Search Results p_school_code

Overview

IGF_DB_DL_RECONC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems / Financial Aid (IGF) product family. Its stated purpose in the source header is "To load the" disbursement file data, and the package is recorded as part of the "Disbursements build" delivered by the original developer (adhawan) in January 2002. Functionally, the package supports reconciliation between disbursement records uploaded from external sources — typically lenders, guarantors, or school financial aid systems — and the corresponding records held in the EBS financial aid tables. It provides the procedural plumbing that a concurrent program uses to identify inbound disbursement files, validate them, and reconcile them against system data.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. This is a common pattern for concurrent-program entry points that must respect the invoking user's data access.

Key Procedures and Functions

Two procedures are documented for this package, both declared in the package specification:

• MAIN_SMR — The summary-level reconciliation entry point. Its standard concurrent-program signature accepts the report buffer/return code pair followed by an award year and, per the 2003 change history, two additional parameters: SCHOOL_TYPE and P_SCHOOL_CODE. This procedure is intended to process disbursement data at a summary (school/reporting) level.
• MAIN_DTL — The detail-level reconciliation entry point. It shares the same parameter profile as MAIN_SMR, including the award year, SCHOOL_TYPE, and P_SCHOOL_CODE parameters, but operates at the individual disbursement detail level rather than in summary form.

Both procedures were modified in October 2003 under Bug #3102439 ("FA 126 Multiple FA Offices") to add the SCHOOL_TYPE and P_SCHOOL_CODE parameters. This change allows the reconciliation logic to be restricted to a specific school type and school code, which was necessary once a single institution could operate multiple financial aid offices. The school_type value is therefore central to how these procedures are invoked.

Tables Accessed

The package references the following tables via APPS synonyms:

• IGF_SL_DL_FILE_TYPE — Defines the valid categories of disbursement/load files. The reconciliation logic consults this table to determine which inbound file types are eligible for processing and how they should be handled.
• IGF_SL_LOAD_FILE_T — The staging table that holds loaded file records prior to reconciliation. MAIN_SMR and MAIN_DTL read from this table to compare staged data with existing disbursement records and to determine which rows reconcile cleanly and which require exception handling.

Usage Notes

IGF_DB_DL_RECONC is not exposed through an Oracle Forms user interface. Instead, it is designed as a concurrent program execution target, consistent with the errbuf/retcode OUT parameters in both procedures. A Financial Aid administrator typically runs the reconciliation by submitting a concurrent request, supplying the award year, school type, and school code. The package is invoked at the point in the disbursement lifecycle after files have been loaded into IGF_SL_LOAD_FILE_T and before downstream disbursement/posting activity.

The documented metadata records zero dependent packages, so no other EBS packages call IGF_DB_DL_RECONC programmatically; external or custom callers should follow the documented parameter order and honor the AUTHID CURRENT_USER context. Because the package dates from Release 11-era code (header revision 115.3, 2003), it remains available in EBS 12.1.1 and 12.2.2 for backward compatibility with the Student Systems disbursement load process.