Search Results pqh_inst_type_pkg




Overview
Explore in AI Chat

Overview

APPS.PQH_INST_TYPE_PKG is a small utility package body in the Oracle E-Business Suite HR/Payroll (PQH) schema responsible for determining the institution type associated with a given organization. Its single function, GET_INST_TYPE, resolves whether an organization has been classified under the IPEDS_INSTITUTION_TYPE organization information context, and returns either the stored institution type value or the literal classification "NON-MED" when no such context exists. The IPEDS (Integrated Postsecondary Education Data System) institution type is relevant to higher-education and public-sector deployments where organization records carry academic institution classification data used downstream by payroll, benefits, and reporting logic.

The package is delivered in the APPS schema and is classified as OTHER in the documented API metadata, meaning it is not a formally supported public API but an internal helper referenced by other PL/SQL units within the application. Its header indicates a 2002 revision level, making it a long-standing component carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes one documented function: GET_INST_TYPE. It accepts an organization identifier and returns a VARCHAR2 representing the resolved institution type for that organization.

  • GET_INST_TYPE — Determines the institution type for the organization supplied by the caller. Internally it first checks whether the organization lacks an IPEDS_INSTITUTION_TYPE context; if the context is absent, the function returns "NON-MED". If the context is present, it retrieves and returns the corresponding org_information1 value from the organization information records.

The parameter list should be treated as documented in the source: a single numeric organization identifier. The function returns a varchar2 value rather than raising exceptions for missing data, defaulting to the "NON-MED" classification instead.

Tables Accessed

The package reads a single documented table, HR_ORGANIZATION_INFORMATION, accessed through its APPS synonym. This table is the standard HR repository for descriptive and classification attributes attached to organizations via flexible organization information types.

  • The first query (cursor c1) confirms the absence of a row for the organization where org_information_context equals 'IPEDS_INSTITUTION_TYPE', using a NOT EXISTS subquery keyed on organization_id.
  • The second query (cursor c2) retrieves org_information1 for the same organization and context when the record exists.

No inserts, updates, or deletes are performed; the package is strictly read-only against organization information data.

Usage Notes

GET_INST_TYPE is invoked programmatically by other PL/SQL packages rather than through a dedicated form or concurrent program. The documented metadata indicates the package is referenced by three other packages within the application, which call it to obtain the institution classification for an organization during processing.

Typical invocation occurs in payroll or HR processing logic that must branch on academic institution classification—for example, applying differing calculation or eligibility rules for medical versus non-medical institutions. Because the function is a private helper rather than a supported API, customizations should follow the same pattern as the existing callers: retrieve the value by organization identifier and tolerate the "NON-MED" default. The value returned for organizations with the IPEDS_INSTITUTION_TYPE context depends entirely on the org_information1 content maintained in HR_ORGANIZATION_INFORMATION, so data setup in that table governs the function’s output.