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_METERREADING_UTILITY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33


PROCEDURE INSERT_ROW
(
	  p_eam_meter_reading_tbl  IN  EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
   	 , p_eam_counter_prop_tbl  IN  EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
	 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
 	 , x_eam_counter_prop_tbl  OUT NOCOPY  EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type
	 , x_return_status         OUT NOCOPY  VARCHAR2
	 , x_mesg_token_tbl        OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
) IS
	l_meter_reading_rec	 EAM_MeterReading_PUB.Meter_Reading_Rec_Type;

Line: 57


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..');

Line: 113


			l_counter_properties_tbl.delete;

Line: 148


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERREADING_PUB.create_meter_reading().. from EAM_METERREADING_UTILITY_PVT.INSERT_ROW()');

Line: 197


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.INSERT_ROW()..Successfully');

Line: 199


END INSERT_ROW;

Line: 223


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.ENABLE_SOURCE_METER()');

Line: 226


			EAM_METER_PUB.update_meter
			(
				p_api_version		=> 1.0,
				p_meter_id		=> p_eam_wo_comp_mr_read_tbl(ii).meter_issued_serial,
				p_source_meter_id	=> p_eam_wo_comp_mr_read_tbl(ii).source_meter,
				p_factor => 1, -- Added for bug #5255445
				x_return_status		=> l_return_status,
				x_msg_count		=> l_msg_count,
				x_msg_data		=> l_msg_data
			);

Line: 237


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with return_status : ' || l_return_status);

Line: 244


				EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter().. : ' || l_msg_data);

Line: 283


        SELECT wdj.maintenance_object_id instance_id
 	  FROM wip_discrete_jobs wdj
	 WHERE wdj.maintenance_object_type = 3 AND wdj.manual_rebuild_flag = 'N'
	   AND wdj.parent_wip_entity_id = p_wip_entity_id;

Line: 310


			l_counter_tbl.delete;

Line: 312


			SELECT maintenance_object_id into l_instance_id
			  FROM wip_discrete_jobs wdj
			 WHERE wip_entity_id = l_eam_wo_comp_rebuild_tbl(ii).wip_entity_id;

Line: 316


		        SELECT  cca.counter_id
			  BULK COLLECT INTO l_counter_tbl
			  FROM CSI_COUNTER_ASSOCIATIONS cca
			 WHERE cca.source_object_id =  l_eam_wo_comp_rebuild_tbl(ii).instance_id_removed
			   AND (cca.end_date_active IS NULL OR cca.end_date_active > sysdate)
			   AND exists
			   (
			   SELECT '1'
			     FROM CSI_COUNTER_ASSOCIATIONS ccas, CSI_COUNTER_RELATIONSHIPS ccr
                            WHERE ccas.source_object_id =  l_instance_id
			      AND (ccas.end_date_active IS NULL OR ccas.end_date_active > sysdate)
			      AND ccr.object_counter_id = cca.COUNTER_ID
			      AND ccr.source_counter_id = ccas.counter_id
			   );

Line: 335


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METER_PUB.update_meter().. from EAM_METERREADING_UTILITY_PVT.DISABLE_COUNTER_HIERARCHY()');

Line: 337


					EAM_METER_PUB.update_meter
					(
						p_api_version		=> 1.0,
						p_meter_id		=> l_counter_tbl(K),
						p_source_meter_id	=> null,
						p_from_eam		=> 'Y',
						x_return_status		=> l_return_status,
						x_msg_count		=> l_msg_count,
						x_msg_data		=> l_msg_data
					);

Line: 348


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METER_PUB.update_meter() with return_status : ' || l_return_status);

Line: 356


		EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METER_PUB.update_meter()..: ' || l_msg_data);

Line: 398


PROCEDURE UPDATE_ACTIVITY
(
	 p_eam_wo_comp_rebuild_tbl     IN  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
       , x_eam_wo_comp_rebuild_tbl     OUT NOCOPY  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
	 , x_return_status         OUT NOCOPY  VARCHAR2
	 , x_mesg_token_tbl        OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)IS

	l_return_status			VARCHAR2(1);

Line: 419


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..');

Line: 429


				SELECT REQUESTED_START_DATE,due_date,primary_item_id
				  INTO l_scheduled_start_date,l_scheduled_completion_date,l_primary_item_id
				  FROM wip_discrete_jobs
				 WHERE wip_entity_id = p_eam_wo_comp_rebuild_tbl(ii).rebuild_wip_entity_id
				   AND organization_id = p_eam_wo_comp_rebuild_tbl(ii).organization_id;

Line: 438


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_PROCESS_WO_PUB.EXPLODE_ACTIVITY().. from EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()');

Line: 494


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_ACTIVITY()..Successfully');

Line: 497


END UPDATE_ACTIVITY;

Line: 499


PROCEDURE UPDATE_GENEALOGY
(
	 p_eam_wo_comp_rebuild_tbl     IN  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
       , x_eam_wo_comp_rebuild_tbl     OUT NOCOPY  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
       , x_return_status               OUT NOCOPY  VARCHAR2
       , x_mesg_token_tbl              OUT NOCOPY  EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)IS
	l_return_status		VARCHAR2(1);

Line: 515


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..');

Line: 527


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling wip_eam_genealogy_pvt.update_eam_genealogy().. from EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()');

Line: 530


			 	wip_eam_genealogy_pvt.update_eam_genealogy
				(
					p_api_version => 1.0,
					p_object_type => 2,
					p_serial_number => p_eam_wo_comp_rebuild_tbl(ii).UNINST_SERIAL_REMOVED,
					p_inventory_item_id => p_eam_wo_comp_rebuild_tbl(ii).ITEM_REMOVED,
					p_organization_id => p_eam_wo_comp_rebuild_tbl(ii).ORGANIZATION_ID,
					p_genealogy_type => 5, /* asset item relationship*/
					p_end_date_active => sysdate,
					x_return_status => l_return_status,
					x_msg_count => l_msg_count,
					x_msg_data => l_msg_data
				);

Line: 544


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from wip_eam_genealogy_pvt.update_eam_genealogy() with return_status : ' || l_return_status);

Line: 552


		EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM wip_eam_genealogy_pvt.update_eam_genealogy()..: ' || l_msg_data);

Line: 568


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_GENEALOGY()..Successfully');

Line: 571


END UPDATE_GENEALOGY;

Line: 574


PROCEDURE UPDATE_LAST_SERVICE_READING
(
	  p_eam_meter_reading_tbl  IN  EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
   	 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
 	 , x_return_status         OUT NOCOPY  VARCHAR2
	 , x_mesg_token_tbl        OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)IS
	l_return_status		VARCHAR2(1);

Line: 590


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..');

Line: 599


			EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling EAM_METERS_UTIL.update_last_service_reading_wo().. from EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()');

Line: 602


			 EAM_METERS_UTIL.update_last_service_reading_wo(
			   p_wip_entity_id      => p_eam_meter_reading_tbl(i).wip_entity_id ,
			   p_meter_id		=> p_eam_meter_reading_tbl(i).meter_id ,
			   p_meter_reading	=> p_eam_meter_reading_tbl(i).meter_reading_id ,
			   p_wo_end_date	=> p_eam_meter_reading_tbl(i).wo_end_date ,
			   x_return_status      => l_return_status,
			   x_msg_count          => l_msg_count,
			   x_msg_data           => l_msg_data
			);

Line: 612


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Returned from EAM_METERS_UTIL.update_last_service_reading_wo() with return_status : ' || l_return_status);

Line: 619


		EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('ERROR RETURNED FROM EAM_METERS_UTIL.update_last_service_reading_wo()..: ' || l_msg_data);

Line: 632


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_LAST_SERVICE_READING()..Successfully');

Line: 634


END UPDATE_LAST_SERVICE_READING;

Line: 636


PROCEDURE UPDATE_REBUILD_WORK_ORDER
(
	 p_eam_wo_comp_rebuild_tbl     IN  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
       , x_eam_wo_comp_rebuild_tbl     OUT NOCOPY  EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
       , x_return_status	       OUT NOCOPY  VARCHAR2
       , x_mesg_token_tbl	       OUT NOCOPY  EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)IS
BEGIN

	IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
		EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..');

Line: 654


		UPDATE wip_discrete_jobs
		   SET maintenance_object_type = 3 ,
		       maintenance_object_id = p_eam_wo_comp_rebuild_tbl(i).instance_id_removed,
		       rebuild_serial_number = ( select serial_number
						   from csi_item_instances
						  where instance_id = p_eam_wo_comp_rebuild_tbl(i).instance_id_removed
						)
		 WHERE wip_entity_id = p_eam_wo_comp_rebuild_tbl(i).rebuild_wip_entity_id;

Line: 668


		EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG('Exception in EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()');

Line: 674


		EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished EAM_METERREADING_UTILITY_PVT.UPDATE_REBUILD_WORK_ORDER()..Successfully');

Line: 677


END UPDATE_REBUILD_WORK_ORDER;