Search Results hrdpp_upload_salary_proposal




Overview
Explore in AI Chat

Overview

The APPS.HRDPP_UPLOAD_SALARY_PROPOSAL package is a PL/SQL database object in the Oracle E-Business Suite Applications (APPS) schema that supports the loading of salary proposal data into the Oracle Human Resources (HR) "batch pump" framework. Oracle HR deployments frequently require mass uploads of compensation data — for example, annual salary review outcomes, merit increases, or grade-based proposal entries — rather than manual data entry through the professional forms interface. The package provides the programmatic plumbing that takes staged salary proposal records and inserts them as batch lines within the HR Pump tables, allowing subsequent validation, error handling, and processing downstream. It is classified in ETRM as an OTHER API object, meaning it is not a formally published public API but a product-internal utility used by other HR components. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents seven procedures within the package. Their short identifiers reflect an internal naming convention rather than descriptive business terms:

  • DC, D, N, DD, ND — These abbreviated routines are internal helpers. Given the batch-line orientation of the package, they are used in the construction and population of batch line records and their associated keys. Names of this style are typically private to the package body and not intended for direct external calls.
  • INSERT_BATCH_LINES — The principal public routine. It performs the core business function of inserting salary proposal rows into the HR Pump batch line structures so that they may be processed by the standard HR pump mechanism.
  • CALL — A wrapper entry point that invokes the package logic, typically providing a single callable interface for callers that should not reference internal procedures directly.

No documented parameter lists exist in the metadata; callers should reference the PL/SQL package specification for exact signatures before invoking these routines from custom code.

Tables Accessed

The package reads and writes the HR Pump staging tables via APPS synonyms:

These tables are the standard staging structures of the HR batch pump, through which the HRMS product validates and commits bulk data.

Usage Notes

HRDPP_UPLOAD_SALARY_PROPOSAL is an internal dependency rather than a documented end-user API. The ETRM dependency map shows it is referenced only by the package itself and by PER_RI_CREATE_CRP_EMPLOYEE, indicating it is consumed indirectly, most likely during HR employee/compensation fast-formula processing. In practice it is not exposed through a standard concurrent program or self-service form; the salary proposal upload workflow visible to end users runs through the HR salary management forms and batch pump concurrent requests, which in turn call this package. Custom integrations that need to load salary proposals should prefer the supported batch pump loading interface or documented HR APIs and should treat direct calls to these routines as unsupported. Because the package writes into staging tables, any custom invocation must be followed by the standard validation and error-checking steps, with HR_PUMP_BATCH_EXCEPTIONS monitored for row-level failures.