Search Results tgroup_rule

Overview

IGF_AW_RULE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Financials/Student Systems family of products concerned with awards, disbursements, and need analysis. The package name derives from "IGF" (the product short code associated with the Student Financial Aid / Awards module) and "AW" (Awards). Its documented purpose is to support the assignment and application of target groups and target group rules for award processing. Target groups define populations of students, identified through Person ID Groups, to which specific award rules or cost-of-attendance treatments are applied.

The package source header records that IGF_AW_RULE has evolved substantially. Bug 2613546 (October 2002) restructured the primary entry points: the RUN procedure was reparameterised to support Target Group assignment, and the tgroup_rule procedure was modified to accept a Person ID Group identifier in place of the former base identifier, together with a group code. The same bug obsoleted all processing previously associated with Rules. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer.

Key Procedures and Functions

The ETRM documentation lists two public procedures in the package specification:

• RUN — The main driver for Target Group assignment. Per the history comments, it accepts a group code identifying the target group and a Person ID Group identifier used to process all students belonging to that group. The p_base_id parameter present in earlier versions was removed. As a concurrent program entry point it also exposes the standard errbuf (OUT NOCOPY VARCHAR2) and retcode (OUT NOCOPY NUMBER) parameters, plus an award year and an operating unit (p_org_id).
• TGROUP_RULE — Applies the target group rule for a given target group identified by calendar type and sequence number, using a Person ID Group identifier and a group code. The history notes confirm this procedure now takes p_pergrp_id instead of p_base_id, and that p_grp_code was added.

No additional parameter lists should be assumed beyond those visible in the specification excerpt.

Tables Accessed

Three tables are documented as referenced through APPS synonyms:

• IGS_PE_PRSID_GRP_MEM_ALL — The Person ID Group membership table. It supplies the list of students (person identifiers) belonging to the group passed via p_pergrp_id, forming the population processed by both procedures.
• IGS_PE_PERSID_GROUP_ALL — The Person ID Group definition table, providing group metadata used to validate and resolve the group being processed.
• HZ_PARTIES — The TCA party registry, used to resolve or validate person records associated with the group members.

Target group definitions themselves reside in IGF_AW_TARGET_GRP (referenced by the parameter data types), though that table is not listed among the documented table references for this package.

Usage Notes

IGF_AW_RULE is typically invoked from the Student Financial Aid awards setup flows and via concurrent programs. The RUN procedure's errbuf/retcode signature is characteristic of an Oracle Reports or PL/SQL concurrent program entry point, indicating it is registered as a concurrent executable with parameters for award year, target group code, Person ID Group, and operating unit.

Because the affected functionality has been revised and the rules processing obsoleted, customisations should avoid the earlier p_base_id interface and instead call the current signatures. As the package is not referenced by any other documented package, direct calls are likely confined to concurrent program registration, forms-based invocation, and bespoke extensions.