[Home] [Help]
912: --if transaction type is of interorg-intransit then we need to enter the shipment number into MTI table explicitly.
913:
914: IF(p_transaction_type_id=21) THEN
915: --code for entering the shipment values into MTI
916: UPDATE MTL_TRANSACTIONS_INTERFACE
917: SET SHIPMENT_NUMBER=p_shipment_number where TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
918: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
919:
920: END IF;
919:
920: END IF;
921:
922: IF(validAssets_rec.prepare_status='MR') THEN --for --for 7370638 Batch seq to be 2 as the transfer is dependent on the Misc. receipt
923: UPDATE MTL_TRANSACTIONS_INTERFACE
924: SET TRANSACTION_BATCH_ID = l_transaction_batch_id,
925: TRANSACTION_BATCH_SEQ = 2
926: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
927: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
1005: SELECT MTI.TRANSACTION_HEADER_ID ,
1006: MTI.TRANSACTION_INTERFACE_ID,
1007: MTI.ERROR_CODE ,
1008: MTI.ERROR_EXPLANATION
1009: FROM MTL_TRANSACTIONS_INTERFACE MTI
1010: WHERE MTI.TRANSACTION_HEADER_ID = p_txn_header_id ;
1011:
1012: BEGIN
1013: --Dbms_Output.put_line('begining of processAssetMoveTxn');
1346: SELECT APPS.mtl_material_transactions_s.NEXTVAL
1347: INTO l_txn_if_id
1348: FROM sys.dual;
1349:
1350: INSERT INTO mtl_transactions_interface
1351: (transaction_header_id,
1352: source_code,
1353: source_line_id,
1354: source_header_id,
1464: l_txn_action_id := 1;
1465: l_txn_SOURCE_TYPE_ID := 13 ;
1466: l_TRANSACTION_BATCH_SEQ := 3;
1467:
1468: -- Please add your code to insert the values into mtl_transactions_interface and mtl_serial_numbers_interface
1469: -- for performing the miscellaneous Issue Transaction
1470:
1471: --****** Important****
1472: