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 297: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '

293: OPEN get_scn_name;
294: FETCH get_scn_name
295: INTO l_scenario_name;
296: CLOSE get_scn_name;
297: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '
298: || 'last_update_date,last_updated_by,creation_date,created_by)'
299: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var
300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
301: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;

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

295: INTO l_scenario_name;
296: CLOSE get_scn_name;
297: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '
298: || 'last_update_date,last_updated_by,creation_date,created_by)'
299: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var
300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
301: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
302:
303: 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 304: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);

300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
301: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
302:
303: INSERT INTO MSD_DP_SCENARIO_OUTPUT_LEVELS(demand_plan_id,scenario_id,level_id,last_update_date,last_updated_by,creation_date,created_by)
304: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);
305:
306: OPEN get_scn_id;
307: FETCH get_scn_id
308: INTO l_scenario_id;

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: