DBA Data[Home] [Help]

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 2008/02/20 10:44:52 arattan 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 300: update mtl_item_categories c

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

Line 301: /*+ INDEX MTL_ITEM_CATEGORIES MTL_ITEM_CATEGORIES_U1 */

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

Line 531: delete from mtl_item_categories c

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