APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_PR_MILESTONE

Line 303: FROM IGS_PR_MILESTONE mil

299: v_mil_exists VARCHAR2(1);
300: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
301: CURSOR c_mil IS
302: SELECT 'x'
303: FROM IGS_PR_MILESTONE mil
304: WHERE mil.person_id = p_person_id AND
305: mil.sequence_number = p_ca_sequence_number;
306: CURSOR c_mil1 IS
307: SELECT mil.sequence_number,

Line 318: FROM IGS_PR_MILESTONE mil

314: mil.ovrd_ntfctn_imminent_days,
315: mil.ovrd_ntfctn_reminder_days,
316: mil.ovrd_ntfctn_re_reminder_days,
317: mil.comments
318: FROM IGS_PR_MILESTONE mil
319: WHERE mil.person_id = p_person_id AND
320: mil.ca_sequence_number = p_transfer_ca_sequence_number
321: ORDER BY mil.due_dt;
322: BEGIN

Line 343: BEGIN --Insert IGS_PR_MILESTONE

339: END IF;
340: CLOSE c_mil;
341: SAVEPOINT sp_milestone;
342: --Insert milestone
343: BEGIN --Insert IGS_PR_MILESTONE
344: FOR v_mil1_rec IN c_mil1 LOOP
345: DECLARE
346: l_rowid VARCHAR2(25);
347: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;

Line 349: IGS_PR_MILESTONE_PKG.INSERT_ROW(

345: DECLARE
346: l_rowid VARCHAR2(25);
347: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
348: BEGIN
349: IGS_PR_MILESTONE_PKG.INSERT_ROW(
350: x_rowid => l_rowid,
351: X_org_id => l_org_id,
352: x_person_id => p_person_id,
353: x_ca_sequence_number => p_ca_sequence_number,

Line 367: END LOOP; --(IGS_PR_MILESTONE)

363: x_ovrd_ntfctn_re_reminder_days => v_mil1_rec.ovrd_ntfctn_re_reminder_days,
364: x_comments => v_mil1_rec.comments );
365: END;
366:
367: END LOOP; --(IGS_PR_MILESTONE)
368: EXCEPTION
369: WHEN OTHERS THEN -- (exception)
370: ROLLBACK TO sp_milestone;
371: p_message_name := 'IGS_RE_CANT_INSERT_MILESTONES';