The following lines contain the word 'select', 'insert', 'update' or 'delete':
select category_set_id,
category_set_name
from icx_category_set_lov;
select lookup_code,
meaning
from fnd_lookups
where lookup_type = 'ICX_RELATIONS'
and enabled_flag = 'Y';
parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
parent.tail.document.Tail.submit()
}');
parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
parent.tail.document.Tail.p_category_id.value = ""
parent.tail.document.Tail.p_category_name.value = ""
parent.tail.document.Tail.submit()
}');
parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
parent.tail.document.Tail.p_category_id.value = ""
parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
parent.tail.document.Tail.submit()
}');
var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
}');
parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
parent.tail.document.Tail.p_category_id.value = cat_id
parent.tail.document.Tail.p_category_name.value = cat_name
parent.tail.document.Tail.submit()
}');
var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
}
}');
-- var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value + "^@~^and^@~^CONCATENATED_SEGMENTS<>''" + document.Category.ICX_CATEGORY.value + "''"
FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
Line: 183
htp.formSelectOption(temp_cat_set,'SELECTED','VALUE="'||temp_cat_set_id||'"');
Line: 185
htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');
Line: 189
htp.p(htf.formSelectClose||'
');
htp.p(''||htf.formSelectOpen('ICX_RELATION'));
Line: 207
htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
Line: 210
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(cat, related_cat, cat_set_id, cat_id, related_cat_id) {
if (confirm("'||icx_util.replace_quotes(FND_MESSAGE.Get)||': " + cat + " - " + related_cat)) {
open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'')
}
}');
select count(*) into l_count
from mtl_categories_kfv mck,
mtl_category_sets mcs
where (mcs.validate_flag = 'Y' and
mck.category_id in (
select mcsv.category_id
from mtl_category_set_valid_cats mcsv
where mcsv.category_set_id = p_category_set_id) and
mck.concatenated_segments = p_category_name)
or (mcs.validate_flag <> 'Y' and
mcs.structure_id = mck.structure_id and
mck.concatenated_segments = p_category_name);
select QUERY_SET into l_query_size
from ICX_PARAMETERS;
htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id||
''')',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 cat_insert(icx_category_set_id in varchar2 default null,
icx_category_id in varchar2 default null,
icx_category in varchar2 default null,
icx_relation in varchar2 default null,
icx_related_category_id in varchar2 default null,
icx_related_category in varchar2 default null) is
l_return_status varchar2(1) := 'S';
ICX_Related_Categories_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_category_set_id => icx_category_set_id ,
p_category_id => icx_category_id ,
p_category => icx_category ,
p_related_category_id => icx_category_id ,
p_related_category => icx_category ,
p_relationship_type => 'TOP' ,
p_created_by => l_user_id
);
ICX_Related_Categories_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_category_set_id => icx_category_set_id ,
p_category_id => icx_category_id ,
p_category => icx_category ,
p_related_category_id => icx_related_category_id ,
p_related_category => icx_related_category ,
p_relationship_type => 'CHILD' ,
p_created_by => l_user_id
);
end cat_insert;
procedure cat_delete(icx_category_set_id in varchar2 default null,
icx_category_id in varchar2 default null,
icx_related_category_id in varchar2 default null) is
cursor category_name is
select CONCATENATED_SEGMENTS
from icx_category_lov
where category_id = icx_category_id;
ICX_Related_Categories_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_category_set_id => icx_category_set_id ,
p_category_id => icx_category_id ,
p_related_category_id => icx_related_category_id
);
end cat_delete;