DBA Data[Home] [Help]

APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSD_DEM_COLLECT_HISTORY_DATA

Line 1439: msd_dem_collect_history_data.analyze_table (

1435: END IF;
1436:
1437: COMMIT;
1438:
1439: msd_dem_collect_history_data.analyze_table (
1440: x_errbuf,
1441: x_retcode,
1442: 'MSD_DP_SCN_ENTRIES_DENORM');
1443:

Line 1657: msd_dem_collect_history_data.analyze_table (

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

Line 2153: msd_dem_collect_history_data.analyze_table (

2149: x_num_rows := SQL%ROWCOUNT;
2150:
2151: COMMIT;
2152:
2153: msd_dem_collect_history_data.analyze_table (
2154: x_errbuf,
2155: x_retcode,
2156: 'MSD_DP_PLANNING_PCT_DENORM');
2157:

Line 2290: msd_dem_collect_history_data.analyze_table (

2286: WHERE scenario_id = x_dep_scenario_id;
2287: COMMIT;
2288:
2289:
2290: msd_dem_collect_history_data.analyze_table (
2291: x_errbuf,
2292: x_retcode,
2293: 'MSD_DP_SCN_ENTRIES_DENORM');
2294:

Line 3016: msd_dem_collect_history_data.analyze_table (

3012: END IF;
3013:
3014: CLOSE EXP_VIEW;
3015:
3016: msd_dem_collect_history_data.analyze_table (
3017: x_errbuf,
3018: x_retcode,
3019: 'MSD_DP_PLANNING_PCT_DENORM');
3020:

Line 3598: msd_dem_collect_history_data.analyze_table (

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

Line 4110: msd_dem_collect_history_data.analyze_table (

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

Line 4117: msd_dem_collect_history_data.analyze_table (

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

Line 5211: msd_dem_collect_history_data.analyze_table (

5207: WHERE scenario_id = x_wod_scenario_id;
5208:
5209: COMMIT;
5210:
5211: msd_dem_collect_history_data.analyze_table (
5212: x_errbuf,
5213: x_retcode,
5214: 'MSD_DP_SCN_ENTRIES_DENORM');
5215: