The following lines contain the word 'select', 'insert', 'update' or 'delete':
if l_type is null or l_type <> 'IEU_UPDATE_ENABLED' then
if (length(l_action_param3) is null) then
l_action_param3:= l_action_param3||l_name||'=['||l_value||']';
if l_type = 'IEU_UPDATE_ENABLED' then /* Store all the update enabled
types to table of records */
p_ieu_media_data1(i).param_name := l_name;
/* maximum length of workitemid, occtmediaitemid and all non-update enbaled types */
max_length := length(l_action_param1) + length(l_action_param2) +
length(l_action_param3);
if l_type = 'IEU_UPDATE_ENABLED' then
if max_length < 1950 then
if (length(l_action_param4) is null) then
l_action_param4:= l_action_param4||l_name||'=['||l_value||']';
end if; /* IEU_UPDATE_ENABLED */