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 1848: FROM MTL_CATEGORY_SETS_B

1844:
1845: -- Finding whether Hierarchy is enabled or not
1846: BEGIN
1847: SELECT HIERARCHY_ENABLED, STRUCTURE_ID INTO l_hrchy_enabled, l_struct_id
1848: FROM MTL_CATEGORY_SETS_B
1849: WHERE CATEGORY_SET_ID = g_catset_id
1850: AND HIERARCHY_ENABLED = 'Y';
1851: EXCEPTION WHEN NO_DATA_FOUND THEN
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Category Set associated with Product Reporting functional area');