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: 49


   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: 60


   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: 69


   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: 76


   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: 86


   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: 97


   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: 267


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

Line: 268


               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: 285


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

Line: 333


		--to Update_Last_Service_Reading_Wo for change counters
          IF p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).transaction_type_id = 92 THEN
               csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');

Line: 337


                SELECT reading_type
                INTO   l_reading_type
                FROM   csi_counters_b
                WHERE  counter_id = p_ctr_rdg_tbl(j).counter_id;

Line: 349


               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).life_to_date_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: 360


               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: 373


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

Line: 387


            END IF; -- Call Update_Last_Service_Reading_WO check

Line: 523


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

Line: 532


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

Line: 654


   l_assembler_tbl.DELETE;

Line: 784


/* 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: 814


   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: 821


   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: 831


   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: 842


   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: 851


   SAVEPOINT  update_counter_reading;

Line: 874


      csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading');

Line: 878


      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: 886


      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: 898


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

Line: 916


      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: 928


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

Line: 949


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

Line: 950


	    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: 962


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

Line: 982


      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: 994


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

Line: 1012


      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: 1024


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

Line: 1041


   l_assembler_tbl.DELETE;

Line: 1140


      ROLLBACK TO update_counter_reading;

Line: 1147


      ROLLBACK TO update_counter_reading;

Line: 1154


      ROLLBACK TO update_counter_reading;

Line: 1165


END Update_Counter_Reading;