DBA Data[Home] [Help]

APPS.FWK_TBX_LOOKUP_TYPES_PKG dependencies on FND_LOAD_UTIL

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

194: f_ludate date; -- entity update date in file
195: db_luby number; -- entity owner in db
196: db_ludate date; -- entity update date in db
197: begin
198: f_luby := fnd_load_util.owner_id(x_owner);
199: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
200:
201: select last_updated_by, last_update_date
202: into db_luby, db_ludate

Line 210: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));

206:
207: -- We want the values from file to be populated, if db has null value
208: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
209: -- Default last updated by to SEED, if db has null value
210: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
211:
212: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
213: db_ludate, X_CUSTOM_MODE)) then
214: update FWK_TBX_LOOKUP_TYPES_TL set

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

208: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
209: -- Default last updated by to SEED, if db has null value
210: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
211:
212: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
213: db_ludate, X_CUSTOM_MODE)) then
214: update FWK_TBX_LOOKUP_TYPES_TL set
215: display_name = nvl(X_DISPLAY_NAME, display_name),
216: description = nvl(X_DESCRIPTION, description),

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

241: f_ludate date; -- entity update date in file
242: db_luby number; -- entity owner in db
243: db_ludate date; -- entity update date in db
244: begin
245: f_luby := fnd_load_util.owner_id(X_OWNER);
246: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
247:
248: select last_updated_by, last_update_date
249: into db_luby, db_ludate

Line 257: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));

253:
254: -- We want the values from file to be populated, if db has null value
255: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
256: -- Default last updated by to SEED, if db has null value
257: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
258:
259: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
260: db_ludate, X_CUSTOM_MODE)) then
261: FWK_TBX_LOOKUP_TYPES_PKG.UPDATE_ROW (

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

255: db_ludate := nvl(db_ludate, to_date('1990/01/01', 'YYYY/MM/DD'));
256: -- Default last updated by to SEED, if db has null value
257: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
258:
259: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
260: db_ludate, X_CUSTOM_MODE)) then
261: FWK_TBX_LOOKUP_TYPES_PKG.UPDATE_ROW (
262: X_LOOKUP_TYPE => X_LOOKUP_TYPE,
263: X_DISPLAY_NAME => X_DISPLAY_NAME,