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

Line 95: l_supplier := PO_WF_UTIL_PKG.GetItemAttrText

91: aname => 'NOTE');
92:
93: -- Show supplier and supplier site for
94: -- approval notifications
95: l_supplier := PO_WF_UTIL_PKG.GetItemAttrText
96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'SUPPLIER');
99:

Line 100: l_supplier_site := PO_WF_UTIL_PKG.GetItemAttrText

96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'SUPPLIER');
99:
100: l_supplier_site := PO_WF_UTIL_PKG.GetItemAttrText
101: (itemtype => l_item_type,
102: itemkey => l_item_key,
103: aname => 'SUPPLIER_SITE');
104: --

Line 447: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText

443: aname => 'FUNCTIONAL_CURRENCY');
444:
445:
446: -- Bug 3668188
447: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText
448: (itemtype => l_item_type,
449: itemkey => l_item_key,
450: aname => 'OPEN_FORM_COMMAND');
451:

Line 454: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

450: aname => 'OPEN_FORM_COMMAND');
451:
452: -- HTML Orders R12
453: -- Get the PO HTML Page URL's
454: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
455: itemtype => l_item_type,
456: itemkey => l_item_key,
457: aname => 'VIEW_DOC_URL');
458:

Line 459: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

455: itemtype => l_item_type,
456: itemkey => l_item_key,
457: aname => 'VIEW_DOC_URL');
458:
459: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
460: itemtype => l_item_type,
461: itemkey => l_item_key,
462: aname => 'EDIT_DOC_URL');
463:

Line 1078: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText

1074:
1075: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1076:
1077: -- Bug 3668188
1078: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText
1079: (itemtype => l_item_type,
1080: itemkey => l_item_key,
1081: aname => 'OPEN_FORM_COMMAND');
1082:

Line 1085: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

1081: aname => 'OPEN_FORM_COMMAND');
1082:
1083: -- HTML Orders R12
1084: -- Get the PO HTML Page URL's
1085: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
1086: itemtype => l_item_type,
1087: itemkey => l_item_key,
1088: aname => 'VIEW_DOC_URL');
1089:

Line 1090: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

1086: itemtype => l_item_type,
1087: itemkey => l_item_key,
1088: aname => 'VIEW_DOC_URL');
1089:
1090: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
1091: itemtype => l_item_type,
1092: itemkey => l_item_key,
1093: aname => 'EDIT_DOC_URL');
1094:

Line 1103: max_actions_dsp:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,

1099: ** If the attribute does not exist or is null, then we would use default
1100: ** value of 20.
1101: */
1102:
1103: max_actions_dsp:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,
1104: itemkey => l_item_key,
1105: aname => 'ACT_HST_IN_NTF');
1106:
1107: if max_actions_dsp is NULL then

Line 1422: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

1418: -- bug 4901406 : need to shift the setting of the preparer resp and appl id
1419: -- to here, it was not initialized inside the if condition if the control went to the
1420: -- else part.
1421: l_preparer_resp_id :=
1422: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
1423: itemkey => itemkey,
1424: aname => 'RESPONSIBILITY_ID');
1425: l_preparer_appl_id :=
1426: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

Line 1426: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

1422: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
1423: itemkey => itemkey,
1424: aname => 'RESPONSIBILITY_ID');
1425: l_preparer_appl_id :=
1426: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
1427: itemkey => itemkey,
1428: aname => 'APPLICATION_ID');
1429:
1430: --

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

1446: */
1447:
1448:
1449:
1450: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1451: itemkey => itemkey,
1452: aname => 'RESPONDER_USER_ID',
1453: avalue => l_responder_id);
1454: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1450: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1451: itemkey => itemkey,
1452: aname => 'RESPONDER_USER_ID',
1453: avalue => l_responder_id);
1454: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1455: itemkey => itemkey,
1456: aname => 'RESPONDER_RESP_ID',
1457: avalue => l_preparer_resp_id);
1458: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1454: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1455: itemkey => itemkey,
1456: aname => 'RESPONDER_RESP_ID',
1457: avalue => l_preparer_resp_id);
1458: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1459: itemkey => itemkey,
1460: aname => 'RESPONDER_APPL_ID',
1461: avalue => l_preparer_appl_id);
1462: else

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

1462: else
1463: if (l_session_resp_id is null) THEN
1464: /* possible when the response is made from the default worklist
1465: without choosing a valid responsibility */
1466: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1467: itemkey => itemkey,
1468: aname => 'RESPONDER_USER_ID',
1469: avalue => l_responder_id);
1470: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1466: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1467: itemkey => itemkey,
1468: aname => 'RESPONDER_USER_ID',
1469: avalue => l_responder_id);
1470: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1471: itemkey => itemkey,
1472: aname => 'RESPONDER_RESP_ID',
1473: avalue => l_preparer_resp_id);
1474: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1470: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1471: itemkey => itemkey,
1472: aname => 'RESPONDER_RESP_ID',
1473: avalue => l_preparer_resp_id);
1474: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1475: itemkey => itemkey,
1476: aname => 'RESPONDER_APPL_ID',
1477: avalue => l_preparer_appl_id);
1478: else

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

1486: This may happen due to the fact that the mailer / background process
1487: carries the context set by the notification/wf it processed last*/
1488:
1489: if ( l_preserved_ctx = 'TRUE') then
1490: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1491: itemkey => itemkey,
1492: aname => 'RESPONDER_USER_ID',
1493: avalue => l_responder_id);
1494: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1490: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1491: itemkey => itemkey,
1492: aname => 'RESPONDER_USER_ID',
1493: avalue => l_responder_id);
1494: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1495: itemkey => itemkey,
1496: aname => 'RESPONDER_RESP_ID',
1497: avalue => l_session_resp_id);
1498: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1494: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1495: itemkey => itemkey,
1496: aname => 'RESPONDER_RESP_ID',
1497: avalue => l_session_resp_id);
1498: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1499: itemkey => itemkey,
1500: aname => 'RESPONDER_APPL_ID',
1501: avalue => l_session_appl_id);
1502: else

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

1499: itemkey => itemkey,
1500: aname => 'RESPONDER_APPL_ID',
1501: avalue => l_session_appl_id);
1502: else
1503: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1504: itemkey => itemkey,
1505: aname => 'RESPONDER_USER_ID',
1506: avalue => l_responder_id);
1507: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1503: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1504: itemkey => itemkey,
1505: aname => 'RESPONDER_USER_ID',
1506: avalue => l_responder_id);
1507: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1508: itemkey => itemkey,
1509: aname => 'RESPONDER_RESP_ID',
1510: avalue => l_preparer_resp_id);
1511: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

1507: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1508: itemkey => itemkey,
1509: aname => 'RESPONDER_RESP_ID',
1510: avalue => l_preparer_resp_id);
1511: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
1512: itemkey => itemkey,
1513: aname => 'RESPONDER_APPL_ID',
1514: avalue => l_preparer_appl_id);
1515: end if;

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

1632: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1633:
1634: -- HTML Orders R12
1635: -- Set the URL and form attributes
1636: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
1637: itemkey => itemkey,
1638: aname => 'OPEN_FORM_COMMAND' ,
1639: avalue => '');
1640:

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

1637: itemkey => itemkey,
1638: aname => 'OPEN_FORM_COMMAND' ,
1639: avalue => '');
1640:
1641: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
1642: itemkey => itemkey,
1643: aname => 'VIEW_DOC_URL' ,
1644: avalue => '');
1645:

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

1642: itemkey => itemkey,
1643: aname => 'VIEW_DOC_URL' ,
1644: avalue => '');
1645:
1646: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
1647: itemkey => itemkey,
1648: aname => 'EDIT_DOC_URL' ,
1649: avalue => '');
1650: END IF;

Line 1655: l_conterms_exist_flag := PO_WF_UTIL_PKG.GetItemAttrText(

1651:
1652:
1653: --
1654:
1655: l_conterms_exist_flag := PO_WF_UTIL_PKG.GetItemAttrText(
1656: itemtype => itemtype,
1657: itemkey => itemkey,
1658: aname => 'CONTERMS_EXIST_FLAG');
1659:

Line 1660: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

1656: itemtype => itemtype,
1657: itemkey => itemkey,
1658: aname => 'CONTERMS_EXIST_FLAG');
1659:
1660: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
1661: itemtype => itemtype,
1662: itemkey => itemkey,
1663: aname => 'DOCUMENT_SUBTYPE');
1664:

Line 1665: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1661: itemtype => itemtype,
1662: itemkey => itemkey,
1663: aname => 'DOCUMENT_SUBTYPE');
1664:
1665: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1666: itemtype => itemtype,
1667: itemkey => itemkey,
1668: aname => 'DOCUMENT_ID');
1669:

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

1687: (PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T')
1688: )
1689: THEN
1690:
1691: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1692: itemkey => itemkey,
1693: aname => 'OKC_DOC_ATTACHMENT',
1694: avalue =>
1695: 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'||

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

1700: /* Contract terms are structured, or attached document is mergeable.
1701: * All contract terms will be in pdf; no need for other okc doc attachment.
1702: */
1703:
1704: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1705: itemkey => itemkey,
1706: aname => 'OKC_DOC_ATTACHMENT',
1707: avalue => '');
1708:

Line 1782: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1778: || username;
1779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1780:
1781: if ((doctype is NULL) or (docsubtype is null)) then
1782: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1783: itemkey => itemkey,
1784: aname => 'DOCUMENT_TYPE');
1785:
1786: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1786: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1782: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1783: itemkey => itemkey,
1784: aname => 'DOCUMENT_TYPE');
1785:
1786: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1787: itemkey => itemkey,
1788: aname => 'DOCUMENT_SUBTYPE');
1789: else
1790: l_doc_type := doctype;

Line 1796: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

1792: end if;
1793:
1794: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
1795:
1796: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
1797: itemkey => itemkey,
1798: aname => 'GLOBAL_AGREEMENT_FLAG');
1799: END IF;
1800:

Line 1806: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1802: notification attribute 'REQUIRES_APPROVAL_MSG' and 'PO_GA_TYPE'.
1803: Deleted the previous code and revamped it.
1804: */
1805: --
1806: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1807: (itemtype => itemtype,
1808: itemkey => itemkey,
1809: aname => 'DOCUMENT_ID');
1810:

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

1849: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 100, type disp: '
1850: || l_doc_disp;
1851: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1852:
1853: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'DOCUMENT_TYPE_DISP',
1856: avalue => l_doc_disp);
1857: BEGIN

Line 1867: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

1863: and fl.nls_language = l_language
1864: and fm.application_id = 201; -- Include application_id to better use PK index
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1868: itemkey => itemkey,
1869: aname => 'REQUIRES_APPROVAL_MSG');
1870: END;
1871:

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

1868: itemkey => itemkey,
1869: aname => 'REQUIRES_APPROVAL_MSG');
1870: END;
1871:
1872: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1873: itemkey => itemkey,
1874: aname => 'REQUIRES_APPROVAL_MSG',
1875: avalue => l_msg_text );
1876: