330: FROM igs_ps_fac_tcft_tmp ;
331:
332:
333: TYPE teach_cal_rec IS RECORD(
334: cal_type igs_ca_inst_all.cal_type%TYPE,
335: sequence_number igs_ca_inst_all.sequence_number%TYPE
336: );
337: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
338: teachCalendar_tbl teachCalendar;
331:
332:
333: TYPE teach_cal_rec IS RECORD(
334: cal_type igs_ca_inst_all.cal_type%TYPE,
335: sequence_number igs_ca_inst_all.sequence_number%TYPE
336: );
337: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
338: teachCalendar_tbl teachCalendar;
339: l_n_counter NUMBER(10);