APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on MTL_CATEGORY_SETS_B

Line 247: INSERT INTO mtl_category_sets_b

243: INTO l_new_category_set_id
244: FROM dual;
245:
246: BEGIN
247: INSERT INTO mtl_category_sets_b
248: (
249: category_set_id,
250: -- category_set_name,
251: structure_id,

Line 275: FROM mtl_category_sets_b b, mtl_category_sets_tl t

271: l_oe_item_groups_rec.created_by,
272: 'Y'
273: FROM dual
274: WHERE NOT EXISTS (SELECT 'X'
275: FROM mtl_category_sets_b b, mtl_category_sets_tl t
276: WHERE b.category_set_id = t.category_set_id
277: AND b.structure_id = l_new_structure_id
278: AND t.category_set_name =
279: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET');

Line 310: FROM mtl_category_sets_b b

306: FROM mtl_category_sets_tl t
307: WHERE t.category_set_id = l_new_category_set_id
308: AND t.language = l.LANGUAGE_CODE)
309: AND EXISTS (SELECT 'X'
310: FROM mtl_category_sets_b b
311: WHERE b.category_set_id = l_new_category_set_id);
312:
313: EXCEPTION
314: WHEN OTHERS THEN

Line 356: FROM mtl_category_sets_b s

352: WHERE EXISTS (SELECT 'X'
353: FROM mtl_categories_b b
354: WHERE b.category_id = l_new_category_id)
355: AND EXISTS (SELECT 'X'
356: FROM mtl_category_sets_b s
357: WHERE s.category_set_id = l_new_category_set_id);
358:
359: EXCEPTION
360: WHEN DUP_VAL_ON_INDEX OR NO_DATA_FOUND OR VALUE_ERROR THEN