Search Results num_of_vacancies

Overview

GHR_RIF_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated as a VALID database object. The acronym "RIF" corresponds to the Redundancy/Reduction-in-Force register functionality delivered within the Oracle HRMS (GHR) product family. The package encapsulates the server-side logic required to define, execute, and maintain a reduction-in-force register — a structured record used by Human Resources organizations to evaluate and process employees affected by workforce reduction programmes.

Classification within the ETRM repository designates this package as "OTHER," indicating that it is not registered as a public, published API and is therefore intended primarily for internal consumption by Oracle HRMS forms, concurrent programs, and dependent PL/SQL constructs. It is a self-referencing package, meaning some of its internal logic calls other procedures or functions within the same package body, and it exposes no public interface to external applications.

Key Procedures and Functions

The package exposes five documented program units:

• RUN_REGISTER — Executes the principal processing logic that generates or recalculates a reduction-in-force register, applying the defined selection criteria and populating the register tables accordingly.
• NUM_OF_VACANCIES — Returns the count of vacancies relevant to the register process, supporting headcount and displacement analysis during a reduction-in-force exercise.
• GET_ORG_NAME — Retrieves the descriptive name of an organization unit, providing readable identification of the organizational context associated with a register.
• PURGE_REGISTER — Removes register data, either wholly or for a specified register, supporting housekeeping and the removal of obsolete or superseded register records.
• CHECK_UNIQUE_NAME — Validates that a proposed register name is unique, preventing duplicate definitions from being saved through the maintenance form.

Parameter lists are not documented in the repository metadata and should be verified against the package specification in the target instance before invoking any program unit directly.

Tables Accessed

The package reads and writes a defined set of HRMS and application foundation tables, referenced through APPS synonyms:

• GHR_RIF_CRITERIA and GHR_RIF_REGISTERS / _S — the core register definition and criteria tables that store the register header and its selection rules.
• PER_ORGANIZATION_UNITS, PER_ANALYSIS_CRITERIA, PER_PERSON_ANALYSES — organization hierarchy and person-analysis data used to evaluate employees against selection criteria.
• PER_ASSIGNMENT_EXTRA_INFO, PER_PEOPLE_EXTRA_INFO, PER_POSITION_EXTRA_INFO — descriptive flexfield and extra information storage for assignment, person, and position records.
• PER_GRADES, PER_GRADE_DEFINITIONS, PER_JOBS, PER_PERSON_TYPES — grade, job, and person-type reference data used in criteria matching.
• FND_ID_FLEX_STRUCTURES and FND_ID_FLEX_STRUCTURES_TL — key flexfield structure definitions for organization and job information.
• DUAL — used for single-row utility queries.

Usage Notes

Because GHR_RIF_PKG is not registered as a public API and is referenced by no other packages, it is normally invoked through the Oracle HRMS reduction-in-force forms or the associated concurrent programs that manage register creation and processing. Custom code should treat the package as internal: direct invocation is possible but unsupported, and any such call risks breakage on patching or upgrade.

The dependency trace shows a reference to the SYS.STANDARD package, confirming standard PL/SQL execution context. When troubleshooting register behaviour in 12.1.1 or 12.2.2, DBMS_OUTPUT tracing, the GHR_RIF_* tables, and the package body source in the APPS schema are the primary diagnostic points.