APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 418: igs_en_su_attempt_all sua

414: waitlist_manual_ind,
415: wlst_priority_weight_num,
416: wlst_preference_weight_num
417: FROM
418: igs_en_su_attempt_all sua
419: WHERE
420: sua.uoo_id = cp_uoo_id
421: AND sua.waitlist_manual_ind = 'M'
422: AND sua.unit_attempt_status = 'WAITLISTED'

Line 438: igs_en_su_attempt_all sua

434: waitlist_manual_ind,
435: wlst_priority_weight_num,
436: wlst_preference_weight_num
437: FROM
438: igs_en_su_attempt_all sua
439: WHERE
440: sua.uoo_id = cp_uoo_id
441: AND sua.waitlist_manual_ind <> 'M'
442: AND sua.unit_attempt_status = 'WAITLISTED'

Line 450: cp_person_id igs_en_su_attempt_all.person_id%TYPE,

446:
447:
448: -- Cursor to select a unit section for a particular student
449: CURSOR c_stud_unit_attempt(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
450: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
451: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
452: ) IS
453: SELECT * FROM
454: igs_en_su_attempt sua

Line 451: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE

447:
448: -- Cursor to select a unit section for a particular student
449: CURSOR c_stud_unit_attempt(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
450: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
451: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE
452: ) IS
453: SELECT * FROM
454: igs_en_su_attempt sua
455: WHERE

Line 478: person_id igs_en_su_attempt_all.person_id%TYPE,

474:
475: -- Record type for PL/SQL table
476: TYPE t_stud_wait_rec IS RECORD
477: (
478: person_id igs_en_su_attempt_all.person_id%TYPE,
479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,

Line 479: course_cd igs_en_su_attempt_all.course_cd%TYPE,

475: -- Record type for PL/SQL table
476: TYPE t_stud_wait_rec IS RECORD
477: (
478: person_id igs_en_su_attempt_all.person_id%TYPE,
479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,
483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE

Line 480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,

476: TYPE t_stud_wait_rec IS RECORD
477: (
478: person_id igs_en_su_attempt_all.person_id%TYPE,
479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,
483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE
484: );

Line 481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,

477: (
478: person_id igs_en_su_attempt_all.person_id%TYPE,
479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,
483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE
484: );
485:

Line 482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,

478: person_id igs_en_su_attempt_all.person_id%TYPE,
479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,
483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE
484: );
485:
486: TYPE t_stud_waitlist IS TABLE OF t_stud_wait_rec INDEX BY BINARY_INTEGER;

Line 483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE

479: course_cd igs_en_su_attempt_all.course_cd%TYPE,
480: admin_priority igs_en_su_attempt_all.administrative_priority%TYPE,
481: wlst_manual_ind igs_en_su_attempt_all.waitlist_manual_ind%TYPE,
482: wlst_priority_weight_num igs_en_su_attempt_all.wlst_priority_weight_num%TYPE,
483: wlst_preference_weight_num igs_en_su_attempt_all.wlst_preference_weight_num%TYPE
484: );
485:
486: TYPE t_stud_waitlist IS TABLE OF t_stud_wait_rec INDEX BY BINARY_INTEGER;
487: