1 package wip_bomRouting_pvt AUTHID CURRENT_USER as
2 /* $Header: wipbmrts.pls 120.2.12020000.2 2013/01/02 10:16:35 pding ship $ */
3
4 -- This procedure is used to explode the bom and routing and schedule the job if needed.
5 -- p_schedulingMethod: if the value is routing based, then you must provide one of the p_startDate
6 -- and p_endDate, you can not provide both, however.
7 -- if it is not routing based, then you must provide both.
8 -- p_startDate: forward schedule the job if it is not null
9 -- p_endDate: backward schedule the job it it is not null
10 -- p_rtgRefID: only useful when p_jobType is nonstandard
11 -- p_bomRefID: only useful when p_jobType is nonstandard
12 -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
13 procedure createJob(p_orgID in number,
14 p_wipEntityID in number,
15 p_jobType in number,
16 p_itemID in number,
17 p_schedulingMethod in number,
18 p_altRouting in varchar2,
19 p_routingRevDate in date,
20 p_altBOM in varchar2,
21 p_bomRevDate in date,
22 p_qty in number,
23 p_startDate in date,
24 p_endDate in date,
25 p_projectID in number,
26 p_taskID in number,
27 p_rtgRefID in number,
28 p_bomRefID in number,
29 p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
30 x_serStartOp out nocopy number,
31 x_returnStatus out nocopy varchar2,
32 x_errorMsg out nocopy varchar2);
33
34
35 -- This procedure is used to reexplode the bom/routing if applicable and reschedule the job.
36 -- It will also handle qty change and scheduled date changes. It will decide whether we need to
37 -- to explode from BOM or just adjust the currrent wip copy.
38 -- p_schedulingMethod: if the value is routing based, then you must provide one of the p_startDate
39 -- and p_endDate, you can not provide both, however.
40 -- if it is not routing based, then you must provide both.
41 -- p_startDate: forward schedule the job if it is not null
42 -- p_endDate: backward schedule the job it it is not null
43 -- p_rtgRefID: only useful when p_jobType is nonstandard
44 -- p_bomRefID: only useful when p_jobType is nonstandard
45 -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
46
47 -- for anything related to bom/rtg you do not want to change, for instance, bom_reference_id, you must pass the original
48 -- value queried up from the job. If you pass null, this API will consider that you want to change the
49 -- value to null instead of not touching it at all.
50 procedure reexplodeJob(p_orgID in number,
51 p_wipEntityID in number,
52 p_schedulingMethod in number,
53 p_altRouting in varchar2,
54 p_routingRev in varchar2, /*add for bug 15963294*/
55 p_routingRevDate in date,
56 p_altBOM in varchar2,
57 p_bomRev in varchar2, /*add for bug 15963294*/
58 p_bomRevDate in date,
59 p_qty in number,
60 p_startDate in date,
61 p_endDate in date,
62 p_projectID in number,
63 p_taskID in number,
64 p_rtgRefID in number,
65 p_bomRefID in number,
66 p_allowExplosion in boolean,
67 p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
68 x_returnStatus out nocopy varchar2,
69 x_errorMsg out nocopy varchar2);
70
71 end wip_bomRouting_pvt;