APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 7724: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,

7720:
7721:
7722: PROCEDURE createCalendar IS
7723:
7724: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
7725: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
7726: SELECT sup_cal_type,sup_ci_sequence_number
7727: FROM igs_ca_inst_rel
7728: WHERE sub_cal_type = cp_load_cal

Line 7725: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS

7721:
7722: PROCEDURE createCalendar IS
7723:
7724: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
7725: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
7726: SELECT sup_cal_type,sup_ci_sequence_number
7727: FROM igs_ca_inst_rel
7728: WHERE sub_cal_type = cp_load_cal
7729: AND sub_ci_sequence_number = cp_load_seq;

Line 7733: FROM igs_ca_teach_to_load_v

7729: AND sub_ci_sequence_number = cp_load_seq;
7730:
7731: CURSOR cur_cal_load IS
7732: SELECT load_cal_type,load_ci_sequence_number
7733: FROM igs_ca_teach_to_load_v
7734: WHERE teach_cal_type=l_c_cal_type
7735: AND teach_ci_sequence_number=l_n_seq_num;
7736:
7737: BEGIN

Line 10394: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,

10390:
10391:
10392: PROCEDURE createCalendar IS
10393:
10394: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
10395: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
10396: SELECT sup_cal_type,sup_ci_sequence_number
10397: FROM igs_ca_inst_rel
10398: WHERE sub_cal_type = cp_load_cal

Line 10395: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS

10391:
10392: PROCEDURE createCalendar IS
10393:
10394: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
10395: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
10396: SELECT sup_cal_type,sup_ci_sequence_number
10397: FROM igs_ca_inst_rel
10398: WHERE sub_cal_type = cp_load_cal
10399: AND sub_ci_sequence_number = cp_load_seq;

Line 10403: FROM igs_ca_teach_to_load_v

10399: AND sub_ci_sequence_number = cp_load_seq;
10400:
10401: CURSOR cur_cal_load IS
10402: SELECT load_cal_type,load_ci_sequence_number
10403: FROM igs_ca_teach_to_load_v
10404: WHERE teach_cal_type=l_c_cal_type
10405: AND teach_ci_sequence_number=l_n_seq_num;
10406:
10407: BEGIN