Search Results per_vacancy_be3




Overview
Explore in AI Chat

Overview

APPS.PER_VACANCY_BE3 is a PL/SQL package that belongs to the Oracle E-Business Suite Human Resources (HR) family of APIs, specifically the Business Entity (BE) layer that supports the Oracle iRecruitment and Human Resources vacancy functionality. Within the EBS architecture, the "BE" packages act as thin generated wrappers around lower-level business logic, providing a stable programmatic interface for manipulating vacancy records. The package is classified under the ETRM API classification "OTHER," indicating that it is not a primary public API but rather an internal or supporting component.

The header comment in the package body ($Header: hrapiwfe.pkb) shows that the code was generated and references the HR API Workflow Events file. This confirms that PER_VACANCY_BE3 participates in the HR workflow event infrastructure, allowing vacancy lifecycle operations to raise and record workflow events when vacancies are removed. Its principal business function is to support the deletion of vacancy records while preserving the integrity of the vacancy data model and its associated workflow events. In Oracle EBS 12.1.1 and 12.2.2, the package is owned by APPS and resides in the same schema as the core PER (People) and HR tables, making it accessible to any code running with APPS privileges.

Key Procedures and Functions

The ETRM documentation for this package records a single documented procedure:

  • DELETE_VACANCY_A — The deletion procedure for a vacancy. It accepts an object version number and a vacancy identifier, and is responsible for removing the specified vacancy through the supported API path. The _A suffix follows Oracle HRMS naming conventions in which the "A" procedure is the internal implementation entry point; the object version number parameter provides optimistic locking so that concurrent updates to the same vacancy are detected and rejected before the delete proceeds. No parameter list beyond what is documented should be assumed.

Because the package body was auto-generated, there are no other documented procedures or functions in the ETRM extract. Any additional private routines reside in the referenced implementation file rather than in this specification.

Tables Accessed

The ETRM metadata records the following objects referenced by PER_VACANCY_BE3 via APPS synonyms:

  • PER_WF_EVENTS_S — The HR workflow events sequence. It is referenced to obtain the next event identifier when a vacancy deletion event is recorded, enabling downstream subscribers to be notified of the change.
  • DBMS_LOB — The Oracle-supplied large object package, used to manipulate CLOB/BLOB columns, typically for the event payload or descriptive data associated with the vacancy event.
  • DUAL — The standard single-row utility table, used for simple value evaluation and function invocations.

The package is also recorded as being referenced by one other package, indicating it forms part of a larger dependency chain in the vacancy management flow.

Usage Notes

PER_VACANCY_BE3 is not intended for direct invocation by end users or by casual custom code. It is typically called indirectly from higher-level HRMS forms and from other PL/SQL packages such as the public vacancy API or the iRecruitment business logic. In custom extensions, developers should prefer the documented public HRMS vacancy APIs rather than calling DELETE_VACANCY_A directly, since the BE3 layer is generated and may change between patch levels or releases (12.1.1 versus 12.2.2). When it is invoked, it should always be executed within a properly managed transaction in the APPS schema, with the correct object version number supplied to guard against lost updates. Because the package writes workflow events, calling it may trigger subscriptions configured in Oracle Workflow; administrators should review those subscriptions before running deletions in bulk.