DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on WF_ENGINE

Line 45: l_document_id := wf_engine.GetItemAttrNumber

41:
42: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
43: l_item_key := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
44:
45: l_document_id := wf_engine.GetItemAttrNumber
46: (itemtype => l_item_type,
47: itemkey => l_item_key,
48: aname => 'DOCUMENT_ID');
49:

Line 50: l_org_id := wf_engine.GetItemAttrNumber

46: (itemtype => l_item_type,
47: itemkey => l_item_key,
48: aname => 'DOCUMENT_ID');
49:
50: l_org_id := wf_engine.GetItemAttrNumber
51: (itemtype => l_item_type,
52: itemkey => l_item_key,
53: aname => 'ORG_ID');
54:

Line 58: l_currency_code := wf_engine.GetItemAttrText

54:
55: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
56:
57:
58: l_currency_code := wf_engine.GetItemAttrText
59: (itemtype => l_item_type,
60: itemkey => l_item_key,
61: aname => 'FUNCTIONAL_CURRENCY');
62:

Line 63: l_po_amount := wf_engine.GetItemAttrText

59: (itemtype => l_item_type,
60: itemkey => l_item_key,
61: aname => 'FUNCTIONAL_CURRENCY');
62:
63: l_po_amount := wf_engine.GetItemAttrText
64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'PO_AMOUNT_DSP');
67:

Line 68: l_tax_amount := wf_engine.GetItemAttrText

64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'PO_AMOUNT_DSP');
67:
68: l_tax_amount := wf_engine.GetItemAttrText
69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'TAX_AMOUNT_DSP');
72:

Line 73: l_description := wf_engine.GetItemAttrText

69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'TAX_AMOUNT_DSP');
72:
73: l_description := wf_engine.GetItemAttrText
74: (itemtype => l_item_type,
75: itemkey => l_item_key,
76: aname => 'PO_DESCRIPTION');
77:

Line 78: l_forwarded_from := wf_engine.GetItemAttrText

74: (itemtype => l_item_type,
75: itemkey => l_item_key,
76: aname => 'PO_DESCRIPTION');
77:
78: l_forwarded_from := wf_engine.GetItemAttrText
79: (itemtype => l_item_type,
80: itemkey => l_item_key,
81: aname => 'FORWARD_FROM_DISP_NAME');
82:

Line 83: l_preparer := wf_engine.GetItemAttrText

79: (itemtype => l_item_type,
80: itemkey => l_item_key,
81: aname => 'FORWARD_FROM_DISP_NAME');
82:
83: l_preparer := wf_engine.GetItemAttrText
84: (itemtype => l_item_type,
85: itemkey => l_item_key,
86: aname => 'PREPARER_DISPLAY_NAME');
87:

Line 88: l_note := wf_engine.GetItemAttrText

84: (itemtype => l_item_type,
85: itemkey => l_item_key,
86: aname => 'PREPARER_DISPLAY_NAME');
87:
88: l_note := wf_engine.GetItemAttrText
89: (itemtype => l_item_type,
90: itemkey => l_item_key,
91: aname => 'NOTE');
92:

Line 420: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

416: */
417:
418: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(l_item_type, l_item_key);
419:
420: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
421: itemkey => l_item_key,
422: aname => 'DOCUMENT_ID');
423:
424: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

Line 424: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,

420: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
421: itemkey => l_item_key,
422: aname => 'DOCUMENT_ID');
423:
424: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
425: itemkey => l_item_key,
426: aname => 'ORG_ID');
427:
428: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

Line 428: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

424: l_org_id := wf_engine.GetItemAttrNumber (itemtype => l_item_type,
425: itemkey => l_item_key,
426: aname => 'ORG_ID');
427:
428: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
429: itemkey => l_item_key,
430: aname => 'DOCUMENT_TYPE');
431:
432: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 440: l_currency_code := wf_engine.GetItemAttrText

436: ** Desc: Use the functional currency of the PO for the precision of
437: ** line amounts.
438: */
439:
440: l_currency_code := wf_engine.GetItemAttrText
441: (itemtype => l_item_type,
442: itemkey => l_item_key,
443: aname => 'FUNCTIONAL_CURRENCY');
444:

Line 1061: l_document_id := wf_engine.GetItemAttrNumber

1057: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1058: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1059: length(document_id) - 2);
1060:
1061: l_document_id := wf_engine.GetItemAttrNumber
1062: (itemtype => l_item_type,
1063: itemkey => l_item_key,
1064: aname => 'DOCUMENT_ID');
1065:

Line 1066: l_org_id := wf_engine.GetItemAttrNumber

1062: (itemtype => l_item_type,
1063: itemkey => l_item_key,
1064: aname => 'DOCUMENT_ID');
1065:
1066: l_org_id := wf_engine.GetItemAttrNumber
1067: (itemtype => l_item_type,
1068: itemkey => l_item_key,
1069: aname => 'ORG_ID');
1070:

Line 1071: l_doc_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,

1067: (itemtype => l_item_type,
1068: itemkey => l_item_key,
1069: aname => 'ORG_ID');
1070:
1071: l_doc_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,
1072: itemkey => l_item_key,
1073: aname => 'DOCUMENT_TYPE');
1074:
1075: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 1362: l_nid := WF_ENGINE.context_nid;

1358: begin
1359:
1360: -- Context setting revamp
1361: if (funcmode = 'RESPOND') then
1362: l_nid := WF_ENGINE.context_nid;
1363:
1364: SELECT fu.USER_ID
1365: INTO l_responder_id
1366: FROM fnd_user fu,

Line 1372: if (wf_engine.preserved_context = TRUE) then

1368: WHERE wfn.notification_id = l_nid
1369: AND wfn.original_recipient = fu.user_name;
1370:
1371: --
1372: if (wf_engine.preserved_context = TRUE) then
1373: l_preserved_ctx := 'TRUE';
1374: else
1375: l_preserved_ctx := 'FALSE';
1376: end if;

Line 1525: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1521:
1522: -- Context setting revamp
1523:
1524:
1525: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1526: l_progress := '040 returning from notif callback -respond mode';
1527: IF (g_po_wf_debug = 'Y') THEN
1528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1529: END IF;

Line 1540: resultout := wf_engine.eng_completed;

1536:
1537: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
1538: app_exception.raise_exception;
1539:
1540: resultout := wf_engine.eng_completed;
1541: return;
1542:
1543: end if; -- end if for funcmode = 'TRANSFER'
1544:

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

1573: BEGIN
1574:
1575: -- Do nothing in cancel or timeout mode
1576: --
1577: if (funcmode <> wf_engine.eng_run) then
1578: resultout := wf_engine.eng_null;
1579: return;
1580: end if;
1581:

Line 1578: resultout := wf_engine.eng_null;

1574:
1575: -- Do nothing in cancel or timeout mode
1576: --
1577: if (funcmode <> wf_engine.eng_run) then
1578: resultout := wf_engine.eng_null;
1579: return;
1580: end if;
1581:
1582: l_progress := 'Get_po_user_msg_attribute:001: actid: ' || actid;

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

1581:
1582: l_progress := 'Get_po_user_msg_attribute:001: actid: ' || actid;
1583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1584:
1585: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1586: itemkey => itemkey,
1587: aname => 'ORG_ID');
1588:
1589: IF l_orgid is NOT NULL THEN

Line 1596: l_user_name := wf_engine.GetActivityAttrText (itemtype => itemtype,

1592:
1593: l_progress := 'Get_po_user_msg_attribute:010: orgid: ' || l_orgid;
1594: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1595:
1596: l_user_name := wf_engine.GetActivityAttrText (itemtype => itemtype,
1597: itemkey => itemkey,
1598: actid => actid,
1599: aname => 'NTF_USER_NAME',
1600: ignore_notfound => TRUE);

Line 1612: l_notification_type := wf_engine.GetActivityAttrText (

1608:
1609: -- Bug 3668188: added the NTF_USER_ROLE Activity Attribute, which is
1610: -- a constant with value 'SUBMITTER' or 'APPROVER'. This distinguishes
1611: -- between the 3 different notification-functions that share this procedure.
1612: l_notification_type := wf_engine.GetActivityAttrText (
1613: itemtype => itemtype,
1614: itemkey => itemkey,
1615: actid => actid,
1616: aname => 'NTF_USER_ROLE',

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

1717:
1718: l_progress := 'Get_po_approver_msg_attribute: 999';
1719: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1720:
1721: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 1947: l_authorization_status := wf_engine.GetItemAttrText

1943:
1944: -- Get the Authorization Status (e.g. 'PRE-APPROVED','APPROVED',
1945: -- 'INCOMPLETE', etc.) of the document.
1946: --
1947: l_authorization_status := wf_engine.GetItemAttrText
1948: ( itemtype => p_itemtype
1949: , itemkey => p_itemkey
1950: , aname => 'AUTHORIZATION_STATUS'
1951: );