APPS.IGS_AS_GEN_006 dependencies on IGS_AS_ESE_VENUE_V

Line 2071: FROM IGS_AS_ESE_VENUE_V esvv,

2067: CURSOR c_esvv IS
2068: SELECT esvv.ese_id,
2069: esvv.venue_cd,
2070: ve.exam_location_cd
2071: FROM IGS_AS_ESE_VENUE_V esvv,
2072: IGS_GR_VENUE ve
2073: WHERE esvv.exam_cal_type = p_exam_cal_type AND
2074: esvv.exam_ci_sequence_number = p_exam_ci_sequence_number AND
2075: esvv.venue_cd = ve.venue_cd;

Line 2087: cp_venue_cd IGS_AS_ESE_VENUE_V.venue_cd%TYPE) IS

2083: lr.location_cd = loc.location_cd AND
2084: loc.LOCATION_TYPE = lot.LOCATION_TYPE AND
2085: lot.s_location_type = 'CAMPUS';
2086: CURSOR c_els (
2087: cp_venue_cd IGS_AS_ESE_VENUE_V.venue_cd%TYPE) IS
2088: SELECT els.person_id
2089: FROM IGS_AS_EXM_LOC_SPVSR els,
2090: IGS_GR_VENUE ve
2091: WHERE els.exam_location_cd = ve.exam_location_cd AND

Line 2096: FROM IGS_AS_ESE_VENUE_V esvv

2092: ve.venue_cd = cp_venue_cd;
2093: CURSOR c_ve IS
2094: SELECT esvv.ese_id,
2095: esvv.venue_cd
2096: FROM IGS_AS_ESE_VENUE_V esvv
2097: WHERE esvv.exam_cal_type = p_exam_cal_type AND
2098: esvv.exam_ci_sequence_number = p_exam_ci_sequence_number AND
2099: esvv.venue_cd = p_venue_cd;
2100: FUNCTION asspl_val_sprvsr(

Line 2102: p_ese_id IN OUT NOCOPY IGS_AS_ESE_VENUE_V.ese_id%TYPE,

2098: esvv.exam_ci_sequence_number = p_exam_ci_sequence_number AND
2099: esvv.venue_cd = p_venue_cd;
2100: FUNCTION asspl_val_sprvsr(
2101: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2102: p_ese_id IN OUT NOCOPY IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2103: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2104: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2105: p_ignore_warnings VARCHAR2,
2106: p_message_name OUT NOCOPY VARCHAR2)

Line 2281: p_ese_id IGS_AS_ESE_VENUE_V.ese_id%TYPE,

2277: END;
2278: END asspl_val_sprvsr;
2279: PROCEDURE asspl_ins_ve_sprvsr(
2280: p_person_id IGS_AS_EXM_INS_SPVSR.person_id%TYPE,
2281: p_ese_id IGS_AS_ESE_VENUE_V.ese_id%TYPE,
2282: p_venue_cd IGS_AS_EXM_INS_SPVSR.venue_cd%TYPE,
2283: p_exam_supervisor_type IGS_AS_EXM_INS_SPVSR.EXAM_SUPERVISOR_TYPE%TYPE,
2284: p_session_venue_ind VARCHAR2)
2285: IS

Line 2381: --(IGS_AS_ESE_VENUE_V) where the IGS_GR_VENUE is not linked to a campus.

2377: --Perform processing to default the supervisor's
2378: --to OFF-CAMPUS exam venues at sessions within the exam
2379: --period (p_exam_cal_type/p_exam_ci_sequence_number).
2380: --Select all exam session venues for the exam period
2381: --(IGS_AS_ESE_VENUE_V) where the IGS_GR_VENUE is not linked to a campus.
2382: FOR v_esvv_rec IN c_esvv LOOP
2383: OPEN c_lr(
2384: v_esvv_rec.exam_location_cd);
2385: FETCH c_lr INTO v_lr_exists;