DBA Data[Home] [Help]

APPS.ENI_DENORM_HRCHY dependencies on MTL_CATEGORY_SETS_B

Line 672: FROM MTL_CATEGORY_SETS_B

668:
669: -- Finding whether Hierarchy is enabled or not
670: BEGIN -- Bug# 3013192, Bug# 3306212
671: SELECT HIERARCHY_ENABLED, VALIDATE_FLAG, STRUCTURE_ID INTO l_hrchy_enabled, l_validate_flag, l_struct_id
672: FROM MTL_CATEGORY_SETS_B
673: WHERE CATEGORY_SET_ID = g_catset_id;
674: EXCEPTION WHEN NO_DATA_FOUND THEN
675: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Category Set associated with Product Reporting functional area');
676: RAISE;

Line 991: FROM MTL_CATEGORY_SETS_B

987:
988: BEGIN
989: BEGIN -- Bug# 3306212
990: SELECT VALIDATE_FLAG, STRUCTURE_ID INTO l_validate_flag, l_struct_id
991: FROM MTL_CATEGORY_SETS_B
992: WHERE CATEGORY_SET_ID = g_catset_id;
993: EXCEPTION WHEN NO_DATA_FOUND THEN
994: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Category Set associated with Product Reporting functional area');
995: RAISE;

Line 1877: FROM MTL_CATEGORY_SETS_B

1873:
1874: -- Finding whether Hierarchy is enabled or not
1875: BEGIN
1876: SELECT HIERARCHY_ENABLED, STRUCTURE_ID INTO l_hrchy_enabled, l_struct_id
1877: FROM MTL_CATEGORY_SETS_B
1878: WHERE CATEGORY_SET_ID = g_catset_id
1879: AND HIERARCHY_ENABLED = 'Y';
1880: EXCEPTION WHEN NO_DATA_FOUND THEN
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Category Set associated with Product Reporting functional area');