APPS.IGS_EN_GEN_010 dependencies on IGS_AD_LOCATION

Line 5796: v_elo_description IGS_AD_LOCATION.description%TYPE;

5792: DECLARE
5793: r_suah IGS_EN_SU_ATTEMPT_H%ROWTYPE;
5794: v_create_history BOOLEAN := FALSE;
5795: v_aus_description IGS_AD_ADM_UNIT_STAT.description%TYPE;
5796: v_elo_description IGS_AD_LOCATION.description%TYPE;
5797:
5798: CURSOR c_find_aus_desc IS
5799: SELECT description
5800: FROM IGS_AD_ADM_UNIT_STAT

Line 5804: FROM IGS_AD_LOCATION

5800: FROM IGS_AD_ADM_UNIT_STAT
5801: WHERE administrative_unit_status = r_suah.administrative_unit_status;
5802: CURSOR c_find_elo_desc IS
5803: SELECT description
5804: FROM IGS_AD_LOCATION
5805: WHERE location_cd = r_suah.exam_location_cd;
5806: BEGIN
5807: -- Create a history for a IGS_EN_SU_ATTEMPT record.
5808: -- Check if any of the non-primary key fields have been changed

Line 5866: -- get the exam IGS_AD_LOCATION description

5862: IF NVL(p_new_exam_location_cd, 'NULL') <>
5863: NVL(p_old_exam_location_cd, 'NULL') THEN
5864: r_suah.exam_location_cd := p_old_exam_location_cd;
5865: IF NVL(p_old_exam_location_cd, 'NULL') <> 'NULL' THEN
5866: -- get the exam IGS_AD_LOCATION description
5867: OPEN c_find_elo_desc;
5868: FETCH c_find_elo_desc INTO r_suah.elo_description;
5869: CLOSE c_find_elo_desc;
5870: END IF;