Results for “pay_btl_rki”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_BTL_RKI is an Oracle EBS Payroll (PAY) schema package that functions as a row-level trigger implementation (RKI, or "Row Kind Implementation") for the PAY_BATCH_LINES entity. It is part of Oracle's generated table-handling API infrastructure, as evidenced by its header signature and the naming conventions typical of the pybtlrhi.pkh source file. The package body primarily exists to supply the transactional logic invoked when a row is inserted into the PAY_BATCH_LINES table — that is, the "after insert" processing for batch line records used within Oracle Payroll's Batch Element Entry (BEE) and Batch processing framework.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is standard for Oracle Applications seed data and ensures consistency with the APPS schema security model in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

• AFTER_INSERT — This is the row-level trigger handler invoked after a row is inserted into the batch lines table. It carries the full set of column values for the newly inserted record as input parameters, covering identifiers (session date, batch line ID, cost allocation keyflex ID, element type ID, assignment ID, batch ID), status and sequence fields (batch line status, batch sequence), descriptive attributes (assignment number, concatenated segments, effective date, element name, entry type, reason), the 30 analytical/segment attributes (segment1 through segment30), and the 11 descriptive value columns (value_1 through value_11). The procedure's role is to perform any post-insert validation, derived-value population, or downstream propagation that Oracle Payroll requires when a batch line is created.

Tables Accessed

The ETRM excerpt does not enumerate explicit table references accessed through APPS synonyms for this package. Based on its role as the row-kind implementation for batch lines, it operates against the PAY_BATCH_LINES table and, through the segment and value parameters, may reference the batch line segment/value storage structures that store the analytical context of a payroll batch entry. The procedure receives these values as parameters rather than resolving them itself, indicating the caller (the table-handling API layer) performs the actual DML.

Usage Notes

PAY_BTL_RKI is not intended for direct invocation by end users or custom code. It is invoked indirectly by the Oracle Payroll batch element entry framework — typically through the generated PAY_BATCH_LINES API and its corresponding table-handling triggers — whenever a batch line row is inserted during Batch Element Entry uploads, concurrent batch processing, or payroll batch import. The metadata notes that the package is referenced by one other package, consistent with its generated, dependency-bound nature. In both 12.1.1 and 12.2.2, the source header (pybtlrhi.pkh 120.2) confirms it belongs to the core Payroll batch processing code set. Customizations should avoid modifying this seeded package directly; extensions should instead target the supported API layer or use form-based personalization. The search context referencing "BNK캐피탈 300만원" (a Korean capital firm and a loan amount) is unrelated to this technical object and appears to be a mismatched user query.