7/28/2019 Peoplecode_XML.docx

1/5

7/28/2019 Peoplecode_XML.docx

2/5

Search Process of a component in Update mode

(UpdateDisplay/UpdateDisplayall) and Component Build Processingor Page build process in Update/Update Displayallmode

When we click on the component portal in menu then the following below PeopleCode events will fire

Search Process

Record Field SearchInit

ComponentRecord SearchInit

-->Click on Search

Record Field SearchSaveComponentRecord SearchSave

Component Build Process or Page Build processing in Updatedisplay/UpdateDisplayall mode

-->Select the Employee ID from the list then

Record Field RowSelect

ComponentRecord RowSelect

Component Level Prebuild

Record Field FieldFormulaRecord Field RowInit

ComponentRecord RowInit

Component level Postbuild

Page Activate fires and displays the page

When we edit the field (Employee ID) then the following below PeopleCode Events will fire

-->Edit the field (Employee ID) and hit on save then the following peoplecode events will fire

Record Field FieldEdit

ComponentRecordField FieldEdit

Record Field FieldChange

ComponentRecordField FieldChange

Record Field FieldFormula

Save Processing PeopleCode Events:

Record Field SaveEdit

http://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/search-process-of-component-in-update.html

7/28/2019 Peoplecode_XML.docx

3/5

ComponentRecord SaveEdit

Record Field SavePrechange

ComponentRecordField SavePrechange

ComponentLevel SavePrechange

Record Field Workflow

ComponentLevel Workflow

Record Field SavePostchange

ComponentRecordlevel SavePostchange

Component Level SavePostchange

Creating the data Source through PS QUERY (Reporting Tools)

Defining Data source:

1.Click on Reporting Tools.

2.Click on XML Publisher.

3.Click on Data Source.

4.Click on Add a New Value.

5.Select the Data Source type as PS Query.

6.In Data Source ID select ur Query (Ex:HARSHA_QRY)

7.Click on ADD.

8.Enter the Description Name (Ex:Harsha)

9.Selct the Object Owner ID as Human Resource.

10.Click on Save.

Step2: Defining Data Source

11.In the Related Files-->Sample Data File-->Click on Generate

12.In the Related Files-->Schema File-->Click on Generate.

13.Click on Save.

14.Open the XML file and Save As Harsha1_Qry on Desktop.

Step3: Building/Creating Template:

1.Open MS Word.

2.Click On Add-Ins.

3.Click on Template Builder-->Data-->Load XML data.

4.Click on Template Builder-->Insert-->Table/ Form

5.Drag and dorp the Rows in to Template Work sapce and click on All Nodes.

4.Click on Ok.

5.Save the MS Wrod sheet with same name given to the XML(HARSHA_QRY) with RTF

Step4: CLICK ON REPORT DEFINITION

1.Select the Existing saved Report(HARSHA_QRY)

7/28/2019 Peoplecode_XML.docx

4/5

2.In the Object owner Id make it empty.

3.Clickon template tab

4.Change the status to Active.

5.Click on Upload.

6.Selct the Existing Word doc

7.Click on Save.

CLICK ON QUERY REPORT VIEWER

1.In the Query Report Viewer select ur existing report.

2.Click on View Report.

Sample People Code for getting the DEPT ID based on the ORG ID

Sample People Code for getting the DEPT ID based on the ORG ID

Below is the 3 level rowset peoplecode for getting the Department ID prompt values when we select

the Organization ID from prompt table.(i'e when we select the Organization ID from the prompt table

then the departments under the particular Organization should only display)

Local Rowset &RS0, &RS1, &RS2;

&RS0 = GetLevel0();

&RS1 = &RS0(1).GetRowset(Scroll.SRI_ORG1_TBL);

For &I = 1 To &RS1.ActiveRowCount

&ID = &RS1(&I).GetRecord(Record.SRI_ORG1_TBL).GetField(Field.SRI_ORG_ID).Value;

&SQL = CreateSQL("SELECT DESCR FROM PS_EXT_ORG_TBL WHERE EXT_ORG_ID=:1", &ID);

While &SQL.FETCH(&DESCR)

&RS1(&I).GetRecord(Record.SRI_ORG1_TBL).GetField(Field.SRI_ORG1_NAME).Value = &DESCR;

REM WinMessage(&DESCR, 0);

&RS2 = &RS1(&I).GetRowset(Scroll.SRI_DEPT1_TBL);

For &J = 1 To &RS2.ActiveRowCount;&DI = &RS2(&J).GetRecord(Record.SRI_DEPT1_TBL).GetField(Field.SRI_ORG_ID).Value;

&SQL1 = CreateSQL("SELECT ORG_DEPARTMENT FROM PS_ORG_DEPT WHERE EXT_ORG_ID=:1", &DI);

While &SQL1.FETCH(&ORG_DEPARTMENT)

REM SQLEXEC("SELECT COUNT(EMPLID) FROM ");

If &ORG_DEPARTMENT = "" Then

&RS2(&J).GetRecord(Record.SRI_DEPT1_TBL).GetField(Field.SRI_DEPT_ID).Value = "";

WinMessage("There are no Departments under this Organisation ID", 0);

http://hrmspeoplesoft.blogspot.in/2010/05/sample-people-code-for-getting-dept-id.htmlhttp://harshachowdaryworld.blogspot.com/2009/08/sample-people-code-for-getting-dept-id.htmlhttp://harshachowdaryworld.blogspot.com/2009/08/sample-people-code-for-getting-dept-id.htmlhttp://hrmspeoplesoft.blogspot.in/2010/05/sample-people-code-for-getting-dept-id.html

7/28/2019 Peoplecode_XML.docx

5/5

Else

&RS2(&J).GetRecord(Record.SRI_DEPT1_TBL).GetField(Field.SRI_DEPT_ID).Value = "";

rem WinMessage(&ORG_DEPARTMENT, 0);

End-If;

End-While;

End-For;

End-While;

End-For;