APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on FND_INSTALLATION

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

755: CHECK_OPI_MFG_CST_VAR_SETUP(errbuf,retcode);
756:
757: /* Truncating Fact Table */
758: l_stmt_num := 15;
759: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
760: --{
761: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_MFG_CST_VAR_F';
762: --}
763: END IF;

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

1010: execute immediate 'alter session disable parallel dml';
1011:
1012: /* Truncating Jobs Staging Table */
1013: l_stmt_num := 30;
1014: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1015: --{
1016: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1017: --}
1018: END IF;

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

1480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count2 || ' rows inserted');
1481:
1482: /* Truncating Jobs Staging Table */
1483: l_stmt_num := 30;
1484: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1485: --{
1486: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1487: --}
1488: END IF;

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

1537: End if;
1538:
1539: /* Truncate Current Unrecognized Variances Fact Table */
1540: l_stmt_num := 10;
1541: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1542: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_CURR_UNREC_VAR_F';
1543: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_CUV_CONV_RATES';
1544: END IF;
1545: