APPS.IGS_SS_ENR_DETAILS dependencies on IGS_CA_INST_ALL

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