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 282: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';

278: FETCH get_scn_name
279: INTO l_scenario_name;
280: CLOSE get_scn_name;
281:
282: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';
283: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_id;
284:
285: UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = l_scenario_id where scenario_name = l_scenario_name
286: and demand_plan_id = 5555555 and scenario_id = -23453;

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

281:
282: lv_sql_stmt := 'DELETE FROM MSD_DP_SCENARIO_ENTRIES WHERE demand_plan_id = 5555555 and scenario_id = :l_scenario_id';
283: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_id;
284:
285: UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = l_scenario_id where scenario_name = l_scenario_name
286: and demand_plan_id = 5555555 and scenario_id = -23453;
287:
288: END IF;
289:

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

307: FETCH get_scn_id
308: INTO l_scenario_id;
309: CLOSE get_scn_id;
310:
311: lv_sql_stmt1 := 'UPDATE MSD_DP_SCENARIO_ENTRIES SET SCENARIO_ID = MSD_DP_SCENARIOS_S.CURRVAL' || ' WHERE SCENARIO_NAME = :l_scenario_name ';
312: log_message(lv_sql_stmt1);
313: EXECUTE IMMEDIATE lv_sql_stmt1 USING l_scenario_name;
314: END IF;
315:

Line 334: FROM msd_dp_scenario_entries mdse,

330: mdse.time_lvl_val_to,
331: mdse.total_quantity,
332: mdse.creation_date,
333: mdse.created_by
334: FROM msd_dp_scenario_entries mdse,
335: msc_trading_partners mtp,
336: msc_system_items msi
337: WHERE mdse.demand_plan_id = 5555555
338: AND mdse.scenario_id = l_scenario_id

Line 348: DELETE FROM msd_dp_scenario_entries mdse

344: AND msi.sr_instance_id = p_instance_id
345: AND msi.plan_id = -1)
346: ;
347:
348: DELETE FROM msd_dp_scenario_entries mdse
349: WHERE mdse.scenario_id = l_scenario_id
350: AND mdse.organization_lvl_val IN
351: (SELECT organization_code
352: FROM msc_trading_partners

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

367: INTO l_err_count;
368: CLOSE get_count_err_records;
369:
370: IF l_err_count > 0 THEN
371: log_message('Records with demand_plan_id 5555555 and scenario_id '|| l_scenario_id ||' in table MSD_DP_SCENARIO_ENTRIES errored out.');
372: retcode := g_error;
373:
374: END IF;
375: