APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_AUS_SEC_ED_SU

Line 130: FROM IGS_AD_AUS_SEC_ED_SU

126: p_aus_scndry_edu_ass_type IS NULL OR
127: tac_aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;
128: CURSOR c_ases IS
129: SELECT NVL(MAX(ase_sequence_number), 0) +1
130: FROM IGS_AD_AUS_SEC_ED_SU
131: WHERE person_id = p_person_id;
132: v_ass_rec c_ass%ROWTYPE;
133: v_aseat_rec c_aseat%ROWTYPE;
134: v_aseat_found BOOLEAN := FALSE;

Line 234: v_subject_ass_type IGS_AD_AUS_SEC_ED_SU.subject_ass_type%TYPE DEFAULT NULL;

230: FROM IGS_AD_AUSE_ED_AS_TY
231: WHERE aus_scndry_edu_ass_type = p_subject_ass_type OR
232: tac_aus_scndry_edu_ass_type = p_subject_ass_type;
233: v_aseat_rec c_aseat%ROWTYPE;
234: v_subject_ass_type IGS_AD_AUS_SEC_ED_SU.subject_ass_type%TYPE DEFAULT NULL;
235: lv_rowid VARCHAR2(25);
236: BEGIN
237: p_message_name := NULL;
238: -- Validate Parameters

Line 254: Igs_Ad_Aus_Sec_Ed_Su_Pkg.Insert_Row (

250: v_subject_ass_type := v_aseat_rec.aus_scndry_edu_ass_type;
251: END IF;
252: CLOSE c_aseat;
253:
254: Igs_Ad_Aus_Sec_Ed_Su_Pkg.Insert_Row (
255: X_Mode => 'R',
256: X_RowId => lv_rowid,
257: X_Person_Id => p_person_id,
258: X_Ase_Sequence_Number => p_ase_sequence_number,