278: and message_name = x_message_name
279: and language = userenv('LANG');
280:
281: -- c. owners are the same, and file_date > db_date
282: if (fnd_load_util.UPLOAD_TEST(
283: p_file_id => f_luby,
284: p_file_lud => f_ludate,
285: p_db_id => db_luby,
286: p_db_lud => db_ludate,
318: FROM fnd_application
319: WHERE application_short_name = X_APP_SHORT_NAME;
320:
321: -- Translate owner to file_last_updated_by
322: f_luby := fnd_load_util.owner_id(x_owner);
323:
324: -- Translate char last_update_date to date
325: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
326:
330: where APPLICATION_ID = appid
331: and MESSAGE_NAME = X_MESSAGE_NAME;
332:
333:
334: if (fnd_load_util.UPLOAD_TEST(
335: p_file_id => f_luby,
336: p_file_lud => f_ludate,
337: p_db_id => db_luby,
338: p_db_lud => db_ludate,