APPS.IGF_SL_LOANS_PKG dependencies on IGF_AW_DB_CHG_DTLS

Line 361: CURSOR cur_sent_disb_chg_records(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

357: || g_v_called_from IN ('IGFSL005','UPDATE_MODE') is needed so that change records are created from both the form and update mode
358: || (reverse chronological order - newest change first)
359: --------------------------------------------------------------------*/
360: -- Cursor to pick All disb change records in SENT status.
361: CURSOR cur_sent_disb_chg_records(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
362: SELECT dbchgdtls.ROWID, dbchgdtls.*
363: FROM IGF_AW_DB_CHG_DTLS dbchgdtls
364: WHERE dbchgdtls.award_id = cp_award_id
365: AND dbchgdtls.disb_status = 'S';

Line 363: FROM IGF_AW_DB_CHG_DTLS dbchgdtls

359: --------------------------------------------------------------------*/
360: -- Cursor to pick All disb change records in SENT status.
361: CURSOR cur_sent_disb_chg_records(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
362: SELECT dbchgdtls.ROWID, dbchgdtls.*
363: FROM IGF_AW_DB_CHG_DTLS dbchgdtls
364: WHERE dbchgdtls.award_id = cp_award_id
365: AND dbchgdtls.disb_status = 'S';
366:
367: -- bvisvana - FA 161 - Bug 5091652..Cursor to pick all the change records for the loan

Line 430: igf_aw_db_chg_dtls_pkg.update_row (

426: (NVL(new_references.loan_chg_status, '*') = 'G' AND NVL(old_references.loan_chg_status,'*') <> 'G')
427: THEN
428: -- update disbursement change records(which are in "Sent" ONLY) status to "Ready to Send"
429: FOR rec IN cur_sent_disb_chg_records(new_references.award_id) LOOP
430: igf_aw_db_chg_dtls_pkg.update_row (
431: x_rowid => rec.ROWID,
432: x_award_id => rec.award_id,
433: x_disb_num => rec.disb_num,
434: x_disb_seq_num => rec.disb_seq_num,