Understanding the AESection Class
Before PeopleTools 8, users could perform SQL directly on the Application Engine tables, thereby changing their SQL and Application Engine "flow" in a dynamic manner, prior to running their applications. Some applications, for example, let the user input their "rules" in a user-friendly application, then convert these rules, at save time, into Application Engine constructs.
With PeopleTools 8, Application Engine programs should not perform SQL directly on the Application Engine tables, as they are system tables, and are cached. SQL on the Application Engine tables may not be accurately reflected when the applications are executed, because of the caching mechanism.
To overcome this problem, developers have two basic operations that let them modify their Application Engine programs from their online pages:
Ability to modify SQL definitions, which are referenced within Application Engine SQL using the PeopleCode SQL class and the meta-SQL function %SQL.
Ability to dynamically change the execution flow of a given Application Engine section.
Use the AESection class to do the latter. This section object is used to modify the steps and SQL associated with a given section by using PeopleCode.
Before describing the specifics of the AESection class, the following are some general terms to understand:
The base section represents the Application Engine section you are working on. This is the section that you are changing in PeopleCode. In other words, it’s the target section.
The template section represents the Application Engine section that is the source, or "model" for the section you're building. You copy from the template section to the base section.
The template must exist in the database before you can use it.
If the base section you specify doesn’t exist, a new base section is created. This enables you to dynamically create sections as needed.
You can copy steps (and their attributes) from the template to the base. The only attribute of the step you can modify is the SQL statement that gets executed.
Warning! When you open or get an AESection object, (that is, the base section) any existing steps in the section are deleted. You must add a new step to the section before you can modify it.
The main assumption for this class is that your rules are dynamic primarily in the SQL that they execute, but that the structure of the rules are static, or at least defined well enough that a standard template can be applied.
Note that you can't update the Application Engine actions that are not SQL-related (that is, PeopleCode, Call Section, or Log Message). In other words, you can’t change the PeopleCode associated with a PeopleCode action within a step. You can add a step containing a PeopleCode action to your new section, but you can't change the PeopleCode dynamically.