Search Results cp_sort_by_detail

Overview

PSP_PSPENEXR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the API classification OTHER. It is a generated BI Publisher (XML Publisher) report package associated with the PSP module, specifically the "PSPENEXR" concurrent program, which is part of the Oracle Grants / Public Sector Payroll functionality. The package serves as the runtime engine for a payroll-related XML report, providing the data retrieval, formatting, and layout-suppression logic that the report template consumes.

The core business function is to produce a formatted payroll exception or element-based report, computing derived runtime values—such as payroll names, element names, person names, and assignment numbers—at report execution time. These values are calculated via formula functions that the XML Publisher template calls as data triggers or group-level computations, rather than being resolved by static SQL alone. The package also manages report-level sort and header descriptions dynamically, allowing the report's sort sequence and column headers to adapt to the user's runtime parameter selections.

Key Procedures and Functions

• BEFOREREPORT — Initializes the report and populates package state before the main query executes, including context and global settings used by downstream formula functions.
• CF_PAYROLL_NAMEFORMULA — Resolves the payroll_id supplied at runtime to its display name; this is the "cf_payroll_nameformula" object referenced in the user's search.
• CF_ELEMENT_NAMEFORMULA — Derives the element type name for the given element and effective-date window, accounting for sort options passed in as parameters.
• CF_SORT_DESCRIPTION1FORMULA — Builds the first sort description text shown to the user based on the selected sort options.
• CF_SORT_BY_HEADERFORMULA — Produces the column header text corresponding to the active "sort by" selection.
• CF_PERSON_NAMEFORMULA — Returns the person full name for the given person and effective-date range.
• CF_ASSIGNMENT_NUMBERFORMULA — Returns the assignment number for the given assignment and effective-date range.
• AFTERREPORT — Performs post-report cleanup and finalization after the report completes.
• CP_SORT_DESCRIPTION2_P — Getter returning the cached value of CP_SORT_DESCRIPTION2.
• CP_SORT_BY_DETAIL_P — Getter returning the cached value of CP_SORT_BY_DETAIL.

Tables Accessed

• PER_ALL_PEOPLE_F — Read to resolve person names for CF_PERSON_NAMEFORMULA.
• PER_ALL_ASSIGNMENTS_F — Read to resolve assignment numbers for CF_ASSIGNMENT_NUMBERFORMULA.
• PAY_ELEMENT_TYPES_F — Read to resolve element type names for CF_ELEMENT_NAMEFORMULA.
• FND_APPLICATION — Read to resolve application identifiers used in report context and lookup validation.

Usage Notes

The package is invoked indirectly by the PSPENEXR concurrent program or the associated XML Publisher report definition; end users do not call it directly. The formula functions are referenced by the report template, which passes bind and column values as parameters and receives the formatted CHAR result for display. Because the package is generated by the XML Publisher/BI Publisher design tool, its signature and the getter functions (CP_*_P) mirror template parameters and should not be modified outside the report definition, as regeneration would overwrite changes. Custom code should not invoke these functions directly, as they depend on report-level package state initialized by BEFOREREPORT.