eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_VIEW_GENERATOR_PVT dependencies on BIS_VIEW_GENERATOR_PVT

Line 1: PACKAGE BODY bis_view_generator_pvt AS

1: PACKAGE BODY bis_view_generator_pvt AS
2: /* $Header: BISTBVGB.pls 120.2 2008/04/23 17:07:24 dbowles ship $ */
3:
4: -- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5: --- All rights reserved.

Line 47: G_PKG_NAME CONSTANT VARCHAR2(60) :='BIS_VIEW_GENERATOR_PVT';

43: --============================================================================
44: -- CONSTANTS
45: --============================================================================
46:
47: G_PKG_NAME CONSTANT VARCHAR2(60) :='BIS_VIEW_GENERATOR_PVT';
48:
49: g_newline CONSTANT VARCHAR2(1):='
50: ';
51:

Line 1786: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints||' database version is '||

1782: END LOOP;
1783: -- Bug 6819715
1784: -- add a comment on the view itself to document the optimizer mode used and the RDBMS major verion number.
1785: l_comment_table_stmt := 'COMMENT ON TABLE ' ||p_view_name|| ' IS '' optimizer mode is '||
1786: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints||' database version is '||
1787: g_db_version||'''';
1788: BEGIN
1789: EXECUTE IMMEDIATE l_comment_table_stmt;
1790: EXCEPTION

Line 2162: BIS_VIEW_GENERATOR_PVT.g_debug_file := ('Debug file - ' || l_debug_file);

2158: --
2159: BEGIN
2160: -- only dbms_output allowed in the whole program
2161: --dbms_output.put_line('Debug file - ' || l_debug_file);
2162: BIS_VIEW_GENERATOR_PVT.g_debug_file := ('Debug file - ' || l_debug_file);
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: NULL;
2166: END;

Line 2182: ( p_error_msg_name => bis_view_generator_pvt.GENERATOR_NO_VIEWS

2178: --
2179: IF (l_View_Table.count = 0)
2180: THEN
2181: BIS_VG_UTIL.Add_Error_message
2182: ( p_error_msg_name => bis_view_generator_pvt.GENERATOR_NO_VIEWS
2183: , p_error_proc_name => G_PKG_NAME||'.generate_Views'
2184: , p_error_table => l_error_tbl
2185: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2186: , x_error_table => l_error_tbl

Line 2210: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := nvl(FND_PROFILE.VALUE('BVG_OPTIMIZER_MODE'),'NEW');

2206: BEGIN --- BLOCK inside IF enumerate-without-generate mode
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);

Line 2217: SELECT substrb(version, 1, instrb(version,'.') -1) into BIS_VIEW_GENERATOR_PVT.g_db_version

2213: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2214: 'g_use_optimizer_hints is '||g_use_optimizer_hints);
2215: END IF;
2216: BEGIN
2217: SELECT substrb(version, 1, instrb(version,'.') -1) into BIS_VIEW_GENERATOR_PVT.g_db_version
2218: FROM product_component_version
2219: WHERE upper(product) like 'ORACLE';
2220: EXCEPTION
2221: WHEN OTHERS THEN

Line 2222: BIS_VIEW_GENERATOR_PVT.g_db_version := '10';

2218: FROM product_component_version
2219: WHERE upper(product) like 'ORACLE';
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: BIS_VIEW_GENERATOR_PVT.g_db_version := '10';
2223: END;
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

Line 2224: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9' and BIS_VIEW_GENERATOR_PVT.g_db_version > 9 then

2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: BIS_VIEW_GENERATOR_PVT.g_db_version := '10';
2223: END;
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

Line 2227: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9.2';

2223: END;
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');

Line 2234: ELSIF BIS_VIEW_GENERATOR_PVT.g_db_version IN ('10', '11') AND BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = 'NEW' then

2230: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2231: 'g_use_optimizer_hints is 9.2');
2232: END IF;
2233:
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

Line 2237: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := 'NEW';

2233:
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');

Line 2244: ELSIF BIS_VIEW_GENERATOR_PVT.g_db_version = '9' OR BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints IN ('10', '11') then

2240: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2241: 'g_use_optimizer_hints is NEW');
2242: END IF;
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,

Line 2246: BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints := '9i';

2242: END IF;
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');

Line 2253: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9.2'then

2249: 'fnd.plsql.BIS_VG_PVT.GENERATE_VIEWS',
2250: 'g_use_optimizer_hints is 9i');
2251: END IF;
2252: END IF;
2253: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9.2'then
2254: -- execute immediate v_shared_pool;
2255: execute immediate v_session_sort;
2256: END IF;
2257: -- END BUG 6819715

Line 2469: bis_debug_pub.add('bis_view_generator_pvt.set_mode');

2465: bis_debug_pub.Add('< set_mode');
2466: EXCEPTION
2467: WHEN OTHERS THEN
2468: bis_debug_pub.debug_on;
2469: bis_debug_pub.add('bis_view_generator_pvt.set_mode');
2470: bis_debug_pub.debug_off;
2471: fnd_msg_pub.Add_Exc_Msg( 'bis_view_generator_pvt'
2472: , 'set_mode'
2473: );

Line 2471: fnd_msg_pub.Add_Exc_Msg( 'bis_view_generator_pvt'

2467: WHEN OTHERS THEN
2468: bis_debug_pub.debug_on;
2469: bis_debug_pub.add('bis_view_generator_pvt.set_mode');
2470: bis_debug_pub.debug_off;
2471: fnd_msg_pub.Add_Exc_Msg( 'bis_view_generator_pvt'
2472: , 'set_mode'
2473: );
2474: RAISE;
2475: --

Line 2509: END bis_view_generator_pvt;

2505: );
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: END set_mode;
2508:
2509: END bis_view_generator_pvt;
2510: