Search Results p_sort_option_1

Overview

SSP_SSPRPELR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the XML Publisher (BI Publisher) report SSPRPELR. The suffix _XMLP_PKG identifies it as the generated wrapper package that binds an Oracle Reports executable to an XML Publisher data template. The report relates to Oracle Payroll and concerns payroll element results grouped or filtered by consolidation set and time period. Its principal business function is to accept concurrent program parameters entered by the user, resolve descriptive names for those parameters, derive a sort criterion for the report output, and expose that derived value to the XML template through a package global. The package is a report-support object rather than a public business API; it is not intended for direct invocation by other PL/SQL programs.

Key Procedures and Functions

• BeforeReport — The report trigger executed before the report body is generated. It performs parameter initialization and populates the package-level global variables used by the report query and layout.
• P_SORT_OPTIONValidTrigger — The validation trigger bound to the P_SORT_OPTION parameter. It validates the user's selection before the report proceeds.
• AfterReport — The post-report trigger, executed after report output has been produced, used for cleanup and final housekeeping.
• C_BUSINESS_GROUP_NAME_P — Returns the resolved business group name stored in the global C_BUSINESS_GROUP_NAME.
• C_REPORT_SUBTITLE_P — Returns the report subtitle value held in C_REPORT_SUBTITLE.
• C_PAYROLL_NAME_P — Returns the payroll name held in C_PAYROLL_NAME.
• C_CONSOLIDATION_SET_NAME_P — Returns the consolidation set name held in C_CONSOLIDATION_SET_NAME.
• C_TIME_PERIOD_NAME_P — Returns the time period name held in C_TIME_PERIOD_NAME.
• C_SORT_OPTION_P — Returns the resolved sort option value held in C_SORT_OPTION.
• Derive_sort_criteria — Returns a VARCHAR2 expression that translates the user's sort selection into the ordering clause applied by the report.

Tables Accessed

The package reads two documented base tables through APPS synonyms. PAY_CONSOLIDATION_SETS provides the consolidation set definition, supplying the name resolved into C_CONSOLIDATION_SET_NAME and validating the P_CONSOLIDATION_SET parameter. PER_TIME_PERIODS provides the payroll time period definition, supplying the name resolved into C_TIME_PERIOD_NAME and validating P_TIME_PERIOD_ID. Business group, payroll, and sort option names are likewise resolved during BeforeReport. No inserts, updates, or deletes are documented; the package is read-only with respect to these tables.

Usage Notes

The package is invoked by the Oracle Reports/XML Publisher runtime when the SSPRPELR concurrent program is submitted. Users supply parameters including P_BUSINESS_GROUP_ID, P_PAYROLL_ID, P_CONSOLIDATION_SET, P_TIME_PERIOD_ID, and the sort option parameters P_SORT_OPTION and P_SORT_OPTION_1, both declared as VARCHAR2(60). A user searching on "p_sort_option_1" is most likely investigating why a second sort selection exists alongside P_SORT_OPTION; the two parameters support a primary and secondary sort key, with Derive_sort_criteria combining them into the report's ORDER BY logic. The package is referenced by zero other packages, confirming it is a leaf-level report wrapper. Customizations should not modify the package directly; parameter defaults, validation, and sort behaviour are best extended through a copy of the concurrent program definition or a custom XML template.