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.OKC_ASYNC_PVT dependencies on FND_USER

Line 33: fnd_user usr

29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
33: fnd_user usr
34: where usr.user_name = p_recipient
35: and fndl.installed_flag = 'B';
36:
37: --

Line 1047: from fnd_user usr

1043: cursor pref_csr is
1044: select
1045: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
1046: notification_preference
1047: from fnd_user usr
1048: where usr.user_name = p_recipient;
1049:
1050: --
1051: --

Line 2300: select user_id from fnd_user

2296: resultout out nocopy varchar2 ) is
2297: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2298: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2299: cursor c1(p_name varchar2) is
2300: select user_id from fnd_user
2301: where user_name=p_name;
2302: l_user_id number;
2303: l_p_value varchar2(3);
2304: --

Line 2401: select user_id from fnd_user

2397: resultout out nocopy varchar2 ) is
2398: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2399: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2400: cursor c1(p_name varchar2) is
2401: select user_id from fnd_user
2402: where user_name=p_name;
2403: l_user_id number;
2404: l_p_value varchar2(3);
2405: --

Line 2507: select user_id from fnd_user

2503: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2504: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2505:
2506: cursor c1(p_name varchar2) is
2507: select user_id from fnd_user
2508: where user_name=p_name;
2509:
2510: l_user_id number;
2511: l_p_value varchar2(3);

Line 2617: select user_id from fnd_user

2613: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2614: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2615:
2616: cursor c1(p_name varchar2) is
2617: select user_id from fnd_user
2618: where user_name=p_name;
2619:
2620: l_user_id number;
2621: l_p_value varchar2(3);

Line 2727: select user_id from fnd_user

2723: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2724: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2725:
2726: cursor c1(p_name varchar2) is
2727: select user_id from fnd_user
2728: where user_name=p_name;
2729:
2730: l_user_id number;
2731: l_p_value varchar2(3);

Line 2837: select user_id from fnd_user

2833: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2834: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2835:
2836: cursor c1(p_name varchar2) is
2837: select user_id from fnd_user
2838: where user_name=p_name;
2839:
2840: l_user_id number;
2841: l_p_value varchar2(3);