The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Propogate_DeletedFlag IS
TYPE t_arr IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
SELECT config_hdr_id,config_rev_nbr
BULK COLLECT INTO t_cfg_id,t_cfg_nbr
FROM CZ_CONFIG_HDRS WHERE deleted_flag='1';
UPDATE CZ_CONFIG_EXT_ATTRIBUTES
SET deleted_flag='1'
WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
AND deleted_flag='0';
UPDATE CZ_CONFIG_ATTRIBUTES
SET deleted_flag='1'
WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
AND deleted_flag='0';
UPDATE CZ_CONFIG_ITEMS
SET deleted_flag='1'
WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
AND deleted_flag='0';
UPDATE CZ_CONFIG_INPUTS
SET deleted_flag='1'
WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
AND deleted_flag='0';
UPDATE CZ_CONFIG_MESSAGES
SET deleted_flag='1'
WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
AND deleted_flag='0';
PurgeDeleteConfigBatchsize NUMBER;
SELECT config_hdr_id, config_rev_nbr
FROM cz_config_hdrs
WHERE (to_be_deleted_flag = '1'
OR deleted_flag = '1') and
component_instance_type = 'R';
SELECT value
INTO PurgeDeleteConfigBatchsize
FROM cz_db_settings
WHERE setting_id = 'PurgeDeleteConfigBatchsize';
PurgeDeleteConfigBatchsize := 100;
BULK COLLECT INTO t_cfg_id, t_cfg_nbr LIMIT PurgeDeleteConfigBatchsize;
cz_cf_api.delete_configuration (
t_cfg_id(i),
t_cfg_nbr(i),
l_usage_exists,
l_error_message,
l_Return_value
);