You are previewing PeopleSoft Developer’s Guide for PeopleTools & PeopleCode.
O'Reilly logo
PeopleSoft Developer’s Guide for PeopleTools & PeopleCode

Book Description

Design and Deliver PeopleSoft Enterprise Resource Planning Solutions Develop data-driven Oracle PeopleSoft applications and business intelligence reports with help from the expert advice in this Oracle Press guide. PeopleSoft Developer’s Guide for PeopleTools & PeopleCode shows you how to build and enhance PeopleSoft modules that maximize return on investment.

Table of Contents

  1. Cover Page
  2. ORACLE™ Oracle Press™
  3. Copyright Page
  4. Contents at a Glance
  5. Contents
  6. ACKNOWLEDGMENTS
  7. INTRODUCTION
  8. PART I Introduction
    1. Oracle Application Lines
    2. PeopleSoft Application Modules
    3. Role of the PeopleSoft Developer
    4. PeopleSoft Vanilla and Modifications
    5. Organization of the PeopleSoft Development Environments
    6. Proper Testing
    7. PeopleSoft Developer’s Guide for PeopleTools and PeopleCode
      1. How This Book Is Organized
      2. How to Use This Book
    8. Fusion: The Next Generation of Application
    9. 1 Application Environment
      1. Outline of PeopleSoft
      2. HR Modules
      3. PeopleSoft Person Model
        1. HCM Business Processes
        2. Absence Management
        3. Benefits Administration
        4. eBenefits
        5. eCompensation
        6. eCompensation Manager Desktop
        7. ePay
        8. Year-End Processing
        9. eProfile and eProfile Manager Desktop
      4. Payroll for North America
        1. Payroll Interface
        2. Payroll Interface for ADP Connection
        3. Pension Administration
        4. Stock Administration
        5. Time and Labor
        6. Workforce Scheduling
        7. Talent Management
        8. Learning Management
        9. Services Procurement
        10. Talent Acquisition Manager
        11. Workforce Administration
      5. Summary
    10. 2 PeopleTools
      1. PeopleSoft Development Architecture
      2. Data Architecture
        1. Internet Connectivity
      3. Middle Tier
        1. Oracle Fusion Middleware
        2. BPEL
        3. Web Application Server
      4. Business Logic Server
      5. Web-Based Application
        1. Internet Application Server
        2. Single Sign-On
        3. Portal
      6. Security
      7. Integration Broker
        1. Application Messaging
        2. Component Interface
        3. Message Monitor
        4. Application Engine
      8. Metadata
      9. Application Designer
        1. Project Workspace
        2. PeopleCode
        3. Component Interfaces
        4. Security Administrator
        5. Configuration Manager
      10. Summary
    11. 3 PeopleSoft Internet Architecture (PIA)
      1. PIA Configuration: An Overview
      2. Understanding How PIA Works
      3. PIA Servers
        1. Database Server
        2. Application Server
        3. Web Server: Oracle Fusion Middleware
      4. Internet Applications to Service-Oriented Applications
      5. Delivered PeopleSoft Components Without Fusion Middleware
        1. Integration Gateway
      6. Summary
  9. PART II PeopleTools Development
    1. 4 PeopleTools Basics
      1. Application Designer
      2. Development Tools That Have Been Around Since the Beginning
        1. PeopleCode
        2. SQR
        3. Application Engine
        4. Meta-SQL
        5. COBOL
      3. Newer Tools
        1. Fusion Middleware Tools
        2. XML Publisher
      4. How to Navigate
      5. Using Application Designer
      6. Projects
        1. Fields
        2. Records
      7. Record Field Properties
        1. Translate Values
        2. Record Types
        3. Pages
        4. Page Action Options
        5. Page Elements
        6. Components
        7. Menus
        8. Roles and Permission Lists
        9. PeopleCode
        10. HTML
        11. Message Catalogs
        12. Query Manager
      8. Summary
    2. 5 PeopleSoft Pages
      1. The Page
      2. Page Controls
        1. Aesthetic Controls
        2. Data Entry Controls
        3. Function and Data Processing Controls
      3. Understanding Component Buffer Structure and Contents
        1. Secondary Page
        2. Customizing an Existing Page
        3. Creating a New Page
        4. Additional Steps
      4. Summary
    3. 6 PeopleCode
      1. Basic Language Syntax and Structure
        1. PeopleCode Editor
        2. Events and Code Placement
        3. PeopleCode Event Summary
        4. PeopleTools Menus
      2. Debugging and Message Functions
        1. Message Catalog
      3. Syntax
        1. Declaring Variables
        2. Scope
        3. Logic Statements
        4. Documentation with Comments
      4. Summary
    4. 7 Advanced PeopleCode
      1. Objects and Classes
        1. Classes
        2. Objects
        3. Object Instantiation
      2. Understand the Component Buffer
      3. Understand the Component Processor
        1. How Application Engine Fires off PeopleCode
      4. Methods
        1. SQL Objects
        2. Records
        3. Standalone RowSets
      5. Functions
      6. Application Packages
        1. How to Create Application Packages
        2. Application Package Editor
        3. Application Package Classes
      7. Creating Pagelets and iScript
        1. GetJavaScriptURL
      8. Charts
        1. Important Terms
        2. iScripts and Charts
        3. IsDrillable
        4. iScript Security
      9. WSDL Bindings for Component Interface
        1. Sample SOAP Message
      10. Component Interface–Based Web Services
      11. Working with the Pagelet Wizard
      12. Automating SaveAs Functionality
      13. Summary
  10. PART III Other Application Development Tools
    1. Newer Tools
    2. Fusion Middleware Tools
    3. XML Publisher
    4. Query Tool
    5. SQR
    6. Application Engine
      1. Meta-SQL
      2. Customization Tricks
      3. Smarter Ways to Work
    7. 8 XML Publisher
      1. Basics of XML
        1. SOAP
      2. XMLP for PeopleSoft Overview
      3. XML Publisher Security
      4. Setting Up XML Publisher in PeopleSoft
        1. Pages Used
        2. Global Engine Settings
        3. Report Categories
        4. Template Design Helpers
      5. XML Report Publisher
        1. Create Data Source
        2. Register Data Source
        3. Create Templates
        4. Subtemplates
        5. Template Translations
        6. Report Templates
        7. Defining Reports
        8. Output Options
        9. Report Scheduler with Bursting Options
        10. Running XML Reports
        11. Using XML and Email
        12. Integration Broker
        13. XML Files with SqlDev
      6. What We Have Learned
      7. Summary
    8. 9 PeopleSoft Query
      1. Query Security
        1. Creating Access Group Trees
        2. Permissions
      2. Query Process Overview
        1. Query Types
        2. Query Steps
        3. Links and Icons Within Query Manager
      3. Creating New Queries
        1. Selecting Records
        2. Fields
        3. Expressions
        4. Prompts
        5. Criteria
        6. Saving
        7. Previewing
      4. Advanced
        1. View SQL
        2. Subquery
        3. Having
        4. New Union
      5. Scheduling
      6. Query Viewer
      7. Query Tables
      8. Summary
    9. 10 Structured Query Reporting
      1. SQR Basics
        1. Editors
        2. Processing
      2. Program Structure
        1. Program or Report
        2. Setup
        3. Heading
        4. Footing
        5. Procedures
      3. Variables and Commands
        1. Data Types
        2. Output File Type
        3. Reserved Variables
        4. PeopleSoft Variables
        5. System Variables
        6. Declare-Variable
        7. Substitution Variables
        8. Move and Let Commands
        9. Display and Show Commands
      4. SQR Program Commands
        1. Comments
        2. DO Command
        3. IF Command
        4. EVALUATE Command
        5. WHILE LOOP Command
        6. BREAK Command
        7. EXIT-SELECT Command
        8. GOTO Command
        9. STOP Command
      5. Delivered Formatting Commands and Functions
        1. STRING Function
        2. SUBSTR and UNSTRING Functions
        3. LENGTH Function
        4. EDIT Functions
        5. RTRIM and LTRIM Functions
        6. RPAD and LPAD Functions
        7. UPPERCASE and LOWERCASE Commands
        8. TO_CHAR Function
        9. TO_NUMBER Function
        10. Basic Arithmetic
        11. Arithmetic Functions
        12. ROUND Function
        13. TRUNC Function
        14. ISNULL and ISBLANk Functions
        15. STRTODATE Function
        16. DATETOSTR Function
        17. DATENOW Function
        18. DATEADD Function
        19. DATEDIFF Function
        20. SQR Arrays
      6. Printing
        1. Format Options
        2. ON-BREAK
        3. EDIT-MASK
      7. Graphics
        1. DECLARE-CHART
        2. PRINT-CHART
        3. DECLARE-IMAGE
        4. PRINT-IMAGE
      8. Structured Query Language
        1. BEGIN-SELECT
        2. BEGIN-SQL
        3. Effective Dated Rows
        4. Dynamic Query Variables
      9. Running an SQR
        1. Running SQR from a Bat File
        2. Running SQR Through the Process Scheduler
        3. Running SQR from PeopleCode
      10. Using SQC Files
      11. File Functions
        1. CLOSE
        2. DELETE
        3. EXISTS
        4. OPEN
        5. READ
        6. RENAME
        7. WRITE
      12. Compiler Functions
        1. #DEBUG
        2. #DEFINE
        3. Compile Directive
        4. #INCLUDE
      13. HTML
      14. Sample Programs
      15. Summary
    10. 11 Application Engine
      1. History
      2. Application Engine vs. SQR
      3. Application Engine
        1. Program Structure
        2. Properties
      4. Action Types
        1. Do When
        2. Do While
        3. Do Select
        4. PeopleCode
        5. SQL
        6. Call Section
        7. Log Message
        8. Do Until
        9. XSLT
      5. Running Application Engine Programs
        1. Process Definition
        2. Using a Batch File
      6. Meta-SQL and Meta Variables
        1. %AsofDate
        2. %Bind (Only Used in AE Programs)
        3. %Concat
        4. %CurrentDateIn
        5. %CurrentDateOut
        6. %Date
        7. %DateIn
        8. %DateOut
        9. %DateAdd
        10. %DateDiff
        11. %InsertSelect
        12. %OperatorId
        13. %ReturnCode
        14. %Round
        15. %RunControl
        16. %Select (Only Used in AE Programs)
        17. %SelectAll
        18. %SelectInit (Only Used in AE Programs)
        19. %Substring
        20. %Table (Only Used in AE Programs)
        21. %Truncate
        22. %Upper
      7. Printing Application Engine Programs
      8. Advanced Coding Within the App Engine
        1. Using E-Mail
        2. Input and Output Files
        3. Reading Records
      9. Sample Programs
        1. Inserting Records
        2. Writing a File
      10. Summary
    11. 12 Tips and Tricks
      1. Quick Answer Web Sites
        1. Metadata Tips
        2. XLAT Changes in 8.9
        3. Security Overview of Primary Table Relations
        4. PIA Tips
        5. Creating a Graph on a Page
        6. Translate Values
        7. Record Naming Conventions
      2. SQL and PL/SQL
        1. SELECT
        2. ORDER Data on Your SELECT
        3. Joins
        4. Group By and Having
        5. Special Set Operators
        6. System Catalog
      3. External Content References
      4. Application Engine E-Mail
      5. Summary
  11. PART IV Appendixes
    1. A PL/SQL in PeopleSoft
      1. PL/SQL
        1. PeopleSoft Available Options
        2. PL/SQL (Procedural Language SQL)
        3. Compile Environment
        4. SQL Statement Executor
        5. Precompiled
        6. Errors
      2. Syntax
        1. Anonymous PL/SQL Blocks
        2. SQR
    2. B COBOL in Peoplesoft
      1. COBOL
      2. Debugging in COBOL
        1. SQL in COBOL
        2. PTPSQLRT Module
        3. Passing Parameters to PTPSQLRT
        4. SQLRT
        5. Cursors
        6. SQL Statement Name
        7. Bind
        8. SELECT
      3. Setup Lists
      4. Action
      5. Modifications
      6. Summary
    3. C References
      1. Chapter 1
      2. Chapter 2
      3. Chapter 3
      4. Chapter 4
      5. Chapter 5
      6. Chapter 6
      7. Chapter 7
      8. Chapter 8
      9. Chapter 9
      10. Chapter 10
      11. Chapter 11
      12. Chapter 12
      13. Appendix A
      14. Appendix B
  12. Index