APPS.IGS_PS_VAL_POS dependencies on IGS_AD_CAT

Line 19: p_admission_cat IN IGS_AD_CAT.admission_cat%TYPE ,

15:
16: --
17: -- Validate the admission category is not closed.
18: FUNCTION crsp_val_ac_closed(
19: p_admission_cat IN IGS_AD_CAT.admission_cat%TYPE ,
20: p_message_name OUT NOCOPY VARCHAR2 )
21: RETURN BOOLEAN AS
22: BEGIN -- crsp_val_ac_closed
23: -- Validate if IGS_AD_CAT.IGS_AD_CAT is closed

Line 23: -- Validate if IGS_AD_CAT.IGS_AD_CAT is closed

19: p_admission_cat IN IGS_AD_CAT.admission_cat%TYPE ,
20: p_message_name OUT NOCOPY VARCHAR2 )
21: RETURN BOOLEAN AS
22: BEGIN -- crsp_val_ac_closed
23: -- Validate if IGS_AD_CAT.IGS_AD_CAT is closed
24: DECLARE
25: v_dummy VARCHAR2(1);
26: CURSOR c_ac IS
27: SELECT 'X'

Line 28: FROM IGS_AD_CAT ac

24: DECLARE
25: v_dummy VARCHAR2(1);
26: CURSOR c_ac IS
27: SELECT 'X'
28: FROM IGS_AD_CAT ac
29: WHERE ac.admission_cat = p_admission_cat AND
30: ac.closed_ind = 'Y';
31: BEGIN
32: IF p_admission_cat IS NOT NULL THEN