DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_REL_WF

Line 241: msc_rel_wf.get_offset_date(p_deliver_calendar,

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

Line 254: msc_rel_wf.get_offset_date(p_deliver_calendar,

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

Line 318: msc_rel_wf.get_offset_date(v_receive_calendar,

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

Line 341: msc_rel_wf.get_offset_date(v_receive_calendar,

337: p_source_sr_instance_id);
338:
339: IF p_anchor_date <> 'DUE_DATE' then
340: p_due_date :=
341: msc_rel_wf.get_offset_date(v_receive_calendar,
342: p_inst_id,
343: v_pp_lead_time, p_dock_date);
344: END IF;
345: