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_GEN_003 dependencies on IGS_AS_SC_ATMPT_ENR

Line 22: pkg_session_enrolment_cat igs_as_sc_atmpt_enr.enrolment_cat%TYPE;

18: pkg_person_id igs_pe_person.person_id%TYPE;
19: pkg_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
20: pkg_cal_type igs_ca_inst.cal_type%TYPE;
21: pkg_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
22: pkg_session_enrolment_cat igs_as_sc_atmpt_enr.enrolment_cat%TYPE;
23: pkg_enrol_cal_type igs_ca_inst.cal_type%TYPE;
24: pkg_enrol_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
25: pkg_commencement_type VARCHAR2(20);
26: pkg_enroll_catg VARCHAR2(200);

Line 200: -- parameters); then pre-enrolment detail (IGS_AS_SC_ATMPT_ENR records)

196: -- where the student may be eligible in more than one IGS_PS_COURSE. These will be
197: -- returned in the form CATEGORY1,CATEGORY2,ETC?
198: -- The routine will determine the enrolment category(ies) by looking firstly
199: -- for one or more eligible IGS_PS_COURSE attempts (matching the specified
200: -- parameters); then pre-enrolment detail (IGS_AS_SC_ATMPT_ENR records)
201: -- will be searched for matching the specified academic period (i.e. the
202: -- enrolment calendar is a subordinate of the academic calendar).
203: -- If this is not found and the passed session enrolment category is set then
204: -- it will be used.

Line 225: v_crs_applicable_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

221: RETURN VARCHAR2 AS
222: BEGIN
223: DECLARE
224: v_applicable_enrolment_cat VARCHAR2(255);
225: v_crs_applicable_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
226: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
227: v_first_record BOOLEAN;
228: v_first_time BOOLEAN;
229: v_set_cal BOOLEAN;

Line 252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,

248: person_id = cp_person_id));
249: CURSOR c_scae_ci(
250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
255: IGS_CA_INST.start_dt,
256: IGS_CA_INST.end_dt

Line 253: IGS_AS_SC_ATMPT_ENR.cal_type,

249: CURSOR c_scae_ci(
250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
255: IGS_CA_INST.start_dt,
256: IGS_CA_INST.end_dt
257: FROM IGS_AS_SC_ATMPT_ENR,

Line 254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,

250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
255: IGS_CA_INST.start_dt,
256: IGS_CA_INST.end_dt
257: FROM IGS_AS_SC_ATMPT_ENR,
258: IGS_CA_INST

Line 257: FROM IGS_AS_SC_ATMPT_ENR,

253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
255: IGS_CA_INST.start_dt,
256: IGS_CA_INST.end_dt
257: FROM IGS_AS_SC_ATMPT_ENR,
258: IGS_CA_INST
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND

Line 259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND

255: IGS_CA_INST.start_dt,
256: IGS_CA_INST.end_dt
257: FROM IGS_AS_SC_ATMPT_ENR,
258: IGS_CA_INST
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND
262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number
263: ORDER BY IGS_CA_INST.start_dt desc;

Line 260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND

256: IGS_CA_INST.end_dt
257: FROM IGS_AS_SC_ATMPT_ENR,
258: IGS_CA_INST
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND
262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number
263: ORDER BY IGS_CA_INST.start_dt desc;
264: CURSOR c_cir(

Line 261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND

257: FROM IGS_AS_SC_ATMPT_ENR,
258: IGS_CA_INST
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND
262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number
263: ORDER BY IGS_CA_INST.start_dt desc;
264: CURSOR c_cir(
265: cp_sup_cal_type IGS_CA_INST.cal_type%TYPE,

Line 262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number

258: IGS_CA_INST
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND
260: IGS_AS_SC_ATMPT_ENR.course_cd = cp_course_cd AND
261: IGS_AS_SC_ATMPT_ENR.cal_type = IGS_CA_INST.cal_type AND
262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number
263: ORDER BY IGS_CA_INST.start_dt desc;
264: CURSOR c_cir(
265: cp_sup_cal_type IGS_CA_INST.cal_type%TYPE,
266: cp_sup_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,