Search Results cf_run_dateformula

Overview

PSP_ENC_CRT_XML is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. Its name and internal structure indicate that it supports the generation of XML output for the encumbrance creation process in Oracle Project Costing and Oracle Payroll integration scenarios. The package exposes a set of user-defined formula functions (prefixed with "cf_") that are consumed by an XML Publisher (BI Publisher) report or template, alongside supporting utility functions for schedule lookups and earned-date calculation. The inclusion of payroll action, set of books, business group, and request identifiers as globals confirms that the package operates within a concurrent request context, typically tied to a payroll or project encumbrance run. In the 12.1.1 and 12.2.2 releases, this object is a repository object rather than a public API, meaning it is not intended for direct invocation by external custom code but rather executes as part of a delivered report or concurrent program flow.

Key Procedures and Functions

• CF_CHARGING_INSTFORMULA — Returns a character value representing the charging instructions for a given expenditure distribution. It accepts the GL code combination, project, task, award, expenditure organization, and expenditure type, and is designed to be called as an XML Publisher formula column, matching the search term "cf_charging_instformula".
• CF_CURRENCY_CODEFORMULA — Formula function returning the currency code used in the generated XML output.
• CF_RUN_DATEFORMULA — Formula function returning the run date as a character string, used to stamp the XML output with the processing date.
• INITIALIZE_SCHED_LOOKUPS — Initializes schedule-related lookup values into package globals, populating the G_* variables (assignment, global element, organization level, suspense, organization default, assignment element, and assignment element group) from FND_LOOKUP_VALUES.
• LAST_DATE_EARNED — Returns the last date earned for a given payroll, supporting payroll encumbrance date derivation.
• CF_P_ORIG_REQ_ID — Returns the original request identifier, used to link the XML output back to its originating concurrent request.

Tables Accessed

• FND_LOOKUP_VALUES — Read by INITIALIZE_SCHED_LOOKUPS to populate schedule and element lookups.
• GMS_AWARDS_ALL — Supplies award information used by the charging instruction formula.
• HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL — Provide expenditure organization details and translated names.
• PA_PROJECTS_ALL — Provides project and task context for charging distributions.
• PAY_PAYROLL_ACTIONS — Used for payroll action context, including request linkage.
• PSP_ENC_PROCESSES — Encumbrance process records that drive the XML generation.

Usage Notes

PSP_ENC_CRT_XML is invoked indirectly through an XML Publisher report or concurrent program associated with encumbrance creation. The "cf_" formula functions are referenced as XML Publisher formula columns within a report template, which is why the package surfaces in searches for "cf_charging_instformula". The package globals (set of books, payroll action, request identifier, business group) are populated at report initialization before the formula functions execute. Because the package is documented as referenced by three other packages, it participates in a broader encumbrance processing chain rather than operating in isolation. Customizations should avoid direct calls to these functions; instead, modifications should be applied to the underlying report template or to the delivered concurrent program definition, preserving the standard API boundary.