Search Results cf_mismatch_eltformula

Overview

PSP_PSPRCLSL_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS and classified under the OTHER API category. It exists to support the Oracle Payroll "Payroll Run Costing / Salary and Labor Costing" report generated through the Oracle Reports XML Publisher (XMLP) engine, internally identified as PSPRCLSLS (Payroll Costing Salary / Labor). The package serves as the PL/SQL container for user-defined formula columns and report triggers used by that report template. It is declared with AUTHID CURRENT_USER and carries a header revision tag of 120.4 dated 2007/10/29.

The business purpose of the package is to supply the report's derived values: it resolves assignment numbers, person names and element names, formats and computes credit and debit amounts at the sub-ledger level, and evaluates whether debits and credits balance at the element, assignment, person and report aggregate levels. Global variables such as P_source_code, P_source_type, P_time_period_id, P_batch_name, P_CONC_REQUEST_ID, P_payroll_id, P_start_date and CP_credit_amount_sl bind concurrent program parameters and report-level accumulators to the formula logic.

Key Procedures and Functions

The 38 documented program units fall into several functional groups. The most relevant to the search term "cf_amt_sl_cformula" is the amount computation group, which includes CF_AMT_SL_CFORMULA (sub-ledger credit amount), CF_AMT_SL_DFORMULA (sub-ledger debit amount), CF_AMT_L_CFORMULA and CF_AMT_L_DFORMULA (ledger credit and debit amounts). These return numeric values derived from payroll line data.

• Lookup formulas: CF_ASSIGNMENT_NUMBERFORMULA, CF_PERSON_NAMEFORMULA, CF_ELEMENT_NAMEFORMULA and CF_ORGFORMULA resolve descriptive identifiers for reporting.
• Mismatch (reconciliation) formulas: CF_MISMATCH_ELTFORMULA, CF_MISMATCH_ASSGFORMULA, CF_MISMATCH_PERSONFORMULA and CF_MISMATCH_REPORTFORMULA compare ledger and sub-ledger debit/credit totals at different granularities and flag discrepancies.
• Formatting formulas: CF_CURRENCY_FORMATFORMULA, CF_CURRENCY_CODEFORMULA, CF_L_DEBIT_AMOUNT_DSPFORMULA and CF_L_CREDIT_AMOUNT_DSPFORMULA prepare amounts and currency values for display.
• Report triggers: AFTERPFORM and BEFOREREPORT control parameter validation and pre-report initialization.

Tables Accessed

The package reads the following APPS synonyms:

• PER_TIME_PERIODS — resolves the payroll time period associated with P_time_period_id.
• HR_ALL_ORGANIZATION_UNITS_TL — supplies translated organization/legal entity names for costing output.
• PSP_PAYROLL_CONTROLS — payroll definition and control information for the concurrent request.
• PSP_PAYROLL_LINES and PSP_PAYROLL_SUB_LINES — the payroll costing line and sub-line detail that drive the debit/credit amount formulas.

Usage Notes

This package is invoked exclusively by the Oracle Reports XML Publisher report executable PSPRCLSLS; it is not a public API and is referenced by zero other packages. Customizations should be limited to the report definition, as the functions and their signatures are generated and bound to the .rdf template. Any modification invalidates the report's compiled formula references.