APPS.CSM_CTR_PROP_READ_EVENT_PKG SQL Statements

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

Line: 28

SELECT
B.COUNTER_PROP_VALUE_ID
FROM
CSI_CTR_PROPERTY_READINGS B,
csm_counter_values_acc	 VACC
WHERE B.COUNTER_VALUE_ID    = VACC.COUNTER_VALUE_ID
AND   VACC.USER_ID 	  		= c_user_id
AND   VACC.COUNTER_VALUE_ID = c_counter_value_id
AND NOT EXISTS( SELECT 1
				FROM   CSM_COUNTER_PROP_VALUES_ACC PVACC
				WHERE  PVACC.COUNTER_PROP_VALUE_ID = B.COUNTER_PROP_VALUE_ID
				AND	   PVACC.USER_ID = c_user_id);

Line: 52

      CSM_ACC_PKG.Insert_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
              ,P_ACC_TABLE_NAME         => g_count_prp_acc_table_name
              ,P_SEQ_NAME               => g_count_prp_seq_name
              ,P_PK1_NAME               => g_count_prp_pk1_name
              ,P_PK1_NUM_VALUE          => r_cntr_prp_val_rec.counter_prop_value_id
              ,P_USER_ID                => p_user_id
             );

Line: 88

SELECT
VACC.ACCESS_ID ,
VACC.USER_ID
FROM
CSI_CTR_PROPERTY_READINGS B,
CSM_COUNTER_PROP_VALUES_ACC VACC
WHERE B.COUNTER_PROP_VALUE_ID    = VACC.COUNTER_PROP_VALUE_ID
AND   VACC.USER_ID 	  			 = c_user_id
AND   B.COUNTER_PROP_VALUE_ID 	 = c_counter_value_id;

Line: 144

SELECT
VACC.ACCESS_ID ,
B.COUNTER_PROP_VALUE_ID
FROM
CSI_CTR_PROPERTY_READINGS B,
CSM_COUNTER_PROP_VALUES_ACC VACC
WHERE B.COUNTER_PROP_VALUE_ID    = VACC.COUNTER_PROP_VALUE_ID
AND   VACC.USER_ID 	  			 = c_user_id
AND   B.COUNTER_VALUE_ID 	  	 = c_counter_value_id;

Line: 165

      CSM_ACC_PKG.Delete_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
              ,P_ACC_TABLE_NAME         => g_count_prp_acc_table_name
              ,P_PK1_NAME               => g_count_prp_pk1_name
              ,P_PK1_NUM_VALUE          => r_cntr_prp_val_rec.counter_prop_value_id
              ,P_USER_ID                => p_user_id
             );

Line: 206

l_prog_update_date 				jtm_con_request_data.last_run_date%TYPE;

Line: 213

SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,
	   prd.counter_prop_value_id,
   	   val_acc.user_id
FROM   CSI_CTR_PROPERTY_READINGS prd,
       csm_counter_values_acc val_acc
where  prd.counter_value_id	    = val_acc.counter_value_id
AND	   val_acc.creation_date    >= c_last_run_date
AND	   NOT EXISTS
	   (SELECT 1 FROM CSM_COUNTER_PROP_VALUES_ACC prop_acc
	    WHERE prop_acc.counter_prop_value_id =prd.counter_prop_value_id
		AND	  prop_acc.user_id    = val_acc.user_id );

Line: 230

SELECT prop_acc.access_id,
	   prop_acc.user_id
FROM   CSI_CTR_PROPERTY_READINGS prd,
	   CSM_COUNTER_PROP_VALUES_ACC prop_acc
where  prd.counter_prop_value_id = prop_acc.counter_prop_value_id
AND    NOT EXISTS
	   (SELECT 1 FROM csm_counter_values_acc val_acc
	    WHERE prd.counter_value_id = val_acc.counter_value_id
		AND	  prop_acc.user_id    = val_acc.user_id);

Line: 244

SELECT 	nvl(last_run_date, (sysdate - 365*50))
FROM 	jtm_con_request_data
WHERE 	package_name   = 'CSM_CTR_PROP_READ_EVENT_PKG'
AND 	procedure_name = 'REFRESH_ACC';

Line: 256

 FETCH 	l_last_run_date_csr INTO l_prog_update_date;

Line: 260

    l_access_list.delete;

Line: 267

 CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

Line: 287

     DELETE FROM CSM_COUNTER_PROP_VALUES_ACC WHERE access_id = l_access_list(i);

Line: 289

   l_access_list.delete;

Line: 290

 END IF; -- end of process deletes

Line: 293

 CSM_UTIL_PKG.LOG('Leaving DELETE and entering inserts', 'CSM_CTR_PROP_READ_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 296

 OPEN  csr_ctr_prop_reading_ins (l_prog_update_date);

Line: 311

     INSERT INTO	CSM_COUNTER_PROP_VALUES_ACC
	 				(access_id,
	 				counter_prop_value_id,
					user_id,
					counter,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
            VALUES (l_access_list(i),
					l_counter_prop_value_id_tbl(i),
					l_user_list(i),
					1,
					fnd_global.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					fnd_global.login_id);

Line: 332

    l_counter_prop_value_id_tbl.delete;

Line: 333

    l_user_list.delete;

Line: 334

    l_access_list.delete;

Line: 336

 END IF; -- end of process inserts

Line: 339

 UPDATE	jtm_con_request_data
 SET 	last_run_date = sysdate
 WHERE 	package_name  = 'CSM_CTR_PROP_READ_EVENT_PKG'
 AND 	procedure_name= 'REFRESH_ACC';