APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on OE_ITEM_GROUP_LINES

Line 32: CURSOR oe_item_group_lines_cur (p_group_id NUMBER)

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 *
35: FROM oe_item_group_lines
36: WHERE group_id = p_group_id;

Line 35: FROM oe_item_group_lines

31:
32: CURSOR oe_item_group_lines_cur (p_group_id NUMBER)
33: IS
34: SELECT *
35: FROM oe_item_group_lines
36: WHERE group_id = p_group_id;
37:
38: BEGIN
39:

Line 326: FOR l_oe_item_group_lines_rec IN oe_item_group_lines_cur

322: p_error_module => 'Upgrade_Item_Groups');
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

Line 343: l_oe_item_group_lines_rec.inventory_item_id,

339: creation_date,
340: created_by
341: )
342: SELECT
343: l_oe_item_group_lines_rec.inventory_item_id,
344: TO_NUMBER(l_organization_id),
345: l_new_category_set_id,
346: l_new_category_id,
347: l_oe_item_group_lines_rec.last_update_date,

Line 347: l_oe_item_group_lines_rec.last_update_date,

343: l_oe_item_group_lines_rec.inventory_item_id,
344: TO_NUMBER(l_organization_id),
345: l_new_category_set_id,
346: l_new_category_id,
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

Line 348: l_oe_item_group_lines_rec.last_updated_by,

344: TO_NUMBER(l_organization_id),
345: l_new_category_set_id,
346: l_new_category_id,
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'

Line 349: l_oe_item_group_lines_rec.creation_date,

345: l_new_category_set_id,
346: l_new_category_id,
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

Line 350: l_oe_item_group_lines_rec.created_by

346: l_new_category_id,
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)

Line 364: p_id1 => 'Group Id '||to_char(l_oe_item_group_lines_rec.group_id),

360: WHEN DUP_VAL_ON_INDEX OR NO_DATA_FOUND OR VALUE_ERROR THEN
361: err_msg := substr(sqlerrm, 1, 240);
362: rollback;
363: QP_UTIL.Log_Error(
364: p_id1 => 'Group Id '||to_char(l_oe_item_group_lines_rec.group_id),
365: p_id2 => 'Inventory Item Id '||to_char(l_oe_item_group_lines_rec.inventory_item_id),
366: p_error_type => 'ITEM_GROUP',
367: p_error_desc => err_msg,
368: p_error_module => 'Upgrade_Item_Groups');

Line 365: p_id2 => 'Inventory Item Id '||to_char(l_oe_item_group_lines_rec.inventory_item_id),

361: err_msg := substr(sqlerrm, 1, 240);
362: rollback;
363: QP_UTIL.Log_Error(
364: p_id1 => 'Group Id '||to_char(l_oe_item_group_lines_rec.group_id),
365: p_id2 => 'Inventory Item Id '||to_char(l_oe_item_group_lines_rec.inventory_item_id),
366: p_error_type => 'ITEM_GROUP',
367: p_error_desc => err_msg,
368: p_error_module => 'Upgrade_Item_Groups');
369:

Line 384: END LOOP; /* Loop over records in oe_item_group_lines */

380: END;
381:
382: commit;
383:
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 */