Search Results p_academic_rank




Overview
Explore in AI Chat

Overview

The APPS.PQH_PROCESS_ACADEMIC_RANK package body supports the Academic Rank business process within Oracle E-Business Suite Human Resources (Oracle HRMS / Public Sector and Higher Education). Academic Rank records capture information such as the rank held (for example, Assistant Professor, Associate Professor, Professor), the effective start and end dates of the rank, the next academic rank, and a projected date associated with the rank change. These attributes are stored as extra information against a person record using the person extra information framework.

The package provides the server-side processing logic invoked when an Academic Rank transaction is committed through the HRMS API framework. It reads the pending transaction values staged by the HR API transaction mechanism, resolves them into a usable record set, and applies the resulting rank details to the underlying person extra information. This ensures the transaction is processed consistently and validates values before persistence. The header comment identifies the source as pqhusark.pkb, version 120.3, dated 2006/12/05, confirming this is a long-standing component of the EBS 12.1.1 code line carried forward into 12.2.2.

Key Procedures and Functions

ETRM documents four procedures and functions in this package:

  • GET_ACADEMIC_RANK — A function returning a REF_CURSOR. It is parameterized by a transaction step identifier (p_transaction_step_id). It assembles the pending Academic Rank values from the HR API transaction tables and decodes them into typed columns, converting canonical date strings to proper dates and numbers as required. It returns a single aggregated row for the transaction step.
  • GET_ACADEMIC_RANK_DETAILS — Retrieves the current or staged Academic Rank detail values for processing. It complements GET_ACADEMIC_RANK by supplying the detail row set consumed during transaction handling.
  • SET_ACADEMIC_RANK_DETAILS — Persists the validated Academic Rank detail values. This is the write path through which the processed rank information is stored against the person extra information record.
  • PROCESS_API — The entry point referenced by the HR API transaction framework. The decoding query in GET_ACADEMIC_RANK filters on api_name = 'PQH_PROCESS_ACADEMIC_RANK.PROCESS_API', confirming that PROCESS_API is the API invoked when an Academic Rank transaction is submitted. It orchestrates the read, validate, and write steps of the transaction.

No parameter lists beyond those visible in the source excerpt are asserted here; the documented signatures are limited to the transaction step identifier and the returned cursor.

Tables Accessed

The package reads from two HR API framework tables, accessed through APPS synonyms:

Note that P_OBJECT_VERSION_NUMBER is read from number_value rather than varchar2_value, reflecting a correction recorded against Bug 5415237.

Usage Notes

This package is not a general-purpose API intended for direct invocation. The PROCESS_API procedure is called by the HR API transaction framework when an Academic Rank transaction is committed, typically initiated from the Academic Rank maintenance form or from a validated dataload in the Higher Education / Public Sector context. The p_review_actid identifier that led to this lookup is associated with review activity tracking, which routes the user to the underlying transaction step that GET_ACADEMIC_RANK uses as its p_transaction_step_id input. Custom code should interact with this package only through the standard HRMS API invocation pattern — that is, by creating transaction steps and values and then calling PROCESS_API — rather than by calling the helper functions directly. Because the package is owned by APPS and classified as OTHER, no other distributed packages reference it (ETRM reports zero dependent packages), so its scope is confined to the Academic Rank transaction flow. It is compatible with Oracle EBS 12.1.1 and 12.2.2 as part of the shared PQH (Public Sector / Higher Education) module.