APPS.EAM_METERREADING_PUB SQL Statements

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

Line: 47

  SELECT maintenance_object_id into x_maintenance_object_id
  FROM wip_discrete_jobs
  WHERE wip_entity_id = p_wip_entity_id
  AND maintenance_object_type = 3;

Line: 57

  SELECT COUNT(1) into l_count
  FROM csi_counter_associations csa,csi_counter_relationships ccr
  WHERE
  csa.source_object_id = x_maintenance_object_id
  AND csa.counter_id = ccr.OBJECT_COUNTER_ID (+)
  AND nvl(ccr.source_counter_id (+),csa.counter_id) = p_meter_id
  and CCR.ACTIVE_END_DATE (+) >= sysdate ;

Line: 153

    l_ctr_property_readings_tbl.DELETE;

Line: 154

    l_ctr_rdg_tbl.DELETE;

Line: 155

    l_csi_txn_tbl.DELETE;

Line: 470

    l_ctr_property_readings_tbl.DELETE;

Line: 640

  l_ctr_rdg_tbl.DELETE;

Line: 642

  SELECT object_version_number
  INTO l_object_version_number
  FROM csi_counter_readings
  WHERE counter_value_id = p_meter_reading_id;

Line: 661

		'==================== Calling Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);

Line: 666

	 Csi_Counter_Readings_PUB.Update_Counter_Reading (p_api_version => p_api_version,
                                                    p_commit => p_commit,
                                                    p_init_msg_list => p_init_msg_list,
                                                    p_validation_level => FND_API.G_VALID_LEVEL_FULL,
                                                    p_ctr_rdg_tbl => l_ctr_rdg_tbl,
                                                    x_return_status => x_return_status,
                                                    x_msg_count => x_msg_count,
                                                    x_msg_data => x_msg_data);

Line: 676

		'==================== Exiting from Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);