43: where EVENT_NAME = P_EVENT_NAME;
44:
45:
46: -- Translate owner to file_last_updated_by
47: f_luby := fnd_load_util.owner_id(P_OWNER);
48:
49: -- Translate char last_update_date to date
50: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
51: begin
56: and SCENARIO_ID = l_scenario_id
57: and EVENT_ID = l_event_id;
58:
59: -- Test for customization and version
60: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
61: db_ludate, P_CUSTOM_MODE)) then
62: -- Update existing row
63: update msd_dp_scenario_events
64: set event_association_priority = p_event_association_priority,