APPS.IGS_AD_VAL_ASE dependencies on IGS_AD_AUSE_ED_AS_TY

Line 44: -- IGS_AD_AUSE_ED_AS_TY.state_cd or that the

40: RETURN BOOLEAN IS
41: gv_other_detail VARCHAR2(255);
42: BEGIN -- admp_val_ase_atstate
43: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
44: -- IGS_AD_AUSE_ED_AS_TY.state_cd or that the
45: -- IGS_AD_AUSE_ED_AS_TY.state_cd is null.
46: DECLARE
47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
48: CURSOR c_aseat IS

Line 45: -- IGS_AD_AUSE_ED_AS_TY.state_cd is null.

41: gv_other_detail VARCHAR2(255);
42: BEGIN -- admp_val_ase_atstate
43: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
44: -- IGS_AD_AUSE_ED_AS_TY.state_cd or that the
45: -- IGS_AD_AUSE_ED_AS_TY.state_cd is null.
46: DECLARE
47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
48: CURSOR c_aseat IS
49: SELECT state_cd

Line 50: FROM IGS_AD_AUSE_ED_AS_TY

46: DECLARE
47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
48: CURSOR c_aseat IS
49: SELECT state_cd
50: FROM IGS_AD_AUSE_ED_AS_TY
51: WHERE aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;
52: BEGIN
53: p_message_name := Null;
54: IF p_aus_scndry_edu_ass_type IS NOT NULL THEN

Line 110: -- Validate if IGS_AD_AUSE_ED_AS_TY is closed.

106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END admp_val_ase_scstate;
109: --
110: -- Validate if IGS_AD_AUSE_ED_AS_TY is closed.
111: FUNCTION ADMP_VAL_ASEATCLOSED(
112: p_aus_scndry_edu_ass_type IN VARCHAR2 ,
113: p_message_name OUT NOCOPY VARCHAR2 )
114: RETURN BOOLEAN IS

Line 117: -- Validate if IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type is closed.

113: p_message_name OUT NOCOPY VARCHAR2 )
114: RETURN BOOLEAN IS
115: gv_other_detail VARCHAR2(255);
116: BEGIN -- admp_val_aseatclosed
117: -- Validate if IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type is closed.
118: DECLARE
119: v_closed_ind IGS_AD_AUSE_ED_AS_TY.closed_ind%TYPE DEFAULT NULL;
120: CURSOR c_aseat IS
121: SELECT closed_ind

Line 119: v_closed_ind IGS_AD_AUSE_ED_AS_TY.closed_ind%TYPE DEFAULT NULL;

115: gv_other_detail VARCHAR2(255);
116: BEGIN -- admp_val_aseatclosed
117: -- Validate if IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type is closed.
118: DECLARE
119: v_closed_ind IGS_AD_AUSE_ED_AS_TY.closed_ind%TYPE DEFAULT NULL;
120: CURSOR c_aseat IS
121: SELECT closed_ind
122: FROM IGS_AD_AUSE_ED_AS_TY
123: WHERE aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;

Line 122: FROM IGS_AD_AUSE_ED_AS_TY

118: DECLARE
119: v_closed_ind IGS_AD_AUSE_ED_AS_TY.closed_ind%TYPE DEFAULT NULL;
120: CURSOR c_aseat IS
121: SELECT closed_ind
122: FROM IGS_AD_AUSE_ED_AS_TY
123: WHERE aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;
124: BEGIN
125: p_message_name := Null;
126: IF p_aus_scndry_edu_ass_type IS NOT NULL THEN