DBA Data[Home] [Help]

APPS.ENI_DENORM_HRCHY dependencies on FND_PROFILE

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

1899:
1900: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_tab_schema || '.ENI_ICAT_CDENORM_HIERARCHIES';
1901:
1902: --Fetch the profile value for No of levels to flatten
1903: fnd_profile.get('ENI_ICAT_DENORM_LEVEL', l_levels_to_flatten);
1904:
1905: IF l_levels_to_flatten IS NULL or l_levels_to_flatten > 10 or l_levels_to_flatten < 5 THEN
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile [ENI: SBA/OBIEE LEVELS IN HIERARCHY] has incorrect value of: [' || l_levels_to_flatten || ']');
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,'Setting the denormalisation to default level of 5');