APPS.IGS_DA_PURGE_RQST_PKG dependencies on IGS_DA_REQ_WIF

Line 36: FROM igs_da_req_wif

32: FROM igs_da_req_ftrs
33: WHERE batch_id = p_batch_id ;
34: CURSOR cur_req_wifs IS
35: SELECT ROWID
36: FROM igs_da_req_wif
37: WHERE batch_id = p_batch_id ;
38: CURSOR cur_req_rqst IS
39: SELECT ROWID
40: FROM igs_da_rqst

Line 72: igs_da_req_wif_pkg.delete_row (

68: );
69: END LOOP;
70: --
71: FOR l_req_wifs IN cur_req_wifs LOOP
72: igs_da_req_wif_pkg.delete_row (
73: x_rowid => l_req_wifs.ROWID,
74: x_return_status => l_return_status,
75: x_msg_data => l_msg_data,
76: x_msg_count => l_msg_count

Line 196: FROM igs_da_req_wif

192: WHERE batch_id = cp_batch_id ;
193: --
194: CURSOR cur_req_wifs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
195: SELECT ROWID
196: FROM igs_da_req_wif
197: WHERE batch_id = cp_batch_id ;
198: --
199: l_return_status VARCHAR2(2000);
200: l_msg_data VARCHAR2(2000);

Line 287: igs_da_req_wif_pkg.delete_row (

283: FOR l_cur_req_wifs IN cur_req_wifs(l_cur_request.batch_id) LOOP
284: --
285: -- Deleting records from WIF Interface table
286: --
287: igs_da_req_wif_pkg.delete_row (
288: x_rowid => l_cur_req_wifs.ROWID,
289: x_return_status => l_return_status,
290: x_msg_data => l_msg_data,
291: x_msg_count => l_msg_count