Search Results pay_batch_headers_s

Overview

PAY_BTH_INS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It is classified as an "OTHER" API within the Oracle Payroll (PAY) module and serves as the primary insert-handler routine for payroll batch header records. The package encapsulates the logic required to create new rows in the PAY_BATCH_HEADERS entity, coordinating the insertion of the base table record alongside its associated "_S" (shadow or audit) record and enforcing the business rules that govern valid batch header creation. As an internal (non-public) utility, PAY_BTH_INS is not exposed to external callers; it is instead invoked by higher-level payroll batch processing code, most notably the PAY_BTH_BUS business layer, which acts as a gatekeeper before delegating the physical insert to this package. The package body is documented as VALID in the ETRM 12.2.2 repository, confirming that its compiled state is consistent with the dependent objects it references.

Key Procedures and Functions

The ETRM metadata documents two procedures/functions, with the primary documented entry point named INS. The INS procedure performs the insertion of a new payroll batch header. Its responsibilities include populating the mandatory columns of the base PAY_BATCH_HEADERS record, propagating the corresponding audit row into PAY_BATCH_HEADERS_S, and invoking the HR_API and HR_UTILITY utilities for standard Oracle HRMS API bookkeeping such as WHO-column population, primary-key generation, and validation of the originating business group. The second documented routine supports the same insertion flow, providing an internal helper path used by INS. Parameter lists are deliberately not enumerated here, as the ETRM documentation does not expose them; consumers should treat INS strictly as an internal insert primitive rather than a directly callable public API.

Tables Accessed

The package operates against two documented tables, both referenced through APPS synonyms. PAY_BATCH_HEADERS is the primary batch header entity and is the target of the INSERT performed by INS. PAY_BATCH_HEADERS_S is the shadow/audit table that mirrors the base record; the insert path writes a matching row there so that downstream audit and change-tracking processes have a consistent history. In addition to these core tables, the dependency list records use of DUAL and STANDARD from the SYS schema, which is consistent with the internal PL/SQL constructs and sequence/lookup logic embedded in the handler.

Usage Notes

PAY_BTH_INS is intended for internal consumption only and should not be called directly from custom code. The documented dependency graph shows it is referenced by one other package, PAY_BTH_BUS, which orchestrates payroll batch header business logic and is the recommended integration point for any extension. The package also interacts with PAY_BTH_RKI (the row-insert kernel trigger package) and PAY_BTH_SHD (the shadow-table maintenance package), meaning insert operations here should be expected to cascade into trigger-driven audit activity. Because it is not referenced by any database object according to the ETRM report, there is no external caller surface; nevertheless, DBA scripts, bulk loaders, or remediation utilities that manipulate PAY_BATCH_HEADERS directly must respect the validation and audit semantics enforced by this handler. When troubleshooting batch creation errors in EBS 12.1.1 or 12.2.2, the package body for PAY_BTH_INS is a primary object to inspect for constraint and WHO-column related failures.