Search Results per_vacancies_s

Overview

PER_VAC_INS is a private PL/SQL package body owned by the APPS schema that implements the vacancy insertion logic for Oracle Human Resources (Oracle HRMS). It forms the backbone of the vacancy management feature, allowing an enterprise to record open positions (vacancies) against which applicants and applicants pools can be tracked and later filled. In Oracle EBS 12.1.1 and 12.2.2, vacancy records are surfaced primarily through the "per_vacancies_s" base table and the PER_ALL_VACANCIES view, and the URL fragment "per_vacancies_s" typically indicates the underlying table behind the Vacancies window in the Oracle Forms-based HRMS UI. The package encapsulates the business rules and DML required to create and maintain these rows, insulating the calling forms and APIs from the complexity of the row-level security, validation, and who-column bookkeeping required by the HR schema.

Key Procedures and Functions

• SET_BASE_KEY_VALUE — Establishes the base key value for the vacancy row being processed. It prepares the primary key/context that the downstream insert logic expects, ensuring the vacancy identifier is populated consistently before the record is committed.
• INS — The core insert routine. It performs the DML that creates a vacancy record and its dependent rows, invoking validation and derived-value logic through the HR business rule helpers, then persisting the result into the vacancy tables. This is the workhorse procedure of the package.

Package metadata for ETRM 12.2.2 documents three procedures/functions in total; the third is a private helper supporting the two above. Parameter lists are not part of the public contract and should not be assumed.

Tables Accessed

• PER_VACANCIES_S — the secured base table holding vacancy header information. The package inserts and maintains rows here; this is the object most commonly referenced by users searching for "per_vacancies_s".
• PER_ALL_VACANCIES — the descriptive/denormalised view exposing vacancy details (including the vacancy name and organisation) for query and validation. The package reads this view while validating and deriving vacancy data.

It also relies indirectly on supporting HR packages such as PER_VAC_BUS (business rules), PER_VAC_RKI (row key information), PER_VAC_SHD (shadow/table handler), HR_API, HR_UTILITY, HR_MULTI_MESSAGE, and FND_MESSAGE for messaging and error reporting.

Usage Notes

PER_VAC_INS is not intended to be called directly by end users. It is invoked from standard HRMS vacancy functionality — the Vacancies window and related APIs — and is referenced by two other packages, typically the vacancy business-rule and DML wrapper packages. Because it is an OTHER-classified (non-public) API residing in the APPS schema, customisations should always call the documented public vacancy API rather than PER_VAC_INS directly, preserving supportability on both 12.1.1 and 12.2.2. When diagnosing vacancy-creation issues, verify that the dependent packages listed above are VALID and that the form has been recompiled after any patch that touches the PER_VAC_* family.