eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AME_WF_PVT dependencies on WF_NOTIFICATION

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

Line 4598: l_notification_id := wf_notification.send(role =>p_role,

4594: l_notification_id NUMBER;
4595:
4596: BEGIN
4597:
4598: l_notification_id := wf_notification.send(role =>p_role,
4599: msg_type => 'POAPPRV',
4600: msg_name => 'PO_WITHDRAWN');
4601:
4602: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4602: wf_notification.SetAttrText(nid =>l_notification_id,

4598: l_notification_id := wf_notification.send(role =>p_role,
4599: msg_type => 'POAPPRV',
4600: msg_name => 'PO_WITHDRAWN');
4601:
4602: wf_notification.SetAttrText(nid =>l_notification_id,
4603: aname=> 'DOCUMENT_NUMBER',
4604: avalue =>p_document_num);
4605:
4606: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4606: wf_notification.SetAttrText(nid =>l_notification_id,

4602: wf_notification.SetAttrText(nid =>l_notification_id,
4603: aname=> 'DOCUMENT_NUMBER',
4604: avalue =>p_document_num);
4605:
4606: wf_notification.SetAttrText(nid =>l_notification_id,
4607: aname=> 'DOCUMENT_TYPE_DISP',
4608: avalue =>p_doc_type_disp);
4609:
4610: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4610: wf_notification.SetAttrText(nid =>l_notification_id,

4606: wf_notification.SetAttrText(nid =>l_notification_id,
4607: aname=> 'DOCUMENT_TYPE_DISP',
4608: avalue =>p_doc_type_disp);
4609:
4610: wf_notification.SetAttrText(nid =>l_notification_id,
4611: aname=> '#FROM_ROLE',
4612: avalue =>p_from_user_name);
4613:
4614: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4614: wf_notification.SetAttrText(nid =>l_notification_id,

4610: wf_notification.SetAttrText(nid =>l_notification_id,
4611: aname=> '#FROM_ROLE',
4612: avalue =>p_from_user_name);
4613:
4614: wf_notification.SetAttrText(nid =>l_notification_id,
4615: aname=> 'NOTIFICATION_REGION',
4616: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NOTIF&poHeaderId=' || p_document_id);
4617:
4618: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4618: wf_notification.SetAttrText(nid =>l_notification_id,

4614: wf_notification.SetAttrText(nid =>l_notification_id,
4615: aname=> 'NOTIFICATION_REGION',
4616: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NOTIF&poHeaderId=' || p_document_id);
4617:
4618: wf_notification.SetAttrText(nid =>l_notification_id,
4619: aname=> '#HISTORY',
4620: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId='
4621: || p_document_id || '&showActions=Y');
4622:

Line 4623: wf_notification.SetAttrText(nid =>l_notification_id,

4619: aname=> '#HISTORY',
4620: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId='
4621: || p_document_id || '&showActions=Y');
4622:
4623: wf_notification.SetAttrText(nid =>l_notification_id,
4624: aname=> 'VIEW_DOC_URL',
4625: avalue =>p_view_po_url);
4626:
4627: wf_notification.SetAttrText(nid =>l_notification_id,

Line 4627: wf_notification.SetAttrText(nid =>l_notification_id,

4623: wf_notification.SetAttrText(nid =>l_notification_id,
4624: aname=> 'VIEW_DOC_URL',
4625: avalue =>p_view_po_url);
4626:
4627: wf_notification.SetAttrText(nid =>l_notification_id,
4628: aname=> 'EDIT_DOC_URL',
4629: avalue =>p_edit_po_url);
4630:
4631: IF g_debug_stmt THEN

Line 5699: l_evidence_store_id := wf_notification.GetAttrText(l_notif_id, '#WF_SIG_ID');

5695: l_signer_type := NULL;
5696: END;
5697:
5698:
5699: l_evidence_store_id := wf_notification.GetAttrText(l_notif_id, '#WF_SIG_ID');
5700:
5701: l_doc_parameters(1).Param_Name := 'PSIG_USER_KEY_LABEL';
5702: l_doc_parameters(1).Param_Value := fnd_message.get_string('PO', 'PO_EREC_PARAM_KEYVALUE');
5703: l_doc_parameters(1).Param_displayname := 'PSIG_USER_KEY_LABEL';