Search Results susp_organizationformula

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.

• BEFOREREPORT / AFTERPFORM / AFTERREPORT — Report-level triggers that initialize session state, bind parameter values, and release resources when the report finishes.
• P_ORGANIZATIONSVALIDTRIGGER — Validation trigger for the Organizations parameter.
• SUSP_ORGANIZATIONFORMULA — Derives the suspense organization account information for a given suspense organization account identifier.
• CF_ORG_NAMEFORMULA, CF_TASK_NAMEFORMULA, CF_PROJECT_NUMBERFORMULA, CF_AWARD_NUMBERFORMULA, CF_EMPLOYEE_NUMBERFORMULA, CF_GL_DESCFORMULA — Lookup formulas that translate stored identifiers into report display values (organization name, task, project number, award number, employee number, and general ledger description).
• CF_SUSPENSE_ORG_ACCOUNTFORMULA — Renders the suspense organization account string from GL code combination and project/award/task/org context.
• CF_CHARGING_INSTRUCTIONSFORMUL — Returns the charging instructions text displayed for each encumbrance line; this is the function most frequently sought in support searches, including the query "cf_charging_instructionsformul."
• CF_CURRENCY_FORMATFORMULA and CF_CURRENCY_TOTAL_DSPFORMULA — Format currency values for display and totals.
• CF_PAY_TOTALFORMULA, CF_ORG_TOTAL_DSPFORMULA, CF_EMP_TOTAL_DSPFORMULA, CF_ENC_AMOUNT_DSPFORMULA — Compute and format report totals by pay element, organization, employee, and encumbrance amount respectively, applying the currency format derived above.

Tables Accessed

The package resolves data through the following APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS_TL — Source of translated organization names for the CF_ORG_NAME formula and suspense account rendering.
• PER_ALL_PEOPLE_F — Source of employee number and person information for CF_EMPLOYEE_NUMBERFORMULA.
• PSP_ORGANIZATION_ACCOUNTS — Labor Distribution organization account definitions, used by the suspense organization and charging instruction logic.
• PSP_REPORT_TEMPLATE_DETAILS — Configuration rows that drive report template behavior, parameter defaults, and report structure.

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.