Search Results cp_set_p

Overview

PSB_PSBRPPAL_XMLP_PKG is a generated Oracle Reports PL/SQL library package owned by the APPS schema in Oracle E-Business Suite. Its naming convention follows the standard Oracle Reports XML Publisher integration pattern: the PSB_PSBRPPAL component denotes a Public Sector Budgeting (PSB) report—specifically the budget group/position alignment report—while the _XMLP_PKG suffix indicates that the report was converted to use the XML Publisher (BI Publisher) engine rather than the legacy character-mode or PostScript output formats. The package itself is not a functional business API; it is an auto-generated report trigger container whose procedures and functions are invoked by the Oracle Reports runtime as the report executes.

The package encapsulates the Before Report, After Report, Before Parameter Form, After Parameter Form, and Between Pages triggers, along with the format trigger logic for each repeating group defined in the report layout. As a result, it governs report-level behavior such as initialization of global variables, parameter handling, conditional formatting of report sections, and the messages emitted when no data is found or when the report reaches its end.

Key Procedures and Functions

• BEFOREREPORT — Executes prior to the main report query; responsible for one-time initialization of report state.
• AFTERREPORT — Executes after the report query completes; performs cleanup or finalization logic.
• BEFOREPFORM — Fires before the Oracle Reports parameter form is displayed; used to prepare or default parameter values.
• AFTERPFORM — Fires after the parameter form is submitted; used to validate or transform user-entered parameters.
• BETWEENPAGE — Executes between report pages; supports page-level logic such as header/footer control.
• M_SET_GRPFRFORMATTRIGGER — Format trigger for the master set/group frame, controlling whether that layout section is rendered based on the current record count.
• M_1FORMATTRIGGER — Format trigger for master group level 1; the specific function the user searched for. It determines whether the level-1 master record section is displayed, receiving the current detail record count as input.
• F_1FORMATTRIGGER and F_2FORMATTRIGGER — Format triggers for the first and second formatting groups; each evaluates the record count to decide section visibility.
• P_CONC_REQUEST_ID_P, CP_SOB_P, CP_BGP_P, CP_SET_P, CP_NLS_NO_DATA_EXISTS_P, CP_NLS_END_OF_REPORT_P — Getter functions exposing the concurrent request ID, the set of books, budget group, set identifiers, and the NLS-dependent "no data exists" and "end of report" message strings declared as package globals.

Tables Accessed

The package references the PSB_BUDGET_GROUPS table through an APPS synonym. This table stores the definition of budget groups used within Public Sector Budgeting and is read to drive the report's grouping and filtering logic. No other tables are documented as being accessed directly by this package; the bulk of reporting data is retrieved through the associated Oracle Reports query, not through direct DML in the package body.

Usage Notes

PSB_PSBRPPAL_XMLP_PKG is invoked exclusively by the Oracle Reports runtime when the PSB_PSBRPPAL report is executed, typically from the Concurrent Programs interface or from a Public Sector Budgeting form that launches the report programmatically. Custom code should not call these functions directly, as their parameters and ordering are dictated by the report definition and may change on regeneration. The CP_ and P_ getters are the only safe integration points for external callers. Because the package is regenerated from the .rdf source, customers should place extensions in a separate custom package rather than modifying this object, ensuring they remain upgrade-safe across 12.1.1 and 12.2.2.