22: FETCH get_delegator_name INTO l_delegator_name, l_itemkey;
23: CLOSE get_delegator_name;
24:
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:
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);
34: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'START_DATE', p_start_date);
35: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'END_DATE', p_end_date);
36:
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);
34: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'START_DATE', p_start_date);
35: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'END_DATE', p_end_date);
36:
37:
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);
34: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'START_DATE', p_start_date);
35: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'END_DATE', p_end_date);
36:
37:
38:
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);
34: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'START_DATE', p_start_date);
35: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'END_DATE', p_end_date);
36:
37:
38:
39: WF_ENGINE.STARTPROCESS (l_itemtype, l_itemkey);
35: WF_ENGINE.SETITEMATTRDATE (l_itemtype, l_itemkey, 'END_DATE', p_end_date);
36:
37:
38:
39: WF_ENGINE.STARTPROCESS (l_itemtype, l_itemkey);
40: END LAUNCH_WORKFLOW;
41:
42:
43: end UMX_PROXY_NTF_WF;