1 PACKAGE WSH_TRX_HANDLER AUTHID CURRENT_USER AS
2 /* $Header: WSHIIXIS.pls 120.0 2005/05/26 18:17:03 appldev noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_trx_interface_id IN OUT NOCOPY NUMBER,
7 p_trx_header_id IN NUMBER,
8 p_trx_source_id IN NUMBER,
9 p_source_code IN VARCHAR2,
10 p_source_line_id IN NUMBER,
11 p_source_header_id IN NUMBER,
12 p_inventory_item_id IN NUMBER,
13 p_subinventory_code IN VARCHAR2,
14 p_trx_quantity IN NUMBER,
15 p_transaction_date IN DATE,
16 p_organization_id IN NUMBER,
17 p_dsp_segment1 IN VARCHAR2,
18 p_dsp_segment2 IN VARCHAR2,
19 p_dsp_segment3 IN VARCHAR2,
20 p_trx_source_type_id IN NUMBER,
21 p_trx_action_id IN NUMBER,
22 p_trx_type_id IN NUMBER,
23 p_distribution_account_id IN NUMBER,
24 p_dst_segment1 IN VARCHAR2,
25 p_dst_segment2 IN VARCHAR2,
26 p_dst_segment3 IN VARCHAR2,
27 p_dst_segment4 IN VARCHAR2,
28 p_dst_segment5 IN VARCHAR2,
29 p_dst_segment6 IN VARCHAR2,
30 p_dst_segment7 IN VARCHAR2,
31 p_dst_segment8 IN VARCHAR2,
32 p_dst_segment9 IN VARCHAR2,
33 p_dst_segment10 IN VARCHAR2,
37 p_dst_segment14 IN VARCHAR2,
34 p_dst_segment11 IN VARCHAR2,
35 p_dst_segment12 IN VARCHAR2,
36 p_dst_segment13 IN VARCHAR2,
38 p_dst_segment15 IN VARCHAR2,
39 p_dst_segment16 IN VARCHAR2,
40 p_dst_segment17 IN VARCHAR2,
41 p_dst_segment18 IN VARCHAR2,
42 p_dst_segment19 IN VARCHAR2,
43 p_dst_segment20 IN VARCHAR2,
44 p_dst_segment21 IN VARCHAR2,
45 p_dst_segment22 IN VARCHAR2,
46 p_dst_segment23 IN VARCHAR2,
47 p_dst_segment24 IN VARCHAR2,
48 p_dst_segment25 IN VARCHAR2,
49 p_dst_segment26 IN VARCHAR2,
50 p_dst_segment27 IN VARCHAR2,
51 p_dst_segment28 IN VARCHAR2,
52 p_dst_segment29 IN VARCHAR2,
53 p_dst_segment30 IN VARCHAR2,
54 p_trx_reference IN VARCHAR2,
55 p_trx_source_line_id IN NUMBER,
56 p_trx_source_delivery_id IN NUMBER,
57 p_revision IN VARCHAR2,
58 p_locator_id IN NUMBER,
59 p_loc_segment1 IN VARCHAR2,
60 p_loc_segment2 IN VARCHAR2,
61 p_loc_segment3 IN VARCHAR2,
62 p_loc_segment4 IN VARCHAR2,
63 p_picking_line_id IN NUMBER,
64 p_transfer_subinventory IN VARCHAR2,
65 p_transfer_organization IN NUMBER,
66 p_ship_to_location_id IN NUMBER,
67 p_requisition_line_id IN NUMBER,
68 p_trx_uom IN VARCHAR2,
69 p_demand_id IN NUMBER,
70 p_shipment_number IN VARCHAR2,
71 p_expected_arrival_date IN DATE,
72 p_encumbrance_account IN NUMBER,
73 p_encumbrance_amount IN NUMBER,
74 p_movement_id IN NUMBER,
75 p_freight_code IN VARCHAR2,
76 p_waybill_airbill IN VARCHAR2,
77 p_last_update_date IN DATE,
78 p_last_updated_by IN NUMBER,
79 p_creation_date IN DATE,
80 p_created_by IN NUMBER,
81 p_last_update_login IN NUMBER DEFAULT NULL,
82 p_request_id IN NUMBER DEFAULT NULL,
83 p_program_application_id IN NUMBER DEFAULT NULL,
84 p_program_id IN NUMBER DEFAULT NULL,
85 p_program_update_date IN DATE DEFAULT NULL,
86 p_process_flag IN NUMBER DEFAULT 1,
87 p_trx_mode IN NUMBER DEFAULT 3,
88 p_lock_flag IN NUMBER DEFAULT 2,
89 p_acct_period_id IN NUMBER DEFAULT NULL,
90 p_required_flag IN VARCHAR2 DEFAULT NULL,
91 p_currency_code IN VARCHAR2 DEFAULT NULL,
92 p_currency_conversion_type IN VARCHAR2 DEFAULT NULL,
93 p_currency_conversion_date IN DATE DEFAULT NULL,
94 p_currency_conversion_rate IN NUMBER DEFAULT NULL,
95 p_project_id IN NUMBER DEFAULT NULL,
96 p_task_id IN NUMBER DEFAULT NULL,
97 p_validation_required IN NUMBER DEFAULT NULL,
98 p_item_segment1 IN VARCHAR2 DEFAULT NULL,
99 p_item_segment2 IN VARCHAR2 DEFAULT NULL,
100 p_item_segment3 IN VARCHAR2 DEFAULT NULL,
101 p_item_segment4 IN VARCHAR2 DEFAULT NULL,
102 p_item_segment5 IN VARCHAR2 DEFAULT NULL,
103 p_item_segment6 IN VARCHAR2 DEFAULT NULL,
104 p_item_segment7 IN VARCHAR2 DEFAULT NULL,
105 p_item_segment8 IN VARCHAR2 DEFAULT NULL,
106 p_item_segment9 IN VARCHAR2 DEFAULT NULL,
107 p_item_segment10 IN VARCHAR2 DEFAULT NULL,
108 p_item_segment11 IN VARCHAR2 DEFAULT NULL,
109 p_item_segment12 IN VARCHAR2 DEFAULT NULL,
110 p_item_segment13 IN VARCHAR2 DEFAULT NULL,
111 p_item_segment14 IN VARCHAR2 DEFAULT NULL,
112 p_item_segment15 IN VARCHAR2 DEFAULT NULL,
113 p_item_segment16 IN VARCHAR2 DEFAULT NULL,
114 p_item_segment17 IN VARCHAR2 DEFAULT NULL,
115 p_item_segment18 IN VARCHAR2 DEFAULT NULL,
116 p_item_segment19 IN VARCHAR2 DEFAULT NULL,
117 p_item_segment20 IN VARCHAR2 DEFAULT NULL,
118 p_primary_quantity IN NUMBER DEFAULT NULL,
119 p_loc_segment5 IN VARCHAR2 DEFAULT NULL,
120 p_loc_segment6 IN VARCHAR2 DEFAULT NULL,
121 p_loc_segment7 IN VARCHAR2 DEFAULT NULL,
122 p_loc_segment8 IN VARCHAR2 DEFAULT NULL,
123 p_loc_segment9 IN VARCHAR2 DEFAULT NULL,
124 p_loc_segment10 IN VARCHAR2 DEFAULT NULL,
125 p_loc_segment11 IN VARCHAR2 DEFAULT NULL,
126 p_loc_segment12 IN VARCHAR2 DEFAULT NULL,
127 p_loc_segment13 IN VARCHAR2 DEFAULT NULL,
128 p_loc_segment14 IN VARCHAR2 DEFAULT NULL,
129 p_loc_segment15 IN VARCHAR2 DEFAULT NULL,
130 p_loc_segment16 IN VARCHAR2 DEFAULT NULL,
131 p_loc_segment17 IN VARCHAR2 DEFAULT NULL,
132 p_loc_segment18 IN VARCHAR2 DEFAULT NULL,
133 p_loc_segment19 IN VARCHAR2 DEFAULT NULL,
134 p_loc_segment20 IN VARCHAR2 DEFAULT NULL,
135 p_dsp_segment4 IN VARCHAR2 DEFAULT NULL,
136 p_dsp_segment5 IN VARCHAR2 DEFAULT NULL,
137 p_dsp_segment6 IN VARCHAR2 DEFAULT NULL,
138 p_dsp_segment7 IN VARCHAR2 DEFAULT NULL,
142 p_dsp_segment11 IN VARCHAR2 DEFAULT NULL,
139 p_dsp_segment8 IN VARCHAR2 DEFAULT NULL,
140 p_dsp_segment9 IN VARCHAR2 DEFAULT NULL,
141 p_dsp_segment10 IN VARCHAR2 DEFAULT NULL,
143 p_dsp_segment12 IN VARCHAR2 DEFAULT NULL,
144 p_dsp_segment13 IN VARCHAR2 DEFAULT NULL,
145 p_dsp_segment14 IN VARCHAR2 DEFAULT NULL,
146 p_dsp_segment15 IN VARCHAR2 DEFAULT NULL,
147 p_dsp_segment16 IN VARCHAR2 DEFAULT NULL,
148 p_dsp_segment17 IN VARCHAR2 DEFAULT NULL,
149 p_dsp_segment18 IN VARCHAR2 DEFAULT NULL,
150 p_dsp_segment19 IN VARCHAR2 DEFAULT NULL,
151 p_dsp_segment20 IN VARCHAR2 DEFAULT NULL,
152 p_dsp_segment21 IN VARCHAR2 DEFAULT NULL,
153 p_dsp_segment22 IN VARCHAR2 DEFAULT NULL,
154 p_dsp_segment23 IN VARCHAR2 DEFAULT NULL,
155 p_dsp_segment24 IN VARCHAR2 DEFAULT NULL,
156 p_dsp_segment25 IN VARCHAR2 DEFAULT NULL,
157 p_dsp_segment26 IN VARCHAR2 DEFAULT NULL,
158 p_dsp_segment27 IN VARCHAR2 DEFAULT NULL,
159 p_dsp_segment28 IN VARCHAR2 DEFAULT NULL,
160 p_dsp_segment29 IN VARCHAR2 DEFAULT NULL,
161 p_dsp_segment30 IN VARCHAR2 DEFAULT NULL,
162 p_trx_source_name IN VARCHAR2 DEFAULT NULL,
163 p_reason_id IN NUMBER DEFAULT NULL,
164 p_trx_cost IN NUMBER DEFAULT NULL,
165 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
166 p_wip_entity_type IN NUMBER DEFAULT NULL,
167 p_schedule_id IN NUMBER DEFAULT NULL,
168 p_employee_code IN VARCHAR2 DEFAULT NULL,
169 p_department_id IN NUMBER DEFAULT NULL,
170 p_schedule_update_code IN NUMBER DEFAULT NULL,
171 p_setup_teardown_code IN NUMBER DEFAULT NULL,
172 p_primary_switch IN NUMBER DEFAULT NULL,
173 p_mrp_code IN NUMBER DEFAULT NULL,
174 p_operation_seq_num IN NUMBER DEFAULT NULL,
175 p_repetitive_line_id IN NUMBER DEFAULT NULL,
176 p_customer_ship_id IN NUMBER DEFAULT NULL,
177 p_line_item_num IN NUMBER DEFAULT NULL,
178 p_receiving_document IN VARCHAR2 DEFAULT NULL,
179 p_rcv_transaction_id IN NUMBER DEFAULT NULL,
180 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
181 p_transfer_locator IN NUMBER DEFAULT NULL,
182 p_xfer_loc_segment1 IN VARCHAR2 DEFAULT NULL,
183 p_xfer_loc_segment2 IN VARCHAR2 DEFAULT NULL,
184 p_xfer_loc_segment3 IN VARCHAR2 DEFAULT NULL,
185 p_xfer_loc_segment4 IN VARCHAR2 DEFAULT NULL,
186 p_xfer_loc_segment5 IN VARCHAR2 DEFAULT NULL,
187 p_xfer_loc_segment6 IN VARCHAR2 DEFAULT NULL,
188 p_xfer_loc_segment7 IN VARCHAR2 DEFAULT NULL,
189 p_xfer_loc_segment8 IN VARCHAR2 DEFAULT NULL,
190 p_xfer_loc_segment9 IN VARCHAR2 DEFAULT NULL,
191 p_xfer_loc_segment10 IN VARCHAR2 DEFAULT NULL,
192 p_xfer_loc_segment11 IN VARCHAR2 DEFAULT NULL,
193 p_xfer_loc_segment12 IN VARCHAR2 DEFAULT NULL,
194 p_xfer_loc_segment13 IN VARCHAR2 DEFAULT NULL,
195 p_xfer_loc_segment14 IN VARCHAR2 DEFAULT NULL,
196 p_xfer_loc_segment15 IN VARCHAR2 DEFAULT NULL,
197 p_xfer_loc_segment16 IN VARCHAR2 DEFAULT NULL,
198 p_xfer_loc_segment17 IN VARCHAR2 DEFAULT NULL,
199 p_xfer_loc_segment18 IN VARCHAR2 DEFAULT NULL,
200 p_xfer_loc_segment19 IN VARCHAR2 DEFAULT NULL,
201 p_xfer_loc_segment20 IN VARCHAR2 DEFAULT NULL,
202 p_transportation_cost IN NUMBER DEFAULT NULL,
203 p_transportation_account IN NUMBER DEFAULT NULL,
204 p_transfer_cost IN NUMBER DEFAULT NULL,
205 p_containers IN NUMBER DEFAULT NULL,
206 p_new_average_cost IN NUMBER DEFAULT NULL,
207 p_value_change IN NUMBER DEFAULT NULL,
208 p_percentage_change IN NUMBER DEFAULT NULL,
209 p_demand_source_header_id IN NUMBER DEFAULT NULL,
210 p_demand_source_line IN VARCHAR2 DEFAULT NULL,
211 p_demand_source_delivery IN VARCHAR2 DEFAULT NULL,
212 p_negative_req_flag IN NUMBER DEFAULT NULL,
213 p_error_explanation IN VARCHAR2 DEFAULT NULL,
214 p_shippable_flag IN VARCHAR2 DEFAULT NULL,
215 p_error_code IN VARCHAR2 DEFAULT NULL,
216 p_attribute_category IN VARCHAR2 DEFAULT NULL,
217 p_attribute1 IN VARCHAR2 DEFAULT NULL,
218 p_attribute2 IN VARCHAR2 DEFAULT NULL,
219 p_attribute3 IN VARCHAR2 DEFAULT NULL,
220 p_attribute4 IN VARCHAR2 DEFAULT NULL,
221 p_attribute5 IN VARCHAR2 DEFAULT NULL,
222 p_attribute6 IN VARCHAR2 DEFAULT NULL,
223 p_attribute7 IN VARCHAR2 DEFAULT NULL,
224 p_attribute8 IN VARCHAR2 DEFAULT NULL,
225 p_attribute9 IN VARCHAR2 DEFAULT NULL,
226 p_attribute10 IN VARCHAR2 DEFAULT NULL,
227 p_attribute11 IN VARCHAR2 DEFAULT NULL,
228 p_attribute12 IN VARCHAR2 DEFAULT NULL,
229 p_attribute13 IN VARCHAR2 DEFAULT NULL,
230 p_attribute14 IN VARCHAR2 DEFAULT NULL,
231 p_attribute15 IN VARCHAR2 DEFAULT NULL,
232 p_requisition_distribution_id IN NUMBER DEFAULT NULL,
233 p_reservation_quantity IN NUMBER DEFAULT NULL,
234 p_shipped_quantity IN NUMBER DEFAULT NULL,
235 p_inventory_item IN VARCHAR2 DEFAULT NULL,
236 p_locator_name IN VARCHAR2 DEFAULT NULL,
237 p_to_task_id IN NUMBER DEFAULT NULL,
238 p_source_task_id IN NUMBER DEFAULT NULL,
239 p_to_project_id IN NUMBER DEFAULT NULL,
240 p_source_project_id IN NUMBER DEFAULT NULL,
241 p_pa_expenditure_org_id IN NUMBER DEFAULT NULL,
242 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
243 p_final_completion_flag IN VARCHAR2 DEFAULT NULL,
244 p_transfer_percentage IN NUMBER DEFAULT NULL,
245 p_trx_sequence_id IN NUMBER DEFAULT NULL,
246 p_material_account IN NUMBER DEFAULT NULL,
247 p_material_overhead_account IN NUMBER DEFAULT NULL,
248 p_resource_account IN NUMBER DEFAULT NULL,
249 p_outside_processing_account IN NUMBER DEFAULT NULL,
250 p_overhead_account IN NUMBER DEFAULT NULL,
251 p_bom_revision IN VARCHAR2 DEFAULT NULL,
252 p_routing_revision IN VARCHAR2 DEFAULT NULL,
253 p_bom_revision_date IN DATE DEFAULT NULL,
254 p_routing_revision_date IN DATE DEFAULT NULL,
255 p_alternate_bom_designator IN VARCHAR2 DEFAULT NULL,
256 p_alternate_routing_designator IN VARCHAR2 DEFAULT NULL,
257 p_accounting_class IN VARCHAR2 DEFAULT NULL,
258 p_demand_class IN VARCHAR2 DEFAULT NULL,
259 p_parent_id IN NUMBER DEFAULT NULL,
260 p_substitution_type_id IN NUMBER DEFAULT NULL,
261 p_substitution_item_id IN NUMBER DEFAULT NULL,
262 p_schedule_group IN NUMBER DEFAULT NULL,
263 p_build_sequence IN NUMBER DEFAULT NULL,
264 p_schedule_number IN VARCHAR2 DEFAULT NULL,
265 p_scheduled_flag IN NUMBER DEFAULT NULL,
266 p_flow_schedule IN VARCHAR2 DEFAULT NULL,
267 p_cost_group_id IN NUMBER DEFAULT NULL,
268 p_content_lpn_id IN NUMBER DEFAULT NULL,
269 -- HW OPMCONV. Added p_secondary_trx_quantity
270 -- and p_secondary_uom_code
271 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
272 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL);
273
274 /* Bug 1549125 :- added p_content_lpn_id above */
275
276
277 PROCEDURE Update_Row (
278 x_rowid IN OUT NOCOPY VARCHAR2,
279 p_trx_interface_id IN NUMBER,
280 p_trx_header_id IN NUMBER,
281 p_trx_source_id IN NUMBER,
282 p_source_code IN VARCHAR2,
283 p_source_line_id IN NUMBER,
284 p_source_header_id IN NUMBER,
285 p_inventory_item_id IN NUMBER,
286 p_subinventory_code IN VARCHAR2,
287 p_trx_quantity IN NUMBER,
288 p_transaction_date IN DATE,
289 p_organization_id IN NUMBER,
290 p_dsp_segment1 IN VARCHAR2,
291 p_dsp_segment2 IN VARCHAR2,
292 p_dsp_segment3 IN VARCHAR2,
293 p_trx_source_type_id IN NUMBER,
294 p_trx_action_id IN NUMBER,
295 p_trx_type_id IN NUMBER,
296 p_distribution_account_id IN NUMBER,
297 p_dst_segment1 IN VARCHAR2,
298 p_dst_segment2 IN VARCHAR2,
299 p_dst_segment3 IN VARCHAR2,
300 p_dst_segment4 IN VARCHAR2,
301 p_dst_segment5 IN VARCHAR2,
302 p_dst_segment6 IN VARCHAR2,
303 p_dst_segment7 IN VARCHAR2,
304 p_dst_segment8 IN VARCHAR2,
305 p_dst_segment9 IN VARCHAR2,
306 p_dst_segment10 IN VARCHAR2,
307 p_dst_segment11 IN VARCHAR2,
308 p_dst_segment12 IN VARCHAR2,
309 p_dst_segment13 IN VARCHAR2,
310 p_dst_segment14 IN VARCHAR2,
311 p_dst_segment15 IN VARCHAR2,
312 p_dst_segment16 IN VARCHAR2,
313 p_dst_segment17 IN VARCHAR2,
314 p_dst_segment18 IN VARCHAR2,
315 p_dst_segment19 IN VARCHAR2,
316 p_dst_segment20 IN VARCHAR2,
317 p_dst_segment21 IN VARCHAR2,
318 p_dst_segment22 IN VARCHAR2,
319 p_dst_segment23 IN VARCHAR2,
320 p_dst_segment24 IN VARCHAR2,
321 p_dst_segment25 IN VARCHAR2,
322 p_dst_segment26 IN VARCHAR2,
323 p_dst_segment27 IN VARCHAR2,
324 p_dst_segment28 IN VARCHAR2,
325 p_dst_segment29 IN VARCHAR2,
326 p_dst_segment30 IN VARCHAR2,
327 p_trx_reference IN VARCHAR2,
328 p_trx_source_line_id IN NUMBER,
329 p_trx_source_delivery_id IN NUMBER,
330 p_revision IN VARCHAR2,
331 p_locator_id IN NUMBER,
332 p_loc_segment1 IN VARCHAR2,
333 p_loc_segment2 IN VARCHAR2,
334 p_loc_segment3 IN VARCHAR2,
335 p_loc_segment4 IN VARCHAR2,
336 p_picking_line_id IN NUMBER,
337 p_transfer_subinventory IN VARCHAR2,
338 p_transfer_organization IN NUMBER,
339 p_ship_to_location_id IN NUMBER,
340 p_requisition_line_id IN NUMBER,
341 p_trx_uom IN VARCHAR2,
342 p_demand_id IN NUMBER,
343 p_shipment_number IN VARCHAR2,
344 p_expected_arrival_date IN DATE,
345 p_encumbrance_account IN NUMBER,
346 p_encumbrance_amount IN NUMBER,
347 p_movement_id IN NUMBER,
348 p_freight_code IN VARCHAR2,
349 p_waybill_airbill IN VARCHAR2,
350 p_last_update_date IN DATE,
351 p_last_updated_by IN NUMBER,
352 p_last_update_login IN NUMBER DEFAULT NULL,
353 p_request_id IN NUMBER DEFAULT NULL,
354 p_program_application_id IN NUMBER DEFAULT NULL,
355 p_program_id IN NUMBER DEFAULT NULL,
356 p_program_update_date IN DATE DEFAULT NULL,
357 p_process_flag IN NUMBER DEFAULT 1,
358 p_trx_mode IN NUMBER DEFAULT 3,
359 p_lock_flag IN NUMBER DEFAULT 2,
360 p_acct_period_id IN NUMBER DEFAULT NULL,
361 p_required_flag IN VARCHAR2 DEFAULT NULL,
362 p_currency_code IN VARCHAR2 DEFAULT NULL,
363 p_currency_conversion_type IN VARCHAR2 DEFAULT NULL,
364 p_currency_conversion_date IN DATE DEFAULT NULL,
365 p_currency_conversion_rate IN NUMBER DEFAULT NULL,
366 p_project_id IN NUMBER DEFAULT NULL,
367 p_task_id IN NUMBER DEFAULT NULL,
368 p_validation_required IN NUMBER DEFAULT NULL,
369 p_item_segment1 IN VARCHAR2 DEFAULT NULL,
370 p_item_segment2 IN VARCHAR2 DEFAULT NULL,
371 p_item_segment3 IN VARCHAR2 DEFAULT NULL,
372 p_item_segment4 IN VARCHAR2 DEFAULT NULL,
373 p_item_segment5 IN VARCHAR2 DEFAULT NULL,
374 p_item_segment6 IN VARCHAR2 DEFAULT NULL,
375 p_item_segment7 IN VARCHAR2 DEFAULT NULL,
376 p_item_segment8 IN VARCHAR2 DEFAULT NULL,
377 p_item_segment9 IN VARCHAR2 DEFAULT NULL,
378 p_item_segment10 IN VARCHAR2 DEFAULT NULL,
379 p_item_segment11 IN VARCHAR2 DEFAULT NULL,
380 p_item_segment12 IN VARCHAR2 DEFAULT NULL,
381 p_item_segment13 IN VARCHAR2 DEFAULT NULL,
382 p_item_segment14 IN VARCHAR2 DEFAULT NULL,
383 p_item_segment15 IN VARCHAR2 DEFAULT NULL,
384 p_item_segment16 IN VARCHAR2 DEFAULT NULL,
385 p_item_segment17 IN VARCHAR2 DEFAULT NULL,
386 p_item_segment18 IN VARCHAR2 DEFAULT NULL,
387 p_item_segment19 IN VARCHAR2 DEFAULT NULL,
388 p_item_segment20 IN VARCHAR2 DEFAULT NULL,
389 p_primary_quantity IN NUMBER DEFAULT NULL,
390 p_loc_segment5 IN VARCHAR2 DEFAULT NULL,
391 p_loc_segment6 IN VARCHAR2 DEFAULT NULL,
392 p_loc_segment7 IN VARCHAR2 DEFAULT NULL,
393 p_loc_segment8 IN VARCHAR2 DEFAULT NULL,
394 p_loc_segment9 IN VARCHAR2 DEFAULT NULL,
395 p_loc_segment10 IN VARCHAR2 DEFAULT NULL,
396 p_loc_segment11 IN VARCHAR2 DEFAULT NULL,
397 p_loc_segment12 IN VARCHAR2 DEFAULT NULL,
398 p_loc_segment13 IN VARCHAR2 DEFAULT NULL,
399 p_loc_segment14 IN VARCHAR2 DEFAULT NULL,
400 p_loc_segment15 IN VARCHAR2 DEFAULT NULL,
401 p_loc_segment16 IN VARCHAR2 DEFAULT NULL,
402 p_loc_segment17 IN VARCHAR2 DEFAULT NULL,
403 p_loc_segment18 IN VARCHAR2 DEFAULT NULL,
404 p_loc_segment19 IN VARCHAR2 DEFAULT NULL,
405 p_loc_segment20 IN VARCHAR2 DEFAULT NULL,
406 p_dsp_segment4 IN VARCHAR2 DEFAULT NULL,
407 p_dsp_segment5 IN VARCHAR2 DEFAULT NULL,
408 p_dsp_segment6 IN VARCHAR2 DEFAULT NULL,
409 p_dsp_segment7 IN VARCHAR2 DEFAULT NULL,
410 p_dsp_segment8 IN VARCHAR2 DEFAULT NULL,
411 p_dsp_segment9 IN VARCHAR2 DEFAULT NULL,
412 p_dsp_segment10 IN VARCHAR2 DEFAULT NULL,
413 p_dsp_segment11 IN VARCHAR2 DEFAULT NULL,
414 p_dsp_segment12 IN VARCHAR2 DEFAULT NULL,
415 p_dsp_segment13 IN VARCHAR2 DEFAULT NULL,
416 p_dsp_segment14 IN VARCHAR2 DEFAULT NULL,
417 p_dsp_segment15 IN VARCHAR2 DEFAULT NULL,
418 p_dsp_segment16 IN VARCHAR2 DEFAULT NULL,
419 p_dsp_segment17 IN VARCHAR2 DEFAULT NULL,
420 p_dsp_segment18 IN VARCHAR2 DEFAULT NULL,
421 p_dsp_segment19 IN VARCHAR2 DEFAULT NULL,
422 p_dsp_segment20 IN VARCHAR2 DEFAULT NULL,
423 p_dsp_segment21 IN VARCHAR2 DEFAULT NULL,
424 p_dsp_segment22 IN VARCHAR2 DEFAULT NULL,
425 p_dsp_segment23 IN VARCHAR2 DEFAULT NULL,
426 p_dsp_segment24 IN VARCHAR2 DEFAULT NULL,
427 p_dsp_segment25 IN VARCHAR2 DEFAULT NULL,
428 p_dsp_segment26 IN VARCHAR2 DEFAULT NULL,
429 p_dsp_segment27 IN VARCHAR2 DEFAULT NULL,
430 p_dsp_segment28 IN VARCHAR2 DEFAULT NULL,
431 p_dsp_segment29 IN VARCHAR2 DEFAULT NULL,
432 p_dsp_segment30 IN VARCHAR2 DEFAULT NULL,
433 p_trx_source_name IN VARCHAR2 DEFAULT NULL,
434 p_reason_id IN NUMBER DEFAULT NULL,
435 p_trx_cost IN NUMBER DEFAULT NULL,
436 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
437 p_wip_entity_type IN NUMBER DEFAULT NULL,
438 p_schedule_id IN NUMBER DEFAULT NULL,
439 p_employee_code IN VARCHAR2 DEFAULT NULL,
440 p_department_id IN NUMBER DEFAULT NULL,
441 p_schedule_update_code IN NUMBER DEFAULT NULL,
442 p_setup_teardown_code IN NUMBER DEFAULT NULL,
443 p_primary_switch IN NUMBER DEFAULT NULL,
444 p_mrp_code IN NUMBER DEFAULT NULL,
445 p_operation_seq_num IN NUMBER DEFAULT NULL,
446 p_repetitive_line_id IN NUMBER DEFAULT NULL,
447 p_customer_ship_id IN NUMBER DEFAULT NULL,
448 p_line_item_num IN NUMBER DEFAULT NULL,
449 p_receiving_document IN VARCHAR2 DEFAULT NULL,
450 p_rcv_transaction_id IN NUMBER DEFAULT NULL,
451 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
452 p_transfer_locator IN NUMBER DEFAULT NULL,
453 p_xfer_loc_segment1 IN VARCHAR2 DEFAULT NULL,
454 p_xfer_loc_segment2 IN VARCHAR2 DEFAULT NULL,
455 p_xfer_loc_segment3 IN VARCHAR2 DEFAULT NULL,
456 p_xfer_loc_segment4 IN VARCHAR2 DEFAULT NULL,
457 p_xfer_loc_segment5 IN VARCHAR2 DEFAULT NULL,
458 p_xfer_loc_segment6 IN VARCHAR2 DEFAULT NULL,
459 p_xfer_loc_segment7 IN VARCHAR2 DEFAULT NULL,
460 p_xfer_loc_segment8 IN VARCHAR2 DEFAULT NULL,
461 p_xfer_loc_segment9 IN VARCHAR2 DEFAULT NULL,
462 p_xfer_loc_segment10 IN VARCHAR2 DEFAULT NULL,
463 p_xfer_loc_segment11 IN VARCHAR2 DEFAULT NULL,
464 p_xfer_loc_segment12 IN VARCHAR2 DEFAULT NULL,
465 p_xfer_loc_segment13 IN VARCHAR2 DEFAULT NULL,
466 p_xfer_loc_segment14 IN VARCHAR2 DEFAULT NULL,
467 p_xfer_loc_segment15 IN VARCHAR2 DEFAULT NULL,
468 p_xfer_loc_segment16 IN VARCHAR2 DEFAULT NULL,
469 p_xfer_loc_segment17 IN VARCHAR2 DEFAULT NULL,
470 p_xfer_loc_segment18 IN VARCHAR2 DEFAULT NULL,
471 p_xfer_loc_segment19 IN VARCHAR2 DEFAULT NULL,
472 p_xfer_loc_segment20 IN VARCHAR2 DEFAULT NULL,
473 p_transportation_cost IN NUMBER DEFAULT NULL,
474 p_transportation_account IN NUMBER DEFAULT NULL,
475 p_transfer_cost IN NUMBER DEFAULT NULL,
476 p_containers IN NUMBER DEFAULT NULL,
477 p_new_average_cost IN NUMBER DEFAULT NULL,
478 p_value_change IN NUMBER DEFAULT NULL,
479 p_percentage_change IN NUMBER DEFAULT NULL,
480 p_demand_source_header_id IN NUMBER DEFAULT NULL,
481 p_demand_source_line IN VARCHAR2 DEFAULT NULL,
482 p_demand_source_delivery IN VARCHAR2 DEFAULT NULL,
483 p_negative_req_flag IN NUMBER DEFAULT NULL,
484 p_error_explanation IN VARCHAR2 DEFAULT NULL,
485 p_shippable_flag IN VARCHAR2 DEFAULT NULL,
486 p_error_code IN VARCHAR2 DEFAULT NULL,
487 p_attribute_category IN VARCHAR2 DEFAULT NULL,
488 p_attribute1 IN VARCHAR2 DEFAULT NULL,
489 p_attribute2 IN VARCHAR2 DEFAULT NULL,
490 p_attribute3 IN VARCHAR2 DEFAULT NULL,
491 p_attribute4 IN VARCHAR2 DEFAULT NULL,
492 p_attribute5 IN VARCHAR2 DEFAULT NULL,
493 p_attribute6 IN VARCHAR2 DEFAULT NULL,
494 p_attribute7 IN VARCHAR2 DEFAULT NULL,
495 p_attribute8 IN VARCHAR2 DEFAULT NULL,
496 p_attribute9 IN VARCHAR2 DEFAULT NULL,
497 p_attribute10 IN VARCHAR2 DEFAULT NULL,
498 p_attribute11 IN VARCHAR2 DEFAULT NULL,
499 p_attribute12 IN VARCHAR2 DEFAULT NULL,
500 p_attribute13 IN VARCHAR2 DEFAULT NULL,
501 p_attribute14 IN VARCHAR2 DEFAULT NULL,
502 p_attribute15 IN VARCHAR2 DEFAULT NULL,
503 p_requisition_distribution_id IN NUMBER DEFAULT NULL,
504 p_reservation_quantity IN NUMBER DEFAULT NULL,
505 p_shipped_quantity IN NUMBER DEFAULT NULL,
506 p_inventory_item IN VARCHAR2 DEFAULT NULL,
507 p_locator_name IN VARCHAR2 DEFAULT NULL,
508 p_to_task_id IN NUMBER DEFAULT NULL,
509 p_source_task_id IN NUMBER DEFAULT NULL,
510 p_to_project_id IN NUMBER DEFAULT NULL,
511 p_source_project_id IN NUMBER DEFAULT NULL,
512 p_pa_expenditure_org_id IN NUMBER DEFAULT NULL,
513 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
514 p_final_completion_flag IN VARCHAR2 DEFAULT NULL,
515 p_transfer_percentage IN NUMBER DEFAULT NULL,
516 p_trx_sequence_id IN NUMBER DEFAULT NULL,
517 p_material_account IN NUMBER DEFAULT NULL,
518 p_material_overhead_account IN NUMBER DEFAULT NULL,
519 p_resource_account IN NUMBER DEFAULT NULL,
520 p_outside_processing_account IN NUMBER DEFAULT NULL,
521 p_overhead_account IN NUMBER DEFAULT NULL,
522 p_bom_revision IN VARCHAR2 DEFAULT NULL,
523 p_routing_revision IN VARCHAR2 DEFAULT NULL,
524 p_bom_revision_date IN DATE DEFAULT NULL,
525 p_routing_revision_date IN DATE DEFAULT NULL,
526 p_alternate_bom_designator IN VARCHAR2 DEFAULT NULL,
527 p_alternate_routing_designator IN VARCHAR2 DEFAULT NULL,
528 p_accounting_class IN VARCHAR2 DEFAULT NULL,
529 p_demand_class IN VARCHAR2 DEFAULT NULL,
530 p_parent_id IN NUMBER DEFAULT NULL,
531 p_substitution_type_id IN NUMBER DEFAULT NULL,
532 p_substitution_item_id IN NUMBER DEFAULT NULL,
533 p_schedule_group IN NUMBER DEFAULT NULL,
534 p_build_sequence IN NUMBER DEFAULT NULL,
535 p_schedule_number IN VARCHAR2 DEFAULT NULL,
536 p_scheduled_flag IN NUMBER DEFAULT NULL,
537 p_flow_schedule IN VARCHAR2 DEFAULT NULL,
538 p_cost_group_id IN NUMBER DEFAULT NULL,
539 -- HW OPMCONV. Added p_secondary_trx_quantity
540 -- and p_secondary_uom_code
541 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
542 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
543 );
544
545 PROCEDURE Delete_Row (
546 x_rowid IN OUT NOCOPY VARCHAR2 );
547
548 PROCEDURE Lock_Row (
549 x_rowid IN OUT NOCOPY VARCHAR2,
550 p_trx_interface_id IN NUMBER,
551 p_trx_header_id IN NUMBER,
552 p_source_code IN VARCHAR2,
553 p_source_line_id IN NUMBER,
554 p_source_header_id IN NUMBER,
555 p_process_flag IN NUMBER,
556 p_validation_required IN NUMBER,
557 p_transaction_mode IN NUMBER,
558 p_lock_flag IN NUMBER,
559 p_inventory_item_id IN NUMBER,
560 p_item_segment1 IN VARCHAR2,
561 p_item_segment2 IN VARCHAR2,
562 p_item_segment3 IN VARCHAR2,
563 p_item_segment4 IN VARCHAR2,
564 p_item_segment5 IN VARCHAR2,
565 p_item_segment6 IN VARCHAR2,
566 p_item_segment7 IN VARCHAR2,
567 p_item_segment8 IN VARCHAR2,
568 p_item_segment9 IN VARCHAR2,
569 p_item_segment10 IN VARCHAR2,
570 p_item_segment11 IN VARCHAR2,
571 p_item_segment12 IN VARCHAR2,
572 p_item_segment13 IN VARCHAR2,
573 p_item_segment14 IN VARCHAR2,
574 p_item_segment15 IN VARCHAR2,
575 p_item_segment16 IN VARCHAR2,
576 p_item_segment17 IN VARCHAR2,
577 p_item_segment18 IN VARCHAR2,
578 p_item_segment19 IN VARCHAR2,
579 p_item_segment20 IN VARCHAR2,
580 p_revision IN VARCHAR2,
581 p_organization_id IN NUMBER,
582 p_transaction_quantity IN NUMBER,
583 p_primary_quantity IN NUMBER,
584 p_trx_uom IN VARCHAR2,
585 p_trx_date IN DATE,
586 p_acct_period_id IN NUMBER,
587 p_subinventory_code IN VARCHAR2,
588 p_locator_id IN NUMBER,
589 p_loc_segment1 IN VARCHAR2,
590 p_loc_segment2 IN VARCHAR2,
591 p_loc_segment3 IN VARCHAR2,
592 p_loc_segment4 IN VARCHAR2,
593 p_loc_segment5 IN VARCHAR2,
594 p_loc_segment6 IN VARCHAR2,
595 p_loc_segment7 IN VARCHAR2,
596 p_loc_segment8 IN VARCHAR2,
597 p_loc_segment9 IN VARCHAR2,
598 p_loc_segment10 IN VARCHAR2,
599 p_loc_segment11 IN VARCHAR2,
600 p_loc_segment12 IN VARCHAR2,
601 p_loc_segment13 IN VARCHAR2,
602 p_loc_segment14 IN VARCHAR2,
603 p_loc_segment15 IN VARCHAR2,
604 p_loc_segment16 IN VARCHAR2,
605 p_loc_segment17 IN VARCHAR2,
606 p_loc_segment18 IN VARCHAR2,
607 p_loc_segment19 IN VARCHAR2,
608 p_loc_segment20 IN VARCHAR2,
609 p_trx_source_id IN NUMBER,
610 p_dsp_segment1 IN VARCHAR2,
611 p_dsp_segment2 IN VARCHAR2,
612 p_dsp_segment3 IN VARCHAR2,
613 p_dsp_segment4 IN VARCHAR2,
614 p_dsp_segment5 IN VARCHAR2,
615 p_dsp_segment6 IN VARCHAR2,
616 p_dsp_segment7 IN VARCHAR2,
617 p_dsp_segment8 IN VARCHAR2,
618 p_dsp_segment9 IN VARCHAR2,
619 p_dsp_segment10 IN VARCHAR2,
620 p_dsp_segment11 IN VARCHAR2,
621 p_dsp_segment12 IN VARCHAR2,
622 p_dsp_segment13 IN VARCHAR2,
623 p_dsp_segment14 IN VARCHAR2,
624 p_dsp_segment15 IN VARCHAR2,
625 p_dsp_segment16 IN VARCHAR2,
626 p_dsp_segment17 IN VARCHAR2,
627 p_dsp_segment18 IN VARCHAR2,
628 p_dsp_segment19 IN VARCHAR2,
629 p_dsp_segment20 IN VARCHAR2,
630 p_dsp_segment21 IN VARCHAR2,
631 p_dsp_segment22 IN VARCHAR2,
632 p_dsp_segment23 IN VARCHAR2,
633 p_dsp_segment24 IN VARCHAR2,
634 p_dsp_segment25 IN VARCHAR2,
635 p_dsp_segment26 IN VARCHAR2,
636 p_dsp_segment27 IN VARCHAR2,
637 p_dsp_segment28 IN VARCHAR2,
638 p_dsp_segment29 IN VARCHAR2,
639 p_dsp_segment30 IN VARCHAR2,
640 p_trx_source_name IN VARCHAR2,
641 p_trx_source_type_id IN NUMBER,
642 p_trx_action_id IN NUMBER,
643 p_trx_type_id IN NUMBER,
644 p_reason_id IN NUMBER,
645 p_trx_reference IN VARCHAR2,
646 p_trx_cost IN NUMBER,
647 p_distribution_acct_id IN NUMBER,
648 p_dst_segment1 IN VARCHAR2,
649 p_dst_segment2 IN VARCHAR2,
650 p_dst_segment3 IN VARCHAR2,
651 p_dst_segment4 IN VARCHAR2,
652 p_dst_segment5 IN VARCHAR2,
653 p_dst_segment6 IN VARCHAR2,
654 p_dst_segment7 IN VARCHAR2,
655 p_dst_segment8 IN VARCHAR2,
656 p_dst_segment9 IN VARCHAR2,
657 p_dst_segment10 IN VARCHAR2,
658 p_dst_segment11 IN VARCHAR2,
659 p_dst_segment12 IN VARCHAR2,
660 p_dst_segment13 IN VARCHAR2,
661 p_dst_segment14 IN VARCHAR2,
662 p_dst_segment15 IN VARCHAR2,
663 p_dst_segment16 IN VARCHAR2,
664 p_dst_segment17 IN VARCHAR2,
665 p_dst_segment18 IN VARCHAR2,
666 p_dst_segment19 IN VARCHAR2,
667 p_dst_segment20 IN VARCHAR2,
668 p_dst_segment21 IN VARCHAR2,
669 p_dst_segment22 IN VARCHAR2,
670 p_dst_segment23 IN VARCHAR2,
671 p_dst_segment24 IN VARCHAR2,
672 p_dst_segment25 IN VARCHAR2,
673 p_dst_segment26 IN VARCHAR2,
674 p_dst_segment27 IN VARCHAR2,
675 p_dst_segment28 IN VARCHAR2,
676 p_dst_segment29 IN VARCHAR2,
677 p_dst_segment30 IN VARCHAR2,
678 p_requisition_line_id IN NUMBER,
679 p_currency_code IN VARCHAR2,
680 p_currency_conversion_date IN DATE,
681 p_currency_conversion_type IN VARCHAR2,
682 p_currency_conversion_rate IN NUMBER,
683 p_ussgl_transaction_code IN VARCHAR2,
684 p_wip_entity_type IN NUMBER,
685 p_schedule_id IN NUMBER,
686 p_employee_code IN VARCHAR2,
687 p_department_id IN NUMBER,
688 p_schedule_update_code IN NUMBER,
689 p_setup_teardown_code IN NUMBER,
690 p_primary_switch IN NUMBER,
691 p_mrp_code IN NUMBER,
692 p_operation_seq_num IN NUMBER,
693 p_repetitive_line_id IN NUMBER,
694 p_picking_line_id IN NUMBER,
695 p_trx_source_line_id IN NUMBER,
696 p_trx_source_delivery_id IN NUMBER,
697 p_demand_id IN NUMBER,
698 p_customer_ship_id IN NUMBER,
699 p_line_item_num IN NUMBER,
700 p_receiving_document IN VARCHAR2,
701 p_rcv_transaction_id IN NUMBER,
702 p_ship_to_location_id IN NUMBER,
703 p_encumbrance_account IN NUMBER,
704 p_encumbrance_amount IN NUMBER,
705 p_vendor_lot_number IN VARCHAR2,
706 p_transfer_subinventory IN VARCHAR2,
707 p_transfer_organization IN NUMBER,
708 p_transfer_locator IN NUMBER,
709 p_xfer_loc_segment1 IN VARCHAR2,
710 p_xfer_loc_segment2 IN VARCHAR2,
711 p_xfer_loc_segment3 IN VARCHAR2,
712 p_xfer_loc_segment4 IN VARCHAR2,
713 p_xfer_loc_segment5 IN VARCHAR2,
714 p_xfer_loc_segment6 IN VARCHAR2,
715 p_xfer_loc_segment7 IN VARCHAR2,
716 p_xfer_loc_segment8 IN VARCHAR2,
717 p_xfer_loc_segment9 IN VARCHAR2,
718 p_xfer_loc_segment10 IN VARCHAR2,
719 p_xfer_loc_segment11 IN VARCHAR2,
720 p_xfer_loc_segment12 IN VARCHAR2,
721 p_xfer_loc_segment13 IN VARCHAR2,
722 p_xfer_loc_segment14 IN VARCHAR2,
723 p_xfer_loc_segment15 IN VARCHAR2,
724 p_xfer_loc_segment16 IN VARCHAR2,
725 p_xfer_loc_segment17 IN VARCHAR2,
726 p_xfer_loc_segment18 IN VARCHAR2,
727 p_xfer_loc_segment19 IN VARCHAR2,
728 p_xfer_loc_segment20 IN VARCHAR2,
729 p_shipment_number IN VARCHAR2,
730 p_transportation_cost IN NUMBER,
731 p_transportation_account IN NUMBER,
732 p_transfer_cost IN NUMBER,
733 p_freight_code IN VARCHAR2,
734 p_containers IN NUMBER,
735 p_waybill_airbill IN VARCHAR2,
736 p_expected_arrival_date IN DATE,
737 p_new_average_cost IN NUMBER,
738 p_value_change IN NUMBER,
739 p_percentage_change IN NUMBER,
740 p_demand_source_header_id IN NUMBER,
741 p_demand_source_line IN VARCHAR2,
742 p_demand_source_delivery IN VARCHAR2,
743 p_negative_req_flag IN NUMBER,
744 p_error_explanation IN VARCHAR2,
745 p_shippable_flag IN VARCHAR2,
746 p_error_code IN VARCHAR2,
747 p_required_flag IN VARCHAR2,
748 p_attribute_category IN VARCHAR2,
749 p_attribute1 IN VARCHAR2,
750 p_attribute2 IN VARCHAR2,
751 p_attribute3 IN VARCHAR2,
752 p_attribute4 IN VARCHAR2,
753 p_attribute5 IN VARCHAR2,
754 p_attribute6 IN VARCHAR2,
755 p_attribute7 IN VARCHAR2,
756 p_attribute8 IN VARCHAR2,
757 p_attribute9 IN VARCHAR2,
758 p_attribute10 IN VARCHAR2,
759 p_attribute11 IN VARCHAR2,
760 p_attribute12 IN VARCHAR2,
761 p_attribute13 IN VARCHAR2,
762 p_attribute14 IN VARCHAR2,
763 p_attribute15 IN VARCHAR2,
764 p_requisition_distribution_id IN NUMBER,
765 p_movement_id IN NUMBER,
766 p_reservation_quantity IN NUMBER,
767 p_shipped_quantity IN NUMBER,
768 p_inventory_item IN VARCHAR2,
769 p_locator_name IN VARCHAR2,
770 p_task_id IN NUMBER,
771 p_to_task_id IN NUMBER,
772 p_source_task_id IN NUMBER,
773 p_project_id IN NUMBER,
774 p_to_project_id IN NUMBER,
775 p_source_project_id IN NUMBER,
776 p_pa_expenditure_org_id IN NUMBER,
777 p_expenditure_type IN VARCHAR2,
778 p_final_completion_flag IN VARCHAR2,
779 p_transfer_percentage IN NUMBER,
780 p_trx_sequence_id IN NUMBER,
781 p_material_account IN NUMBER,
782 p_material_overhead_account IN NUMBER,
783 p_resource_account IN NUMBER,
784 p_outside_processing_account IN NUMBER,
785 p_overhead_account IN NUMBER,
786 p_bom_revision IN VARCHAR2,
787 p_routing_revision IN VARCHAR2,
788 p_bom_revision_date IN DATE,
789 p_routing_revision_date IN DATE,
790 p_alternate_bom_designator IN VARCHAR2,
791 p_alternate_routing_designator IN VARCHAR2,
792 p_accounting_class IN VARCHAR2,
793 p_demand_class IN VARCHAR2,
794 p_parent_id IN NUMBER,
795 p_substitution_type_id IN NUMBER,
796 p_substitution_item_id IN NUMBER,
797 p_schedule_group IN NUMBER,
798 p_build_sequence IN NUMBER,
799 p_schedule_number IN VARCHAR2,
800 p_scheduled_flag IN NUMBER,
801 p_flow_schedule IN VARCHAR2,
802 p_cost_group_id IN NUMBER,
803 -- HW OPMCONV. Added p_secondary_trx_quantity
804 -- and p_secondary_uom_code
805 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
806 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
807 -- p_qa_collection_id IN NUMBER,
808 -- p_kanban_card_id IN NUMBER,
809 -- p_end_item_unit_number IN VARCHAR2,
810 -- p_overcompletion_transaction_qty IN NUMBER,
811 -- p_overcompletion_primary_qty IN NUMBER,
812 -- p_overcompletion_transaction_id IN NUMBER,
813 -- p_scheduled_payback_date IN DATE
814 );
815
816
817 --HVOP heali
818 PROCEDURE INSERT_ROW_BULK (
819 p_start_index IN NUMBER,
820 p_end_index IN NUMBER,
821 p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.mtl_txn_if_rec_type,
822 x_return_status OUT NOCOPY VARCHAR2);
823 --HVOP heali
824
825 END WSH_TRX_HANDLER;