Search Results cf_exp_org_nameformula

Overview

PSP_PSPLSEMP_XMLP_PKG is an Oracle Application Object Library package owned by APPS that supports the XML Publisher (BI Publisher) concurrent program used by Oracle Project Resource Management to produce the Assignment / employee schedule listing within Oracle E-Business Suite 12.1.1 and 12.2.2. The package is a generated concurrent-program support package: its name suffix _XMLP_PKG indicates it accompanies an XML Publisher report definition and supplies the PL/SQL logic bound to the report's data model and layout templates. Its central role is to resolve the numerous code-stored identifiers captured by the report query — organization identifiers, person identifiers, project and task numbers, award numbers, GL account combinations, and scheduling type codes — into the human-readable display values that appear on the printed or exported report. In addition, it drives the report's lifecycle events through the standard BEFOREREPORT, AFTERPFORM, and AFTERREPORT hooks and applies consistent date formatting to the scheduling and fiscal period columns.

The user search term cf_exp_org_nameformula corresponds directly to one of the package's documented formula functions: CF_EXP_ORG_NAMEFORMULA. This function converts an expenditure organization identifier into its descriptive organization name for display in the report output. The leading CF_ prefix is the naming convention for XML Publisher "column formula" placeholders generated automatically for a report's data groups.

Key Procedures and Functions

The package exposes 20 documented subprograms, all but three of which are CF_ formula functions used as report placeholders:

• Identifier-to-name formulae: CF_ORGANIZATION_NAMEFORMULA, CF_EMPLOYEE_NAMEFORMULA, CF_PROJECT_NUMBERFORMULA, CF_TASK_NUMBERFORMULA, CF_AWARD_NUMBERFORMULA, CF_EXP_ORG_NAMEFORMULA, and CF_GL_DESCRIPTIONFORMULA each accept a numeric identifier (organization, person, project, task, award, expenditure organization, or GL code combination) and return the corresponding formatted character value for the report.
• Classification formulae: CF_DESCRIPTIONFORMULA derives a descriptive label from a type code combined with a scheduling type code, and CF_HIER_DESCFORMULA produces the hierarchy description from the scheduling type code and the derived description.
• Date formatting formulae: CF_DATE_FORMATFORMULA returns the active date format pattern, which is then applied by CF_REPORT_RUN_DATEFORMULA, CF_SCH_BEGIN_DATE_DISPFORMULA, CF_SCH_END_DATE_DSPFORMULA, CF_PERIOD_START_DATE_DISPFORMU, CF_PERIOD_END_DATE_DISPFORMULA, CF_BEGIN_DATE_DISPFORMULA, and CF_END_DATE_DISPFORMULA to render scheduling, period, and parameter dates consistently.
• Lifecycle events: BEFOREREPORT initializes report state and parameter defaults; AFTERPFORM executes after the parameter form is submitted; AFTERREPORT performs post-processing. Each returns BOOLEAN.

Tables Accessed

The package resolves its lookup values against the following APPS synonyms: HR_ALL_ORGANIZATION_UNITS_TL for organization name translations; PA_PROJECTS_ALL for project numbers; GMS_AWARDS_ALL and GMS_IMPLEMENTATIONS for award numbers and grants configuration; PAY_ELEMENT_TYPES_F for element type descriptions; and PSP_ELEMENT_GROUPS and PSP_REPORT_TEMPLATE_DETAILS for the report's own grouping and template definition. No insert, update, or delete operations are implied; the package is a read-only reporting support unit.

Usage Notes

PSP_PSPLSEMP_XMLP_PKG is not called by other PL/SQL packages — the ETRM metadata records zero referencing packages. It is invoked exclusively through the XML Publisher concurrent program infrastructure when the associated report is submitted, at which point the runtime engine binds each CF_ function to its report column and executes the lifecycle hooks. Direct invocation from custom code is neither expected nor supported; customization should be performed through the report definition and template rather than by modifying this generated package.