Search Results pay_batch_lines_s

Overview

The APPS.PAY_BTL_INS package body is a server-side PL/SQL component within the Oracle E-Business Suite Payroll (PAY) module. Its designation as an "Insert" handler, together with its dependency on the PAY_BATCH_LINES and PAY_BATCH_LINES_S tables, identifies it as the table handler responsible for coordinating insert operations against the batch lines entity in the Payment Batches schema. In Oracle EBS, batch lines represent the individual payment instructions grouped under a parent batch header; the rows inserted here drive the downstream payment process, including payment creation, reconciliation, and eventual disbursement to third parties.

The package is classified under an API classification of "OTHER," meaning it is not a public, user-facing application programming interface intended for external integration. Instead, it functions as an internal construction utility invoked by other payroll processing packages. It is a valid, compiled object in the APPS schema on both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented metadata identifies a single procedure belonging to this package:

• INS — The primary insert handler. Its purpose is to perform the physical insertion of a new row into the batch lines entity, applying the standard Oracle EBS table handler pattern (row initialization, attribute defaulting, and validation hooks prior to the DML operation). This procedure is the core entry point through which new batch line records are materialized in the database. As documented, it relies on the companion packages PAY_BTL_BUS, PAY_BTL_RKI, and PAY_BTL_SHD to complete business-rule processing, primary key derivation, and shadow-row maintenance respectively. Parameter lists are intentionally not reproduced here, as the ETRM metadata does not expose them; consult the package specification for the exact signature.

The "2 total" count of documented procedures refers to the declaration and its implementation context; functionally, only the INS routine is exposed for invocation.

Tables Accessed

Through APPS synonyms, the package references the following documented tables:

• PAY_BATCH_LINES — The base transactional table storing individual batch line records. The INS procedure writes new rows here, supplying the batch line identifier and associated attributes validated against the parent batch.
• PAY_BATCH_LINES_S — The shadow/audit table used by Oracle EBS table handlers to capture the pre- and post-change images of a row. Every insert through PAY_BTL_INS is mirrored into this table by the associated shadow package (PAY_BTL_SHD), preserving an auditable history of batch line creation.

Additional non-table dependencies include HR_API and HR_UTILITY (shared utility and API-error handling routines), DUAL, and the STANDARD package, which are typical of any EBS table handler.

Usage Notes

Because PAY_BTL_INS is classified as "OTHER" and is not referenced by any database object other than its own package family, it should be regarded as a private internal handler rather than a supported integration point. It is typically invoked by the higher-level business logic in PAY_BTL_BUS, which itself may be called from the Payment Batches maintenance forms, the batch import interfaces, or concurrent programs that build payment batches from payroll run results.

The search term pay_batch_lines_s confirms that developers investigating this object are usually tracing how batch line audit rows are generated. Custom code should avoid calling PAY_BTL_INS.INS directly; instead, use the sanctioned PAY_BTL_BUS layer or the corresponding public batch APIs, which enforce validation, security, and date-tracked (WHO column) population consistently. Direct invocation risks bypassing defaulting and shadow-table logic and may produce orphaned or unreconcilable batch lines.