Results for “audp_get_uvh_col”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AU_GEN_004 is an Oracle EBS Student System (IGS) package owned by APPS that provides a set of historical attribute retrieval functions. It is part of the "AU" (Academic Unit) family of generated utilities. The package has a specialized purpose: for a given entity identified by a composite key — unit code, version number, organization unit, and a historical date — it returns the value that was effective at, or after, a specified point in time. This "effective-dated lookup" pattern is fundamental to the IGS data model, where records such as teaching responsibility, unit descriptions, and unit versions are retained in history tables with start and end dates rather than being overwritten. The package therefore centralizes the rather repetitive SQL needed to query these history tables and isolates the calling code from the underlying table structures. The API classification is OTHER, meaning it is an internal utility rather than a public, supported interface.

Key Procedures and Functions

The package body contains seven documented functions, each returning a single historical attribute value for a different entity. In every case the return type is NUMBER, reflecting that these functions retrieve code or numeric attribute values rather than descriptive text.

• AUDP_GET_TRH_COL — returns the oldest percentage value from the teaching responsibility history, using unit code, version number, organisation unit, organisation unit start date, and history date as its key. The documented source confirms this function queries IGS_PS_TCH_RESP_HIST.
• AUDP_GET_TROH_COL — retrieves the corresponding historical column from the teaching responsibility overriding history.
• AUDP_GET_UDH_COL — retrieves a historical attribute for a unit description.
• AUDP_GET_UICLH_COL — retrieves a historical attribute relating to unit inloader configuration.
• AUDP_GET_URCH_COL — retrieves a historical attribute from the unit reference history.
• AUDP_GET_USH_COL — retrieves a historical attribute from the unit set history.
• AUDP_GET_UVH_COL — retrieves a historical attribute from the unit version history. Per the change history, this function was modified to add billing_credit_points logic and later to incorporate workload value and override workload flag logic.

Tables Accessed

The package reads from the following tables via APPS synonyms: IGS_EN_UNIT_SET_HIST_ALL, IGS_PS_TCH_RESP_HIST_ALL, IGS_PS_TCH_RSOV_HIST_ALL, IGS_PS_UNIT_REF_HIST_ALL, IGS_PS_UNIT_VER_HIST_ALL, IGS_PS_UNT_DSCP_HIST_ALL, and IGS_PS_UNT_INLV_HIST_ALL. It also references USER_TAB_COLUMNS, indicating dynamic handling of column presence. All are history (_HIST) tables, reinforcing that this package is exclusively a read-only historical lookup utility. The _ALL tables are the multi-organization views of the base history tables.

Usage Notes

IGS_AU_GEN_004 is referenced by seven other packages, which is consistent with a shared low-level utility. It is not intended for direct invocation by end users; rather, it is called from higher-level academic unit APIs, validation routines, and possibly concurrent programs that must reconstruct the state of an academic unit as of a particular date. The documented metadata reveals no reference to the searched term "ci_sequence," so it should be understood that this package does not expose a CI sequence attribute. Developers invoking these functions must supply fully qualified composite keys, and should be aware of the "oldest value after the given date" semantics demonstrated in AUDP_GET_TRH_COL.