Summary

PeopleCode is integrated into every aspect of PeopleSoft applications. This five-day course gives participants the essential tools to work with object-oriented PeopleCode. Participants actively build programming skills in a PeopleSoft environment. The tools and skills learned in this course provide the participants with the structure of PeopleCode and prepare them to move on to more advanced applications.Learn To:Write, edit, and debug PeopleCode programs.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.A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Course Content

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

Additional Information

Audiences

• Application Developers
• Developer
• System Analysts
• Technical Consultant