Results for “hrdpp_update_emp_asg”

50+ results




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

Overview

The APPS.HRDPP_UPDATE_EMP_ASG package is a PL/SQL database object residing in the APPS schema within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its classification according to the E-Business Suite Technical Reference Manual (ETRM) is "OTHER," indicating that it is not exposed as a formally published public API but instead functions as an internal processing utility supporting Oracle Human Resources and Oracle Payroll data-pump operations. Its name, containing the fragment HRDPP (Human Resources Data Pump Process) and UPDATE_EMP_ASG (update employee assignment), indicates that its principal responsibility is the controlled updating of employee assignment records as part of the HR/Payroll data pump batch architecture.

The package operates directly against the HR_PUMP_BATCH_* table family, which underpins bulk data movements such as payroll consolidation, legislative data group migrations, and mass assignment corrections. It is marked VALID in the documented environment, confirming that it compiles cleanly and its dependencies (notably the SYS.STANDARD package) resolve correctly.

Key Procedures and Functions

The ETRM metadata documents seven procedures or functions within this package: DC, D, N, DD, ND, INSERT_BATCH_LINES, and CALL. The abbreviated single- and double-letter names are characteristic of internal helper routines that encapsulate logging, debugging, or validation logic. Their documented presence without parameter lists suggests they are private or semi-private units invoked from within the package body rather than by external callers.

INSERT_BATCH_LINES is the most functionally descriptive procedure: it is responsible for inserting row records into the HR_PUMP_BATCH_LINES and HR_PUMP_BATCH_LINES_S tables, thereby queuing employee assignment changes for subsequent processing by the data pump. CALL appears to serve as the orchestration entry point that sequences the helper routines and the batch-line insertion. Per the documentation, no parameter signatures are published, and parameter lists should not be assumed.

Tables Accessed

The package references five tables through APPS synonyms: HR_PUMP_BATCH_EXCEPTIONS, HR_PUMP_BATCH_LINES, HR_PUMP_BATCH_LINES_S, HR_PUMP_BATCH_LINE_USER_KEYS, and HR_PUMP_BATCH_LINE_USER_KEYS_S. HR_PUMP_BATCH_LINES and its _S sibling store the primary staging rows for pending assignment updates, with the _S variant holding the corresponding set/denormalized rows. HR_PUMP_BATCH_EXCEPTIONS captures error and rejection records generated when a queued update fails validation or processing. The two HR_PUMP_BATCH_LINE_USER_KEYS tables hold surrogate user-key mappings used to reconcile source records with their target assignments. Collectively these tables constitute the staging, error-handling, and key-resolution layers of the HR data pump.

Usage Notes

This package is referenced by three other packages: PER_RI_CREATE_CRP_EMPLOYEE, PQP_HROSS_INTEGRATION, and PQP_PERASGADD_RIW, and it also references itself. These callers belong to Oracle HR and Oracle Payroll integration flows, notably the HROSS (HR Operational Shared Services) integration and the assignment-add row-handler interface. Consequently, HRDPP_UPDATE_EMP_ASG is invoked indirectly during bulk employee-assignment changes driven by concurrent programs and integration processes rather than from a standard Oracle Forms interface. Custom code should avoid calling this package directly, since its interface is undocumented and subject to change; developers requiring assignment updates should instead use supported public APIs such as hr_assignment_api.update_emp_asg.