Search Results dl_originate

Overview

The APPS.IGF_SL_DL_ORIG package is a PL/SQL database object within the Oracle E-Business Suite (EBS) schema, classified under the Oracle Student System / Financial Aid (IGF) module. It supports the loan origination and disbursement lifecycle for the Student Loan (SL) submodule. In the context of Oracle EBS 12.1.1 and 12.2.2, this package forms part of the Grants and Financial Aid processing framework that manages student loan transactions and their downstream integration with payables and disbursement processes. The package is documented with a status of VALID and is owned by the APPS schema, indicating that it is a deployed and compilable component of the standard Oracle-delivered codebase.

Key Procedures and Functions

The ETRM metadata for this package documents a single procedure or function, DL_ORIGINATE. This routine forms part of the loan origination logic, handling the creation or population of loan origination records based on award and fund data. The procedure operates within the broader loan processing flow, where origination records must be established before disbursement scheduling and reconciliation can occur. Additional internal routines may exist in the package body, but only DL_ORIGINATE is formally documented. Parameter lists are not specified in the available metadata and should be verified against the live database source.

Tables Accessed

The package references several application tables and views through APPS synonyms. These include:

• IGF_SL_LOANS_ALL — the core base table for student loan records, holding loan-level attributes and status.
• IGF_AP_FA_BASE_REC_ALL — financial aid base records tied to accounts payable integration.
• IGF_AW_AWARD_ALL — award data that drives eligibility and loan amounts.
• IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL — fund category and fund master definitions used to resolve funding sources.
• IGF_SL_LOR_ALL — loan origination request records that this package creates or updates.
• IGS_PS_OFR_INST — the offering instance table from the Student System academic structure, used to link loan activity to program offerings.
• DUAL — a standard Oracle system table.

The dependency documentation also shows references to IGF_LOOKUPS_VIEW, which supplies lookup code values for validation and display purposes.

Usage Notes

This package is typically invoked during the loan origination stage of financial aid processing, when award data must be converted into loan records ready for disbursement. It may be called from concurrent programs, from Oracle Forms within the Student Loan module, or from custom PL/SQL code extending the standard process. Because the package is documented as not referenced by any other package (0 dependents), it is likely invoked directly by application artifacts rather than through other PL/SQL APIs. Developers extending or troubleshooting loan origination should verify the actual signature of DL_ORIGINATE and confirm that all required fund and award data is populated before invocation.