DBA Data[Home] [Help]

APPS.OPI_DBI_RES_PKG dependencies on FND_INSTALLATION

Line 2240: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

2236:
2237: -- common clean up
2238: l_stmt_num := 20;
2239:
2240: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2241: --{
2242: execute immediate 'truncate table ' || l_opi_schema
2243: || '.opi_dbi_res_conv_rates ';
2244:

Line 2952: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

2948:
2949:
2950: l_stmt_num := 20;
2951: -- conversion rate table cleanup
2952: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2953: --{
2954:
2955: execute immediate 'truncate table ' || l_opi_schema
2956: || '.opi_dbi_res_conv_rates ';

Line 3613: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

3609:
3610:
3611: -- common clean up
3612: l_stmt_num := 20;
3613: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
3614: --{
3615: execute immediate 'truncate table ' || l_opi_schema
3616: || '.opi_dbi_res_std_f PURGE MATERIALIZED VIEW LOG';
3617: --}