eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JUMF_LCT_PKG dependencies on JTF_UM_ROLE_RESP_PKG

Line 409: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(

405: -- and PRINCIPAL_NAME = x_principal_name
406: -- and EFFECTIVE_START_DATE = TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' );
407:
408: -- if (v_db_owner_id = 1) then
409: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(
410: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
411: x_principal_name => x_principal_name ,
412: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
413: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 423: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(

419: END IF;
420:
421: exception
422: when no_data_found then
423: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(
424: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
425: x_principal_name => x_principal_name ,
426: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
427: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 480: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(

476: and RESPONSIBILITY_KEY = x_responsibility_key
477: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
478:
479: if ( v_active_record_count = 0 ) then
480: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(
481: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
482: x_responsibility_key => x_responsibility_key ,
483: x_is_default_flag => x_is_default_flag ,
484: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 503: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(

499: set EFFECTIVE_END_DATE = SYSDATE
500: where EFFECTIVE_END_DATE is NULL
501: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
502:
503: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(
504: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
505: x_responsibility_key => x_responsibility_key ,
506: x_is_default_flag => x_is_default_flag ,
507: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 774: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(

770: -- and PRINCIPAL_NAME = x_principal_name
771: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
772:
773: -- if (v_db_owner_id = 1) then
774: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(
775: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
776: x_principal_name => x_principal_name ,
777: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
778: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 788: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(

784: end if;
785:
786: exception
787: when no_data_found then
788: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(
789: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
790: x_principal_name => x_principal_name ,
791: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
792: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 843: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(

839: -- and RESPONSIBILITY_KEY = x_responsibility_key
840: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
841:
842: if ( v_active_record_count = 0 ) then
843: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(
844: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
845: x_responsibility_key => x_responsibility_key ,
846: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
847: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 864: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(

860: set EFFECTIVE_END_DATE = SYSDATE
861: where EFFECTIVE_END_DATE is NULL
862: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
863:
864: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(
865: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
866: x_responsibility_key => x_responsibility_key ,
867: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
868: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,