APPS.IGS_AD_VAL_TE dependencies on IGS_AD_TER_ED_LVL_QF

Line 118: -- Validate if IGS_AD_TER_ED_LVL_QF.tertiary_edu_lvl_qual is closed.

114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END admp_val_telocclosed;
117: --
118: -- Validate if IGS_AD_TER_ED_LVL_QF.tertiary_edu_lvl_qual is closed.
119: FUNCTION admp_val_teloqclosed(
120: p_tertiary_edu_lvl_qual IN VARCHAR2 ,
121: p_message_name OUT NOCOPY VARCHAR2 )
122: RETURN BOOLEAN AS

Line 124: --This module validates if IGS_AD_TER_ED_LVL_QF.IGS_AD_TER_ED_LVL_QF

120: p_tertiary_edu_lvl_qual IN VARCHAR2 ,
121: p_message_name OUT NOCOPY VARCHAR2 )
122: RETURN BOOLEAN AS
123: BEGIN --admp_val_teloqclosed
124: --This module validates if IGS_AD_TER_ED_LVL_QF.IGS_AD_TER_ED_LVL_QF
125: -- is closed
126: DECLARE
127: v_teloq_exists VARCHAR2(1);
128: CURSOR c_teloq IS

Line 130: FROM IGS_AD_TER_ED_LVL_QF teloq

126: DECLARE
127: v_teloq_exists VARCHAR2(1);
128: CURSOR c_teloq IS
129: SELECT 'X'
130: FROM IGS_AD_TER_ED_LVL_QF teloq
131: WHERE teloq.tertiary_edu_lvl_qual = p_tertiary_edu_lvl_qual AND
132: teloq.closed_ind = 'Y';
133: BEGIN
134: --Set the default message number