APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 111: FROM mtl_category_set_valid_cats

107: ( p_category_set_id NUMBER
108: , p_category_id NUMBER
109: ) IS
110: SELECT 'x'
111: FROM mtl_category_set_valid_cats
112: WHERE category_set_id = p_category_set_id
113: AND category_id = p_category_id;
114:
115: CURSOR item_cat_assign_count_csr

Line 306: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.

302:
303: -- End If Category set control level is master
304:
305: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
306: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.
307:
308: IF (l_category_set_restrict_cats = 'Y') THEN
309:
310: IF (l_debug = 1) THEN

Line 907: FROM mtl_Category_set_valid_cats VC

903: ( p_category_set_id NUMBER
904: , p_category_id NUMBER
905: ) IS
906: SELECT 'x'
907: FROM mtl_Category_set_valid_cats VC
908: WHERE VC.category_set_id = p_category_set_id
909: AND VC.category_id = p_category_id
910: AND NOT EXISTS
911: (SELECT NULL FROM mtl_Category_set_valid_cats

Line 911: (SELECT NULL FROM mtl_Category_set_valid_cats

907: FROM mtl_Category_set_valid_cats VC
908: WHERE VC.category_set_id = p_category_set_id
909: AND VC.category_id = p_category_id
910: AND NOT EXISTS
911: (SELECT NULL FROM mtl_Category_set_valid_cats
912: WHERE parent_category_id = VC.category_id
913: AND category_set_id = p_category_set_id);
914:
915: CURSOR hierarchy_and_not_validate_csr

Line 920: FROM mtl_Category_set_valid_cats

916: ( p_category_set_id NUMBER
917: , p_category_id NUMBER
918: ) IS
919: SELECT 'x'
920: FROM mtl_Category_set_valid_cats
921: WHERE category_set_id = p_category_set_id
922: AND parent_category_id = p_category_id ;
923:
924: l_exists VARCHAR2(10);

Line 1096: FROM mtl_category_set_valid_cats

1092: ( p_category_set_id NUMBER
1093: , p_category_id NUMBER
1094: ) IS
1095: SELECT 'x'
1096: FROM mtl_category_set_valid_cats
1097: WHERE category_set_id = p_category_set_id
1098: AND category_id = p_category_id;
1099:
1100:

Line 1201: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.

1197: RAISE FND_API.g_EXC_ERROR;
1198: END IF;
1199:
1200: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
1201: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.
1202: IF (l_category_set_restrict_cats = 'Y') THEN
1203: IF (l_debug = 1) THEN
1204: INV_ITEM_MSG.Debug(Mctx, 'Category Set has a restricted list of categories');
1205: INV_ITEM_MSG.Debug(Mctx, 'Validate Category Set valid category');

Line 1208: --* Validating whether new category id exists in table MTL_CATEGORY_SET_VALID_CATS

1204: INV_ITEM_MSG.Debug(Mctx, 'Category Set has a restricted list of categories');
1205: INV_ITEM_MSG.Debug(Mctx, 'Validate Category Set valid category');
1206: END IF;
1207:
1208: --* Validating whether new category id exists in table MTL_CATEGORY_SET_VALID_CATS
1209: OPEN category_set_valid_cats_csr (p_category_set_id, p_category_id);
1210: FETCH category_set_valid_cats_csr INTO l_exists;
1211: IF (category_set_valid_cats_csr%NOTFOUND) THEN
1212: CLOSE category_set_valid_cats_csr;