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_EN_ENROLL_WLST dependencies on IGS_PS_OFR_OPT

Line 256: sarakshi 24-Feb-2003 Enh#2797116,modified cursor igs_ps_ofr_opt_cur to include delete_flag in

252: remarks :
253:
254: Change History
255: Who When What
256: sarakshi 24-Feb-2003 Enh#2797116,modified cursor igs_ps_ofr_opt_cur to include delete_flag in
257: the where clause
258: ayedubat 30-MAY-2002 Added a new parameter,p_message_name to the Function:Enrp_Get_Rec_Window
259: call and dsiplaying the returning message for the bug fix:2337161.
260: kkillams 28-04-2003 modified igs_en_su_attempt_cur cursor where clause and impacted object,

Line 289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,

285: FROM igs_en_stdnt_ps_att
286: WHERE course_cd = cp_course_cd
287: AND person_id = cp_person_id;
288:
289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,

Line 290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,

286: WHERE course_cd = cp_course_cd
287: AND person_id = cp_person_id;
288:
289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)

Line 291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,

287: AND person_id = cp_person_id;
288:
289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)
295: IS

Line 292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,

288:
289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)
295: IS
296: SELECT location_cd,

Line 293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,

289: CURSOR igs_ps_ofr_opt_cur (cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)
295: IS
296: SELECT location_cd,
297: coo_id

Line 294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)

290: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
291: cp_cal_type IGS_PS_OFR_OPT.cal_type%TYPE,
292: cp_location_cd IGS_PS_OFR_OPT.location_cd%TYPE,
293: cp_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE,
294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)
295: IS
296: SELECT location_cd,
297: coo_id
298: FROM IGS_PS_OFR_OPT

Line 298: FROM IGS_PS_OFR_OPT

294: cp_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE)
295: IS
296: SELECT location_cd,
297: coo_id
298: FROM IGS_PS_OFR_OPT
299: WHERE course_cd = cp_course_cd
300: AND version_number = cp_version_number
301: AND cal_type = cp_cal_type
302: AND location_cd = cp_location_cd

Line 307: igs_ps_ofr_opt_cur_rec igs_ps_ofr_opt_cur%ROWTYPE;

303: AND attendance_mode = cp_attendance_mode
304: AND attendance_type = cp_attendance_type
305: AND delete_flag = 'N';
306:
307: igs_ps_ofr_opt_cur_rec igs_ps_ofr_opt_cur%ROWTYPE;
308:
309: v_duplicate_course_cd igs_en_su_attempt.course_cd%TYPE;
310:
311: BEGIN

Line 364: OPEN igs_ps_ofr_opt_cur(p_course_cd,

360: p_message_name) THEN
361: p_deny_warn := 'DENY';
362: RETURN FALSE;
363: END IF;
364: OPEN igs_ps_ofr_opt_cur(p_course_cd,
365: igs_en_stdnt_ps_att_cur_rec.version_number,
366: p_cal_type,
367: p_location_cd,
368: igs_en_stdnt_ps_att_cur_rec.attendance_mode,

Line 371: FETCH igs_ps_ofr_opt_cur INTO igs_ps_ofr_opt_cur_rec;

367: p_location_cd,
368: igs_en_stdnt_ps_att_cur_rec.attendance_mode,
369: igs_en_stdnt_ps_att_cur_rec.attendance_type);
370: LOOP
371: FETCH igs_ps_ofr_opt_cur INTO igs_ps_ofr_opt_cur_rec;
372: IF igs_ps_ofr_opt_cur%NOTFOUND THEN
373: CLOSE igs_ps_ofr_opt_cur;
374: EXIT;
375: END IF;

Line 372: IF igs_ps_ofr_opt_cur%NOTFOUND THEN

368: igs_en_stdnt_ps_att_cur_rec.attendance_mode,
369: igs_en_stdnt_ps_att_cur_rec.attendance_type);
370: LOOP
371: FETCH igs_ps_ofr_opt_cur INTO igs_ps_ofr_opt_cur_rec;
372: IF igs_ps_ofr_opt_cur%NOTFOUND THEN
373: CLOSE igs_ps_ofr_opt_cur;
374: EXIT;
375: END IF;
376:

Line 373: CLOSE igs_ps_ofr_opt_cur;

369: igs_en_stdnt_ps_att_cur_rec.attendance_type);
370: LOOP
371: FETCH igs_ps_ofr_opt_cur INTO igs_ps_ofr_opt_cur_rec;
372: IF igs_ps_ofr_opt_cur%NOTFOUND THEN
373: CLOSE igs_ps_ofr_opt_cur;
374: EXIT;
375: END IF;
376:
377: IF NOT Igs_En_Val_Sua.enrp_val_coo_loc(igs_ps_ofr_opt_cur_rec.coo_id,

Line 377: IF NOT Igs_En_Val_Sua.enrp_val_coo_loc(igs_ps_ofr_opt_cur_rec.coo_id,

373: CLOSE igs_ps_ofr_opt_cur;
374: EXIT;
375: END IF;
376:
377: IF NOT Igs_En_Val_Sua.enrp_val_coo_loc(igs_ps_ofr_opt_cur_rec.coo_id,
378: igs_ps_ofr_opt_cur_rec.location_cd,
379: p_message_name) THEN
380:
381: p_deny_warn := 'WARN';

Line 378: igs_ps_ofr_opt_cur_rec.location_cd,

374: EXIT;
375: END IF;
376:
377: IF NOT Igs_En_Val_Sua.enrp_val_coo_loc(igs_ps_ofr_opt_cur_rec.coo_id,
378: igs_ps_ofr_opt_cur_rec.location_cd,
379: p_message_name) THEN
380:
381: p_deny_warn := 'WARN';
382: fnd_message.set_name('IGS',p_message_name);

Line 383: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||

379: p_message_name) THEN
380:
381: p_deny_warn := 'WARN';
382: fnd_message.set_name('IGS',p_message_name);
383: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||
384: igs_ps_ofr_opt_cur_rec.location_cd || ' ' ||
385: fnd_message.get_string ('IGS',p_message_name));
386:
387: /**** Not Returning false as it is just a warning ***/

Line 384: igs_ps_ofr_opt_cur_rec.location_cd || ' ' ||

380:
381: p_deny_warn := 'WARN';
382: fnd_message.set_name('IGS',p_message_name);
383: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||
384: igs_ps_ofr_opt_cur_rec.location_cd || ' ' ||
385: fnd_message.get_string ('IGS',p_message_name));
386:
387: /**** Not Returning false as it is just a warning ***/
388: END IF;

Line 391: IF NOT Igs_En_Val_Sua.enrp_val_coo_mode(igs_ps_ofr_opt_cur_rec.coo_id,

387: /**** Not Returning false as it is just a warning ***/
388: END IF;
389:
390:
391: IF NOT Igs_En_Val_Sua.enrp_val_coo_mode(igs_ps_ofr_opt_cur_rec.coo_id,
392: p_unit_class,
393: p_message_name) THEN
394: p_deny_warn := 'WARN';
395: fnd_message.set_name('IGS',p_message_name);

Line 396: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||

392: p_unit_class,
393: p_message_name) THEN
394: p_deny_warn := 'WARN';
395: fnd_message.set_name('IGS',p_message_name);
396: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||
397: p_unit_class || ' ' ||
398: fnd_message.get_string ('IGS',p_message_name));
399:
400: /**** Not Returning false as it is just a warning ***/