APPS.PO_WF_PO_NOTIFICATION dependencies on WF_NOTIFICATIONS

Line 1699: l_original_recipient wf_notifications.original_recipient%TYPE;

1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;
1699: l_original_recipient wf_notifications.original_recipient%TYPE;
1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;
1701:
1702: --Added the below variables as part of bug 14105414 fix.
1703: x_user_id number;

Line 1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;

1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;
1699: l_original_recipient wf_notifications.original_recipient%TYPE;
1700: l_current_recipient_role wf_notifications.recipient_role%TYPE;
1701:
1702: --Added the below variables as part of bug 14105414 fix.
1703: x_user_id number;
1704: l_forward_to_username_response varchar2(100);

Line 1785: FROM wf_notifications

1781: BEGIN
1782: SELECT original_recipient,
1783: Decode(MORE_INFO_ROLE, NULL, RECIPIENT_ROLE,MORE_INFO_ROLE)
1784: INTO l_original_recipient, l_current_recipient_role
1785: FROM wf_notifications
1786: WHERE
1787: notification_id = WF_ENGINE.context_nid
1788: AND ( MORE_INFO_ROLE IS NOT NULL OR RECIPIENT_ROLE <> ORIGINAL_RECIPIENT );
1789:

Line 1889: wf_notifications wfn

1885:
1886: SELECT fu.USER_ID
1887: INTO l_responder_id
1888: FROM fnd_user fu,
1889: wf_notifications wfn
1890: WHERE wfn.notification_id = l_nid
1891: AND wfn.original_recipient = fu.user_name;
1892:
1893: --Start of code changes for updating the action code in the action history