APPS.IGS_DA_PURGE_RQST_PKG dependencies on IGS_DA_RQST

Line 40: FROM igs_da_rqst

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
41: WHERE batch_id = p_batch_id ;
42: --
43: l_return_status VARCHAR2(1);
44: l_msg_data VARCHAR2(2000);

Line 81: igs_da_rqst_pkg.delete_row(

77: );
78: END LOOP;
79: --
80: FOR l_req_rqst IN cur_req_rqst LOOP
81: igs_da_rqst_pkg.delete_row(
82: x_rowid => l_req_rqst.ROWID,
83: x_return_status => l_return_status,
84: x_msg_data => l_msg_data,
85: x_msg_count => l_msg_count

Line 156: FROM igs_da_rqst dar,

152: flv.meaning request_status_meaning,
153: pbv1.full_name requestor_full_name,
154: dar.creation_date,
155: dar.requestor_id
156: FROM igs_da_rqst dar,
157: igs_pe_person_base_v pbv1,
158: igs_da_cnfg dac,
159: igs_da_cnfg_req_typ dacr,
160: fnd_lookup_values_vl flv

Line 163: AND flv.lookup_type = 'IGS_DA_RQST_STATUS'

159: igs_da_cnfg_req_typ dacr,
160: fnd_lookup_values_vl flv
161: WHERE dacr.request_type_id = dar.request_type_id
162: AND dacr.purgable_ind = 'Y'
163: AND flv.lookup_type = 'IGS_DA_RQST_STATUS'
164: AND flv.lookup_code = dar.request_status
165: AND dar.batch_id = NVL(p_c_request_number, dar.batch_id)
166: AND dar.requestor_id = NVL(p_requestor_id, dar.requestor_id)
167: AND dac.responsibility_name = NVL(p_responsibility,dac.responsibility_name)

Line 184: CURSOR cur_req_stdnts (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

180: dacr.request_mode_meaning
181: FROM igs_da_cnfg_req_typ_v dacr
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: --

Line 189: CURSOR cur_req_ftrs (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
191: FROM igs_da_req_ftrs
192: WHERE batch_id = cp_batch_id ;
193: --

Line 194: CURSOR cur_req_wifs (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
196: FROM igs_da_req_wif
197: WHERE batch_id = cp_batch_id ;
198: --

Line 338: igs_da_rqst_pkg.delete_row(

334: --
335: l_count := l_count + 1;
336: --
337: -- Deleting records from Requests Interface table
338: igs_da_rqst_pkg.delete_row(
339: x_rowid => l_cur_request.rowid,
340: x_return_status => l_return_status,
341: x_msg_data => l_msg_data,
342: x_msg_count => l_msg_count