656: db_luby number; -- entity owner in db
657: db_ludate date; -- entity update date in db
658:
659: begin
660: f_luby := fnd_load_util.owner_id(X_OWNER);
661: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
662:
663: -- bug3703523
664: -- for old see data we have last_updated_by as -1.
674: and ( (X_ORG_ID is null and org_id = -3113 )
675: or (X_ORG_ID is not null and org_id = X_ORG_ID))
676: and language = userenv('LANG') ;
677:
678: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
679: db_ludate, X_CUSTOM_MODE)) then
680:
681: update PO_DOCUMENT_TYPES_ALL_TL set
682: type_name = X_TYPE_NAME ,
760:
761: begin
762:
763: -- Bug6910423 Moved these statements before Select statement.
764: f_luby := fnd_load_util.owner_id(X_OWNER);
765: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
766: --End Bug6910423
767:
768: -- Bug6086648 FP:Bug 5985709. Query added to get the existing data.
787: and ( (X_ORG_ID is null and org_id = -3113 )
788: or (X_ORG_ID is not null and org_id = X_ORG_ID))
789: and language = userenv('LANG');
790:
791: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
792: db_ludate, X_CUSTOM_MODE)) then
793: /* Bug6086648 FP:Bug 5985709 Start.
794: Modified the parameters in call to UPDATE_ROW to prioritise the
795: existing values, using NVL, over the seed values. */