APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_DLDB_RSP_DTL

Line 107: DELETE IGF_SL_DLDB_RSP_DTL WHERE DISB_RESP_ID = l_temp.REC_ID;

103: DELETE IGF_SL_ST_RESP_DTLS WHERE STDNT_RESP_ID = l_temp.REC_ID;
104: ELSIF l_temp.LEVEL_CODE = 'AWD' THEN
105: DELETE IGF_SL_DL_RESP_DTLS WHERE DL_LOAN_RESP_ID = l_temp.REC_ID;
106: ELSIF l_temp.LEVEL_CODE = 'DL_DB' THEN
107: DELETE IGF_SL_DLDB_RSP_DTL WHERE DISB_RESP_ID = l_temp.REC_ID;
108: ELSIF l_temp.LEVEL_CODE = 'PELL' THEN
109: DELETE IGF_GR_RESP_DTLS WHERE PELL_RESP_ID = l_temp.REC_ID;
110: ELSIF l_temp.LEVEL_CODE = 'PELL_DB' THEN
111: DELETE IGF_GR_DB_RESP_DTLS WHERE DISB_RESP_ID = l_temp.REC_ID;

Line 613: FROM IGF_SL_DLDB_RSP_DTL

609: AND NVL(STATUS_CODE, '*') <> 'P';
610:
611: CURSOR get_dl_db_resp ( cp_dl_id NUMBER) IS
612: SELECT *
613: FROM IGF_SL_DLDB_RSP_DTL
614: WHERE DL_LOAN_RESP_ID = cp_dl_id
615: AND NVL(STATUS_CODE, '*') <> 'P';
616:
617: CURSOR get_dl_rec ( cp_dl_num VARCHAR2,

Line 1238: UPDATE IGF_SL_DLDB_RSP_DTL

1234: -- disbursement record not found in the system. Log a mesg.
1235: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1236: fnd_file.put_line(fnd_file.log,fnd_message.get);
1237:
1238: UPDATE IGF_SL_DLDB_RSP_DTL
1239: SET status_code = 'N'
1240: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1241: update_flag := FALSE;
1242: ELSE

Line 1246: UPDATE IGF_SL_DLDB_RSP_DTL

1242: ELSE
1243: l_tbh_disb.DISB_STATUS := 'R';
1244: --l_tbh_disb1.DISB_STATUS := 'R';
1245:
1246: UPDATE IGF_SL_DLDB_RSP_DTL
1247: SET status_code = 'P'
1248: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1249: update_flag := TRUE;
1250: END IF;

Line 1261: UPDATE IGF_SL_DLDB_RSP_DTL

1257: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1258: fnd_file.put_line(fnd_file.log,fnd_message.get);
1259:
1260: -- update the status to 'N' - Processed, Not found in the System
1261: UPDATE IGF_SL_DLDB_RSP_DTL
1262: SET STATUS_CODE = 'N'
1263: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1264: update_flag := FALSE;
1265: ELSE

Line 1282: UPDATE IGF_SL_DLDB_RSP_DTL

1278: --l_tbh_disb1.DISB_STATUS := l_dl_db_resp.RESP_CODE;
1279: --l_tbh_disb.PREV_SEQ_NUM := l_dl_db_resp.PREV_SEQ_NUM;
1280: --l_tbh_disb1.PREV_SEQ_NUM := l_dl_db_resp.PREV_SEQ_NUM;
1281:
1282: UPDATE IGF_SL_DLDB_RSP_DTL
1283: SET STATUS_CODE = 'P'
1284: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1285: update_flag := TRUE;
1286: END IF;

Line 1300: UPDATE IGF_SL_DLDB_RSP_DTL

1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);
1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);
1298: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_dl_db_resp.PREV_SEQ_NUM);
1299:
1300: UPDATE IGF_SL_DLDB_RSP_DTL
1301: SET STATUS_CODE = 'P'
1302: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1303: update_flag := FALSE;
1304: END IF;

Line 1897: UPDATE IGF_SL_DLDB_RSP_DTL

1893: UPDATE IGF_SL_DL_RESP_DTLS
1894: SET B_RESP_CODE = l_temp.RESP_CODE
1895: WHERE DL_LOAN_RESP_ID = l_temp.REC_ID;
1896: ELSIF l_temp.LEVEL_CODE = 'DL_DB' THEN
1897: UPDATE IGF_SL_DLDB_RSP_DTL
1898: SET RESP_CODE = l_temp.RESP_CODE,
1899: PREV_SEQ_NUM = l_temp.PREV_SEQ_NUM
1900: WHERE DISB_RESP_ID = l_temp.REC_ID;
1901: ELSIF l_temp.LEVEL_CODE = 'PELL' THEN