PeopleSoft PeopleCode Training

PeopleSoft PeopleCode Training

PeopleSoft Applications are built using PeopleCode as the main language.

We will train you in PeopleCode with an objective to make you understand the PeopleCode Write, edit, and debug PeopleCode programs for customizing/modifying PeopleSoft Applications.

• Integrate PeopleCode with the component processor event flow.
• Use PeopleCode to validate data and control program flow.
• Manipulate data in the component buffer and in SQL tables.
• Program with object-oriented PeopleCode.
• Create and manage application packages.
• Create a graphical representation of data using Charts.

Duration: 7 Days

Who can attend:

• Technical Consultant
• System Analysts
• Developer
• Application Developers

Required knowledge to understand this course:

• Programming experience, preferably in an object-oriented language.
• PeopleSoft Application Designer

Course Objectives:

• Use the PeopleCode development tools to write, edit, and debug PeopleCode programs
• Choose the events in which to place PeopleCode
• Program with object-oriented PeopleCode
• Manipulate data in the component buffer
• Manipulate data in the data buffers and in SQL tables

Topics:

Using PeopleCode Development Tools

• The Eight Steps of PeopleSoft Application Development
• Locating PeopleCode Programs
• Using the PeopleCode Editor
• Using the PeopleCode Debugger
• Other Development Tools

Describing the Component Processor

• Events in the Component Processor Flow
• Search Events
• Component Build Events
• Field Action Events
• Row Action Events
• Save Action Events
• Add Mode Processing
• Deferred Processing

Writing PeopleCode Programs

• Writing PeopleCode Statements
• Conditional Statements
• Looping Statements

Understanding PeopleCode Events

• PeopleCode in Search Events
• PeopleCode in Component Build Events
• PeopleCode in Field Action Events
• PeopleCode in Row Action Events
• PeopleCode in Save Action Events

Using PeopleCode Variables

• Creating User-Defined PeopleCode Variables
• Using System Variables
• Incorporating Derived/Work Fields into PeopleSoft Applications
• Explaining Variable Prompt Tables

Using Built-In Functions

• Types of Built-In Functions
• Message Catalog Functions
• All, None, and Prior Value Functions
• String Functions
• Other Built-In Functions
• Reserved Words

Writing PeopleCode Functions

• Writing External PeopleCode Functions
• Declaring a PeopleCode Function
• Calling PeopleCode Functions
• Writing Functions Using Parameters
• Writing Functions Using the Returns Argument

Explaining the Component Buffer

• Occurs Levels
• Determining Buffer Allocation
• Determining the Order of Execution of PeopleCode Programs

Accessing Data in the Component Buffer

• Processing Rows Using Loops
• Using Fetch Value and Update Value
• Accessing Data with Multiple Occurs Levels

Programming With Object-Oriented PeopleCode

• Object-Oriented Terms
• Instantiating Objects
• Referencing Object Properties by Using Dot Notation
• Calling Object Methods by Using Dot Notation
• Explaining Passing by Reference
• Using Object-Oriented Methods and Properties
• Using Arrays

Referencing Data in the Component Buffer

• The Data Buffer Classes
• Instantiating the Buffer Access Classes
• Using Current Context
• Traversing the Data Buffer
• Using Shorthand Dot Notation
• Traversing the Data Buffer with Multiple Scroll Levels

Creating Custom Objects with Application Classes

• Application Classes
• Organizing Application Classes Using Application Packages
• Using the Application Class Editor
• Application Class Structure
• Calling Application Classes
• Passing Parameters to Application Classes

Using Data Buffer Methods

• Using the Sort Method
• Using the Select Method
• Using Flush
• Working With Standalone Rowsets
• More Buffer Methods

Executing SQL in PeopleCode

• Writing SQL Exec Statements
• Creating SQL Definitions
• Using the SQL Class
• Executing SQL Using Record Objects
• Incorporating Meta-SQL in PeopleCode and SQL
• Searching PeopleCode for Potential SQL Injection