Search Results c_consolidation_set_p

Overview

PAY_PYGBNICV_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It serves as the report logic container for the Oracle Payroll concurrent program associated with the PYGBNICV (Payroll Gross-to-Net / consolidation verification) XML Publisher report. The package encapsulates the global variables, cursors, and report-level functions that the Oracle Reports XML Publisher engine invokes at runtime to render payroll consolidation data for a selected business group, payroll, consolidation set, and assignment set.

The package declares a set of public global variables that map directly to the report's concurrent program parameters, including P_BUSINESS_GROUP_ID, P_SESSION_DATE, P_CONC_REQUEST_ID, P_SORT_ORDER, P_PAYROLL_NAME, P_CONSOLIDATION_SET, P_ASSIGNMENT_SET, P_EFFECTIVE_DATE, P_SORT, and P_EFFECTIVE_START_DATE, alongside LP_EFFECTIVE_DATE. It also declares internal globals C_BUSINESS_GROUP_NAME, C_REPORT_SUBTITLE, C_PAYROLL_NAME, C_CONSOLIDATION_SET, and C_ASSIGNMENT_SET that hold processed values for display in the report header and subtitle. The report is a payroll reporting utility, and the user search term "p_consolidation_set" corresponds directly to the package-level variable P_CONSOLIDATION_SET, which carries the consolidation set selection from the concurrent program parameter form into the report logic.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• BEFOREREPORT — Executed by the Oracle Reports runtime before report data is fetched. It is used to derive and populate the report-level globals, such as business group name, report subtitle, payroll name, consolidation set, and assignment set, from the concurrent request parameters.
• AFTERREPORT — Executed after the report completes, providing cleanup or post-processing logic.
• C_BUSINESS_GROUP_NAME_P — Returns the business group name used in the report output.
• C_REPORT_SUBTITLE_P — Returns the report subtitle string for the heading section.
• C_PAYROLL_NAME_P — Returns the formatted payroll name.
• C_CONSOLIDATION_SET_P — Returns the formatted consolidation set name associated with the P_CONSOLIDATION_SET parameter.
• C_ASSIGNMENT_SET_P — Returns the formatted assignment set name.

Tables Accessed

The package references two documented tables via APPS synonyms:

• PAY_CONSOLIDATION_SETS — The payroll consolidation set definition table. It is queried to resolve the consolidation set identifier passed through P_CONSOLIDATION_SET into the display name returned by C_CONSOLIDATION_SET_P.
• HR_ASSIGNMENT_SETS — The assignment set definition table, queried to resolve the assignment set parameter into the value returned by C_ASSIGNMENT_SET_P.

Usage Notes

PAY_PYGBNICV_XMLP_PKG is not a general-purpose API and is not referenced by any other package (referenced by 0 other packages). It is invoked exclusively through the Oracle Reports/XML Publisher runtime when the associated Payroll concurrent program is submitted. Administrators and developers interact with it indirectly through the concurrent program parameter form, where parameters such as Consolidation Set and Assignment Set are entered; those values populate P_CONSOLIDATION_SET and P_ASSIGNMENT_SET and flow into the BeforeReport logic. Customizations should be limited to report template changes rather than direct package modification, since the package is version-controlled Oracle seed code and upgrading EBS may overwrite local edits. Developers troubleshooting report header values such as the consolidation set display name should inspect C_CONSOLIDATION_SET_P and the PAY_CONSOLIDATION_SETS lookup.