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

Line 104: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(

100: END IF;
101:
102: --
103:
104: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(
105: itemtype => itemtype
106: , itemkey => itemkey
107: , aname => 'DOCUMENT_TYPE'
108: );

Line 110: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

106: , itemkey => itemkey
107: , aname => 'DOCUMENT_TYPE'
108: );
109:
110: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
111: itemtype => itemtype
112: , itemkey => itemkey
113: , aname => 'DOCUMENT_SUBTYPE'
114: );

Line 118: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrText(

114: );
115:
116: IF ((l_document_type = 'PO') AND (l_document_subtype = 'STANDARD')) THEN
117:
118: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrText(
119: itemtype => itemtype
120: , itemkey => itemkey
121: , aname => 'DOCUMENT_ID'
122: );

Line 147: l_retroactive_change := PO_WF_UTIL_PKG.GetItemAttrText

143: * this approval is initiated due to the retroactive change in
144: * the release. If this value is N, then we send the document
145: * through Change Order Workflow.
146: */
147: l_retroactive_change := PO_WF_UTIL_PKG.GetItemAttrText
148: (itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'CO_R_RETRO_CHANGE');
151:

Line 154: l_autoapprove_retro := PO_WF_UTIL_PKG.GetItemAttrText

150: aname => 'CO_R_RETRO_CHANGE');
151:
152: If (l_retroactive_change = 'Y') then
153:
154: l_autoapprove_retro := PO_WF_UTIL_PKG.GetItemAttrText
155: (itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'CO_H_RETROACTIVE_AUTOAPPROVAL');
158:

Line 165: l_actionoriginated_from := PO_WF_UTIL_PKG.GetItemAttrText

161: the value which indicates where the approval workflow is called from.If
162: approval is called from "Retroactive" concurrent program only then check
163: for the "automatic approval" wf attribute */
164:
165: l_actionoriginated_from := PO_WF_UTIL_PKG.GetItemAttrText
166: (itemtype => itemtype,
167: itemkey => itemkey,
168: aname => 'INTERFACE_SOURCE_CODE');
169:

Line 755: PO_WF_UTIL_PKG.GetItemAttrText (itemtype , itemkey,'GA_ORG_ASSIGN_CHANGE');

751: -- Bug 2911017 START
752: -- Require reapproval if the GA org assignments have been changed.
753: IF x_result <> 'Y' THEN
754: l_ga_org_assign_change :=
755: PO_WF_UTIL_PKG.GetItemAttrText (itemtype , itemkey,'GA_ORG_ASSIGN_CHANGE');
756: IF l_ga_org_assign_change = 'Y' THEN
757: IF (g_po_wf_debug = 'Y') THEN
758: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
759: '########## GA org assignments require reapproval result: Y');

Line 943: l_retroactive_change := PO_WF_UTIL_PKG.GetItemAttrText

939: * this approval is initiated due to the retroactive change in
940: * the release. If this value is Y, then we send the document
941: * through Change Order Workflow.
942: */
943: l_retroactive_change := PO_WF_UTIL_PKG.GetItemAttrText
944: (itemtype => itemtype,
945: itemkey => itemkey,
946: aname => 'CO_R_RETRO_CHANGE');
947:

Line 950: l_autoapprove_retro := PO_WF_UTIL_PKG.GetItemAttrText

946: aname => 'CO_R_RETRO_CHANGE');
947:
948: If (l_retroactive_change = 'Y') then
949:
950: l_autoapprove_retro := PO_WF_UTIL_PKG.GetItemAttrText
951: (itemtype => itemtype,
952: itemkey => itemkey,
953: aname => 'CO_H_RETROACTIVE_AUTOAPPROVAL');
954: /*Bug5697556 Get the wf attribute value 'INTERFACE_SOURCE_CODE'.This would be

Line 959: l_actionoriginated_from := PO_WF_UTIL_PKG.GetItemAttrText

955: the value which indicates where the approval workflow is called from.If
956: approval is called from "Retroactive" concurrent program only then check
957: for the "automatic approval" wf attribute */
958:
959: l_actionoriginated_from := PO_WF_UTIL_PKG.GetItemAttrText
960: (itemtype => itemtype,
961: itemkey => itemkey,
962: aname => 'INTERFACE_SOURCE_CODE');
963:

Line 1334: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1330: END IF;
1331:
1332: -- Common attributes
1333: x_tolerance_control.s_quantity_t :=
1334: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1335: itemkey,
1336: 'CO_S_QUANTITY_T');
1337:
1338: x_tolerance_control.h_amount_limit_t :=

Line 1339: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1335: itemkey,
1336: 'CO_S_QUANTITY_T');
1337:
1338: x_tolerance_control.h_amount_limit_t :=
1339: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1340: itemkey,
1341: 'CO_H_AMOUNT_LIMIT_T');
1342:
1343: x_tolerance_control.l_unit_price_t :=

Line 1344: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1340: itemkey,
1341: 'CO_H_AMOUNT_LIMIT_T');
1342:
1343: x_tolerance_control.l_unit_price_t :=
1344: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1345: itemkey,
1346: 'CO_L_UNIT_PRICE_T');
1347:
1348: x_tolerance_control.s_price_override_t :=

Line 1349: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1345: itemkey,
1346: 'CO_L_UNIT_PRICE_T');
1347:
1348: x_tolerance_control.s_price_override_t :=
1349: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1350: itemkey,
1351: 'CO_S_PRICE_OVERRIDE_T');
1352:
1353: -- Common attributes between orders and releases

Line 1357: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1353: -- Common attributes between orders and releases
1354: IF doc_type in ('PO','RELEASE') THEN
1355:
1356: x_tolerance_control.s_need_by_date_t :=
1357: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1358: itemkey,
1359: 'CO_S_NEED_BY_DATE_T');
1360:
1361: x_tolerance_control.s_promised_date_t :=

Line 1362: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1358: itemkey,
1359: 'CO_S_NEED_BY_DATE_T');
1360:
1361: x_tolerance_control.s_promised_date_t :=
1362: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1363: itemkey,
1364: 'CO_S_PROMISED_DATE_T');
1365:
1366: x_tolerance_control.d_quantity_ordered_t:=

Line 1367: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1363: itemkey,
1364: 'CO_S_PROMISED_DATE_T');
1365:
1366: x_tolerance_control.d_quantity_ordered_t:=
1367: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1368: itemkey,
1369: 'CO_D_QUANTITY_ORDERED_T');
1370:
1371: x_tolerance_control.d_amount_ordered_t:=

Line 1372: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1368: itemkey,
1369: 'CO_D_QUANTITY_ORDERED_T');
1370:
1371: x_tolerance_control.d_amount_ordered_t:=
1372: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1373: itemkey,
1374: 'CO_D_AMOUNT_ORDERED_T');
1375:
1376: x_tolerance_control.s_amount_t :=

Line 1377: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1373: itemkey,
1374: 'CO_D_AMOUNT_ORDERED_T');
1375:
1376: x_tolerance_control.s_amount_t :=
1377: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1378: itemkey,
1379: 'CO_S_AMOUNT_T');
1380: END IF;
1381:

Line 1386: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1382: -- Attributes for orders
1383: IF doc_type = 'PO' THEN
1384:
1385: x_tolerance_control.h_po_total_t :=
1386: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1387: itemkey,
1388: 'CO_H_PO_TOTAL_T');
1389:
1390: x_tolerance_control.l_start_date_t :=

Line 1391: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1387: itemkey,
1388: 'CO_H_PO_TOTAL_T');
1389:
1390: x_tolerance_control.l_start_date_t :=
1391: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1392: itemkey,
1393: 'CO_L_START_DATE_T');
1394:
1395: x_tolerance_control.l_end_date_t :=

Line 1396: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1392: itemkey,
1393: 'CO_L_START_DATE_T');
1394:
1395: x_tolerance_control.l_end_date_t :=
1396: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1397: itemkey,
1398: 'CO_L_END_DATE_T');
1399:
1400: x_tolerance_control.l_quantity_t :=

Line 1401: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1397: itemkey,
1398: 'CO_L_END_DATE_T');
1399:
1400: x_tolerance_control.l_quantity_t :=
1401: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1402: itemkey,
1403: 'CO_L_QUANTITY_T');
1404:
1405: x_tolerance_control.l_amount_t :=

Line 1406: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1402: itemkey,
1403: 'CO_L_QUANTITY_T');
1404:
1405: x_tolerance_control.l_amount_t :=
1406: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1407: itemkey,
1408: 'CO_L_AMOUNT_T');
1409:
1410: -- Complex work attributes

Line 1412: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1408: 'CO_L_AMOUNT_T');
1409:
1410: -- Complex work attributes
1411: x_tolerance_control.p_quantity_t :=
1412: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1413: itemkey,
1414: 'CO_P_QUANTITY_T');
1415:
1416: x_tolerance_control.p_price_override_t :=

Line 1417: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1413: itemkey,
1414: 'CO_P_QUANTITY_T');
1415:
1416: x_tolerance_control.p_price_override_t :=
1417: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1418: itemkey,
1419: 'CO_P_PRICE_OVERRIDE_T');
1420:
1421: x_tolerance_control.p_amount_t :=

Line 1422: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1418: itemkey,
1419: 'CO_P_PRICE_OVERRIDE_T');
1420:
1421: x_tolerance_control.p_amount_t :=
1422: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1423: itemkey,
1424: 'CO_P_AMOUNT_T');
1425: END IF;
1426:

Line 1430: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1426:
1427: -- attributes for agreements
1428: IF doc_type = 'PA' THEN
1429: x_tolerance_control.h_blanket_total_t :=
1430: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1431: itemkey,
1432: 'CO_H_BLANKET_TOTAL_T');
1433:
1434: x_tolerance_control.l_quantity_committed_t :=

Line 1435: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1431: itemkey,
1432: 'CO_H_BLANKET_TOTAL_T');
1433:
1434: x_tolerance_control.l_quantity_committed_t :=
1435: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1436: itemkey,
1437: 'CO_L_QTY_COMMITTED_T');
1438:
1439: x_tolerance_control.l_committed_amount_t :=

Line 1440: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1436: itemkey,
1437: 'CO_L_QTY_COMMITTED_T');
1438:
1439: x_tolerance_control.l_committed_amount_t :=
1440: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1441: itemkey,
1442: 'CO_L_COMMITTED_AMT_T');
1443:
1444: x_tolerance_control.l_price_limit_t :=

Line 1445: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,

1441: itemkey,
1442: 'CO_L_COMMITTED_AMT_T');
1443:
1444: x_tolerance_control.l_price_limit_t :=
1445: PO_WF_UTIL_PKG.GetItemAttrText(itemtype,
1446: itemkey,
1447: 'CO_L_NOT_TO_EXCEED_PRICE_T');
1448: END IF;
1449:

Line 1501: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,

1497: '*** In Procedure: Set_Wf_Order_Tol ***');
1498: END IF;
1499:
1500: -- Retrieve organization id
1501: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,
1502: itemkey => itemkey,
1503: aname => 'ORG_ID');
1504: -- Retrieve the tolerances
1505: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

Line 1529: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1525: -- common tolerances
1526: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_UNIT_PRICE) then
1527:
1528: if x_tol_tab(i).max_increment is not null then
1529: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1530: itemkey,
1531: 'CO_L_UNIT_PRICE_T',
1532: x_tol_tab(i).max_increment);
1533: end if;

Line 1538: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1534:
1535: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_QTY) then
1536:
1537: if x_tol_tab(i).max_increment is not null then
1538: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1539: itemkey,
1540: 'CO_L_QUANTITY_T',
1541: x_tol_tab(i).max_increment);
1542: end if;

Line 1547: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1543:
1544: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_QTY) then
1545:
1546: if x_tol_tab(i).max_increment is not null then
1547: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1548: itemkey,
1549: 'CO_S_QUANTITY_T',
1550: x_tol_tab(i).max_increment);
1551: end if;

Line 1556: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1552:
1553: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_QTY) then
1554:
1555: if x_tol_tab(i).max_increment is not null then
1556: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1557: itemkey,
1558: 'CO_D_QUANTITY_ORDERED_T',
1559: x_tol_tab(i).max_increment);
1560: end if;

Line 1565: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1561:
1562: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_NEED_BY_DATE) then
1563:
1564: if x_tol_tab(i).max_increment is not null then
1565: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1566: itemkey,
1567: 'CO_S_NEED_BY_DATE_T',
1568: x_tol_tab(i).max_increment);
1569: end if;

Line 1574: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1570:
1571: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PROMISED_DATE) then
1572:
1573: if x_tol_tab(i).max_increment is not null then
1574: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1575: itemkey,
1576: 'CO_S_PROMISED_DATE_T',
1577: x_tol_tab(i).max_increment);
1578: end if;

Line 1587: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1583: if (order_type = 'STANDARD') then
1584: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PO_AMOUNT) then
1585:
1586: if x_tol_tab(i).max_increment is not null then
1587: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1588: itemkey,
1589: 'CO_H_PO_TOTAL_T',
1590: x_tol_tab(i).max_increment);
1591: end if;

Line 1596: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1592:
1593: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_AMOUNT_PERCENT) then
1594:
1595: if x_tol_tab(i).max_increment is not null then
1596: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1597: itemkey,
1598: 'CO_L_AMOUNT_T',
1599: x_tol_tab(i).max_increment);
1600: end if;

Line 1605: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1601:
1602: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_AMOUNT_PERCENT) then
1603:
1604: if x_tol_tab(i).max_increment is not null then
1605: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1606: itemkey,
1607: 'CO_S_AMOUNT_T',
1608: x_tol_tab(i).max_increment);
1609: end if;

Line 1614: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1610:
1611: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_AMOUNT_PERCENT) then
1612:
1613: if x_tol_tab(i).max_increment is not null then
1614: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1615: itemkey,
1616: 'CO_D_AMOUNT_ORDERED_T',
1617: x_tol_tab(i).max_increment);
1618: end if;

Line 1623: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1619: --
1620: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_AMOUNT_PERCENT) then
1621:
1622: if x_tol_tab(i).max_increment is not null then
1623: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1624: itemkey,
1625: 'CO_P_AMOUNT_T',
1626: x_tol_tab(i).max_increment);
1627: end if;

Line 1632: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1628:
1629: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_QTY) then
1630:
1631: if x_tol_tab(i).max_increment is not null then
1632: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1633: itemkey,
1634: 'CO_P_QUANTITY_T',
1635: x_tol_tab(i).max_increment);
1636: end if;

Line 1641: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1637:
1638: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_PRICE) then
1639:
1640: if x_tol_tab(i).max_increment is not null then
1641: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1642: itemkey,
1643: 'CO_P_PRICE_OVERRIDE_T',
1644: x_tol_tab(i).max_increment);
1645: end if;

Line 1651: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1647: --
1648: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_START_DATE) then
1649:
1650: if x_tol_tab(i).max_increment is not null then
1651: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1652: itemkey,
1653: 'CO_L_START_DATE_T',
1654: x_tol_tab(i).max_increment);
1655: end if;

Line 1660: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1656:
1657: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_END_DATE) then
1658:
1659: if x_tol_tab(i).max_increment is not null then
1660: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1661: itemkey,
1662: 'CO_L_END_DATE_T',
1663: x_tol_tab(i).max_increment);
1664: end if;

Line 1672: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1668: else -- Planned PO tolerances
1669: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then
1670:
1671: if x_tol_tab(i).max_increment is not null then
1672: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1673: itemkey,
1674: 'CO_H_AMOUNT_LIMIT_T',
1675: x_tol_tab(i).max_increment);
1676: end if;

Line 1735: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,

1731: '*** In Procedure: Set_Wf_Agreement_Tol ***');
1732: END IF;
1733:
1734: -- Retrieve organization id
1735: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,
1736: itemkey => itemkey,
1737: aname => 'ORG_ID');
1738: -- Retrieve the tolerances
1739: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

Line 1763: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1759: if (agreement_type = 'CONTRACT') then
1760:
1761: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then
1762: if x_tol_tab(i).max_increment is not null then
1763: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1764: itemkey,
1765: 'CO_H_AMOUNT_LIMIT_T',
1766: x_tol_tab(i).max_increment);
1767: end if;

Line 1772: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1768:
1769: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_AGREED) then
1770:
1771: if x_tol_tab(i).max_increment is not null then
1772: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1773: itemkey,
1774: 'CO_H_BLANKET_TOTAL_T',
1775: x_tol_tab(i).max_increment);
1776: end if;

Line 1783: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1779: else -- Blanket PO
1780: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_AGREED) then
1781:
1782: if x_tol_tab(i).max_increment is not null then
1783: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1784: itemkey,
1785: 'CO_H_BLANKET_TOTAL_T',
1786: x_tol_tab(i).max_increment);
1787: end if;

Line 1792: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1788:
1789: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then
1790:
1791: if x_tol_tab(i).max_increment is not null then
1792: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1793: itemkey,
1794: 'CO_H_AMOUNT_LIMIT_T',
1795: x_tol_tab(i).max_increment);
1796: end if;

Line 1801: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1797:
1798: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_UNIT_PRICE) then
1799:
1800: if x_tol_tab(i).max_increment is not null then
1801: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1802: itemkey,
1803: 'CO_L_UNIT_PRICE_T',
1804: x_tol_tab(i).max_increment);
1805: end if;

Line 1810: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1806:
1807: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRICE_LIMIT) then
1808:
1809: if x_tol_tab(i).max_increment is not null then
1810: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1811: itemkey,
1812: 'CO_L_NOT_TO_EXCEED_PRICE_T',
1813: x_tol_tab(i).max_increment);
1814: end if;

Line 1818: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1814: end if;
1815:
1816: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_QTY_AGREED) then
1817: if x_tol_tab(i).max_increment is not null then
1818: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1819: itemkey,
1820: 'CO_L_QTY_COMMITTED_T',
1821: x_tol_tab(i).max_increment);
1822: end if;

Line 1827: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1823:
1824: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_AMOUNT_AGREED) then
1825:
1826: if x_tol_tab(i).max_increment is not null then
1827: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1828: itemkey,
1829: 'CO_L_COMMITTED_AMT_T',
1830: x_tol_tab(i).max_increment);
1831: end if;

Line 1836: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1832:
1833: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRC_BRK_PRICE) then
1834:
1835: if x_tol_tab(i).max_increment is not null then
1836: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1837: itemkey,
1838: 'CO_S_PRICE_OVERRIDE_T',
1839: x_tol_tab(i).max_increment);
1840: end if;

Line 1845: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1841:
1842: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRC_BRK_QTY) then
1843:
1844: if x_tol_tab(i).max_increment is not null then
1845: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1846: itemkey,
1847: 'CO_S_QUANTITY_T',
1848: x_tol_tab(i).max_increment);
1849: end if;

Line 1906: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,

1902: '*** In Procedure: Set_Wf_Release_Tol ***');
1903: END IF;
1904:
1905: -- Retrieve organization id
1906: x_org_id:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemType,
1907: itemkey => itemkey,
1908: aname => 'ORG_ID');
1909: -- Retrieve the tolerances
1910: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

Line 1934: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1930: -- Common Tolerances
1931: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_PRICE) then
1932:
1933: if x_tol_tab(i).max_increment is not null then
1934: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1935: itemkey,
1936: 'CO_S_PRICE_OVERRIDE_T',
1937: x_tol_tab(i).max_increment);
1938: end if;

Line 1943: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1939:
1940: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_QTY) then
1941:
1942: if x_tol_tab(i).max_increment is not null then
1943: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1944: itemkey,
1945: 'CO_S_QUANTITY_T',
1946: x_tol_tab(i).max_increment);
1947: end if;

Line 1952: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1948:
1949: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_QTY) then
1950:
1951: if x_tol_tab(i).max_increment is not null then
1952: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1953: itemkey,
1954: 'CO_D_QUANTITY_ORDERED_T',
1955: x_tol_tab(i).max_increment);
1956:

Line 1963: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1959: elsif (x_tol_tab(i).tolerance_name =
1960: PO_CO_TOLERANCES_GRP.G_SHIPMENT_AMOUNT_PERCENT) then
1961:
1962: if x_tol_tab(i).max_increment is not null then
1963: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1964: itemkey,
1965: 'CO_S_AMOUNT_T',
1966: x_tol_tab(i).max_increment);
1967: end if;

Line 1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1969: elsif (x_tol_tab(i).tolerance_name =
1970: PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_AMOUNT_PERCENT) then
1971:
1972: if x_tol_tab(i).max_increment is not null then
1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1974: itemkey,
1975: 'CO_D_AMOUNT_ORDERED_T',
1976: x_tol_tab(i).max_increment);
1977: end if;

Line 1985: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1981:
1982: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_NEED_BY_DATE) then
1983:
1984: if x_tol_tab(i).max_increment is not null then
1985: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1986: itemkey,
1987: 'CO_S_NEED_BY_DATE_T',
1988: x_tol_tab(i).max_increment);
1989: end if;

Line 1994: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,

1990:
1991: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PROMISED_DATE) then
1992:
1993: if x_tol_tab(i).max_increment is not null then
1994: PO_WF_UTIL_PKG.SetItemAttrText(itemtype,
1995: itemkey,
1996: 'CO_S_PROMISED_DATE_T',
1997: x_tol_tab(i).max_increment);
1998: end if;