Search Results per_vac_shd




Overview
Explore in AI Chat

Overview

PER_VAC_SHD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the Oracle Human Resources (PER) vacancy management infrastructure. The suffix "SHD" identifies it as a shadow or shadowing package associated with the PER_VACANCY tables and API family. In the Oracle EBS architecture, shadow packages and shadow tables are generated and maintained to support the specific requirements of an object's lifecycle — most notably the handling of multi-row operations and the recording of Who columns and DML audit context — alongside the primary business API.

Functionally, PER_VAC_SHD supports the vacancy management APIs that allow an organisation to define, amend and remove vacancies, and to link vacancies to recruitment activities. It is a supporting package rather than an end-user-facing entry point: it does not itself expose business functionality directly to forms but is consumed by the higher-level vacancy API packages. Its API classification in the ETRM repository is recorded as OTHER, indicating that it is not classified as a standard business API, and its status is VALID. The package is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents five procedures or functions within PER_VAC_SHD. Their names reflect the internal bookkeeping and DML-control responsibilities typical of a shadow package:

  • RETURN_API_DML_STATUS — Returns the DML status of the most recent API operation, allowing a calling package to determine whether data was inserted, updated or deleted successfully.
  • CONSTRAINT_ERROR — Handles constraint violation conditions raised during DML against the underlying vacancy tables, providing a controlled error path instead of an unhandled Oracle exception.
  • API_UPDATING — Indicates or tracks whether an API-driven update is currently in progress, guarding against re-entrant or conflicting DML within the same session.
  • LCK — Performs row-level locking on the vacancy records being processed, ensuring that concurrent API calls do not corrupt vacancy data.
  • CONVERT_ARGS — Converts or normalises incoming arguments prior to DML, aligning caller-supplied values with the storage and datatype expectations of the vacancy tables.

These procedures are described here by purpose only; the ETRM metadata does not publish their parameter signatures.

Tables Accessed

The package references the following objects through APPS synonyms:

  • ALL_CONSTRAINTS — Consulted to resolve constraint definitions, supporting the CONSTRAINT_ERROR handling logic so that violations can be identified and reported against the correct constraint.
  • PER_ALL_VACANCIES — The primary vacancy entity table. PER_VAC_SHD reads and writes this table as the shadow-layer handler for vacancy DML performed by the calling API packages.

The dependency listing additionally records a reference to the SYS.STANDARD package, which is the implicit PL/SQL base package present in all compiled units.

Usage Notes

PER_VAC_SHD is not invoked directly from Oracle Forms or concurrent programs. It is referenced by the vacancy API and business logic layer, specifically PER_VACANCY_API, PER_VAC_BUS, PER_VAC_DEL, PER_VAC_INS, PER_VAC_OVN and PER_VAC_UPD. These packages call PER_VAC_SHD as part of their insert, update, delete and validation processing, so the shadow package executes implicitly whenever vacancy records are maintained through the supported APIs.

Customisations should always call the documented vacancy APIs rather than PER_VAC_SHD directly, because the shadow package assumes pre-validated arguments and an established transactional context. Direct invocation bypasses the validation and business-rule enforcement performed by the parent API packages and risks producing inconsistent vacancy data.