Search Results get_salary_currency

Overview

IRC_APPROVALS is a PL/SQL package in the Oracle E-Business Suite iRecruitment (IRC) application, owned by the APPS schema and declared with AUTHID CURRENT_USER. It functions as a server-side utility and data-access layer that supports the approval, posting, and vacancy-management workflows of the iRecruitment module. Rather than exposing a single business event, the package aggregates a broad library of getter functions that retrieve transactional attributes, posting details, vacancy attributes, and search-related values required by the approval engine and its associated Oracle Forms and OA Framework pages.

The header reference (ircame.mepkh 120.12.12010000.2) indicates the package has been maintained across the 12.1.x and 12.2.x release streams and is classified as an OTHER API, meaning it is intended primarily for internal consumption by iRecruitment components rather than as a formally published integration interface.

Key Procedures and Functions

The 56 documented routines fall into several functional families:

• Transaction data retrieval: GET_TRANSACTION_DATA and GET_TRANSACTION_NUMBER_DATA return transactional values (character and numeric respectively) based on a transaction identifier and a path expression, supporting the approval routing logic.
• Posting data accessors: GET_POSTING_DATA_NUMBER and GET_POSTING_DATA_VARCHAR extract numeric and character posting attributes keyed by transaction and data name.
• Vacancy data accessors: GET_VACANCY_DATA_NUMBER and GET_VACANCY_DATA_VARCHAR perform the same role for vacancy records.
• Search data accessors: GET_SEARCH_DATA_NUMBER and GET_SEARCH_DATA_VARCHAR return numeric and character values used by recruitment search and filtering.
• Vacancy attribute getters: a substantial group resolves specific vacancy fields — GET_VAC_BUSINESS_GROUP_ID, GET_VAC_ORGANIZATION_ID, GET_VAC_GRADE_ID, GET_VAC_JOB_ID, GET_VAC_LOCATION_ID, GET_VAC_BUDGET_VALUE, GET_VAC_BUDGET_TYPE, GET_VAC_STATUS, GET_VAC_PROFESSIONAL_AREA, GET_VAC_FOR_EMP, and related identifiers.
• Mode and control helpers: GET_TRANSACTION_MODE and similar routines expose the current processing mode to drive conditional approval behavior.

Notably, the user search term “get_salary_currency” does not appear among the documented procedure names, though the package’s pattern of typed getters suggests salary and currency attributes would be exposed through the generic posting or vacancy data accessors rather than a dedicated function.

Tables Accessed

The package reads from several core HR and iRecruitment tables via APPS synonyms:

• HR_API_TRANSACTIONS — the transaction header driving approval and posting processing.
• PER_ALL_VACANCIES — vacancy definitions and their attributes.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — person and assignment records for recruiter, approver, and applicant context.
• FND_USER — application user identity for approval and security checks.
• DBMS_LOB and PLITBLM — Oracle-supplied packages used for large object handling and PL/SQL table/list manipulation, supporting the internal data assembly.

Usage Notes

IRC_APPROVALS is invoked internally by iRecruitment approval, posting, and vacancy pages, typically from OA Framework controllers or Oracle Forms triggers that need to resolve vacancy and transaction attributes for display or routing decisions. Because it is classified as OTHER and has no documented external callers, it should not be treated as a stable public API for custom integrations; direct calls risk breakage on patch application. Custom code requiring similar data should prefer supported public APIs or views. All access is performed under the current user’s privileges due to AUTHID CURRENT_USER, so invoking users must possess the appropriate iRecruitment and HR data grants.