DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_REL_WF

Line 240: msc_rel_wf.get_offset_date(p_deliver_calendar,

236: msc_drp_util.get_work_day( 'NEXT', p_ship_calendar,
237: p_inst_id, p_ship_date);
238: -- dbms_output.put_line('new ship date='||to_char(p_ship_date, 'MM/DD/RR HH24:MI'));
239: p_dock_date :=
240: msc_rel_wf.get_offset_date(p_deliver_calendar,
241: p_inst_id,
242: p_lead_time, p_ship_date);
243: -- dbms_output.put_line('dock date='||to_char(p_dock_date, 'MM/DD/RR HH24:MI'));
244: p_dock_date :=

Line 253: msc_rel_wf.get_offset_date(p_deliver_calendar,

249: p_dock_date :=
250: msc_drp_util.get_work_day('PREV',p_receive_calendar,
251: p_inst_id, p_dock_date);
252: p_ship_date :=
253: msc_rel_wf.get_offset_date(p_deliver_calendar,
254: p_inst_id,
255: -1*p_lead_time, p_dock_date);
256: p_ship_date :=
257: msc_drp_util.get_work_day('PREV', p_ship_calendar,

Line 315: msc_rel_wf.get_offset_date(v_receive_calendar,

311: end if;
312:
313: IF p_anchor_date = 'DUE_DATE' then
314: p_dock_date :=
315: msc_rel_wf.get_offset_date(v_receive_calendar,
316: p_inst_id,
317: v_pp_lead_time*-1, p_due_date);
318: v_anchor_date := 'DOCK_DATE';
319: ELSE

Line 337: msc_rel_wf.get_offset_date(v_receive_calendar,

333: p_dock_date);
334:
335: IF p_anchor_date <> 'DUE_DATE' then
336: p_due_date :=
337: msc_rel_wf.get_offset_date(v_receive_calendar,
338: p_inst_id,
339: v_pp_lead_time, p_dock_date);
340: END IF;
341: