DBA Data[Home] [Help]

APPS.JTF_UM_TEMPLATES_PKG dependencies on FND_LOAD_UTIL

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

323: x_last_update_date in varchar2 default NULL,
324: X_CUSTOM_MODE in varchar2 default NULL
325:
326: ) is
327: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
328: l_template_id NUMBER := 0;
329: f_luby number; -- entity owner in file
330: f_ludate date; -- entity update date in file
331: db_luby number; -- entity owner in db

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

335: -- l_user_id := 1;
336: -- end if;
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 373: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

369: into db_luby, db_ludate
370: FROM JTF_UM_TEMPLATES_B
371: where TEMPLATE_ID = X_TEMPLATE_ID;
372:
373: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
374: db_ludate, X_CUSTOM_MODE)) then
375:
376: UPDATE_ROW(
377: X_TEMPLATE_ID => X_TEMPLATE_ID,

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

413:
414: begin
415:
416: -- Translate owner to file_last_updated_by
417: f_luby := fnd_load_util.owner_id(x_owner);
418:
419: -- Translate char last_update_date to date
420: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
421:

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

427: FROM JTF_UM_TEMPLATES_TL
428: where TEMPLATE_ID = X_TEMPLATE_ID
429: and LANGUAGE = userenv('LANG');
430:
431: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
432: db_ludate, X_CUSTOM_MODE)) then
433:
434:
435: update JTF_UM_TEMPLATES_TL set