APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_LOR_LOC_ALL

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 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 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: