APPS.IGS_AS_GEN_006 dependencies on IGS_AS_EXM_SUPRVISOR

Line 2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;

2115: v_dai_sequence_number IGS_AS_EXM_INS_SPVSR.dai_sequence_number%TYPE;
2116: v_start_time IGS_AS_EXM_INS_SPVSR.start_time%TYPE;
2117: v_end_time IGS_AS_EXM_INS_SPVSR.end_time%TYPE;
2118: v_local_message_name VARCHAR2(30);
2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2120: CURSOR c_esu IS
2121: SELECT esu.EXAM_SUPERVISOR_TYPE
2122: FROM IGS_AS_EXM_SUPRVISOR esu
2123: WHERE esu.person_id = p_person_id;

Line 2122: FROM IGS_AS_EXM_SUPRVISOR esu

2118: v_local_message_name VARCHAR2(30);
2119: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2120: CURSOR c_esu IS
2121: SELECT esu.EXAM_SUPERVISOR_TYPE
2122: FROM IGS_AS_EXM_SUPRVISOR esu
2123: WHERE esu.person_id = p_person_id;
2124: BEGIN
2125: v_local_message_name := NULL;
2126: p_message_name := NULL;

Line 2289: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;

2285: IS
2286: BEGIN --asspl_ins_ve_sprvsr
2287: --Local procedure to insert the supervisor
2288: DECLARE
2289: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2290: CURSOR c_esu IS
2291: SELECT esu.EXAM_SUPERVISOR_TYPE
2292: FROM IGS_AS_EXM_SUPRVISOR esu
2293: WHERE esu.person_id = p_person_id;

Line 2292: FROM IGS_AS_EXM_SUPRVISOR esu

2288: DECLARE
2289: v_exam_supervisor_type IGS_AS_EXM_SUPRVISOR.EXAM_SUPERVISOR_TYPE%TYPE;
2290: CURSOR c_esu IS
2291: SELECT esu.EXAM_SUPERVISOR_TYPE
2292: FROM IGS_AS_EXM_SUPRVISOR esu
2293: WHERE esu.person_id = p_person_id;
2294: CURSOR c_ei IS
2295: SELECT ei.ass_id
2296: FROM IGS_AS_EXAM_INSTANCE ei