DBA Data[Home] [Help]

APPS.AMW_OPINION_COMPONTS_PKG dependencies on FND_LOAD_UTIL

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

282: db_ludate date; -- entity update date in db
283:
284: begin
285: -- Translate owner to file_last_updated_by
286: f_luby := fnd_load_util.owner_id(X_OWNER);
287:
288: -- Translate char last_update_date to date
289: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
290:

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

291: select last_updated_by, last_update_date into db_luby, db_ludate
292: from AMW_OPINION_COMPONTS_B
293: where opinion_component_id = X_OPINION_COMPONENT_ID;
294:
295: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
296: then AMW_OPINION_COMPONTS_PKG.UPDATE_ROW(
297: X_OPINION_COMPONENT_ID => X_OPINION_COMPONENT_ID,
298: X_OPINION_COMPONENT_CODE => X_OPINION_COMPONENT_CODE,
299: X_OBJECT_OPINION_TYPE_ID => X_OBJECT_OPINION_TYPE_ID,

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

334: db_ludate date; -- entity update date in db
335:
336: begin
337: -- Translate owner to file_last_updated_by
338: f_luby := fnd_load_util.owner_id(X_OWNER);
339:
340: -- Translate char last_update_date to date
341: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
342:

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

343: select last_updated_by, last_update_date into db_luby, db_ludate
344: from AMW_OPINION_COMPONTS_TL
345: where opinion_component_id = X_OPINION_COMPONENT_ID and language = userenv('LANG');
346:
347: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
348: then update AMW_OPINION_COMPONTS_TL set
349: opinion_component_name = nvl(X_OPINION_COMPONENT_NAME, opinion_component_name),
350: source_lang = userenv('LANG'),
351: last_update_date = f_ludate,