APPS.BIS_VIEW_GENERATOR_PVT dependencies on FND_LOG

Line 2211: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2207: -- Bug 6819715
2208: -- Check the profile and database version to decide if the we need to modify some session and system settings
2209: --- and user optimizer hints
2210: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := nvl(FND_PROFILE.VALUE('BVG_OPTIMIZER_MODE'),'NEW');
2211: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2213: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2214: 'g_use_optimizer_hints is '||g_use_optimizer_hints);
2215: END IF;

Line 2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2208: -- Check the profile and database version to decide if the we need to modify some session and system settings
2209: --- and user optimizer hints
2210: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := nvl(FND_PROFILE.VALUE('BVG_OPTIMIZER_MODE'),'NEW');
2211: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2213: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2214: 'g_use_optimizer_hints is '||g_use_optimizer_hints);
2215: END IF;
2216: BEGIN

Line 2228: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2224: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9' and BIS_VIEW_GENERATOR_PVT.g_db_version > 9 then
2225: --This is the only case we want to use optimizer hints to try to mimic a 9i database
2226: --when we are not on a 9i database
2227: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9.2';
2228: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2229: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2230: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2231: 'g_use_optimizer_hints is 9.2');
2232: END IF;

Line 2229: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2225: --This is the only case we want to use optimizer hints to try to mimic a 9i database
2226: --when we are not on a 9i database
2227: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9.2';
2228: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2229: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2230: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2231: 'g_use_optimizer_hints is 9.2');
2232: END IF;
2233:

Line 2238: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2234: ELSIF BIS_VIEW_GENERATOR_PVT.g_db_version IN ('10', '11') AND BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = 'NEW' then
2235: --This mode setting will cause the Desc Flex package to use the cursor with the new order by clause
2236: --on a new install no one should be on 9.2
2237: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := 'NEW';
2238: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2240: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2241: 'g_use_optimizer_hints is NEW');
2242: END IF;

Line 2239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2235: --This mode setting will cause the Desc Flex package to use the cursor with the new order by clause
2236: --on a new install no one should be on 9.2
2237: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := 'NEW';
2238: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2240: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2241: 'g_use_optimizer_hints is NEW');
2242: END IF;
2243:

Line 2247: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2243:
2244: ELSIF BIS_VIEW_GENERATOR_PVT.g_db_version = '9' OR BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints IN ('10', '11') then
2245: --This setting cause the Desc Flex package to use the original cursor
2246: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9i';
2247: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2249: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2250: 'g_use_optimizer_hints is 9i');
2251: END IF;

Line 2248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2244: ELSIF BIS_VIEW_GENERATOR_PVT.g_db_version = '9' OR BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints IN ('10', '11') then
2245: --This setting cause the Desc Flex package to use the original cursor
2246: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9i';
2247: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2249: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2250: 'g_use_optimizer_hints is 9i');
2251: END IF;
2252: END IF;