Search Results psp_pspencsc_xmlp_pkg




Overview
Explore in AI Chat

Overview

PSP_PSPENCSC_XMLP_PKG is an Oracle Application Object Library PL/SQL package owned by APPS that supports the Oracle E-Business Suite Labor Distribution (PSP) encumbrance reporting infrastructure. The "XMLP" suffix in the package name denotes that it is a report helper package generated for a BI Publisher (XML Publisher) concurrent program, and the "ENCSC" fragment indicates its association with the Encumbrance Summary/Detail report family. Its principal role is to supply the PL/SQL formula columns, bind variables, and report-level triggers required by the XML Publisher report template at runtime.

The package was last revised under header PSPENCSCS.pls version 120.3. It is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the calling user rather than the defining user. It is not classified as an API and is referenced by zero other packages, confirming that it is a report-private component invoked only by its owning concurrent program and template.

Key Procedures and Functions

The package exposes nineteen documented functions, most of which are named with the "FORMULA" suffix convention used by Oracle Reports/XML Publisher to denote report formula columns.

Tables Accessed

The package resolves data through the following APPS synonyms:

Usage Notes

PSP_PSPENCSC_XMLP_PKG is invoked exclusively by the concurrent program that executes the PSP Encumbrance Summary report and its associated BI Publisher template. The report engine calls the trigger functions at defined lifecycle points (BeforeReport, AfterPForm, AfterReport) and calls each CF_* formula function once per report row or total block. Because the package is not classified as an API and is referenced by no other packages, it should not be called directly from custom code, forms, or third-party integrations; any extension or correction should be implemented through a cloned custom package rather than by modifying the seeded object.