Application Engine is a Development PeopleTool designed to create applications, these applications are used to perform the background SQL process, means we can develop, test, and run background SQL processing programs. It is a set of SQL statements people code and program control actions defined in A.D that performs the business process.
This chapter discusses:
- PeopleSoft Application Engine Fundamentals.
- Meta-Structured Query Language (SQL).
- Application Engine program elements.
- Application Engine program types.
PeopleSoft Application Engine Fundamentals:
- In PeopleSoft Application Engine, a program is a set of SQL statements, PeopleCode, and program control actions that enable looping and conditional logic.
- A program is defined in PeopleSoft Application Designer and performs a business process.
- We can use PeopleSoft Application Engine for straight, row-by-row processing, but the most efficient Application Engine programs are written to perform set-based processing.
- PeopleSoft Application Engine is designed for batch processing where you have data that must be processed without user intervention—for example, calculating salaries in payroll processing
Meta-Structured Query Language (SQL)
It supports the meta-SQL so that we can make the program platform independent that is RDBMS independent. By using Meta SQL we can generate portions of SQL statements.
Application Engine program elements.
A PeopleSoft Application Engine program comprises the set of processes to execute a given task, and is made up of several key elements:
Sections: A section is a set of ordered steps that gets executed as part of a program. You can call sections (and other programs) from steps within other sections.
Steps: Steps are the smallest unit of work that can be committed to a program. Although you can use a step to execute a PeopleCode command or log a message, typically you use a step to execute a SQL statement or to call another section.
Actions: It is common to have multiple actions associated with a single step.
- Do When
- Do while
- Do select
- SQL \ call section
- People code
- Log message
- Do until
State records: A state record is a PeopleSoft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one action to another.
An Application Engine state record can be either a physical record or a work record, and any number of state records can be associated with a program. Physical state records must be keyed by a process instance.
Application Engine program types.
There are five types of Application Engine programs. You specify the type in the Program Properties dialog box for your program definition. The types are:
- Standard, which is a normal entry-point program.
- Upgrade Only, which is used in PeopleSoft upgrade utilities.
- Import Only, which is used by PeopleSoft import utilities.
- Daemon Only, a type of program used as a daemon process.
- Transform Only, a program type used to support Extensible Stylesheet Language Transformations (XSLT).
No comments:
Post a Comment