The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
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);
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;
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);
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';
FETCH l_last_run_date_csr INTO l_prog_update_date;
l_access_list.delete;
CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);
DELETE FROM csm_counter_values_acc WHERE access_id = l_access_list(i);
l_access_list.delete;
END IF; -- end of process deletes
CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
OPEN csr_ctr_reading_upd(l_prog_update_date);
l_access_list.delete;
END IF; -- end of process updates
l_counter_value_id_tbl.delete;
l_counter_id_tbl.delete;
l_user_list.delete;
l_access_list.delete;
CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_COUNTER_READING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
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);
l_counter_value_id_tbl.delete;
l_counter_id_tbl.delete;
l_user_list.delete;
l_access_list.delete;
END IF; -- end of process inserts
UPDATE jtm_con_request_data
SET last_run_date = sysdate
WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'
AND procedure_name= 'REFRESH_ACC';
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);
l_access_list.delete;
l_counter_value_id_tbl.delete;
l_counter_id_tbl.delete;
l_user_list.delete;
CSM_UTIL_PKG.LOG('Entering Insert ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_INS',FND_LOG.LEVEL_STATEMENT);
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);
l_counter_value_id_tbl.delete;
l_counter_id_tbl.delete;
l_user_list.delete;
l_access_list.delete;
END IF; -- end of process insert
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;
l_access_list.delete;
l_user_list.delete;
CSM_UTIL_PKG.LOG('Entering Update Counter Value id ', 'CSM_COUNTER_READING_EVENT_PKG.COUNTER_VALUE_ACC_UPD',FND_LOG.LEVEL_STATEMENT);
l_user_list.delete;
l_access_list.delete;
END IF; -- end of process insert