1 package GMO_VBATCH_TASK_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMOVVTKS.pls 120.2.12020000.4 2012/09/21 15:41:45 srpuri ship $ */
3
4 function is_wms_installed return varchar2;
5
6 procedure update_process_parameter
7 (
8 p_batch_no IN VARCHAR2
9 ,p_org_code IN VARCHAR2
10 ,p_validate_flexfields IN VARCHAR2
11 ,p_batchstep_no IN NUMBER
12 ,p_activity IN VARCHAR2
13 ,p_parameter IN VARCHAR2
14 ,p_process_param_rec IN fnd_table_of_varchar2_255
15 ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_message_count OUT NOCOPY NUMBER
18 ,x_message_data OUT NOCOPY VARCHAR2
19 );
20
21
22 procedure setup_resource_transaction(
23 p_org_id NUMBER,
24 p_org_code VARCHAR2,
25 p_batch_id NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_message_count OUT NOCOPY NUMBER,
28 x_message_data OUT NOCOPY VARCHAR2
29 );
30
31 procedure create_resource_transaction (
32 p_resource_transaction_rec IN fnd_table_of_varchar2_255
33 , p_actual_resource_count IN NUMBER
34 ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_message_count OUT NOCOPY NUMBER
37 ,x_message_data OUT NOCOPY VARCHAR2
38 );
39
40 procedure update_resource_transaction (
41 p_resource_transaction_rec IN fnd_table_of_varchar2_255
42 , p_actual_resource_count IN NUMBER
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_message_count OUT NOCOPY NUMBER
45 ,x_message_data OUT NOCOPY VARCHAR2
46 );
47
48 procedure delete_resource_transaction (
49 p_resource_transaction_rec IN fnd_table_of_varchar2_255
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_message_count OUT NOCOPY NUMBER
52 ,x_message_data OUT NOCOPY VARCHAR2
53 );
54
55 procedure save_batch (
56 p_table in number
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_message_count OUT NOCOPY NUMBER
59 ,x_message_data OUT NOCOPY VARCHAR2
60 );
61
62 procedure get_resource_txn_end_date(
63 p_start_date IN DATE
64 ,p_usage IN NUMBER
65 ,p_trans_um IN VARCHAR2
66 ,x_end_date OUT NOCOPY DATE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_message_count OUT NOCOPY NUMBER
69 ,x_message_data OUT NOCOPY VARCHAR2
70 );
71
72 procedure get_resource_txn_usage(
73 p_start_date IN DATE
74 ,p_end_date IN DATE
75 ,p_trans_um IN VARCHAR2
76 ,x_usage OUT NOCOPY NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_message_count OUT NOCOPY NUMBER
79 ,x_message_data OUT NOCOPY VARCHAR2
80 );
81
82 procedure convert_um (
83 p_organization_id IN NUMBER
84 ,p_inventory_item_id IN NUMBER
85 ,p_lot_number IN VARCHAR2
86 ,p_from_qty IN NUMBER
87 ,p_from_um IN VARCHAR2
88 ,p_to_um IN VARCHAR2
89 ,x_to_qty OUT NOCOPY NUMBER
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_message_count OUT NOCOPY NUMBER
92 ,x_message_data OUT NOCOPY VARCHAR2
93 );
94
95 procedure qty_within_deviation (
96 p_organization_id IN NUMBER
97 ,p_inventory_item_id IN NUMBER
98 ,p_lot_number IN NUMBER
99 ,p_qty IN NUMBER
100 ,p_um IN VARCHAR2
101 ,p_sec_qty IN NUMBER
102 ,p_sec_um IN VARCHAR2
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_message_count OUT NOCOPY NUMBER
105 ,x_message_data OUT NOCOPY VARCHAR2
106 );
107
108 procedure get_material_transactions(
109 p_organization_id IN NUMBER
110 ,p_batch_id IN NUMBER
111 ,p_material_detail_id IN NUMBER
112 ,x_mmt_cur OUT NOCOPY gme_api_grp.g_gmo_txns
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_message_count OUT NOCOPY NUMBER
115 ,x_message_data OUT NOCOPY VARCHAR2
116 );
117
118 procedure get_material_reservations(
119 p_organization_id IN NUMBER
120 ,p_batch_id IN NUMBER
121 ,p_material_detail_id IN NUMBER
122 ,x_res_cur OUT NOCOPY gme_api_grp.g_gmo_resvns
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_message_count OUT NOCOPY NUMBER
125 ,x_message_data OUT NOCOPY VARCHAR2
126 );
127
128 procedure get_material_pplots(
129 p_organization_id IN NUMBER
130 ,p_batch_id IN NUMBER
131 ,p_material_detail_id IN NUMBER
132 ,x_pplot_cur OUT NOCOPY gme_api_grp.g_gmo_pplots
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_message_count OUT NOCOPY NUMBER
135 ,x_message_data OUT NOCOPY VARCHAR2
136 );
137
138 procedure get_lot_transactions(
139 p_transaction_id IN NUMBER
140 ,x_lt_cur OUT NOCOPY gme_api_grp.g_gmo_lot_txns
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_message_count OUT NOCOPY NUMBER
143 ,x_message_data OUT NOCOPY VARCHAR2
144 );
145
146 procedure get_dispense_um(
147 p_material_detail_id IN NUMBER
148 ,x_dispense_um OUT NOCOPY VARCHAR2
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_message_count OUT NOCOPY NUMBER
151 ,x_message_data OUT NOCOPY VARCHAR2
152 );
153
154 procedure relieve_reservation(
155 p_reservation_id IN NUMBER
156 ,p_prim_relieve_quantity IN NUMBER
157 ,x_return_status OUT NOCOPY VARCHAR2
158 ,x_message_count OUT NOCOPY NUMBER
159 ,x_message_data OUT NOCOPY VARCHAR2
160 );
161
162 procedure relieve_pending_lot(
163 p_pending_lot_id IN NUMBER
164 ,p_quantity IN NUMBER
165 ,p_secondary_quantity IN NUMBER
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_message_count OUT NOCOPY NUMBER
168 ,x_message_data OUT NOCOPY VARCHAR2
169 );
170
171 procedure create_material_transaction(
172 p_mtl_txn_rec IN fnd_table_of_varchar2_255
173 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_message_count OUT NOCOPY NUMBER
176 ,x_message_data OUT NOCOPY VARCHAR2
177 );
178
179 procedure update_material_transaction(
180 p_mtl_txn_rec IN fnd_table_of_varchar2_255
181 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
182 ,x_return_status OUT NOCOPY VARCHAR2
183 ,x_message_count OUT NOCOPY NUMBER
184 ,x_message_data OUT NOCOPY VARCHAR2
185 );
186
187 procedure delete_material_transaction(
188 p_mtl_txn_rec IN fnd_table_of_varchar2_255
189 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_message_count OUT NOCOPY NUMBER
192 ,x_message_data OUT NOCOPY VARCHAR2
193 );
194
195 procedure create_lot(
196 p_lot_rec IN fnd_table_of_varchar2_255
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_message_count OUT NOCOPY NUMBER
199 ,x_message_data OUT NOCOPY VARCHAR2
200 );
201
202 procedure generate_lot(
203 p_organization_id IN NUMBER
204 ,p_inventory_item_id IN NUMBER
205 ,x_lot_number OUT NOCOPY VARCHAR2
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_message_count OUT NOCOPY NUMBER
208 ,x_message_data OUT NOCOPY VARCHAR2
209 );
210
211 procedure get_lot_event_key (
212 p_organization_id IN NUMBER
213 ,p_inventory_item_id IN NUMBER
214 ,p_lot_number IN VARCHAR2
215 ,x_lot_event_key OUT NOCOPY VARCHAR2
216 );
217
218 PROCEDURE release_or_complete_step(
219 p_batch_id IN NUMBER,
220 p_batchstep_id IN NUMBER,
221 p_event IN VARCHAR2,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_message OUT NOCOPY VARCHAR2,
224 x_message_count OUT NOCOPY NUMBER
225 );
226
227 PROCEDURE get_origination_date
228 ( p_inventory_item_id IN NUMBER
229 ,p_organization_id IN NUMBER
230 ,p_lot_number IN VARCHAR2
231 ,p_transaction_date IN DATE
232 ,x_orig_date OUT NOCOPY DATE
233 ,x_return_status OUT NOCOPY VARCHAR2
234 ) ;
235 end GMO_VBATCH_TASK_PVT;