DBA Data[Home] [Help]

APPS.ENI_DENORM_HRCHY dependencies on FND_PROFILE

Line 1874: fnd_profile.get('ENI_ICAT_DENORM_LEVEL', l_levels_to_flatten);

1870:
1871: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_tab_schema || '.ENI_ICAT_CDENORM_HIERARCHIES';
1872:
1873: --Fetch the profile value for No of levels to flatten
1874: fnd_profile.get('ENI_ICAT_DENORM_LEVEL', l_levels_to_flatten);
1875:
1876: IF l_levels_to_flatten IS NULL or l_levels_to_flatten > 10 or l_levels_to_flatten < 5 THEN
1877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile [ENI: SBA/OBIEE LEVELS IN HIERARCHY] has incorrect value of: [' || l_levels_to_flatten || ']');
1878: FND_FILE.PUT_LINE(FND_FILE.LOG,'Setting the denormalisation to default level of 5');