1 PACKAGE wip_discrete_ws_move AUTHID CURRENT_USER AS
2 /* $Header: wipdsmvs.pls 120.1 2006/09/19 06:30:30 paho noship $ */
3
4 TYPE MoveData IS RECORD
5 (
6 txnMode number,
7 txnID number,
8 txnType number,
9 orgID number,
10 wipEntityID number,
11 fmOp number,
12 fmStep number,
13 toOp number,
14 toStep number,
15 txnQty number,
16 txnUOM varchar2(3),
17 scrapAcctID number,
18 qaCollectionID number,
19 periodID number,
20 assyHeaderID number,
21 compHeaderID number,
22 mtlMode number
23 );
24
25
26 procedure explodeComponents(p_jobID in number,
27 p_orgID in number,
28 p_moveQty in number,
29 p_fromOp in number,
30 p_fromStep in number,
31 p_toOp in number,
32 p_toStep in number,
33 p_txnType in number,
34 x_moveTxnID out nocopy number,
35 x_cplTxnID out nocopy number,
36 x_txnHeaderID out nocopy number,
37 x_compHeaderID out nocopy number,
38 x_batchID out nocopy number,
39 x_lotEntryType out nocopy number,
40 x_compInfo out nocopy system.wip_lot_serial_obj_t,
41 x_mtlMode out nocopy number,
42 x_periodID out nocopy number,
43 x_returnStatus out nocopy varchar2,
44 x_errMessage out nocopy varchar2);
45
46
47 procedure processMove(moveData in MoveData,
48 x_returnStatus out nocopy varchar2,
49 x_errMessage out nocopy varchar2);
50
51
52 procedure createLocator(p_orgID in number,
53 p_locatorName in varchar2,
54 p_subinv in varchar2,
55 x_locatorID out nocopy number,
56 x_returnStatus out nocopy varchar2,
57 x_errMessage out nocopy varchar2);
58
59 procedure checkOvershipment(p_orgID in number,
60 p_itemID in number,
61 p_orderLineID in number,
62 p_primaryQty in number,
63 p_primaryUOM in varchar2,
64 x_returnStatus out nocopy varchar2,
65 x_errMessage out nocopy varchar2);
66
67
68
69 function clientToServerDate(p_date in date) return date;
70
71 function serverToClientDate(p_date in date) return date;
72
73 procedure initTimezone;
74
75 /* Fix for bug 4568517: New procedure get_prj_loc_lov added.
76 *=====================================================================+
77 | PROCEDURE
78 | get_prj_loc_lov
79 |
80 | PURPOSE
81 | A replacement LOV API taken from package INV_UI_ITEM_SUB_LOC_LOVS
82 | for use in WIP. Will be called by LocatorLovService.java to
83 | populate completion locator LOV in discrete workstation.
84 |
85 | Returns a REF cursor containing LOV query. For PJM org, the locator
86 | will contain the project number and task number, and will be filtered
87 | on the project and task supplied.
88 |
89 +=====================================================================*/
90
91 TYPE t_genref IS REF CURSOR;
92
93 PROCEDURE get_prj_loc_lov(
94 x_locators OUT NOCOPY t_genref
95 , p_organization_id IN NUMBER
96 , p_subinventory_code IN VARCHAR2
97 , p_restrict_locators_code IN NUMBER
98 , p_inventory_item_id IN NUMBER
99 , p_concatenated_segments IN VARCHAR2
100 , p_transaction_type_id IN NUMBER
101 , p_wms_installed IN VARCHAR2
102 , p_project_id IN NUMBER
103 , p_task_id IN NUMBER
104 );
105
106 END wip_discrete_ws_move;