APPS.JTF_UM_USERTYPES_PKG dependencies on FND_LOAD_UTIL

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

335: X_DISPLAY_ORDER in NUMBER,
336: x_last_update_date in varchar2 default NULL,
337: X_CUSTOM_MODE in varchar2 default NULL
338: ) is
339: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
340: l_usertype_id NUMBER := 0;
341: f_luby number; -- entity owner in file
342: f_ludate date; -- entity update date in file
343: db_luby number; -- entity owner in db

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

350: -- l_user_id := 1;
351: -- end if;
352:
353: -- Translate owner to file_last_updated_by
354: f_luby := fnd_load_util.owner_id(x_owner);
355:
356: -- Translate char last_update_date to date
357: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
358:

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

387: into db_luby, db_ludate
388: FROM JTF_UM_USERTYPES_B
389: where USERTYPE_ID = X_USERTYPE_ID;
390:
391: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
392: db_ludate, X_CUSTOM_MODE)) then
393:
394: UPDATE_ROW(
395: X_USERTYPE_ID => X_USERTYPE_ID,

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

533: X_OWNER IN VARCHAR2,
534: x_last_update_date in varchar2 default NULL,
535: X_CUSTOM_MODE in varchar2 default NULL
536: ) is
537: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
538: h_record_exists NUMBER := 0;
539: f_luby number; -- entity owner in file
540: f_ludate date; -- entity update date in file
541: db_luby number; -- entity owner in db

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

552: and TEMPLATE_ID = X_TEMPLATE_ID
553: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
554:
555: -- Translate owner to file_last_updated_by
556: f_luby := fnd_load_util.owner_id(x_owner);
557:
558: -- Translate char last_update_date to date
559: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
560:

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

581: where USERTYPE_ID = X_USERTYPE_ID
582: and TEMPLATE_ID = X_TEMPLATE_ID
583: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
584:
585: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
586: db_ludate, X_CUSTOM_MODE)) then
587: UPDATE_TEMPLATE_ASSIGNMENT(
588: X_USERTYPE_ID => X_USERTYPE_ID,
589: X_TEMPLATE_ID => X_TEMPLATE_ID,

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

703: X_OWNER IN VARCHAR2,
704: x_last_update_date in varchar2 default NULL,
705: X_CUSTOM_MODE in varchar2 default NULL
706: ) is
707: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
708: h_record_exists NUMBER := 0;
709: f_luby number; -- entity owner in file
710: f_ludate date; -- entity update date in file
711: db_luby number; -- entity owner in db

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

722: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
723: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
724:
725: -- Translate owner to file_last_updated_by
726: f_luby := fnd_load_util.owner_id(x_owner);
727:
728: -- Translate char last_update_date to date
729: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
730:

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

752: where USERTYPE_ID = X_USERTYPE_ID
753: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
754: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
755:
756: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
757: db_ludate, X_CUSTOM_MODE)) then
758: UPDATE_SUBSCRIPTION_ASSIGNMENT(
759: X_USERTYPE_ID => X_USERTYPE_ID,
760: X_SUBSCRIPTION_ID => X_SUBSCRIPTION_ID,

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

791:
792: begin
793:
794: -- Translate owner to file_last_updated_by
795: f_luby := fnd_load_util.owner_id(x_owner);
796:
797: -- Translate char last_update_date to date
798: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
799:

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

805: FROM JTF_UM_USERTYPES_TL
806: where USERTYPE_ID = X_USERTYPE_ID
807: and LANGUAGE = userenv('LANG');
808:
809: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
810: db_ludate, X_CUSTOM_MODE)) then
811:
812: update JTF_UM_USERTYPES_TL set
813: USERTYPE_NAME = X_USERTYPE_NAME,

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

907: X_USERTYPE_NAME in VARCHAR2,
908: X_USERTYPE_SHORTNAME in VARCHAR2,
909: X_DISPLAY_ORDER in NUMBER
910: ) is
911: l_user_id NUMBER := fnd_load_util.owner_id(x_owner);
912: begin
913: --if (x_owner = 'SEED') then
914: -- l_user_id := 1;
915: --end if;