Search Results cf_person_nameformula

Overview

PSP_PSPRCPGD_XMLP_PKG is an Oracle EBS PL/SQL package that supports the concurrent program PSPRCPGD — the Project Costing Pre-Generation Distribution report, rendered through Oracle XML Publisher (BI Publisher). The package embodies the report's PL/SQL logic: it declares the report's bind/parameter variables, defines the group-level formula functions invoked by the XML Publisher template, and provides the before-report and after-form triggers used to initialize parameters, balances, and derived values before the report data model executes. The "_XMLP_PKG" suffix denotes that the package was auto-generated by the Oracle XML Publisher concurrent program definition process, which extracts report logic from the source report into a package attachable to the data template.

Key Procedures and Functions

The documented entry points include the following functions. Each is designed as a "formula" or trigger called by the XML Publisher engine or the concurrent manager during report execution.

• CF_PERSON_NAMEFORMULA — the object directly relevant to the user's search term "cf_person_nameformula". It derives the display name for a person from a person identifier passed into the report, enabling readable names in the report output rather than numeric IDs.
• CF_ASSIGNMENT_NUMBERFORMULA — resolves an assignment identifier to its formatted assignment number for display.
• AFTERPFORM — the after-parameter-form trigger, executed after the report parameter form is populated. It typically performs parameter validation, defaulting, or setup logic prior to the report query.
• CF_MISMATCH_ELTFORMULA, CF_MISMATCH_ASSGFORMULA, CF_MISMATCH_PERSONFORMULA, CF_MISMATCH_REPORTFORMULA — a family of comparison formulas that flag mismatches between debit and credit amounts at the element, assignment, person, and report levels.
• CF_AMT_SL_CFORMULA and CF_AMT_DL_DFORMULA — derive secondary ledger credit amounts and primary ledger debit amounts respectively, based on GL code combination, project, task, award, expenditure type, and organization context.
• CF_ORG_REPORTFORMULA — supplies the organization value reported when the report is executed at the organization level.
• BEFOREREPORT — the before-report trigger, which initializes reporting parameters and any global state required by the data model.
• Additional formula functions (CF_SOURCE_TYPEFORMULA, CF_TIME_PERIODFORMULA, CF_CHARGING_INSTRUCTIONSFORMU, CF_CURRENCY_CODEFORMULA, CF_CURRENCY_FORMATFORMULA, and the CF_SUM_*_DSPFORMULA family) provide display formatting for source type, time period, charging instructions, currency code and format, and summed debit/credit totals.

Tables Accessed

The package reads from the following documented tables via APPS synonyms:

• PSP_PRE_GEN_DIST_LINES_HISTORY — the pre-generation distribution history lines that constitute the report's principal dataset.
• PSP_SUMMARY_LINES — summarized distribution lines used for aggregation and comparison logic.
• HR_ALL_ORGANIZATION_UNITS / HR_ALL_ORGANIZATION_UNITS_TL — organization units and translated names for resolving organization identifiers.
• PER_TIME_PERIODS — payroll period definitions used by the time period formula.
• PA_PROJECTS_ALL — project definitions used when validating or displaying project context.
• GMS_AWARDS_ALL — award records referenced when the report includes grant-funded distributions.

Usage Notes

PSP_PSPRCPGD_XMLP_PKG is not an API intended for direct invocation by custom code. It is registered as the report package for the PSPRCPGD concurrent program and is invoked exclusively by the XML Publisher / concurrent manager engine when the report is run. It is referenced by zero other packages and exposes no public API surface for reuse. Customizations should not modify this package directly, since it is regenerated when the report definition is regenerated; extensions should instead be implemented through the underlying data template or report registration.