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_EN_STDNT_PS_ATT

Line 278: CURSOR igs_en_stdnt_ps_att_cur (cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

274: AND course_cd = cp_course_cd
275: AND uoo_id = cp_uoo_id;
276:
277:
278: CURSOR igs_en_stdnt_ps_att_cur (cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
279: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE)
280: IS
281: SELECT version_number,
282: attendance_mode,

Line 279: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE)

275: AND uoo_id = cp_uoo_id;
276:
277:
278: CURSOR igs_en_stdnt_ps_att_cur (cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
279: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE)
280: IS
281: SELECT version_number,
282: attendance_mode,
283: attendance_type,

Line 285: FROM igs_en_stdnt_ps_att

281: SELECT version_number,
282: attendance_mode,
283: attendance_type,
284: course_attempt_status
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,

Line 315: FOR igs_en_stdnt_ps_att_cur_rec IN igs_en_stdnt_ps_att_cur(p_course_cd,

311: BEGIN
312:
313: FOR igs_en_su_attempt_cur_rec IN igs_en_su_attempt_cur(p_person_id,p_course_cd,p_uoo_id) LOOP
314:
315: FOR igs_en_stdnt_ps_att_cur_rec IN igs_en_stdnt_ps_att_cur(p_course_cd,
316: p_person_id) LOOP
317:
318: IF NOT Igs_En_Val_Sua.enrp_val_sua_advstnd(p_person_id,
319: p_course_cd,

Line 320: igs_en_stdnt_ps_att_cur_rec.version_number,

316: p_person_id) LOOP
317:
318: IF NOT Igs_En_Val_Sua.enrp_val_sua_advstnd(p_person_id,
319: p_course_cd,
320: igs_en_stdnt_ps_att_cur_rec.version_number,
321: p_unit_cd,
322: p_version_number,
323: p_message_name ,
324: 'N' ) THEN

Line 365: igs_en_stdnt_ps_att_cur_rec.version_number,

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,
369: igs_en_stdnt_ps_att_cur_rec.attendance_type);

Line 368: igs_en_stdnt_ps_att_cur_rec.attendance_mode,

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,
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

Line 369: igs_en_stdnt_ps_att_cur_rec.attendance_type);

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,
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;

Line 472: FROM igs_en_stdnt_ps_att

468:
469: CURSOR c_version_number
470: IS
471: SELECT version_number
472: FROM igs_en_stdnt_ps_att
473: WHERE course_cd = p_course_cd
474: AND person_id = p_person_id;
475: -- Cursor to get the Person Type Code corresponding to the System Type
476: -- Added as per the bug# 2364461.

Line 483: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

479: FROM igs_pe_person_types
480: WHERE system_type = 'OTHER';
481: l_cur_per_typ cur_per_typ%ROWTYPE;
482:
483: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;
484: lv_message VARCHAR2(2000);
485: lv_deny_warn VARCHAR2(20);
486: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
487: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;

Line 598: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

594: FROM igs_pe_person_types
595: WHERE system_type = 'OTHER';
596: l_cur_per_typ cur_per_typ%ROWTYPE;
597:
598: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;
599: lv_message VARCHAR2(2000);
600: lv_deny_warn VARCHAR2(20);
601: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
602: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;

Line 1975: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

1971: FROM igs_pe_person_types
1972: WHERE system_type = 'OTHER';
1973: l_cur_per_typ cur_per_typ%ROWTYPE;
1974:
1975: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1976: lv_message VARCHAR2(2000);
1977: -- lv_deny_warn VARCHAR2(20);
1978: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
1979: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;