Search Results convert_defs




Overview
Explore in AI Chat

Overview

APPS.BEN_PEI_UPD2 is a PL/SQL package body belonging to the Oracle E-Business Suite Advanced Benefits (BEN) module. It operates within the standard Oracle HRMS API architecture, in which each entity is supported by a row handler (RHI), a shared definitions package (SHD), and an update/validation package. The BEN_PEI_UPD2 package supports the update processing logic for a benefits entity whose primary key is anchored on the pl_id column, with related identifiers plip_id and oipl_id. Its principal responsibility is the transformation of incoming API record structures so that system default markers submitted by a caller are replaced with the current values already stored in the database. This behaviour preserves existing column values whenever a caller does not explicitly supply new data, and it is a mandatory step in the standard BEN row handler flow before the record is passed to the downstream update logic. The package is classified under the generic "OTHER" API category in the ETRM repository, indicating that it is an internal implementation unit rather than a publicly documented business API.

Key Procedures and Functions

  • convert_defs — The single documented procedure in this package. It accepts the BEN shared record type ben_pei_shd.g_rec_type as an IN OUT NOCOPY parameter and examines each attribute for the presence of a system default. Where a system default is detected, the procedure substitutes the value held in the package's cached previous record, ben_pei_shd.g_old_rec. Attributes handled in this manner include pl_id, plip_id, oipl_id, third_party_identifier, organization_id, job_id, and position_id. Numeric attributes are compared against hr_api.g_number, while character attributes are compared against hr_api.g_varchar2. The procedure maintains an execution trace through hr_utility.set_location and builds its location string from the private global g_package constant. The header comment identifies the source file as bepeirhi.pkb.

Tables Accessed

The ETRM metadata for this package does not list any directly referenced tables accessed through APPS synonyms. Its data interaction is instead performed against the cached row buffer maintained by the companion shared package, BEN_PEI_SHD, specifically the g_old_rec record structure that holds the pre-update image of the entity. This design means that convert_defs performs no standalone SQL against the base benefits tables; the read of the current database row is the responsibility of the row handler that populates g_old_rec prior to invocation. The absence of documented table references is consistent with the helper nature of the procedure.

Usage Notes

This procedure is not intended for direct invocation by end users, forms, or concurrent programs. It is invoked internally by the benefits row handler as part of the standard API processing sequence, after the old row image has been loaded into the shared package and before validation and update logic execute. The ETRM metadata records that this package is referenced by one other package, confirming its role as a subordinate implementation unit within the BEN API stack. Custom code that calls the public benefits update APIs need not invoke convert_defs explicitly, because the row handler performs this step automatically. Developers extending or debugging the benefits API should be aware that the procedure mutates the passed record in place, so callers must treat g_old_rec as a read-only source and must not assume that unmodified attributes retain their original submitted values after the call completes. The package body carries the standard Oracle copyright header and revision identifier bepeirhi.pkb 120.0.