35:
36: CURSOR c_mult_item_flag (cp_cat_set_id NUMBER)
37: IS
38: SELECT mult_item_cat_assign_flag
39: FROM mtl_category_sets_b
40: WHERE category_set_id = cp_cat_set_id;
41:
42: l_category_id NUMBER := 0;
43: l_old_category_id NUMBER;
254: AND set_process_id = g_xset_id
255: AND ( i.organization_id = org_id OR all_org = l_All_Org )
256: AND (
257: (NOT EXISTS (select m.category_set_id
258: from mtl_category_sets_b m
259: where m.category_set_id = i.category_set_id )
260: )
261: OR
262: (NOT EXISTS (select m.category_id
260: )
261: OR
262: (NOT EXISTS (select m.category_id
263: from mtl_categories_b m,
264: mtl_category_sets_b ms
265: where m.category_id = i.category_id
266: and m.structure_id = ms.structure_id
267: and i.category_set_id = ms.category_set_id)
268: )
731: BEGIN
732: -- bug 3500492
733: IF l_structure_id IS NULL THEN
734: SELECT structure_id INTO l_structure_id
735: FROM mtl_category_sets_b
736: WHERE category_set_id = l_category_set_id;
737: END IF;
738: SELECT category_id INTO l_category_id
739: FROM mtl_categories_b_kfv