DBA Data[Home] [Help]

APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_DI_RESP_DTLS

Line 113: DELETE IGF_SL_DI_RESP_DTLS WHERE DL_INFO_ID = l_temp.REC_ID;

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;
114: END IF;
115: END LOOP;
116:
117: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1920: UPDATE IGF_SL_DI_RESP_DTLS

1916: SET RESP_CODE = l_temp.RESP_CODE,
1917: PREV_SEQ_NUM = l_temp.PREV_SEQ_NUM
1918: WHERE DISB_RESP_ID = l_temp.REC_ID;
1919: ELSIF l_temp.LEVEL_CODE = 'DL_INFO' THEN
1920: UPDATE IGF_SL_DI_RESP_DTLS
1921: SET RESP_CODE = l_temp.RESP_CODE
1922: WHERE DL_INFO_ID = l_temp.REC_ID;
1923: END IF;
1924: END LOOP;