1 package wip_bomRoutingUtil_pvt as
2 /* $Header: wipbmrus.pls 120.1.12010000.1 2008/07/24 05:21:44 appldev ship $ */
3
4 procedure explodeRouting(p_orgID in number,
5 p_wipEntityID in number,
6 p_repSchedID in number,
7 p_itemID in number,
8 p_altRouting in varchar2,
9 p_routingRevDate in date,
10 p_qty in number,
11 p_startDate in date,
12 p_endDate in date,
13 x_serStartOp out nocopy number,
14 x_returnStatus out nocopy varchar2,
15 x_errorMsg out nocopy varchar2);
16
17 procedure explodeBOM(p_orgID in number,
18 p_wipEntityID in number,
19 p_jobType in number,
20 p_repSchedID in number,
21 p_itemID in number,
22 p_altBOM in varchar2,
23 p_bomRevDate in date,
24 p_altRouting in varchar2,
25 p_routingRevDate in date,
26 p_qty in number,
27 p_jobStartDate in date,
28 p_projectID in number,
29 p_taskID in number,
30 p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
31 x_returnStatus out nocopy varchar2,
32 x_errorMsg out nocopy varchar2);
33
34 procedure adjustQtyChange(p_orgID in number,
35 p_wipEntityID in number,
36 p_qty in number,
37 x_returnStatus out nocopy varchar2,
38 x_errorMsg out nocopy varchar2);
39
40 end wip_bomRoutingUtil_pvt;