APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DP_SCENARIOS

Line 41: FROM msd_dp_scenarios

37: WHERE demand_plan_id = 5555555;
38:
39: CURSOR get_scn_id IS
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)

Line 304: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '

300: OPEN get_scn_name;
301: FETCH get_scn_name
302: INTO l_scenario_name;
303: CLOSE get_scn_name;
304: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '
305: || 'last_update_date,last_updated_by,creation_date,created_by)'
306: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var
307: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
308: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;

Line 306: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var

302: INTO l_scenario_name;
303: CLOSE get_scn_name;
304: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '
305: || 'last_update_date,last_updated_by,creation_date,created_by)'
306: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var
307: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
308: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
309:
310: INSERT INTO MSD_DP_SCENARIO_OUTPUT_LEVELS(demand_plan_id,scenario_id,level_id,last_update_date,last_updated_by,creation_date,created_by)

Line 311: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);

307: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
308: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
309:
310: INSERT INTO MSD_DP_SCENARIO_OUTPUT_LEVELS(demand_plan_id,scenario_id,level_id,last_update_date,last_updated_by,creation_date,created_by)
311: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);
312:
313: OPEN get_scn_id;
314: FETCH get_scn_id
315: INTO l_scenario_id;

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: