DBA Data[Home] [Help]

APPS.FND_RESPONSIBILITY_PKG dependencies on FND_LOAD_UTIL

Line 171: f_luby := fnd_load_util.owner_id(x_owner);

167: db_ludate date; -- entity update date in db
168:
169: begin
170: -- Translate owner to file_last_updated_by
171: f_luby := fnd_load_util.owner_id(x_owner);
172:
173: -- Translate char last_update_date to date
174: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
175:

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

184: and r.application_id = a.application_id
185: and a.application_short_name = X_APP_SHORT_NAME)
186: and LANGUAGE = userenv('LANG');
187:
188: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
189: db_ludate, X_CUSTOM_MODE)) then
190: update fnd_responsibility_tl set
191: responsibility_name = nvl(X_RESPONSIBILITY_NAME, responsibility_name),
192: DESCRIPTION = nvl(X_DESCRIPTION, description),

Line 791: f_luby := fnd_load_util.owner_id(x_owner);

787:
788: begin
789:
790: -- Translate owner to file_last_updated_by
791: f_luby := fnd_load_util.owner_id(x_owner);
792:
793: -- Translate char last_update_date to date
794: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
795:

Line 796: select decode(X_END_DATE, fnd_load_util.null_value, null,

792:
793: -- Translate char last_update_date to date
794: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
795:
796: select decode(X_END_DATE, fnd_load_util.null_value, null,
797: null, X_END_DATE,
798: X_END_DATE),
799: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
800: null, X_WEB_HOST_NAME,

Line 799: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,

795:
796: select decode(X_END_DATE, fnd_load_util.null_value, null,
797: null, X_END_DATE,
798: X_END_DATE),
799: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
800: null, X_WEB_HOST_NAME,
801: X_WEB_HOST_NAME),
802: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
803: null, X_WEB_AGENT_NAME,

Line 802: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,

798: X_END_DATE),
799: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
800: null, X_WEB_HOST_NAME,
801: X_WEB_HOST_NAME),
802: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
803: null, X_WEB_AGENT_NAME,
804: X_WEB_AGENT_NAME)
805: into l_end_date, l_web_host_name, l_web_agent_name
806: from dual;

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

810: from fnd_responsibility
811: where RESPONSIBILITY_KEY = upper(X_RESP_KEY)
812: and APPLICATION_ID = app_id;
813:
814: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
815: db_ludate, X_CUSTOM_MODE)) then
816: fnd_responsibility_pkg.UPDATE_ROW (
817: X_RESPONSIBILITY_ID => resp_id,
818: X_APPLICATION_ID => app_id,