APPS.MSD_DP_PRICE_LIST_PKG dependencies on MSD_DP_PRICE_LISTS

Line 41: from msd_dp_price_lists

37: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
38: begin
39: select LAST_UPDATED_BY, LAST_UPDATE_DATE
40: into db_luby, db_ludate
41: from msd_dp_price_lists
42: where DEMAND_PLAN_ID = l_demand_plan_id
43: and PRICE_LIST_NAME = P_PRICE_LIST_NAME;
44:
45: -- Test for customization and version

Line 49: update msd_dp_price_lists

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

Line 62: insert into msd_dp_price_lists

58: end if;
59: exception
60: when no_data_found then
61: -- Record doesn't exist - insert in all cases
62: insert into msd_dp_price_lists
63: (DP_PRICE_LIST_ID,
64: DEMAND_PLAN_ID ,
65: PRICE_LIST_NAME,
66: CREATION_DATE ,

Line 75: (msd_dp_price_lists_s.nextval,

71: ENABLE_NONSEED_FLAG ,
72: DELETEABLE_FLAG
73: )
74: values
75: (msd_dp_price_lists_s.nextval,
76: l_demand_plan_id ,
77: P_PRICE_LIST_NAME ,
78: f_ludate ,
79: f_luby ,