Search Results c_batch_name

Overview

PSP_NON_ORCL_RLBK_PKG is a PL/SQL package body owned by APPS in Oracle E-Business Suite. It supports the Payroll (PSP) module by managing the rollback of payroll batch records that were not sourced from Oracle Payroll. The package falls under the ETRM API classification of OTHER, indicating it is an internal utility rather than a published open interface. Its principal role is to validate and reverse non-Oracle payroll control records associated with a given batch, business group, and set of books before any downstream processing proceeds. The package header comment ($Header: PSPNORBB.pls 115.11 2002/11/18 11:54:44 ddubey ship $) confirms it is a long-standing shipped object, and the source registers references across several payroll tables, reflecting its integration into the core payroll data flow.

Key Procedures and Functions

• CHECK_ROLLBACK — The single documented procedure in the package. It accepts a batch name, a business group identifier, and a set of books identifier, then drives the rollback logic. Internally it opens CURSOR cursor_batch to retrieve distribution debit and credit amounts and the payroll control identifier from PSP_PAYROLL_CONTROLS, filtering on the supplied batch name, a status code of 'N', the business group, and the set of books. For each matching record, the procedure evaluates whether both distribution amounts are null, which signals that no accounting distribution has yet been posted. When that condition holds, it delegates to the private helper CHANGE_RECORDS and returns a success status via FND_API.G_RET_STS_SUCCESS, printing a success message through PSP_MESSAGE_S. When distribution amounts exist, it raises the PSP_NON_ORCL_RLBK message with the batch name token and raises FND_API.G_EXC_UNEXPECTED_ERROR. A NO_DATA_FOUND handler emits PSP_NON_ORCL_RLBK_EXCP, reporting that no matching batch exists. Error handling throughout uses the FND_MSG_PUB and FND_MESSAGE stack, which is the standard Oracle EBS messaging convention.

Tables Accessed

• PSP_PAYROLL_CONTROLS — The primary table read by CHECK_ROLLBACK. It supplies batch_name, status_code, business_group_id, set_of_books_id, payroll_control_id, dist_dr_amount, and dist_cr_amount, forming the basis for eligibility decisions.
• PSP_PAYROLL_INTERFACE — Referenced as part of the rollback data set, holding staged payroll interface rows subject to reversal.
• PSP_PAYROLL_LINES and PSP_PAYROLL_SUB_LINES — Referenced for the line-level detail associated with the batch, ensuring that rollback cascades through the payroll hierarchy.

All tables are accessed through APPS synonyms, consistent with standard EBS coding practice.

Usage Notes

The package is invoked internally when a non-Oracle batch must be unwound, typically from payroll batch maintenance forms or from concurrent programs that process payroll controls. The presence of the c_batch_name parameter, echoed in the user search, confirms that callers must supply a batch name alongside the business group and set of books context. Because ETRM records no downstream packages referencing this object, it should be treated as a terminal utility rather than a reusable API. Direct invocation from custom code should be avoided, as the FND message stack expectations and the reliance on null distribution amounts impose preconditions that are not enforced outside the package. Developers investigating the c_batch_name parameter should examine CHECK_ROLLBACK and the private CHANGE_RECORDS helper together, since the two procedures coordinate the full rollback. The package operates within the same 12.1.1 and 12.2.2 code lines without documented behavioral differences.