Search Results cf_date_runformula

Overview

PSP_PSPLDAWD_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified as an OTHER API. It serves as the backend formula package for a BI Publisher (XML Publisher) concurrent report within the Oracle Grants Management (PSP) module. The package's naming convention — the "_XMLP_PKG" suffix together with the "PSPLDAWD" identifier and the "LD" prefix in the header comment — indicates that it backs the Award Labor Distribution report (PSPLDAWD), a report that presents award-related payroll labor distribution data in a formatted output. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking user rather than the definer.

The package declares packaged variables for report parameters — P_AWARD_ID, P_CONC_REQUEST_ID, P_BUSINESS_GROUP_ID, P_SET_OF_BOOKS_ID, P_START_DATE, P_END_DATE, and P_AWD_TEMPLATE_ID — which are populated at runtime from the concurrent program's parameter form. The remainder of the package consists of functions that generate the report's computed and formatted columns, including the function the user searched for, CF_DATE_RUNFORMULA.

Key Procedures and Functions

The 30 documented program units divide into three functional groups.

Report lifecycle triggers: BEFOREREPORT, AFTERPFORM, BEFOREPFORM, and AFTERREPORT handle report initialization and teardown. BEFOREPFORM accepts an orientation parameter. These are standard XML Publisher report hooks invoked automatically when the report runs.

Formatting formulas: CF_CURRENCY_FORMATFORMULA, CF_SUM_CURRENCY_CODEFORMULA, CF_CURR_AWD_AMT_TOTALFORMULA, CF_EARNINGS_AMOUNTFORMULA, and CF_DATE_FORMATFORMULA return currency and date formatting strings. CF_START_DATE_DISPLAYFORMULA and CF_END_DATE_DISPFORMULA render the report date range using the computed date format. CF_DATE_RUNFORMULA returns the report run date as a formatted CHAR.

Lookup and display formulas: CF_AWARD_NAMEFORMULA, CF_EMPLOYEE_NAMEFORMULA, CF_EMPLOYEE_NUMBERFORMULA, CF_INSTITUTION_NAMEFORMULA, CF_ASSIGNMENT_NUMBERFORMULA, CF_ELEMENT_NAMEFORMULA, and CF_TIME_PERIOD_NAMEFORMULA resolve IDs to descriptive display text. CF_CHARGING_INSTRUCTIONSFORMUL builds the charging instructions narrative from expenditure organization, task, project, award, and expenditure type inputs.

Tables Accessed

The package reads reference data through APPS synonyms. GMS_AWARDS_ALL supplies award header and template information; the P_AWARD_ID and P_AWD_TEMPLATE_ID parameters drive this filtering. HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL provide the institution and organization names used by CF_INSTITUTION_NAMEFORMULA, with the _TL table supplying translated descriptions. PAY_ELEMENT_TYPES_F resolves element type names for labor distribution lines. PA_PROJECTS_ALL and PER_ALL_PEOPLE_F supply project and employee/assignment attributes. PER_TIME_PERIODS provides the time period descriptions used by CF_TIME_PERIOD_NAMEFORMULA. PSP_REPORT_TEMPLATE_DETAILS is the reporting metadata table that defines the template used to render this report.

Usage Notes

PSP_PSPLDAWD_XMLP_PKG is invoked indirectly by the XML Publisher runtime engine when the corresponding concurrent program executes. The report definition's data template and RTF template reference each CF_* formula by name, and the engine calls the package function at report execution time to populate the formatted column value. Parameters captured in the concurrent program's parameter form are assigned to the package-level variables before the report data model runs.

The package is not referenced by any other PL/SQL package, so it has no downstream dependency exposure. Customizations should be limited to the report templates and concurrent program definition rather than direct modification of the seeded package, since the header version (120.5) confirms it is a delivered object subject to patching.