597: db_last_update_date date;
598:
599: begin
600:
601: user_id := fnd_load_util.owner_id (X_Owner);
602:
603: select count(*)
604: into h_record_exists
605: from fa_lookups
613: from fa_lookups
614: where lookup_type = x_lookup_type
615: and lookup_code = x_lookup_code;
616:
617: if (fnd_load_util.upload_test(user_id, x_last_update_date,
618: db_last_updated_by, db_last_update_date,
619: X_CUSTOM_MODE)) then
620:
621: fa_lookups_pkg.update_row (
744: where lookup_type = x_lookup_type
745: and lookup_code = x_lookup_code
746: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
747:
748: user_id := fnd_load_util.owner_id (X_Owner);
749:
750: if (fnd_load_util.upload_test(user_id, sysdate,
751: db_last_updated_by, db_last_update_date,
752: X_CUSTOM_MODE)) then
746: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
747:
748: user_id := fnd_load_util.owner_id (X_Owner);
749:
750: if (fnd_load_util.upload_test(user_id, sysdate,
751: db_last_updated_by, db_last_update_date,
752: X_CUSTOM_MODE)) then
753:
754: update FA_LOOKUPS_TL set