APPS.IGS_AD_VAL_TE dependencies on IGS_AD_TER_ED_LV_COM

Line 81: -- Validate if IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp is closed.

77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END admp_val_te_enr_yr;
80: --
81: -- Validate if IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp is closed.
82: FUNCTION admp_val_telocclosed(
83: p_tertiary_edu_lvl_comp IN VARCHAR2 ,
84: p_message_name OUT NOCOPY VARCHAR2 )
85: RETURN BOOLEAN AS

Line 87: --This module validates if IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp

83: p_tertiary_edu_lvl_comp IN VARCHAR2 ,
84: p_message_name OUT NOCOPY VARCHAR2 )
85: RETURN BOOLEAN AS
86: BEGIN --admp_val_telocclosed
87: --This module validates if IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp
88: -- is closed
89: DECLARE
90: v_teloc_exists VARCHAR2(1);
91: CURSOR c_teloc IS

Line 93: FROM IGS_AD_TER_ED_LV_COM teloc

89: DECLARE
90: v_teloc_exists VARCHAR2(1);
91: CURSOR c_teloc IS
92: SELECT 'X'
93: FROM IGS_AD_TER_ED_LV_COM teloc
94: WHERE teloc.tertiary_edu_lvl_comp = p_tertiary_edu_lvl_comp AND
95: teloc.closed_ind = 'Y';
96: BEGIN
97: --Set the default message number