APPS.MSC_DRP_UTIL dependencies on MSC_DRP_UTIL

Line 1: PACKAGE BODY MSC_DRP_UTIL AS

1: PACKAGE BODY MSC_DRP_UTIL AS
2: /* $Header: MSCDRPUB.pls 120.23.12020000.2 2012/09/04 16:40:52 eychen ship $ */
3: TYPE supply_undo_type IS RECORD (
4: transaction_id number,
5: sr_instance_id number,

Line 237: msc_drp_util.get_work_day( 'NEXT', p_ship_calendar,

233: -- dbms_output.put_line(p_lead_time||','||p_deliver_calendar||','||p_receive_calendar||','||p_ship_calendar);
234: if p_anchor_date = 'SHIP_DATE' then
235: -- dbms_output.put_line('old ship date='||to_char(p_ship_date, 'MM/DD/RR HH24:MI'));
236: p_ship_date :=
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,

Line 246: msc_drp_util.get_work_day('NEXT', p_receive_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 :=
246: msc_drp_util.get_work_day('NEXT', p_receive_calendar,
247: p_inst_id, p_dock_date);
248: -- dbms_output.put_line('dock date2='||to_char(p_dock_date, 'MM/DD/RR HH24:MI'));
249: else
250: p_dock_date :=

Line 251: msc_drp_util.get_work_day('PREV',p_receive_calendar,

247: p_inst_id, p_dock_date);
248: -- dbms_output.put_line('dock date2='||to_char(p_dock_date, 'MM/DD/RR HH24:MI'));
249: else
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,

Line 258: msc_drp_util.get_work_day('PREV', p_ship_calendar,

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,
259: nvl(p_source_sr_instance_id,
260: p_inst_id), p_ship_date);
261: end if;
262:

Line 1445: END MSC_DRP_UTIL;

1441: WHEN others then
1442: null; --dbms_output.put_line('error is ' ||SQLERRM);
1443: END retrieve_exp_version;
1444:
1445: END MSC_DRP_UTIL;