APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DP_SCENARIO_ENTRIES

Line 44: FROM msd_dp_scenario_entries

40: SELECT scenario_id
41: FROM msd_dp_scenarios
42: WHERE scenario_name LIKE
43: (SELECT DISTINCT(scenario_name)
44: FROM msd_dp_scenario_entries
45: WHERE scenario_id = -23453)
46: ;
47:
48: CURSOR get_scn_name IS

Line 50: FROM msd_dp_scenario_entries

46: ;
47:
48: CURSOR get_scn_name IS
49: SELECT DISTINCT(scenario_name)
50: FROM msd_dp_scenario_entries
51: WHERE scenario_id = -23453;
52:
53: CURSOR get_count_err_records(l_scenario_id NUMBER) IS
54: SELECT COUNT(*)

Line 55: FROM msd_dp_scenario_entries

51: WHERE scenario_id = -23453;
52:
53: CURSOR get_count_err_records(l_scenario_id NUMBER) IS
54: SELECT COUNT(*)
55: FROM msd_dp_scenario_entries
56: WHERE demand_plan_id = 5555555
57: AND scenario_id = l_scenario_id;
58:
59: CURSOR get_err_records IS

Line 289: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';

285: FETCH get_scn_name
286: INTO l_scenario_name;
287: CLOSE get_scn_name;
288:
289: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';
290: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_id;
291:
292: UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = l_scenario_id where scenario_name = l_scenario_name
293: and demand_plan_id = 5555555 and scenario_id = -23453;

Line 292: UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = l_scenario_id where scenario_name = l_scenario_name

288:
289: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';
290: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_id;
291:
292: UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = l_scenario_id where scenario_name = l_scenario_name
293: and demand_plan_id = 5555555 and scenario_id = -23453;
294:
295: END IF;
296:

Line 318: lv_sql_stmt1 := 'UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = MSD_DP_SCENARIOS_S.CURRVAL' || ' WHERE SCENARIO_NAME = :l_scenario_name ';

314: FETCH get_scn_id
315: INTO l_scenario_id;
316: CLOSE get_scn_id;
317:
318: lv_sql_stmt1 := 'UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = MSD_DP_SCENARIOS_S.CURRVAL' || ' WHERE SCENARIO_NAME = :l_scenario_name ';
319: log_message(lv_sql_stmt1);
320: EXECUTE IMMEDIATE lv_sql_stmt1 USING l_scenario_name;
321: END IF;
322:

Line 341: FROM msd_dp_scenario_entries mdse,

337: mdse.time_lvl_val_to,
338: mdse.total_quantity,
339: mdse.creation_date,
340: mdse.created_by
341: FROM msd_dp_scenario_entries mdse,
342: msc_trading_partners mtp,
343: msc_system_items msi
344: WHERE mdse.demand_plan_id = 5555555
345: AND mdse.scenario_id = l_scenario_id

Line 355: DELETE FROM msd_dp_scenario_entries mdse

351: AND msi.sr_instance_id = p_instance_id
352: AND msi.plan_id = -1)
353: ;
354:
355: DELETE FROM msd_dp_scenario_entries mdse
356: WHERE mdse.scenario_id = l_scenario_id
357: AND mdse.organization_lvl_val IN
358: (SELECT organization_code
359: FROM msc_trading_partners

Line 378: log_message('Records with demand_plan_id 5555555 and scenario_id '|| l_scenario_id ||' in table MSD_DP_SCENARIO_ENTRIES errored out.');

374: INTO l_err_count;
375: CLOSE get_count_err_records;
376:
377: IF l_err_count > 0 THEN
378: log_message('Records with demand_plan_id 5555555 and scenario_id '|| l_scenario_id ||' in table MSD_DP_SCENARIO_ENTRIES errored out.');
379: retcode := g_error;
380:
381: END IF;
382: