312: db_luby number; -- entity owner in db
313: db_ludate date; -- entity update date in db
314: begin
315: -- Translate owner to file_last_updated_by
316: f_luby := fnd_load_util.owner_id(x_owner);
317:
318: -- Translate char last_update_date to date
319: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
320: begin
325: and CONCURRENT_PROGRAM_NAME = x_concurrent_program_name
326: and ELEMENT_NAME = x_element_name;
327:
328: -- Test for customization and version
329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
330: db_ludate, x_custom_mode)) then
331: -- Update existing row
332: FRM_REP_TEMPLATE_ALIASES_PKG.Update_Row(
333: X_APPLICATION_SHORT_NAME => x_application_short_name,
389: db_luby number; -- entity owner in db
390: db_ludate date; -- entity update date in db
391: begin
392: -- Translate owner to file_last_updated_by
393: f_luby := fnd_load_util.owner_id(x_owner);
394:
395: -- Translate char last_update_date to date
396: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
397: begin
403: and ELEMENT_NAME = x_element_name
404: and LANGUAGE = userenv('LANG');
405:
406: -- Test for customization and version
407: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
408: db_ludate, x_custom_mode)) then
409:
410: update FRM_REP_TEMPLATE_ALIASES_TL
411: set USER_NAME = x_user_name,