DBA Data[Home] [Help]

APPS.ITA_SETUP_HIERARCHY_PKG dependencies on FND_LOAD_UTIL

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

202: db_ludate date; -- entity update date in db
203:
204: begin
205: -- Translate owner to file_last_updated_by
206: f_luby := fnd_load_util.owner_id(X_OWNER);
207:
208: -- Translate char last_update_date to date
209: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
210:

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

211: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
212: from ITA_SETUP_HIERARCHY_B
213: where HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE;
214:
215: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
216: then ITA_SETUP_HIERARCHY_PKG.UPDATE_ROW (
217: X_HIERARCHY_LEVEL_CODE => X_HIERARCHY_LEVEL_CODE,
218: X_HIERARCHY_LEVEL_NAME => X_HIERARCHY_LEVEL_NAME,
219: X_SECURITY_GROUP_ID => null,

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

319: db_ludate date; -- entity update date in db
320:
321: begin
322: -- Translate owner to file_last_updated_by
323: f_luby := fnd_load_util.owner_id(X_OWNER);
324:
325: -- Translate char last_update_date to date
326: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
327:

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

328: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
329: from ITA_SETUP_HIERARCHY_TL
330: where HIERARCHY_LEVEL_CODE = X_HIERARCHY_LEVEL_CODE and LANGUAGE = userenv('LANG');
331:
332: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
333: then update ITA_SETUP_HIERARCHY_TL set
334: HIERARCHY_LEVEL_NAME = nvl(X_HIERARCHY_LEVEL_NAME, HIERARCHY_LEVEL_NAME),
335: SOURCE_LANG = userenv('LANG'),
336: LAST_UPDATE_DATE = f_ludate,