1 PACKAGE wma_inv_wrappers AUTHID CURRENT_USER AS
2 /* $Header: wmainvws.pls 115.8 2003/06/09 18:59:02 kmreddy ship $ */
3
4 PROCEDURE validateLot(p_inventory_item_id IN NUMBER,
5 p_organization_id IN NUMBER,
6 p_lot_number IN VARCHAR2,
7 x_lot_exp OUT NOCOPY DATE,
8 x_return_status OUT NOCOPY VARCHAR2,
9 x_err_msg OUT NOCOPY VARCHAR2);
10
11 PROCEDURE insertLot(p_header_id IN NUMBER,
12 p_lot_number IN VARCHAR2,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_err_msg OUT NOCOPY VARCHAR2);
15
16 PROCEDURE updateLSAttributes(p_header_id IN NUMBER,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_err_msg OUT NOCOPY VARCHAR2);
19
20 PROCEDURE backflush(p_header_id IN NUMBER,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_err_msg OUT NOCOPY VARCHAR2);
23
24 PROCEDURE createLpn(p_api_version IN NUMBER,
25 p_commit IN VARCHAR2,
26 p_lpn IN VARCHAR2,
27 p_organization_id IN NUMBER,
28 p_source IN NUMBER,
29 p_source_type_id IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_err_msg OUT NOCOPY VARCHAR2,
32 x_lpn_id OUT NOCOPY VARCHAR2);
33
34 PROCEDURE packLpnContainer(p_api_version IN NUMBER,
35 p_commit IN VARCHAR2,
36 p_lpn_id IN NUMBER,
37 p_content_item_id IN NUMBER,
38 p_revision IN VARCHAR2,
39 p_lot_number IN VARCHAR2,
40 p_from_serial_number IN VARCHAR2,
41 p_to_serial_number IN VARCHAR2,
42 p_quantity IN NUMBER,
43 p_organization_id IN NUMBER,
44 p_source_type_id IN NUMBER,
45 p_uom IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_err_msg OUT NOCOPY VARCHAR2);
48
49 PROCEDURE packSerials(p_api_version IN NUMBER,
50 p_commit IN VARCHAR2,
51 p_lpn_id IN NUMBER,
52 p_content_item_id IN NUMBER,
53 p_revision IN VARCHAR2,
54 p_lot_number IN VARCHAR2,
55 p_from_serial_number IN VARCHAR2,
56 p_to_serial_number IN VARCHAR2,
57 p_quantity IN NUMBER,
58 p_organization_id IN NUMBER,
59 p_source_type_id IN NUMBER,
60 p_uom IN VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_err_msg OUT NOCOPY VARCHAR2);
63
64 PROCEDURE createMO(p_organization_id IN NUMBER,
65 p_inventory_item_id IN NUMBER,
66 p_quantity IN NUMBER,
67 p_uom IN VARCHAR2,
68 p_lpn_id IN NUMBER,
69 p_reference_id IN NUMBER,
70 p_lot_number IN VARCHAR2,
71 p_revision IN VARCHAR2,
72 p_transaction_source_id IN NUMBER,
73 p_transaction_type_id IN NUMBER,
74 p_transaction_source_type_id IN NUMBER,
75 p_wms_process_flag IN NUMBER,
76 p_project_id IN NUMBER,
77 p_task_id IN NUMBER,
78 p_header_id IN OUT NOCOPY NUMBER,
79 x_line_id OUT NOCOPY NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_err_msg OUT NOCOPY VARCHAR2);
82
83 PROCEDURE OkMOLines(p_lpn_id IN NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_err_msg OUT NOCOPY VARCHAR2);
86
87 PROCEDURE updateLpnContext(p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_commit IN VARCHAR2,
90 p_lpn_id IN NUMBER,
91 p_lpn_context IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_err_msg OUT NOCOPY VARCHAR2);
94
95 --transferReservation -- transfers the sales order reservation from wip to inventory
96 -- for lpn completions.
97 --
98 --called by inventory for lpn completions. We can not process the sales order reservation
99 --immediately as for lpn completions, the destination of the move order is not known, and
100 --the assembly will not even be in that location until the move order is transacted. Thus,
101 --inventory calls this procedure when the move order is transacted. This procedure may be
102 --obsoleted if we ever change lpn completions to complete into a staging sub.
103 --
104 -- parameters:
105 -- + p_header_id: unique key into the wip_lpn_completions table (header_id column)
106 -- + p_subinventory_code: the destination subinv
107 -- + p_locator_id: the destination locator id
108 -- + p_primary_quantity: the quantity being transacted (not necessarily the quantity that
109 -- was completed. It could be a lesser value.
110 -- + p_lpn_id: The lpn id to pass to the inventory API inv_reservation_pub.transfer_reservation()
111 -- This value is:
112 -- + The lpn_id of the completion if the entire txn quantity is being dropped.
113 -- + The to lpn_id if the quantity is being dropped into an lpn
114 -- + null if a partial quantity is being dropped loose into inventory
115 -- + x_returnStatus: FND_API.G_RET_STS_SUCCESS on success.
116 -- + x_msg_count: Number of messages on the message stack
117 -- + x_msg
118 PROCEDURE transferReservation(p_header_id IN NUMBER, --the header_id to the wlc table
119 p_subinventory_code IN VARCHAR2,
120 p_locator_id IN NUMBER,
121 p_primary_quantity IN NUMBER,
122 p_lpn_id IN NUMBER,
123 p_lot_number IN VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_err_msg OUT NOCOPY VARCHAR2);
127
128 PROCEDURE clearQtyTrees(x_return_status OUT NOCOPY VARCHAR2,
129 x_err_msg OUT NOCOPY VARCHAR2);
130
131 END wma_inv_wrappers;