Search Results get_key_program

Overview

IGF_AP_GEN_001 is an Oracle Application Object Library (APPS) PL/SQL package body classified as an "OTHER" API within Oracle E-Business Suite. It is part of the Oracle Student System / Financial Aid (IGF) module set and provides generalized utility functions related to student enrollment, academic program attempts, and term calendaring. The package primarily serves as a helper layer used by financial aid processing and award-based date derivation logic, converting a base record identifier (base_id) into derived attributes such as person identifier, course, version, and commencement dates.

The body header ($Header: IGFAP44B.pls 120.1) indicates the source was last touched in 2005, with a change history entry dated December 2003 describing the introduction of a key-program lookup to support course commencement date calculation. This confirms the package is a long-standing component carried forward into 12.1.1 and 12.2.2 without functional rework.

Key Procedures and Functions

• GET_PROG_ATT_START_DT — Returns the Program Attempt Start Date. It resolves the person from the base identifier, calls GET_KEY_PROGRAM to derive the course and version, then reads the commencement date from the student program attempt table. Exceptions are trapped and return NULL.
• GET_ANTICIP_COMPL_DATE — Computes the anticipated completion date for a program attempt.
• GET_CLASS_STANDING — Derives the class standing of a student.
• GET_ENRL_PROGRAM_TYPE — Returns the enrollment program type for a given base record.
• GET_KEY_PROGRAM — The procedure referenced in the user's search; it determines the key program (course code and version number) associated with a base_id. It is invoked internally by GET_PROG_ATT_START_DT and exposes the resolved course/version to callers.
• GET_TERM_ENRLMNT_DTL — Retrieves term enrollment detail.
• GET_ENR_EFF_DT_ALIAS_VAL — Returns an effective-date alias value scoped to enrollment.
• GET_TERM_DATES — Returns term start/end dates.
• GET_DATE_ALIAS_VAL — Returns a generic date alias value.
• GET_CONTEXT_DATA_FOR_TERM — Resolves context (calendar/term) data for a term.

Tables Accessed

• IGF_AP_FA_BASE_REC_ALL — Core financial aid base record; primary driver of all lookups.
• IGF_AP_FA_ANT_DATA — Anticipated completion data.
• IGS_EN_STDNT_PS_ATT_ALL — Student program attempt; source of commencement date.
• IGS_PS_VER_ALL — Program version definitions (course code/version).
• HZ_PARTIES — Party (person) resolution.
• IGS_CA_DA_INST, IGS_CA_INST_REL, IGS_CA_TYPE — Calendar instance and relationship data.
• IGS_EN_SPA_TERMS, IGS_EN_CAL_CONF, IGS_PR_CLASS_STD — Term, calendar configuration, and class standing data.

Usage Notes

IGF_AP_GEN_001 is referenced by 14 other packages, indicating it is a shared utility invoked from financial aid award processing, enrollment validation, and calendar/term derivation logic rather than being called directly from a form. Typical invocation is from PL/SQL wrapper packages and concurrent program logic that operate on a base_id. Custom code extending financial aid or student-program logic may call GET_KEY_PROGRAM first to resolve the governing course and version before querying term or attempt data. Because GET_PROG_ATT_START_DT suppresses exceptions with a WHEN OTHERS handler returning NULL, callers must null-check returned dates before using them in downstream calculations.