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.JTF_UM_USERTYPE_CREDENTIALS dependencies on WF_LOCAL_ROLES

Line 492: * This procedure sets the notification preference in the wf_local_roles for the given user to the value in the corresponding adHocRole.

488: * Procedure Name :
489: * setApproverNotifPref
490: * Description :
491: * This procedure is called after enabling the user in ASSIGN_USERTYPE_CREDENTIALS
492: * This procedure sets the notification preference in the wf_local_roles for the given user to the value in the corresponding adHocRole.
493: * Parameters
494: * userName : The User Name
495: * userId : The User ID
496: *

Line 499: l_notif_pref wf_local_roles.NOTIFICATION_PREFERENCE%type;

495: * userId : The User ID
496: *
497: ************************************************************/
498: procedure setApproverNotifPref(userName varchar2, userId varchar2) is
499: l_notif_pref wf_local_roles.NOTIFICATION_PREFERENCE%type;
500: l_user_name wf_local_roles.name%type;
501: l_user_display_name wf_local_roles.display_name%type;
502: errCode varchar2(100);
503: errMsg varchar2(200);

Line 500: l_user_name wf_local_roles.name%type;

496: *
497: ************************************************************/
498: procedure setApproverNotifPref(userName varchar2, userId varchar2) is
499: l_notif_pref wf_local_roles.NOTIFICATION_PREFERENCE%type;
500: l_user_name wf_local_roles.name%type;
501: l_user_display_name wf_local_roles.display_name%type;
502: errCode varchar2(100);
503: errMsg varchar2(200);
504: begin

Line 501: l_user_display_name wf_local_roles.display_name%type;

497: ************************************************************/
498: procedure setApproverNotifPref(userName varchar2, userId varchar2) is
499: l_notif_pref wf_local_roles.NOTIFICATION_PREFERENCE%type;
500: l_user_name wf_local_roles.name%type;
501: l_user_display_name wf_local_roles.display_name%type;
502: errCode varchar2(100);
503: errMsg varchar2(200);
504: begin
505: wf_directory.GetUserName(p_orig_system => 'FND_USR',

Line 512: wf_local_roles wlr

508: p_display_name => l_user_display_name);
509: if(l_user_name is not null) then
510: select NOTIFICATION_PREFERENCE into l_notif_pref
511: from jtf_um_usertype_reg ut,
512: wf_local_roles wlr
513: where ut.status_code='PENDING'
514: and '__JTA_UM'||USERTYPE_REG_ID = name
515: and ut.user_id = userId;
516: