Search Results cf_org_nameformula

Overview

The APPS.PSP_PSPENASG_XMLP_PKG package is a report-support PL/SQL package associated with Oracle E-Business Suite's Oracle Labor Distribution (formerly Oracle Payroll Encumbrance) module. Its name derives from the Oracle Reports XML Publisher (XMLP) naming convention, where a report's data model or after-report triggers are implemented in a corresponding database package. In this case, the package supports a report dealing with encumbrance assignments (PSPENASG), providing formula functions that resolve descriptive values and driver logic at report execution time.

The package functions as a library of formatting and lookup routines consumed by the XML Publisher report definition. Because the report is registered as a concurrent program, the package carries global state variables for the concurrent request identifier and request ID, which report logic commonly uses to isolate run-time parameters, logging, and session context. The package is owned by APPS and classified under the "OTHER" API category, indicating it is not a public, supported integration API but rather an internal report dependency subject to change without notice.

Key Procedures and Functions

The package exposes three formula functions plus two report lifecycle triggers:

• cf_org_nameformula — Derives and returns the organization name for a given encumbrance assignment context. This is the function matched by the user's search term. It resolves the organization identifier associated with the assignment, action, and change type into a display name suitable for the report output.
• cf_change_sourceformula — Returns a character value representing the source of a change to an encumbrance assignment, based on the change type. This drives descriptive labels in the report.
• cf_element_nameformula — Returns the element name associated with an assignment change, resolving the element type from the assignment and change context.
• BeforeReport — Standard Oracle Reports trigger fired prior to report execution; typically used to initialize package state and validate run-time conditions.
• AfterReport — Standard Oracle Reports trigger fired after report completion; used to release resources or finalize state.

All three formula functions return a character (char) result and are declared as public functions within the package specification, making them callable from the report's formula columns. Parameter lists are intentionally not restated here; consult the package specification for exact signatures.

Tables Accessed

The package reads from core HR and Labor Distribution tables through APPS synonyms. Human Resources tables include HR_ALL_ORGANIZATION_UNITS, used to resolve organization names for cf_org_nameformula, and PER_ALL_ASSIGNMENTS_F for assignment context. Payroll structures are referenced through PAY_ELEMENT_TYPES_F, supporting cf_element_nameformula, and PSP_ELEMENT_TYPE_ACCOUNTS for element-to-account mapping. Encumbrance history is drawn from PSP_ENC_CHANGED_SCH_HISTORY, PSP_ENC_LINES_HISTORY, and PSP_ENC_END_DATES. Configuration and account data come from PSP_DEFAULT_LABOR_SCHEDULES and PSP_ORGANIZATION_ACCOUNTS. These accesses are read-only in the report's context.

Usage Notes

PSP_PSPENASG_XMLP_PKG is invoked exclusively by the associated Oracle Reports/XML Publisher report as a concurrent program; it is not referenced by any other documented packages. Developers and administrators should treat it as internal infrastructure rather than a callable API. Customizations should be limited to the report definition, not the package body, and any modifications require careful regression testing because the package is unsupported and version-specific.