DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on WF_NOTIFICATIONS

Line 2678: l_original_recipient wf_notifications.original_recipient%TYPE;

2674: -- Context setting revamp
2675: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
2676:
2677: --Bug 11664961
2678: l_original_recipient wf_notifications.original_recipient%TYPE;
2679: l_current_recipient_role wf_notifications.recipient_role%TYPE;
2680:
2681: -- MIPR Changes
2682: l_doc_id NUMBER;

Line 2679: l_current_recipient_role wf_notifications.recipient_role%TYPE;

2675: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
2676:
2677: --Bug 11664961
2678: l_original_recipient wf_notifications.original_recipient%TYPE;
2679: l_current_recipient_role wf_notifications.recipient_role%TYPE;
2680:
2681: -- MIPR Changes
2682: l_doc_id NUMBER;
2683: l_mipr_type_disp VARCHAR2(100);

Line 2749: FROM wf_notifications

2745: NULL, RECIPIENT_ROLE,
2746: MORE_INFO_ROLE)
2747:
2748: INTO l_original_recipient, l_current_recipient_role
2749: FROM wf_notifications
2750: WHERE notification_id = WF_ENGINE.context_nid
2751: AND ( MORE_INFO_ROLE IS NOT NULL OR
2752: RECIPIENT_ROLE <> ORIGINAL_RECIPIENT );
2753: EXCEPTION

Line 2862: wf_notifications wfn

2858:
2859: SELECT fu.USER_ID
2860: INTO l_responder_id
2861: FROM fnd_user fu,
2862: wf_notifications wfn
2863: WHERE wfn.notification_id = l_nid
2864: AND wfn.original_recipient = fu.user_name;
2865:
2866: --