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_WF_APPROVAL dependencies on WF_LOCAL_ROLES

Line 622: x_wf_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;

618: usertypeId jtf_um_usertypes_b.usertype_id%type;
619: usertypeKey jtf_um_usertypes_b.usertype_key%type;
620: usertypeName jtf_um_usertypes_tl.usertype_name%type;
621: MISSING_REQUESTER_USER_ID exception;
622: x_wf_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
623: Email_Address WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE;
624: x_role_name WF_LOCAL_ROLES.NAME%TYPE;
625: l_approver_display_name varchar2(1000);
626: l_role_name wf_local_roles.name%type;

Line 623: Email_Address WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE;

619: usertypeKey jtf_um_usertypes_b.usertype_key%type;
620: usertypeName jtf_um_usertypes_tl.usertype_name%type;
621: MISSING_REQUESTER_USER_ID exception;
622: x_wf_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
623: Email_Address WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE;
624: x_role_name WF_LOCAL_ROLES.NAME%TYPE;
625: l_approver_display_name varchar2(1000);
626: l_role_name wf_local_roles.name%type;
627:

Line 624: x_role_name WF_LOCAL_ROLES.NAME%TYPE;

620: usertypeName jtf_um_usertypes_tl.usertype_name%type;
621: MISSING_REQUESTER_USER_ID exception;
622: x_wf_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
623: Email_Address WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE;
624: x_role_name WF_LOCAL_ROLES.NAME%TYPE;
625: l_approver_display_name varchar2(1000);
626: l_role_name wf_local_roles.name%type;
627:
628:

Line 626: l_role_name wf_local_roles.name%type;

622: x_wf_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
623: Email_Address WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE;
624: x_role_name WF_LOCAL_ROLES.NAME%TYPE;
625: l_approver_display_name varchar2(1000);
626: l_role_name wf_local_roles.name%type;
627:
628:
629: --
630: cursor getCompanyNumber is

Line 667: select email_address from wf_local_roles where name=upper(requesterUserName);

663: and nvl (utr.effective_end_date, sysdate + 1) > sysdate
664: and rvl.version in ('W','4');
665:
666: cursor getEmailAddress is
667: select email_address from wf_local_roles where name=upper(requesterUserName);
668:
669: --------------Bug No: 7270214-------------------
670:
671: cursor getADHocRole is

Line 673: from WF_LOCAL_ROLES

669: --------------Bug No: 7270214-------------------
670:
671: cursor getADHocRole is
672: select name, display_name
673: from WF_LOCAL_ROLES
674: where name = x_role_name;
675: --------------Bug No: 7270214-------------------
676: --
677:

Line 925: l_role_name wf_local_roles.name%type;

921: l_requester_user_id fnd_user.user_id%type;
922: l_org_name hz_parties.party_name%type;
923: l_org_number hz_parties.party_number%type;
924: l_uni_approver_not_found boolean := true;
925: l_role_name wf_local_roles.name%type;
926: l_approver_display_name varchar2(1000);
927:
928: cursor getADHocRole is
929: select name, display_name

Line 930: from WF_LOCAL_ROLES

926: l_approver_display_name varchar2(1000);
927:
928: cursor getADHocRole is
929: select name, display_name
930: from WF_LOCAL_ROLES
931: where name = x_role_name;
932:
933: cursor getUniversalApprovers is
934: select fnd.user_name