APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSD_DEM_COLLECT_HISTORY_DATA

Line 966: msd_dem_collect_history_data.analyze_table (

962: /* Analyze Staging Table */ -- Bug#12675064
963: msd_dem_common_utilities.log_message ('Analyzing staging table ' || C_SPARE_USAGE_HISTORY_TABLE);
964: msd_dem_common_utilities.log_debug ('Begin Analyze staging table ' || C_SPARE_USAGE_HISTORY_TABLE || ' - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
965:
966: msd_dem_collect_history_data.analyze_table (
967: var_errbuf,
968: var_retcode,
969: C_SPARE_USAGE_HISTORY_TABLE);
970:

Line 1757: msd_dem_collect_history_data.analyze_table (var_errbuf, var_retcode, g_schema || '.BIIO_SPF_SPARES_HIST_DATA');

1753: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.T_SRC_SALES_TMPL';
1754:
1755: /* Analyze table BIIO_SPF_SPARES_HIST_DATA */
1756: msd_dem_common_utilities.log_message ('Analyzing table BIIO_SPF_SPARES_HIST_DATA...');
1757: msd_dem_collect_history_data.analyze_table (var_errbuf, var_retcode, g_schema || '.BIIO_SPF_SPARES_HIST_DATA');
1758: IF (var_retcode = -1)
1759: THEN
1760: retcode := -1;
1761: errbuf := var_errbuf;

Line 1763: msd_dem_common_utilities.log_message ('Error in call to msd_dem_collect_history_data.analyze_table');

1759: THEN
1760: retcode := -1;
1761: errbuf := var_errbuf;
1762: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.launch_spf_shipment_data_ff - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1763: msd_dem_common_utilities.log_message ('Error in call to msd_dem_collect_history_data.analyze_table');
1764: RETURN;
1765: END IF;
1766:
1767: msd_dem_common_utilities.log_message('--------------------------------Stage II - End----------------------------------------');

Line 3258: msd_dem_collect_history_data.analyze_table (

3254:
3255: /* Analyze Sales Staging Table */ -- doing this at end of stage 2
3256: /*msd_dem_common_utilities.log_debug ('Begin Analyze sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3257:
3258: msd_dem_collect_history_data.analyze_table (
3259: x_errbuf,
3260: x_retcode,
3261: x_dest_table);
3262:

Line 3557: msd_dem_collect_history_data.analyze_table (

3553:
3554: -- analyze table MSD_SPF_MODEL_BOM_COMPONENTS
3555: msd_dem_common_utilities.log_debug ('Begin Analyze MSD_SPF_MODEL_BOM_COMPONENTS table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3556:
3557: msd_dem_collect_history_data.analyze_table (
3558: var_errbuf,
3559: var_retcode,
3560: 'MSD_SPF_MODEL_BOM_COMPONENTS');
3561:

Line 6240: * This pocedure is wrapper on the top of the msd_dem_collect_history_data.collect_history_data procedure.

6236:
6237: END Collect_eAM_Data ;
6238: /*
6239: * This procedure will be collecting historical data of non-maintenance products
6240: * This pocedure is wrapper on the top of the msd_dem_collect_history_data.collect_history_data procedure.
6241: * Actions performed
6242: * 1. Submit "Push Setup Parameters" conc progam
6243: * 2. Call msd_dem_collect_history_data.collect_history_data procedure
6244: * 3. Update columns in t_src_sales_tmpl table

Line 6243: * 2. Call msd_dem_collect_history_data.collect_history_data procedure

6239: * This procedure will be collecting historical data of non-maintenance products
6240: * This pocedure is wrapper on the top of the msd_dem_collect_history_data.collect_history_data procedure.
6241: * Actions performed
6242: * 1. Submit "Push Setup Parameters" conc progam
6243: * 2. Call msd_dem_collect_history_data.collect_history_data procedure
6244: * 3. Update columns in t_src_sales_tmpl table
6245: * 4. Submit "Collect Level Types" conc program for items
6246: * 5. Submit "Collect Level Types" conc program for locations
6247: * 6. Check requests status

Line 6405: msd_dem_common_utilities.log_debug ('Calling msd_dem_collect_history_data.collect_history_data procedure.');

6401:
6402: /*------- START - call collect_history_data procedure -------*/
6403:
6404: msd_dem_common_utilities.log_debug (' ');
6405: msd_dem_common_utilities.log_debug ('Calling msd_dem_collect_history_data.collect_history_data procedure.');
6406: msd_dem_common_utilities.log_debug (' ');
6407:
6408: msd_dem_collect_history_data.collect_history_data (
6409: x_errbuf ,

Line 6408: msd_dem_collect_history_data.collect_history_data (

6404: msd_dem_common_utilities.log_debug (' ');
6405: msd_dem_common_utilities.log_debug ('Calling msd_dem_collect_history_data.collect_history_data procedure.');
6406: msd_dem_common_utilities.log_debug (' ');
6407:
6408: msd_dem_collect_history_data.collect_history_data (
6409: x_errbuf ,
6410: x_retcode ,
6411: p_sr_instance_id ,
6412: p_collection_group ,