PeopleSoft PeopleCode Rel 8.50

Course Description

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.

Skills Gained

• 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

Who Can Benefit

• Application Developers
• Developer
• System Analysts
• Technical Consultant

Prerequisites

• Programming experience, preferably in an object-oriented language.
• Experience configuring and customizing applications
• Working knowledge of PeopleTools
• Comfortable with parent/child relationships in PeopleSoft

Syllabus

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