Search Results hr_pde_ins




Overview
Explore in AI Chat

Overview

HR_PDE_INS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that implements the insert-side record interface for the Person Deployment Extra Information Types (EIT) entity. In the EBS architecture, this package belongs to the family of automatically generated table handlers produced by the Oracle Designer-style PL/SQL generation utilities, as evidenced by its header signature and internal naming conventions. Its business purpose is to accept a fully validated row of person deployment EIT data from a calling process and persist it into the HR schema, returning any system-generated values such as the primary key and object version number back to the caller. This pattern isolates the physical insert logic from the calling application, ensuring consistent enforcement of validation rules, key derivation, and audit column population across all channels that create person deployment EIT records.

Key Procedures and Functions

The documented interface exposes two procedures, both classified under the package's "Internal Development Use Only" access status:

  • SET_BASE_KEY_VALUE — Registers the next unique identifier value derived from the database sequence associated with the person deployment EIT entity. This procedure establishes the base primary key value that the subsequent insert operation will use, ensuring that system-generated identifiers remain unique and consistent with the HR schema's key generation strategy.
  • INS — The main record interface for the insert process. Per the documented processing flow, it first invokes the controlling validation process (insert_validate), which executes all private and public validation business rules. It then runs the pre_insert business process, allowing any logic to be executed before the insert DML. Finally, it performs the insert against the HR schema and passes back system-generated values to the calling process. This procedure forms the backbone of the insert operation for the entity.

The ETRM metadata records three documented procedures or functions in total, with SET_BASE_KEY_VALUE and INS comprising the principal documented interface.

Tables Accessed

The package operates against two documented tables, accessed through APPS synonyms:

  • HR_PERSON_DEPLYMT_EITS — The primary base table holding person deployment extra information type records. This is the target of the insert DML performed by the INS procedure.
  • HR_PERSON_DEPLYMT_EITS_S — The corresponding sequence object used by SET_BASE_KEY_VALUE to generate the next primary key value for new rows.

These tables belong to the HR schema and store deployment-related EIT data associated with persons in the HRMS data model. The package reads the sequence to derive keys and writes the validated row into the base table.

Usage Notes

HR_PDE_INS is marked "Internal Development Use Only," meaning it is not intended as a public integration point for customer extensions. It is typically invoked indirectly rather than called directly by end users or custom code. In the standard EBS flow, the package is called by higher-level business logic — commonly the generated entity handler or an enclosing API — which supplies already-validated attribute values. The referenced-by count of two other packages in the ETRM metadata confirms this layered invocation pattern. Because the package assumes full validation has occurred upstream and performs no partial or deferred validation of its own beyond insert_validate, custom code should avoid direct invocation unless it fully replicates the expected calling contract. When custom integrations must create person deployment EIT records, the recommended approach is to route through the supported public API or the standard form that ultimately delegates to this package, preserving key generation and audit behavior. The package is available in both Oracle EBS 12.1.1 and 12.2.2, with the documented header revision indicating a stable, long-standing implementation.