DBA Data[Home] [Help]

APPS.AMW_OPINION_VALUES_PKG dependencies on FND_LOAD_UTIL

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

328: row_id rowid;
329:
330: begin
331: -- Translate owner to file_last_updated_by
332: f_luby := fnd_load_util.owner_id(X_OWNER);
333:
334: -- Translate char last_update_date to date
335: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
336:

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

337: select last_updated_by, last_update_date into db_luby, db_ludate
338: from AMW_OPINION_VALUES_B
339: where opinion_value_id = X_OPINION_VALUE_ID;
340:
341: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
342: then AMW_OPINION_VALUES_PKG.UPDATE_ROW(
343: X_OPINION_VALUE_ID => X_OPINION_VALUE_ID,
344: X_OPINION_VALUE_CODE => X_OPINION_VALUE_CODE,
345: X_OPINION_COMPONENT_ID => X_OPINION_COMPONENT_ID,

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

387: db_ludate date; -- entity update date in db
388:
389: begin
390: -- Translate owner to file_last_updated_by
391: f_luby := fnd_load_util.owner_id(X_OWNER);
392:
393: -- Translate char last_update_date to date
394: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
395:

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

396: select last_updated_by, last_update_date into db_luby, db_ludate
397: from AMW_OPINION_VALUES_TL
398: where opinion_value_id = X_OPINION_VALUE_ID and language = userenv('LANG');
399:
400: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
401: then update AMW_OPINION_VALUES_TL set
402: opinion_value_name = nvl(X_OPINION_VALUE_NAME, opinion_value_name),
403: source_lang = userenv('LANG'),
404: last_update_date = f_ludate,