APPS.MSD_DP_CALENDAR_PKG dependencies on MSD_DP_CALENDARS

Line 43: from msd_dp_calendars

39: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
40: begin
41: select LAST_UPDATED_BY, LAST_UPDATE_DATE
42: into db_luby, db_ludate
43: from msd_dp_calendars
44: where DEMAND_PLAN_ID = l_demand_plan_id
45: and CALENDAR_TYPE = P_CALENDAR_TYPE
46: and CALENDAR_CODE = P_CALENDAR_CODE;
47:

Line 52: update msd_dp_calendars

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

Line 66: insert into msd_dp_calendars

62: end if;
63: exception
64: when no_data_found then
65: -- Record doesn't exist - insert in all cases
66: insert into msd_dp_calendars
67: (DEMAND_PLAN_ID ,
68: CALENDAR_TYPE ,
69: CALENDAR_CODE ,
70: CREATION_DATE ,