DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_ATD_MODE

Line 3072: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

3068: DECLARE
3069: v_coo_rec_found BOOLEAN;
3070: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3071: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3072: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3073: v_other_detail VARCHAR(255);
3074: CURSOR c_coo(
3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3076: SELECT *

Line 3112: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

3108: DECLARE
3109: v_coo_rec_found BOOLEAN;
3110: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3111: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3112: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3113: v_other_detail VARCHAR(255);
3114: CURSOR c_coo(
3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3116: SELECT *

Line 3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS

3127: SELECT s_unit_mode
3128: FROM IGS_AS_UNIT_MODE
3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;
3130: CURSOR c_attend_mode(
3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS
3132: SELECT govt_attendance_mode
3133: FROM IGS_EN_ATD_MODE
3134: WHERE IGS_EN_ATD_MODE.attendance_mode = cp_attend_mode;
3135: BEGIN

Line 3133: FROM IGS_EN_ATD_MODE

3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;
3130: CURSOR c_attend_mode(
3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS
3132: SELECT govt_attendance_mode
3133: FROM IGS_EN_ATD_MODE
3134: WHERE IGS_EN_ATD_MODE.attendance_mode = cp_attend_mode;
3135: BEGIN
3136: -- This module validates the nominated unit class against
3137: -- course_offering_option attandance mode for the enrolled course

Line 3134: WHERE IGS_EN_ATD_MODE.attendance_mode = cp_attend_mode;

3130: CURSOR c_attend_mode(
3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS
3132: SELECT govt_attendance_mode
3133: FROM IGS_EN_ATD_MODE
3134: WHERE IGS_EN_ATD_MODE.attendance_mode = cp_attend_mode;
3135: BEGIN
3136: -- This module validates the nominated unit class against
3137: -- course_offering_option attandance mode for the enrolled course
3138: p_message_name := null;