APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_AUS_SEC_EDU

Line 111: -- This procedure inserts a new IGS_AD_AUS_SEC_EDU record

107: p_ase_sequence_number OUT NOCOPY NUMBER ,
108: p_message_name OUT NOCOPY VARCHAR2 )
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

Line 114: v_ase_sequence_number IGS_AD_AUS_SEC_EDU.sequence_number%TYPE;

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
118: WHERE secondary_school_cd = p_secondary_school_cd AND

Line 187: Igs_Ad_Aus_Sec_Edu_Pkg.Insert_Row (

183: OPEN c_ases;
184: FETCH c_ases INTO v_ase_sequence_number;
185: CLOSE c_ases;
186: -- Insert the record
187: Igs_Ad_Aus_Sec_Edu_Pkg.Insert_Row (
188: X_Mode => 'R',
189: X_RowId => lv_rowid,
190: X_Person_Id => p_person_id,
191: X_Sequence_Number => v_ase_sequence_number,