DBA Data[Home] [Help]

APPS.ICX_TAG dependencies on ICX_TEMPLATE_TAGS

Line 192: icx_template_tags

188: v_tag_description,
189: v_replacement_text,
190: v_protected
191: from
192: icx_template_tags
193: where
194: tag_name = p_tag;
195: END IF;
196:

Line 373: icx_template_tags

369: v_tag_name_exists number;
370:
371: BEGIN
372: select count(*) into v_tag_name_exists from
373: icx_template_tags
374: where tag_name = p_tag_name;
375: IF v_tag_name_exists =1 THEN
376: UPDATE ICX_TEMPLATE_TAGS SET application_id = p_application_id,
377: tag_description = p_tag_description,

Line 376: UPDATE ICX_TEMPLATE_TAGS SET application_id = p_application_id,

372: select count(*) into v_tag_name_exists from
373: icx_template_tags
374: where tag_name = p_tag_name;
375: IF v_tag_name_exists =1 THEN
376: UPDATE ICX_TEMPLATE_TAGS SET application_id = p_application_id,
377: tag_description = p_tag_description,
378: replacement_text = p_replacement_text,
379: protected = upper(p_protected),
380: last_updated_by = -1,

Line 385: insert into icx_template_tags(

381: last_update_date = sysdate
382: WHERE tag_name = p_tag_name ;
383:
384: ELSE
385: insert into icx_template_tags(
386: tag_name,
387: application_id,
388: tag_description,
389: replacement_text,