The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
SELECT nvl(last_run_date, (sysdate - 365*50))
FROM jtm_con_request_data
WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
AND procedure_name = 'REFRESH_ACC';
SELECT mtlp.organization_id
FROM mtl_parameters mtlp
WHERE NOT EXISTS
(SELECT 1
FROM csm_mtl_parameters_acc acc
WHERE acc.organization_id = mtlp.organization_id
);
SELECT acc.access_id, mtlp.organization_id
FROM mtl_parameters mtlp,
csm_mtl_parameters_acc acc
WHERE (mtlp.creation_date < p_last_upd_date AND mtlp.last_update_date > p_last_upd_date)
AND acc.organization_id = mtlp.organization_id;
SELECT acc.access_id, acc.organization_id
FROM csm_mtl_parameters_acc acc
WHERE NOT EXISTS
(SELECT 1
FROM mtl_parameters mtlp
WHERE mtlp.organization_id = acc.organization_id
);
FETCH l_last_run_date_csr INTO l_prog_update_date;
DELETE FROM csm_mtl_parameters_acc WHERE access_id = l_access_id;
FOR r_mtl_parameters_upd_rec IN l_mtl_parameters_upd_csr(l_prog_update_date) LOOP
--get the users with this language
l_all_omfs_palm_resource_list := l_null_resource_list;
SELECT csm_mtl_parameters_acc_s.nextval
INTO l_access_id
FROM dual;
INSERT INTO csm_mtl_parameters_acc (access_id,
organization_id,
counter,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (l_access_id,
r_mtl_parameters_ins_rec.organization_id,
1,
fnd_global.user_id,
l_run_date,
fnd_global.user_id,
l_run_date,
fnd_global.login_id
);
UPDATE jtm_con_request_data
SET last_run_date = l_run_date
WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
AND procedure_name = 'REFRESH_ACC';