DBA Data[Home] [Help]

APPS.MTL_CATEGORY_SETS_PKG dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 552: FROM MTL_DEFAULT_CATEGORY_SETS

548: RETURN;
549: ELSIF(NVL(X_HIERARCHY_ENABLED,'N') ='Y' AND NVL(db_hierarchy_enabled,'N')='N' ) THEN
550: BEGIN
551: SELECT NULL INTO l_select
552: FROM MTL_DEFAULT_CATEGORY_SETS
553: WHERE FUNCTIONAL_AREA_ID NOT IN (7,11)
554: AND CATEGORY_SET_ID = x_category_set_id
555: AND ROWNUM = 1;
556: x_msg_name := 'INV_DEF_HIER_ENABLE_ERR';

Line 592: FROM MTL_DEFAULT_CATEGORY_SETS

588: RETURN;
589: ELSIF(NVL(X_HIERARCHY_ENABLED,'N') ='Y' AND NVL(db_hierarchy_enabled,'N')='N' ) THEN
590: BEGIN
591: SELECT NULL INTO l_select
592: FROM MTL_DEFAULT_CATEGORY_SETS
593: WHERE FUNCTIONAL_AREA_ID NOT IN (7,11)
594: AND CATEGORY_SET_ID = x_category_set_id
595: AND ROWNUM = 1;
596: x_msg_name := 'INV_DEF_HIER_ENABLE_ERR';