The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like p_type||':%';
select min(to_number(substr(iav.name
,instr(iav.name,':',1,2) + 1)))
from wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like p_type||':%'
and to_number(substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2)
- instr(iav.name,':') - 1))
= p_transaction_step_id
and iav.text_value IS NULL;
select iav.text_value
from hr_api_transaction_steps hats
,wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like p_type||':%'
and hats.activity_id = p_actid
and hats.transaction_step_id =
to_number(substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
/* select iav.text_value
from hr_api_transaction_steps hats
,wf_item_attribute_values iav
where hats.activity_id = p_actid
and hats.item_type = p_item_type
and hats.item_key = p_item_key
and iav.name like p_type||':%'
and hats.transaction_step_id =
to_number(substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
select iav.text_value
from hr_api_transaction_steps hats
,wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like p_type||':%'
and hats.activity_id = p_actid
and hats.transaction_step_id = p_transaction_step_id
and hats.transaction_step_id =
to_number(substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
/*select iav.text_value
from hr_api_transaction_steps hats
,wf_item_attribute_values iav
where hats.activity_id = p_actid
and hats.item_type = p_item_type
and hats.item_key = p_item_key
and iav.name like p_type||':%'
and hats.transaction_step_id = p_transaction_step_id
and hats.transaction_step_id =
to_number(substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));
SELECT iav.name
FROM wf_item_attribute_values iav,
hr_api_transaction_steps hats
WHERE iav.item_type = hats.item_type
AND iav.item_key = hats.item_key
AND (iav.name LIKE 'ERROR_TEXT:%'
OR iav.name LIKE 'WARNING_TEXT:%')
AND TO_NUMBER(SUBSTR(iav.name,
INSTR (iav.name, ':') + 1,
INSTR (iav.name, ':', 1, 2) - INSTR (iav.name, ':') - 1)) =
hats.transaction_step_id
AND hats.item_type = p_item_type
AND hats.item_key = p_item_key
AND hats.activity_id = p_actid;
select iav.name
from wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like 'ERROR_TEXT'||':%'
or iav.name like 'WARNING_TEXT'||':%'
and to_number(
substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1
)
) in
(select hats.transaction_step_id
from hr_api_transaction_steps hats
where hats.item_type = p_item_type
and hats.item_key = p_item_key
and hats.activity_id = p_actid);*/
SELECT iav.name
FROM wf_item_attribute_values iav
WHERE iav.item_type = p_item_type
AND iav.item_key = p_item_key
AND (iav.name LIKE 'ERROR_TEXT:%'
OR iav.name LIKE 'WARNING_TEXT:%')
AND TO_NUMBER(SUBSTR(iav.name,
INSTR(iav.name, ':') + 1,
INSTR(iav.name, ':', 1, 2) - INSTR(iav.name, ':') - 1)) =
p_transaction_step_id;
select iav.name
from wf_item_attribute_values iav
where iav.item_type = p_item_type
and iav.item_key = p_item_key
and iav.name like 'ERROR_TEXT'||':%'
or iav.name like 'WARNING_TEXT'||':%'
and to_number(
substr(iav.name
,instr(iav.name,':') + 1
,instr(iav.name,':',1,2) - instr(iav.name,':') - 1
)
) = p_transaction_step_id; */