DBA Data[Home] [Help]

APPS.PER_ASS_STATUS_TYPE_AMENDS_PKG dependencies on FND_LOAD_UTIL

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

261: X_LAST_UPDATE_LOGIN
262: ); */
263:
264: begin
265: f_luby := fnd_load_util.owner_id(X_OWNER);
266: -- Translate char last_update_date to date
267: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
268: select LAST_UPDATED_BY, LAST_UPDATE_DATE
269: into db_luby, db_ludate

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

270: from PER_ASS_STATUS_TYPE_AMENDS
271: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID);
272:
273: -- Test for customization and version
274: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
275: db_ludate, X_CUSTOM_MODE)) then
276:
277: UPDATE_ROW (
278: X_ASS_STATUS_TYPE_AMEND_ID,

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

335: X_LAST_UPDATED_BY,
336: X_LAST_UPDATE_LOGIN
337: ); */
338: -- Translate owner to file_last_updated_by
339: f_luby := fnd_load_util.owner_id(x_owner);
340:
341: -- Translate char last_update_date to date
342: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
343:

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

346: from PER_ASS_STATUS_TYPE_AMENDS_TL
347: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID)
348: and LANGUAGE=userenv('LANG');
349:
350: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
351: db_ludate,X_CUSTOM_MODE)) then
352: update PER_ASS_STATUS_TYPE_AMENDS_TL set
353: USER_STATUS = X_USER_STATUS,
354: LAST_UPDATE_DATE = db_ludate,