DBA Data[Home] [Help]

APPS.CSM_COUNTER_READING_EVENT_PKG SQL Statements

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

Line: 32

l_prog_update_date 				jtm_con_request_data.last_run_date%TYPE;
Line: 40

SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,
	   cnt_rd.counter_value_id,
	   cnt_acc.counter_id,
   	   cnt_acc.user_id
FROM   CSI_COUNTER_READINGS cnt_rd,
       csm_counters_acc cnt_acc
where  cnt_rd.counter_id=cnt_acc.counter_id
AND	   NOT EXISTS
	   (SELECT 1 FROM csm_counter_values_acc val_acc
	    WHERE VAL_acc.counter_value_id =cnt_rd.counter_value_id);
Line: 55

SELECT val_acc.access_id,
	   val_acc.user_id
FROM   CSI_COUNTER_READINGS cnt_rd,
	   csm_counter_values_acc val_acc
where  cnt_rd.counter_id = val_acc.counter_id
AND	   cnt_rd.last_update_date 	>= p_lastrundate;
Line: 65

SELECT val_acc.access_id,
	   val_acc.user_id
FROM   CSI_COUNTER_READINGS cnt_rd,
	   csm_counter_values_acc val_acc
where  cnt_rd.counter_id = val_acc.counter_id
AND    NOT EXISTS
	   (SELECT 1 FROM csm_counters_acc cnt_acc
	    WHERE cnt_acc.counter_id =val_acc.counter_id
		AND	  cnt_acc.user_id =val_acc.user_id);
Line: 79

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

 FETCH 	l_last_run_date_csr INTO l_prog_update_date;
Line: 95

    l_access_list.delete;
Line: 102

 CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
Line: 122

     DELETE FROM csm_counter_values_acc WHERE access_id = l_access_list(i);
Line: 124

   l_access_list.delete;
Line: 125

 END IF; -- end of process deletes
Line: 127

 CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
Line: 131

 OPEN	csr_ctr_reading_upd(l_prog_update_date);
Line: 145

   l_access_list.delete;
Line: 146

 END IF; -- end of process updates
Line: 149

    l_counter_value_id_tbl.delete;
Line: 153

    l_counter_id_tbl.delete;
Line: 157

    l_user_list.delete;
Line: 161

     l_access_list.delete;
Line: 164

 CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
Line: 182

     INSERT INTO	csm_counter_values_acc
	 				(access_id,
	 				counter_value_id,
					counter_id,
					user_id,
					counter,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
            VALUES (l_access_list(i),
					l_counter_value_id_tbl(i),
					l_counter_id_tbl(i),
					l_user_list(i),
					1,
					fnd_global.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					fnd_global.login_id);
Line: 205

    l_counter_value_id_tbl.delete;
Line: 206

    l_counter_id_tbl.delete;
Line: 207

    l_user_list.delete;
Line: 208

    l_access_list.delete;
Line: 210

 END IF; -- end of process inserts
Line: 213

 UPDATE	jtm_con_request_data
 SET 	last_run_date = sysdate
 WHERE 	package_name  = 'CSM_COUNTER_READING_EVENT_PKG'
 AND 	procedure_name= 'REFRESH_ACC';
Line: 259

SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,
	   cnt_rd.counter_value_id,
	   cnt_acc.counter_id,
   	   cnt_acc.user_id
FROM   CSI_COUNTER_READINGS cnt_rd,
       csm_counters_acc cnt_acc
where  cnt_rd.counter_id=cnt_acc.counter_id
AND	   cnt_rd.counter_value_id = c_counter_value_id
AND	   cnt_acc.counter_id = c_counter_id
AND	   NOT EXISTS
	   (SELECT 1 FROM csm_counter_values_acc val_acc
	    WHERE val_acc.counter_value_id =cnt_rd.counter_value_id
		AND   val_acc.user_id =cnt_acc.user_id);
Line: 279

    l_access_list.delete;
Line: 280

    l_counter_value_id_tbl.delete;
Line: 281

    l_counter_id_tbl.delete;
Line: 282

    l_user_list.delete;
Line: 286

 CSM_UTIL_PKG.LOG('Entering Insert ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_STATEMENT);
Line: 304

     INSERT INTO	csm_counter_values_acc
	 				(access_id,
	 				counter_value_id,
					counter_id,
					user_id,
					counter,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
            VALUES (l_access_list(i),
					l_counter_value_id_tbl(i),
					l_counter_id_tbl(i),
					l_user_list(i),
					1,
					fnd_global.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					fnd_global.login_id);
Line: 327

    l_counter_value_id_tbl.delete;
Line: 328

    l_counter_id_tbl.delete;
Line: 329

    l_user_list.delete;
Line: 330

    l_access_list.delete;
Line: 332

 END IF; -- end of process insert
Line: 372

SELECT val_acc.access_id,
   	   val_acc.user_id
FROM   csm_counter_values_acc val_acc
WHERE  val_acc.counter_value_id =c_counter_value_id;
Line: 383

    l_access_list.delete;
Line: 384

    l_user_list.delete;
Line: 388

 CSM_UTIL_PKG.LOG('Entering Update Counter Value id ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_STATEMENT);
Line: 404

   l_user_list.delete;
Line: 405

   l_access_list.delete;
Line: 407

 END IF; -- end of process insert