APPS.IGS_RE_GEN_003 dependencies on IGS_TR_STEP_V

Line 272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;

268: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
269: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
270: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
271: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
272: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
273: v_current_person_id IGS_PE_PERSON.person_id%TYPE;
274:
275: CURSOR c_pe IS
276: SELECT PERSON_PARTY_ID

Line 308: FROM IGS_TR_STEP_V tsdv

304: WHERE tri.tracking_id = cp_tracking_id;
305: CURSOR c_tsdv (
306: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
307: SELECT MAX(tsdv.action_dt)
308: FROM IGS_TR_STEP_V tsdv
309: WHERE tsdv.tracking_id = cp_tracking_id;
310: CURSOR c_trs (
311: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
312: SELECT trs.tracking_step_id,

Line 470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)

466: ELSE
467: -- Clear the recipient ID (IGS_GE_NOTE: no locking check as the record has been
468: -- created by this routine.
469: BEGIN
470: FOR IGS_TR_STEP_REC IN CUR_IGS_TR_STEP(V_TRACKING_ID, v_trs_rec.tracking_step_id)
471: LOOP
472: IGS_TR_STEP_PKG.UPDATE_ROW(
473: X_ROWID => IGS_TR_STEP_REC.ROWID,
474: X_TRACKING_ID => IGS_TR_STEP_REC.TRACKING_ID,

Line 895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;

891: v_tracking_status IGS_TR_STATUS.tracking_status%TYPE;
892: v_person_id IGS_RE_SPRVSR.person_id%TYPE;
893: v_start_dt IGS_TR_ITEM.start_dt%TYPE;
894: v_business_days_ind IGS_TR_ITEM.business_days_ind%TYPE;
895: v_action_dt IGS_TR_STEP_V.action_dt%TYPE;
896: CURSOR c_pe IS
897: SELECT PERSON_PARTY_ID
898: FROM fnd_user
899: WHERE user_id = fnd_global.user_id;

Line 929: FROM IGS_TR_STEP_V tsdv

925: WHERE tri.tracking_id = cp_tracking_id;
926: CURSOR c_tsdv (
927: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
928: SELECT MAX(tsdv.action_dt)
929: FROM IGS_TR_STEP_V tsdv
930: WHERE tsdv.tracking_id = cp_tracking_id;
931: CURSOR c_trs (
932: cp_tracking_id IGS_TR_ITEM.tracking_id%TYPE) IS
933: SELECT trs.tracking_step_id,