Search Results pay_pyauapl_xmlp_pkg




Overview
Explore in AI Chat

Overview

PAY_PYAUAPL_XMLP_PKG is the generated PLSQL package that supports the Oracle Payroll concurrent program and report template associated with advance payment processing and leave advance reporting. The package follows the standard Oracle Reports XML Publisher integration pattern used throughout Oracle E-Business Suite, where a report definition exposed as a concurrent program has a corresponding PL/SQL package (typically the _XMLP_PKG suffix) that declares report parameters, provides initialization logic at runtime, and exposes report-level formula functions to the reporting engine. This package exists in the APPS schema and is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as the definer, which is the convention for reports that must honor the session context of the requesting user.

The user search term "cp_lv_adv_p" corresponds directly to a global package variable and accessor function documented in this package (CP_LV_ADV, CP_LV_ADV_P), indicating the object of interest is the leave advance date element used by the report. This naming convention — CP_ prefix for calculated or control parameters — is consistent with Oracle Reports parameter naming, where values computed during report execution are surfaced to the layout and data model. The package therefore serves the payroll administrator in reporting on leave advances tied to a specific payroll, employee, and advance period.

Key Procedures and Functions

The package declares fifteen documented procedures and functions plus a set of global variables that carry request and parameter context. The variables include the concurrent request ID (P_CONC_REQUEST_ID), business group and payroll identifiers, employee identifiers, leave start and end dates, pay dates, and the calculated values CP_LV_ADV, CP_CURRENT, CP_FUTURE, CP_YES, and CP_NO.

  • BEFOREREPORT — initialization function invoked before report execution, typically responsible for defaulting parameters, deriving the business group context, and caching configuration values.
  • AFTERREPORT — post-processing function invoked after report execution, commonly used for cleanup or final status updates.
  • CF_BUSINESS_GROUPFORMULA — returns the business group name or identifier for the report header context.
  • CF_CURRENT_FUTURE_FLAGFORMULA — returns a flag indicating whether the leave advance relates to a current or future period.
  • CF_PROCESS_FLAGFORMULA — evaluates the leave start and end dates to determine whether the record should be processed in the report output.
  • CF_END_DATEFORMULA — returns a formatted end date string for report display.
  • CF_DATE_CONVERSIONFORMULA — converts leave start date, leave end date, and pay date strings into a numeric representation for comparison or ordering.
  • CP_LEAVE_START_DATE_P, CP_PAY_DATE_P, CP_LEAVE_END_DATE_P, CP_LV_ADV_P — accessor functions exposing the calculated leave start, pay, leave end, and leave advance dates to the report layout.
  • CP_CURRENT_P, CP_FUTURE_P, CP_YES_P, CP_NO_P — accessor functions exposing the current/future designation and the yes/no literal values used by conditional formatting.

Tables Accessed

The package references three tables through APPS synonyms. HR_ALL_ORGANIZATION_UNITS is the primary organization and business group table, used to resolve the business group and validate organization context. PAY_ASSIGNMENT_ACTIONS supplies assignment-level payroll action records, which link employees to payroll processing events and are central to identifying leave advance activity. PAY_PAYROLL_ACTIONS provides payroll action information used to constrain data to the selected payroll and time period. Together these tables allow the report to correlate employees, their assignments, and the payroll actions relevant to leave advances.

Usage Notes

This package is not intended for direct invocation by application code or custom PL/SQL. It is invoked by the Oracle Reports runtime when the associated concurrent program is submitted from the Payroll responsibility or when the report is run through standard report submission. Because it is declared AUTHID CURRENT_USER and is referenced by zero other packages, it functions as a leaf object dedicated to a single report definition. Customizations should therefore be applied to the underlying report template or by extending the report data model rather than by modifying the package body directly, since regenerated versions from patch application will overwrite manual changes. Users searching for "cp_lv_adv_p" are directed to the CP_LV_ADV and CP_LV_ADV_P elements, which represent the computed leave advance date carried from the report data model into the layout.