Search Results parameter_rec

Overview

IGF_AW_RULE is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the OTHER API category. It belongs to the Financial Aid (IGF) product family and is responsible for the assignment of Award Groups and Target Groups to students within a given award year. The package header and body carry a revision history spanning 2001 through 2006, reflecting multiple enhancement cycles tied to Financial Aid legislative and functional changes, including the introduction of Multiple FA Offices (FA 126), To Do Enhancements (FA 104), ISIR Enhancements (FA 138), and the addition of the "Eligible for Additional Unsubsidized Loans" attribute in the To Be Handled (TBH) call.

The package is centered on rule-driven processing of student populations. Its primary role is to evaluate students either by award year or by membership in a Person ID Group, and to apply the appropriate group assignment logic. Earlier iterations of the package included cost-of-attendance rule processing; that functionality has since been obsoleted, and the package was reoriented exclusively toward Target Group assignment.

Key Procedures and Functions

• RUN — The main driver procedure for assigning Award Groups to students for a specified award year, or to students belonging to a designated Person ID Group. The RUN procedure was modified to introduce the parameters p_grp_code (used for Target Group assignment) and p_pergrp_id (used to process all students belonging to a Person ID Group). The older p_base_id parameter was removed as part of this restructuring. RUN is intended for the assignment of Target Groups rather than Cost of Attendance groups.
• TGROUP_RULE — The target group rule procedure. It was modified to accept p_pergrp_id in place of p_base_id, and to add p_grp_code. Together with RUN, it forms the operational core of group assignment processing. All processing associated with the legacy Rules has been obsoleted, and a call to IGF_AP_FA_BASE_REC_PKG.UPDATE_ROW is performed as part of the downstream update of the Financial Aid base record, including the manual_disb_hold flag and, in later revisions, the FA 126 assoc_org_num attribute.

The user search term "parameter_rec" is consistent with the parameter-driven design of these procedures; the package receives its selection and assignment criteria through procedure parameters rather than a single monolithic record, and callers must supply the award year, group code, Person ID Group, and related identifiers explicitly.

Tables Accessed

• IGS_PE_PRSID_GRP_MEM_ALL — The Person ID Group membership table. RUN and TGROUP_RULE read this table to resolve the set of students that belong to a specified Person ID Group (p_pergrp_id) so that group assignment can be applied to the entire population rather than to a single student.
• IGS_PE_PERSID_GROUP_ALL — The Person ID Group definition table. It provides the group header information required to validate and resolve the group identified by p_pergrp_id before membership is expanded.
• HZ_PARTIES — The Trading Community Architecture party table. It is referenced to obtain and validate person-level party information for the students being processed, ensuring that assignment targets correspond to valid party records.

The package also updates the Financial Aid base record through IGF_AP_FA_BASE_REC_PKG.UPDATE_ROW, and stores working values such as calendar type and sequence number in package-level variables (l_ci_cal_type, l_ci_sequence_number) derived from IGF_AW_TARGET_GRP.

Usage Notes

IGF_AW_RULE is not exposed as a form-level API and is not referenced by any other documented package, which indicates that it is invoked directly, typically from concurrent programs or from custom Financial Aid batch code. RUN is the appropriate entry point when a batch process must assign Target Groups across an award year or across a Person ID Group. TGROUP_RULE is invoked to apply the group rule logic and to persist results to the Financial Aid base record, including the manual disbursement hold flag and, in FA 126 installations, the associated organization number.

Because the package is an APPS-owned body with no documented public API classification and no inbound package dependencies, implementations should treat it as an internal processing component. Direct modification is unsupported; extensions should call the documented procedures and rely on IGF_AP_FA_BASE_REC_PKG for record maintenance. The embedded comment "Skip the student if award is locked at the student level" (Bug 3021287) documents a key behavioral guard: students with locked awards are bypassed during assignment. This behavior should be accounted for when reconciling expected versus actual group assignment counts.