APPS.MSD_DP_EVENT_PKG dependencies on MSD_DP_EVENTS

Line 47: from msd_dp_events

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_events
48: where DEMAND_PLAN_ID = l_demand_plan_id
49: and EVENT_ID = l_event_id;
50:
51: -- Test for customization and version

Line 55: update msd_dp_events

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

Line 68: insert into msd_dp_events

64: end if;
65: exception
66: when no_data_found then
67: -- Record doesn't exist - insert in all cases
68: insert into msd_dp_events
69: (DEMAND_PLAN_ID ,
70: DP_EVENT_ID,
71: EVENT_ID,
72: CREATION_DATE ,

Line 82: msd_dp_events_s.nextval,

78: DELETEABLE_FLAG
79: )
80: values
81: (l_demand_plan_id ,
82: msd_dp_events_s.nextval,
83: l_event_id,
84: f_ludate ,
85: f_luby ,
86: f_ludate ,