APPS.MSD_DEM_UPLOAD_FORECAST dependencies on FND_INSTALLATION

Line 1656: x_boolean := fnd_installation.get_app_info ('MSC', x_dummy1, x_dummy2, x_msc_schema_name);

1652:
1653: COMMIT;
1654:
1655: /* Get the msc schema name */
1656: x_boolean := fnd_installation.get_app_info ('MSC', x_dummy1, x_dummy2, x_msc_schema_name);
1657: msd_dem_collect_history_data.analyze_table (
1658: x_errbuf,
1659: x_retcode,
1660: x_msc_schema_name || '.MSC_DMD_SCN_METRICS');

Line 2709: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);

2705: x_sr_organization_id := ' msi.organization_id ';
2706: END IF;
2707:
2708: --truncate temp table
2709: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);
2710: x_small_sql := 'TRUNCATE table ' || var_msd_schema_name ||'.MSD_DP_PLANNING_PCT_TMP';
2711: EXECUTE IMMEDIATE x_small_sql;
2712:
2713: /* Get Time Info - BEGIN */

Line 3597: var_boolean := fnd_installation.get_app_info ('MSC', var_dummy1, var_dummy2, var_msc_schema_name);

3593: EXECUTE IMMEDIATE x_small_sql;
3594:
3595: COMMIT;
3596:
3597: var_boolean := fnd_installation.get_app_info ('MSC', var_dummy1, var_dummy2, var_msc_schema_name);
3598: msd_dem_collect_history_data.analyze_table (
3599: x_errbuf,
3600: x_retcode,
3601: var_msc_schema_name || '.MSC_DMD_SCN_METRICS');

Line 3893: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);

3889:
3890: x_large_sql := x_insert_clause || x_select_clause || x_from_clause || x_where_clause;
3891:
3892: /* Truncate data in the MSD_SPF_MATRIX_COMB table */
3893: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);
3894: x_small_sql := 'TRUNCATE table ' || var_msd_schema_name ||'.MSD_SPF_MATRIX_COMB';
3895: EXECUTE IMMEDIATE x_small_sql;
3896:
3897: /* Insert item/org combinations into MSD_SPF_MATRIX_COMB table */

Line 4109: var_boolean := fnd_installation.get_app_info ('MSC', var_dummy1, var_dummy2, var_msc_schema_name);

4105:
4106: COMMIT;
4107:
4108: /* Analyze table MSC_DMD_SCN_METRICS */
4109: var_boolean := fnd_installation.get_app_info ('MSC', var_dummy1, var_dummy2, var_msc_schema_name);
4110: msd_dem_collect_history_data.analyze_table (
4111: x_errbuf,
4112: x_retcode,
4113: var_msc_schema_name || '.MSC_DMD_SCN_METRICS');

Line 4116: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);

4112: x_retcode,
4113: var_msc_schema_name || '.MSC_DMD_SCN_METRICS');
4114:
4115: /* Analyze table MSD_DP_SCN_ENTRIES_DENORM */
4116: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);
4117: msd_dem_collect_history_data.analyze_table (
4118: x_errbuf,
4119: x_retcode,
4120: var_msd_schema_name || '.MSD_DP_SCN_ENTRIES_DENORM');