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 798: INV_TRANSACTIONS.G_Header_ID := p_header_id;

794: when no_data_found then
795: raise no_data_found;
796: end;
797:
798: INV_TRANSACTIONS.G_Header_ID := p_header_id;
799: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
800: UPDATE EAM_ASSET_MOVE_TEMP
801: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
802: WHERE CURRENT OF validAssets_cur;

Line 799: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;

795: raise no_data_found;
796: end;
797:
798: INV_TRANSACTIONS.G_Header_ID := p_header_id;
799: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
800: UPDATE EAM_ASSET_MOVE_TEMP
801: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
802: WHERE CURRENT OF validAssets_cur;
803: IF(l_serial_number_control_code <> 1) THEN

Line 805: INTO INV_TRANSACTIONS.G_Serial_ID

801: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
802: WHERE CURRENT OF validAssets_cur;
803: IF(l_serial_number_control_code <> 1) THEN
804: SELECT mtl_material_transactions_s.nextval
805: INTO INV_TRANSACTIONS.G_Serial_ID
806: FROM dual;
807: END IF;
808:
809:

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

807: END IF;
808:
809:
810: -- insert into MTI, MSNI
811: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
812: IF (l_slog) then
813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
814: END IF;
815:

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

809:
810: -- insert into MTI, MSNI
811: --dbms_output.put_line('header_id IS' ||INV_TRANSACTIONS.G_Header_ID);
812: IF (l_slog) then
813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'Calling the procedure INV_TRANSACTIONS.LINE_INTERFACE_INSERT' );
814: END IF;
815:
816: IF(p_transaction_type_id=2) THEN --if subinventory transfer
817: IF(p_CURRENT_ORGANIZATION_ID<>l_CURRENT_ORGANIZATION_ID)THEN

Line 872: INV_TRANSACTIONS.LINE_INTERFACE_INSERT(

868: END IF;
869: --Added for the 7833252
870: END IF;
871:
872: INV_TRANSACTIONS.LINE_INTERFACE_INSERT(
873: l_inventory_item_id,
874: NULL, --revision
875: l_CURRENT_ORGANIZATION_ID,
876: NULL, -- l_Transaction_Source_Id,

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

895:
896: IF(p_transaction_type_id=21) THEN
897: --code for entering the shipment values into MTI
898: UPDATE MTL_TRANSACTIONS_INTERFACE
899: SET SHIPMENT_NUMBER=p_shipment_number where TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
900: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
901:
902: END IF;
903:

Line 900: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;

896: IF(p_transaction_type_id=21) THEN
897: --code for entering the shipment values into MTI
898: UPDATE MTL_TRANSACTIONS_INTERFACE
899: SET SHIPMENT_NUMBER=p_shipment_number where TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
900: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
901:
902: END IF;
903:
904: 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 908: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID

904: IF(validAssets_rec.prepare_status='MR') THEN --for --for 7370638 Batch seq to be 2 as the transfer is dependent on the Misc. receipt
905: UPDATE MTL_TRANSACTIONS_INTERFACE
906: SET TRANSACTION_BATCH_ID = l_transaction_batch_id,
907: TRANSACTION_BATCH_SEQ = 2
908: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
909: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
910: END IF;
911:
912: IF(l_serial_number_control_code <> 1

Line 909: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;

905: UPDATE MTL_TRANSACTIONS_INTERFACE
906: SET TRANSACTION_BATCH_ID = l_transaction_batch_id,
907: TRANSACTION_BATCH_SEQ = 2
908: WHERE TRANSACTION_INTERFACE_ID=INV_TRANSACTIONS.G_Interface_ID
909: AND TRANSACTION_HEADER_ID=INV_TRANSACTIONS.G_Header_ID;
910: END IF;
911:
912: IF(l_serial_number_control_code <> 1
913: AND l_from_ser_number IS NOT NULL

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

912: IF(l_serial_number_control_code <> 1
913: AND l_from_ser_number IS NOT NULL
914: AND l_to_ser_number IS NOT NULL AND
915: l_serial_number_control_code IS NOT NULL) THEN
916: --dbms_output.put_line('serial_id IS' ||INV_TRANSACTIONS.G_Serial_ID);
917: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
918: l_from_ser_number ,
919: l_to_ser_number ,
920: FND_GLOBAL.USER_ID ,

Line 917: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(

913: AND l_from_ser_number IS NOT NULL
914: AND l_to_ser_number IS NOT NULL AND
915: l_serial_number_control_code IS NOT NULL) THEN
916: --dbms_output.put_line('serial_id IS' ||INV_TRANSACTIONS.G_Serial_ID);
917: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
918: l_from_ser_number ,
919: l_to_ser_number ,
920: FND_GLOBAL.USER_ID ,
921: l_lot_control_code