Search Results psp_pspenasg_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PSP_PSPENASG_XMLP_PKG is a packaged PL/SQL construct owned by the APPS schema in Oracle E-Business Suite, classified as a report-oriented package body associated with the PSP (Payables/Project Supplier Portal — here specifically the Oracle Labor Distribution / Project Costing staffing assignment) module. Its name follows the standard XML Publisher concurrent program naming convention, where the suffix XMLP_PKG denotes the PL/SQL package bound to a BI Publisher (XML Publisher) report definition. The package encapsulates the data extraction and formula logic that produces the XML data source consumed by the report template.

In business terms, this package supports the reporting of employee assignment / element distribution information, correlating HR organizations, payroll element types, and default labor schedules with their associated accounting distributions. It is the programmatic backbone of a concurrent report used by payroll, cost accounting, and project accounting personnel to review how labor assignments and their charges are structured across organizations.

Key Procedures and Functions

The documented package exposes five program units, two of which are standard XML Publisher report-level triggers and three of which are formula/derivation functions:

  • BEFOREREPORT — The standard BI Publisher before-report trigger. It executes once prior to data extraction, typically to initialize session context, resolve report parameters, and prepare any package-level state required by the query.
  • AFTERREPORT — The standard after-report trigger, invoked once after the data set has been generated, commonly used to release resources or finalize report-level processing.
  • CF_ORG_NAMEFORMULA — A formula function ("CF" indicating a computed/column formula) that derives the human-readable organization name for display, resolving the organization identifier against the HR organization structures.
  • CF_ELEMENT_NAMEFORMULA — A formula function that resolves and returns the descriptive name of the payroll element type associated with a distribution line.
  • CF_CHANGE_SOURCEFORMULA — A formula function that determines and formats the source of a schedule or assignment change, drawing on the change-history data. Together these three CF_ functions implement the presentation-level derivations required by the report layout that cannot be produced by a simple SQL select.

Tables Accessed

The package reads from the following documented tables (via APPS synonyms), each serving a distinct reporting purpose:

The package references itself internally and is not referenced by any other database object, confirming it is a terminal report package rather than a shared API.

Usage Notes

PSP_PSPENASG_XMLP_PKG is invoked exclusively through its associated XML Publisher concurrent program; the XMLP_PKG suffix and the presence of BEFOREREPORT/AFTERREPORT triggers and CF_ formula functions are the definitive markers of this pattern. It is not a callable business API and should not be invoked from forms or custom PL/SQL. Because it relies on the PSP and HR/PAY tables, it must be run in an environment where the Labor Distribution (PSP) product is installed. Customizations should be limited to the report template; the package body is Oracle-owned and is overwritten by patching or upgrades in both 12.1.1 and 12.2.2.