APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on DUAL

Line 161: FROM dual;

157: l_user_id := FND_GLOBAL.USER_ID;
158:
159: SELECT mtl_categories_s.nextval
160: INTO l_new_category_id
161: FROM dual;
162:
163: BEGIN
164: INSERT INTO mtl_categories_b
165: (

Line 188: FROM dual

184: -- l_description,
185: 'N',
186: l_enabled_flag, -- whether segment combination is enabled
187: 'Item Category for Item Groups'
188: FROM dual
189: WHERE NOT EXISTS (SELECT 'X'
190: FROM mtl_categories_b b
191: WHERE b.structure_id = l_new_structure_id
192: AND b.segment1 = 'Item Category for Item Groups');

Line 244: FROM dual;

240: LOOP
241:
242: SELECT mtl_category_sets_s.nextval
243: INTO l_new_category_set_id
244: FROM dual;
245:
246: BEGIN
247: INSERT INTO mtl_category_sets_b
248: (

Line 273: FROM dual

269: l_oe_item_groups_rec.last_updated_by,
270: l_oe_item_groups_rec.creation_date,
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

Line 351: FROM dual

347: l_oe_item_group_lines_rec.last_update_date,
348: l_oe_item_group_lines_rec.last_updated_by,
349: l_oe_item_group_lines_rec.creation_date,
350: l_oe_item_group_lines_rec.created_by
351: FROM dual
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'