Results for “cf_pay_totalformula”

16 results




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

Overview

APPS.PSP_PSPENCSC_XMLP_PKG is the generated package body that supports the Oracle E-Business Suite XML Publisher (BI Publisher) report "PSPENCSC" — the Encumbrance Detail / Encumbrance Summary report belonging to the Oracle Grants and Project Costing (PSP) product family. In Oracle EBS 12.1.1 and 12.2.2 the XML Publisher concurrent program architecture pairs a data model (a query executed by the XMLP engine) with a PL/SQL package generated by the XML Publisher design-time tooling. This package is classified as OTHER and contains no business API calls intended for external consumption; it exists solely to supply computed column values to the report layout and to execute report-level trigger logic.

The name PSP_PSPENCSC_XMLP_PKG follows the standard naming convention: PSP designates the owning application, PSPENCSC is the report short name, and XMLP_PKG identifies it as an XML Publisher support package. The header comment ($Header: PSPENCSCB.pls 120.3.12020000.2 2013/04/05) indicates the body was last delivered against kernel 12.2 level source in 2013, consistent with its presence in both 12.1.1 and 12.2.2 installations.

Key Procedures and Functions

The package exposes 19 documented program units, most of which are "formula" functions whose return values are mapped to named fields in the report template.

Each formula function wraps its query in a NO_DATA_FOUND / TOO_MANY_ROWS / OTHERS exception handler that returns the literal strings 'no_data_found', 'too many rows', or 'error', allowing the report to render a diagnostic placeholder rather than failing outright.

Tables Accessed

  • HR_ALL_ORGANIZATION_UNITS_TL — source of the translated organization name used by SUSP_ORGANIZATIONFORMULA and the organization name formulas.
  • PER_ALL_PEOPLE_F — source of employee number values for the employee formulas.
  • PSP_ORGANIZATION_ACCOUNTS — maps an organization account identifier to an organization identifier, bridging suspense accounts to organizations.
  • PSP_REPORT_TEMPLATE_DETAILS — the report template definition table, consulted by the report trigger logic to resolve layout/template configuration.

Additional views referenced include PA_TASKS_EXPEND_V and GMS_AWARDS_BASIC_V, both accessed through APPS synonyms. All access is read-only; the package performs no DML.

Usage Notes

PSP_PSPENCSC_XMLP_PKG is invoked indirectly rather than directly. When the "Encumbrance Detail" (PSPENCSC) concurrent program is submitted with the XML Publisher output format, the XML Publisher engine calls the packaged functions to populate template parameters and computed columns, and fires the BEFOREREPORT/AFTERREPORT/AFTERPFORM triggers automatically. The Organizations parameter is validated through P_ORGANIZATIONSVALIDTRIGGER before the data model executes.

Because the package is documented as referenced by zero other packages, it should be treated as a leaf-level report component with no supported inbound API surface. Customizations should be applied by copying the report definition, not by modifying this generated package, since patches to the Grants/Project Costing family will overwrite the delivered body. The 120.3 source version applies to both 12.1.1 and 12.2.2, so no version-specific behavior differences are expected. Developers troubleshooting the report should use the returned sentinel strings ('no_data_found', 'too many rows', 'error') as indicators of underlying data or join problems.