DBA Data[Home] [Help]

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 1085: from fnd_user usr

1081: cursor pref_csr is
1082: select
1083: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
1084: notification_preference
1085: from fnd_user usr
1086: where usr.user_name = p_recipient;
1087:
1088: --
1089: --

Line 2338: select user_id from fnd_user

2334: resultout out nocopy varchar2 ) is
2335: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2336: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2337: cursor c1(p_name varchar2) is
2338: select user_id from fnd_user
2339: where user_name=p_name;
2340: l_user_id number;
2341: l_p_value varchar2(3);
2342: --

Line 2439: select user_id from fnd_user

2435: resultout out nocopy varchar2 ) is
2436: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2437: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2438: cursor c1(p_name varchar2) is
2439: select user_id from fnd_user
2440: where user_name=p_name;
2441: l_user_id number;
2442: l_p_value varchar2(3);
2443: --

Line 2545: select user_id from fnd_user

2541: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2542: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2543:
2544: cursor c1(p_name varchar2) is
2545: select user_id from fnd_user
2546: where user_name=p_name;
2547:
2548: l_user_id number;
2549: l_p_value varchar2(3);

Line 2655: select user_id from fnd_user

2651: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2652: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2653:
2654: cursor c1(p_name varchar2) is
2655: select user_id from fnd_user
2656: where user_name=p_name;
2657:
2658: l_user_id number;
2659: l_p_value varchar2(3);

Line 2765: select user_id from fnd_user

2761: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2762: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2763:
2764: cursor c1(p_name varchar2) is
2765: select user_id from fnd_user
2766: where user_name=p_name;
2767:
2768: l_user_id number;
2769: l_p_value varchar2(3);

Line 2875: select user_id from fnd_user

2871: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2872: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2873:
2874: cursor c1(p_name varchar2) is
2875: select user_id from fnd_user
2876: where user_name=p_name;
2877:
2878: l_user_id number;
2879: l_p_value varchar2(3);