Results for “cf_legislation_codeformula”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_PAYRPBLK1_XMLP_PKG is the generated PL/SQL package that supports the Oracle Payroll XML Publisher concurrent program PAYRPBLK1, a payroll run blocking report. In Oracle E-Business Suite 12.1.1 and 12.2.2, Oracle Reports-based concurrent programs that have been migrated to the XML Publisher (BI Publisher) engine are published alongside an automatically generated package whose name carries the _XMLP_PKG suffix. This package supplies the bind parameters, group filters, formula columns, and before/after report logic required by the underlying data model and report template.

The report is concerned with identifying payroll runs that are blocked, and it is parameterised by business group, payroll, and an effective date. The package header records fixed PL/SQL variables corresponding to these parameters and to the derived columns of the report query, including P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID, P_PAYROLL_ID, P_EFFECTIVE_DATE, and the local bind LP_EFFECTIVE_DATE. The package therefore acts as the runtime container for the concurrent request context and for the values the report layout consumes through its data model.

Key Procedures and Functions

The package exposes a defined set of 13 documented procedures and functions. The report-level entry points are BEFORE_REPORT and AFTERREPORT, which handle preparation and cleanup around execution, including resolution of the effective date and currency formatting defaults. Formula functions include CF_BUSINESS_GROUPFORMULA and CF_LEGISLATION_CODEFORMULA, which derive the business group and legislation context used by the template; CF_CURRENCY_FORMAT_MASKFORMULA, which returns the currency mask for a given legislation; and CF_Q1_DATA_FOUNDFORMULA and CF_Q2_DATA_FOUNDFORMULA, which signal whether the respective query blocks returned rows. SET_CURRENCY_FORMAT_MASK applies the resolved mask to the session. P_BUSINESS_GROUP_IDVALIDTRIGGE is the validation trigger for the business group parameter. Accessor functions CP_PAYROLL_NAME_P, CP_Q1_NO_DATA_FOUND_P, CP_Q2_NO_DATA_FOUND_P, and C_EFFECTIVE_DATE_P expose the corresponding report column values to the layout.

Tables Accessed

The package reads from FND_CURRENCIES to resolve currency formatting attributes, HR_ALL_ORGANIZATION_UNITS to identify the business group organisation, and HR_ORGANIZATION_INFORMATION to retrieve organisation classifications and related descriptive data. These accesses are performed through APPS synonyms, consistent with standard EBS design. The package makes no documented writes; it is a read-only reporting component, with the report data itself being returned by the XML Publisher data model rather than by this package directly.

Usage Notes

PAY_PAYRPBLK1_XMLP_PKG is not intended for direct invocation by developers. It is called by the XML Publisher runtime when the PAYRPBLK1 concurrent program is submitted, typically from the Payroll responsibility. A user supplies the payroll, business group, and effective date parameters; the effective date defaults to the session date if not entered. The report is generally run before processing a payroll to confirm that blocking conditions are resolved. Because the package is regenerated whenever the report definition changes, customisations should be applied through the report template or a wrapper, not by editing this package, as direct modifications will be overwritten. The documented tables referenced by the package are used only for context and formatting rather than to produce the report's principal result set.