DBA Data[Home] [Help]

APPS.IGS_DA_PURGE_RQST_PKG dependencies on IGS_DA_REQ_FTRS

Line 32: FROM igs_da_req_ftrs

28: FROM igs_da_req_stdnts
29: WHERE batch_id = p_batch_id ;
30: CURSOR cur_req_ftrs IS
31: SELECT ROWID
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

Line 63: igs_da_req_ftrs_pkg.delete_row (

59: );
60: END LOOP;
61: --
62: FOR l_req_ftrs IN cur_req_ftrs LOOP
63: igs_da_req_ftrs_pkg.delete_row (
64: x_rowid => l_req_ftrs.ROWID,
65: x_return_status => l_return_status,
66: x_msg_data => l_msg_data,
67: x_msg_count => l_msg_count

Line 191: FROM igs_da_req_ftrs

187: WHERE batch_id = cp_batch_id ;
188: --
189: CURSOR cur_req_ftrs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
190: SELECT ROWID
191: FROM igs_da_req_ftrs
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

Line 275: igs_da_req_ftrs_pkg.delete_row (

271: FOR l_cur_req_ftrs IN cur_req_ftrs(l_cur_request.batch_id) LOOP
272: --
273: -- Deleting records from Request Feature Interface table
274: --
275: igs_da_req_ftrs_pkg.delete_row (
276: x_rowid => l_cur_req_ftrs.ROWID,
277: x_return_status => l_return_status,
278: x_msg_data => l_msg_data,
279: x_msg_count => l_msg_count