35: p_intake_target_type IN VARCHAR2 ,
36: p_message_name OUT NOCOPY VARCHAR2 )
37: RETURN BOOLEAN AS
38: BEGIN -- admp_val_itt_closed
39: -- Description: This module checks if an IGS_AD_INTAK_TRG_TYP is closed.
40: DECLARE
41: v_itt_rec IGS_AD_INTAK_TRG_TYP.intake_target_type%TYPE;
42: CURSOR c_itt IS
43: SELECT itt.closed_ind
37: RETURN BOOLEAN AS
38: BEGIN -- admp_val_itt_closed
39: -- Description: This module checks if an IGS_AD_INTAK_TRG_TYP is closed.
40: DECLARE
41: v_itt_rec IGS_AD_INTAK_TRG_TYP.intake_target_type%TYPE;
42: CURSOR c_itt IS
43: SELECT itt.closed_ind
44: FROM IGS_AD_INTAK_TRG_TYP itt
45: WHERE itt.intake_target_type = p_intake_target_type;
40: DECLARE
41: v_itt_rec IGS_AD_INTAK_TRG_TYP.intake_target_type%TYPE;
42: CURSOR c_itt IS
43: SELECT itt.closed_ind
44: FROM IGS_AD_INTAK_TRG_TYP itt
45: WHERE itt.intake_target_type = p_intake_target_type;
46: BEGIN
47: p_message_name := null;
48: OPEN c_itt;