Search Results get_vac_position_changed

Overview

IRC_VACANCY_APPROVALS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the iRecruitment (IRC) product family. It is declared with AUTHID CURRENT_USER, meaning that all SQL statements inside the package execute with the privileges of the invoking session rather than the package owner. The package exists to support the vacancy approval workflow in iRecruitment, exposing a set of read-only accessor functions that retrieve transaction, posting, vacancy, and search attribute values required during the approval process.

The central concept in the package is the transaction identifier, held as a VARCHAR2 and passed into almost every function. The transaction_id allows the approval logic—whether expressed in a workflow activity, an OAF page, or a concurrent process—to resolve the specific approval transaction and return the associated iRecruitment data. Two functions also accept a p_path argument, allowing the caller to request a named attribute from within the stored transaction data.

Key Procedures and Functions

The package exposes twenty-eight documented functions, all of which are accessors returning VARCHAR2 or NUMBER. They fall into several functional groups.

• Transaction accessors: GET_TRANSACTION_DATA returns transaction data for a given transaction_id and path. GET_TRANSACTION_NUMBER_DATA returns the numeric form of transaction number data. GET_TRANSACTION_MODE returns the mode of the transaction.
• Data-category accessors: GET_POSTING_DATA_NUMBER and GET_POSTING_DATA_VARCHAR retrieve posting attributes by name in numeric and character form respectively. GET_VACANCY_DATA_NUMBER and GET_VACANCY_DATA_VARCHAR do the same for vacancy attributes. GET_SEARCH_DATA_NUMBER and GET_SEARCH_DATA_VARCHAR return search-related attribute values.
• Change-detection functions: GET_VAC_ORGANIZATION_CHANGED, GET_VAC_JOB_CHANGED, GET_VAC_GRADE_CHANGED, GET_VAC_POSITION_CHANGED, GET_VAC_BUDGET_VALUE_CHANGED, GET_VAC_BUDGET_TYPE_CHANGED, and GET_VAC_STATUS_CHANGED report whether specific vacancy fields have been modified as part of the transaction.
• Posting change-detection functions: GET_POSTING_TITLE_CHANGED, GET_POSTING_JOB_TITLE_CHANGED, GET_POSTING_DEPARTMENT_CHANGED, and GET_POSTING_DEPT_DESC_CHANGED report whether the corresponding posting field has been altered.

The consistent pattern across the package is a lightweight lookup that returns a single scalar value or a change indicator, which the approval engine uses to decide routing, validation, or display.

Tables Accessed

Through APPS synonyms, the package references HR_API_TRANSACTIONS, PER_ALL_VACANCIES, and DBMS_LOB. HR_API_TRANSACTIONS is the generic Oracle HRMS transaction repository that stores the transaction record keyed by transaction_id; the package reads this table to resolve transaction mode, number, and stored attribute payloads. PER_ALL_VACANCIES holds vacancy definitions and their attributes such as organization, job, grade, position, budget, and status, which the change-detection and vacancy data functions interrogate. DBMS_LOB is used to handle large object columns, indicating that some transaction data or serialized attribute values may be stored as CLOBs or similar LOB types and must be read before parsing.

Usage Notes

IRC_VACANCY_APPROVALS is not an API in the conventional sense: it publishes no create, update, or approval procedures and is not referenced by any other documented package. Its functions are intended as internal support routines called by iRecruitment approval workflow activities, Oracle Applications Framework (OAF) approval pages, and related concurrent or PL/SQL logic that needs to inspect a vacancy approval transaction. The package is typically invoked during the vacancy approval lifecycle, when the system must determine whether a given vacancy or posting attribute has changed and what its current value is. Because it relies on AUTHID CURRENT_USER and APPS synonyms, the invoking session must have the appropriate grants on the underlying objects.