Search Results chk_loan_upd_lock

Overview

IGF_SL_AWARD is a PL/SQL package in the APPS schema that supports the Oracle Financials student loan processing solution delivered under the OSSA/ETRM (Student System) application family. It centralizes the business logic that binds award-level data to the student loan lifecycle. In practice the package resolves the terms and conditions that apply to a loan award so that the award and disbursement infrastructure (the IGF_AW_* tables) can be joined to the loan and change-setup infrastructure (the IGF_SL_* tables). This makes it the bridge between award scheduling and loan origination, disbursement, and release processing.

The package is classified as OTHER, meaning it is an internal supporting package rather than a formal published PL/SQL API. It nevertheless exposes fifteen documented procedures and functions that are consumed by a broad set of callers across award lifecycle processing, loan origination, loan change processing, late disbursement handling, and disbursement release.

Key Procedures and Functions

• GET_LOAN_AMTS — Returns the loan amounts applicable to an award for downstream award or disbursement processing.
• PICK_SETUP — Selects the applicable loan change setup record (from IGF_SL_CL_SETUP_ALL) that governs the award or loan being processed.
• GET_LOAN_FEE1 / GET_LOAN_FEE2 — Retrieve the two configured loan fee values applicable to the loan.
• GET_CL_HOLD_REL_IND — Returns the change-setup hold/release indicator, controlling whether a held disbursement may be released.
• GET_CL_AUTO_LATE_IND — Returns the automatic late-disbursement indicator from the change setup.
• CHK_DISB_DATE — Validates a disbursement date against the configured rules for the award.
• CHK_LOAN_UPD_LOCK — Checks whether a loan is locked against update, preventing conflicting modifications.
• GET_ALT_REL_CODE — Determines the alternate release code used when releasing disbursements.
• RECALC_FEES — Recomputes loan fees, typically after an amount or setup change.
• CHK_CHG_ENABLE — Determines whether a change is permitted on the loan in its current state.
• CHK_ADD_NEW_DISB — Validates whether a new disbursement may be added to the award or loan.
• CHK_LOAN_INCREASE — Validates a requested loan increase against award and setup limits.
• GET_LOAN_CL_VERSION — Returns the loan change version in effect, supporting version-aware change processing.
• CHK_FUND_ST_CHG — Checks whether the fund status has changed, governing whether further processing is allowed.

Tables Accessed

The package reads and writes across two table families. The award family includes IGF_AW_AWARD_ALL, IGF_AW_AWD_DISB_ALL, IGF_AW_FUND_CAT, IGF_AW_FUND_CAT_ALL, IGF_AW_FUND_MAST_ALL, IGF_AP_FA_BASE_REC_ALL, and IGS_CA_INST/IGS_CA_INST_ALL. These supply award, disbursement, and fund category/status data. The loan family includes IGF_SL_LOANS/IGF_SL_LOANS_ALL, IGF_SL_CL_SETUP/IGF_SL_CL_SETUP_ALL, IGF_SL_CL_PREF_LENDERS, IGF_SL_CLCHSN_DTLS, IGF_SL_DL_SETUP_ALL, and IGF_SL_LOR_ALL. These supply loan terms, change setup, lender preference, and loan origination data. Supporting tables FND_NEW_MESSAGES and HZ_PARTIES are used for messaging and party resolution.

Usage Notes

IGF_SL_AWARD is invoked indirectly rather than through direct end-user calls. Documented callers include IGF_AW_AWD_DISB_PKG, IGF_AW_CANCEL_AWD, IGF_AW_GEN, IGF_AW_GEN_003, IGF_AW_LI_IMPORT, IGF_AW_PACKAGING, IGF_DB_DISB, IGF_SL_CL_CREATE_CHG, IGF_SL_CL_ORIG, IGF_SL_CL_ORIG_ACK, IGF_SL_LAR_CREATION, and IGF_SL_REL_DISB — twelve packages in total. These correspond to award generation and packaging, disbursement processing, loan origination and acknowledgement, change creation, loan award record creation, and disbursement release. Customizations should invoke it through those calling packages rather than directly, and only after reviewing the referenced change setup and fund status data to ensure the award and loan are in a compatible state.