1 PACKAGE gme_transactions_pvt AS
2 /* $Header: GMEVPTXS.pls 120.13.12010000.1 2008/07/25 10:31:27 appldev ship $ */
3 /* Bug 5903208 Added PL/SQL table to store values */
4 TYPE p_qty_rec IS RECORD (doc_qty NUMBER);
5 TYPE p_qty_tab IS TABLE OF p_qty_rec INDEX BY VARCHAR2(100);
6 p_qty_tbl p_qty_tab;
7
8 /* +==========================================================================+
9 | PROCEDURE NAME
10 | create_material_txn
11 |
12 | USAGE
13 | Inserts the transaction to interface table and moves to temp when
14 | called from forms.
15 |
16 | ARGUMENTS
17 | p_mmti_rec -- mtl_transaction_interface rowtype
18 | p_mmli_tbl -- table of mtl_transaction_lots_inumber_tbl as input
19 |
20 | RETURNS
21 | returns via x_status OUT parameters
22 |
23 | HISTORY
24 | Created 02-Feb-05 Pawan Kumar
25 |
26 +==========================================================================+ */
27 PROCEDURE create_material_txn (
28 p_mmti_rec IN mtl_transactions_interface%ROWTYPE
29 ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
30 ,p_phantom_trans IN NUMBER DEFAULT 0
31 ,x_return_status OUT NOCOPY VARCHAR2);
32
33 /* +==========================================================================+
34 | PROCEDURE NAME
35 | update_material_txn
36 |
37 | USAGE
38 | update the transaction in interface table - it deletes all transactions
39 | of transaction_id passed. Creates new transactions as passed.
40 |
41 | ARGUMENTS
42 | p_transaction_id - transaction_id from mmt for deletion
43 | p_mmti_rec -- mtl_transaction_interface rowtype
44 | p_mmli_tbl -- table of mtl_transaction_lots_inumber_tbl as input
45 |
46 | RETURNS
47 | returns via x_status OUT parameters
48 |
49 | HISTORY
50 | Created 02-Feb-05 Pawan Kumar
51 |
52 +==========================================================================+ */
53 PROCEDURE update_material_txn (
54 p_transaction_id IN NUMBER
55 ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE
56 ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
57 ,x_return_status OUT NOCOPY VARCHAR2);
58
59 /* +==========================================================================+
60 | PROCEDURE NAME
61 | update_material_txn
62 |
63 | USAGE
64 | update the transaction in interface table - it deletes all transactions
65 | by getting transaction_id from the mmt record passed. Creates new transactions
66 | in interface by converting the mmt to mmti.
67 |
68 | ARGUMENTS
69 | p_mmt_rec -- mtl_material_transaction rowtype
70 | p_mmln_tbl -- table of mtl_transaction_lots_inumber_tbl as input
71 |
72 | RETURNS
73 | returns via x_status OUT parameters
74 |
75 | HISTORY
76 | Created 02-Feb-05 Pawan Kumar
77 |
78 +==========================================================================+ */
79 PROCEDURE update_material_txn (
80 p_mmt_rec IN mtl_material_transactions%ROWTYPE
81 ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
82 ,x_return_status OUT NOCOPY VARCHAR2);
83
84 /* +==========================================================================+
85 | PROCEDURE NAME
86 | delete_material_txn
87 |
88 | USAGE
89 | delete all transactions of transaction_id passed by creating reverse transaction.
90 |
91 | ARGUMENTS
92 | p_transaction_id -- transaction_id from mmt for deletion
93 |
94 |
95 | RETURNS
96 | returns via x_status OUT parameters
97 |
98 | HISTORY
99 | Created 02-Feb-05 Pawan Kumar
100 |
101 +==========================================================================+ */
102 PROCEDURE delete_material_txn (
103 p_transaction_id IN NUMBER
104 ,p_txns_pair IN NUMBER DEFAULT NULL
105 ,x_return_status OUT NOCOPY VARCHAR2);
106
107 /* +==========================================================================+
108 | PROCEDURE NAME
109 | build_txn_inter
110 |
111 | USAGE
112 | Inserts the transaction to interface table
113 |
114 | ARGUMENTS
115 | p_mmti_rec -- mtl_transaction_interface rowtype
116 | p_mmli_tbl -- table of mtl_trans_lots_inter_tbl as input
117 |
118 | RETURNS
119 | returns via x_status OUT parameters
120 |
121 | HISTORY
122 | Created 02-Feb-05 Pawan Kumar
123 |
124 +==========================================================================+ */
125 PROCEDURE build_txn_inter (
126 p_mmti_rec IN mtl_transactions_interface%ROWTYPE
127 ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
128 ,p_assign_phantom IN NUMBER DEFAULT 0
129 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
130 ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
131 ,x_return_status OUT NOCOPY VARCHAR2);
132
133 /* +==========================================================================+
134 | PROCEDURE NAME
135 | build_txn_inter
136 |
137 | USAGE
138 | Inserts the transaction to interface table
139 |
140 | ARGUMENTS
141 | p_mmti_rec -- mtl_transaction_interface rowtype
142 |
143 |
144 | RETURNS
145 | returns via x_status OUT parameters
146 |
147 | HISTORY
148 | Created 02-Feb-05 Pawan Kumar
149 |
150 +==========================================================================+ */
151 /* Bug 4929610 Added new parameter */
152 PROCEDURE build_txn_inter_hdr (
153 p_mmti_rec IN mtl_transactions_interface%ROWTYPE
154 ,p_assign_phantom IN NUMBER DEFAULT 0
155 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
156 ,x_return_status OUT NOCOPY VARCHAR2
157 ,p_insert_hdr IN BOOLEAN DEFAULT TRUE);
158
159 /* +==========================================================================+
160 | PROCEDURE NAME
161 | build_txn_inter_hdr
162 |
163 | USAGE
164 | Inserts the transaction to interface table
165 |
166 | ARGUMENTS
167 | p_mmli_rec -- record of mtl_transaction_lots_interface as input
168 |
169 | RETURNS
170 | returns via x_status OUT parameters
171 |
172 | HISTORY
173 | Created 02-Feb-05 Pawan Kumar
174 | Bug 6925025 11-Apr-2008 Archana Mundhe
175 | Added parameters subinventory_code and locator_id.
176 +==========================================================================+ */
177 PROCEDURE build_txn_inter_lot (
178 p_trans_inter_id IN NUMBER
179 ,p_transaction_type_id IN NUMBER
180 ,p_inventory_item_id IN NUMBER
181 ,p_subinventory_code IN VARCHAR2
182 ,p_locator_id IN NUMBER
183 ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE
184 ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE
185 ,x_return_status OUT NOCOPY VARCHAR2);
186
187 /* +==========================================================================+
188 | PROCEDURE NAME
189 | get_transactions
190 |
191 | USAGE
192 | Gets all transactions from mmt based on transaction_id passed.
193 |
194 | ARGUMENTS
195 | p_transaction_id -- transaction_id from mmt for fetch
196 |
197 | RETURNS
198 |
199 | returns via x_status OUT parameters
200 | x_mmt_rec -- mtl_transaction_interface rowtype
201 | x_mmln_tbl -- table of mtl_trans_lots_number_tbl
202 | HISTORY
203 | Created 02-Feb-05 Pawan Kumar
204 |
205 +==========================================================================+ */
206 PROCEDURE get_transactions (
207 p_transaction_id IN NUMBER
208 ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
209 ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
210 ,x_return_status OUT NOCOPY VARCHAR2);
211
212 /* +==========================================================================+
213 | PROCEDURE NAME
214 | construct_mmti
215 |
216 | USAGE
217 | Construct interface table record based on mmt passed to it.
218 |
219 | ARGUMENTS
220 | p_mmt_rec -- mtl_material_transaction rowtype
221 | p_mmln_tbl -- table of mtl_trans_lots_num_tbl as input
222 |
223 | RETURNS
224 | returns via x_status OUT parameters
225 | x_mmti_rec mtl_transactions_interface rowtype
226 | x_mmli_tbl table of mtl_trans_lots_inter_tbl
227 | HISTORY
228 | Created 02-Feb-05 Pawan Kumar
229 |
230 +==========================================================================+ */
231 PROCEDURE construct_mmti (
232 p_mmt_rec IN mtl_material_transactions%ROWTYPE
233 ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
234 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
235 ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
236 ,x_return_status OUT NOCOPY VARCHAR2);
237
238 /* +==========================================================================+
239 | PROCEDURE NAME
240 | get_mat_trans
241 |
242 | USAGE
243 | Gets all transactions from mmt based on material_detail_id and batch_id passed.
244 |
245 | ARGUMENTS
246 | p_mat_det_id -- material_detail_id passed of material
247 | p_batch_id -- batch_id to which the material belongs.
248 |
249 | RETURNS
250 | returns via x_status OUT parameters
251 | x_mmt_tbl- gives back all transactions of the material
252 | HISTORY
253 | Created 02-Feb-05 Pawan Kumar
254 |
255 +==========================================================================+ */
256 PROCEDURE get_mat_trans (
257 p_mat_det_id IN NUMBER
258 ,p_batch_id IN NUMBER
259 ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl
260 ,x_return_status OUT NOCOPY VARCHAR2);
261
262 /* +==========================================================================+
263 | PROCEDURE NAME
264 | get_lot_trans
265 |
266 | USAGE
267 | Gets all lot transactions from mmln for a given transaction_id.
268 |
269 | ARGUMENTS
270 | p_transaction_id -- transaction_id for which all lot info is required.
271 |
272 | RETURNS
273 | returns via x_status OUT parameters
274 | x_mmln_tbl- all lot info for a given transaction_id.
275 | HISTORY
276 | Created 02-Feb-05 Pawan Kumar
277 |
278 +==========================================================================+ */
279 PROCEDURE get_lot_trans (
280 p_transaction_id IN NUMBER
281 ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
282 ,x_return_status OUT NOCOPY VARCHAR2);
283
284 /* +==========================================================================+
285 | PROCEDURE NAME
286 | GME_PRE_PROCESS
287 |
288 | USAGE
289 | Gets all pre-process validations based on header_id
290 |
291 | ARGUMENTS
292 | p_transaction_hdr_id
293 |
294 |
295 | RETURNS
296 | returns via x_status OUT parameters
297 |
298 | HISTORY
299 | Created 02-Feb-05 Pawan Kumar
300 |
301 +==========================================================================+ */
302 PROCEDURE gme_pre_process (
303 p_transaction_hdr_id IN NUMBER
304 ,x_return_status OUT NOCOPY VARCHAR2);
305
306 /* +==========================================================================+
307 | PROCEDURE NAME
308 | get_returnable_qty
309 |
310 | USAGE
311 | Gets net quantity that can be returned from mmt based on the details passed
312 |
313 | ARGUMENTS
314 | p_mmti_rec -- mtl_transaction_interface rowtype
315 | p_lot_number - Lot number
316 | p_lot_control - 1 for plain 2 for lot control
317 | RETURNS
318 | x_return_status S for success, U for unexpected
319 | x_available_qty Quantity that can be returned.
320 | HISTORY
321 | Created 20-Sep-05 Shrikant Nene
322 |
323 +==========================================================================+ */
324 PROCEDURE get_returnable_qty (
325 p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
326 p_lot_number IN VARCHAR2,
327 p_lot_control IN NUMBER,
328 x_available_qty OUT NOCOPY NUMBER,
329 x_return_status OUT NOCOPY VARCHAR2);
330
331 /* +==========================================================================+
332 | PROCEDURE NAME
333 | PRE_PROCESS_VAL
334 |
335 | USAGE
336 | validations for individual transactions
337 |
338 | ARGUMENTS
339 | p_mmti_rec -- mtl_transaction_interface rowtype
340 |
341 |
342 | RETURNS
343 | returns via x_status OUT parameters
344 |
345 | HISTORY
346 | Created 02-Feb-05 Pawan Kumar
347 |
348 +==========================================================================+ */
349 PROCEDURE pre_process_val (
350 p_transaction_interface_id IN NUMBER
351 ,x_return_status OUT NOCOPY VARCHAR2);
352
353 /* +==========================================================================+
354 | PROCEDURE NAME
355 | gme_txn_message
356 |
357 | USAGE
358 | validations for individual transactions
359 |
360 | ARGUMENTS
361 | p_mmti_rec -- mtl_transaction_interface rowtype
362 |
363 |
364 | RETURNS
365 | returns via x_status OUT parameters
366 |
367 | HISTORY
368 | Created 02-Feb-05 Pawan Kumar
369 |
370 +==========================================================================+ */
371 PROCEDURE gme_txn_message (
372 p_api_name IN VARCHAR2
373 ,p_transaction_interface_id IN VARCHAR2);
374
375 /* +==========================================================================+
376 | PROCEDURE NAME
377 | gme_post_process
378 |
379 | USAGE
380 |
381 |
382 | ARGUMENTS
383 | p_transaction_id
384 |
385 |
386 | RETURNS
387 | returns via x_status OUT parameters
388 |
389 | HISTORY
390 | Created 02-Feb-05 Pawan Kumar
391 |
392 +==========================================================================+ */
393 PROCEDURE gme_post_process (
394 p_transaction_id IN NUMBER
395 ,x_return_status OUT NOCOPY VARCHAR2);
396
397 /* +==========================================================================+
398 | PROCEDURE NAME
399 | purge_trans_pairs
400 |
401 | USAGE
402 |
403 |
404 | ARGUMENTS
405 | p_batch_id
406 | p_material_detail_id
407 |
408 | RETURNS
409 | returns via x_status OUT parameters
410 |
411 | HISTORY
412 | Created 02-Feb-05 Pawan Kumar
413 |
414 +==========================================================================+ */
415 PROCEDURE purge_trans_pairs (
416 p_batch_id IN NUMBER
417 ,p_material_detail_id IN NUMBER DEFAULT NULL
418 ,x_return_status OUT NOCOPY VARCHAR2);
419
420 /* +==========================================================================+
421 | PROCEDURE NAME
422 | Process_transactions
423 |
424 | USAGE
425 | This is the interface procedure to the Inventory Transaction
426 | Manager to validate and process a batch of material transaction
427 | interface records
428 |
429 | ARGUMENTS
430 | p_api_version API Version of this procedure. Current version is 1.0
431 | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
432 | p_commit Indicates whether to commit the changes after successful processing
433 | p_validation_level Indicates whether or not to perform a full validation
434 | x_return_status Returns the status to indicate success or failure of execution
435 | x_msg_count Returns number of error message in the error message stack in case of failure
436 | x_msg_data Returns the error message in case of failure
437 | x_trans_count The count of material transaction interface records processed.
438 | p_table Source of transaction records with value 1 of material transaction interface table and value 2 of material transaction temp table
439 | p_header_id Transaction header id (If not passed in then call gme_common_pvt.get_txn_header_id to populate
440 |
441 | RETURNS
442 | returns via x_ OUT parameters
443 |
444 | HISTORY
445 | Created 07-Mar-05 Jalaj Srivastava
446 |
447 +==========================================================================+ */
448 /* Bug 5255959 added p_clear_qty_cache parameter */
449 PROCEDURE process_transactions (
450 p_api_version IN NUMBER := 1
451 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452 ,p_commit IN VARCHAR2 := fnd_api.g_false
453 ,p_validation_level IN NUMBER
454 := fnd_api.g_valid_level_full
455 ,p_table IN NUMBER := 2
456 ,p_header_id IN NUMBER
457 := gme_common_pvt.get_txn_header_id
458 ,x_return_status OUT NOCOPY VARCHAR2
459 ,x_msg_count OUT NOCOPY NUMBER
460 ,x_msg_data OUT NOCOPY VARCHAR2
461 ,x_trans_count OUT NOCOPY NUMBER
462 --Bug#5584699 Changed the datatype from boolean to varchar2.
463 ,p_clear_qty_cache IN VARCHAR2 := fnd_api.g_true);
464 --,p_clear_qty_cache IN BOOLEAN DEFAULT TRUE);
465
466 /* +==========================================================================+
467 | PROCEDURE NAME
468 | query_quantities
469 |
470 | USAGE
471 | Query quantities at a level specified by the input
472 |
473 | ARGUMENTS
474 | p_api_version API Version of this procedure. Current version is 1.0
475 | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
476 | x_return_status Returns the status to indicate success or failure of execution
477 | x_msg_count Returns number of error message in the error message stack in case of failure
478 | x_msg_data Returns the error message in case of failure
479 |
480 | RETURNS
481 | returns via x_ OUT parameters
482 |
483 | HISTORY
484 | Created 07-Mar-05 Jalaj Srivastava
485 |
486 +==========================================================================+ */
487 PROCEDURE query_quantities (
488 p_api_version_number IN NUMBER := 1
489 ,p_init_msg_lst IN VARCHAR2
490 DEFAULT fnd_api.g_false
491 ,x_return_status OUT NOCOPY VARCHAR2
492 ,x_msg_count OUT NOCOPY NUMBER
493 ,x_msg_data OUT NOCOPY VARCHAR2
494 ,p_organization_id IN NUMBER
495 ,p_inventory_item_id IN NUMBER
496 ,p_tree_mode IN INTEGER
497 ,p_is_serial_control IN BOOLEAN DEFAULT FALSE
498 ,p_grade_code IN VARCHAR2
499 ,p_demand_source_type_id IN NUMBER
500 DEFAULT gme_common_pvt.g_txn_source_type
501 ,p_demand_source_header_id IN NUMBER DEFAULT -9999
502 ,p_demand_source_line_id IN NUMBER DEFAULT -9999
503 ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
504 ,p_lot_expiration_date IN DATE DEFAULT NULL
505 ,p_revision IN VARCHAR2
506 ,p_lot_number IN VARCHAR2
507 ,p_subinventory_code IN VARCHAR2
508 ,p_locator_id IN NUMBER
509 ,p_onhand_source IN NUMBER
510 DEFAULT inv_quantity_tree_pvt.g_all_subs
511 ,x_qoh OUT NOCOPY NUMBER
512 ,x_rqoh OUT NOCOPY NUMBER
513 ,x_qr OUT NOCOPY NUMBER
514 ,x_qs OUT NOCOPY NUMBER
515 ,x_att OUT NOCOPY NUMBER
516 ,x_atr OUT NOCOPY NUMBER
517 ,x_sqoh OUT NOCOPY NUMBER
518 ,x_srqoh OUT NOCOPY NUMBER
519 ,x_sqr OUT NOCOPY NUMBER
520 ,x_sqs OUT NOCOPY NUMBER
521 ,x_satt OUT NOCOPY NUMBER
522 ,x_satr OUT NOCOPY NUMBER
523 ,p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
524 ,p_cost_group_id IN NUMBER DEFAULT NULL
525 ,p_lpn_id IN NUMBER DEFAULT NULL
526 ,p_transfer_locator_id IN NUMBER DEFAULT NULL);
527
528 /* +==========================================================================+
529 | PROCEDURE NAME
530 | update_quantities
531 |
532 | USAGE
533 | Update quantity at the level specified by the input and
534 | return the quantities at the level after the update
535 |
536 | ARGUMENTS
537 | p_api_version API Version of this procedure. Current version is 1.0
538 | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
539 | x_return_status Returns the status to indicate success or failure of execution
540 | x_msg_count Returns number of error message in the error message stack in case of failure
541 | x_msg_data Returns the error message in case of failure
542 |
543 | RETURNS
544 | returns via x_ OUT parameters
545 |
546 | HISTORY
547 | Created 07-Mar-05 Jalaj Srivastava
548 |
549 +==========================================================================+ */
550 PROCEDURE update_quantities (
551 p_api_version_number IN NUMBER := 1
552 ,p_init_msg_lst IN VARCHAR2
553 DEFAULT fnd_api.g_false
554 ,x_return_status OUT NOCOPY VARCHAR2
555 ,x_msg_count OUT NOCOPY NUMBER
556 ,x_msg_data OUT NOCOPY VARCHAR2
557 ,p_organization_id IN NUMBER
558 ,p_inventory_item_id IN NUMBER
559 ,p_tree_mode IN INTEGER
560 ,p_is_serial_control IN BOOLEAN := FALSE
561 ,p_demand_source_type_id IN NUMBER
562 DEFAULT gme_common_pvt.g_txn_source_type
563 ,p_demand_source_header_id IN NUMBER DEFAULT -9999
564 ,p_demand_source_line_id IN NUMBER DEFAULT -9999
565 ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
566 ,p_lot_expiration_date IN DATE DEFAULT NULL
567 ,p_revision IN VARCHAR2 DEFAULT NULL
568 ,p_lot_number IN VARCHAR2 DEFAULT NULL
569 ,p_subinventory_code IN VARCHAR2 DEFAULT NULL
570 ,p_locator_id IN NUMBER DEFAULT NULL
571 ,p_grade_code IN VARCHAR2 DEFAULT NULL
572 ,p_primary_quantity IN NUMBER
573 ,p_quantity_type IN INTEGER
574 ,p_secondary_quantity IN NUMBER
575 ,p_onhand_source IN NUMBER
576 DEFAULT inv_quantity_tree_pvt.g_all_subs
577 ,x_qoh OUT NOCOPY NUMBER
578 ,x_rqoh OUT NOCOPY NUMBER
579 ,x_qr OUT NOCOPY NUMBER
580 ,x_qs OUT NOCOPY NUMBER
581 ,x_att OUT NOCOPY NUMBER
582 ,x_atr OUT NOCOPY NUMBER
583 ,x_sqoh OUT NOCOPY NUMBER
584 ,x_srqoh OUT NOCOPY NUMBER
585 ,x_sqr OUT NOCOPY NUMBER
586 ,x_sqs OUT NOCOPY NUMBER
587 ,x_satt OUT NOCOPY NUMBER
588 ,x_satr OUT NOCOPY NUMBER
589 ,p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
590 ,p_cost_group_id IN NUMBER DEFAULT NULL
591 ,p_containerized IN NUMBER
592 DEFAULT inv_quantity_tree_pvt.g_containerized_false
593 ,p_lpn_id IN NUMBER DEFAULT NULL
594 ,p_transfer_locator_id IN NUMBER DEFAULT NULL);
595
596 /* Bug 4929610 Added function */
597 FUNCTION is_lot_expired (p_organization_id IN NUMBER,
598 p_inventory_item_id IN NUMBER,
599 p_lot_number IN VARCHAR2,
600 p_date IN DATE) RETURN BOOLEAN;
601 PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
602 x_return_status OUT NOCOPY VARCHAR2);
603 -- nsinghi Bug5176319. Added the proc.
604 /* +==========================================================================+
605 | PROCEDURE NAME
606 | get_mmt_transactions
607 |
608 | USAGE
609 | Gets all transactions from mmt based on transaction_id passed. Unlike get_transactions,
610 | this procedure does not check for enteries in gme_transaction_pairs
611 |
612 | ARGUMENTS
613 | p_transaction_id -- transaction_id from mmt for fetch
614 |
615 | RETURNS
616 |
617 | returns via x_status OUT parameters
618 | x_mmt_rec -- mtl_material_transactions rowtype
619 | x_mmln_tbl -- table of mtl_trans_lots_number_tbl
620 | HISTORY
621 | Created 19-Jun-06 Namit S. Created
622 |
623 +==========================================================================+ */
624
625 PROCEDURE get_mmt_transactions (
626 p_transaction_id IN NUMBER
627 ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
628 ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
629 ,x_return_status OUT NOCOPY VARCHAR2);
630
631 /* Bug 5358129 Added procedure */
632 PROCEDURE validate_lot_for_ing(p_organization_id IN NUMBER,
633 p_inventory_item_id IN NUMBER,
634 p_lot_number IN VARCHAR2,
635 x_return_status OUT NOCOPY VARCHAR2);
636 /* Added for bug 5597385 */
637 PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
638 p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
639 p_mode IN VARCHAR2,
640 x_return_status OUT NOCOPY VARCHAR2);
641 END gme_transactions_pvt;