APPS.IGS_AD_VAL_TE dependencies on IGS_OR_INSTITUTION

Line 5: -- Validate tertiary education IGS_OR_INSTITUTION details.

1: PACKAGE BODY IGS_AD_VAL_TE AS
2: /* $Header: IGSAD72B.pls 115.3 2002/11/28 21:40:17 nsidana ship $ */
3:
4: --
5: -- Validate tertiary education IGS_OR_INSTITUTION details.
6: FUNCTION admp_val_te_inst(
7: p_institution_cd IN VARCHAR2 ,
8: p_institution_name IN VARCHAR2 ,
9: p_message_name OUT NOCOPY VARCHAR2 )

Line 12: -- Validate IGS_AD_TER_EDU IGS_OR_INSTITUTION details

8: p_institution_name IN VARCHAR2 ,
9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN AS
11: BEGIN -- admp_val_te_inst
12: -- Validate IGS_AD_TER_EDU IGS_OR_INSTITUTION details
13: DECLARE
14: v_local_inst_ind IGS_OR_INSTITUTION.local_institution_ind%TYPE;
15: CURSOR c_institution IS
16: SELECT local_institution_ind

Line 14: v_local_inst_ind IGS_OR_INSTITUTION.local_institution_ind%TYPE;

10: RETURN BOOLEAN AS
11: BEGIN -- admp_val_te_inst
12: -- Validate IGS_AD_TER_EDU IGS_OR_INSTITUTION details
13: DECLARE
14: v_local_inst_ind IGS_OR_INSTITUTION.local_institution_ind%TYPE;
15: CURSOR c_institution IS
16: SELECT local_institution_ind
17: FROM IGS_OR_INSTITUTION
18: WHERE institution_cd = p_institution_cd;

Line 17: FROM IGS_OR_INSTITUTION

13: DECLARE
14: v_local_inst_ind IGS_OR_INSTITUTION.local_institution_ind%TYPE;
15: CURSOR c_institution IS
16: SELECT local_institution_ind
17: FROM IGS_OR_INSTITUTION
18: WHERE institution_cd = p_institution_cd;
19: BEGIN
20: p_message_name := null;
21: IF p_institution_cd IS NULL AND