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_ITEM_LOC_EVENT_PKG'
AND procedure_name = 'REFRESH_ACC';
SELECT acc.user_id,
mil.inventory_location_id,
mil.organization_id
FROM csm_inv_loc_ass_acc acc,
csp_inv_loc_assignments cila,
mtl_item_locations mil
WHERE cila.csp_inv_loc_assignment_id = acc.csp_inv_loc_assignment_id
AND mil.subinventory_code = cila.subinventory_code
AND mil.organization_id = cila.organization_id
AND NOT EXISTS
(SELECT 1
FROM csm_mtl_item_locations_acc mil_acc
WHERE mil_acc.user_id = acc.user_id
AND mil_acc.inventory_location_id = mil.inventory_location_id
AND mil_acc.organization_id = mil.organization_id
);
SELECT acc.access_id,
acc.user_id
FROM csm_mtl_item_locations_acc acc,
mtl_item_locations mil
WHERE acc.inventory_location_id = mil.inventory_location_id
AND acc.organization_id = mil.organization_id
AND mil.last_update_date > p_last_upd_date;
SELECT acc.access_id,
acc.inventory_location_id,
acc.organization_id,
acc.user_id
FROM csm_mtl_item_locations_acc acc
WHERE NOT EXISTS
(SELECT 1
FROM csm_inv_loc_ass_acc cila_acc,
csp_inv_loc_assignments cila,
mtl_item_locations mil
WHERE cila_acc.user_id = acc.user_id
AND cila_acc.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
AND mil.inventory_location_id = acc.inventory_location_id
AND mil.organization_id = acc.organization_id
AND mil.subinventory_code = cila.subinventory_code
AND mil.organization_id = cila.organization_id
);
FETCH l_last_run_date_csr INTO l_prog_update_date;
CSM_ACC_PKG.Delete_acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
,P_ACC_TABLE_NAME => g_acc_table_name1
,P_PK1_NAME => g_pk1_name1
,P_PK1_NUM_VALUE => r_mtl_item_loc_del_rec.inventory_location_id
,P_PK2_NAME => g_pk2_name1
,P_PK2_NUM_VALUE => r_mtl_item_loc_del_rec.organization_id
,P_USER_ID => r_mtl_item_loc_del_rec.user_id
);
FOR r_mtl_item_loc_upd_rec IN l_mtl_item_loc_upd_csr(l_prog_update_date) LOOP
CSM_ACC_PKG.Update_acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
,P_ACC_TABLE_NAME => g_acc_table_name1
,P_ACCESS_ID => r_mtl_item_loc_upd_rec.access_id
,P_USER_ID => r_mtl_item_loc_upd_rec.user_id
);
CSM_ACC_PKG.Insert_Acc
( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
,P_ACC_TABLE_NAME => g_acc_table_name1
,P_SEQ_NAME => g_acc_sequence_name1
,P_PK1_NAME => g_pk1_name1
,P_PK1_NUM_VALUE => r_mtl_item_loc_ins_rec.inventory_location_id
,P_PK2_NAME => g_pk2_name1
,P_PK2_NUM_VALUE => r_mtl_item_loc_ins_rec.organization_id
,P_USER_ID => r_mtl_item_loc_ins_rec.user_id
);
UPDATE jtm_con_request_data
SET last_run_date = l_run_date
WHERE package_name = 'CSM_MTL_ITEM_LOC_EVENT_PKG'
AND procedure_name = 'REFRESH_ACC';