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_CA_INST

Line 20: pkg_cal_type igs_ca_inst.cal_type%TYPE;

16: Following package variable keeps the enrp_get_enr_cat function parameters values.
17: -------------------------------------------------------------------------------------------------------------*/
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;

Line 21: pkg_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

17: -------------------------------------------------------------------------------------------------------------*/
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);

Line 23: pkg_enrol_cal_type igs_ca_inst.cal_type%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);
27: pkg_enr_categories VARCHAR2(200);

Line 24: pkg_enrol_ci_sequence_number igs_ca_inst.sequence_number%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);
27: pkg_enr_categories VARCHAR2(200);
28: pkg_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

Line 226: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

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;
230: v_crs_commencement_type VARCHAR2(10);

Line 255: IGS_CA_INST.start_dt,

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
259: WHERE IGS_AS_SC_ATMPT_ENR.person_id = cp_person_id AND

Line 256: IGS_CA_INST.end_dt

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
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

Line 258: IGS_CA_INST

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
262: IGS_AS_SC_ATMPT_ENR.ci_sequence_number = IGS_CA_INST.sequence_number

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,

Line 263: ORDER BY IGS_CA_INST.start_dt desc;

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,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,

Line 265: cp_sup_cal_type IGS_CA_INST.cal_type%TYPE,

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,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type

Line 266: cp_sup_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

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,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type
270: FROM IGS_CA_INST_REL

Line 267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,

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,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type
270: FROM IGS_CA_INST_REL
271: WHERE sup_cal_type = cp_sup_cal_type AND

Line 268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

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,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type
270: FROM IGS_CA_INST_REL
271: WHERE sup_cal_type = cp_sup_cal_type AND
272: sup_ci_sequence_number = cp_sup_ci_sequence_number AND

Line 270: FROM IGS_CA_INST_REL

266: cp_sup_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
267: cp_sub_cal_type IGS_CA_INST.cal_type%TYPE,
268: cp_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
269: SELECT sub_cal_type
270: FROM IGS_CA_INST_REL
271: WHERE sup_cal_type = cp_sup_cal_type AND
272: sup_ci_sequence_number = cp_sup_ci_sequence_number AND
273: sub_cal_type = cp_sub_cal_type AND
274: sub_ci_sequence_number = cp_sub_ci_sequence_number;

Line 468: FROM IGS_CA_INST_REL cir,

464: cst_enrolment CONSTANT VARCHAR2(10) := 'ENROLMENT';
465: CURSOR c_cir IS
466: SELECT cir.sub_cal_type,
467: cir.sub_ci_sequence_number
468: FROM IGS_CA_INST_REL cir,
469: IGS_CA_INST ci,
470: IGS_CA_TYPE cat,
471: IGS_CA_STAT cs
472: WHERE cir.sup_cal_type = p_adm_cal_type AND

Line 469: IGS_CA_INST ci,

465: CURSOR c_cir IS
466: SELECT cir.sub_cal_type,
467: cir.sub_ci_sequence_number
468: FROM IGS_CA_INST_REL cir,
469: IGS_CA_INST ci,
470: IGS_CA_TYPE cat,
471: IGS_CA_STAT cs
472: WHERE cir.sup_cal_type = p_adm_cal_type AND
473: cir.sup_ci_sequence_number = p_adm_sequence_number AND