APPS.INVIDSCS dependencies on MTL_ITEM_CATEGORIES

Line 4: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;

1: PACKAGE BODY INVIDSCS as
2: /* $Header: INVIDSCB.pls 120.7.12010000.3 2009/05/26 07:06:59 maychen ship $ */
3:
4: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;
5:
6: PROCEDURE CHECK_CAT_SET_MANDATORY(
7: current_cat_set_id IN NUMBER,
8: func_area_flag1 OUT NOCOPY VARCHAR2,

Line 229: insert into mtl_item_categories

225: where ood.organization_id = p.organization_id
226: and ood.inventory_enabled_flag = 'Y')*/;
227:
228: FORALL I IN l_organizations_rec.FIRST .. l_organizations_rec.LAST
229: insert into mtl_item_categories
230: (inventory_item_id,
231: category_set_id,
232: category_id,
233: last_update_date,

Line 301: update /*+ INDEX(c MTL_ITEM_CATEGORIES_U1) */

297: BEGIN
298: IF (cat_set_control_level = 1) THEN
299: BEGIN
300: /* Bug 7626142 hint syntax change */
301: update /*+ INDEX(c MTL_ITEM_CATEGORIES_U1) */
302: mtl_item_categories c
303: set c.category_id = current_cat_id,
304: c.last_update_date = sysdate,
305: c.last_updated_by = NVL(current_last_updated_by, FND_GLOBAL.USER_ID) -- Added Bug-4949084 @ 4886176

Line 302: mtl_item_categories c

298: IF (cat_set_control_level = 1) THEN
299: BEGIN
300: /* Bug 7626142 hint syntax change */
301: update /*+ INDEX(c MTL_ITEM_CATEGORIES_U1) */
302: mtl_item_categories c
303: set c.category_id = current_cat_id,
304: c.last_update_date = sysdate,
305: c.last_updated_by = NVL(current_last_updated_by, FND_GLOBAL.USER_ID) -- Added Bug-4949084 @ 4886176
306: where c.inventory_item_id = current_inv_item_id

Line 532: delete from mtl_item_categories c

528: So, during Deleting need to use all these 4 column values to delete
529: a single assignment.
530: */
531:
532: delete from mtl_item_categories c
533: where c.inventory_item_id = current_inv_item_id
534: and c.category_set_id = current_cat_set_id
535: and c.category_id = current_cat_id
536: and c.organization_id in