APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_CA_TYPE

Line 276: CURSOR c_sua(cp_cal_cat igs_ca_type.s_cal_cat%TYPE) IS

272: -- student unit attempts for the passed program attempt.
273: --The two selects are mutually exclusive ie at any time the calendar passed is
274: --either 'LOAD' or 'TEACHING' so this cursor selects the unit attempts
275: -- for that particular calendar passed as parameter
276: CURSOR c_sua(cp_cal_cat igs_ca_type.s_cal_cat%TYPE) IS
277: -- selects the unit attempt when a teaching calendar is passed
278: SELECT
279: sua.unit_cd,
280: sua.cal_type,

Line 355: FROM IGS_CA_TYPE

351: /* smaddali bug#1832130 enrollment processes build nov 2001 release
352: added declarations for workflow events */
353: CURSOR cur_cal_cat IS
354: SELECT s_cal_cat
355: FROM IGS_CA_TYPE
356: WHERE cal_type = p_cal_type ;
357: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;
358: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE ;
359: l_retval BOOLEAN ;

Line 357: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;

353: CURSOR cur_cal_cat IS
354: SELECT s_cal_cat
355: FROM IGS_CA_TYPE
356: WHERE cal_type = p_cal_type ;
357: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;
358: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE ;
359: l_retval BOOLEAN ;
360: sua_rec cur_IGS_EN_SU_ATTEMPT%ROWTYPE ;
361:

Line 795: CURSOR c_sua_sca(cp_cal_cat igs_ca_type.s_cal_cat%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

791: --The two selects are mutually exclusive ie at any time the calendar passed is
792: --either 'LOAD' or 'TEACHING' so this cursor selects the unit attempts
793: -- for that particular calendar passed as parameter
794:
795: CURSOR c_sua_sca(cp_cal_cat igs_ca_type.s_cal_cat%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
796: --selects unit attempts when a teaching calendar is passed
797: SELECT sua.unit_cd,
798: sua.version_number sua_version_number,
799: sua.cal_type,

Line 857: FROM IGS_CA_TYPE

853: /* smaddali bug#1832130 enrollment processes build nov 2001 release
854: added declarations for workflow events and new parameters added to this procedure */
855: CURSOR cur_cal_cat IS
856: SELECT s_cal_cat
857: FROM IGS_CA_TYPE
858: WHERE cal_type = p_cal_type ;
859:
860: CURSOR c_load_to_teach IS
861: SELECT teach_cal_type,teach_ci_sequence_number

Line 867: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;

863: WHERE load_cal_type = p_cal_type
864: AND load_ci_sequence_number = nvl( p_ci_sequence_number ,load_ci_sequence_number);
865:
866: rec_teach c_load_to_teach%ROWTYPE;
867: l_cal_cat igs_ca_type.s_cal_cat%TYPE ;
868: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;
869: sua_rec cur_IGS_EN_SU_ATTEMPT%ROWTYPE ;
870: l_loop_ended BOOLEAN := FALSE;
871: