DBA Data[Home] [Help]

APPS.AMW_COMPLIANCE_ENVS_PKG dependencies on FND_LOAD_UTIL

Line 435: l_user_id := fnd_load_util.owner_id(X_OWNER);

431: l_row_id varchar2(32767);
432:
433: BEGIN
434: -- Translate owner to file_last_updated_by
435: l_user_id := fnd_load_util.owner_id(X_OWNER);
436:
437: select COMPLIANCE_ENV_ID into l_compliance_env_id
438: from AMW_COMPLIANCE_ENVS_B
439: where COMPLIANCE_ENV_ID = X_COMPLIANCE_ENV_ID;

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

636: db_luby number; -- entity owner in db
637: db_ludate date; -- entity update date in db
638: begin
639: -- Translate owner to file_last_updated_by
640: f_luby := fnd_load_util.owner_id(X_OWNER);
641:
642: -- Translate char last_update_date to date
643: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
644:

Line 651: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

647: from AMW_COMPLIANCE_ENVS_TL
648: where compliance_env_id = X_COMPLIANCE_ENV_ID
649: and language = userenv('LANG');
650:
651: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
652: update AMW_COMPLIANCE_ENVS_TL
653: set name = X_COMPLIANCE_ENV_NAME,
654: description = nvl(X_COMPLIANCE_ENV_DESCRIPTION, description),
655: alias = nvl(X_COMPLIANCE_ENV_ALIAS, alias),