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_STDNT_PS_ATT

Line 172: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

168: CLOSE c_uoo_details ;
169:
170: END getuoodetail ;
171:
172: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,

Line 173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

169:
170: END getuoodetail ;
171:
172: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,

Line 174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

170: END getuoodetail ;
171:
172: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,

Line 175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

171:
172: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,

173: p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
180: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE
181: )

Line 178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,

174: P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
180: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE
181: )
182: ------------------------------------------------------------------

Line 1176: FROM igs_en_stdnt_ps_att

1172: CURSOR cur_get_prog_ver (cp_person_id NUMBER ,
1173: cp_course_cd VARCHAR2)
1174: IS
1175: SELECT version_number
1176: FROM igs_en_stdnt_ps_att
1177: WHERE person_id = cp_person_id
1178: AND course_cd = cp_course_cd;
1179:
1180: -- Cursors to check whether given student is satisfying waitlist priority / preferences

Line 1186: FROM igs_en_stdnt_ps_att

1182: cp_course_cd VARCHAR2 ,
1183: cp_version_number NUMBER)
1184: IS
1185: SELECT 'X'
1186: FROM igs_en_stdnt_ps_att
1187: WHERE person_id = cp_person_id
1188: AND course_cd = cp_course_cd
1189: AND version_number = cp_version_number;
1190:

Line 1195: FROM igs_en_stdnt_ps_att sca,

1191: CURSOR cur_org ( cp_person_id NUMBER ,
1192: cp_org_unit_cd VARCHAR2)
1193: IS
1194: SELECT 'X'
1195: FROM igs_en_stdnt_ps_att sca,
1196: igs_ps_ver pv
1197: WHERE sca.person_id = cp_person_id
1198: AND sca.course_cd = pv.course_cd
1199: AND sca.version_number = pv.version_number

Line 1207: FROM igs_en_stdnt_ps_att spa,

1203: cp_unit_set_cd VARCHAR2 ,
1204: cp_us_version_number NUMBER)
1205: IS
1206: SELECT 'X'
1207: FROM igs_en_stdnt_ps_att spa,
1208: igs_as_su_setatmpt sus
1209: WHERE spa.person_id = cp_person_id
1210: AND sus.person_id = spa.person_id
1211: AND spa.course_cd = sus.course_cd

Line 1223: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;

1219: l_pref_satisfied BOOLEAN;
1220: l_pri_satisfied VARCHAR2(1);
1221: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
1222: l_teach_seq_no igs_ca_inst.sequence_number%TYPE;
1223: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
1224:
1225: BEGIN
1226: l_pref_order := 0;
1227: l_pri_weight := 0;