The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_id, application_name from fnd_application_vl;
htp.formOpen('icx_tag.update_tag_det','POST','','','NAME="enter_tag"');
select
tag_name,
application_id,
tag_description,
replacement_text,
protected
into
v_tag_name,
v_application_id,
v_tag_description,
v_replacement_text,
v_protected
from
icx_template_tags
where
tag_name = p_tag;
htp.formSelectOpen ('p_application_id');
htp.p('
htp.p('
htp.p('
htp.p('
htp.p('
htp.p('');
PROCEDURE update_tag_det (p_tag_name varchar2 ,
p_application_id number := null,
p_tag_description varchar2 := null,
p_replacement_text varchar2 :=null,
p_protected varchar2 := null) AS
-------------------------------------------------------------------
v_tag_name_exists number;
select count(*) into v_tag_name_exists from
icx_template_tags
where tag_name = p_tag_name;
UPDATE ICX_TEMPLATE_TAGS SET application_id = p_application_id,
tag_description = p_tag_description,
replacement_text = p_replacement_text,
protected = upper(p_protected),
last_updated_by = -1,
last_update_date = sysdate
WHERE tag_name = p_tag_name ;
insert into icx_template_tags(
tag_name,
application_id,
tag_description,
replacement_text,
protected,
last_updated_by,
last_update_date,
creation_date,
created_by )
values
(p_tag_name,
p_application_id,
p_tag_description,
p_replacement_text,
p_protected,
-1,
sysdate,
sysdate,
-1);
END update_tag_det;