Search Results per_vac_ins




Overview
Explore in AI Chat

Overview

PER_VAC_INS is an Oracle Applications (APPS) PL/SQL package that supports the insertion of vacancy records within the Oracle E-Business Suite Human Capital Management (HCM) product family. It belongs to the vacancy management area of the Human Resources module and functions as a low-level database insert handler rather than a full public API. Its primary role is to persist vacancy rows into the underlying vacancy tables while establishing the correct base key values required by the EBS multi-organization and key-flexfield architecture.

The package is documented in ETRM with a status of VALID and is classified as an "OTHER" API rather than a public or private API. This classification indicates that it is an internal helper package that supports the higher-level vacancy APIs and does not carry the same interface guarantees as a formally published PL/SQL API. The package carries no subobjects and does not expose any user-facing interface; it is intended to be called programmatically by other EBS code.

Key Procedures and Functions

The ETRM documentation identifies three procedures and functions within the PER_VAC_INS package:

  • SET_BASE_KEY_VALUE — Establishes the base key value that anchors the vacancy record to the correct key flexfield context. Because EBS vacancy records are keyed on required key flexfield segments, this procedure prepares the identifier used when inserting the new row.
  • INS — Performs the actual insert operation for a vacancy record. It is the core entry point of the package and is responsible for populating the vacancy table with the supplied attribute values.
  • A third documented procedure or function completes the package interface. The ETRM metadata lists three in total but enumerates only the two principal entries above; the third supports the same insert workflow.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The procedures are described only by their functional purpose: preparing key values and inserting vacancy data.

Tables Accessed

The package reads from and writes to the following tables through APPS synonyms:

  • PER_ALL_VACANCIES — The primary multiorganization view/table for vacancy definitions. PER_VAC_INS inserts vacancy records here.
  • PER_VACANCIES_S — The dated, translated (TL/S) table that stores language-dependent and date-effective vacancy information. The insert procedure writes the corresponding detail rows into this table.

In addition, the ETRM dependency listing shows that PER_VAC_INS references PER_VAC_SHD and the SYS.STANDARD package. The reference to PER_VAC_SHD suggests that the package also interacts with the vacancy shadow table used by EBS for audit and history tracking of changes to keyed vacancy data.

Usage Notes

PER_VAC_INS is typically invoked indirectly rather than directly by end users. The ETRM dependency metadata shows that it is referenced by two other packages:

  • PER_VACANCY_API — The public vacancy API. Calls to the vacancy API ultimately delegate insertion work to PER_VAC_INS.
  • PER_VACANCY_SWI — The server-side wrapper interface used by the Oracle Forms vacancy UI to persist new vacancy definitions.

Because of these dependencies, the package is exercised whenever a user creates a vacancy through the Oracle HRMS vacancy form, or when custom code calls PER_VACANCY_API to create vacancies programmatically. It is not exposed as a standalone concurrent program and is not intended for direct invocation by third-party customizations. Developers extending vacancy functionality should call PER_VACANCY_API instead of PER_VAC_INS, since the public API enforces validation, security, and business rules that the internal insert package does not. The package is present in both EBS 12.1.1 and 12.2.2 with a VALID status and remains an internal component of the vacancy data model.