APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSD_DP_SCENARIOS_S

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: