Search Results igf_ap_ss_pkg




Overview
Explore in AI Chat

Overview

IGF_AP_SS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems (SS) side of the Financial Aid module. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package participates in the processing of Institutional Student Information Records (ISIRs) and related need-analysis data used by educational institutions. Its responsibilities center on the creation, correction, and simulation of ISIR records, the computation of the Expected Family Contribution (EFC), and the management of internal identifiers and dynamic dates tied to financial aid processing cycles. The package body is documented as VALID and is classified under the general API category "OTHER" rather than as a formally published open interface. It operates as an internal processing utility invoked by higher-level financial aid batch processes rather than as a standalone user-facing API.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within IGF_AP_SS_PKG. Their purposes are summarized below without presuming parameter signatures.

  • SET_INTERNAL_ISIR — Establishes or updates the internal representation of an ISIR record within the financial aid data model.
  • GET_PID — Retrieves the person identifier associated with a student or applicant record, supporting integration with person identification structures.
  • SAVE_AS_CORRECTION_ISIR — Persists an ISIR as a correction record, supporting the correction workflow required when students amend previously submitted federal data.
  • CREATE_SIMULATION_ISIR — Creates a simulated ISIR, enabling institutions to model need-analysis outcomes without committing them as official records.
  • COMPUTE_EFC — Calculates the Expected Family Contribution, the central need-analysis metric driving award eligibility.
  • GET_DYNAMIC_DATES — Returns dynamically derived dates, typically award-year or processing-cycle milestones used throughout financial aid processing.
  • GET_INTERNAL_ISIR_ID — Returns the internal identifier for an ISIR record, used to link corrections, simulations, and matched records.
  • INSERT_INTO_TODO — Inserts actionable items into the financial aid to-do list, flagging required follow-up activity for a student record.

Tables Accessed

The package reads and writes three documented tables accessed through APPS synonyms:

  • IGF_AP_FA_BASE_REC_ALL — The base financial aid record table, holding the foundation record against which ISIR and need-analysis data are associated.
  • IGF_AP_ISIR_MATCHED_ALL — Stores ISIR records that have been matched to existing student records, supporting the matching outcome of ISIR ingestion.
  • IGF_FC_SAR_CD_MST — A master table of Student Aid Report codes used to interpret coded values carried on ISIR and SAR data.

Additional dependencies include IGF_AP_ISIR_MATCHED, IGF_AP_INST_VER_ITEM, and various packages such as IGF_AP_ISIR_GEN_PKG, IGF_AP_ISIR_MATCHED_PKG, IGF_AP_BATCH_VER_PRC_PKG, and IGF_AP_EFC_CALC, indicating that this package orchestrates and is orchestrated by the broader ISIR and verification pipeline. It also depends on infrastructure utilities including FND_API, FND_DATE, FND_LOG, FND_MESSAGE, FND_MSG_PUB, and STANDARD.

Usage Notes

IGF_AP_SS_PKG is an internal package and is not referenced by any other database object according to the ETRM dependency report, although it is itself listed as being referenced by twenty-six other packages. It is typically invoked from financial aid concurrent programs and batch processes that ingest, match, correct, and simulate ISIR data, rather than directly from Oracle Forms or end-user interfaces. Customizations should treat the package as a supporting utility: it is called by higher-level ISIR generation and matching logic and relies on the standard EBS message, logging, and date APIs for error handling and localization. Because it manipulates core financial aid records, any extension or modification should preserve the validation and message-stack conventions enforced by the FND and IGS_GE_MSG_STACK dependencies.