APPS.IGF_SL_UPLOAD_XML dependencies on IGF_GR_RESP_DTLS

Line 109: DELETE IGF_GR_RESP_DTLS WHERE PELL_RESP_ID = l_temp.REC_ID;

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;
112: ELSIF l_temp.LEVEL_CODE = 'DL_INFO' THEN
113: DELETE IGF_SL_DI_RESP_DTLS WHERE DL_INFO_ID = l_temp.REC_ID;

Line 1375: FROM IGF_GR_RESP_DTLS

1371: AS
1372:
1373: CURSOR get_pell_resp ( cp_st_id NUMBER) IS
1374: SELECT *
1375: FROM IGF_GR_RESP_DTLS
1376: WHERE STDNT_RESP_ID = cp_st_id
1377: AND NVL(STATUS_CODE, '*') <> 'P';
1378:
1379: CURSOR get_pell_db_resp (cp_pell_id NUMBER) IS

Line 1463: UPDATE IGF_GR_RESP_DTLS

1459: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1460: fnd_file.put_line(fnd_file.log,fnd_message.get);
1461:
1462: -- Update the status to 'N' - Processed, Not found in the System
1463: UPDATE IGF_GR_RESP_DTLS
1464: SET STATUS_CODE = 'N'
1465: WHERE PELL_RESP_ID = l_pell_resp.PELL_RESP_ID;
1466: ELSE
1467:

Line 1504: CPS_VERIF_FLAG, HIGH_CPS_TRANS_NUM FROM IGF_GR_RESP_DTLS

1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);
1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);
1502:
1503: /*SELECT THE COLUMNS YTD_DISB_AMT, TOT_ELIG_USED, SCHD_PELL_AMT, NEG_PEND_AMT, FSA_CODE_1,FSA_CODE_2,FSA_CODE_3,PELL_STATUS
1504: CPS_VERIF_FLAG, HIGH_CPS_TRANS_NUM FROM IGF_GR_RESP_DTLS
1505: Also update the fields YTD_DISB_AMT, TOT_ELIG_USED, PENDING_AMOUNT,ORIG_aCTION_CODE in the table IGF_GR_RFMS_ALL
1506: */--dont
1507: l_tbh_pell.ORIG_ACTION_CODE := l_pell_resp.RESP_CODE;
1508: END IF;

Line 1568: UPDATE IGF_GR_RESP_DTLS

1564: x_full_resp_code => l_tbh_pell.full_resp_code ,
1565: x_document_id_txt => l_tbh_pell.document_id_txt
1566: );
1567:
1568: UPDATE IGF_GR_RESP_DTLS
1569: SET STATUS_CODE = 'P'
1570: WHERE PELL_RESP_ID = l_pell_resp.PELL_RESP_ID;
1571:
1572: -- start the processing of pell disbursements

Line 1902: UPDATE IGF_GR_RESP_DTLS

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
1902: UPDATE IGF_GR_RESP_DTLS
1903: SET RESP_CODE = l_temp.RESP_CODE,
1904: YTD_DISB_AMT = l_temp.YTD_DISB_AMT,
1905: TOT_ELIG_USED = l_temp.TOT_ELIG_USED,
1906: SCHD_PELL_AMT = l_temp.SCHD_PELL_AMT,