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.CSI_COUNTER_READINGS_PUB SQL Statements

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

Line: 48


   select ccp.counter_property_id,ccp.default_value
   from CSI_COUNTER_PROPERTIES_B ccp
   where ccp.counter_id = p_counter_id
   and    ((ccp.default_value is not null) or
           (ccp.default_value is null and ccp.is_nullable = 'N'))
   and   nvl(end_date_active,(sysdate+1)) > sysdate
   and   not exists (select 'x' from CSI_CTR_PROPERTY_READINGS cpr
                     Where cpr.counter_value_id = p_value_id
                     and   cpr.counter_property_id = ccp.counter_property_id);

Line: 59


   select counter_value_id,counter_reading,net_reading,value_timestamp,adjustment_reading
         ,reset_mode,adjustment_type,include_target_resets
   from CSI_COUNTER_READINGS
   where counter_id = p_counter_id
   and   nvl(disabled_flag,'N') = 'N'
   and   value_timestamp > p_value_timestamp
   ORDER BY value_timestamp asc, counter_value_id asc;

Line: 68


   select distinct object_counter_id
   from csi_counter_relationships
   where source_counter_id = p_src_ctr_id
   and   relationship_type_code = l_formula_rel_type
   and   nvl(active_end_date,(sysdate+1)) > sysdate;

Line: 75


   select ccr.object_counter_id
   from CSI_COUNTER_RELATIONSHIPS ccr,
        CSI_COUNTERS_B ccv
   where ccr.source_counter_id = p_src_ctr_id
   and   ccr.relationship_type_code = l_target_rel_type
   and   nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
   and   nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp
   and   ccv.counter_id = ccr.object_counter_id;

Line: 85


   SELECT crg.counter_id
   from CSI_COUNTER_READINGS crg,
        CSI_COUNTER_RELATIONSHIPS ccr,
        CSI_COUNTERS_B ccv
   where crg.source_counter_value_id = p_ctr_value_id
   and   ccr.object_counter_id = crg.counter_id
   and   ccr.source_counter_id = p_src_ctr_id
   and   ccr.relationship_type_code = l_target_rel_type
   and   ccv.counter_id = crg.counter_id;

Line: 96


   SELECT ctr.counter_id
   FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
   WHERE cv.counter_value_id = p_ctr_value_id
   AND   ctr.derive_counter_id = cv.counter_id
   AND   NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
   AND   NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line: 266


               csi_ctr_gen_utility_pvt.put_line('Calling Insert Meter Log...');

Line: 267


               Eam_Asset_Log_Pvt.Insert_Meter_Log
                  (
                    P_api_version           =>  1.0,
                    P_init_msg_list         =>  fnd_api.g_false,
                    P_commit                =>  fnd_api.g_false,
                    P_validation_level      =>  fnd_api.g_valid_level_full,
                    P_event_date            =>  p_ctr_rdg_tbl(j).value_timestamp,
                    P_instance_id           =>  l_instance_id,
                    P_ref_id                =>  p_ctr_rdg_tbl(j).counter_id,
                    X_return_status         =>  x_return_status,
                    X_msg_count             =>  x_msg_count,
                    X_msg_data              =>  x_msg_data
               );

Line: 284


		  csi_ctr_gen_utility_pvt.put_line('ERROR FROM Insert_Meter_Log API ');

Line: 301


               csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');

Line: 302


               Eam_Meters_Util.Update_Last_Service_Reading_Wo
                  (
                    p_wip_entity_id    =>  p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).source_header_ref_id,
                    p_meter_id         =>  p_ctr_rdg_tbl(j).counter_id,
		    p_meter_reading    =>  p_ctr_rdg_tbl(j).counter_reading,
		    p_wo_end_date      =>  p_ctr_rdg_tbl(j).value_timestamp,
                    X_return_status    =>  x_return_status,
                    X_msg_count        =>  x_msg_count,
                    X_msg_data         =>  x_msg_data
	           );

Line: 313


		  csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');

Line: 327


            END IF; -- Call Update_Last_Service_Reading_WO check

Line: 492


		     csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters for Update...');

Line: 501


			 ,p_mode                  => 'UPDATE'
			 ,x_return_status         => x_return_status
			 ,x_msg_count             => x_msg_count
			 ,x_msg_data              => x_msg_data
		       );

Line: 623


   l_assembler_tbl.DELETE;

Line: 753


/* procedure name: Update_Counter_Reading             */
/* description :   procedure used to                  */
/*                 update counter readings            */
/*----------------------------------------------------*/

PROCEDURE Update_Counter_Reading
 (
     p_api_version           IN     NUMBER
    ,p_commit                IN     VARCHAR2
    ,p_init_msg_list         IN     VARCHAR2
    ,p_validation_level      IN     NUMBER
    ,p_ctr_rdg_tbl           IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_tbl
    ,x_return_status         OUT    NOCOPY VARCHAR2
    ,x_msg_count             OUT    NOCOPY NUMBER
    ,x_msg_data              OUT    NOCOPY VARCHAR2
 )
IS
   l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_COUNTER_READING';

Line: 783


   select distinct object_counter_id
   from csi_counter_relationships
   where source_counter_id = p_src_ctr_id
   and   relationship_type_code = l_formula_rel_type
   and   nvl(active_end_date,(sysdate+1)) > sysdate;

Line: 790


   select ccr.object_counter_id
   from CSI_COUNTER_RELATIONSHIPS ccr,
        CSI_COUNTERS_B ccv
   where ccr.source_counter_id = p_src_ctr_id
   and   ccr.relationship_type_code = l_target_rel_type
   and   nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
   and   nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp
   and   ccv.counter_id = ccr.object_counter_id;

Line: 800


   SELECT crg.counter_id
   from CSI_COUNTER_READINGS crg,
        CSI_COUNTER_RELATIONSHIPS ccr,
        CSI_COUNTERS_B ccv
   where crg.source_counter_value_id = p_ctr_value_id
   and   ccr.object_counter_id = crg.counter_id
   and   ccr.source_counter_id = p_src_ctr_id
   and   ccr.relationship_type_code = l_target_rel_type
   and   ccv.counter_id = crg.counter_id;

Line: 811


   SELECT ctr.counter_id
   FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
   WHERE cv.counter_value_id = p_ctr_value_id
   AND   ctr.derive_counter_id = cv.counter_id
   AND   NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
   AND   NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line: 820


   SAVEPOINT  update_counter_reading;

Line: 843


      csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');

Line: 847


      csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading'     ||
                                     p_api_version         ||'-'||
                                     nvl(p_commit,FND_API.G_FALSE)              ||'-'||
                                     nvl(p_init_msg_list,FND_API.G_FALSE)       ||'-'||
                                     nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

Line: 855


      CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_PRE
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_rdg_tbl          => p_ctr_rdg_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );

Line: 867


         csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');

Line: 885


      CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_PRE
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_rdg_tbl          => p_ctr_rdg_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );

Line: 897


         csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');

Line: 918


	    csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');

Line: 919


	    Csi_Counter_Readings_Pvt.Update_Counter_Reading
	       (
		 p_api_version           => 1.0
		,p_commit                => p_commit
		,p_init_msg_list         => p_init_msg_list
		,p_validation_level      => p_validation_level
		,p_ctr_rdg_rec           => p_ctr_rdg_tbl(j)
		,x_return_status         => x_return_status
		,x_msg_count             => x_msg_count
		,x_msg_data              => x_msg_data
	       );

Line: 931


               csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pvt API ');

Line: 951


      CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_POST
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_rdg_tbl          => p_ctr_rdg_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );

Line: 963


         csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');

Line: 981


      CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_POST
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_rdg_tbl          => p_ctr_rdg_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );

Line: 993


         csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');

Line: 1010


   l_assembler_tbl.DELETE;

Line: 1109


      ROLLBACK TO update_counter_reading;

Line: 1116


      ROLLBACK TO update_counter_reading;

Line: 1123


      ROLLBACK TO update_counter_reading;

Line: 1134


END Update_Counter_Reading;