APPS.IGS_AD_VAL_AA dependencies on IGS_AD_CAT

Line 268: p_message_name := 'IGS_AD_CAT_AS_ACADEMIC';

264: FETCH c_ct INTO v_ct_rec;
265: IF c_ct%FOUND THEN
266: CLOSE c_ct;
267: IF v_ct_rec.s_cal_cat <> cst_academic THEN
268: p_message_name := 'IGS_AD_CAT_AS_ACADEMIC';
269: RETURN FALSE;
270: END IF;
271: ELSE
272: CLOSE c_ct;

Line 443: v_closed_ind IGS_AD_CAT.closed_ind%TYPE;

439: p_message_name OUT NOCOPY VARCHAR2 )
440: RETURN BOOLEAN AS
441: BEGIN
442: DECLARE
443: v_closed_ind IGS_AD_CAT.closed_ind%TYPE;
444: v_count NUMBER;
445: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;
446: CURSOR c_ac IS
447: SELECT ac.closed_ind

Line 445: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;

441: BEGIN
442: DECLARE
443: v_closed_ind IGS_AD_CAT.closed_ind%TYPE;
444: v_count NUMBER;
445: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;
446: CURSOR c_ac IS
447: SELECT ac.closed_ind
448: FROM IGS_AD_CAT ac
449: WHERE ac.admission_cat = p_admission_cat;

Line 448: FROM IGS_AD_CAT ac

444: v_count NUMBER;
445: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;
446: CURSOR c_ac IS
447: SELECT ac.closed_ind
448: FROM IGS_AD_CAT ac
449: WHERE ac.admission_cat = p_admission_cat;
450: CURSOR c_ccm IS
451: SELECT ccm.admission_cat,
452: COUNT(*)