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_WLST_GEN_PROC dependencies on IGS_EN_SU_ATTEMPT

Line 394: --pradhakr 15-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

390: --Known limitations/enhancements and/or remarks:
391: --
392: --Change History:
393: --Who When What
394: --pradhakr 15-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
395: -- table to igs_en_sua_api.update_unit_attempt.
396: -- Changes wrt ENCR031 build. Bug# 2643207
397: --ptandon 25-Aug-2003 Modified the signature to add a new parameter of
398: -- type t_modified_pos_tab and added logic to retain the

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 454: igs_en_su_attempt sua

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
456: sua.uoo_id = cp_uoo_id
457: AND sua.person_id = cp_person_id
458: AND sua.course_cd = cp_course_cd

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:

Line 900: CURSOR c_sua_pri_pref (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

896: WHERE uoo_id = p_uoo_id
897: FOR UPDATE;
898:
899: -- Cursor to get all the waitlisted students in the given unit section.
900: CURSOR c_sua_pri_pref (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
901: SELECT *
902: FROM igs_en_su_attempt
903: WHERE uoo_id = cp_uoo_id AND unit_attempt_status = 'WAITLISTED'
904: ORDER BY wlst_priority_weight_num DESC, wlst_preference_weight_num DESC, administrative_priority

Line 902: FROM igs_en_su_attempt

898:
899: -- Cursor to get all the waitlisted students in the given unit section.
900: CURSOR c_sua_pri_pref (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
901: SELECT *
902: FROM igs_en_su_attempt
903: WHERE uoo_id = cp_uoo_id AND unit_attempt_status = 'WAITLISTED'
904: ORDER BY wlst_priority_weight_num DESC, wlst_preference_weight_num DESC, administrative_priority
905: FOR UPDATE;
906:

Line 915: UPDATE igs_en_su_attempt

911: OPEN c_unit_sec_lock;
912: l_cnt := 1;
913: FOR l_sua_details IN c_sua_pri_pref(p_uoo_id) LOOP
914: IF l_cnt <> NVL(l_sua_details.administrative_priority,0) THEN
915: UPDATE igs_en_su_attempt
916: SET administrative_priority = l_cnt ,
917: waitlist_manual_ind = 'N'
918: WHERE CURRENT OF c_sua_pri_pref;
919: END IF;

Line 954: CURSOR c_sua_wl_dt (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ,

950: FOR UPDATE;
951:
952: -- Cursor to get all the waitlisted students in the given unit section
953: -- whose waitlist date is later than the student in context.
954: CURSOR c_sua_wl_dt (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ,
955: cp_person_id igs_en_su_attempt.person_id%TYPE ,
956: cp_program_cd igs_en_su_attempt.course_cd%TYPE ,
957: cp_cur_position NUMBER)
958: IS

Line 955: cp_person_id igs_en_su_attempt.person_id%TYPE ,

951:
952: -- Cursor to get all the waitlisted students in the given unit section
953: -- whose waitlist date is later than the student in context.
954: CURSOR c_sua_wl_dt (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ,
955: cp_person_id igs_en_su_attempt.person_id%TYPE ,
956: cp_program_cd igs_en_su_attempt.course_cd%TYPE ,
957: cp_cur_position NUMBER)
958: IS
959: SELECT *

Line 956: cp_program_cd igs_en_su_attempt.course_cd%TYPE ,

952: -- Cursor to get all the waitlisted students in the given unit section
953: -- whose waitlist date is later than the student in context.
954: CURSOR c_sua_wl_dt (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ,
955: cp_person_id igs_en_su_attempt.person_id%TYPE ,
956: cp_program_cd igs_en_su_attempt.course_cd%TYPE ,
957: cp_cur_position NUMBER)
958: IS
959: SELECT *
960: FROM igs_en_su_attempt

Line 960: FROM igs_en_su_attempt

956: cp_program_cd igs_en_su_attempt.course_cd%TYPE ,
957: cp_cur_position NUMBER)
958: IS
959: SELECT *
960: FROM igs_en_su_attempt
961: WHERE uoo_id = cp_uoo_id AND
962: (person_id <> cp_person_id OR
963: course_cd <> cp_program_cd) AND
964: unit_attempt_status = 'WAITLISTED' AND

Line 977: UPDATE igs_en_su_attempt

973: OPEN c_unit_sec_lock;
974: l_cnt := p_cur_position + 1;
975: FOR l_sua_details IN c_sua_wl_dt(p_uoo_id,p_person_id,p_program_cd,p_cur_position) LOOP
976: IF l_cnt <> NVL(l_sua_details.administrative_priority,0) THEN
977: UPDATE igs_en_su_attempt
978: SET administrative_priority = l_cnt ,
979: waitlist_manual_ind = 'N'
980: WHERE CURRENT OF c_sua_wl_dt;
981: END IF;