331: -- if p_category_id is null then check that p_category_name is valid
332: if p_category_id is null then
333:
334: select count(*) into l_count 335: from mtl_categories_kfv mck, 336: mtl_category_sets mcs
337: where (mcs.validate_flag = 'Y' and
338: mck.category_id in (
339: select mcsv.category_id