Search Results hr_per_deplymt_eit_swi




Overview
Explore in AI Chat

Overview

The APPS.HR_PER_DEPLYMT_EIT_SWI package is a PL/SQL seed wrapper interface within the Oracle E-Business Suite Human Resources (HR) module. Its acronym — "PER_DEPLYMT_EIT_SWI" — identifies it as the deployment-related Extra Information Type (EIT) seed wrapper interface. EITs are the configurable, descriptive attributes that Oracle HRMS attaches to business objects (person, assignment, position, deployment, and others) to capture customer-specific data without schema changes. This package exists to programmatically seed, maintain, and remove deployment-level EIT definitions during the implementation or upgrade lifecycle, rather than requiring a functional administrator to enter them manually through the Standard EIT configuration forms.

The package is classified as API classification OTHER, indicating that it is not a public, supported business API for runtime transaction processing. It is an internal seed utility invoked by setup or diagnostic routines. In ETRM (E-Business Suite Technical Reference Manual) for release 12.2.2, the object is reported with status VALID in the APPS schema, and it declares both a package specification and package body.

Key Procedures and Functions

Three documented entry points exist in the package specification:

  • CREATE_PER_DEPLYMT_EIT — Creates (seeds) a deployment-level Extra Information Type definition. Typically invoked during a seeding pass to establish the EIT metadata that the HRMS EIT framework subsequently uses to render and validate extra information for deployment records.
  • DELETE_PER_DEPLYMT_EIT — Removes an existing deployment-level EIT definition. This provides the inverse operation, allowing cleanup or re-seeding after configuration changes.
  • PROCESS_API — The orchestrating routine that drives the create/delete logic. It is the conventional wrapper entry point through which the seeding operation is executed; the caller passes the operation context and the underlying HRMS API calls are performed.

No parameter signatures are published in the ETRM extract, so argument lists are deliberately not reproduced here. The procedures should be treated as internal, subject to change, and not as contractually supported interfaces.

Tables Accessed

The documented dependency list shows that HR_PER_DEPLYMT_EIT_SWI references APPS.HR_API as a package-level dependency and SYS.STANDARD as the PL/SQL standard package. Via APPS synonyms, it references the XMLDOM and XMLPARSER packages. These XML-related components indicate that EIT metadata used by this wrapper is expressed or transported as XML fragments, a pattern common in HRMS EIT seeding utilities where EIT definitions and their associated context/attribute structures are passed as XML documents.

The ETRM does not enumerate base HRMS tables (such as HR_EXTRA_INFO_TYPES or HR_EIT_*) in the documented dependency excerpt. The only direct package dependencies recorded are HR_API and STANDARD. Any persistent HRMS EIT tables are therefore accessed indirectly through HR_API rather than by direct SQL in this wrapper. The XMLDOM/XMLPARSER references confirm parsed XML input but do not, of themselves, indicate direct table DML.

Usage Notes

HR_PER_DEPLYMT_EIT_SWI is referenced by no other packages according to the documented metadata, and it is referenced by itself in the dependency listing, confirming its nature as a leaf-level wrapper with no downstream package consumers. It is not invoked by a standard concurrent program or form in the documented data.

In practice, packages of this family are called from setup scripts, patch drivers, or seeding utilities during HRMS implementation in both 12.1.1 and 12.2.2. Because it is classified OTHER and depends only on the private HR_API interface, custom code should not call it directly; alternative, supported configuration of EITs via the HRMS EIT setup forms or supported APIs is preferable. Any direct invocation risks breakage if the seed wrapper is changed or de-supported in a subsequent patch or upgrade.