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 786: f_luby := fnd_load_util.owner_id(x_owner);

782:
783: begin
784:
785: -- Translate owner to file_last_updated_by
786: f_luby := fnd_load_util.owner_id(x_owner);
787:
788: -- Translate char last_update_date to date
789: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
790:

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

787:
788: -- Translate char last_update_date to date
789: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
790:
791: select decode(X_END_DATE, fnd_load_util.null_value, null,
792: null, X_END_DATE,
793: X_END_DATE),
794: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
795: null, X_WEB_HOST_NAME,

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

790:
791: select decode(X_END_DATE, fnd_load_util.null_value, null,
792: null, X_END_DATE,
793: X_END_DATE),
794: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
795: null, X_WEB_HOST_NAME,
796: X_WEB_HOST_NAME),
797: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
798: null, X_WEB_AGENT_NAME,

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

793: X_END_DATE),
794: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
795: null, X_WEB_HOST_NAME,
796: X_WEB_HOST_NAME),
797: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
798: null, X_WEB_AGENT_NAME,
799: X_WEB_AGENT_NAME)
800: into l_end_date, l_web_host_name, l_web_agent_name
801: from dual;

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

805: from fnd_responsibility
806: where RESPONSIBILITY_KEY = X_RESP_KEY
807: and APPLICATION_ID = app_id;
808:
809: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
810: db_ludate, X_CUSTOM_MODE)) then
811: fnd_responsibility_pkg.UPDATE_ROW (
812: X_RESPONSIBILITY_ID => resp_id,
813: X_APPLICATION_ID => app_id,