APPS.IGS_AD_EXTRACURR_ACT_PKG dependencies on IGS_AD_HZ_EXTRACURR_ACT

Line 162: Igs_Ad_Hz_Extracurr_Act_Pkg.Insert_Row(

158: -- selecting the value of the last_update_date ot pass
159: -- it back to the calling form to enable locking when the record
160: -- is updated immediately after inserting.
161:
162: Igs_Ad_Hz_Extracurr_Act_Pkg.Insert_Row(
163: x_rowid => l_rowId,
164: x_hz_extracurr_act_id => l_hz_extracurr_act_id,
165: x_person_interest_id => x_person_interest_id,
166: x_end_date => x_End_Date,

Line 222: IGS_AD_HZ_EXTRACURR_ACT

218: CURSOR C1 IS
219: SELECT
220: ROWID, HZ_EXTRACURR_ACT_ID
221: FROM
222: IGS_AD_HZ_EXTRACURR_ACT
223: WHERE
224: PERSON_INTEREST_ID = x_person_interest_id;
225: tmp_var1 VARCHAR2(2000);
226: tmp_var VARCHAR2(2000);

Line 342: Igs_Ad_Hz_Extracurr_Act_Pkg.Update_Row(

338:
339: OPEN C1;
340: FETCH C1 INTO l_RowId, l_hz_ExtraCurr_Act_Id;
341: CLOSE C1;
342: Igs_Ad_Hz_Extracurr_Act_Pkg.Update_Row(
343: x_rowid => l_rowId,
344: x_hz_extracurr_act_id => l_hz_ExtraCurr_Act_Id,
345: x_person_interest_id => x_person_interest_id,
346: x_end_date => x_End_Date,