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: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;

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: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
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: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
628:
629: --
630: cursor getCompanyNumber is

Line 627: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%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: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
628:
629: --
630: cursor getCompanyNumber is
631: select hz.party_number

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 931: l_role_name wf_local_roles.name%type;

927: l_requester_user_id fnd_user.user_id%type;
928: l_org_name hz_parties.party_name%type;
929: l_org_number hz_parties.party_number%type;
930: l_uni_approver_not_found boolean := true;
931: l_role_name wf_local_roles.name%type;
932: l_approver_display_name varchar2(1000);
933: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
934:
935: cursor getADHocRole is

Line 933: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;

929: l_org_number hz_parties.party_number%type;
930: l_uni_approver_not_found boolean := true;
931: l_role_name wf_local_roles.name%type;
932: l_approver_display_name varchar2(1000);
933: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
934:
935: cursor getADHocRole is
936: select name, display_name
937: from WF_LOCAL_ROLES

Line 937: from WF_LOCAL_ROLES

933: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;
934:
935: cursor getADHocRole is
936: select name, display_name
937: from WF_LOCAL_ROLES
938: where name = x_role_name;
939:
940: cursor getUniversalApprovers is
941: select fnd.user_name