APPS.CSI_TIME_BASED_CTR_ENGINE_PKG SQL Statements

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

Line: 71

   fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');

Line: 72

   select CSI_COUNTER_READINGS_S.nextval
   into l_ctr_rdg_rec.counter_value_id from dual;

Line: 75

      CSI_COUNTER_READINGS_PKG.Insert_Row(
	  px_COUNTER_VALUE_ID         =>  l_ctr_rdg_rec.counter_value_id
	 ,p_COUNTER_ID                =>  l_ctr_rdg_rec.counter_id
	 ,p_VALUE_TIMESTAMP           =>  l_ctr_rdg_rec.value_timestamp
	 ,p_COUNTER_READING           =>  l_ctr_rdg_rec.counter_reading
	 ,p_RESET_MODE                =>  NULL
	 ,p_RESET_REASON              =>  NULL
	 ,p_ADJUSTMENT_TYPE           =>  NULL
	 ,p_ADJUSTMENT_READING        =>  NULL
	 ,p_OBJECT_VERSION_NUMBER     =>  1
	 ,p_LAST_UPDATE_DATE          =>  SYSDATE
	 ,p_LAST_UPDATED_BY           =>  fnd_global.user_id
	 ,p_CREATION_DATE             =>  SYSDATE
	 ,p_CREATED_BY                =>  fnd_global.user_id
	 ,p_LAST_UPDATE_LOGIN         =>  fnd_global.conc_login_id
	 ,p_ATTRIBUTE1                =>  NULL
	 ,p_ATTRIBUTE2                =>  NULL
	 ,p_ATTRIBUTE3                =>  NULL
	 ,p_ATTRIBUTE4                =>  NULL
	 ,p_ATTRIBUTE5                =>  NULL
	 ,p_ATTRIBUTE6                =>  NULL
	 ,p_ATTRIBUTE7                =>  NULL
	 ,p_ATTRIBUTE8                =>  NULL
	 ,p_ATTRIBUTE9                =>  NULL
	 ,p_ATTRIBUTE10               =>  NULL
	 ,p_ATTRIBUTE11               =>  NULL
	 ,p_ATTRIBUTE12               =>  NULL
	 ,p_ATTRIBUTE13               =>  NULL
	 ,p_ATTRIBUTE14               =>  NULL
	 ,p_ATTRIBUTE15               =>  NULL
	 ,p_ATTRIBUTE16               =>  NULL
	 ,p_ATTRIBUTE17               =>  NULL
	 ,p_ATTRIBUTE18               =>  NULL
	 ,p_ATTRIBUTE19               =>  NULL
	 ,p_ATTRIBUTE20               =>  NULL
	 ,p_ATTRIBUTE21               =>  NULL
	 ,p_ATTRIBUTE22               =>  NULL
	 ,p_ATTRIBUTE23               =>  NULL
	 ,p_ATTRIBUTE24               =>  NULL
	 ,p_ATTRIBUTE25               =>  NULL
	 ,p_ATTRIBUTE26               =>  NULL
	 ,p_ATTRIBUTE27               =>  NULL
	 ,p_ATTRIBUTE28               =>  NULL
	 ,p_ATTRIBUTE29               =>  NULL
	 ,p_ATTRIBUTE30               =>  NULL
	 ,p_ATTRIBUTE_CATEGORY        =>  NULL
	 ,p_MIGRATED_FLAG             =>  'N'
	 ,p_COMMENTS                  =>  NULL
	 ,p_LIFE_TO_DATE_READING      =>  l_ctr_rdg_rec.counter_reading
	 ,p_TRANSACTION_ID            =>  p_txn_rec.transaction_id -- bug 15972103
	 ,p_AUTOMATIC_ROLLOVER_FLAG   =>  NULL
	 ,p_INCLUDE_TARGET_RESETS     =>  NULL
	 ,p_SOURCE_COUNTER_VALUE_ID   =>  NULL
	 ,p_NET_READING               =>  l_ctr_rdg_rec.counter_reading
	 ,p_DISABLED_FLAG             =>  'N'
	 ,p_SOURCE_CODE               =>  NULL
	 ,p_SOURCE_LINE_ID            =>  NULL
	 ,p_INITIAL_READING_FLAG      =>  NULL
       );

Line: 135

      CSI_COUNTER_PVT.update_ctr_val_max_seq_no(
          p_api_version           =>  1.0
         ,p_commit                =>  fnd_api.g_false
         ,p_init_msg_list         =>  fnd_api.g_true
         ,p_validation_level      =>  fnd_api.g_valid_level_full
         ,p_counter_id            =>  l_ctr_rdg_rec.counter_id
         ,px_ctr_val_max_seq_no   =>  l_ctr_rdg_rec.counter_value_id
         ,x_return_status         =>  x_return_status
         ,x_msg_count             =>  x_msg_count
         ,x_msg_data              =>  x_msg_data
         );

Line: 155

          csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');

Line: 207

      select '1'
      into l_exists
      from dual
      where exists (select distinct object_counter_id
                     from csi_counter_relationships
                     where source_counter_id = p_src_counter_id
                     and   relationship_type_code = 'FORMULA'
                     and   nvl(active_end_date,(sysdate+1)) > sysdate
                     AND ROWNUM = 1);

Line: 260

   SELECT ctr.counter_id, ctr.creation_date, ctr.uom_code, ctr.ctr_val_max_seq_no --Bug 15972103
   FROM   CSI_COUNTERS_B ctr, CS_CSI_COUNTER_GROUPS ccg
   WHERE  ctr.group_id  =   ccg.counter_group_id
   AND    ccg.created_from_ctr_grp_tmpl_id  = nvl(p_counter_group_id, ccg.created_from_ctr_grp_tmpl_id)
   AND    ccg.template_flag    = 'N'
   AND    ctr.counter_type = 'REGULAR'
   AND    nvl(ctr.end_date_active,(sysdate+1)) > sysdate
   AND    nvl(ctr.time_based_manual_entry, 'N') = 'N'
   AND    exists (select 'x'
                  from   MTL_UNITS_OF_MEASURE_VL uom
                  where  upper(uom.uom_class) = 'TIME'
                  and    uom.uom_code = ctr.uom_code);

Line: 277

   SELECT counter_value_id,counter_reading,value_timestamp
   FROM CSI_COUNTER_READINGS
   WHERE counter_value_id = p_ctr_val_max_seq_no --Bug 15972103
   AND   nvl(disabled_flag,'N') = 'N'
   ORDER BY value_timestamp desc;