Search Results pay_itr_rki

Overview

PAY_ITR_RKI is an Oracle E-Business Suite database package owned by the APPS schema, classified under Oracle's ETRM (E-Business Suite Technical Reference Manual) metadata as an "OTHER" API type. The name follows Oracle's standard naming convention for row-level trigger implementation packages: the suffix "RKI" denotes a Row-Kind Insert (RKI) handler, a construct used by Oracle Forms and the Oracle Toolbox (FTM) framework to encapsulate the INSERT logic for a specific base table. In Oracle EBS 12.1.1 and 12.2.2, RKI packages serve as the server-side component of the Form Trigger Management architecture, allowing the insert behavior of a form block to be executed through centralized PL/SQL rather than duplicated in form-level code. In this case PAY_ITR_RKI provides the insert processing for the PAY_ITR base table, which belongs to the Oracle Payroll (PAY) application family.

Key Procedures and Functions

The documented metadata for PAY_ITR_RKI identifies a single stored program unit:

• AFTER_INSERT — The row-kind insert handler invoked after an insert operation against the associated PAY_ITR base table. Its purpose is to execute post-insert processing logic required to keep the row consistent with Oracle Payroll's business rules, referential integrity expectations, and any dependent denormalized columns. In the ETRM 12.2.2 record, AFTER_INSERT is the only documented procedure or function for this package, which indicates that the insert logic is intentionally minimal and that the bulk of validation and derived-value calculation is performed elsewhere (for example, in the shadow "INS" package, PAY_ITR_INS, or in form-level triggers). No parameter lists are documented in the ETRM metadata, so callers should inspect the live package specification via USER_PROCEDURES/ALL_PROCEDURES or DBMS_METADATA before invoking it directly.

Because only a single procedure is documented, there is no evidence of overloaded or additional helper functions in the released version.

Tables Accessed

The ETRM dependency section for PAY_ITR_RKI does not enumerate any APPS synonym-backed tables directly; only SYS.STANDARD appears as a referenced object, which is the automatic PL/SQL standard package every compiled unit depends upon. The absence of documented table references is significant: it suggests that PAY_ITR_RKI does not itself perform DML against application tables, and instead delegates any such work to the companion insert package PAY_ITR_INS. The target table of the row-kind trigger is, by naming convention, PAY_ITR, a Payroll application table. Consumers requiring an authoritative list of table references should query ALL_DEPENDENCIES filtered on REFERENCED_OWNER = 'APPS' and NAME = 'PAY_ITR_RKI' in their specific instance, because dependency data can vary with patch level.

Usage Notes

PAY_ITR_RKI is not a general-purpose business API. It is invoked by the Oracle Forms framework through the row-kind trigger mechanism when a user creates a new record in a form block whose block-to-table mapping is PAY_ITR. The documented dependency chain shows that PAY_ITR_RKI is referenced by one other package, PAY_ITR_INS. This indicates that PAY_ITR_INS is the higher-level insert API and that PAY_ITR_INS calls PAY_ITR_RKI.AFTER_INSERT as part of its processing sequence, rather than the reverse. Customizations should therefore prefer invoking PAY_ITR_INS in place of PAY_ITR_RKI directly. The package is VALID in the documented 12.2.2 environment, so it is compiled and available. Because the metadata does not expose a public parameter specification, any direct call from custom code must first inspect the package header. In 12.1.1 and 12.2.2 the package resides in the APPS schema alongside the other PAY_ITR_* family members (PAY_ITR_INS and the associated table handler packages), and is shipped as part of the standard Oracle Payroll installation rather than as an optional or localized component.