Search Results coa_duration

Overview

IGF_AW_COA_GEN is a generic PL/SQL API package in the Oracle E-Business Suite Grants Accounting (IGF) module, owned by the APPS schema. It provides the core calculation, validation, and lock-management logic that supports Cost of Attendance (COA) processing for awards. The package was originally created in October 2004 by Oracle India and is classified under the "OTHER" API category, meaning it is intended primarily for internal use by other Grants Accounting components rather than as a supported public integration interface. Its header references the source file IGFAW17S.pls.

The package exposes thirteen documented procedures and functions. It is referenced by seventeen other packages, which confirms its role as a shared utility layer within the awards/COA subsystem. The user search term "check_oss_attrib" corresponds to the CHECK_OSS_ATTRIB function within this package.

Key Procedures and Functions

• COA_AMOUNT — Returns the computed Cost of Attendance amount for a given base record, optionally scoped to an award period and with a flag controlling whether direct costs are included.
• AWARD_AMOUNT — Returns the award amount associated with a base record, award period, and award identifier.
• ISCOALOCKED — Boolean function that determines whether the COA records for a base, item, and load calendar instance are currently locked.
• DOLOCK — Applies a lock to the specified COA set and returns a status value indicating the result.
• DOUNLOCK — Removes an existing lock and returns a status value.
• GETBASEDETAILS — Retrieves base-level detail attributes (for example organizational unit, program type, and program location) used in subsequent COA processing.
• INS_COA_TODO — Inserts a standard "to-do" action record into the applicable table for COA-related follow-up.
• GET_COA_MONTHS — Derives the months applicable to COA processing, typically tied to teaching periods.
• SET_AWD_PROC_STATUS — Updates the processing status of an award.
• GET_AWARD_PERIOD_DATES — Returns the start and end dates for a specified award period.
• CANUSEANTICIPVAL — Validation function that determines whether an anticipated value may be used for an award.
• CHECK_OSS_ATTRIB — Validates specific award attributes (the "OSS" attribute set) to confirm that required conditions are satisfied before COA processing continues.
• COA_DURATION — Computes the duration associated with a Cost of Attendance record, in months or periods.

Tables Accessed

The package references a broad set of Grants and shared tables through APPS synonyms. Financial and award base data is read from IGF_AP_FA_BASE_REC_ALL and IGF_AP_FA_ANT_DATA, while award-level data is drawn from IGF_AW_AWARD_ALL, IGF_AW_AWARD_PRD, IGF_AW_AWD_PRD_TERM, and IGF_AW_AWD_DISB_ALL. COA-specific figures and rates come from IGF_AW_COA_ITEMS, IGF_AW_COA_RATE_DET, and IGF_AW_COA_ITM_TERMS. Award item definitions are supplied by IGF_AW_ITEM, and batch-to-award mappings by IGF_AP_BATCH_AW_MAP_ALL. Calendar and period information is read from IGS_CA_INST (load calendar), IGS_PE_TEACH_PERIODS_ALL, and IGS_EN_SPA_TERMS, with standard to-do records created in IGS_PE_STD_TODO. Party data is validated against HZ_PARTIES.

Usage Notes

IGF_AW_COA_GEN is invoked by the Grants Accounting forms, concurrent programs, and other API packages that manage award COA setup and calculation in EBS 12.1.1 and 12.2.2. Lock-related functions (ISCOALOCKED, DOLOCK, DOUNLOCK) are typically called before and after COA adjustments to prevent concurrent modification. Because the package is classified as OTHER, customizations should call it cautiously and validate behavior against the specific release; Oracle does not guarantee backward compatibility for non-public APIs.