Search Results cp_payroll_name

Overview

APPS.PAY_PAYGBPAY_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Payroll "GB Payment" (PAYGBPAY) XML Publisher concurrent report. It handles report-level setup and formatting logic for a UK (GB) payroll payment listing, performing initialization, parameter resolution, and running-total accumulation before and during report execution. The package is classified under ETRM as API classification OTHER, indicating it is not a public callable API but a supporting implementation package for the report. In Oracle EBS 12.1.1 and 12.2.2, packages of this naming convention (APPS._XMLP_PKG) are auto-generated when a concurrent program is migrated to the XML Publisher (BI Publisher) engine, and they encapsulate the data model triggers and formula columns that were previously handled by Oracle Reports.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. Their roles are as follows:

• BEFORE_REPORT_TRIGGER — The primary initialization routine. It retrieves the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, derives the business group name through HR_REPORTS.GET_BUSINESS_GROUP, converts the payment start and end date parameters using FND_DATE.CANONICAL_TO_DATE, and resolves the legislation code, payroll name (CP_PAYROLL_NAME), and consolidation set name. It also constructs the dynamic CP_CONSOLIDATION_SET_LINE SQL fragment conditionally.
• CF_CALCULATE_RUNNING_TOTALFORM — A formula column function that accumulates CP_RUNNING_TOTAL_AMOUNT_PAID from an input running total amount paid.
• CF_RUNNING_TOTAL_NUMBER_PAIDFO — A formula column function that accumulates CP_RUNNING_TOTAL_NUMBER_PAID from an input total assignments paid.
• AFTERREPORT — The after-report trigger, which conventionally issues the SRW exit user exit (FND SRWEXIT) to release report resources.
• CP_RUNNING_TOTAL_NUMBER_PAID_P, CP_RUNNING_TOTAL_AMOUNT_PAID_P — Accessor functions returning the accumulated running totals.
• CP_BUSINESS_GROUP_NAME_P, CP_PAYROLL_NAME_P, CP_CONSOLIDATION_SET_LINE_P, CP_CONSOLIDATION_SET_NAME_P, CP_EARLIEST_PAYMENT_P, CP_LATEST_PAYMENT_P — Accessor functions that return the corresponding CP_* package variables set during the before-report trigger for use by the report layout.

Tables Accessed

The package reads from several EBS tables via APPS synonyms. PER_BUSINESS_GROUPS supplies the LEGISLATION_CODE for the selected business group. PAY_PAYROLLS_F supplies the distinct PAYROLL_NAME for the given payroll ID, populating CP_PAYROLL_NAME. PAY_CONSOLIDATION_SETS supplies CONSOLIDATION_SET_NAME when a consolidation set ID is provided; otherwise the variable is set to NULL. The ETRM metadata explicitly lists PAY_CONSOLIDATION_SETS as a referenced table. Additional references to PER_BUSINESS_GROUPS and PAY_PAYROLLS_F appear in the source excerpt.

Usage Notes

This package is invoked indirectly when the PAYGBPAY concurrent program is run; it is not intended for direct invocation by custom code. The BEFORE_REPORT_TRIGGER fires as the report's data model pre-trigger, AFTERREPORT as the post-trigger. Parameter values (P_BUSINESS_GROUP_ID, P_PAYROLL_ID, P_PAYMENT_START_DATE, P_PAYMENT_END_DATE, P_CONSOLIDATION_SET_ID) are supplied by the concurrent program submission. The CP_* accessor functions are referenced from the report layout to display the resolved payroll name and consolidation set description. Because CP_PAYROLL_NAME is populated via a SELECT INTO, a missing or ambiguous payroll ID would raise NO_DATA_FOUND or TOO_MANY_ROWS at runtime; the DISTINCT clause mitigates the latter. The package references no other PL/SQL packages and is referenced by zero other packages, confirming its scope is confined to supporting this single concurrent report.