APPS.JMF_SHIKYU_INV_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 25: --| mtl_transactions_interface with |

21: --| 10/24/2005 vmutyala Bug:-4670527, Made some changes |
22: --| to Process_Transaction procedure |
23: --| 01/26/2006 vchu Bug 4964675. Populate |
24: --| transaction_source_id column of |
25: --| mtl_transactions_interface with |
26: --| wip_entity_id for WIP Component Issue |
27: --| and Return. |
28: --| 03/07/2006 vchu Fixed the WIP Component Issue |
29: --| transactions by multiplying the |

Line 56: --| mtl_transactions_interface table, if |

52: --| 06/16/2006 vchu Fixed Bug 5337725: Modified the |
53: --| Process_Transaction procedure to get |
54: --| the locator used to supply component to |
55: --| WIP, and then pass it to the |
56: --| mtl_transactions_interface table, if |
57: --| the transaction is WIP Component Issue |
58: --| or WIP Component Return. |
59: --+=======================================================================+
60:

Line 517: l_wip_entity_id NUMBER; -- will be inserted into mtl_transactions_interface as transaction_source_id

513: l_primary_quantity NUMBER;
514: l_status NUMBER;
515:
516: /* vmutyala added the following local variables for Bug 4670527*/
517: l_wip_entity_id NUMBER; -- will be inserted into mtl_transactions_interface as transaction_source_id
518: l_transaction_quantity NUMBER;
519: l_distribution_account_id NUMBER;
520:
521: -- Added for the fix of bug 4869546

Line 557: -- and pass it to the mtl_Transactions_interface table

553: IF p_transaction_type_id IN (35, 43)
554: THEN
555:
556: -- Bug 5337725: Get the locator used to supply component to WIP,
557: -- and pass it to the mtl_Transactions_interface table
558: SELECT wro.supply_subinventory,
559: wro.supply_locator_id
560: INTO l_subinventory_code,
561: l_locator_id

Line 598: into mtl_Transactions_interface Bug 4670527 */

594: l_transaction_quantity := l_primary_quantity;
595: END IF;
596:
597: /* vmutyala added the following code to fetch distribution account and insert
598: into mtl_Transactions_interface Bug 4670527 */
599: IF p_transaction_type_id IN (42, 32)
600: THEN
601: JMF_SHIKYU_UTIL.Get_Shikyu_Offset_Account(p_subcontract_po_shipment_id,l_distribution_account_id);
602: ELSE

Line 607: transaction_source_id into mtl_Transactions_interface for Bug 4670527 */

603: l_distribution_account_id := NULL;
604: END IF;
605:
606: /* vmutyala added the following code to fetch wip entity id and insert as
607: transaction_source_id into mtl_Transactions_interface for Bug 4670527 */
608:
609: -- Bug 4964675
610: -- Added transaction types 35 and 43 for WIP Component Issue or Return
611:

Line 667: INSERT INTO mtl_Transactions_interface

663:
664: /* vmutyala changed the following insert statement to add FINAL_COMPLETION_FLAG,
665: DISTRIBUTION_ACCOUNT_ID, transaction_source_id for insertion Bug 4670527 */
666:
667: INSERT INTO mtl_Transactions_interface
668: ( source_code
669: , source_line_id
670: , source_header_id
671: , process_flag