[Home] [Help]
5: /****************************************************************************************/
6: /***********************LINE_INTERFACE_INSERT PROCEDURE*********************************/
7: /****************************************************************************************/
8: /**This procedure Inserts lines related transaction information in the **/
9: /**mtl_transactions_interface table **/
10: /**USED BY: ON_SUBMIT and ON_SERIAL Procedures **/
11: /****************************************************************************************/
12: /****************************************************************************************/
13:
47: END IF;
48:
49:
50:
51: --INSERTING VALUES INTO MTL_TRANSACTIONS_INTERFACE
52:
53: Insert into MTL_TRANSACTIONS_INTERFACE
54: (
55: transaction_interface_id,
49:
50:
51: --INSERTING VALUES INTO MTL_TRANSACTIONS_INTERFACE
52:
53: Insert into MTL_TRANSACTIONS_INTERFACE
54: (
55: transaction_interface_id,
56: transaction_header_id,
57: Source_Code,
345: p_To_Loc_Id IN NUMBER)
346: IS
347: BEGIN
348: IF p_Transaction_Action_Id = 2 or p_Transaction_Action_Id = 3 THEN
349: UPDATE MTL_TRANSACTIONS_INTERFACE SET
350: Transfer_Subinventory = p_To_Sub,
351: Transfer_Locator = p_To_Loc_Id
352: WHERE Transaction_Interface_Id = G_Interface_Id;
353: END IF;
528: ELSE
529: l_txn_qty := p_txn_qty;
530: END IF;
531:
532: UPDATE MTL_TRANSACTIONS_INTERFACE SET
533: transaction_quantity = l_txn_qty
534: WHERE Transaction_Header_Id = G_Header_Id;
535:
536: IF (p_transaction_action_id = 2 or p_transaction_action_id =3
773: into l_revision,l_from_sub, l_from_loc from mtl_serial_numbers
774: where current_organization_id = p_organization_id and inventory_item_id =
775: p_inventory_item_id and serial_number = p_from_serial;
776:
777: UPDATE MTL_TRANSACTIONS_INTERFACE SET
778: subinventory_code = l_from_sub,
779: revision = l_revision,
780: locator_id = l_from_loc
781: WHERE Transaction_Header_Id = G_Header_Id;