DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on WF_NOTIFICATION

Line 2413: wf_notification.GetAttrInfo(nid => l_notification_id,

2409: hide notification header summary for new notification
2410: */
2411: if (wf_core.translate('WF_HEADER_ATTR') = 'Y') then
2412: begin
2413: wf_notification.GetAttrInfo(nid => l_notification_id,
2414: aname => '#HDR_1',
2415: atype => l_type,
2416: subtype => l_subtype,
2417: format => l_format);

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 2825: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');

2821: if (funcmode = 'RESPOND') then
2822:
2823: l_nid := WF_ENGINE.context_nid;
2824:
2825: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
2826:
2827: l_progress := '006';
2828:
2829: if((l_result = 'FORWARD') or (l_result = 'APPROVE_AND_FORWARD')) then

Line 2831: l_forwardTo := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');

2827: l_progress := '006';
2828:
2829: if((l_result = 'FORWARD') or (l_result = 'APPROVE_AND_FORWARD')) then
2830:
2831: l_forwardTo := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');
2832:
2833: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
2834: itemkey => itemkey,
2835: aname => 'FORWARD_TO_USERNAME_RESPONSE');

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: --