APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSD_DP_PLANNING_PCT_DENORM

Line 1697: * MSD_DP_PLANNING_PCT_DENORM table.

1693:
1694:
1695: /*
1696: * This procedure export the planning percentages from Demantra to the table
1697: * MSD_DP_PLANNING_PCT_DENORM table.
1698: * The parameters are -
1699: * p_pp_export_data_profile - Export data profile used to export planning
1700: * percentages
1701: * p_fcst_export_data_profile - Export data profile used to export total demand

Line 2074: x_insert_clause := 'INSERT INTO MSD_DP_PLANNING_PCT_DENORM ( ' ||

2070: x_where_clause := x_where_clause ||
2071: ' AND exp.sdate = inp.start_time ';
2072: END IF;
2073:
2074: x_insert_clause := 'INSERT INTO MSD_DP_PLANNING_PCT_DENORM ( ' ||
2075: ' DEMAND_PLAN_ID, ' ||
2076: ' DP_SCENARIO_ID, ' ||
2077: ' DATE_FROM, ' ||
2078: ' DATE_TO, ' ||

Line 2141: DELETE FROM MSD_DP_PLANNING_PCT_DENORM

2137: END IF;
2138:
2139:
2140: /* Delete all data in the denorm for the export data profile */
2141: DELETE FROM MSD_DP_PLANNING_PCT_DENORM
2142: WHERE demand_plan_id = x_demand_plan_id
2143: AND dp_scenario_id = x_scenario_id;
2144:
2145: COMMIT;

Line 2156: 'MSD_DP_PLANNING_PCT_DENORM');

2152:
2153: msd_dem_collect_history_data.analyze_table (
2154: x_errbuf,
2155: x_retcode,
2156: 'MSD_DP_PLANNING_PCT_DENORM');
2157:
2158: x_small_sql := ' BEGIN ' || x_schema || '.dl_log_status(''' || VS_MSG_UPLOAD_PCTG || ''' , ''' ||
2159: VS_MSG_LOADED || ' ' || p_pp_export_data_profile || ''' , ''' || VS_MSG_SUCCEEDED || ''' ); END;';
2160:

Line 2452: * MSD_DP_PLANNING_PCT_DENORM table.

2448:
2449:
2450: /*
2451: * This procedure export the planning percentages from Demantra to the table
2452: * MSD_DP_PLANNING_PCT_DENORM table.
2453: * The parameters are -
2454: * p_pp_export_data_profile - Export data profile used to export planning
2455: * percentages
2456: * p_fcst_export_data_profile - Export data profile used to export total demand

Line 2884: DELETE FROM MSD_DP_PLANNING_PCT_DENORM WHERE demand_plan_id = x_demand_plan_id AND dp_scenario_id = x_scenario_id;

2880: x_demand_plan_id := C_DEMAND_PLAN_ID;
2881: x_scenario_id := x_fcst_profile_id + C_SCENARIO_ID_OFFSET;
2882:
2883: /* Delete all data in the denorm for the export data profile */
2884: DELETE FROM MSD_DP_PLANNING_PCT_DENORM WHERE demand_plan_id = x_demand_plan_id AND dp_scenario_id = x_scenario_id;
2885: COMMIT;
2886:
2887: x_insert_clause := 'INSERT INTO MSD_DP_PLANNING_PCT_DENORM ( ' ||
2888: ' DEMAND_PLAN_ID, ' ||

Line 2887: x_insert_clause := 'INSERT INTO MSD_DP_PLANNING_PCT_DENORM ( ' ||

2883: /* Delete all data in the denorm for the export data profile */
2884: DELETE FROM MSD_DP_PLANNING_PCT_DENORM WHERE demand_plan_id = x_demand_plan_id AND dp_scenario_id = x_scenario_id;
2885: COMMIT;
2886:
2887: x_insert_clause := 'INSERT INTO MSD_DP_PLANNING_PCT_DENORM ( ' ||
2888: ' DEMAND_PLAN_ID, ' ||
2889: ' DP_SCENARIO_ID, ' ||
2890: ' DATE_FROM, ' ||
2891: ' DATE_TO, ' ||

Line 3019: 'MSD_DP_PLANNING_PCT_DENORM');

3015:
3016: msd_dem_collect_history_data.analyze_table (
3017: x_errbuf,
3018: x_retcode,
3019: 'MSD_DP_PLANNING_PCT_DENORM');
3020:
3021: <>
3022: x_small_sql := ' BEGIN ' || x_schema || '.dl_log_status(''' || VS_MSG_UPLOAD_PCTG_DRCT || ''' , ''' ||
3023: VS_MSG_LOADED || ' ' || p_pp_export_data_profile || ''' , ''' || VS_MSG_SUCCEEDED || ''' ); END;';