DBA Data[Home] [Help]

APPS.ICX_TAG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 110

 select application_id, application_name from fnd_application_vl;
Line: 174

 htp.formOpen('icx_tag.update_tag_det','POST','','','NAME="enter_tag"');
Line: 179

  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;
Line: 215

        htp.formSelectOpen ('p_application_id');
Line: 222

          htp.p('
Line: 225

                        htp.p('
Line: 230

        htp.p('
Line: 253

	htp.p('');
Line: 363

 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;
Line: 372

select count(*) into v_tag_name_exists from
	icx_template_tags
	where tag_name = p_tag_name;
Line: 376

   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     ;
Line: 385

   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);
Line: 412

END update_tag_det;