eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on OE_ITEM_GROUPS

Line 27: CURSOR oe_item_groups_cur

23:
24: err_num NUMBER := 0;
25: err_msg VARCHAR2(240) := '';
26:
27: CURSOR oe_item_groups_cur
28: IS
29: SELECT *
30: FROM oe_item_groups;
31:

Line 30: FROM oe_item_groups;

26:
27: CURSOR oe_item_groups_cur
28: IS
29: SELECT *
30: FROM oe_item_groups;
31:
32: CURSOR oe_item_group_lines_cur (p_group_id NUMBER)
33: IS
34: SELECT *

Line 239: FOR l_oe_item_groups_rec IN oe_item_groups_cur

235: END;
236:
237: commit;
238:
239: FOR l_oe_item_groups_rec IN oe_item_groups_cur
240: LOOP
241:
242: SELECT mtl_category_sets_s.nextval
243: INTO l_new_category_set_id

Line 263: -- upper(l_oe_item_groups_rec.name) || '_CATEGORY_SET',

259: mult_item_cat_assign_flag
260: )
261: SELECT
262: l_new_category_set_id,
263: -- upper(l_oe_item_groups_rec.name) || '_CATEGORY_SET',
264: l_new_structure_id,
265: 'N',
266: l_control_level, --Control level is item_level
267: -- l_oe_item_groups_rec.description,

Line 267: -- l_oe_item_groups_rec.description,

263: -- upper(l_oe_item_groups_rec.name) || '_CATEGORY_SET',
264: l_new_structure_id,
265: 'N',
266: l_control_level, --Control level is item_level
267: -- l_oe_item_groups_rec.description,
268: l_oe_item_groups_rec.last_update_date,
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,

Line 268: l_oe_item_groups_rec.last_update_date,

264: l_new_structure_id,
265: 'N',
266: l_control_level, --Control level is item_level
267: -- l_oe_item_groups_rec.description,
268: l_oe_item_groups_rec.last_update_date,
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'

Line 269: l_oe_item_groups_rec.last_updated_by,

265: 'N',
266: l_control_level, --Control level is item_level
267: -- l_oe_item_groups_rec.description,
268: l_oe_item_groups_rec.last_update_date,
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

Line 270: l_oe_item_groups_rec.creation_date,

266: l_control_level, --Control level is item_level
267: -- l_oe_item_groups_rec.description,
268: l_oe_item_groups_rec.last_update_date,
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'

Line 271: l_oe_item_groups_rec.created_by,

267: -- l_oe_item_groups_rec.description,
268: l_oe_item_groups_rec.last_update_date,
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

Line 279: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET');

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');
280:
281: INSERT INTO mtl_category_sets_tl
282: (
283: category_set_id,

Line 297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',

293: SELECT
294: l_new_category_set_id,
295: l.LANGUAGE_CODE,
296: userenv('LANG'),
297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',
298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,

Line 298: substr(l_oe_item_groups_rec.description,1, 240),

294: l_new_category_set_id,
295: l.LANGUAGE_CODE,
296: userenv('LANG'),
297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',
298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,
302: l_oe_item_groups_rec.created_by

Line 299: l_oe_item_groups_rec.last_update_date,

295: l.LANGUAGE_CODE,
296: userenv('LANG'),
297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',
298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,
302: l_oe_item_groups_rec.created_by
303: FROM FND_LANGUAGES l

Line 300: l_oe_item_groups_rec.last_updated_by,

296: userenv('LANG'),
297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',
298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,
302: l_oe_item_groups_rec.created_by
303: FROM FND_LANGUAGES l
304: WHERE l.INSTALLED_FLAG IN ('I', 'B')

Line 301: l_oe_item_groups_rec.creation_date,

297: substr(upper(l_oe_item_groups_rec.name),1,15) || '_CATEGORY_SET',
298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,
302: l_oe_item_groups_rec.created_by
303: FROM FND_LANGUAGES l
304: WHERE l.INSTALLED_FLAG IN ('I', 'B')
305: AND NOT EXISTS (SELECT 'X'

Line 302: l_oe_item_groups_rec.created_by

298: substr(l_oe_item_groups_rec.description,1, 240),
299: l_oe_item_groups_rec.last_update_date,
300: l_oe_item_groups_rec.last_updated_by,
301: l_oe_item_groups_rec.creation_date,
302: l_oe_item_groups_rec.created_by
303: FROM FND_LANGUAGES l
304: WHERE l.INSTALLED_FLAG IN ('I', 'B')
305: AND NOT EXISTS (SELECT 'X'
306: FROM mtl_category_sets_tl t

Line 327: (l_oe_item_groups_rec.group_id)

323: raise;
324: END;
325:
326: FOR l_oe_item_group_lines_rec IN oe_item_group_lines_cur
327: (l_oe_item_groups_rec.group_id)
328: LOOP
329:
330: BEGIN
331: INSERT INTO mtl_item_categories

Line 388: END LOOP; /* Loop over records in oe_item_groups */

384: END LOOP; /* Loop over records in oe_item_group_lines */
385:
386: commit;
387:
388: END LOOP; /* Loop over records in oe_item_groups */
389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: err_msg := substr(sqlerrm, 1, 240);