DBA Data[Home] [Help]

APPS.PO_DOCUMENT_TYPES_ALL_PKG dependencies on FND_LOAD_UTIL

Line 660: f_luby := fnd_load_util.owner_id(X_OWNER);

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.

Line 678: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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 ,

Line 764: f_luby := fnd_load_util.owner_id(X_OWNER);

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.

Line 791: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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. */