APPS.IGS_AD_VAL_ACCT dependencies on IGS_AD_CAT

Line 10: -- Validate if IGS_AD_CAT.admission_cat is closed.

6: --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "crsp_val_cty_closed"
7: -------------------------------------------------------------------------------------------
8:
9: --
10: -- Validate if IGS_AD_CAT.admission_cat is closed.
11: FUNCTION admp_val_ac_closed(
12: p_admission_cat IN VARCHAR2 ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS

Line 16: -- Validate if IGS_AD_CAT.admission_cat is closed.

12: p_admission_cat IN VARCHAR2 ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS
15: BEGIN -- admp_val_ac_closed
16: -- Validate if IGS_AD_CAT.admission_cat is closed.
17: DECLARE
18: v_closed_ind IGS_AD_CAT.closed_ind%type;
19: CURSOR c_ac IS
20: SELECT ac.closed_ind

Line 18: v_closed_ind IGS_AD_CAT.closed_ind%type;

14: RETURN BOOLEAN AS
15: BEGIN -- admp_val_ac_closed
16: -- Validate if IGS_AD_CAT.admission_cat is closed.
17: DECLARE
18: v_closed_ind IGS_AD_CAT.closed_ind%type;
19: CURSOR c_ac IS
20: SELECT ac.closed_ind
21: FROM IGS_AD_CAT ac
22: WHERE ac.admission_cat = p_admission_cat;

Line 21: FROM IGS_AD_CAT ac

17: DECLARE
18: v_closed_ind IGS_AD_CAT.closed_ind%type;
19: CURSOR c_ac IS
20: SELECT ac.closed_ind
21: FROM IGS_AD_CAT ac
22: WHERE ac.admission_cat = p_admission_cat;
23: BEGIN
24: -- Set the default message number
25: p_message_name := NULL;