APPS.ICX_TEMPLATE_HEIRARCHY SQL Statements

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

Line: 44

select lookup_code,
       meaning
from   fnd_lookups
where  lookup_type = 'ICX_RELATIONS'
and    enabled_flag = 'Y';

Line: 118

		  if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {');

Line: 138

    htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');

Line: 163

      htp.p(''||htf.formSelectOpen('ICX_RELATION'));

Line: 168

	    htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');

Line: 171

      htp.p(htf.formSelectClose||'');

Line: 212

    select substr(temp_text,12,512) into err_mesg from dual;

Line: 271

	    -- javascript function to confirm delete of relationship
 	    FND_MESSAGE.Set_name('ICX','ICX_DELETE');

Line: 273

            htp.p('function delete_relation(template, related_template, html_template, html_related_template) {
              if (confirm("'||icx_util.replace_onMouseOver_quotes(FND_MESSAGE.Get)||': " + template + " - " + related_template)) {
                  open('''||l_agent||'/ICX_TEMPLATE_HEIRARCHY.template_delete?icx_template1='' + html_template + ''&icx_related_template='' + html_related_template,''tail'')
              }
            }');

Line: 292

    select count(*) into l_count
    from po_reqexpress_headers
    where express_name = p_template;

Line: 314

        select QUERY_SET into l_query_size
        from ICX_PARAMETERS;

Line: 432

            htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''',
'''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')',
htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'',
'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"'));

Line: 489

    select substr(temp_text,12,512) into err_mesg from dual;

Line: 498

procedure template_insert(icx_template1 in varchar2 default null,
		          icx_relation in varchar2 default null,
		          icx_related_template in varchar2 default null) is

l_return_status  varchar2(1) := 'S';

Line: 515

        ICX_Related_Templates_PUB.Insert_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_TRUE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_template		=> icx_template1		,
          p_related_template	=> icx_template1		,
          p_relationship_type	=> 'TOP'			,
          p_created_by		=> l_user_id
        );

Line: 535

        ICX_Related_Templates_PUB.Insert_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_FALSE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_template		=> icx_template1			,
          p_related_template	=> icx_related_template		,
          p_relationship_type	=> 'CHILD'			,
          p_created_by		=> l_user_id
        );

Line: 568

end template_insert;

Line: 572

procedure template_delete(icx_template1 in varchar2 default null,
		          icx_related_template in varchar2 default null) is

l_return_status  varchar2(1) := 'S';

Line: 590

        ICX_Related_Templates_PUB.Delete_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_TRUE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_template		=> l_icx_template1		,
          p_related_template	=> l_icx_related_template
        );

Line: 619

end template_delete;