APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_RS_RESP_DTLS

Line 99: DELETE IGF_SL_RS_RESP_DTLS WHERE REP_SCHL_RESP_ID = l_temp.REC_ID;

95: LOOP
96: IF l_temp.LEVEL_CODE = 'CR' THEN
97: DELETE IGF_SL_CR_RESP_DTLS WHERE DOCUMENT_ID_TXT = l_temp.REC_ID;
98: ELSIF l_temp.LEVEL_CODE = 'RS' THEN
99: DELETE IGF_SL_RS_RESP_DTLS WHERE REP_SCHL_RESP_ID = l_temp.REC_ID;
100: ELSIF l_temp.LEVEL_CODE = 'AS' THEN
101: DELETE IGF_SL_AS_RESP_DTLS WHERE ATD_SCHL_RESP_ID = l_temp.REC_ID;
102: ELSIF l_temp.LEVEL_CODE = 'ST' THEN
103: DELETE IGF_SL_ST_RESP_DTLS WHERE STDNT_RESP_ID = l_temp.REC_ID;

Line 1774: FROM IGF_SL_RS_RESP_DTLS

1770: l_get_cr_resp get_cr_resp%ROWTYPE;
1771:
1772: CURSOR get_rs_resp ( cp_doc_id VARCHAR2) IS
1773: SELECT *
1774: FROM IGF_SL_RS_RESP_DTLS
1775: WHERE document_id_txt = cp_doc_id;
1776:
1777: CURSOR get_fin_smry ( cp_rep_id NUMBER) IS
1778: SELECT *

Line 1865: UPDATE IGF_SL_RS_RESP_DTLS

1861: DOC_STATUS_CODE = l_temp.DOC_STATUS_CODE,
1862: PROCESS_DATE = l_temp.PROCESS_DATE
1863: WHERE DOCUMENT_ID_TXT = l_temp.REC_ID;
1864: ELSIF l_temp.LEVEL_CODE = 'RS' THEN
1865: UPDATE IGF_SL_RS_RESP_DTLS
1866: SET RESP_CODE = l_temp.RESP_CODE
1867: WHERE REP_SCHL_RESP_ID = l_temp.REC_ID;
1868: ELSIF l_temp.LEVEL_CODE = 'AS' THEN
1869: UPDATE IGF_SL_AS_RESP_DTLS