Search Results per_hr_asg_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_HR_ASG_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of "OTHER." Its header, bearing the source identifier peper05t.pkh, indicates it belongs to the Human Resources (PER) product family and operates with AUTHID CURRENT_USER privileges. The package encapsulates reusable logic related to assignment, vacancy, and recruiting validation for Oracle HRMS. Rather than exposing a broad public API, it provides a small, focused set of utilities that resolve descriptive attributes of a vacancy and validate combinations of job, organization, position, and grade against a received date. Because its comments repeatedly refer the reader to PER_APPLICANT_PKG "for details," the package functions as a supporting utility to the applicant and recruitment processing flow, supplying shared lookups and consistency checks used when screening or recording applicant information. Its scope is therefore narrow and internal in nature, oriented toward data resolution and validation rather than transactional commitment of HR records.

Key Procedures and Functions

The package exposes three documented program units.

  • GET_VACANCY_DETAILS — A procedure that accepts a vacancy identifier and returns the descriptive attributes associated with that vacancy. It resolves the vacancy name, recruiter identifier and name, organization identifier and name, people group identifier, job identifier and name, position identifier and name, grade identifier and name, and location identifier and code. It is the primary read routine in the package and is used to populate vacancy context for downstream recruiting logic.
  • CHK_JOB_ORG_POS_COMB — A function that validates whether a given job, organization, and position combination is valid as of a supplied received date, returning a Boolean result. This reflects the HRMS rule that valid job, organization, and position combinations are date-effective and may change over time.
  • EXISTS_VAL_GRD_FOR_POS_AND_JOB — A procedure that determines, within a business group and as of a received date, whether a valid grade exists for a specified job and separately whether one exists for a specified position, returning two Boolean outputs.

Tables Accessed

The ETRM metadata for this object does not enumerate the base tables or APPS synonyms the package touches. By inference from the PER source prefix and the data it resolves, the package reads core Oracle HRMS tables such as those holding vacancies, recruiters, organizations, people groups, jobs, positions, grades, and locations. These reads are consistent with the descriptive attributes returned by GET_VACANCY_DETAILS and with the date-effective validation performed by the two validation routines. No insert, update, or delete activity is documented.

Usage Notes

PER_HR_ASG_PKG is typically invoked from recruitment and applicant-handling code, including Oracle Forms and custom PL/SQL that call into or are called by PER_APPLICANT_PKG. Because GET_VACANCY_DETAILS and EXISTS_VAL_GRD_FOR_POS_AND_JOB return values through OUT and IN OUT parameters, they are called within PL/SQL blocks that declare matching host variables. CHK_JOB_ORG_POS_COMB returns a Boolean, limiting direct invocation from tools that cannot bind Booleans. The ETRM metadata records that the package is referenced by one other package, confirming it is used as a shared dependency rather than a standalone entry point. The header date (1999) and the AUTHID CURRENT_USER declaration indicate a long-standing internal utility whose behaviour should be verified against the target release before reuse in custom code.