Search Results get_academic_rank




Overview
Explore in AI Chat

Overview

PQH_PROCESS_ACADEMIC_RANK is an Oracle EBS Applications (APPS) PL/SQL package that belongs to the Public Sector/HR (PQH) product family and supports the processing of academic rank information within the Oracle Human Resources framework. Academic rank records — such as professorial titles or equivalent faculty designations — are stored as person extra information (PEI) attributes attached to an employee assignment or person record. This package provides the transactional logic that reads and writes those academic rank values as part of a configurable HR API transaction step. It is classified in the ETRM metadata as an "OTHER" API, indicating it is an internal supporting package rather than a fully published, external-facing interface. In Oracle EBS 12.1.1 and 12.2.2 the package is deployed under the APPS schema and is invoked in the context of the HR API transaction step framework, which coordinates multi-step, rule-driven updates to person and assignment data.

Key Procedures and Functions

  • GET_ACADEMIC_RANK — A function returning a reference cursor (REF CURSOR). It accepts a transaction step identifier and returns a result set of academic rank information associated with that step, intended for downstream iteration by the calling process.
  • GET_ACADEMIC_RANK_DETAILS — A procedure that receives a transaction step identifier and returns the individual academic rank values (five generic PEI information attributes) together with the person extra information identifier. It is used to retrieve the current rank details for display, validation, or subsequent processing.
  • SET_ACADEMIC_RANK_DETAILS — A procedure that writes academic rank detail values. It accepts person, item type, item key, activity, object version, and person extra information identifiers, plus the five PEI information attributes, allowing the rank data to be persisted within the context of an HR transaction.
  • PROCESS_API — The primary entry point. It accepts a validation flag, a transaction step identifier, and an optional effective date, and orchestrates the retrieval and application of academic rank data for the transaction step. When the validate flag is true, the procedure performs validation only rather than committing changes.

Tables Accessed

The package operates against two documented tables referenced through APPS synonyms: HR_API_TRANSACTION_STEPS and HR_API_TRANSACTION_VALUES. HR_API_TRANSACTION_STEPS holds the definition and state of each step within an HR API transaction, and the package uses the transaction step identifier against it to determine which processing logic applies. HR_API_TRANSACTION_VALUES stores the individual attribute values accumulated for a transaction step; the academic rank PEI attributes are read from and written to this table through the SET and GET procedures. The person extra information identifier links the transaction values back to the underlying PEI record on the person or assignment.

Usage Notes

PQH_PROCESS_ACADEMIC_RANK is not typically called directly by end users or external integrations; it is invoked by the HR API transaction step engine when an academic rank related step is processed, whether from an Oracle HRMS form, a concurrent program, or custom code extending the transaction framework. Developers customizing academic rank processing should call PROCESS_API as the documented entry point, passing a valid transaction step identifier and effective date, and should rely on the validation mode before committing. The package is documented with the header identifier pqhusark.pkh and carries an Oracle proprietary and confidential designation; it is referenced by zero other packages according to the ETRM metadata, confirming its role as a leaf-level implementation package rather than a shared utility. Those searching for unrelated exam-related terms such as passing-rate queries will find no functional relevance here, as this object serves strictly academic rank data processing in Oracle EBS HR.