APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_AUS_SEC_ED_SC

Line 113: v_secondary_school_cd IGS_AD_AUS_SEC_ED_SC.secondary_school_cd%TYPE := NULL;

109: RETURN BOOLEAN IS
110: BEGIN -- admp_ins_aus_scn_edu
111: -- This procedure inserts a new IGS_AD_AUS_SEC_EDU record
112: DECLARE
113: v_secondary_school_cd IGS_AD_AUS_SEC_ED_SC.secondary_school_cd%TYPE := NULL;
114: v_ase_sequence_number IGS_AD_AUS_SEC_EDU.sequence_number%TYPE;
115: CURSOR c_ass IS
116: SELECT secondary_school_cd
117: FROM IGS_AD_AUS_SEC_ED_SC

Line 117: FROM IGS_AD_AUS_SEC_ED_SC

113: v_secondary_school_cd IGS_AD_AUS_SEC_ED_SC.secondary_school_cd%TYPE := NULL;
114: v_ase_sequence_number IGS_AD_AUS_SEC_EDU.sequence_number%TYPE;
115: CURSOR c_ass IS
116: SELECT secondary_school_cd
117: FROM IGS_AD_AUS_SEC_ED_SC
118: WHERE secondary_school_cd = p_secondary_school_cd AND
119: closed_ind = 'N' AND
120: state_cd = p_state_cd;
121: CURSOR c_aseat IS

Line 181: -- Get the next sequence number for IGS_AD_AUS_SEC_ED_SC for PERSON

177: v_secondary_school_cd := v_ass_rec.secondary_school_cd;
178: END IF;
179: CLOSE c_ass;
180: END IF;
181: -- Get the next sequence number for IGS_AD_AUS_SEC_ED_SC for PERSON
182: -- A number will always be returned, at least 1.
183: OPEN c_ases;
184: FETCH c_ases INTO v_ase_sequence_number;
185: CLOSE c_ases;

Line 226: -- This procedure inserts a new IGS_AD_AUS_SEC_ED_SC record

222: p_notes IN VARCHAR2 ,
223: p_message_name OUT NOCOPY VARCHAR2 )
224: RETURN BOOLEAN IS
225: BEGIN -- admp_ins_aus_scn_sub
226: -- This procedure inserts a new IGS_AD_AUS_SEC_ED_SC record
227: DECLARE
228: CURSOR c_aseat IS
229: SELECT aus_scndry_edu_ass_type
230: FROM IGS_AD_AUSE_ED_AS_TY