APPS.MSD_DP_SCENARIO_OUTPUT_LVL_PKG dependencies on MSD_DP_SCENARIO_OUTPUT_LEVELS

Line 47: from msd_dp_scenario_output_levels

43: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
44: begin
45: select LAST_UPDATED_BY, LAST_UPDATE_DATE
46: into db_luby, db_ludate
47: from msd_dp_scenario_output_levels
48: where demand_plan_id = l_demand_plan_id
49: and scenario_id = l_scenario_id
50: and level_id = p_level_id;
51:

Line 56: update msd_dp_scenario_output_levels

52: -- Test for customization and version
53: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
54: db_ludate, P_CUSTOM_MODE)) then
55: -- Update existing row
56: update msd_dp_scenario_output_levels
57: set last_update_date = f_ludate ,
58: deleteable_flag = P_DELETEABLE_FLAG ,
59: enable_nonseed_flag = P_ENABLE_NONSEED_FLAG ,
60: last_updated_by = f_luby ,

Line 70: insert into msd_dp_scenario_output_levels

66: end if;
67: exception
68: when no_data_found then
69: -- Record doesn't exist - insert in all cases
70: insert into msd_dp_scenario_output_levels
71: (DEMAND_PLAN_ID ,
72: SCENARIO_ID ,
73: LEVEL_ID ,
74: CREATION_DATE ,