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_SS_ENR_DETAILS dependencies on IGS_CA_INST

Line 1568: FROM igs_ca_inst

1564:
1565: CURSOR c_cal_dates IS
1566: SELECT TO_CHAR(START_DT) || ' - ' ||
1567: TO_CHAR(END_DT)
1568: FROM igs_ca_inst
1569: WHERE cal_type = x_cal_type
1570: AND sequence_number = x_ci_seq_number;
1571:
1572: l_eff_date VARCHAR2(50) DEFAULT NULL;

Line 2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2317:
2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2325: l_message VARCHAR2(300);

Line 2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2318: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2319: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2325: l_message VARCHAR2(300);
2326: l_ret_status VARCHAR2(30);

Line 2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

2320: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2321: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2322: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2323: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2324: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2325: l_message VARCHAR2(300);
2326: l_ret_status VARCHAR2(30);
2327: l_dummy VARCHAR2(300);
2328:

Line 3057: l_c_en_cal igs_ca_inst.cal_type%type;

3053:
3054: l_c_msg VARCHAR2(2000);
3055: l_c_ret_sts VARCHAR2(10);
3056: l_c_en_meth_type igs_en_method_type.enr_method_type%TYPE;
3057: l_c_en_cal igs_ca_inst.cal_type%type;
3058: l_n_en_seq igs_ca_inst.sequence_number%type;
3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;

Line 3058: l_n_en_seq igs_ca_inst.sequence_number%type;

3054: l_c_msg VARCHAR2(2000);
3055: l_c_ret_sts VARCHAR2(10);
3056: l_c_en_meth_type igs_en_method_type.enr_method_type%TYPE;
3057: l_c_en_cal igs_ca_inst.cal_type%type;
3058: l_n_en_seq igs_ca_inst.sequence_number%type;
3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;

Line 3060: l_c_acad_cal igs_ca_inst.cal_type%type;

3056: l_c_en_meth_type igs_en_method_type.enr_method_type%TYPE;
3057: l_c_en_cal igs_ca_inst.cal_type%type;
3058: l_n_en_seq igs_ca_inst.sequence_number%type;
3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;
3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;

Line 3061: l_n_acad_seq igs_ca_inst.sequence_number%type;

3057: l_c_en_cal igs_ca_inst.cal_type%type;
3058: l_n_en_seq igs_ca_inst.sequence_number%type;
3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;
3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;
3065: l_c_en_cat igs_en_enrolment_cat.enrolment_cat%TYPE;

Line 3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;

3058: l_n_en_seq igs_ca_inst.sequence_number%type;
3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;
3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;
3065: l_c_en_cat igs_en_enrolment_cat.enrolment_cat%TYPE;
3066: l_c_en_ctgs VARCHAR2(200);

Line 3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;

3059: l_c_en_com igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;
3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;
3065: l_c_en_cat igs_en_enrolment_cat.enrolment_cat%TYPE;
3066: l_c_en_ctgs VARCHAR2(200);
3067: l_c_notify_flag igs_en_cpd_ext.notification_flag%TYPE;

Line 3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;

3060: l_c_acad_cal igs_ca_inst.cal_type%type;
3061: l_n_acad_seq igs_ca_inst.sequence_number%type;
3062: l_d_acad_st_dt igs_ca_inst.start_dt%type;
3063: l_d_acad_ed_dt igs_ca_inst.end_dt%type;
3064: l_c_alternate_cd igs_ca_inst.alternate_code%type;
3065: l_c_en_cat igs_en_enrolment_cat.enrolment_cat%TYPE;
3066: l_c_en_ctgs VARCHAR2(200);
3067: l_c_notify_flag igs_en_cpd_ext.notification_flag%TYPE;
3068: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

Line 3261: igs_ca_inst_all CA

3257: TO_CHAR(uso.start_time,'hh:miam') start_time,
3258: TO_CHAR(uso.end_time, 'hh:miam') end_time
3259: FROM igs_ps_usec_occurs_all USO,
3260: igs_ps_unit_ofr_opt_all US,
3261: igs_ca_inst_all CA
3262: WHERE uso.uoo_id = cp_n_uoo_id AND
3263: uso.uoo_id = us.uoo_id AND
3264: us.cal_type = ca.cal_type AND
3265: us.ci_sequence_number = ca.sequence_number

Line 3306: igs_ca_inst_all ca

3302: CURSOR c_uoo(cp_n_uoo_id IN NUMBER) IS
3303: SELECT NVL(us.unit_section_start_date,ca.start_dt) start_date,
3304: NVL(us.unit_section_end_date, ca.end_dt) end_date
3305: FROM igs_ps_unit_ofr_opt_all us,
3306: igs_ca_inst_all ca
3307: WHERE us.uoo_id = cp_n_uoo_id AND
3308: us.cal_type = ca.cal_type AND
3309: us.ci_sequence_number = ca.sequence_number;
3310:

Line 4300: FROM igs_ca_inst_all ci

4296: AS
4297: --cursor to check if schedule is open for a given term
4298: CURSOR c_get_schedule_flag IS
4299: SELECT ci.schedule_flag schedule_flag
4300: FROM igs_ca_inst_all ci
4301: WHERE CAL_TYPE = p_load_calendar_type
4302: AND SEQUENCE_NUMBER = p_load_cal_sequence_number;
4303:
4304: --cursor to fetch the schedule start date alias

Line 4311: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;

4307: FROM igs_en_cal_conf
4308: WHERE s_control_num = 1;
4309:
4310: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_OPEN_DT_ALIAS%TYPE;
4311: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;
4312: l_dt_alias_val DATE;
4313:
4314:
4315: BEGIN

Line 4379: FROM IGS_CA_INST

4375: --cursor to check if the selected load calendar is open only for searching
4376: --but not for planning or for the schedule.
4377: CURSOR c_get_load_cal_open_status(cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
4378: SELECT 'x'
4379: FROM IGS_CA_INST
4380: WHERE CAL_TYPE = cp_load_cal_type
4381: AND SEQUENCE_NUMBER = cp_load_seq_num
4382: AND SS_DISPLAYED = 'Y'
4383: AND PLANNING_FLAG = 'N'

Line 4391: igs_ca_inst_rel cir,

4387: -- of any of the student's program attempts
4388: CURSOR c_check_is_load_assoc_to_acad (cp_person_id NUMBER, cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
4389: SELECT distinct cir.sub_cal_type ,cir.sub_ci_sequence_number
4390: FROM igs_en_stdnt_ps_att sca,
4391: igs_ca_inst_rel cir,
4392: igs_ca_type ct
4393: WHERE cir.sup_cal_type = sca.cal_type and
4394: ct.cal_type = cir.sub_cal_type and
4395: ct.s_cal_cat = 'LOAD' and

Line 4628: igs_ca_inst_all CA

4624: TO_CHAR( NVL( NVL( USO.END_DATE, US.UNIT_SECTION_END_DATE),
4625: CA.END_DT), 'DD MON YYYY') effective_date
4626: FROM igs_ps_usec_occurs_all USO,
4627: igs_ps_unit_ofr_opt_all US,
4628: igs_ca_inst_all CA
4629: WHERE uso.unit_section_occurrence_id = cp_n_uso_id
4630: AND uso.uoo_id = us.uoo_id
4631: AND us.cal_type = ca.cal_type
4632: AND us.ci_sequence_number = ca.sequence_number;

Line 4670: FROM igs_ca_inst_all ci

4666:
4667: CURSOR c_get_plan_schedule_flag(cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
4668: SELECT planning_flag,
4669: schedule_flag
4670: FROM igs_ca_inst_all ci
4671: WHERE CAL_TYPE = cp_load_cal_type
4672: AND SEQUENCE_NUMBER = cp_load_seq_num;
4673:
4674: CURSOR c_cal_conf IS

Line 4699: l_plan_flag igs_ca_inst_all.planning_flag%TYPE;

4695:
4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;
4697: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_open_DT_ALIAS%TYPE;
4698:
4699: l_plan_flag igs_ca_inst_all.planning_flag%TYPE;
4700: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;
4701:
4702: l_dt_alias_val DATE;
4703:

Line 4700: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;

4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;
4697: l_sch_dt_alias igs_en_cal_conf.SCHEDULE_open_DT_ALIAS%TYPE;
4698:
4699: l_plan_flag igs_ca_inst_all.planning_flag%TYPE;
4700: l_schedule_flag igs_ca_inst_all.schedule_flag%TYPE;
4701:
4702: l_dt_alias_val DATE;
4703:
4704: l_planning_open BOOLEAN;