DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on WF_ENGINE

Line 95: if (funcmode <> wf_engine.eng_run) then

91:
92:
93: -- Do nothing in cancel or timeout mode
94: --
95: if (funcmode <> wf_engine.eng_run) then
96:
97: resultout := wf_engine.eng_null;
98: return;
99:

Line 97: resultout := wf_engine.eng_null;

93: -- Do nothing in cancel or timeout mode
94: --
95: if (funcmode <> wf_engine.eng_run) then
96:
97: resultout := wf_engine.eng_null;
98: return;
99:
100: end if;
101: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 101: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

97: resultout := wf_engine.eng_null;
98: return;
99:
100: end if;
101: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
102: itemkey => itemkey,
103: aname => 'ORG_ID');
104:
105: IF l_orgid is NOT NULL THEN

Line 111: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

107: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
108:
109: END IF;
110:
111: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'DOCUMENT_ID');
114:
115:

Line 116: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

112: itemkey => itemkey,
113: aname => 'DOCUMENT_ID');
114:
115:
116: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
117: itemkey => itemkey,
118: aname => 'DOCUMENT_TYPE');
119:
120: IF l_doc_type IN ('PO','PA') THEN

Line 134: l_po_revision_num_curr := wf_engine.GetItemAttrText (itemtype => itemtype,

130:
131: -- code added for bug 8291565 FP
132: -- for blocking FYI notification to web supplier users when there is no change in the revision number of the PO
133:
134: l_po_revision_num_curr := wf_engine.GetItemAttrText (itemtype => itemtype,
135: itemkey => itemkey,
136: aname => 'REVISION_NUMBER');
137:
138: IF l_doc_type IN ('PO', 'PA') THEN

Line 195: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

191:
192: -- end of code added for bug 8291565 FP
193:
194: --
195: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
196: --
197: x_progress := 'PO_POAPPROVAL_INIT1.Get_PO_Attributes: 02';
198: IF (g_po_wf_debug = 'Y') THEN
199: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 248: if (funcmode <> wf_engine.eng_run) then

244:
245:
246: -- Do nothing in cancel or timeout mode
247: --
248: if (funcmode <> wf_engine.eng_run) then
249:
250: resultout := wf_engine.eng_null;
251: return;
252:

Line 250: resultout := wf_engine.eng_null;

246: -- Do nothing in cancel or timeout mode
247: --
248: if (funcmode <> wf_engine.eng_run) then
249:
250: resultout := wf_engine.eng_null;
251: return;
252:
253: end if;
254:

Line 255: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

251: return;
252:
253: end if;
254:
255: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
256: itemkey => itemkey,
257: aname => 'ORG_ID');
258:
259: IF l_orgid is NOT NULL THEN

Line 266: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

262:
263: END IF;
264:
265:
266: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
267: itemkey => itemkey,
268: aname => 'DOCUMENT_ID');
269:
270:

Line 271: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

267: itemkey => itemkey,
268: aname => 'DOCUMENT_ID');
269:
270:
271: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
272: itemkey => itemkey,
273: aname => 'DOCUMENT_TYPE');
274:
275: --< Bug 3554754 Start >

Line 299: resultout := wf_engine.eng_completed || ':' || l_is_new_document;

295: itemkey => itemkey,
296: aname => 'IS_NEW_DOCUMENT',
297: avalue => l_is_new_document );
298:
299: resultout := wf_engine.eng_completed || ':' || l_is_new_document;
300: --
301:
302: x_progress := 'PO_POAPPROVAL_INIT1.Is_this_new_doc: 02: ' || l_is_new_document;
303: IF (g_po_wf_debug = 'Y') THEN

Line 356: if (funcmode <> wf_engine.eng_run) then

352:
353:
354: -- Do nothing in cancel or timeout mode
355: --
356: if (funcmode <> wf_engine.eng_run) then
357:
358: resultout := wf_engine.eng_null;
359: return;
360:

Line 358: resultout := wf_engine.eng_null;

354: -- Do nothing in cancel or timeout mode
355: --
356: if (funcmode <> wf_engine.eng_run) then
357:
358: resultout := wf_engine.eng_null;
359: return;
360:
361: end if;
362:

Line 363: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

359: return;
360:
361: end if;
362:
363: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'ORG_ID');
366:
367: IF l_orgid is NOT NULL THEN

Line 374: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

370:
371: END IF;
372:
373:
374: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'DOCUMENT_ID');
377:
378: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 378: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

374: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'DOCUMENT_ID');
377:
378: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'DOCUMENT_TYPE');
381:
382: IF l_doc_type IN ('PO','PA') THEN

Line 400: resultout := wf_engine.eng_completed || ':' || 'Y';

396: END IF;
397:
398: IF NVL(l_acceptance_required,'N') = 'Y' THEN
399:
400: resultout := wf_engine.eng_completed || ':' || 'Y';
401:
402: ELSE
403:
404: resultout := wf_engine.eng_completed || ':' || 'N';

Line 404: resultout := wf_engine.eng_completed || ':' || 'N';

400: resultout := wf_engine.eng_completed || ':' || 'Y';
401:
402: ELSE
403:
404: resultout := wf_engine.eng_completed || ':' || 'N';
405:
406: END IF;
407:
408: x_progress := 'PO_POAPPROVAL_INIT1.Is_Acceptance_Required: 02';

Line 594: wf_engine.SetItemAttrText ( itemtype => itemtype,

590: ** Desc: There is no need to set the DOCUMENT_ID again as
591: ** it is set at the time of startup.
592: */
593:
594: wf_engine.SetItemAttrText ( itemtype => itemtype,
595: itemkey => itemkey,
596: aname => 'AUTHORIZATION_STATUS',
597: avalue => POHdr_rec.authorization_status);
598: --

Line 599: wf_engine.SetItemAttrText ( itemtype => itemtype,

595: itemkey => itemkey,
596: aname => 'AUTHORIZATION_STATUS',
597: avalue => POHdr_rec.authorization_status);
598: --
599: wf_engine.SetItemAttrText ( itemtype => itemtype,
600: itemkey => itemkey,
601: aname => 'CLOSED_CODE',
602: avalue => POHdr_rec.closed_code);
603:

Line 605: wf_engine.SetItemAttrText ( itemtype => itemtype,

601: aname => 'CLOSED_CODE',
602: avalue => POHdr_rec.closed_code);
603:
604: --
605: wf_engine.SetItemAttrText ( itemtype => itemtype,
606: itemkey => itemkey,
607: aname => 'FUNCTIONAL_CURRENCY',
608: avalue => POHdr_rec.currency_code);
609: --

Line 610: wf_engine.SetItemAttrText ( itemtype => itemtype,

606: itemkey => itemkey,
607: aname => 'FUNCTIONAL_CURRENCY',
608: avalue => POHdr_rec.currency_code);
609: --
610: wf_engine.SetItemAttrText ( itemtype => itemtype,
611: itemkey => itemkey,
612: aname => 'PO_DESCRIPTION',
613: avalue => POHdr_rec.comments);
614:

Line 616: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

612: aname => 'PO_DESCRIPTION',
613: avalue => POHdr_rec.comments);
614:
615:
616: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'DOCUMENT_ID');
619:
620:

Line 625: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

621:
622: /* Get the translated values for the DOC_TYPE, DOC_SUBTYPE, AUTH_STATUS and
623: ** CLOSED_CODE. These will be displayed in the notifications.
624: */
625: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
626: itemkey => itemkey,
627: aname => 'DOCUMENT_TYPE');
628:
629: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 629: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

625: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
626: itemkey => itemkey,
627: aname => 'DOCUMENT_TYPE');
628:
629: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
630: itemkey => itemkey,
631: aname => 'DOCUMENT_SUBTYPE');
632:
633: OPEN C1(POHdr_rec.authorization_status);

Line 659: wf_engine.SetItemAttrText ( itemtype => itemtype,

655: CLOSE C3;
656: end if;
657: --
658:
659: wf_engine.SetItemAttrText ( itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'AUTHORIZATION_STATUS_DISP',
662: avalue => l_auth_stat);
663: --

Line 664: wf_engine.SetItemAttrText ( itemtype => itemtype,

660: itemkey => itemkey,
661: aname => 'AUTHORIZATION_STATUS_DISP',
662: avalue => l_auth_stat);
663: --
664: wf_engine.SetItemAttrText ( itemtype => itemtype,
665: itemkey => itemkey,
666: aname => 'CLOSED_CODE_DISP',
667: avalue => l_closed_code);
668:

Line 672: wf_engine.SetItemAttrText ( itemtype => itemtype,

668:
669: --
670: -- Removed FPI GA Modifications to get PO_GA_TYPE Message for GA
671:
672: wf_engine.SetItemAttrText ( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'DOCUMENT_TYPE_DISP',
675: avalue => l_doc_type_disp);
676: --

Line 715: wf_engine.SetItemAttrText ( itemtype => itemtype,

711: IF (g_po_wf_debug = 'Y') THEN
712: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
713: END IF;
714:
715: wf_engine.SetItemAttrText ( itemtype => itemtype,
716: itemkey => itemkey,
717: aname => 'PO_AMOUNT_DSP',
718: avalue => l_po_amount_disp);
719:

Line 827: wf_engine.SetItemAttrText ( itemtype => itemtype,

823:
824: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
825: POHdr_rec.currency_code,30));
826:
827: wf_engine.SetItemAttrText ( itemtype => itemtype,
828: itemkey => itemkey,
829: aname => 'TAX_AMOUNT_DSP',
830: avalue => l_tax_amount_disp );
831:

Line 837: wf_engine.SetItemAttrText ( itemtype => itemtype,

833:
834: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(
835: POHdr_rec.currency_code,30));
836:
837: wf_engine.SetItemAttrText ( itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'TOTAL_AMOUNT_DSP',
840: avalue => l_total_amount_disp);
841:

Line 999: wf_engine.SetItemAttrText ( itemtype => itemtype,

995: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
996: END IF;
997:
998:
999: wf_engine.SetItemAttrText ( itemtype => itemtype,
1000: itemkey => itemkey,
1001: aname => 'RELEASE_TYPE',
1002: avalue => RelHdr_rec.Release_Type);
1003: --

Line 1004: wf_engine.SetItemAttrNumber ( itemtype => itemType,

1000: itemkey => itemkey,
1001: aname => 'RELEASE_TYPE',
1002: avalue => RelHdr_rec.Release_Type);
1003: --
1004: wf_engine.SetItemAttrNumber ( itemtype => itemType,
1005: itemkey => itemkey,
1006: aname => 'RELEASE_NUM',
1007: avalue => RelHdr_rec.Release_num);
1008: --

Line 1010: wf_engine.SetItemAttrText ( itemtype => itemtype,

1006: aname => 'RELEASE_NUM',
1007: avalue => RelHdr_rec.Release_num);
1008: --
1009:
1010: wf_engine.SetItemAttrText ( itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => 'AUTHORIZATION_STATUS',
1013: avalue => RelHdr_rec.authorization_status);
1014: --

Line 1015: wf_engine.SetItemAttrText ( itemtype => itemtype,

1011: itemkey => itemkey,
1012: aname => 'AUTHORIZATION_STATUS',
1013: avalue => RelHdr_rec.authorization_status);
1014: --
1015: wf_engine.SetItemAttrText ( itemtype => itemtype,
1016: itemkey => itemkey,
1017: aname => 'CLOSED_CODE',
1018: avalue => RelHdr_rec.closed_code);
1019: --

Line 1020: wf_engine.SetItemAttrText ( itemtype => itemtype,

1016: itemkey => itemkey,
1017: aname => 'CLOSED_CODE',
1018: avalue => RelHdr_rec.closed_code);
1019: --
1020: wf_engine.SetItemAttrText ( itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'DOCUMENT_NUMBER',
1023: avalue => RelHdr_rec.po_number);
1024: --

Line 1025: wf_engine.SetItemAttrText ( itemtype => itemtype,

1021: itemkey => itemkey,
1022: aname => 'DOCUMENT_NUMBER',
1023: avalue => RelHdr_rec.po_number);
1024: --
1025: wf_engine.SetItemAttrText ( itemtype => itemtype,
1026: itemkey => itemkey,
1027: aname => 'FUNCTIONAL_CURRENCY',
1028: avalue => RelHdr_rec.currency_code);
1029: --

Line 1030: wf_engine.SetItemAttrText ( itemtype => itemtype,

1026: itemkey => itemkey,
1027: aname => 'FUNCTIONAL_CURRENCY',
1028: avalue => RelHdr_rec.currency_code);
1029: --
1030: wf_engine.SetItemAttrText ( itemtype => itemtype,
1031: itemkey => itemkey,
1032: aname => 'RELEASE_NUM_DASH',
1033: avalue => '-');
1034:

Line 1036: wf_engine.SetItemAttrText ( itemtype => itemtype,

1032: aname => 'RELEASE_NUM_DASH',
1033: avalue => '-');
1034:
1035: --Bug 10140786 - Setting the PO_DESCRIPTION
1036: wf_engine.SetItemAttrText ( itemtype => itemtype,
1037: itemkey => itemkey,
1038: aname => 'PO_DESCRIPTION',
1039: avalue => RelHdr_rec.comments);
1040:

Line 1064: wf_engine.SetItemAttrText ( itemtype => itemtype,

1060: CLOSE C4;
1061: */
1062:
1063: --
1064: wf_engine.SetItemAttrText ( itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'AUTHORIZATION_STATUS_DISP',
1067: avalue => l_auth_stat);
1068: --

Line 1070: wf_engine.SetItemAttrText ( itemtype => itemtype,

1066: aname => 'AUTHORIZATION_STATUS_DISP',
1067: avalue => l_auth_stat);
1068: --
1069: /* Not using this currently
1070: wf_engine.SetItemAttrText ( itemtype => itemtype,
1071: itemkey => itemkey,
1072: aname => 'CLOSED_CODE_DISP',
1073: avalue => l_closed_code);
1074: */

Line 1076: wf_engine.SetItemAttrText ( itemtype => itemtype,

1072: aname => 'CLOSED_CODE_DISP',
1073: avalue => l_closed_code);
1074: */
1075: --
1076: wf_engine.SetItemAttrText ( itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'DOCUMENT_TYPE_DISP',
1079: avalue => l_doc_type_disp);
1080: --

Line 1088: wf_engine.SetItemAttrText ( itemtype => itemtype,

1084: ** subtype - DOCUMENT_TYPE_DISP, hence commenting the code below
1085: */
1086:
1087: /*
1088: wf_engine.SetItemAttrText ( itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'DOCUMENT_SUBTYPE_DISP',
1091: avalue => l_doc_subtype_disp);
1092: */

Line 1094: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1090: aname => 'DOCUMENT_SUBTYPE_DISP',
1091: avalue => l_doc_subtype_disp);
1092: */
1093:
1094: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1095: itemkey => itemkey,
1096: aname => 'DOCUMENT_ID');
1097:
1098: l_po_amount := po_notifications_sv3.get_doc_total('RELEASE', l_doc_id);

Line 1103: wf_engine.SetItemAttrText ( itemtype => itemtype,

1099:
1100: l_po_amount_disp := TO_CHAR(l_po_amount,FND_CURRENCY.GET_FORMAT_MASK(
1101: RelHdr_rec.currency_code,30));
1102:
1103: wf_engine.SetItemAttrText ( itemtype => itemtype,
1104: itemkey => itemkey,
1105: aname => 'PO_AMOUNT_DSP',
1106: avalue => l_po_amount_disp);
1107:

Line 1187: wf_engine.SetItemAttrText ( itemtype => itemtype,

1183:
1184: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
1185: RelHdr_rec.currency_code,30));
1186:
1187: wf_engine.SetItemAttrText ( itemtype => itemtype,
1188: itemkey => itemkey,
1189: aname => 'TAX_AMOUNT_DSP',
1190: avalue => l_tax_amount_disp );
1191:

Line 1198: wf_engine.SetItemAttrText ( itemtype => itemtype,

1194:
1195: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(
1196: RelHdr_rec.currency_code,30));
1197:
1198: wf_engine.SetItemAttrText ( itemtype => itemtype,
1199: itemkey => itemkey,
1200: aname => 'TOTAL_AMOUNT_DSP',
1201: avalue => l_total_amount_disp);
1202:

Line 1704: if (funcmode <> wf_engine.eng_run) then

1700: l_clm_document_number varchar2(50);
1701:
1702: BEGIN
1703: -- Do nothing if the Workflow mode is Cancel or Timeout.
1704: if (funcmode <> wf_engine.eng_run) then
1705: resultout := wf_engine.eng_null;
1706: return;
1707: end if;
1708:

Line 1705: resultout := wf_engine.eng_null;

1701:
1702: BEGIN
1703: -- Do nothing if the Workflow mode is Cancel or Timeout.
1704: if (funcmode <> wf_engine.eng_run) then
1705: resultout := wf_engine.eng_null;
1706: return;
1707: end if;
1708:
1709: l_document_type := po_wf_util_pkg.GetItemAttrText (

Line 1802: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1798: END LOOP; -- l_temp_labor_requesters_csr
1799:
1800: END IF; -- Standard PO
1801:
1802: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1803:
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: wf_core.context( g_pkg_name, l_proc_name, l_progress );

Line 1875: wf_engine.CreateProcess(itemtype => p_item_type,

1871:
1872: l_progress := '010';
1873:
1874: -- Create the child process.
1875: wf_engine.CreateProcess(itemtype => p_item_type,
1876: itemkey => p_item_key,
1877: process => p_process );
1878:
1879: l_progress := '020';

Line 1976: wf_engine.SetItemParent (itemtype => p_item_type,

1972:
1973: l_progress := '030';
1974:
1975: -- Set the parent-child relationship between the 2 processes.
1976: wf_engine.SetItemParent (itemtype => p_item_type,
1977: itemkey => p_item_key,
1978: parent_itemtype => p_parent_item_type,
1979: parent_itemkey => p_parent_item_key,
1980: parent_context => NULL);

Line 1985: wf_engine.StartProcess (itemtype => p_item_type,

1981:
1982: l_progress := '040';
1983:
1984: -- Start the child process.
1985: wf_engine.StartProcess (itemtype => p_item_type,
1986: itemkey => p_item_key );
1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN