APPS.JTF_UM_ROLE_RESP_PKG dependencies on FND_LOAD_UTIL

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

65: x_owner IN VARCHAR2,
66: x_last_update_date in varchar2 default NULL,
67: X_CUSTOM_MODE in varchar2 default NULL
68: ) is
69: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
70: f_luby number; -- entity owner in file
71: f_ludate date; -- entity update date in file
72: db_luby number; -- entity owner in db
73: db_ludate date; -- entity update date in db

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

78: -- end if;
79:
80:
81: -- Translate owner to file_last_updated_by
82: f_luby := fnd_load_util.owner_id(x_owner);
83:
84: -- Translate char last_update_date to date
85: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
86:

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

92: FROM jtf_um_usertype_role
93: where usertype_id = x_usertype_id AND
94: principal_name = x_principal_name;
95:
96: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
97: db_ludate, X_CUSTOM_MODE)) then
98:
99: -- Update row if present
100: JTF_UM_ROLE_RESP_PKG.UPDATE_USERTYPE_ROLE_ROW (

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

202: x_application_id IN NUMBER,
203: x_last_update_date in varchar2 default NULL,
204: x_custom_mode in varchar2 default NULL
205: ) is
206: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
207: f_luby number; -- entity owner in file
208: f_ludate date; -- entity update date in file
209: db_luby number; -- entity owner in db
210: db_ludate date; -- entity update date in db

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

213: -- if (x_owner = 'SEED') then
214: -- l_user_id := 1;
215: -- end if;
216: -- Translate owner to file_last_updated_by
217: f_luby := fnd_load_util.owner_id(x_owner);
218:
219: -- Translate char last_update_date to date
220: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
221:

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

227: FROM jtf_um_usertype_resp
228: where usertype_id = x_usertype_id AND
229: responsibility_key = x_responsibility_key ;
230:
231: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
232: db_ludate, X_CUSTOM_MODE)) then
233:
234:
235: -- Update row if present

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

329: x_owner IN VARCHAR2,
330: x_last_update_date in varchar2 default NULL,
331: x_custom_mode in varchar2 default NULL
332: ) is
333: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
334: f_luby number; -- entity owner in file
335: f_ludate date; -- entity update date in file
336: db_luby number; -- entity owner in db
337: db_ludate date; -- entity update date in db

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

343: --end if;
344:
345:
346: -- Translate owner to file_last_updated_by
347: f_luby := fnd_load_util.owner_id(x_owner);
348:
349: -- Translate char last_update_date to date
350: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
351:

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

358: where subscription_id = x_subscription_id AND
359: principal_name = x_principal_name ;
360:
361:
362: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
363: db_ludate, X_CUSTOM_MODE)) then
364:
365:
366: -- Update row if present

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

463: x_application_id IN NUMBER,
464: x_last_update_date in varchar2 default NULL,
465: X_CUSTOM_MODE in varchar2 default NULL
466: ) is
467: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
468:
469: f_luby number; -- entity owner in file
470: f_ludate date; -- entity update date in file
471: db_luby number; -- entity owner in db

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

476: -- l_user_id := 1;
477: -- end if;
478:
479: -- Translate owner to file_last_updated_by
480: f_luby := fnd_load_util.owner_id(x_owner);
481:
482: -- Translate char last_update_date to date
483: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
484:

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

491: where subscription_id = x_subscription_id AND
492: responsibility_key = x_responsibility_key ;
493:
494:
495: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
496: db_ludate, X_CUSTOM_MODE)) then
497:
498:
499: -- Update row if present