APPS.MSD_DP_DIMENSION_PKG dependencies on MSD_DP_DIMENSIONS

Line 42: from msd_dp_dimensions

38: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
39: begin
40: select LAST_UPDATED_BY, LAST_UPDATE_DATE
41: into db_luby, db_ludate
42: from msd_dp_dimensions
43: where DEMAND_PLAN_ID = l_demand_plan_id
44: and DP_DIMENSION_CODE = P_DP_DIMENSION_CODE
45: and DIMENSION_CODE = P_DIMENSION_CODE;
46:

Line 51: update msd_dp_dimensions

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

Line 65: insert into msd_dp_dimensions

61: end if;
62: exception
63: when no_data_found then
64: -- Record doesn't exist - insert in all cases
65: insert into msd_dp_dimensions
66: (DEMAND_PLAN_ID ,
67: DP_DIMENSION_CODE ,
68: DIMENSION_CODE ,
69: CREATION_DATE ,