Search Results send_work_auth

Overview

IGF_SE_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Student Financial Aid (formerly Student System / Financial Aid) product family, whose objects are prefixed with IGF_. The package functions as a generation and processing utility for student financial aid disbursements, with particular emphasis on work authorization and payment handling. Its classification in the ETRM repository is OTHER, indicating that it is not a published public API but an internal component used by other financial aid packages and concurrent processes. The package status is VALID, and it references a mixture of financial aid base tables, payment tables, award and fund master tables, and person/party tables drawn from the Trading Community Architecture (HZ) and Student System (IGS) schemas.

Key Procedures and Functions

The package exposes five documented procedures and functions:

• SEND_WORK_AUTH — Generates and dispatches a work authorization record, typically relating a student's award to an authorization used to permit payment or work activity.
• SEND_WORK_AUTH_JOB — A concurrent-program style entry point that processes work authorization generation in batch, invoking the same logic as SEND_WORK_AUTH across a set of records.
• PAYROLL_UPLAOD — Uploads payroll-related financial aid data into the payment tables. The misspelling (UPLAOD rather than UPLOAD) is preserved in the actual object name and must be used in any direct call.
• PAYROLL_ADJUST — Applies adjustments to payroll-derived payment records, reconciling amounts against the financial aid payment and payment interface tables.
• SE_NOTIFY — Issues a notification associated with student financial aid events, using party and person data to identify recipients.

Each procedure interacts primarily with the IGF_SE_AUTH, IGF_SE_PAYMENT, and IGF_SE_PAYMENT_INT tables, and with the award and fund master tables for validation and lookup.

Tables Accessed

The package reads and writes through APPS synonyms of the following base objects:

• IGF_SE_AUTH and IGF_SE_AUTH_S1 — Student financial aid authorization records and their sequence, central to the work authorization procedures.
• IGF_SE_PAYMENT and IGF_SE_PAYMENT_INT — Payment and payment interface tables written by the payroll upload and adjustment logic.
• IGF_AW_AWARD_ALL, IGF_AW_FUND_MAST_ALL, IGF_AW_FUND_CAT_ALL — Award, fund master, and fund category data used to validate and derive authorization and payment amounts.
• IGF_AP_FA_BASE_REC_ALL — The base financial aid recipient record linking a person to their aid records.
• HZ_PARTIES and HZ_PERSON_PROFILES — Trading Community person data used for party identification and notification.
• IGS_CA_INST, IGS_PE_PERSON_ID_TYP, IGS_PE_RES_CHG_S, IGS_PE_VISA, IGS_PE_VISIT_HISTRY — Student System person, residency, visa, and visitor history data used in eligibility determination.
• DUAL — Standard single-row utility table for PL/SQL and SQL expression evaluation.

Usage Notes

IGF_SE_GEN_001 is an internal financial aid component rather than a supported public API. It is referenced by two other packages: IGF_AW_LI_IMPORT and IGF_SE_PAYMENT_PKG, the latter being the principal payment processing package. Customizations should therefore prefer calling IGF_SE_PAYMENT_PKG or the standard concurrent programs rather than invoking IGF_SE_GEN_001 directly, since Oracle does not guarantee the stability of its signature across patches or upgrades. When diagnosing issues, note that work authorization logic is triggered from the financial aid forms and from batch jobs using SEND_WORK_AUTH_JOB, while payroll upload and adjustment are normally reached through the payment processing flows. Because the package writes to payment and payment interface tables, any custom call must respect existing validation and commit logic to avoid orphaned or duplicate payment records.