APPS.MSD_DP_SCENARIO_EVENT_PKG dependencies on MSD_DP_SCENARIO_EVENTS

Line 54: from msd_dp_scenario_events

50: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
51: begin
52: select LAST_UPDATED_BY, LAST_UPDATE_DATE
53: into db_luby, db_ludate
54: from msd_dp_scenario_events
55: where DEMAND_PLAN_ID = l_demand_plan_id
56: and SCENARIO_ID = l_scenario_id
57: and EVENT_ID = l_event_id;
58:

Line 63: update msd_dp_scenario_events

59: -- Test for customization and version
60: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
61: db_ludate, P_CUSTOM_MODE)) then
62: -- Update existing row
63: update msd_dp_scenario_events
64: set event_association_priority = p_event_association_priority,
65: last_update_date = f_ludate ,
66: deleteable_flag = P_DELETEABLE_FLAG ,
67: enable_nonseed_flag = P_ENABLE_NONSEED_FLAG ,

Line 78: insert into msd_dp_scenario_events

74: end if;
75: exception
76: when no_data_found then
77: -- Record doesn't exist - insert in all cases
78: insert into msd_dp_scenario_events
79: (DEMAND_PLAN_ID ,
80: SCENARIO_ID ,
81: EVENT_ID,
82: EVENT_ASSOCIATION_PRIORITY ,