DBA Data[Home] [Help]

APPS.UMX_PROXY_NTF_WF dependencies on FND_GLOBAL

Line 13: select nvl(hz_format_pub.format_name(person_party_id),user_name), UMX_PROXY_NOTIFICATIONS_S.NEXTVAL from fnd_user where user_id = FND_GLOBAL.USER_ID;

9: p_end_date in date default null) is
10:
11:
12: cursor get_delegator_name is
13: select nvl(hz_format_pub.format_name(person_party_id),user_name), UMX_PROXY_NOTIFICATIONS_S.NEXTVAL from fnd_user where user_id = FND_GLOBAL.USER_ID;
14:
15: l_itemtype VARCHAR2 (8) := 'UMXPXYNF';
16: l_itemkey NUMBER;
17: l_delegator_name varchar2(500);

Line 29: owner_role => FND_GLOBAL.USER_NAME);

25: -- Call the Workflow API to send the notification.
26: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
27: itemkey => l_itemkey,
28: process => 'PROXYNOTIFY',
29: owner_role => FND_GLOBAL.USER_NAME);
30:
31: -- Set Workflow Item Attributes.
32: WF_ENGINE.SETITEMATTRTEXT (l_itemtype, l_itemkey, 'DELEGATOR_NAME', l_delegator_name);
33: WF_ENGINE.SETITEMATTRTEXT (l_itemtype, l_itemkey, 'PROXY_USERNAME', p_proxy_username);