Search Results cf_total_valueformula

Overview

PAY_PYAULLAL_XMLP_PKG is an Oracle E-Business Suite package owned by the APPS schema and classified under ETRM as API classification OTHER. It is the generated PL/SQL placeholder package associated with a concurrent program XML Publisher (BI Publisher) report — the "py" prefix and "XMLP_PKG" suffix conform to the naming convention Oracle uses when a report definition is registered and its corresponding package is auto-generated to expose report-level parameters and formulas. The report in question pertains to a payroll-related listing, most likely a payroll/allocation listing driven by the cost allocation key flexfield.

The package is not a business API; it holds no application logic beyond what the report template and its data model require. Its role is to declare global variables that carry user-entered parameters into the report query and to expose functions that format or transform values used in the report's computed (CF) columns. Globals such as P_BUSINESS_GROUP_ID, P_PAYROLL_ACTION_ID, P_CONC_REQUEST_ID, and P_PAYROLL are populated from the concurrent program parameter form at run time. Output-side globals CP_CURRENCY_FORMAT, CP_CURRENCY_CODE, and CP_PRECISION carry currency-presentation settings back to the XML Publisher template.

Key Procedures and Functions

The package declares the following documented procedures and functions, invoked by the Oracle Reports/XML Publisher runtime rather than by user code:

• BEFOREREPORT — Executes before the report's main query fires, initialising globals and any derived values required by the report.
• AFTERREPORT — Executes once after the report output has been produced, typically for cleanup or final assignment of globals.
• CF_TOTAL_VALUEFORMULA — A computed-column formula returning a total derived from an entitlement value and an accrual value.
• CF_BUSINESS_GROUP_IDFORMULA — Resolves the business group identifier into its displayable form for the report layout.
• CF_PAYROLL_ACTIONFORMULA — Returns the descriptive payroll action text corresponding to the selected payroll action.
• CF_PAYROLLFORMULA — Returns the payroll name or description for the selected payroll.
• CF_COST_CENTREFORMULA — Returns the cost centre text derived from the cost allocation key flexfield.
• CP_CURRENCY_FORMAT_P — Returns the currency display format for the report.
• CP_CURRENCY_CODE_P — Returns the currency code in use for the report output.
• CP_PRECISION_P — Returns the numeric precision applied to monetary columns. This is the element users reference when they search on "cp_precision_p", which drives decimal-place behaviour in currency formatting within the report template.

Tables Accessed

The package's query logic resolves the following objects through APPS synonyms:

• FND_CURRENCIES — Supplies currency code and format details that populate CP_CURRENCY_CODE and CP_PRECISION.
• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION — Provide business group and organisational context for the report parameters and their descriptive formulas.
• PAY_PAYROLL_ACTIONS — Supplies payroll action records, feeding the payroll action formula and the P_PAYROLL_ACTION_ID parameter.
• PAY_COST_ALLOCATION_KEYFLEX — Supplies cost allocation key flexfield data used by the cost centre formula.

Usage Notes

PAY_PYAULLAL_XMLP_PKG is invoked exclusively by the concurrent program it belongs to; no other package references it, and it appears in ETRM as referenced by zero packages. It should not be called from forms, custom PL/SQL, or other concurrent programs. Customisations to report output should be made in the XML Publisher template or the underlying data model, not by modifying this generated package, since Oracle may regenerate it during patching or upgrade in 12.1.1 or 12.2.2.