APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_CATEGORIES

Line 2220: DELETE MTL_ITEM_CATEGORIES

2216: -- assignments for unapproved items will be supported, so only
2217: -- functional category assignments will be deleted
2218: --Bug: 3808294 If its unapproved item delete default item-cat assignments
2219: IF p_approval_status <> 'A' THEN
2220: DELETE MTL_ITEM_CATEGORIES
2221: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2222: AND ORGANIZATION_ID = p_organization_id
2223: AND CATEGORY_SET_ID IN (SELECT CATEGORY_SET_ID
2224: FROM MTL_DEFAULT_CATEGORY_SETS

Line 3956: from mtl_item_categories a

3952: l_total_count NUMBER := 0;
3953: BEGIN
3954: IF (P_CATEGORY_ID <> -1) THEN
3955: select count(*) into l_total_count
3956: from mtl_item_categories a
3957: where category_id in (
3958: select category_id
3959: from mtl_category_set_valid_cats
3960: start with category_id = P_CATEGORY_ID

Line 3968: from mtl_item_categories a

3964: and a.organization_id = P_ORGANIZATION_ID
3965: and a.category_set_id = P_CATEGORY_SET_ID;
3966: ELSE
3967: select count(*) into l_total_count
3968: from mtl_item_categories a
3969: where a.organization_id = P_ORGANIZATION_ID
3970: and a.category_set_id = P_CATEGORY_SET_ID;
3971: END IF;
3972: