krishnamraju

<xsl:value-of select='format-number(SSR_TOT_EN_GRDPTS, "0.000")'/>

REM ***********************************************Modification Summary******; REM SL.No Developer     Mod. No.   Date      Changes REM ----- -----------    ---------- ---------- ------------------------------------------- REM************************************************************************; &str_WhereClause = ""; &str_NoAddnlClause = "N"; /* Clause for acad org */ If (LAC_CSG_RPT_AET.ACAD_ORG.Value <> " ") Then    &str_WhereClause = " A.ACAD_ORG = '" | LAC_CSG_RPT_AET.ACAD_ORG.Value | "' ";    &str_NoAddnlClause = "Y"; End-If; /* Clause for Subject */ If All(LAC_CSG_RPT_AET.SUBJECT.Value) Then    If &str_NoAddnlClause = "Y" Then       &str_WhereClause = &str_WhereClause | " AND A.SUBJECT = '" | LAC_CSG_RPT_AET.SUBJECT.Value | "' ";    Else       &str_WhereClause = "  A.SUBJECT = '...

Application Engine 1.It is a People Tool  and It is used to develop batch programs or online programs that perform the backed processing against the data. 2.It consists of the 2 distinct components .They are Designer->Consists of the batch programs. Run time Environment->To run and monitor the programs. 3.A program is a set of SQL statements. 4.It does not generate SQL or PeopleCode, but it executes SQL or PeopleCode as a part of program. 5.It is designed for batch processing where data must be processed without user interaction. 6.AE resides on database server. APPLICATION ENGINE PROGRAM ELEMENTS: ====================================== 1.PS AE consists a set of processes to execute a given task and made up of several elements.They are i)  Sections It is a set of ordered steps that gets executed as a part of the program.The execution of the program starts with the section defined as MAIN. ii)  Steps Steps are the smallest unit of the program that can be commi...

Save Project Peoplecode into file: If you want to save the entire peoplecode of your project you can do it through application designer. Bellow are the steps to save peoplecode to file. In application designer 1.Go to Edit->Find In option. 2.Enter find character as semicolon(;) and select your project. 3.Check the Save PeopleCode to file option. 4.Click Find button it will ask a file name. 5.Provide the file name and location where you want to save the file. Then the peoplecode of your project stored into file.

Add Drop-down values through peoplecode /* Get the field reference into &field variable */ &field = GetRecord(Record.CH_EMPTYPE).GetField(Field.CH_EMPMAIN); /* Delete all the values from dropdown list */ &field.cleardropdownlist(); /* Add values to the dropdown list */ &field.adddropdownitem(Descr, Value);    [Value]: It is actual value which is mapped to the dropdown item    [Descr]: It is actual text which is visible as a dropdown item Examples: &field.adddropdownitem("A", "A"); &field.adddropdownitem("B", "B"); &field.adddropdownitem("C", "C");

PeopleCode for disable the row delete option in scroll and grid For &i = 1 To &Asmfloor.ActiveRowCount    &Asmwing = &Asmfloor(&i).GetRowset(Scroll.ASM_WING_TBL);    For &j = 1 To &Asmwing.ActiveRowCount       &Asmcabin = &Asmwing(&j).GetRowset(Scroll.ASM_CABIN_TBL);           If &Asmcabin.ActiveRowCount = 1 Then          &Asmwing.DeleteEnabled = True; /* to enable the row delete option */          If &Asmwing.ActiveRowCount = 1 Then             &Asmfloor.DeleteEnabled = True;          Else             &Asmfloor.DeleteEnabled = False; /* to disable the row delete option */          End-If;          rem &Asmfloor.DeleteEnabled = True;   ...

PeopleCode to find special characters in file other than ASCII characters Local string &File_path, &File_path1; &File_path = "C:\temp\ascii.xml"; &bud_rep = GetFile(&File_path, "r", %FilePath_Absolute); &File_path1 = "C:\temp\ascii_1.txt"; &bud_rep1 = GetFile(&File_path1, "a", %FilePath_Absolute); &count = 0; While &bud_rep.readline(&line)    &line1 = Len(&line);    &count = &count + 1;    For &i = 1 To &line1       &char = Substring(&line, &i, 1);       &naciichar = Code(&char); /* returns the number corresponds to character */       /* check whether the character is in the range of ascii char's or not */       If &naciichar >= 128 Or             &naciichar < 0 Then          &bud_rep1.writeline(&coun...

PeopleSoft : Changing table space of a record. If you want to assign a record to the new table space that you created open your record, and go to Tools --> Data Administration --> Set Table space. then you can assign new table space to record.

We can use the below XML Tag, to get the rows conditionally. <?for-each:DISTRICT[CRSE_ATTR_VALUE = '5' and RESIDENT = 'Y']?> <?end for-each?>

Basic HRMS Setup's and adding the Benefits to the Employee Setup Create SETID Navigation: Main Menu ->PeopleTools ->Utilities ->Administration ->Tableset ID's Create Business Unit Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Business Unit Setup Location: Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Location Add a company Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Company Create an Establishment ID Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Establishment Create Departments Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Departments Setting the Business Unit options default Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organization ->Business Unit options default (Enter the company and Country details) Create a pay Gro...

/********************************************************************************* Descr: The Below code is used to populate the grid. Developer: Krishnam Raju Nadimpalli *********************************************************************************/ Component Rowset &Level0, &Act_Log; Component Row &Level0_Row; &Level0 = GetLevel0(); &Level0_Row = &Level0(1); &Act_Log = &Level0_Row.GetRowset(Scroll.LAC_WS_ACT_LOG); &Act_Log.Flush(); &str_WhereClause = ""; &str_NoAddnlClause = "N"; /* Clause for emplid*/ If All(LAC_WS_DERIVED.EMPLID.Value) Then    &str_WhereClause = " EMPLID = " | Quote(LAC_WS_DERIVED.EMPLID.Value);    &str_NoAddnlClause = "Y"; End-If; /* Clause for Status */ If All(LAC_WS_DERIVED.LAC_WS_STATUS.Value) Then    If &str_NoAddnlClause = "Y" Then       &str_WhereClause = &str_WhereClause | " AND LAC_WS_STATUS = " | Quote(L...

Generating the XML Publisher Report from Scratch:          Full Program :            Main Section :          Truncate:         Truncate SQL Code:         INIT Code:        Do Select:           Insert into staging table and updating the staging table:               Prepare and generate the report:                    XMLGEN code: REM ****************************************Modification Summary ******************************************; REM SL.No                   Developer       ...