Results for “fresh_origintn”

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

Overview

IGF_GR_GEN is the core PL/SQL package body within the Oracle E-Business Suite financial aid module responsible for Pell Grant disbursement generation and acknowledgement processing. In Oracle EBS 12.1.1 and 12.2.2, the package operates under the APPS schema and is classified as an "OTHER" API type, indicating it supports internal processing logic rather than a published integration interface. The package name, combining the "IGF" (financial aid) and "GR" (grant) prefixes, reflects its role in student grant administration. Its primary business function is to assemble, validate, and transmit Pell Grant origination and disbursement records to the federal Common Origination and Disbursement (COD) system, and to process the electronic responses returned by that system.

Key Procedures and Functions

The package exposes 41 documented procedures and functions, several of which are central to grant processing:

• GET_CYCLE_YEAR — Retrieves the award cycle year associated with a processing period, anchoring calculations to the correct federal award year.
• DISB_HAS_ADJ — Determines whether a disbursement carries an adjustment, guarding downstream logic against duplicate or conflicting transmissions.
• GET_ALT_CODE, GET_PER_NUM, GET_PER_NUM_OSS, GET_PERSON_ID — Resolve student and person identifiers, including alternate identifiers used for federal reporting.
• GET_CALENDAR_DESC, GET_FUND_ID, GET_SSN_DIGITS — Supply descriptive and identifying attributes such as fund references and partial Social Security Number data.
• GET_MIN_AWD_DISB, GET_MIN_PELL_DISB — Compute minimum award and Pell disbursement thresholds.
• GET_PELL_HEADER, GET_PELL_TRAILER — Build the header and trailer segments of the Pell origination/disbursement transmission file.
• GET_PELL_EFC, GET_PELL_EFC_CODE — Derive the Expected Family Contribution and its associated code for the student record.
• PROCESS_PELL_ACK — Parses and applies the acknowledgement response returned by the federal system.
• INSERT_SYS_HOLDS, SEND_ORIG_DISB, FRESH_ORIGINTN, OVRD_COA_EXIST — Manage system holds, transmit origination and disbursement data, refresh origination status, and detect existing Chart of Accounts override records.

Tables Accessed

The package reads and writes a broad set of financial aid tables, most referenced through APPS synonyms:

• IGF_GR_ATTEND_PELL, IGF_GR_PELL_SETUP_ALL — Store Pell attendance and configuration data used to build transmissions.
• IGF_AW_AWARD_ALL, IGF_AW_AWD_DISB_ALL — Supply award and disbursement detail.
• IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_MATCHED_ALL — Provide base financial aid records and ISIR matching results.
• IGF_AW_COA_ITEMS, IGF_AW_COA_ITM_TERMS, IGF_AW_COA_GROUP_ALL, IGF_AW_COA_GRP_ITEM_ALL — Support cost-of-attendance calculation and grouping.
• IGF_AW_CIT_LD_OVRD_ALL, IGF_AW_FUND_CAT_ALL, IGF_DB_DISB_HOLDS_ALL, FND_NEW_MESSAGES — Persist overrides, fund category references, disbursement holds, and application messages.

Usage Notes

IGF_GR_GEN is invoked indirectly by concurrent programs and forms that drive Pell Grant origination and disbursement cycles, and it is referenced by 47 other packages, confirming its role as a shared utility layer. Typical invocation occurs during the financial aid disbursement run, when origination and acknowledgement files are produced or consumed. Because the package is classified as OTHER and not a public API, customizations should avoid direct calls; developers extending Pell processing generally wrap or replicate the documented behavior through supported extension points or data-level integration.