DBA Data[Home] [Help]

APPS.AMW_OPINION_TYPES_PKG dependencies on FND_LOAD_UTIL

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

264: db_ludate date; -- entity update date in db
265:
266: begin
267: -- Translate owner to file_last_updated_by
268: f_luby := fnd_load_util.owner_id(X_OWNER);
269:
270: -- Translate char last_update_date to date
271: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
272:

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

273: select last_updated_by, last_update_date into db_luby, db_ludate
274: from AMW_OPINION_TYPES_B
275: where opinion_type_id = X_OPINION_TYPE_ID;
276:
277: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
278: then AMW_OPINION_TYPES_PKG.UPDATE_ROW(
279: X_OPINION_TYPE_ID => X_OPINION_TYPE_ID,
280: X_OPINION_TYPE_CODE => X_OPINION_TYPE_CODE,
281: X_SECURITY_GROUP_ID => null,

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

312: db_ludate date; -- entity update date in db
313:
314: begin
315: -- Translate owner to file_last_updated_by
316: f_luby := fnd_load_util.owner_id(X_OWNER);
317:
318: -- Translate char last_update_date to date
319: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
320:

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

321: select last_updated_by, last_update_date into db_luby, db_ludate
322: from AMW_OPINION_TYPES_TL
323: where opinion_type_id = X_OPINION_TYPE_ID and language = userenv('LANG');
324:
325: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
326: then update AMW_OPINION_TYPES_TL set
327: opinion_type_name = nvl(X_OPINION_TYPE_NAME, opinion_type_name),
328: source_lang = userenv('LANG'),
329: last_update_date = f_ludate,