APPS.IGS_DA_PURGE_RQST_PKG dependencies on IGS_DA_REQ_STDNTS

Line 28: FROM igs_da_req_stdnts

24: Who When What
25: *****************************************************************************/
26: CURSOR cur_req_stdnts IS
27: SELECT ROWID
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

Line 57: igs_da_req_stdnts_pkg.delete_row (

53: RAISE FND_API.G_EXC_ERROR;
54: ELSE
55: --
56: FOR l_req_stdnts IN cur_req_stdnts LOOP
57: igs_da_req_stdnts_pkg.delete_row (
58: x_rowid => l_req_stdnts.ROWID
59: );
60: END LOOP;
61: --

Line 186: FROM igs_da_req_stdnts

182: WHERE dacr.request_type_id = cp_request_type_id;
183: --
184: CURSOR cur_req_stdnts (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
185: SELECT ROWID
186: FROM igs_da_req_stdnts
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

Line 266: igs_da_req_stdnts_pkg.delete_row (

262: FOR l_cur_req_stdnts IN cur_req_stdnts (l_cur_request.batch_id) LOOP
263: --
264: -- Deleting records from Request Students Interface table
265: --
266: igs_da_req_stdnts_pkg.delete_row (
267: x_rowid => l_cur_req_stdnts.ROWID
268: );
269: END LOOP;
270: --