Search Results igs_pe

Overview

IGF_SE_GEN_001 is a PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite financial aid and student systems module. It is classified as an "OTHER" API, indicating it is not a public, fully supported interface but rather an internal utility package invoked by Oracle Forms, concurrent programs, and other PL/SQL packages within the Institutional Financial aid (IGF) and Student Enrollment (IGS) product families. The package addresses the automated disbursement and notification of student financial aid awards, orchestrating work authorization sending, payroll-related processing, and stakeholder notification. The "SE" designation in its name associates it with the Student Enrollment / Student Financials processing domain.

In the context of the user's search for "igs_pe", the package references several IGS_PE (Student Person/People) foundation tables, confirming the strong integration between the IGF financial aid schema and the IGS student records schema. Person identity, visa, and residency information maintained in the IGS_PE tables is consumed by this package to correctly identify and notify aid recipients.

Key Procedures and Functions

The package exposes five documented procedures and functions:

• SEND_WORK_AUTH — Initiates the sending of work authorization records for financial aid awards. The header change history notes that this procedure raises the exception IGFSEGEN001 when the parameter p_call is passed with the value 'LEGACY', a behavior introduced under Bug #3536039.
• SEND_WORK_AUTH_JOB — The concurrent/background counterpart that drives work authorization sending as a scheduled job, allowing bulk processing rather than interactive single-record submission.
• PAYROLL_UPLAOD — Uploads payroll-related payment data (note the documented spelling). It interfaces the aid payment records with payroll processing.
• PAYROLL_ADJUST — Handles adjustments to previously uploaded payroll entries, supporting corrections and reversal processing.
• SE_NOTIFY — Generates notifications to students or other stakeholders regarding award or payment events.

The package also contains the display_auth_params procedure and multiple private cursors (c_alternate_code, c_get_parameters, c_person_dtls, c) used for parameter retrieval and logging. Performance tuning fixes were applied under Bug numbers 2620242, 2620259, and 2620264.

Tables Accessed

Referenced through APPS synonyms, the tables fall into three groups:

• Award and fund data: IGF_AW_AWARD_ALL, IGF_AW_FUND_MAST_ALL, IGF_AW_FUND_CAT_ALL — source of award, fund, and fund-category definitions.
• Payment and authorization data: IGF_SE_AUTH, IGF_SE_AUTH_S1, IGF_SE_PAYMENT, IGF_SE_PAYMENT_INT — the core authorization and payment records the package creates and updates.
• Person and party data: HZ_PARTIES, HZ_PERSON_PROFILES, IGS_PE_PERSON_ID_TYP, IGS_PE_RES_CHG_S, IGS_PE_VISA, IGS_PE_VISIT_HISTRY, IGF_AP_FA_BASE_REC_ALL — used to resolve party numbers, person identifiers, residency/visa status, and visit history. The c_person_dtls cursor joins HZ_PARTIES and IGF_AP_FA_BASE_REC_ALL to resolve party_number by person_id and base_id.
• DUAL is used for single-row computations.

Usage Notes

IGF_SE_GEN_001 is typically invoked from Oracle Forms in the Student Financial aid module and from concurrent programs (notably SEND_WORK_AUTH_JOB). It is referenced by two other packages, indicating it forms part of a call chain rather than an entry point. Because it references IGS_PE foundation tables, it requires that person, visa, and residency data be populated before award processing. The package prints parameters only when non-null (Bug #3709292) and includes logging messages added under Bug #3346948. Custom code should invoke the public procedures only; the internal cursors and display_auth_params are implementation details subject to change across 12.1.1 and 12.2.2.