How to Insert row in PeopleCode?

When inserting rows using PeopleCode, you can either use the Insert method with a record object or create a SQL Insert statement using the SQL object. If you do a single insert, use the Record Insert method. If you are in a loop and,therefore, calling the insert more than once, use the SQL object.

What are PeopleCode events?

This event is often used to hide or unhide pages. It is also used to set component variables. Note: If a PreBuild PeopleCode program issues an error or warning, the user is returned to the search page. If the search record has no keys, a blank component page appears.

What are three standard system edits that the component processor performs on a field?

The Component Processor performs standard system edits….Field Modification.

System Edits	Location of Execution
Prompt table	Application server
Translate table	Browser

What is Oracle PeopleCode?

PeopleCode is the proprietary language used by PeopleSoft applications. This chapter provides an overview of PeopleCode and discusses how to create PeopleCode programs. These topics provide information to consider before you begin to use PeopleCode.

How do you populate a grid in Peoplesoft?

The grid is placed on level 1 of a secondary page and is populated using Peoplecode written in the Activate event of the secondary page. We use the SQL object &VCHRS_GRD_SQL to fetch some Voucher IDs and Vendor IDs from the database and populate the grid with these values.

How do I delete a row from the grid in Peoplesoft?

If you are using PeopleCode to populate the data then there should be a loop that will populate the gird data fields. You can use the InsertRow() and DeleteRow() on the gird to control the rows that are being inserted or deleted.

What is PeopleSoft think time function?

Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box) or until an external process has run to completion (for example, a remote process). Avoid think-time functions in the following PeopleCode events: SavePreChange.

What is PeopleSoft component interface?

A component interface enables exposure of a PeopleSoft component (a set of pages grouped together for a business purpose) for synchronous access from another application (such as PeopleCode, Java, C/C++, COM, or XML).

Which PeopleCode statement should you use to instantiate a row object for the current row?

The GetRowset method creates a rowset object that references a child rowset of the current row. scrollname must specify the primary record for the child rowset. Specify a rowset to be used for instantiating the rowset object. You can specify either n or SCROLL.

What is the difference between component buffer and data buffer?

Component buffer contains data of the currently active component. Data buffer contains the data of the currently active peoplesoft application it can be from a component, an application engine or application message. If the level 0 rowset is formed from a component buffer data the level 0 contains only one row of data.

What is PeopleCode program?

PeopleCode is a proprietary object-oriented programming language used to express business logic for PeopleSoft applications. Syntactically, PeopleCode is similar to other programming languages, and can be found in both loosely-typed and strongly-typed forms.

Is PeopleCode similar to Java?

Dot notation, classes, and methods in PeopleCode are similar to other object-oriented languages, like Java.

What is Rowset in PeopleSoft?

In an Application Engine program, a rowset object is the equivalent of a record object that contains one row and a single record, that is, the State Record. PeopleSoft suggests using the Record object instead of a rowset object to obtain access to the State Record.

Which PeopleCode statement would you use to instantiate a row object for the current row?

How do you populate a grid in PeopleSoft?

How do I find the current row number in PeopleSoft?

Use currentrownumber(scrolllevel); This will give you current row number.

How do I access component buffer in PeopleCode?

To access the same field in the component buffer, PeopleCode must:

1. Specify a scroll area and row on scroll level one: this selects a subset of dependent rows on level two.
2. Specify a scroll area and row on scroll level two.
3. Specify the recordname. fieldname on the level two row.

What are the options to access data in the component buffer from within PeopleCode?

Access Classes The four data buffer classes are: Rowset, Row, Record, and Field. These four classes are the foundation for accessing component buffer data through the new object syntax.

What is a rowset in PeopleSoft?

How do I use a component interface in PeopleSoft?

Configuring Component Interface Security for PeopleSoft Version 8.1x

1. From the Use menu, select Permission Lists, Component Interface, and then click Update/Display.
2. Select the relevant permission list and click OK.
3. Insert the new component interface that you created.
4. Click Edit.
5. Select the desired level of access.

How do I insert a row in PeopleCode?

When inserting rows using PeopleCode, you can either use the Insert method with a record object or create a SQL Insert statement using the SQL object. If you do a single insert, use the Record Insert method. If you are in a loop and,therefore, calling the insert more than once, use the SQL object.

How does the rowdelete event trigger PeopleCode?

The RowDelete event triggers PeopleCode on any field on the row of data that is being flagged as deleted. RowDelete does not trigger PeopleCode on derived/work fields. RowDelete PeopleCode can be associated with record fields and component records. When the last row of a scroll area is deleted, a new, dummy row is automatically added.

What is the use of rowselect PeopleCode?

RowSelect PeopleCode is used to filter out rows of data as they are being read into the component buffer. This event also occurs after a ScrollSelect or related function is executed.

How do I add PeopleCode to the search init and searchsave events?

Beginning with PeopleTools 8.50, you can put PeopleCode on the SearchInit and SearchSave events on the search keys of prompt table records. SearchInit and SearchSave events will only execute if the Allow Search Events for Prompt Dialogs checkbox is selected for the search key’s record field properties in Application Designer.