2823:
2824:
2825: PROCEDURE createCalendar IS
2826:
2827: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
2828: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
2829: SELECT teach_cal_type,teach_ci_sequence_number
2830: FROM igs_ca_teach_to_load_v
2831: WHERE load_cal_type = cp_load_cal
2824:
2825: PROCEDURE createCalendar IS
2826:
2827: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
2828: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
2829: SELECT teach_cal_type,teach_ci_sequence_number
2830: FROM igs_ca_teach_to_load_v
2831: WHERE load_cal_type = cp_load_cal
2832: AND load_ci_sequence_number = cp_load_seq;
2826:
2827: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
2828: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
2829: SELECT teach_cal_type,teach_ci_sequence_number
2830: FROM igs_ca_teach_to_load_v
2831: WHERE load_cal_type = cp_load_cal
2832: AND load_ci_sequence_number = cp_load_seq;
2833:
2834: CURSOR cur_cal_load IS