APPS.IGS_AV_VAL_ASAU dependencies on IGS_AV_STND_UNIT

Line 18: -- s_adv_stnd_recognition_type of the parent IGS_AV_STND_UNIT record is 'PRECLUDE'

14: gv_other_detail VARCHAR2(255);
15: BEGIN
16: -- advp_val_alt_unit
17: -- Validate that alternate units can only be specified if the
18: -- s_adv_stnd_recognition_type of the parent IGS_AV_STND_UNIT record is 'PRECLUDE'
19: DECLARE
20: v_ret_val BOOLEAN DEFAULT TRUE;
21: v_check CHAR;
22: CURSOR c_chk_adv_stnd_recog_type IS

Line 24: FROM IGS_AV_STND_UNIT

20: v_ret_val BOOLEAN DEFAULT TRUE;
21: v_check CHAR;
22: CURSOR c_chk_adv_stnd_recog_type IS
23: SELECT 'x'
24: FROM IGS_AV_STND_UNIT
25: WHERE person_id = p_person_id AND
26: as_course_cd = p_course_cd AND
27: as_version_number = p_course_version AND
28: s_adv_stnd_type = p_adv_stnd_type AND

Line 43: -- Determine the recognition type of the appropriate IGS_AV_STND_UNIT record

39: p_unit_cd IS NULL OR
40: p_unit_version IS NULL) THEN
41: RETURN TRUE;
42: END IF;
43: -- Determine the recognition type of the appropriate IGS_AV_STND_UNIT record
44: OPEN c_chk_adv_stnd_recog_type;
45: FETCH c_chk_adv_stnd_recog_type INTO v_check;
46: IF (c_chk_adv_stnd_recog_type%NOTFOUND) THEN
47: -- Alternate units cannot be recorded, report an error