Search Results cf_date_formatformula

Overview

PSP_PSPLSODR_XMLP_PKG is an Oracle Application Object Library (APPS) PL/SQL package that supports the Oracle E-Business Suite Grants and Project Portfolio analysis reporting infrastructure. Based on its naming convention and its association with the Oracle XML Publisher (XMLP) framework, the package serves as the backend PL/SQL package for a concurrent-program data definition used to produce a report — specifically one structured around "PSP," the schema prefix associated with Oracle Grants Management / Project Portfolio Management reporting templates. The reported source header (PSPLSODRS.pls, version 120.5, dated January 2008) confirms that it is a long-standing component relevant to both EBS 12.1.1 and 12.2.2.

The package declares a set of global variables that capture concurrent-program parameters — including P_RUN_ID, P_BEGIN_DATE, P_END_DATE, P_ORGANIZATION_ID, P_REPORT_TYPE, P_CONC_REQUEST_ID, P_BUSINESS_GROUP_ID, P_SET_OF_BOOKS_ID, and P_ORG_TEMPLATE_ID. These variables define the runtime context of a single report execution. Collectively the package provides the data validation, lookup resolution, and date-formatting formulas that an XML Publisher report relies upon when it renders project and award schedule information.

Key Procedures and Functions

The package exposes 17 documented functions. Two are lifecycle hooks: BEFOREREPORT and AFTERREPORT handle initialization and cleanup around report execution, while AFTERPFORM performs post-parameter-form processing after the user submits concurrent-program parameters.

The remaining functions generate computed column values for the report output:

• CF_DATE_FORMATFORMULA — returns the format mask used to render dates throughout the report. It is the pivot for every date-display function below, several of which accept a CF_DATE_FORMAT parameter.
• CF_SCH_BEGIN_DATE_DISPFORMULA and CF_SCH_END_DATE_DISPFORMULA — produce the displayed schedule begin and end dates.
• CF_REPORT_RUN_DATEFORMULA — returns the report execution timestamp.
• CF_PERIOD_START_DATEFORMULA and CF_PERIOD_END_DATE_DISPFORMULA — render the accounting/period start and end dates.
• CF_BEGIN_DATE_DISPFORMULA and CF_END_DATE_DISPFORMULA — display the concurrent-program begin and end date parameters.
• CF_GL_DESCFORMULA — resolves a GL code combination identifier to its descriptive flexfield description.
• CF_TASK_NAMEFORMULA, CF_AWARD_NUMBERFORMULA, CF_PROJECT_NUMBERFORMULA — return the names/numbers for the task, award, and project associated with each row.
• CF_ORG_NAMEFORMULA — returns the expenditure organization name.
• CF_ORG_SCHEDULE_IDFORMULA — returns the organization schedule identifier.

Tables Accessed

The package reads from the following APPS-synonymed tables:

• GMS_AWARDS_ALL — source for award numbers and award attributes.
• GMS_IMPLEMENTATIONS — Grants Management implementation/configuration data.
• HR_ALL_ORGANIZATION_UNITS_TL — translated organization names used by CF_ORG_NAMEFORMULA.
• PA_PROJECTS_ALL — project numbers and project attributes.
• PSP_MATRIX_DRIVER — the PSP report matrix driver table that supplies the report template structure.
• PSP_REPORT_TEMPLATE_DETAILS — report template definitions used by the XML Publisher layout.

Usage Notes

PSP_PSPLSODR_XMLP_PKG is invoked indirectly by the Oracle XML Publisher concurrent program to which it is bound; the report's template calls each CF_* function to populate computed columns. The metadata records no other package referencing it, indicating that it is a leaf-level reporting package not intended for direct invocation from forms or custom code. It is not an API-classified package; its functions are display formulas rather than business APIs, and they should not be relied upon for transactional data manipulation. Administrators should treat the CF_* functions as read-only reporting helpers whose behavior is governed by the runtime values of the package-level parameters.