DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on WF_NOTIFICATION

Line 530: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

526: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 02';
527: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
528: END IF;
529:
530: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
531:
532: IF (g_po_wf_debug = 'Y') THEN
533: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 03';
534: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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

768: l_signer_type := NULL;
769: END;
770:
771:
772: l_evidence_store_id := wf_notification.GetAttrText(l_notif_id, '#WF_SIG_ID');
773:
774: l_doc_parameters(1).Param_Name := 'PSIG_USER_KEY_LABEL';
775: l_doc_parameters(1).Param_Value := fnd_message.get_string('PO', 'PO_EREC_PARAM_KEYVALUE');
776: l_doc_parameters(1).Param_displayname := 'PSIG_USER_KEY_LABEL';

Line 1726: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');

1722: itemtype => l_item_type,
1723: itemkey => l_item_key,
1724: aname => 'NOTIFICATION_ID');
1725:
1726: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
1727:
1728: l_supplier_userid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1729: itemtype => l_item_type,
1730: itemkey => l_item_key,

Line 1861: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

1857: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 02';
1858: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1859: END IF;
1860:
1861: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
1862:
1863: IF (g_po_wf_debug = 'Y') THEN
1864: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 03';
1865: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

Line 2092: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');

2088: itemtype => l_item_type,
2089: itemkey => l_item_key,
2090: aname => 'NOTIFICATION_ID');
2091:
2092: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
2093:
2094: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
2095: itemtype => l_item_type,
2096: itemkey => l_item_key,

Line 2215: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

2211: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 02';
2212: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2213: END IF;
2214:
2215: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
2216:
2217: IF (g_po_wf_debug = 'Y') THEN
2218: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 03';
2219: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

Line 2710: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;

2706: l_notification_id NUMBER;
2707: l_progress VARCHAR2(300);
2708: l_doc_string VARCHAR2(200);
2709: l_preparer_user_name WF_USERS.name%TYPE;
2710: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2711: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2712: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2713: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
2714:

Line 2822: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;

2818: l_notification_id NUMBER;
2819: l_progress VARCHAR2(300);
2820: l_doc_string VARCHAR2(200);
2821: l_preparer_user_name WF_USERS.name%TYPE;
2822: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2823: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2824: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2825: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
2826: