eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_MOVE_PUB dependencies on INV_TRANSACTIONS

Line 816: INV_TRANSACTIONS.G_Header_ID := p_header_id;

812: when no_data_found then
813: raise no_data_found;
814: end;
815:
816: INV_TRANSACTIONS.G_Header_ID := p_header_id;
817: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
818: UPDATE EAM_ASSET_MOVE_TEMP
819: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
820: WHERE CURRENT OF validAssets_cur;

Line 817: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;

813: raise no_data_found;
814: end;
815:
816: INV_TRANSACTIONS.G_Header_ID := p_header_id;
817: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
818: UPDATE EAM_ASSET_MOVE_TEMP
819: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
820: WHERE CURRENT OF validAssets_cur;
821: IF(l_serial_number_control_code <> 1) THEN

Line 823: INTO INV_TRANSACTIONS.G_Serial_ID

819: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
820: WHERE CURRENT OF validAssets_cur;
821: IF(l_serial_number_control_code <> 1) THEN
822: SELECT mtl_material_transactions_s.nextval
823: INTO INV_TRANSACTIONS.G_Serial_ID
824: FROM dual;
825: END IF;
826:
827:

Line 829: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);

825: END IF;
826:
827:
828: -- insert into MTI, MSNI
829: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
830: IF (l_slog) then
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
832: END IF;
833:

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );

827:
828: -- insert into MTI, MSNI
829: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
830: IF (l_slog) then
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
832: END IF;
833:
834: IF(p_transaction_type_id=2) THEN --if subinventory transfer
835: IF(p_CURRENT_ORGANIZATION_ID<>l_CURRENT_ORGANIZATION_ID)THEN

Line 890: INV_TRANSACTIONS.LINE_INTERFACE_INSERT(

886: END IF;
887: --Added for the 7833252
888: END IF;
889:
890: INV_TRANSACTIONS.LINE_INTERFACE_INSERT(
891: l_inventory_item_id,
892: NULL, --revision
893: l_CURRENT_ORGANIZATION_ID,
894: NULL, -- l_Transaction_Source_Id,

Line 917: SET SHIPMENT_NUMBER=p_shipment_number where TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID

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;
921:

Line 918: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;

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;
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

Line 926: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID

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;
928: END IF;
929:
930: IF(l_serial_number_control_code <> 1

Line 927: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;

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;
928: END IF;
929:
930: IF(l_serial_number_control_code <> 1
931: AND l_from_ser_number IS NOT NULL

Line 934: --dbms_output.put_line('serial_id IS' ||INV_TRANSACTIONS.G_Serial_ID);

930: IF(l_serial_number_control_code <> 1
931: AND l_from_ser_number IS NOT NULL
932: AND l_to_ser_number IS NOT NULL AND
933: l_serial_number_control_code IS NOT NULL) THEN
934: --dbms_output.put_line('serial_id IS' ||INV_TRANSACTIONS.G_Serial_ID);
935: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
936: l_from_ser_number ,
937: l_to_ser_number ,
938: FND_GLOBAL.USER_ID ,

Line 935: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(

931: AND l_from_ser_number IS NOT NULL
932: AND l_to_ser_number IS NOT NULL AND
933: l_serial_number_control_code IS NOT NULL) THEN
934: --dbms_output.put_line('serial_id IS' ||INV_TRANSACTIONS.G_Serial_ID);
935: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
936: l_from_ser_number ,
937: l_to_ser_number ,
938: FND_GLOBAL.USER_ID ,
939: l_lot_control_code