DBA Data[Home] [Help]

APPS.PER_ASS_STATUS_TYPE_AMENDS_PKG dependencies on FND_LOAD_UTIL

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

240: X_LAST_UPDATE_LOGIN
241: ); */
242:
243: begin
244: f_luby := fnd_load_util.owner_id(X_OWNER);
245: -- Translate char last_update_date to date
246: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
247: select LAST_UPDATED_BY, LAST_UPDATE_DATE
248: into db_luby, db_ludate

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

249: from PER_ASS_STATUS_TYPE_AMENDS
250: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID);
251:
252: -- Test for customization and version
253: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
254: db_ludate, X_CUSTOM_MODE)) then
255:
256: UPDATE_ROW (
257: X_ASS_STATUS_TYPE_AMEND_ID,

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

314: X_LAST_UPDATED_BY,
315: X_LAST_UPDATE_LOGIN
316: ); */
317: -- Translate owner to file_last_updated_by
318: f_luby := fnd_load_util.owner_id(x_owner);
319:
320: -- Translate char last_update_date to date
321: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
322:

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

325: from PER_ASS_STATUS_TYPE_AMENDS_TL
326: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID)
327: and LANGUAGE=userenv('LANG');
328:
329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
330: db_ludate,X_CUSTOM_MODE)) then
331: update PER_ASS_STATUS_TYPE_AMENDS_TL set
332: USER_STATUS = X_USER_STATUS,
333: LAST_UPDATE_DATE = db_ludate,