DBA Data[Home] [Help]

APPS.IGS_AD_VAL_AC dependencies on IGS_AD_CAT

Line 5: -- Validate if the IGS_AD_CAT record can be updated.

1: PACKAGE BODY IGS_AD_VAL_AC AS
2: /* $Header: IGSAD20B.pls 115.5 2003/01/08 14:30:57 rghosh ship $ */
3:
4: --
5: -- Validate if the IGS_AD_CAT record can be updated.
6: FUNCTION admp_val_ac_upd(
7: p_admission_cat IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN IS

Line 12: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;

8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN IS
10: BEGIN
11: DECLARE
12: v_admission_cat IGS_AD_CAT.admission_cat%TYPE;
13: CURSOR c_apc IS
14: SELECT apc.admission_cat
15: FROM IGS_AD_PRCS_CAT apc
16: WHERE apc.admission_cat = p_admission_cat