Results for “igf_aw_rollover”

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

Overview

IGF_AW_ROLLOVER is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the Oracle Grants/Funds (IGF) module. Its central purpose is to roll over award-based and fund-based setup data from one award or calendar year into the next, cloning the configuration that governs a grant so that a subsequent award period inherits its distribution plans, cost-of-attendance definitions, terms, and related attributes rather than requiring manual re-entry. The package header comment documents a build dated 16-MAY-2005 (Build #4382389) attributed to ridas, describing it as the mechanism for "rolling over all the award based setups." The package is classified as OTHER in the ETRM metadata and is not referenced by any other documented package, indicating it is invoked at the application front end or by concurrent processing rather than serving as a shared utility library.

Key Procedures and Functions

• MAIN — The driver entry point. It orchestrates the rollover, determining the source and target award/calendar context and sequencing the subordinate rollover steps.
• CHK_CALENDAR_MAPPING — Validates the calendar mapping between the source and target periods, confirming that a valid relationship exists before rollover proceeds.
• GET_FUND_CD — Retrieves the fund code associated with a given fund or award record during the rollover.
• GET_PLAN_CD — Retrieves the distribution plan code used to derive the plans that must be replicated for the target period.
• ROLLOVER_INST_ATTCH_TODO — Rolls over installment attachments and associated to-do items, creating the corresponding to-do entries for the target award year. Internal private functions, such as create_fund_todo, support creation of fund to-do items by fetching the to-do details attached to a source fund.

No parameter lists are documented and are therefore not reproduced here.

Tables Accessed

The package touches a broad set of IGF and cross-module tables via APPS synonyms. Core award and fund masters are read and written: IGF_AW_AWARD_ALL, IGF_AW_FUND_MAST_ALL, IGF_AW_AWD_FRML_DET_ALL, and IGF_AW_AWD_DIST_PLANS provide award, fund, formula detail, and distribution-plan data. Calendar context comes from IGS_CA_INST_ALL, with calendar relationships held in IGF_AW_CAL_REL_ALL. To-do items are created in IGF_AP_TD_ITEM_MST_ALL, driven by maps such as IGF_AW_FUND_TD_MAP_ALL. Cost-of-attendance and rate structures are cloned from IGF_AW_COA_GROUP_ALL, IGF_AW_COA_GRP_ITEM_ALL, IGF_AW_COA_LD_ALL, and IGF_AW_COA_RATE_DET; the COA_GROUP objects are relevant to searches for "coa_group," identifying the cost-of-attendance group configuration rolled forward. Additional setup is drawn from IGF_AW_CIT_LD_OVRD_ALL, IGF_AW_DP_TEACH_PRDS, IGF_AW_DP_TERMS, IGF_AW_FUND_EXCL_ALL, and IGF_AP_APPL_SETUP_ALL.

Usage Notes

IGF_AW_ROLLOVER is typically invoked when establishing a new award year or replicating an existing award's setup, most likely from the IGF Grants/funds forms or from a scheduled concurrent program that performs year-end rollover. Because it is not referenced by other packages, custom integrations should call MAIN directly after confirming that the source award, target calendar mapping, and target period are correctly defined. Pre-rollover validation via CHK_CALENDAR_MAPPING is essential to avoid orphaned or unmapped rollover records. The package remains present in both 12.1.1 and 12.2.2, and its behavior is consistent across those releases.