APPS.MSD_DP_HIERARCHY_PKG dependencies on MSD_DP_HIERARCHIES

Line 42: from msd_dp_hierarchies

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_hierarchies
43: where DEMAND_PLAN_ID = l_demand_plan_id
44: and HIERARCHY_ID = P_HIERARCHY_ID;
45:
46: -- Test for customization and version

Line 50: update msd_dp_hierarchies

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

Line 64: insert into msd_dp_hierarchies

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