Search Results hrdpp_update_in_location




Overview
Explore in AI Chat

Overview

HRDPP_UPDATE_IN_LOCATION is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its ETRM classification is OTHER, indicating that it is not a published, supported public API intended for direct customer invocation, but rather an internal utility that supports the HR data pump framework used by Oracle HRMS. The HRDPP prefix associates the package with the HR Data Pump Processing (HRDPP) family of programs, which manipulate intermediate staging tables during bulk loads into Oracle HRMS. The package name itself, referencing an "in location" update, reflects its role in refreshing or synchronising location-related batch line data while a pump batch is being staged or processed.

The package is reported as VALID in the ETRM repository and references only SYS.STANDARD in its dependency list, confirming that it is a self-contained PL/SQL unit that relies on no external packaged APIs. Conversely, the dependency report shows it is referenced by itself under APPS, and no other packages reference it, meaning it sits at the leaf of the HRDPP dependency tree and is invoked only through its own entry points or directly by concurrent processing logic.

Key Procedures and Functions

Seven procedures and functions are documented for this package. The abbreviated names suggest compact internal utilities rather than business-facing APIs, and their parameter lists are not published for external use.

  • CALL — The principal entry point that drives the package's processing logic, coordinating the remaining routines to perform the in-location update operation on a pump batch.
  • DC — A deletion routine, most likely a "delete child" or "delete current" operation that removes dependent batch line records.
  • D — A general deletion routine that purges rows associated with the update operation, typically the parent batch line records.
  • N — A routine whose single-letter name indicates a normalisation or new-record handler, responsible for installing updated values.
  • DD — A paired deletion routine operating on the detailed or dependent level of the staging hierarchy.
  • ND — A paired normalisation/insert routine that repopulates detail records after deletion.
  • INSERT_BATCH_LINES — An explicitly named routine that inserts new rows into the pump batch line tables, forming the core write operation of the package.

Tables Accessed

The package operates against five HR Pump staging tables, accessed through APPS synonyms:

Usage Notes

Because HRDPP_UPDATE_IN_LOCATION is classified as OTHER and is referenced by no other packages, it should be treated as an internal implementation component of the HR data pump. It is typically invoked indirectly, either by the HRDPP concurrent programs that load HRMS data or by parsing routines that stage records before validation. It is not intended for direct calls from customer forms or custom PL/SQL. Developers requiring location-related bulk update behaviour should use supported Oracle HRMS APIs instead, and any direct interaction with these pump tables should be confined to controlled migration or diagnostic scenarios, with full testing in a cloned environment before production use.