APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 112: FROM mtl_category_set_valid_cats

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

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

312:
313: -- End If Category set control level is master
314:
315: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
316: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.
317:
318: IF (l_category_set_restrict_cats = 'Y') THEN
319:
320: IF (l_debug = 1) THEN

Line 919: FROM mtl_Category_set_valid_cats VC

915: ( p_category_set_id NUMBER
916: , p_category_id NUMBER
917: ) IS
918: SELECT 'x'
919: FROM mtl_Category_set_valid_cats VC
920: WHERE VC.category_set_id = p_category_set_id
921: AND VC.category_id = p_category_id
922: AND NOT EXISTS
923: (SELECT NULL FROM mtl_Category_set_valid_cats

Line 923: (SELECT NULL FROM mtl_Category_set_valid_cats

919: FROM mtl_Category_set_valid_cats VC
920: WHERE VC.category_set_id = p_category_set_id
921: AND VC.category_id = p_category_id
922: AND NOT EXISTS
923: (SELECT NULL FROM mtl_Category_set_valid_cats
924: WHERE parent_category_id = VC.category_id
925: AND category_set_id = p_category_set_id);
926:
927: CURSOR hierarchy_and_not_validate_csr

Line 932: FROM mtl_Category_set_valid_cats

928: ( p_category_set_id NUMBER
929: , p_category_id NUMBER
930: ) IS
931: SELECT 'x'
932: FROM mtl_Category_set_valid_cats
933: WHERE category_set_id = p_category_set_id
934: AND parent_category_id = p_category_id ;
935:
936: l_exists VARCHAR2(10);

Line 1108: FROM mtl_category_set_valid_cats

1104: ( p_category_set_id NUMBER
1105: , p_category_id NUMBER
1106: ) IS
1107: SELECT 'x'
1108: FROM mtl_category_set_valid_cats
1109: WHERE category_set_id = p_category_set_id
1110: AND category_id = p_category_id;
1111:
1112:

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

1209: RAISE FND_API.g_EXC_ERROR;
1210: END IF;
1211:
1212: -- If a Category Set is defined with the VALIDATE_FLAG = 'Y' then
1213: -- a Category must belong to a list of categories in the table MTL_CATEGORY_SET_VALID_CATS.
1214: IF (l_category_set_restrict_cats = 'Y') THEN
1215: IF (l_debug = 1) THEN
1216: INV_ITEM_MSG.Debug(Mctx, 'Category Set has a restricted list of categories');
1217: INV_ITEM_MSG.Debug(Mctx, 'Validate Category Set valid category');

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

1216: INV_ITEM_MSG.Debug(Mctx, 'Category Set has a restricted list of categories');
1217: INV_ITEM_MSG.Debug(Mctx, 'Validate Category Set valid category');
1218: END IF;
1219:
1220: --* Validating whether new category id exists in table MTL_CATEGORY_SET_VALID_CATS
1221: OPEN category_set_valid_cats_csr (p_category_set_id, p_category_id);
1222: FETCH category_set_valid_cats_csr INTO l_exists;
1223: IF (category_set_valid_cats_csr%NOTFOUND) THEN
1224: CLOSE category_set_valid_cats_csr;