The following lines contain the word 'select', 'insert', 'update' or 'delete':
select lookup_code,
meaning
from fnd_lookups
where lookup_type = 'ICX_RELATIONS'
and enabled_flag = 'Y';
if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {');
htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
htp.p(''||htf.formSelectOpen('ICX_RELATION'));
Line: 168
htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
Line: 171
htp.p(htf.formSelectClose||'
');
select substr(temp_text,12,512) into err_mesg from dual;
-- javascript function to confirm delete of relationship
FND_MESSAGE.Set_name('ICX','ICX_DELETE');
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'')
}
}');
select count(*) into l_count
from po_reqexpress_headers
where express_name = p_template;
select QUERY_SET into l_query_size
from ICX_PARAMETERS;
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"'));
select substr(temp_text,12,512) into err_mesg from dual;
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';
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
);
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
);
end template_insert;
procedure template_delete(icx_template1 in varchar2 default null,
icx_related_template in varchar2 default null) is
l_return_status varchar2(1) := 'S';
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
);
end template_delete;