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.21.12010000.2 2008/08/27 20:21:38 eychen ship $ */
3: TYPE supply_undo_type IS RECORD (
4: transaction_id number,
5: sr_instance_id number,

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

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

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

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

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

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

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,
258: p_inst_id, p_ship_date);
259: end if;
260:
261: END offset_date;

Line 1429: END MSC_DRP_UTIL;

1425: WHEN others then
1426: null; --dbms_output.put_line('error is ' ||SQLERRM);
1427: END retrieve_exp_version;
1428:
1429: END MSC_DRP_UTIL;