APPS.JTF_UM_APPROVALS_PKG dependencies on FND_LOAD_UTIL

Line 265: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);

261: X_DESCRIPTION IN VARCHAR2,
262: x_last_update_date in varchar2 default NULL,
263: X_CUSTOM_MODE in varchar2 default NULL
264: ) is
265: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
266: l_approval_id NUMBER := 0;
267: f_luby number; -- entity owner in file
268: f_ludate date; -- entity update date in file
269: db_luby number; -- entity owner in db

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

274: -- l_user_id := 1;
275: -- end if;
276:
277: -- Translate owner to file_last_updated_by
278: f_luby := fnd_load_util.owner_id(x_owner);
279:
280: -- Translate char last_update_date to date
281: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
282:

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

308: into db_luby, db_ludate
309: FROM JTF_UM_APPROVALS_B
310: where APPROVAL_ID = X_APPROVAL_ID;
311:
312: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
313: db_ludate, X_CUSTOM_MODE)) then
314:
315: UPDATE_ROW(
316: X_APPROVAL_ID => X_APPROVAL_ID,

Line 454: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);

450: x_last_update_date in varchar2 default NULL,
451: X_CUSTOM_MODE in varchar2 default NULL
452: ) is
453:
454: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
455: l_approver_id NUMBER := 0;
456: h_record_exists NUMBER := 0;
457:
458: f_luby number; -- entity owner in file

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

474: and APPROVER_SEQ = X_APPROVER_SEQ
475: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
476:
477: -- Translate owner to file_last_updated_by
478: f_luby := fnd_load_util.owner_id(x_owner);
479:
480: -- Translate char last_update_date to date
481: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
482:

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

517: into db_luby, db_ludate
518: FROM JTF_UM_APPROVERS
519: where APPROVER_ID = l_approver_id;
520:
521: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
522: db_ludate, X_CUSTOM_MODE)) then
523:
524:
525: UPDATE_APPROVERS_ROW(

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

652:
653: begin
654:
655: -- Translate owner to file_last_updated_by
656: f_luby := fnd_load_util.owner_id(x_owner);
657:
658: -- Translate char last_update_date to date
659: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
660:

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

666: FROM JTF_UM_APPROVALS_TL
667: where APPROVAL_ID = X_APPROVAL_ID
668: and LANGUAGE = userenv('LANG');
669:
670: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
671: db_ludate, X_CUSTOM_MODE)) then
672: update JTF_UM_APPROVALS_TL set
673: APPROVAL_NAME = X_APPROVAL_NAME,
674: DESCRIPTION = X_DESCRIPTION,