Search Results hrdpp_create_qualification_typ




Overview
Explore in AI Chat

Overview

The APPS.HRDPP_CREATE_QUALIFICATION_TYP package is a PL/SQL program unit owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the Human Resources "HRDPP" (HR Data Pump / Person and Position) family of utilities, and more specifically with the creation of qualification type records within the HR data model. In Oracle EBS, the HRDPP modules support bulk data loading of HR entities—people, assignments, competencies, and related qualification data—through a staging and validation mechanism known as the HR pump. This package participates in that framework by providing the programmatic logic that creates qualification type definitions and stages them for processing.

Within the documented ETRM metadata, the package is classified as an "OTHER" API, meaning it is not a public, externally supported interface intended for customer extension, but rather an internal utility invoked by the HR data pump infrastructure. It carries a VALID status in both 12.1.1 and 12.2.2, confirming its continued presence and resolution across releases.

Key Procedures and Functions

The package exposes seven documented program units. Their names are terse, reflecting internal design conventions:

  • DC — an internal routine associated with the create/processing flow for qualification type data.
  • D — a helper routine used within the package's processing sequence.
  • N — a further internal helper supporting the creation workflow.
  • DD — an internal routine contributing to validation or data handling.
  • ND — an internal routine complementing the other helpers in the processing sequence.
  • INSERT_BATCH_LINES — the principal procedure for inserting records into the HR pump batch lines staging table, establishing the rows that downstream processing will consume.
  • CALL — the entry point that orchestrates invocation of the package's logic, typically acting as the wrapper the pump framework calls.

Because the ETRM metadata documents only names and no parameter lists, parameter signatures should be obtained from the source in the APPS schema rather than inferred. Users should not construct direct calls based on assumptions about argument order or types.

Tables Accessed

The package reads and writes the HR pump staging tables, all accessed through APPS synonyms:

The "_S" suffixed tables represent the sequence/identifier components of the corresponding base tables. Collectively, these objects form the standard HR pump batch structure.

Usage Notes

This package is an internal component of the HR data pump framework and is not documented as a supported public API. It is typically invoked indirectly—through the HR pump concurrent programs, batch upload processes, or higher-level HRDPP packages that manage the overall load—rather than called directly from custom code. Because it is referenced by no other documented packages and is classified as "OTHER," direct invocation is discouraged; customers requiring qualification type loading should use the supported HR data pump interfaces. Developers inspecting the package should review the source in the APPS schema for accurate signatures, since the ETRM metadata provides names only.