Search Results hr_person_deployment_api




Overview

The APPS.HR_PERSON_DEPLOYMENT_API package is a server-side PL/SQL API in Oracle E-Business Suite that governs the creation and maintenance of person deployments. In Oracle HRMS, a deployment captures the movement of an employee away from their primary assignment for a defined period, such as a temporary assignment, secondment, or long-term business trip. This package provides the programmatic interface through which deployment records are created, modified, initiated, date-adjusted, and closed out on return.

The package resides in the APPS schema and is classified as a public API within the ETRM (E-Business Suite Technical Reference Manual) metadata. It is reported with a status of VALID and is a dependency of HR_PERSON_DEPLOYMENT_SWI, the server-side wrapper that exposes deployment functionality to the forms layer. The API is built on the standard HR API infrastructure through a dependency on APPS.HR_API, meaning it inherits the expected conventions for date-tracked entity handling, validation, and business-group security.

Key Procedures and Functions

The ETRM metadata documents six callable units within the package. A recurring convention is that each returns the deployment record identifier or status of the operation rather than performing direct DML against the base tables.

  • CREATE_PERSON_DEPLOYMENT — Creates a new deployment record for a person, associating the deployment with an organization unit and the applicable deployment dates and assignment context.
  • UPDATE_PERSON_DEPLOYMENT — Modifies the attributes of an existing deployment, such as the destination organization or related descriptive information.
  • DELETE_PERSON_DEPLOYMENT — Removes a deployment record, subject to the validation rules imposed by the HR API framework.
  • INITIATE_DEPLOYMENT — Marks the start of the deployment, transitioning the record into an active state so it is effective for the deployment period.
  • CHANGE_DEPLOYMENT_DATES — Adjusts the start and/or end dates of an existing deployment while preserving the integrity of the underlying date-tracked records.
  • RETURN_FROM_DEPLOYMENT — Closes the deployment and returns the person to their home assignment, recording the end of the deployment period.

Tables Accessed

The package reads and writes a range of HRMS and related tables, largely through APPS synonyms. The core storage table is HR_PERSON_DEPLOYMENTS, with supporting tables HR_PERSON_DEPLYMT_CONTACTS and HR_PERSON_DEPLYMT_EITS holding deployment contacts and extra information types respectively.

Person and assignment data is validated against PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, while assignment statuses and periods of service are resolved through PER_ASSIGNMENT_STATUS_TYPES and PER_PERIODS_OF_SERVICE. Organizational context comes from HR_ALL_ORGANIZATION_UNITS, and payroll grouping from PAY_PEOPLE_GROUPS. Related data such as PER_CONTACT_RELATIONSHIPS, PER_PEOPLE_EXTRA_INFO, and HR_SOFT_CODING_KEYFLEX are referenced as the deployment definition requires. Attachment handling uses FND_ATTACHED_DOCUMENTS, and PLITBLM supplies the standard PL/SQL table handling used by HR APIs.

Usage Notes

In standard Oracle EBS usage, this package is not called directly by end users but is invoked indirectly. The deployment maintenance form calls into HR_PERSON_DEPLOYMENT_SWI, which in turn delegates to this API. Customizations and integrations that must create or amend deployments should call the API rather than inserting into HR_PERSON_DEPLOYMENTS directly, ensuring all validations and date-tracked side effects are applied.

Typical callers include custom Oracle Forms, concurrent programs, and interface programs that load deployment data from external systems. Because the package depends on HR_API, callers must observe the standard HR API conventions, including business-group context and effective-date handling, when passing values into the deployment routines.