APPS.PO_AME_WF_PVT dependencies on WF_NOTIFICATIONS

Line 2706: l_original_recipient wf_notifications.original_recipient%TYPE;

2702: l_org_id NUMBER;
2703: l_document_type po_document_types.document_type_code%TYPE;
2704: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
2705: l_approval_group_id NUMBER:='';
2706: l_original_recipient wf_notifications.original_recipient%TYPE;
2707: l_current_recipient_role wf_notifications.recipient_role%TYPE;
2708: l_api_name VARCHAR2(500) := 'post_approval_notif';
2709: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2710:

Line 2707: l_current_recipient_role wf_notifications.recipient_role%TYPE;

2703: l_document_type po_document_types.document_type_code%TYPE;
2704: l_document_subtype po_document_types_all_b.document_subtype%TYPE;
2705: l_approval_group_id NUMBER:='';
2706: l_original_recipient wf_notifications.original_recipient%TYPE;
2707: l_current_recipient_role wf_notifications.recipient_role%TYPE;
2708: l_api_name VARCHAR2(500) := 'post_approval_notif';
2709: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2710:
2711: BEGIN

Line 2767: FROM wf_notifications

2763: BEGIN
2764: SELECT original_recipient,
2765: DECODE(more_info_role, NULL, recipient_role, more_info_role)
2766: INTO l_original_recipient, l_current_recipient_role
2767: FROM wf_notifications
2768: WHERE notification_id = WF_ENGINE.context_nid
2769: AND (more_info_role IS NOT NULL OR recipient_role <> original_recipient );
2770: EXCEPTION
2771: WHEN OTHERS THEN

Line 2858: wf_notifications wfn

2854:
2855: SELECT fu.user_id
2856: INTO l_responder_id
2857: FROM fnd_user fu,
2858: wf_notifications wfn
2859: WHERE wfn.notification_id = l_nid
2860: AND wfn.original_recipient = fu.user_name;
2861:
2862: IF (wf_engine.preserved_context = TRUE) THEN

Line 3735: wf_notifications wfn

3731: wfn.recipient_role,
3732: wfn.original_recipient
3733: FROM wf_items wfi,
3734: wf_item_activity_statuses wfias,
3735: wf_notifications wfn
3736: WHERE wfi.parent_item_key = itemkey
3737: AND wfi.item_type = itemtype
3738: AND wfias.item_type = wfi.item_type
3739: AND wfias.item_key = wfi.item_key