Search Results before_dml

Overview

APPS.PER_EMPDIR_LOCATIONS_OVERRIDE is a small, specialized PL/SQL package body belonging to the Oracle E-Business Suite Human Resources employee directory (EmpDir) module. Its documented header comment identifies the source file as peredcor.pkb, version 115.1, last modified in August 2003. The package exists to provide a controlled override mechanism for location data processed by the employee directory integration. In the EBS 12.1.1 and 12.2.2 releases this object is classified as an OTHER API rather than a public interface, meaning it is intended for internal use by the employee directory synchronization framework rather than for direct invocation by customer extensions.

Key Procedures and Functions

The ETRM metadata documents two callable units within this package body:

• ISOVERRIDEENABLED — A function that returns a Boolean indicating whether location override processing is currently active. It is driven by the package-level variable g_override_flg, which is initialized to FALSE at package load. Callers use this function to determine whether override logic should be applied before passing location data downstream.
• BEFORE_DML — A procedure that serves as the pre-DML hook for the employee directory location override process. It accepts the standard concurrent-program error buffer and return code, together with context values including an effective date, a count, a record locator, and a source system identifier. In the documented implementation the executable body is essentially a no-op, with a NULL statement occupying the main block. The exception handler appends the SQL error message to the error buffer, sets the return code, and writes diagnostic entries through PER_EMPDIR_SS.WRITE_LOG.

Tables Accessed

The supplied documentation records no direct table references through APPS synonyms for this package body. This is consistent with the source excerpt, which contains no SQL DML statements. The only database interaction evidenced is the call to the logging routine PER_EMPDIR_SS.WRITE_LOG, an error-handling utility rather than a data access path. The package therefore does not itself read or write employee directory location rows; the actual data manipulation is delegated to the broader employee directory synchronization logic that invokes BEFORE_DML.

Usage Notes

BEFORE_DML is not a general-purpose API. It is invoked as a callback within the employee directory data pipeline, most likely from a concurrent program or from code generated for the EmpDir integration, at the point immediately preceding a location insert or update. The parameters p_eff_date, p_cnt, p_rec_locator, and p_srcSystem allow the override layer to identify which source record and source system are being processed at a given effective date. The override flag toggled through ISOVERRIDEENABLED provides a switch that allows site-specific override behavior to be enabled or disabled without modifying the calling framework.

The ETRM metadata also records that this package is referenced by one other package, confirming its role as a subordinate component rather than a top-level entry point. Because the documented BEFORE_DML body performs no substantive work and only traps errors, any site requiring genuine override behavior must rely on the package-level state managed elsewhere, or on a customized version of this package. In upgrade paths from 12.1.1 to 12.2.2 the object should be reviewed for customizations, since modifying a seeded package body can be overwritten during patching. The signature is intentionally stable and no direct calls from forms or user-facing concurrent programs are documented.