PeopleSoft PeopleCode Ed 1

Module 1: Course Introduction

• Lesson 1: Course Overview
• Agenda
• Lesson 2: Technology Overview
• Describing PeopleCode
• How PeopleCode Is Used
• Where PeopleCode Is Used
• Finding PeopleCode Information in PeopleSoft Online Help
• PeopleCode Syntax Conventions

Module 2: PeopleCode Development Tools

• Lesson 3: Using PeopleCode Development Tools
• PeopleSoft Application Development Steps
• Activity 1: Reviewing the PeopleSoft Application Development Process
• Locating PeopleCode Programs
• Using the PeopleCode Editor
• Activity 2: Using the PeopleCode Editor
• Using the PeopleCode Debugger
• Activity 3: Debugging PeopleCode Programs
• Additional Development Tools

Module 3: Component Processor and PeopleCode Events

• Lesson 4: Understanding the Component Processor and PeopleCode Events
• Tracing Component Processor Flow
• Identifying PeopleCode Events
• Search Events
• Activity 4: Using SearchInit to Control the Search Page
• Activity 5: Placing WinMessage in Search Events
• Component Build and Page Display Events
• Activity 6: Placing WinMessage in Component Build Events
• Field Action Events
• Row Action Events
• Activity 7: Placing WinMessage in Row Action Events
• Save Action Events
• Activity 8: Placing WinMessage in Save Action Events
• Add Mode Processing
• Other Processing Flows
• Deferred Processing
• Activity 9: Examining Deferred Processing
• Synchronization Programs

Activity 10: Reviewing Programs That Synchronize Student Addresses with Customer Addresses

Module 4: Writing PeopleCode Programs

• Lesson 5: Writing PeopleCode Programs
• Writing Statements, Conditional Statements, and Loops
• Activity 11: Selecting Correct PeopleCode Events for Error Messages
• Lesson 6: Using PeopleCode Variables
• User-Defined Variables
• System Variables
• Derived/Work Fields
• Activity 12: Calculating and Displaying Derived Values
• Contextual Prompt Table Edits
• Activity 13: Reviewing Setup for Contextual Prompt Table Edits
• Lesson 7: Using PeopleCode Built-In Functions
• Types of Built-In Functions
• Message Catalog Functions
• All, None, and PriorValue Functions
• String Functions
• Fluid Application Functions
• Reserved Words
• Activity 14: Using PeopleCode Built-In Functions
• Lesson 8: Writing User-Defined Functions
• External User-Defined Functions
• Declaring and Calling Functions
• Using Parameters and Returns Clause
• Activity 15: Writing User-Defined Functions

Module 5: Component Buffer Concepts

• Lesson 9: Explaining the Component Buffer
• Occurs Levels
• Component Buffer Allocation
• Execution Order of PeopleCode Programs
• Activity 16: Determining the of the Component Buffer
• Lesson 10: Using Legacy Techniques to Access Component Buffer Data
• Loops to Process Rows
• FetchValue and UpdateValue Functions
• Accessing Data Across Multiple Occurs Levels

Module 6: Object-Oriented PeopleCode

• Lesson 11: Programming With Object-Oriented PeopleCode
• Object-Oriented Terms
• Instantiating Objects
• Dot Notation for Properties and Methods
• Passing Objects by Reference
• Component Buffer Classes Methods
• Activity 17: Using Methods and Properties of the Field Class
• Lesson 12: Referencing Data in the Component Buffer
• Component Buffer Classes
• Current Context
• Traversing the Component Buffer
• Activity 18: Traversing Objects and Data in the Component Buffer
• Shorthand Dot Notation
• Activity 19: Looping Through Data in a Rowset
• Traversing Multiple Occurs Levels
• Activity 20: Modifying Objects at Multiple Occurs Levels
• Lesson 13: Using Additional Component Buffer Methods
• Rowset Sort, Select, and Flush Methods
• Standalone Rowsets
• Activity 21: Using the Select Method to Display Enrollments
• Activity 22: Flushing Data from a Rowset
• Activity 23: Using a Standalone Rowset to Calculate Effort Spent

Module 7: Application Classes

• Lesson 14: Creating and Using Application Classes
• Application Classes and Packages
• PeopleCode Editor for Classes
• Class Structure and Usage
• Activity 24: Creating and Using an Application Class
• Passing Parameters to Methods
• Activity 25: Passing Method Parameters by Value
• Activity 26: Passing Method Parameters by Reference
• Lesson 15: Extending and Implementing Base Classes
• Base Classes and Subclasses
• Abstract Methods and Properties
• Interface Classes
• Activity 27: Extending a Built-in Class

Module 8: Executing SQL in PeopleCode

• Lesson 16: Executing SQL in PeopleCode
• SQLExec Statements
• Activity 28: Updating Effort Spent with SQLExec
• SQL Definitions
• Activity 29: Updating Effort Spent with SQL Definition
• SQL Class and Objects
• Activity 30: Updating Effort Spent Using SQL Object
• Meta-SQL
• Record Objects
• Activity 31: Choosing the Best SQL Option
• Activity 32: Using Object-Oriented Techniques to Execute SQL

Module 9: Charting and Reporting

• Lesson 17: Using PeopleCode to Create Charts
• PeopleCode Charting Classes
• Chart Elements
• Creating Charts
• Activity 33: Creating a Bar Chart

Module 10: Course Workshop and Review

• Lesson 18: Course Workshop
• Activity 34: Using a Standalone Rowset to Track Overtime Hours
• Lesson 19: Course Review
• PeopleCode Concepts
• Development Tools
• Component Processor Events
• Writing PeopleCode Programs
• Component Buffer Manipulation
• Object-Oriented PeopleCode
• Application Classes
• Executing SQL
• Appendices
• Appendix A: Course Workshop Solution
• Appendix B: Navigating in PeopleSoft Applications
• Fluid Banner, Action List, NavBar, Navigator Menu, Global Search
• Appendix C: Activity Solutions and Alternate Solutions
• Appendix D: Component Processor Flow
• Appendix E: Component Buffer Classes and SQL Class Quick Reference