eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_DA_UTILS_PKG dependencies on IGS_DA_RQST

Line 41: FROM IGS_DA_RQST da

37: DECLARE
38:
39: CURSOR c_da_rqst IS
40: SELECT rowid, da.*
41: FROM IGS_DA_RQST da
42: WHERE BATCH_ID = p_batch_id;
43:
44: -- Declare local variables :
45: V_RETURN_STATUS VARCHAR2(30);

Line 55: IGS_DA_RQST_PKG.UPDATE_ROW(

51: OPEN c_da_rqst;
52: FETCH c_da_rqst INTO v_da_rqst;
53: IF c_da_rqst%ROWCOUNT = 1 THEN
54: -- call update_row
55: IGS_DA_RQST_PKG.UPDATE_ROW(
56: X_ROWID => v_da_rqst.ROWID ,
57: X_BATCH_ID => v_da_rqst.BATCH_ID ,
58: X_REQUEST_TYPE_ID => v_da_rqst.REQUEST_TYPE_ID ,
59: X_REQUEST_MODE => v_da_rqst.REQUEST_MODE ,

Line 143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

139: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
140: SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;
141: l_is_filename_null varchar2(1) := 'N';
142:
143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
144: SELECT dr.rowid, dr.*
145: FROM igs_da_rqst dr
146: WHERE batch_id = cp_batch_id;
147: rec_igs_da_rqst c_igs_da_rqst%ROWTYPE;

Line 145: FROM igs_da_rqst dr

141: l_is_filename_null varchar2(1) := 'N';
142:
143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
144: SELECT dr.rowid, dr.*
145: FROM igs_da_rqst dr
146: WHERE batch_id = cp_batch_id;
147: rec_igs_da_rqst c_igs_da_rqst%ROWTYPE;
148:
149: l_stc_stud_grp_mem VARCHAR2(2000) := ' SELECT person_id FROM igs_pe_prsid_grp_mem WHERE group_id = :1 ';

Line 147: rec_igs_da_rqst c_igs_da_rqst%ROWTYPE;

143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
144: SELECT dr.rowid, dr.*
145: FROM igs_da_rqst dr
146: WHERE batch_id = cp_batch_id;
147: rec_igs_da_rqst c_igs_da_rqst%ROWTYPE;
148:
149: l_stc_stud_grp_mem VARCHAR2(2000) := ' SELECT person_id FROM igs_pe_prsid_grp_mem WHERE group_id = :1 ';
150: l_dyn_stud_grp_mem VARCHAR2(2000);
151:

Line 152: CURSOR c_igs_da_rec_wif (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

148:
149: l_stc_stud_grp_mem VARCHAR2(2000) := ' SELECT person_id FROM igs_pe_prsid_grp_mem WHERE group_id = :1 ';
150: l_dyn_stud_grp_mem VARCHAR2(2000);
151:
152: CURSOR c_igs_da_rec_wif (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
153: SELECT *
154: FROM igs_da_req_wif
155: WHERE batch_id = cp_batch_id;
156:

Line 157: CURSOR c_prog_attempt (cp_person_id igs_da_rqst.person_id%TYPE) IS

153: SELECT *
154: FROM igs_da_req_wif
155: WHERE batch_id = cp_batch_id;
156:
157: CURSOR c_prog_attempt (cp_person_id igs_da_rqst.person_id%TYPE) IS
158: SELECT course_cd
159: FROM igs_en_stdnt_ps_att
160: WHERE person_id = cp_person_id
161: AND course_attempt_status NOT IN ('DISCONTIN','UNCONFIRM');

Line 163: CURSOR c_dff (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

159: FROM igs_en_stdnt_ps_att
160: WHERE person_id = cp_person_id
161: AND course_attempt_status NOT IN ('DISCONTIN','UNCONFIRM');
162:
163: CURSOR c_dff (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
164: SELECT crt.*
165: FROM igs_da_cnfg_req_typ crt,
166: igs_da_rqst dr
167: WHERE crt.request_type_id = dr.request_type_id

Line 166: igs_da_rqst dr

162:
163: CURSOR c_dff (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
164: SELECT crt.*
165: FROM igs_da_cnfg_req_typ crt,
166: igs_da_rqst dr
167: WHERE crt.request_type_id = dr.request_type_id
168: AND dr.batch_id = cp_batch_id;
169: rec_dff c_dff%ROWTYPE;
170:

Line 171: CURSOR c_req_ftrs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

167: WHERE crt.request_type_id = dr.request_type_id
168: AND dr.batch_id = cp_batch_id;
169: rec_dff c_dff%ROWTYPE;
170:
171: CURSOR c_req_ftrs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
172: SELECT cf.feature_code,
173: cf.feature_value
174: FROM igs_da_cnfg_ftr cf,
175: igs_da_rqst dr

Line 175: igs_da_rqst dr

171: CURSOR c_req_ftrs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
172: SELECT cf.feature_code,
173: cf.feature_value
174: FROM igs_da_cnfg_ftr cf,
175: igs_da_rqst dr
176: WHERE dr.request_type_id = cf.request_type_id
177: AND dr.batch_id = cp_batch_id
178: AND cf.feature_code IN (SELECT feature_code
179: FROM igs_da_cnfg_ftr cf_in

Line 187: OPEN c_igs_da_rqst (p_batch_id);

183: FROM igs_da_req_ftrs rf_in
184: WHERE rf_in.batch_id = dr.batch_id);
185: BEGIN
186: FND_MSG_PUB.initialize;
187: OPEN c_igs_da_rqst (p_batch_id);
188: LOOP
189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;
190: EXIT WHEN c_igs_da_rqst%NOTFOUND;
191: -- check whether the dynamic persid group has to be used or not

Line 189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;

185: BEGIN
186: FND_MSG_PUB.initialize;
187: OPEN c_igs_da_rqst (p_batch_id);
188: LOOP
189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;
190: EXIT WHEN c_igs_da_rqst%NOTFOUND;
191: -- check whether the dynamic persid group has to be used or not
192: OPEN c_is_filename_null (rec_igs_da_rqst.person_id_group_id);
193: FETCH c_is_filename_null INTO l_is_filename_null;

Line 190: EXIT WHEN c_igs_da_rqst%NOTFOUND;

186: FND_MSG_PUB.initialize;
187: OPEN c_igs_da_rqst (p_batch_id);
188: LOOP
189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;
190: EXIT WHEN c_igs_da_rqst%NOTFOUND;
191: -- check whether the dynamic persid group has to be used or not
192: OPEN c_is_filename_null (rec_igs_da_rqst.person_id_group_id);
193: FETCH c_is_filename_null INTO l_is_filename_null;
194: CLOSE c_is_filename_null;

Line 192: OPEN c_is_filename_null (rec_igs_da_rqst.person_id_group_id);

188: LOOP
189: FETCH c_igs_da_rqst INTO rec_igs_da_rqst;
190: EXIT WHEN c_igs_da_rqst%NOTFOUND;
191: -- check whether the dynamic persid group has to be used or not
192: OPEN c_is_filename_null (rec_igs_da_rqst.person_id_group_id);
193: FETCH c_is_filename_null INTO l_is_filename_null;
194: CLOSE c_is_filename_null;
195:
196: IF rec_igs_da_rqst.program_comparison_type = 'SP' THEN

Line 196: IF rec_igs_da_rqst.program_comparison_type = 'SP' THEN

192: OPEN c_is_filename_null (rec_igs_da_rqst.person_id_group_id);
193: FETCH c_is_filename_null INTO l_is_filename_null;
194: CLOSE c_is_filename_null;
195:
196: IF rec_igs_da_rqst.program_comparison_type = 'SP' THEN
197: -- insert a corresponding record in igs_da_req_stdnts if a single student
198: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
199: l_rowid := null;
200: l_igs_da_req_stdnts_id := null;

Line 198: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN

194: CLOSE c_is_filename_null;
195:
196: IF rec_igs_da_rqst.program_comparison_type = 'SP' THEN
197: -- insert a corresponding record in igs_da_req_stdnts if a single student
198: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
199: l_rowid := null;
200: l_igs_da_req_stdnts_id := null;
201: igs_da_req_stdnts_pkg.insert_row (
202: X_ROWID => l_rowid,

Line 203: X_BATCH_ID => rec_igs_da_rqst.batch_id,

199: l_rowid := null;
200: l_igs_da_req_stdnts_id := null;
201: igs_da_req_stdnts_pkg.insert_row (
202: X_ROWID => l_rowid,
203: X_BATCH_ID => rec_igs_da_rqst.batch_id,
204: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
205: X_PERSON_ID => rec_igs_da_rqst.person_id,
206: X_PROGRAM_CODE => NULL,
207: X_WIF_PROGRAM_CODE => NULL,

Line 205: X_PERSON_ID => rec_igs_da_rqst.person_id,

201: igs_da_req_stdnts_pkg.insert_row (
202: X_ROWID => l_rowid,
203: X_BATCH_ID => rec_igs_da_rqst.batch_id,
204: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
205: X_PERSON_ID => rec_igs_da_rqst.person_id,
206: X_PROGRAM_CODE => NULL,
207: X_WIF_PROGRAM_CODE => NULL,
208: X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,
209: X_MAJOR_UNIT_SET_CD => NULL,

Line 208: X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,

204: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
205: X_PERSON_ID => rec_igs_da_rqst.person_id,
206: X_PROGRAM_CODE => NULL,
207: X_WIF_PROGRAM_CODE => NULL,
208: X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,
209: X_MAJOR_UNIT_SET_CD => NULL,
210: X_PROGRAM_MAJOR_CODE => NULL,
211: X_REPORT_TEXT => NULL,
212: X_WIF_ID => NULL,

Line 218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

214: x_error_code => NULL
215: );
216: ELSE
217: IF l_is_filename_null = 'N' THEN
218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
220: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
221: FND_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;

Line 226: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
225: ELSE
226: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;
227: END IF;
228: LOOP
229: FETCH c_stud_grp_mem INTO l_person_id;
230: EXIT WHEN c_stud_grp_mem%NOTFOUND;

Line 235: X_BATCH_ID => rec_igs_da_rqst.batch_id,

231: l_rowid := null;
232: l_igs_da_req_stdnts_id := null;
233: igs_da_req_stdnts_pkg.insert_row (
234: X_ROWID => l_rowid,
235: X_BATCH_ID => rec_igs_da_rqst.batch_id,
236: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
237: X_PERSON_ID => l_person_id,
238: X_PROGRAM_CODE => NULL,
239: X_WIF_PROGRAM_CODE => NULL,

Line 240: X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,

236: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
237: X_PERSON_ID => l_person_id,
238: X_PROGRAM_CODE => NULL,
239: X_WIF_PROGRAM_CODE => NULL,
240: X_SPECIAL_PROGRAM_CODE => rec_igs_da_rqst.special_program,
241: X_MAJOR_UNIT_SET_CD => NULL,
242: X_PROGRAM_MAJOR_CODE => NULL,
243: X_REPORT_TEXT => NULL,
244: X_WIF_ID => NULL,

Line 250: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' SP

246: x_error_code => NULL
247: );
248: END LOOP;
249: CLOSE c_stud_grp_mem;
250: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' SP
251: ELSIF rec_igs_da_rqst.program_comparison_type = 'WIF' THEN
252: FOR rec_igs_da_rec_wif IN c_igs_da_rec_wif(rec_igs_da_rqst.batch_id) LOOP
253: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
254: l_rowid := null;

Line 251: ELSIF rec_igs_da_rqst.program_comparison_type = 'WIF' THEN

247: );
248: END LOOP;
249: CLOSE c_stud_grp_mem;
250: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' SP
251: ELSIF rec_igs_da_rqst.program_comparison_type = 'WIF' THEN
252: FOR rec_igs_da_rec_wif IN c_igs_da_rec_wif(rec_igs_da_rqst.batch_id) LOOP
253: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
254: l_rowid := null;
255: l_igs_da_req_stdnts_id := null;

Line 252: FOR rec_igs_da_rec_wif IN c_igs_da_rec_wif(rec_igs_da_rqst.batch_id) LOOP

248: END LOOP;
249: CLOSE c_stud_grp_mem;
250: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' SP
251: ELSIF rec_igs_da_rqst.program_comparison_type = 'WIF' THEN
252: FOR rec_igs_da_rec_wif IN c_igs_da_rec_wif(rec_igs_da_rqst.batch_id) LOOP
253: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
254: l_rowid := null;
255: l_igs_da_req_stdnts_id := null;
256: igs_da_req_stdnts_pkg.insert_row (

Line 253: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN

249: CLOSE c_stud_grp_mem;
250: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' SP
251: ELSIF rec_igs_da_rqst.program_comparison_type = 'WIF' THEN
252: FOR rec_igs_da_rec_wif IN c_igs_da_rec_wif(rec_igs_da_rqst.batch_id) LOOP
253: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
254: l_rowid := null;
255: l_igs_da_req_stdnts_id := null;
256: igs_da_req_stdnts_pkg.insert_row (
257: X_ROWID => l_rowid,

Line 258: X_BATCH_ID => rec_igs_da_rqst.batch_id,

254: l_rowid := null;
255: l_igs_da_req_stdnts_id := null;
256: igs_da_req_stdnts_pkg.insert_row (
257: X_ROWID => l_rowid,
258: X_BATCH_ID => rec_igs_da_rqst.batch_id,
259: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
260: X_PERSON_ID => rec_igs_da_rqst.person_id,
261: X_PROGRAM_CODE => NULL,
262: X_WIF_PROGRAM_CODE => rec_igs_da_rec_wif.program_code,

Line 260: X_PERSON_ID => rec_igs_da_rqst.person_id,

256: igs_da_req_stdnts_pkg.insert_row (
257: X_ROWID => l_rowid,
258: X_BATCH_ID => rec_igs_da_rqst.batch_id,
259: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
260: X_PERSON_ID => rec_igs_da_rqst.person_id,
261: X_PROGRAM_CODE => NULL,
262: X_WIF_PROGRAM_CODE => rec_igs_da_rec_wif.program_code,
263: X_SPECIAL_PROGRAM_CODE => NULL,
264: X_MAJOR_UNIT_SET_CD => rec_igs_da_rec_wif.major_unit_set_cd1,

Line 273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

269: x_error_code => NULL
270: );
271: ELSE
272: IF l_is_filename_null = 'N' THEN
273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
276: FND_MSG_PUB.ADD;
277: RAISE FND_API.G_EXC_ERROR;

Line 281: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
280: ELSE
281: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;
282: END IF;
283: LOOP
284: FETCH c_stud_grp_mem INTO l_person_id;
285: EXIT WHEN c_stud_grp_mem%NOTFOUND;

Line 290: X_BATCH_ID => rec_igs_da_rqst.batch_id,

286: l_rowid := null;
287: l_igs_da_req_stdnts_id := null;
288: igs_da_req_stdnts_pkg.insert_row (
289: X_ROWID => l_rowid,
290: X_BATCH_ID => rec_igs_da_rqst.batch_id,
291: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
292: X_PERSON_ID => l_person_id,
293: X_PROGRAM_CODE => NULL,
294: X_WIF_PROGRAM_CODE => rec_igs_da_rec_wif.program_code,

Line 305: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' WIF

301: x_error_code => NULL
302: );
303: END LOOP;
304: CLOSE c_stud_grp_mem;
305: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' WIF
306: END LOOP;
307:
308: ELSIF rec_igs_da_rqst.program_comparison_type = 'DP' THEN
309: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN

Line 308: ELSIF rec_igs_da_rqst.program_comparison_type = 'DP' THEN

304: CLOSE c_stud_grp_mem;
305: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' WIF
306: END LOOP;
307:
308: ELSIF rec_igs_da_rqst.program_comparison_type = 'DP' THEN
309: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
310: -- insert each program attempt of the student
311: FOR rec_prog_attempt IN c_prog_attempt (rec_igs_da_rqst.person_id) LOOP
312: l_rowid := null;

Line 309: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN

305: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' WIF
306: END LOOP;
307:
308: ELSIF rec_igs_da_rqst.program_comparison_type = 'DP' THEN
309: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
310: -- insert each program attempt of the student
311: FOR rec_prog_attempt IN c_prog_attempt (rec_igs_da_rqst.person_id) LOOP
312: l_rowid := null;
313: l_igs_da_req_stdnts_id := null;

Line 311: FOR rec_prog_attempt IN c_prog_attempt (rec_igs_da_rqst.person_id) LOOP

307:
308: ELSIF rec_igs_da_rqst.program_comparison_type = 'DP' THEN
309: IF rec_igs_da_rqst.request_mode = 'SINGLE' THEN
310: -- insert each program attempt of the student
311: FOR rec_prog_attempt IN c_prog_attempt (rec_igs_da_rqst.person_id) LOOP
312: l_rowid := null;
313: l_igs_da_req_stdnts_id := null;
314: igs_da_req_stdnts_pkg.insert_row (
315: X_ROWID => l_rowid,

Line 316: X_BATCH_ID => rec_igs_da_rqst.batch_id,

312: l_rowid := null;
313: l_igs_da_req_stdnts_id := null;
314: igs_da_req_stdnts_pkg.insert_row (
315: X_ROWID => l_rowid,
316: X_BATCH_ID => rec_igs_da_rqst.batch_id,
317: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
318: X_PERSON_ID => rec_igs_da_rqst.person_id,
319: X_PROGRAM_CODE => rec_prog_attempt.course_cd,
320: X_WIF_PROGRAM_CODE => NULL,

Line 318: X_PERSON_ID => rec_igs_da_rqst.person_id,

314: igs_da_req_stdnts_pkg.insert_row (
315: X_ROWID => l_rowid,
316: X_BATCH_ID => rec_igs_da_rqst.batch_id,
317: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
318: X_PERSON_ID => rec_igs_da_rqst.person_id,
319: X_PROGRAM_CODE => rec_prog_attempt.course_cd,
320: X_WIF_PROGRAM_CODE => NULL,
321: X_SPECIAL_PROGRAM_CODE => NULL,
322: X_MAJOR_UNIT_SET_CD => NULL,

Line 332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);

328: );
329: END LOOP;
330: ELSE
331: IF l_is_filename_null = 'N' THEN
332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;

Line 340: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
339: ELSE
340: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;
341: END IF;
342: LOOP
343: FETCH c_stud_grp_mem INTO l_person_id;
344: EXIT WHEN c_stud_grp_mem%NOTFOUND;

Line 350: X_BATCH_ID => rec_igs_da_rqst.batch_id,

346: l_rowid := null;
347: l_igs_da_req_stdnts_id := null;
348: igs_da_req_stdnts_pkg.insert_row (
349: X_ROWID => l_rowid,
350: X_BATCH_ID => rec_igs_da_rqst.batch_id,
351: X_IGS_DA_REQ_STDNTS_ID => l_igs_da_req_stdnts_id,
352: X_PERSON_ID => l_person_id,
353: X_PROGRAM_CODE => rec_prog_attempt.course_cd,
354: X_WIF_PROGRAM_CODE => NULL,

Line 366: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' DP

362: );
363: END LOOP;
364: END LOOP;
365: CLOSE c_stud_grp_mem;
366: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' DP
367: END IF; -- rec_igs_da_rqst.program_comparison_type = 'SP''
368: /*
369: copy the DFF values from IGS_DA_CNFG_REQ_TYP to IGS_DARQST
370: */

Line 367: END IF; -- rec_igs_da_rqst.program_comparison_type = 'SP''

363: END LOOP;
364: END LOOP;
365: CLOSE c_stud_grp_mem;
366: END IF; -- rec_igs_da_rqst.request_mode = 'SINGLE' DP
367: END IF; -- rec_igs_da_rqst.program_comparison_type = 'SP''
368: /*
369: copy the DFF values from IGS_DA_CNFG_REQ_TYP to IGS_DARQST
370: */
371: OPEN c_dff(p_batch_id);

Line 374: igs_da_rqst_pkg.update_row

370: */
371: OPEN c_dff(p_batch_id);
372: FETCH c_dff INTO rec_dff;
373: CLOSE c_dff;
374: igs_da_rqst_pkg.update_row
375: (
376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,

Line 376: X_ROWID => rec_igs_da_rqst.rowid ,

372: FETCH c_dff INTO rec_dff;
373: CLOSE c_dff;
374: igs_da_rqst_pkg.update_row
375: (
376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,

Line 377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,

373: CLOSE c_dff;
374: igs_da_rqst_pkg.update_row
375: (
376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,

Line 378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,

374: igs_da_rqst_pkg.update_row
375: (
376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,

Line 379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,

375: (
376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,

Line 380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,

376: X_ROWID => rec_igs_da_rqst.rowid ,
377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,

Line 381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,

377: X_BATCH_ID => rec_igs_da_rqst.batch_id ,
378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,

Line 382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,

378: X_REQUEST_TYPE_ID => rec_igs_da_rqst.request_type_id ,
379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,

Line 383: X_PERSON_ID => rec_igs_da_rqst.person_id ,

379: X_REQUEST_MODE => rec_igs_da_rqst.request_mode ,
380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,

Line 384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,

380: X_PROGRAM_COMPARISON_TYPE => rec_igs_da_rqst.program_comparison_type ,
381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,
388: X_ATTRIBUTE_CATEGORY => rec_dff.attribute_category ,

Line 385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,

381: X_REQUEST_STATUS => rec_igs_da_rqst.request_status ,
382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,
388: X_ATTRIBUTE_CATEGORY => rec_dff.attribute_category ,
389: X_ATTRIBUTE1 => rec_dff.attribute1 ,

Line 386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,

382: X_PERSON_ID_GROUP_ID => rec_igs_da_rqst.person_id_group_id ,
383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,
388: X_ATTRIBUTE_CATEGORY => rec_dff.attribute_category ,
389: X_ATTRIBUTE1 => rec_dff.attribute1 ,
390: X_ATTRIBUTE2 => rec_dff.attribute2 ,

Line 387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,

383: X_PERSON_ID => rec_igs_da_rqst.person_id ,
384: X_REQUESTOR_ID => rec_igs_da_rqst.requestor_id ,
385: X_STUDENT_RELEASE_IND => rec_igs_da_rqst.student_release_ind ,
386: X_SPECIAL_PROGRAM => rec_igs_da_rqst.special_program ,
387: X_SPECIAL_PROGRAM_CATALOG => rec_igs_da_rqst.special_program_catalog ,
388: X_ATTRIBUTE_CATEGORY => rec_dff.attribute_category ,
389: X_ATTRIBUTE1 => rec_dff.attribute1 ,
390: X_ATTRIBUTE2 => rec_dff.attribute2 ,
391: X_ATTRIBUTE3 => rec_dff.attribute3 ,

Line 421: CLOSE c_igs_da_rqst;

417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: END LOOP;
421: CLOSE c_igs_da_rqst;
422:
423: /*
424: now insert the records (IGS_DA_CNFG_FTR) not shown to the user
425: in the table IGS_DA_REQ_FTRS