Search Results log_asg_chg

Overview

APPS.BEN_EXT_CHLG (Benefit Extract Change Log) is an Oracle E-Business Suite PL/SQL package that records change events for the Benefits extract process. Its declared purpose, per the package header, is "to log changes for benefit extract." Benefits extract programs must identify which participants, assignments, dependents, contacts, and related entities have changed since a prior extraction run so that downstream systems — carriers, third-party administrators, and payroll interfaces — receive only the delta rather than a full population. BEN_EXT_CHLG provides the logging mechanism that captures these changes into a staging log table for later consumption.

The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the package owner. It is classified as OTHER in the ETRM metadata and is referenced by 23 other packages, confirming its role as a widely shared utility within the Benefits extract subsystem. The header history shows incremental expansion of the change-event set over many releases, beginning in 1998 and continuing through 2009.

Key Procedures and Functions

The documented interface consists of 19 procedures, each corresponding to a distinct change-event category. They are uniformly named with a LOG_*_CHG convention, where the embedded token identifies the entity being logged:

• LOG_DEPENDENT_CHG — logs changes to a participant's dependents; this is the procedure associated with the search term "log_dependent_chg" and was added in version 115.13 (26 Jan 1999).
• LOG_PER_CHG, LOG_PER_PAY_CHG, LOG_PER_DIS_CHG — log person-level changes, person pay (base salary) changes, and person disability changes respectively.
• LOG_ASG_CHG — logs assignment changes.
• LOG_BENEFIT_CHG — logs benefit enrollment and election changes; added in version 115.5.
• LOG_ABS_CHG — logs absence change events; added in version 115.9.
• LOG_CONT_CHG — logs contact changes, supported by the g_cont_type global added in version 115.16.
• LOG_ADD_CHG, LOG_PHN_CHG — log address and phone changes.
• LOG_POS_CHG — logs position changes.
• LOG_APL_CHG — logs applicant/application changes.
• LOG_PTU_CHG — logs person type usage changes.
• LOG_PCP_CHG — logs person/contact point changes; associated with globals introduced in version 115.14.
• LOG_ELEMENT_CHG — logs element entry changes; added in version 115.15.
• LOG_SCHOOL_CHG, LOG_PREM_MO_CHG — log school changes and premium-by-month changes; both added in version 115.20.

Each procedure writes a row describing the changed entity to the change-event log, with later versions extended to capture new and old values (version 115.10) and ANSI-required attributes (version 115.18).

Tables Accessed

The package reads from and writes to the following documented objects:

• BEN_EXT_CHG_EVT_LOG — the primary target table; change events are inserted here for the extract process to consume.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_PERSON_TYPE_USAGES_F — person, assignment, service, and person-type source data used to detect and describe changes.
• PER_ADDRESSES, PER_PHONES, PER_CONTACT_RELATIONSHIPS — contact point and relationship data underlying address, phone, contact, and dependent logging.
• PER_ABSENCE_ATTENDANCES, PER_ESTABLISHMENT_ATTENDANCES — absence and attendance records for absence change logging.
• PER_PAY_PROPOSALS — salary proposal data for base salary change logging.
• PER_DISABILITIES_F, PER_APPLICATIONS — disability and application data.
• BEN_PRTT_PREM_BY_MO_F, BEN_BENFTS_GRP — participant premium-by-month and benefits group data used by premium and benefit change logging.

Usage Notes

BEN_EXT_CHLG is not an end-user-facing API. It is invoked programmatically by the Benefits extract machinery and by the 23 dependent packages that reference it. Typical invocation points include benefits extract concurrent programs, which call the relevant LOG_*_CHG procedure as each participant record is evaluated, and custom or extension code that needs to register a change event in the same format as the standard extract. Because the package relies on AUTHID CURRENT_USER, callers must have the necessary privileges on the underlying PER and BEN tables. Implementers extending extract logic should call the specific procedure matching the changed entity rather than writing directly to BEN_EXT_CHG_EVT_LOG, ensuring consistency with the standard event structure and column set.