APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on FND_LOAD_UTIL

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

348: X_AUTH_DELEGATION_ROLE_ID IN NUMBER,
349: x_last_update_date in varchar2 default NULL,
350: X_CUSTOM_MODE in varchar2 default NULL
351: ) is
352: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
353: l_subscription_id NUMBER := 0;
354: f_luby number; -- entity owner in file
355: f_ludate date; -- entity update date in file
356: db_luby number; -- entity owner in db

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

362: -- end if;
363:
364:
365: -- Translate owner to file_last_updated_by
366: f_luby := fnd_load_util.owner_id(x_owner);
367:
368: -- Translate char last_update_date to date
369: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
370:

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

398: into db_luby, db_ludate
399: FROM JTF_UM_SUBSCRIPTIONS_B
400: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
401:
402: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
403: db_ludate, X_CUSTOM_MODE)) then
404:
405: UPDATE_ROW(
406: X_SUBSCRIPTION_ID => X_SUBSCRIPTION_ID,

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

439: db_ludate date; -- entity update date in db
440: begin
441:
442: -- Translate owner to file_last_updated_by
443: f_luby := fnd_load_util.owner_id(x_owner);
444:
445: -- Translate char last_update_date to date
446: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
447:

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

453: FROM JTF_UM_SUBSCRIPTIONS_TL
454: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
455: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
456:
457: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
458: db_ludate, X_CUSTOM_MODE)) then
459: update JTF_UM_SUBSCRIPTIONS_TL set
460: SUBSCRIPTION_NAME = X_SUBSCRIPTION_NAME,
461: DESCRIPTION = X_DESCRIPTION,

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

572: x_last_update_date in varchar2 default NULL,
573: X_CUSTOM_MODE in varchar2 default NULL
574: )
575: is
576: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
577: h_record_exists NUMBER := 0;
578: f_luby number; -- entity owner in file
579: f_ludate date; -- entity update date in file
580: db_luby number; -- entity owner in db

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

592: and TEMPLATE_ID = X_TEMPLATE_ID
593: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
594:
595: -- Translate owner to file_last_updated_by
596: f_luby := fnd_load_util.owner_id(x_owner);
597:
598: -- Translate char last_update_date to date
599: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
600:

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

620: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
621: and TEMPLATE_ID = X_TEMPLATE_ID
622: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
623:
624: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
625: db_ludate, X_CUSTOM_MODE)) then
626:
627: UPDATE_TEMPLATE_ASSIGNMENT(
628: X_SUBSCRIPTION_ID => X_SUBSCRIPTION_ID,