APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on FND_INSTALLATION

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

2981: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INIT';
2982:
2983: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2984:
2985: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2986: --{
2987: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
2988: --}
2989: END IF;

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

3235: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INCR';
3236:
3237: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3238:
3239: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
3240: --{
3241: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
3242: --}
3243: END IF;

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

4003: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4004:
4005: /* truncate all tables */
4006: l_stmt_num := 10;
4007: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
4008: --{
4009: --execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
4010: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_STD_QTY_TMP';
4011: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_STG';

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

4053: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4054:
4055: /* truncate all tables */
4056: l_stmt_num := 10;
4057: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
4058: --{
4059: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DETAILS_F';
4060: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DTL_STD_F';
4061: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_COMP_F';