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_SIGNATURE_PVT dependencies on PO_WF_UTIL_PKG

Line 109: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

105: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
106: END IF;
107:
108: -- Set the multi-org context
109: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'ORG_ID');
112:
113: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 113: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

109: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'ORG_ID');
112:
113: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'BUYER_EMPLOYEE_ID');
116:
117: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,

Line 117: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,

113: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'BUYER_EMPLOYEE_ID');
116:
117: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
118: itemkey => itemkey,
119: aname => 'PREPARER_ID',
120: avalue => l_preparer_id);
121:

Line 130: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

126: WF_ENGINE.SetItemOwner (itemtype => itemtype,
127: itemkey => itemkey,
128: owner => l_username);
129:
130: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
131: itemkey => itemkey,
132: aname => 'BUYER_USER_NAME',
133: avalue => l_username);
134:

Line 135: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

131: itemkey => itemkey,
132: aname => 'BUYER_USER_NAME',
133: avalue => l_username);
134:
135: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
136: itemkey => itemkey,
137: aname => 'BUYER_DISPLAY_NAME',
138: avalue => l_user_display_name);
139:

Line 140: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

136: itemkey => itemkey,
137: aname => 'BUYER_DISPLAY_NAME',
138: avalue => l_user_display_name);
139:
140: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
141: itemtype => itemtype,
142: itemkey => itemkey,
143: aname => 'DOCUMENT_ID');
144:

Line 145: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

141: itemtype => itemtype,
142: itemkey => itemkey,
143: aname => 'DOCUMENT_ID');
144:
145: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
146: itemtype => itemtype,
147: itemkey => itemkey,
148: aname => 'DOCUMENT_NUMBER');
149:

Line 150: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(

146: itemtype => itemtype,
147: itemkey => itemkey,
148: aname => 'DOCUMENT_NUMBER');
149:
150: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(
151: itemtype => itemtype,
152: itemkey => itemkey,
153: aname => 'DOCUMENT_TYPE');
154:

Line 155: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

151: itemtype => itemtype,
152: itemkey => itemkey,
153: aname => 'DOCUMENT_TYPE');
154:
155: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
156: itemtype => itemtype,
157: itemkey => itemkey,
158: aname => 'DOCUMENT_SUBTYPE');
159:

Line 160: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

156: itemtype => itemtype,
157: itemkey => itemkey,
158: aname => 'DOCUMENT_SUBTYPE');
159:
160: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
161: itemtype => itemtype,
162: itemkey => itemkey,
163: aname => 'PO_REVISION_NUM');
164:

Line 183: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

179: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_document_id);
180:
181: END IF;
182:
183: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
184: itemkey => itemkey,
185: aname => 'DOCUMENT_DISPLAY_NAME',
186: avalue => l_doc_display_name);
187:

Line 195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

191: value => l_doc_display_name);
192: FND_MESSAGE.set_token(token => 'DOC_NUM',
193: value => (l_document_number ||','||l_revision));
194:
195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'PO_SUP_SIGNATURE_MSG_SUB',
198: avalue => fnd_message.get);
199:

Line 234: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

230: ||'&categories=OKC_REPO_CONTRACT';
231:
232: END IF; -- if (l_conterms_exist = 'N')
233:
234: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
235: itemkey => itemkey,
236: aname => 'PO_SIGN_ATTACHMENTS',
237: avalue => l_sign_attachments_value);
238:

Line 242: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

238:
239: --
240:
241:
242: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
243: itemkey => itemkey,
244: aname => 'PO_SUP_SIGNATURE_MSG_BODY',
245: avalue =>
246: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 334: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

330: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';
331: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
332: END IF;
333:
334: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
335: itemkey => l_item_key,
336: aname => 'BUYER_DISPLAY_NAME');
337:
338: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

Line 338: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

334: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
335: itemkey => l_item_key,
336: aname => 'BUYER_DISPLAY_NAME');
337:
338: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'SUPPLIER_RESPONSE');
341:
342: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

Line 342: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

338: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'SUPPLIER_RESPONSE');
341:
342: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
343: itemtype => l_item_type,
344: itemkey => l_item_key,
345: aname => 'DOCUMENT_DISPLAY_NAME');
346:

Line 347: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

343: itemtype => l_item_type,
344: itemkey => l_item_key,
345: aname => 'DOCUMENT_DISPLAY_NAME');
346:
347: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
348: itemtype => l_item_type,
349: itemkey => l_item_key,
350: aname => 'ORG_ID');
351:

Line 536: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

532: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 01';
533: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
534: END IF;
535:
536: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
537: itemkey => itemkey,
538: aname => 'PO_HEADER_ID');
539:
540: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 540: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

536: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
537: itemkey => itemkey,
538: aname => 'PO_HEADER_ID');
539:
540: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
541: itemkey => itemkey,
542: aname => 'SIGNATURE_COMMENTS');
543:
544: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 544: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

540: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
541: itemkey => itemkey,
542: aname => 'SIGNATURE_COMMENTS');
543:
544: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
545: itemkey => itemkey,
546: aname => 'SUPPLIER_RESPONSE');
547:
548: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 548: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

544: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
545: itemkey => itemkey,
546: aname => 'SUPPLIER_RESPONSE');
547:
548: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
549: itemkey => itemkey,
550: aname => 'BUYER_RESPONSE');
551:
552: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 552: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

548: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
549: itemkey => itemkey,
550: aname => 'BUYER_RESPONSE');
551:
552: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'ORG_ID');
555:
556: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 556: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

552: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'ORG_ID');
555:
556: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
557: itemkey => itemkey,
558: aname => 'DOCUMENT_NUMBER');
559:
560: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 560: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

556: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
557: itemkey => itemkey,
558: aname => 'DOCUMENT_NUMBER');
559:
560: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
561: itemkey => itemkey,
562: aname => 'PO_REVISION_NUM');
563:
564: -- If the BUYER_RESPONSE attribute is Null then this procedure is called for Supplier Signature

Line 574: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

570: l_signer := 'SUPPLIER';
571:
572: l_event_name := 'oracle.apps.po.suppliersignature';
573:
574: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'SUPPLIER_USER_NAME');
577:
578: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 578: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

574: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'SUPPLIER_USER_NAME');
577:
578: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'BUYER_USER_NAME');
581:
582: --Get the Notification Id of the recent Signature Notification into l_notif_id.

Line 583: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

579: itemkey => itemkey,
580: aname => 'BUYER_USER_NAME');
581:
582: --Get the Notification Id of the recent Signature Notification into l_notif_id.
583: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'NOTIFICATION_ID');
586: ELSE
587: l_response := l_buyer_response;

Line 600: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

596: -- the buyer because the notification may have been routed to
597: -- somebody else
598: l_user_name := FND_GLOBAL.user_name;
599:
600: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'SUPPLIER_USER_NAME');
603:
604: --Get the Notification Id of the recent Signature Notification into l_notif_id.

Line 605: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

601: itemkey => itemkey,
602: aname => 'SUPPLIER_USER_NAME');
603:
604: --Get the Notification Id of the recent Signature Notification into l_notif_id.
605: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
606: itemkey => itemkey,
607: aname => 'NOTIFICATION_ID');
608: END IF;
609:

Line 728: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,

724: IF l_return_status <> 'S' THEN
725: RAISE l_erecords_exception;
726: END IF;
727:
728: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'ERECORD_ID',
731: avalue => l_erecord_id);
732:

Line 733: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

729: itemkey => itemkey,
730: aname => 'ERECORD_ID',
731: avalue => l_erecord_id);
732:
733: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
734: itemkey => itemkey,
735: aname => 'SIG_ID',
736: avalue => l_signature_id);
737: EXCEPTION

Line 835: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

831: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';
832: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
833: END IF;
834:
835: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
836: itemkey => itemkey,
837: aname => 'SIGNATURE_COMMENTS');
838:
839: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 839: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

835: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
836: itemkey => itemkey,
837: aname => 'SIGNATURE_COMMENTS');
838:
839: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'SUPPLIER_RESPONSE');
842:
843: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 843: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

839: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'SUPPLIER_RESPONSE');
842:
843: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
844: itemkey => itemkey,
845: aname => 'BUYER_RESPONSE');
846:
847:

Line 875: l_employee_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

871: -- then the buyer on the document.
872: l_employee_id := FND_GLOBAL.employee_id;
873:
874: /*
875: l_employee_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
876: itemkey => itemkey,
877: aname => 'BUYER_EMPLOYEE_ID');
878: */
879:

Line 893: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

889: ELSIF l_response = 'REJECTED' THEN
890: l_accepted_flag := 'N';
891: END IF;
892:
893: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'PO_REVISION_NUM');
896:
897: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 897: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

893: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'PO_REVISION_NUM');
896:
897: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'ERECORD_ID');
900:
901: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 901: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

897: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'ERECORD_ID');
900:
901: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'DOCUMENT_ID');
904:
905: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 905: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

901: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'DOCUMENT_ID');
904:
905: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
906: itemkey => itemkey,
907: aname => 'DOCUMENT_TYPE');
908:
909: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 909: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

905: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
906: itemkey => itemkey,
907: aname => 'DOCUMENT_TYPE');
908:
909: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'DOCUMENT_SUBTYPE');
912:
913: SELECT wf_item_type,

Line 1032: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

1028:
1029: END IF;
1030:
1031: -- Resets the Signature comments attribute to Null
1032: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1033: itemkey => itemkey,
1034: aname => 'SIGNATURE_COMMENTS',
1035: avalue => '');
1036:

Line 1128: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1124: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';
1125: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1126: END IF;
1127:
1128: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1129: itemtype => itemtype,
1130: itemkey => itemkey,
1131: aname => 'DOCUMENT_ID');
1132:

Line 1133: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1129: itemtype => itemtype,
1130: itemkey => itemkey,
1131: aname => 'DOCUMENT_ID');
1132:
1133: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1134: itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => 'DOCUMENT_NUMBER');
1137:

Line 1138: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1134: itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => 'DOCUMENT_NUMBER');
1137:
1138: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1139: itemkey => itemkey,
1140: aname => 'SUPPLIER_RESPONSE',
1141: avalue => 'ACCEPTED');
1142:

Line 1143: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1139: itemkey => itemkey,
1140: aname => 'SUPPLIER_RESPONSE',
1141: avalue => 'ACCEPTED');
1142:
1143: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1144: itemtype => itemtype,
1145: itemkey => itemkey,
1146: aname => 'PO_REVISION_NUM');
1147:

Line 1148: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1144: itemtype => itemtype,
1145: itemkey => itemkey,
1146: aname => 'PO_REVISION_NUM');
1147:
1148: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1149: itemtype => itemtype,
1150: itemkey => itemkey,
1151: aname => 'DOCUMENT_DISPLAY_NAME');
1152:

Line 1160: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1156: value => l_doc_display_name);
1157: FND_MESSAGE.set_token(token => 'DOC_NUM',
1158: value => (l_document_number ||','||l_revision));
1159:
1160: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1161: itemkey => itemkey,
1162: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1163: avalue => fnd_message.get);
1164:

Line 1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1161: itemkey => itemkey,
1162: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1163: avalue => fnd_message.get);
1164:
1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'PO_BUY_SIGNATURE_MSG_BODY',
1168: avalue =>
1169: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 1235: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1231: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 01';
1232: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1233: END IF;
1234:
1235: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1236: itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => 'DOCUMENT_ID');
1239:

Line 1240: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1236: itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => 'DOCUMENT_ID');
1239:
1240: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1241: itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => 'DOCUMENT_NUMBER');
1244:

Line 1245: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1241: itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => 'DOCUMENT_NUMBER');
1244:
1245: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1246: itemkey => itemkey,
1247: aname => 'SUPPLIER_RESPONSE',
1248: avalue => 'REJECTED');
1249:

Line 1250: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1246: itemkey => itemkey,
1247: aname => 'SUPPLIER_RESPONSE',
1248: avalue => 'REJECTED');
1249:
1250: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1251: itemtype => itemtype,
1252: itemkey => itemkey,
1253: aname => 'PO_REVISION_NUM');
1254:

Line 1255: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1251: itemtype => itemtype,
1252: itemkey => itemkey,
1253: aname => 'PO_REVISION_NUM');
1254:
1255: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1256: itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_DISPLAY_NAME');
1259:

Line 1267: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1263: value => l_doc_display_name);
1264: FND_MESSAGE.set_token(token => 'DOC_NUM',
1265: value => (l_document_number ||','||l_revision));
1266:
1267: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'PO_BUY_INFO_MSG_SUB',
1270: avalue => fnd_message.get);
1271:

Line 1272: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1268: itemkey => itemkey,
1269: aname => 'PO_BUY_INFO_MSG_SUB',
1270: avalue => fnd_message.get);
1271:
1272: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'PO_BUY_INFO_MSG_BODY',
1275: avalue =>
1276: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 1368: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

1364: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';
1365: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1366: END IF;
1367:
1368: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(
1369: itemtype => l_item_type,
1370: itemkey => l_item_key,
1371: aname => 'BUYER_DISPLAY_NAME');
1372:

Line 1373: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1369: itemtype => l_item_type,
1370: itemkey => l_item_key,
1371: aname => 'BUYER_DISPLAY_NAME');
1372:
1373: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1374: itemtype => l_item_type,
1375: itemkey => l_item_key,
1376: aname => 'PO_REVISION_NUM');
1377:

Line 1378: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1374: itemtype => l_item_type,
1375: itemkey => l_item_key,
1376: aname => 'PO_REVISION_NUM');
1377:
1378: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1379: itemtype => l_item_type,
1380: itemkey => l_item_key,
1381: aname => 'NOTIFICATION_ID');
1382:

Line 1385: l_supplier_userid := PO_WF_UTIL_PKG.GetItemAttrNumber(

1381: aname => 'NOTIFICATION_ID');
1382:
1383: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
1384:
1385: l_supplier_userid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1386: itemtype => l_item_type,
1387: itemkey => l_item_key,
1388: aname => 'SUPPLIER_USER_ID');
1389:

Line 1395: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1391: l_supplier_userid,
1392: l_supplier_username,
1393: l_supplier_displayname);
1394:
1395: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1396: itemtype => l_item_type,
1397: itemkey => l_item_key,
1398: aname => 'DOCUMENT_NUMBER');
1399:

Line 1400: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1396: itemtype => l_item_type,
1397: itemkey => l_item_key,
1398: aname => 'DOCUMENT_NUMBER');
1399:
1400: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1401: itemtype => l_item_type,
1402: itemkey => l_item_key,
1403: aname => 'DOCUMENT_DISPLAY_NAME');
1404:

Line 1405: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

1401: itemtype => l_item_type,
1402: itemkey => l_item_key,
1403: aname => 'DOCUMENT_DISPLAY_NAME');
1404:
1405: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1406: itemtype => l_item_type,
1407: itemkey => l_item_key,
1408: aname => 'ORG_ID');
1409:

Line 1589: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1585: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 01';
1586: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1587: END IF;
1588:
1589: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1590: itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'DOCUMENT_ID');
1593:

Line 1594: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1590: itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'DOCUMENT_ID');
1593:
1594: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1595: itemtype => itemtype,
1596: itemkey => itemkey,
1597: aname => 'DOCUMENT_NUMBER');
1598:

Line 1600: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1596: itemkey => itemkey,
1597: aname => 'DOCUMENT_NUMBER');
1598:
1599:
1600: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1601: itemkey => itemkey,
1602: aname => 'BUYER_RESPONSE',
1603: avalue => 'ACCEPTED');
1604:

Line 1605: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1601: itemkey => itemkey,
1602: aname => 'BUYER_RESPONSE',
1603: avalue => 'ACCEPTED');
1604:
1605: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1606: itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'PO_REVISION_NUM');
1609:

Line 1610: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1606: itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'PO_REVISION_NUM');
1609:
1610: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1611: itemtype => itemtype,
1612: itemkey => itemkey,
1613: aname => 'DOCUMENT_DISPLAY_NAME');
1614:

Line 1622: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1618: value => l_doc_display_name);
1619: FND_MESSAGE.set_token(token => 'DOC_NUM',
1620: value => (l_document_number ||','||l_revision));
1621:
1622: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'PO_SUP_INFO_MSG_SUB',
1625: avalue => fnd_message.get);
1626:

Line 1627: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1623: itemkey => itemkey,
1624: aname => 'PO_SUP_INFO_MSG_SUB',
1625: avalue => fnd_message.get);
1626:
1627: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1628: itemkey => itemkey,
1629: aname => 'PO_SUP_INFO_MSG_BODY',
1630: avalue =>
1631: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 1721: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

1717: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';
1718: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1719: END IF;
1720:
1721: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(
1722: itemtype => l_item_type,
1723: itemkey => l_item_key,
1724: aname => 'BUYER_DISPLAY_NAME');
1725:

Line 1726: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText(

1722: itemtype => l_item_type,
1723: itemkey => l_item_key,
1724: aname => 'BUYER_DISPLAY_NAME');
1725:
1726: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText(
1727: itemtype => l_item_type,
1728: itemkey => l_item_key,
1729: aname => 'BUYER_RESPONSE');
1730:

Line 1731: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1727: itemtype => l_item_type,
1728: itemkey => l_item_key,
1729: aname => 'BUYER_RESPONSE');
1730:
1731: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1732: itemtype => l_item_type,
1733: itemkey => l_item_key,
1734: aname => 'PO_REVISION_NUM');
1735:

Line 1736: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1732: itemtype => l_item_type,
1733: itemkey => l_item_key,
1734: aname => 'PO_REVISION_NUM');
1735:
1736: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1737: itemtype => l_item_type,
1738: itemkey => l_item_key,
1739: aname => 'NOTIFICATION_ID');
1740:

Line 1743: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1739: aname => 'NOTIFICATION_ID');
1740:
1741: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
1742:
1743: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1744: itemtype => l_item_type,
1745: itemkey => l_item_key,
1746: aname => 'DOCUMENT_NUMBER');
1747:

Line 1748: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1744: itemtype => l_item_type,
1745: itemkey => l_item_key,
1746: aname => 'DOCUMENT_NUMBER');
1747:
1748: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1749: itemtype => l_item_type,
1750: itemkey => l_item_key,
1751: aname => 'DOCUMENT_DISPLAY_NAME');
1752:

Line 1753: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

1749: itemtype => l_item_type,
1750: itemkey => l_item_key,
1751: aname => 'DOCUMENT_DISPLAY_NAME');
1752:
1753: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1754: itemtype => l_item_type,
1755: itemkey => l_item_key,
1756: aname => 'ORG_ID');
1757:

Line 1937: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1933: l_progress := 'PO_SIGNATURE_PVT.set_rejected_buyer_response: 01';
1934: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1935: END IF;
1936:
1937: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1938: itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'DOCUMENT_ID');
1941:

Line 1942: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1938: itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'DOCUMENT_ID');
1941:
1942: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1943: itemtype => itemtype,
1944: itemkey => itemkey,
1945: aname => 'DOCUMENT_NUMBER');
1946:

Line 1948: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1944: itemkey => itemkey,
1945: aname => 'DOCUMENT_NUMBER');
1946:
1947:
1948: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1949: itemkey => itemkey,
1950: aname => 'BUYER_RESPONSE',
1951: avalue => 'REJECTED');
1952:

Line 1953: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1949: itemkey => itemkey,
1950: aname => 'BUYER_RESPONSE',
1951: avalue => 'REJECTED');
1952:
1953: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1954: itemtype => itemtype,
1955: itemkey => itemkey,
1956: aname => 'PO_REVISION_NUM');
1957:

Line 1958: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1954: itemtype => itemtype,
1955: itemkey => itemkey,
1956: aname => 'PO_REVISION_NUM');
1957:
1958: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1959: itemtype => itemtype,
1960: itemkey => itemkey,
1961: aname => 'DOCUMENT_DISPLAY_NAME');
1962:

Line 1970: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1966: value => l_doc_display_name);
1967: FND_MESSAGE.set_token(token => 'DOC_NUM',
1968: value => (l_document_number ||','||l_revision));
1969:
1970: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'PO_SUP_INFO_MSG_SUB',
1973: avalue => fnd_message.get);
1974:

Line 1975: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1971: itemkey => itemkey,
1972: aname => 'PO_SUP_INFO_MSG_SUB',
1973: avalue => fnd_message.get);
1974:
1975: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1976: itemkey => itemkey,
1977: aname => 'PO_SUP_INFO_MSG_BODY',
1978: avalue =>
1979: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 2123: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

2119: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);
2120:
2121: -- Get the Document Type and ID from the Workflow Attributes.
2122: --
2123: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText
2124: ( itemtype => p_itemtype
2125: , itemkey => p_itemkey
2126: , aname => 'DOCUMENT_TYPE'
2127: );

Line 2128: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

2124: ( itemtype => p_itemtype
2125: , itemkey => p_itemkey
2126: , aname => 'DOCUMENT_TYPE'
2127: );
2128: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
2129: ( itemtype => p_itemtype
2130: , itemkey => p_itemkey
2131: , aname => 'DOCUMENT_ID'
2132: );

Line 2268: PO_WF_UTIL_PKG.SetItemAttrNumber(

2264: BEGIN
2265: IF (funcmode = 'RESPOND') THEN
2266: l_notification_id := WF_ENGINE.context_nid;
2267:
2268: PO_WF_UTIL_PKG.SetItemAttrNumber(
2269: itemtype => itemtype,
2270: itemkey => itemkey,
2271: aname => 'NOTIFICATION_ID',
2272: avalue => l_notification_id);

Line 2329: PO_WF_UTIL_PKG.SetItemAttrNumber(

2325:
2326: IF (funcmode = 'RESPOND') THEN
2327: l_notification_id := WF_ENGINE.context_nid;
2328:
2329: PO_WF_UTIL_PKG.SetItemAttrNumber(
2330: itemtype => itemtype,
2331: itemkey => itemkey,
2332: aname => 'NOTIFICATION_ID',
2333: avalue => l_notification_id);