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 JTF_UM_USERTYPES_B

Line 68: l_application_id jtf_um_usertypes_b.application_id%type;

64: -- Return the application id of the usertype or enrollment request
65: function getRequestApplId (requestType in varchar2,
66: requestId in number) return varchar2 is
67:
68: l_application_id jtf_um_usertypes_b.application_id%type;
69:
70: cursor getUsertypeApplID (x_usertype_id in number) is
71: select application_id
72: from jtf_um_usertypes_b

Line 72: from jtf_um_usertypes_b

68: l_application_id jtf_um_usertypes_b.application_id%type;
69:
70: cursor getUsertypeApplID (x_usertype_id in number) is
71: select application_id
72: from jtf_um_usertypes_b
73: where usertype_id = x_usertype_id;
74:
75: cursor getSubscriptionApplID (x_subscription_id in number) is
76: select application_id

Line 178: l_application_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;

174: function get_wf_owner_username (p_request_id in number,
175: p_request_type in varchar2) return varchar2 is
176:
177: l_method_name varchar2 (21) := 'GET_WF_OWNER_USERNAME';
178: l_application_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
179: l_owner_username varchar2 (100);
180:
181: begin
182:

Line 325: from JTF_UM_USERTYPES_B

321: processOwner varchar2 (100);
322:
323: cursor usertypeApprovalCursor is
324: select APPROVAL_ID
325: from JTF_UM_USERTYPES_B
326: where USERTYPE_ID = requestID;
327:
328: cursor enrollApprovalCursor is
329: select APPROVAL_ID

Line 618: usertypeId jtf_um_usertypes_b.usertype_id%type;

614: respApplID number;
615: responID number;
616: supportContact fnd_profile_option_values.profile_option_value%type;
617: timeout number;
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;

Line 619: usertypeKey jtf_um_usertypes_b.usertype_key%type;

615: responID number;
616: supportContact fnd_profile_option_values.profile_option_value%type;
617: timeout number;
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;

Line 644: from JTF_UM_USERTYPES_B

640: and hzr.object_id = hz.party_id;
641:
642: cursor getUsertypeKey is
643: select USERTYPE_KEY
644: from JTF_UM_USERTYPES_B
645: where USERTYPE_ID = usertypeId
646: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;
647:
648: cursor getUTRespApplID is

Line 2128: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

2124:
2125: -- cursor for populating event parameters in case of user type rejection
2126: cursor getRejectEventData is
2127: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
2128: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg
2129: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USERTYPE_REG_ID=to_number(itemkey);
2130: -- and reg.EFFECTIVE_START_DATE <= sysdate
2131: -- and reg.EFFECTIVE_END_DATE= sysdate;
2132:

Line 2488: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;

2484: actid in number,
2485: funcmode in varchar2,
2486: resultout out NOCOPY varchar2) is
2487:
2488: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2489: l_approver_username fnd_user.user_name%type;
2490: l_org_name hz_parties.party_name%type;
2491: l_org_number hz_parties.party_number%type;
2492: l_primary_user_role fnd_profile_option_values.profile_option_value%type;

Line 2595: from JTF_UM_USERTYPES_B

2591: MISSING_USERTYPE_INFO exception;
2592: --
2593: cursor getUsertypeInfo is
2594: select USERTYPE_KEY, EMAIL_NOTIFICATION_FLAG
2595: from JTF_UM_USERTYPES_B
2596: where USERTYPE_ID = usertypeID;
2597:
2598: begin
2599:

Line 3142: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3138: p_user_id number;
3139:
3140: cursor find_old_item_type is
3141: select utreg.wf_item_type
3142: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3143: where utreg.usertype_id = p_usertype_id
3144: and utreg.usertype_id = ut.usertype_id
3145: and utreg.status_code = 'PENDING'
3146: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

Line 3267: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut

3263: p_user_id number;
3264:
3265: cursor find_old_item_type is
3266: select utreg.wf_item_type
3267: from jtf_um_usertype_reg utreg, jtf_um_usertypes_b ut
3268: where utreg.usertype_id = p_usertype_id
3269: and utreg.usertype_id = ut.usertype_id
3270: and utreg.status_code = 'PENDING'
3271: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate;

Line 3567: cursor usertype_approval is select usertype_id from jtf_um_usertypes_b

3563: procedure approval_chain_changed(p_approval_id in number,
3564: p_org_party_id in number)
3565: is
3566:
3567: cursor usertype_approval is select usertype_id from jtf_um_usertypes_b
3568: where approval_id = p_approval_id
3569: and nvl (effective_end_date, sysdate + 1) > sysdate;
3570: p_usertype_id number;
3571: