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_PS_UNIT_OFR_OPT

Line 105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

101: CLOSE c_igs_pe_person ;
102:
103: END getpersondetail ;
104:
105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,

Line 108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,

104:
105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
112: p_message OUT NOCOPY VARCHAR2

Line 111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,

107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
112: p_message OUT NOCOPY VARCHAR2
113: ) IS
114: ------------------------------------------------------------------
115: --Created by : Sanil Madathil, Oracle IDC

Line 129: CURSOR c_uoo_details(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

125: --Change History:
126: --Who When What
127: -------------------------------------------------------------------
128:
129: CURSOR c_uoo_details(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
130: SELECT uoo.unit_cd , uv.title , uoo.cal_type ,
131: ci.alternate_code , al.description location_desc ,
132: uoo.unit_class
133: FROM igs_ps_unit_ofr_opt uoo ,

Line 133: FROM igs_ps_unit_ofr_opt uoo ,

129: CURSOR c_uoo_details(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
130: SELECT uoo.unit_cd , uv.title , uoo.cal_type ,
131: ci.alternate_code , al.description location_desc ,
132: uoo.unit_class
133: FROM igs_ps_unit_ofr_opt uoo ,
134: igs_ad_location al ,
135: igs_ps_unit_ver uv ,
136: igs_ca_inst ci
137: WHERE uoo.unit_cd = uv.unit_cd

Line 235: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

231:
232:
233:
234: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
235: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
236: p_org_id IN NUMBER
237: )
238: ------------------------------------------------------------------
239: --Created by : smanglm, Oracle IDC

Line 283: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

279:
280: END wf_send_mail_stud;
281:
282: PROCEDURE wf_send_mail_adm ( p_person_id_list IN VARCHAR2 ,
283: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
284: p_org_id IN NUMBER
285: )
286: ------------------------------------------------------------------
287: --Created by : smanglm, Oracle IDC

Line 376: FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

372: p_parameters => l_param_list);
373: END IF;
374: END wf_send_mail_adm;
375:
376: FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
377: p_modified_pos_tab IN t_modified_pos_tab
378: ) RETURN BOOLEAN
379:
380: ------------------------------------------------------------------

Line 409: CURSOR c_unit_sec_stud_mod(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

405: IS
406:
407: -- Cursor to select all the students for the unit section whose
408: -- waitlist postion has been currently modified by the Admin.
409: CURSOR c_unit_sec_stud_mod(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
410: SELECT
411: person_id,
412: course_cd,
413: administrative_priority,

Line 429: CURSOR c_unit_sec_stud(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

425:
426:
427: -- Cursor to select all the students for the unit section whose
428: -- waitlist postion has NOT been currently modified by the Admin.
429: CURSOR c_unit_sec_stud(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
430: SELECT
431: person_id,
432: course_cd,
433: administrative_priority,

Line 449: CURSOR c_stud_unit_attempt(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

445: unit_sec_stud_rec c_unit_sec_stud%ROWTYPE;
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

Line 895: FROM igs_ps_unit_ofr_opt

891: IS
892: -- Cursor to lock parent unit section record.
893: CURSOR c_unit_sec_lock IS
894: SELECT uoo_id
895: FROM igs_ps_unit_ofr_opt
896: WHERE uoo_id = p_uoo_id
897: FOR UPDATE;
898:
899: -- Cursor to get all the waitlisted students in the given unit section.

Line 948: FROM igs_ps_unit_ofr_opt

944: IS
945: -- Cursor to lock parent unit section record.
946: CURSOR c_unit_sec_lock IS
947: SELECT uoo_id
948: FROM igs_ps_unit_ofr_opt
949: WHERE uoo_id = p_uoo_id
950: FOR UPDATE;
951:
952: -- Cursor to get all the waitlisted students in the given unit section

Line 1042: CURSOR cur_get_teach_inst ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)

1038: WHERE uoo_id = cp_uoo_id);
1039: l_max_uoo_pref NUMBER;
1040:
1041: -- Cursor to get the unit code, version number and teaching calender associated with the unit section
1042: CURSOR cur_get_teach_inst ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
1043: IS
1044: SELECT unit_cd, version_number, cal_type , ci_sequence_number
1045: FROM igs_ps_unit_ofr_opt
1046: WHERE uoo_id = cp_uoo_id;

Line 1045: FROM igs_ps_unit_ofr_opt

1041: -- Cursor to get the unit code, version number and teaching calender associated with the unit section
1042: CURSOR cur_get_teach_inst ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
1043: IS
1044: SELECT unit_cd, version_number, cal_type , ci_sequence_number
1045: FROM igs_ps_unit_ofr_opt
1046: WHERE uoo_id = cp_uoo_id;
1047: cur_get_teach_inst_rec cur_get_teach_inst%ROWTYPE;
1048:
1049: -- Cursor to select priorities at unit offering pattern level

Line 1102: CURSOR cur_org_unit_cd ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)

1098: AND ci_sequence_number = cp_seq_no);
1099: l_max_uop_pref NUMBER;
1100:
1101: -- Cursor to select organization unit code for a given unit section
1102: CURSOR cur_org_unit_cd ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
1103: IS
1104: SELECT NVL(uoo.owner_org_unit_cd,uv.owner_org_unit_cd)
1105: FROM igs_ps_unit_ofr_opt uoo,
1106: igs_ps_unit_ver uv

Line 1105: FROM igs_ps_unit_ofr_opt uoo,

1101: -- Cursor to select organization unit code for a given unit section
1102: CURSOR cur_org_unit_cd ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
1103: IS
1104: SELECT NVL(uoo.owner_org_unit_cd,uv.owner_org_unit_cd)
1105: FROM igs_ps_unit_ofr_opt uoo,
1106: igs_ps_unit_ver uv
1107: WHERE uoo.uoo_id = cp_uoo_id
1108: AND uv.unit_cd= uoo.unit_cd
1109: AND uv.version_number= uoo.version_number;

Line 1111: l_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;

1107: WHERE uoo.uoo_id = cp_uoo_id
1108: AND uv.unit_cd= uoo.unit_cd
1109: AND uv.version_number= uoo.version_number;
1110:
1111: l_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
1112:
1113: -- Cursor to get the load calender type associated with a teaching calender instance
1114: CURSOR cur_teach_to_load ( cp_teach_cal_type igs_ca_inst.cal_type%TYPE ,
1115: cp_teach_seq_no igs_ca_inst.sequence_number%TYPE)