eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_LOR

Line 621: FROM IGF_SL_LOR_LOC_ALL

617: CURSOR get_dl_rec ( cp_dl_num VARCHAR2,
618: cp_fin_awd_yr VARCHAR2
619: ) IS
620: SELECT *
621: FROM IGF_SL_LOR_LOC_ALL
622: WHERE LOAN_NUMBER = cp_dl_num
623: AND FIN_AWARD_YEAR = cp_fin_awd_yr;
624: l_dl_rec get_dl_rec%ROWTYPE;
625:

Line 639: SELECT igf_sl_lor.*

635: l_dl_db_rec get_dl_db_rec%ROWTYPE;
636:
637: -- Curosrs for the loan records updation
638: CURSOR c_tbh_cur ( cp_loan_id NUMBER) IS
639: SELECT igf_sl_lor.*
640: FROM IGF_SL_LOR
641: WHERE loan_id = cp_loan_id
642: FOR UPDATE NOWAIT;
643: l_tbh_cur c_tbh_cur%ROWTYPE;

Line 640: FROM IGF_SL_LOR

636:
637: -- Curosrs for the loan records updation
638: CURSOR c_tbh_cur ( cp_loan_id NUMBER) IS
639: SELECT igf_sl_lor.*
640: FROM IGF_SL_LOR
641: WHERE loan_id = cp_loan_id
642: FOR UPDATE NOWAIT;
643: l_tbh_cur c_tbh_cur%ROWTYPE;
644:

Line 646: SELECT igf_sl_lor_loc.*

642: FOR UPDATE NOWAIT;
643: l_tbh_cur c_tbh_cur%ROWTYPE;
644:
645: CURSOR c_tbh_cur1 ( cp_loan_id NUMBER) IS
646: SELECT igf_sl_lor_loc.*
647: FROM IGF_SL_LOR_LOC
648: WHERE loan_id = cp_loan_id
649: FOR UPDATE NOWAIT;
650: l_tbh_cur1 c_tbh_cur1%ROWTYPE;

Line 647: FROM IGF_SL_LOR_LOC

643: l_tbh_cur c_tbh_cur%ROWTYPE;
644:
645: CURSOR c_tbh_cur1 ( cp_loan_id NUMBER) IS
646: SELECT igf_sl_lor_loc.*
647: FROM IGF_SL_LOR_LOC
648: WHERE loan_id = cp_loan_id
649: FOR UPDATE NOWAIT;
650: l_tbh_cur1 c_tbh_cur1%ROWTYPE;
651:

Line 712: -- igf_sl_lor_all

708: l_tbh_cur := NULL;
709: l_tbh_cur1 := NULL;
710: l_tbh_cur2 := NULL;
711:
712: -- igf_sl_lor_all
713: OPEN c_tbh_cur(l_dl_rec.loan_id);
714: FETCH c_tbh_cur INTO l_tbh_cur;
715: CLOSE c_tbh_cur;
716:

Line 717: -- igf_sl_lor_loc_all

713: OPEN c_tbh_cur(l_dl_rec.loan_id);
714: FETCH c_tbh_cur INTO l_tbh_cur;
715: CLOSE c_tbh_cur;
716:
717: -- igf_sl_lor_loc_all
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:

Line 730: -- update the IGF_SL_LOR_ALL with ORIG_STATUS_FLAG = 'R'

726:
727: print_edits(l_dl_resp.DL_LOAN_RESP_ID,'DL');
728:
729: IF p_rej_flg = TRUE OR l_dl_resp.RESP_CODE = 'R' THEN
730: -- update the IGF_SL_LOR_ALL with ORIG_STATUS_FLAG = 'R'
731: l_tbh_cur.ORIG_STATUS_FLAG := 'R';
732:
733: -- update the IGF_SL_LOR_LOC_ALL with ORIG_STATUS_FLAG = 'R'
734: l_tbh_cur1.ORIG_STATUS_FLAG := 'R';

Line 733: -- update the IGF_SL_LOR_LOC_ALL with ORIG_STATUS_FLAG = 'R'

729: IF p_rej_flg = TRUE OR l_dl_resp.RESP_CODE = 'R' THEN
730: -- update the IGF_SL_LOR_ALL with ORIG_STATUS_FLAG = 'R'
731: l_tbh_cur.ORIG_STATUS_FLAG := 'R';
732:
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'

Line 772: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL

768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);
769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);
770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);
771:
772: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
773: l_tbh_cur.CREDIT_OVERRIDE := NVL(l_dl_resp.CRDT_DECISION_OVRD_CODE, l_tbh_cur.CREDIT_OVERRIDE);
774: l_tbh_cur.CREDIT_DECISION_DATE := NVL(l_dl_resp.CRDT_DECISION_DATE, l_tbh_cur.CREDIT_DECISION_DATE);
775: l_tbh_cur.crdt_decision_status := NVL(l_dl_resp.CRDT_DECISION_STATUS, l_tbh_cur.crdt_decision_status);
776: l_tbh_cur.PNOTE_ACCEPT_AMT := NVL(l_dl_resp.ENDORSER_AMT, l_tbh_cur.PNOTE_ACCEPT_AMT);

Line 794: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL

790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);
791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);
792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);
793:
794: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
795: l_tbh_cur.PNOTE_ID := NVL(l_dl_resp.PNOTE_MPN_ID, l_tbh_cur.PNOTE_ID);
796: l_tbh_cur.PNOTE_STATUS := NVL(l_dl_resp.MPN_STATUS_CODE, l_tbh_cur.PNOTE_STATUS);
797: l_tbh_cur.PNOTE_ACK_DATE := NVL(g_process_date, l_tbh_cur.PNOTE_ACK_DATE);
798: l_tbh_cur.PNOTE_STATUS_DATE := SYSDATE;

Line 830: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL

826:
827: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_AMT')||':' ||l_dl_resp.PYMT_SERVICER_AMT);
828: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_DATE')||':' ||l_dl_resp.PYMT_SERVICER_DATE);
829:
830: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
831: -- IN LOR_ALL OLD+NEW PYMT AMOUNT
832: l_tbh_cur1.pymt_servicer_amt := NVL(l_tbh_cur1.pymt_servicer_amt,0) + NVL(l_dl_resp.PYMT_SERVICER_AMT,0);
833: l_tbh_cur1.pymt_servicer_date := NVL(l_dl_resp.PYMT_SERVICER_DATE, l_tbh_cur1.pymt_servicer_date);
834: l_tbh_cur1.DOCUMENT_ID_TXT := g_doc_id;

Line 843: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL and the document_id also

839:
840: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT')||':' ||l_dl_resp.BOOK_LOAN_AMT);
841: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT_DATE')||':' ||l_dl_resp.BOOK_LOAN_AMT_DATE);
842:
843: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL and the document_id also
844: l_tbh_cur.BOOK_LOAN_AMT := NVL(l_dl_resp.BOOK_LOAN_AMT, l_tbh_cur.BOOK_LOAN_AMT);
845: l_tbh_cur.BOOK_LOAN_AMT_DATE := NVL(l_dl_resp.BOOK_LOAN_AMT_DATE, l_tbh_cur.BOOK_LOAN_AMT_DATE);
846: l_tbh_cur.PNOTE_BATCH_ID := g_doc_id;
847:

Line 855: igf_sl_lor_pkg.update_row (

851:
852: END IF;
853: END IF;
854:
855: igf_sl_lor_pkg.update_row (
856: X_Mode => 'R',
857: x_rowid => l_tbh_cur.row_id,
858: x_origination_id => l_tbh_cur.origination_id,
859: x_loan_id => l_tbh_cur.loan_id,

Line 983: igf_sl_lor_loc_pkg.update_row (

979: x_esign_src_typ_cd => l_tbh_cur.esign_src_typ_cd,
980: x_acad_begin_date => l_tbh_cur.acad_begin_date,
981: x_acad_end_date => l_tbh_cur.acad_end_date);
982:
983: igf_sl_lor_loc_pkg.update_row (
984: x_mode => 'R',
985: x_rowid => l_tbh_cur1.row_id,
986: x_loan_id => l_tbh_cur1.loan_id,
987: x_origination_id => l_tbh_cur1.origination_id,

Line 1807: FROM IGF_SL_LOR_LOC coddl

1803: AND codpell.s_date_of_birth = cp_dob;
1804:
1805: CURSOR get_loans_for_student ( cp_ssn VARCHAR2, cp_lname VARCHAR2, cp_dob DATE) IS
1806: SELECT coddl.*
1807: FROM IGF_SL_LOR_LOC coddl
1808: WHERE coddl.s_ssn = cp_ssn
1809: AND coddl.s_last_name = cp_lname
1810: AND coddl.s_date_of_birth = cp_dob;
1811:

Line 2201: igf_sl_lor_loc_pkg.update_row (

2197:
2198: -- Update student loan records with new student identifier info.
2199: FOR rec IN get_loans_for_student(l_st_resp.s_ssn,l_st_resp.s_last_name,l_st_resp.s_date_of_birth)
2200: LOOP
2201: igf_sl_lor_loc_pkg.update_row (
2202: x_mode => 'R',
2203: x_rowid => rec.row_id,
2204: x_loan_id => rec.loan_id,
2205: x_origination_id => rec.origination_id,