APPS.ICX_RELATED_CATEGORIES_PUB dependencies on MTL_CATEGORY_SETS

Line 26: from mtl_category_sets

22: ) IS
23:
24: cursor l_category_set_csr is
25: select category_set_id
26: from mtl_category_sets
27: where category_set_name = p_category_set;
28:
29: cursor l_category_csr(l_cat_name in varchar2,
30: l_cat_set_id in number) is

Line 33: mtl_category_sets mcs

29: cursor l_category_csr(l_cat_name in varchar2,
30: l_cat_set_id in number) is
31: select mck.category_id
32: from mtl_categories_kfv mck,
33: mtl_category_sets mcs
34: where (mcs.validate_flag = 'Y' and
35: mck.category_id in (
36: select mcsv.category_id
37: from mtl_category_set_valid_cats mcsv

Line 195: from mtl_category_sets

191:
192: -- check category set id if it was not looked up previously
193: if p_category_set_id is not null then
194: select count(*) into l_count
195: from mtl_category_sets
196: where category_set_id = l_category_set_id;
197:
198: if l_count <> 1 then
199: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 214: mtl_category_sets mcs

210: -- check category id if it was not looked up previously
211: if p_category_id is not null then
212: select count(*) into l_count
213: from mtl_categories_kfv mck,
214: mtl_category_sets mcs
215: where (mcs.validate_flag = 'Y' and
216: mck.category_id in (
217: select mcsv.category_id
218: from mtl_category_set_valid_cats mcsv

Line 241: mtl_category_sets mcs

237: -- check related category id if it was not looked up previously
238: if p_related_category_id is not null then
239: select count(*) into l_count
240: from mtl_categories_kfv mck,
241: mtl_category_sets mcs
242: where (mcs.validate_flag = 'Y' and
243: mck.category_id in (
244: select mcsv.category_id
245: from mtl_category_set_valid_cats mcsv

Line 460: from mtl_category_sets

456: ) IS
457:
458: cursor l_category_set_csr is
459: select category_set_id
460: from mtl_category_sets
461: where category_set_name = p_category_set;
462:
463: cursor l_category_csr(l_cat_name in varchar2,
464: l_cat_set_id in number) is

Line 467: mtl_category_sets mcs

463: cursor l_category_csr(l_cat_name in varchar2,
464: l_cat_set_id in number) is
465: select mck.category_id
466: from mtl_categories_kfv mck,
467: mtl_category_sets mcs
468: where (mcs.validate_flag = 'Y' and
469: mck.category_id in (
470: select mcsv.category_id
471: from mtl_category_set_valid_cats mcsv