APPS.IGS_PS_GEN_008 dependencies on IGS_CA_INST_ALL

Line 2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt
2600: FROM igs_ca_inst_all
2601: WHERE cal_type = cp_cal_type
2602: AND sequence_number = cp_seq_num;

Line 2600: FROM igs_ca_inst_all

2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt
2600: FROM igs_ca_inst_all
2601: WHERE cal_type = cp_cal_type
2602: AND sequence_number = cp_seq_num;
2603: l_d_src_teach_cal_start_dt DATE;
2604: l_d_src_teach_cal_end_dt DATE;

Line 2816: cal_type igs_ca_inst_all.cal_type%TYPE,

2812: l_b_var1 BOOLEAN := FALSE;
2813:
2814: --- added as a part of performance activity ---
2815: TYPE teach_cal_rec IS RECORD(
2816: cal_type igs_ca_inst_all.cal_type%TYPE,
2817: sequence_number igs_ca_inst_all.sequence_number%TYPE
2818: );
2819: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2820: teachCalendar_tbl teachCalendar;

Line 2817: sequence_number igs_ca_inst_all.sequence_number%TYPE

2813:
2814: --- added as a part of performance activity ---
2815: TYPE teach_cal_rec IS RECORD(
2816: cal_type igs_ca_inst_all.cal_type%TYPE,
2817: sequence_number igs_ca_inst_all.sequence_number%TYPE
2818: );
2819: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2820: teachCalendar_tbl teachCalendar;
2821: l_n_counter NUMBER(10);

Line 2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

2849: END LOOP;
2850:
2851: END createCalendar;
2852:
2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
2855: BEGIN
2856: IF teachCalendar_tbl.EXISTS(1) THEN
2857: FOR i IN 1..teachCalendar_tbl.last LOOP

Line 2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS

2850:
2851: END createCalendar;
2852:
2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
2855: BEGIN
2856: IF teachCalendar_tbl.EXISTS(1) THEN
2857: FOR i IN 1..teachCalendar_tbl.last LOOP
2858: IF cp_cal_type=teachCalendar_tbl(i).cal_type AND