50: where DEMAND_PLAN_NAME = P_DEMAND_PLAN_NAME;
51:
52:
53: -- Translate owner to file_last_updated_by
54: f_luby := fnd_load_util.owner_id(P_OWNER);
55:
56: -- Translate char last_update_date to date
57: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
58: begin
62: where DEMAND_PLAN_ID = l_demand_plan_id
63: and SCENARIO_NAME = P_SCENARIO_NAME;
64:
65: -- Test for customization and version
66: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
67: db_ludate, P_CUSTOM_MODE)) then
68: -- Update existing row
69: update msd_dp_scenarios
70: set supply_plan_flag = p_supply_plan_flag,
263:
264: BEGIN
265:
266: -- Translate owner to file_last_updated_by
267: f_luby := fnd_load_util.owner_id(P_OWNER);
268:
269:
270: update msd_dp_scenarios_tl set
271: description = p_description,