Search Results dltrailer_cur

Overview

IGF_SL_DL_RECORD is an Oracle Application Object Library package in the APPS schema that supports the Student Loan (SL) disbursement processing within the Oracle E-Business Suite Financial Aid / Student Loan module. Its name reflects its role: it handles the record layer of disbursement (DL) data — that is, the structured loan disbursement records that are prepared, validated, and ultimately transmitted to (or received from) lending institutions and disbursement files. In the standard Oracle EBS 12.1.1 and 12.2.2 environment, this package sits between the higher-level loan origination logic and the lower-level file generation and validation routines.

Functionally, IGF_SL_DL_RECORD constructs and manages disbursement header, detail, and trailer records. It supplies cursor logic used to assemble the population of loan disbursements eligible for a given processing run, and it provides utility logic (such as academic calendar date resolution) needed to correctly stamp disbursement records with the appropriate institutional dates.

Key Procedures and Functions

The ETRM metadata documents five program units. Descriptions are based on the documented names and the package's dependency context; parameter signatures are not published here.

• DLDISBDETAILS — Assembles and returns disbursement detail records for the loans being processed, drawing on loan, award, and disbursement batch data to populate the detail lines of a disbursement file.
• DLHEADER_CUR — A cursor that produces the disbursement file header record, identifying the file type, batch, and originating institution context for the disbursement transmission.
• DLTRAILER_CUR — A cursor that produces the disbursement file trailer record, which carries control totals and summary counts that close out a disbursement file.
• DLORIG_CUR — A cursor that yields the loan origination records associated with the disbursement set, linking disbursement activity back to the underlying loan origination data.
• GET_ACAD_CAL_DTLS — A utility that resolves academic calendar details (such as term or calendar dates) required when formatting disbursement records.

Tables Accessed

The package reads and references the following documented objects, accessed through APPS synonyms:

• IGF_SL_DL_FILE_TYPE — Defines the disbursement file layouts and rules that govern how header, detail, and trailer records are produced.
• IGF_SL_LOANS_ALL — The loan master data supplying the loan and borrower information that populates disbursement records.
• IGS_CA_INST_ALL — Institution calendar instances, used by GET_ACAD_CAL_DTLS for academic date resolution.
• IGS_PS_OFR_INST — Program offering instances, providing the academic program context for the disbursement.
• DUAL — The standard Oracle single-row utility table, used for scalar evaluations.

Through additional dependencies, the package also relates to IGF_AW_AWARD, IGF_LOOKUPS_VIEW, IGF_SL_DL_BATCH, IGF_SL_LOANS, and IGS_CA_INST, reflecting its position at the intersection of award, loan, batch, and calendar data.

Usage Notes

IGF_SL_DL_RECORD is not intended for direct end-user invocation. It is typically called from disbursement batch processing logic and from other loan packages. The ETRM dependency report shows it is referenced by IGF_DB_DL_DISB_ORIG, IGF_SL_DL_CHG_ORIG, IGF_SL_DL_ORIG, IGF_SL_DL_VALIDATION, and IGF_SL_LAR_CREATION, and it is referenced by itself — confirming that its cursors and helpers are reused across the disbursement origin, change, validation, and Loan Acknowledgement Record (LAR) creation flows.

In practice, these routines execute during disbursement file preparation and validation runs, either as part of a concurrent program that builds disbursement transmissions or as called subroutines within custom extensions. Because the package is a dependency of origination and validation packages, changes to it can ripple through the full disbursement lifecycle; customizations should therefore treat it as a controlled, internal API rather than a direct integration point.