Search Results assign_todo




Overview
Explore in AI Chat

Overview

IGF_AP_TODO_GRPS_PRC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API. It resides in the Oracle Student Financial Aid / Financial Aid (IGF) module, which supports the administration of Title IV and institutional aid processing, ISIR (Institutional Student Information Record) data management, and related verification workflows. The package name follows the IGF naming convention: the "AP" segment designates Application Processing, "TODO" refers to task or action items, and "GRPS" denotes groups, while "PRC" identifies the package as a processing utility. Conceptually, the package supports the automation of "to-do group" processing — that is, the assignment and management of actionable student or applicant task items that must be completed before an award or disbursement can proceed.

The package maintains a VALID status in the ETRM for both release 12.1.1 and 12.2.2, confirming that its interfaces are considered stable across these versions. It exposes two documented program units and is itself referenced by one dependent package, indicating that it acts as a shared service layer within the financial aid application-processing stack rather than as a top-level entry point.

Key Procedures and Functions

  • MAIN — The primary driver routine of the package. Consistent with the "PRC" naming, MAIN orchestrates the processing of to-do groups: it evaluates the criteria that determine whether a to-do item should be created, grouped, or resolved, and then applies the corresponding updates to the underlying item instance and master records. MAIN serves as the designated entry point invoked by callers.
  • ASSIGN_TODO — Performs the assignment of to-do items to the appropriate recipient, person identifier group, or profiling category. It resolves the applicable student or applicant context and creates the association between the task definition and the individual affected by it. ASSIGN_TODO encapsulates the logic that determines which records receive a to-do assignment.

Per ETRM documentation, no public parameter signatures are published for these units; implementation details should be confirmed against the live package specification before invoking them from custom code.

Tables Accessed

ETRM dependency reporting lists the following base tables, accessed through APPS synonyms: IGF_AP_FA_BASE_REC_ALL (the financial aid base record for the applicant), IGF_AP_TD_ITEM_INST_ALL (to-do item instances) and IGF_AP_TD_ITEM_MST_ALL (to-do item master definitions), IGS_CA_INST (the calendar/instance setup inherited from the Student System), and IGS_PE_PERSID_GROUP_ALL (person identifier groups, used to determine assignment population). Additional documented references include IGF_AP_CSS_PROFILE_ALL (CSS/Profile applicant data), IGF_AP_ISIR_MATCHED_ALL (matched ISIR records), IGF_SL_CL_PREF_LENDERS (preferred lender data), and HZ_PARTIES (the Trading Community Architecture party registry used for person identification).

Collectively, these tables indicate that processing reads applicant identity and aid-eligibility context (HZ_PARTIES, IGF_AP_FA_BASE_REC_ALL, ISIR data), evaluates task definitions and instances, and writes to-do assignments. The dependency on IGS_CA_INST suggests that to-do generation is time-sensitive.

Usage Notes

IGF_AP_TODO_GRPS_PRC_PKG is referenced by IGF_AP_VER_GRPS_PRC_PKG, indicating that verification group processing calls into this package's grouping and assignment logic. It is typically invoked from within the financial aid processing workflow — either from concurrent programs that refresh to-do items or from the OAF-based financial aid forms that display applicant to-do lists. Custom code should invoke MAIN or ASSIGN_TODO rather than manipulating the underlying tables directly, to preserve grouping semantics. Because it operates on applicant-level data, it should be run with standard APPS schema privileges and appropriate MOAC operating unit context.