Search Results cf_date_checkformula

Overview

PSP_PSPENORG_XMLP_PKG is an Oracle Application Object Library PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is a report-support package that encapsulates the PL/SQL logic behind the Oracle Projects (PSP) encumbrance-by-organization concurrent report, internally identified as PSPENORG. The package follows the standard Oracle Reports XML Publisher integration pattern, in which report-level "formula" columns and format triggers are exposed as server-side PL/SQL functions so that the report definition itself remains thin and the business logic is centralized in the database layer.

The package declares a set of global parameters that receive the concurrent request context at runtime: organization identifier, payroll identifier, set of books, business group, concurrent request ID, begin and end dates with their character counterparts, and organization and pay templates. These globals are populated by the report trigger functions and are thereafter available to every formula in the report. The substantive purpose of the package is to derive encumbrance amounts, date ranges, award attributes, and currency-formatted display strings for a project encumbrance report organized by expenditure organization.

Key Procedures and Functions

The package exposes twelve documented program units, of which three are report-level triggers and nine are column formulas.

• AFTERPFORM — report trigger executed after the parameter form is submitted; resolves and normalizes the runtime parameters before the query executes.
• BEFOREREPORT — report trigger executed before the main data query; initializes package globals and report-level settings.
• AFTERREPORT — report trigger executed after report completion; performs cleanup and finalization.
• CF_CHARGING_INSTFORMULA — derives the charging instruction for an encumbrance line from the code combination, project, task, award, expenditure organization, and expenditure type.
• CF_AWD_END_DTFORMULA — returns the end date of the referenced award.
• CF_DATE_CHECKFORMULA — compares the award end date against the encumbrance end date and returns a status indicator.
• CF_ENC_DATE_RANGEFORMULA — formats the encumbrance begin and end dates into a display date range.
• CF_ENC_AMOUNT_DSPFORMULA — formats a single encumbrance amount using the currency format string supplied by CF_CURRENCY_FORMATFORMULA.
• CF_ORG_TOTAL_DSPFORMULA — formats the organization-level encumbrance total.
• CF_PAY_TOTAL_DISPFORMULA — formats the pay-level encumbrance total.
• CF_CURRENCY_FORMATFORMULA — returns the display format mask for a given currency code; this is the function associated with the user search term "cf_currency_formatformula".
• CF_CURRENCY_TOTAL_DSPFORMULA — formats a per-currency encumbrance total, combining currency code, format mask, and total value.

Tables Accessed

The package reads reference and transaction data through APPS synonyms. GMS_AWARDS and GMS_AWARDS_ALL supply award identifiers, end dates, and award attributes used by the award and date-check formulas. HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL provide organization identifiers and translated organization names for the organization breakdown. PA_PROJECTS_ALL supplies project-level attributes used in charging instruction derivation. PSP_REPORT_TEMPLATE_DETAILS supplies report template configuration consumed during parameter processing.

Usage Notes

The package is not intended to be called directly by custom code. It is invoked exclusively by the PSPENORG Oracle Reports/XML Publisher concurrent program at runtime, with the report engine calling each trigger and formula function in sequence. The currency format formula, CF_CURRENCY_FORMATFORMULA, is invoked once per distinct currency encountered in the report output so that amounts can be rendered with the correct symbol and precision. Because no other package references PSP_PSPENORG_XMLP_PKG, modifications carry limited blast radius but should still be treated as report-layer changes subject to the standard Oracle Projects patching and regression-testing process.