APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_LOANS

Line 653: SELECT igf_sl_loans.*

649: FOR UPDATE NOWAIT;
650: l_tbh_cur1 c_tbh_cur1%ROWTYPE;
651:
652: CURSOR c_tbh_cur2 ( cp_loan_id NUMBER) IS
653: SELECT igf_sl_loans.*
654: FROM IGF_SL_LOANS
655: WHERE loan_id = cp_loan_id
656: FOR UPDATE NOWAIT;
657: l_tbh_cur2 c_tbh_cur2%ROWTYPE;

Line 654: FROM IGF_SL_LOANS

650: l_tbh_cur1 c_tbh_cur1%ROWTYPE;
651:
652: CURSOR c_tbh_cur2 ( cp_loan_id NUMBER) IS
653: SELECT igf_sl_loans.*
654: FROM IGF_SL_LOANS
655: WHERE loan_id = cp_loan_id
656: FOR UPDATE NOWAIT;
657: l_tbh_cur2 c_tbh_cur2%ROWTYPE;
658:

Line 722: -- igf_sl_loans

718: OPEN c_tbh_cur1(l_dl_rec.loan_id);
719: FETCH c_tbh_cur1 INTO l_tbh_cur1;
720: CLOSE c_tbh_cur1;
721:
722: -- igf_sl_loans
723: OPEN c_tbh_cur2(l_dl_rec.loan_id);
724: FETCH c_tbh_cur2 INTO l_tbh_cur2;
725: CLOSE c_tbh_cur2;
726:

Line 737: -- update IGF_SL_LOANS_ALL with LOAN_STATUS or LOAN_CHG_STATUS = 'R'

733: -- update the IGF_SL_LOR_LOC_ALL with ORIG_STATUS_FLAG = 'R'
734: l_tbh_cur1.ORIG_STATUS_FLAG := 'R';
735: l_tbh_cur1.document_id_txt := g_doc_id;
736:
737: -- update IGF_SL_LOANS_ALL with LOAN_STATUS or LOAN_CHG_STATUS = 'R'
738: IF l_tbh_cur2.LOAN_STATUS = 'S' THEN
739: l_tbh_cur2.LOAN_STATUS := 'R';
740: l_tbh_cur2.LOAN_STATUS_DATE := SYSDATE;
741: ELSIF l_tbh_cur2.LOAN_CHG_STATUS = 'S' THEN -- change down

Line 1184: igf_sl_loans_pkg.update_row (

1180: x_student_electronic_sign_flag => l_tbh_cur1.student_electronic_sign_flag,
1181: x_esign_src_typ_cd => l_tbh_cur1.esign_src_typ_cd
1182: );
1183:
1184: igf_sl_loans_pkg.update_row (
1185: x_mode => 'R',
1186: x_rowid => l_tbh_cur2.row_id,
1187: x_loan_id => l_tbh_cur2.loan_id,
1188: x_award_id => l_tbh_cur2.award_id,