DBA Data[Home] [Help]

APPS.PO_CHORD_WF6 dependencies on PO_CO_TOLERANCES_GRP

Line 1262: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;

1258: x_tolerance_control IN OUT NOCOPY t_tolerance_control_type,
1259: chord_doc_type IN VARCHAR2 default NULL)
1260: IS
1261: x_org_id number;
1262: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;
1263: p_api_name varchar2(50):= 'get_default_tolerance';
1264: x_return_status varchar2(1);
1265: x_msg_count NUMBER;
1266: x_msg_data VARCHAR2(2000);

Line 1489: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;

1485: itemkey IN VARCHAR2,
1486: order_type IN VARCHAR2)
1487: IS
1488: x_org_id number;
1489: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;
1490: x_return_status varchar2(1);
1491: x_msg_count NUMBER;
1492: x_msg_data VARCHAR2(2000);
1493: BEGIN

Line 1505: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

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,
1506: FND_API.G_TRUE,
1507: x_org_id,
1508: PO_CO_TOLERANCES_GRP.G_CHG_ORDERS,
1509: x_tol_tab,

Line 1508: PO_CO_TOLERANCES_GRP.G_CHG_ORDERS,

1504: -- Retrieve the tolerances
1505: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,
1506: FND_API.G_TRUE,
1507: x_org_id,
1508: PO_CO_TOLERANCES_GRP.G_CHG_ORDERS,
1509: x_tol_tab,
1510: x_return_status,
1511: x_msg_count,
1512: x_msg_data);

Line 1526: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_UNIT_PRICE) then

1522: -- Assign the values
1523: -- ECO 4716963: Added a condition for all tolerences to only assign not
1524: -- null values from the table
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,

Line 1535: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_QTY) then

1531: 'CO_L_UNIT_PRICE_T',
1532: x_tol_tab(i).max_increment);
1533: end if;
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,

Line 1544: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_QTY) then

1540: 'CO_L_QUANTITY_T',
1541: x_tol_tab(i).max_increment);
1542: end if;
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,

Line 1553: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_QTY) then

1549: 'CO_S_QUANTITY_T',
1550: x_tol_tab(i).max_increment);
1551: end if;
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,

Line 1562: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_NEED_BY_DATE) then

1558: 'CO_D_QUANTITY_ORDERED_T',
1559: x_tol_tab(i).max_increment);
1560: end if;
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,

Line 1571: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PROMISED_DATE) then

1567: 'CO_S_NEED_BY_DATE_T',
1568: x_tol_tab(i).max_increment);
1569: end if;
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,

Line 1584: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PO_AMOUNT) then

1580: end if;
1581:
1582: -- Standard PO tolerances
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,

Line 1593: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_AMOUNT_PERCENT) then

1589: 'CO_H_PO_TOTAL_T',
1590: x_tol_tab(i).max_increment);
1591: end if;
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,

Line 1602: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_AMOUNT_PERCENT) then

1598: 'CO_L_AMOUNT_T',
1599: x_tol_tab(i).max_increment);
1600: end if;
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,

Line 1611: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_AMOUNT_PERCENT) then

1607: 'CO_S_AMOUNT_T',
1608: x_tol_tab(i).max_increment);
1609: end if;
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,

Line 1620: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_AMOUNT_PERCENT) then

1616: 'CO_D_AMOUNT_ORDERED_T',
1617: x_tol_tab(i).max_increment);
1618: end if;
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,

Line 1629: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_QTY) then

1625: 'CO_P_AMOUNT_T',
1626: x_tol_tab(i).max_increment);
1627: end if;
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,

Line 1638: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PAY_ITEM_PRICE) then

1634: 'CO_P_QUANTITY_T',
1635: x_tol_tab(i).max_increment);
1636: end if;
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,

Line 1648: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_START_DATE) then

1644: x_tol_tab(i).max_increment);
1645: end if;
1646:
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,

Line 1657: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_END_DATE) then

1653: 'CO_L_START_DATE_T',
1654: x_tol_tab(i).max_increment);
1655: end if;
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,

Line 1669: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then

1665:
1666: end if;
1667:
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,

Line 1723: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;

1719: itemkey IN VARCHAR2,
1720: agreement_type IN VARCHAR2)
1721: IS
1722: x_org_id number;
1723: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;
1724: x_return_status varchar2(1);
1725: x_msg_count NUMBER;
1726: x_msg_data VARCHAR2(2000);
1727: BEGIN

Line 1739: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

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,
1740: FND_API.G_TRUE,
1741: x_org_id,
1742: PO_CO_TOLERANCES_GRP.G_CHG_AGREEMENTS,
1743: x_tol_tab,

Line 1742: PO_CO_TOLERANCES_GRP.G_CHG_AGREEMENTS,

1738: -- Retrieve the tolerances
1739: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,
1740: FND_API.G_TRUE,
1741: x_org_id,
1742: PO_CO_TOLERANCES_GRP.G_CHG_AGREEMENTS,
1743: x_tol_tab,
1744: x_return_status,
1745: x_msg_count,
1746: x_msg_data);

Line 1761: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then

1757: -- ECO 4716963: Added a condition for all tolerences to only assign not
1758: -- null values from the table
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',

Line 1769: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_AGREED) then

1765: 'CO_H_AMOUNT_LIMIT_T',
1766: x_tol_tab(i).max_increment);
1767: end if;
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,

Line 1780: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_AGREED) then

1776: end if;
1777: end if;
1778:
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,

Line 1789: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_HEADER_AMOUNT_LIMIT) then

1785: 'CO_H_BLANKET_TOTAL_T',
1786: x_tol_tab(i).max_increment);
1787: end if;
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,

Line 1798: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_UNIT_PRICE) then

1794: 'CO_H_AMOUNT_LIMIT_T',
1795: x_tol_tab(i).max_increment);
1796: end if;
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,

Line 1807: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRICE_LIMIT) then

1803: 'CO_L_UNIT_PRICE_T',
1804: x_tol_tab(i).max_increment);
1805: end if;
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,

Line 1816: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_QTY_AGREED) then

1812: 'CO_L_NOT_TO_EXCEED_PRICE_T',
1813: x_tol_tab(i).max_increment);
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',

Line 1824: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_LINE_AMOUNT_AGREED) then

1820: 'CO_L_QTY_COMMITTED_T',
1821: x_tol_tab(i).max_increment);
1822: end if;
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,

Line 1833: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRC_BRK_PRICE) then

1829: 'CO_L_COMMITTED_AMT_T',
1830: x_tol_tab(i).max_increment);
1831: end if;
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,

Line 1842: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PRC_BRK_QTY) then

1838: 'CO_S_PRICE_OVERRIDE_T',
1839: x_tol_tab(i).max_increment);
1840: end if;
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,

Line 1894: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;

1890: itemkey IN VARCHAR2,
1891: release_type IN VARCHAR2)
1892: IS
1893: x_org_id number;
1894: x_tol_tab PO_CO_TOLERANCES_GRP.tolerances_tbl_type;
1895: x_return_status varchar2(1);
1896: x_msg_count NUMBER;
1897: x_msg_data VARCHAR2(2000);
1898: BEGIN

Line 1910: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,

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,
1911: FND_API.G_TRUE,
1912: x_org_id,
1913: PO_CO_TOLERANCES_GRP.G_CHG_RELEASES,
1914: x_tol_tab,

Line 1913: PO_CO_TOLERANCES_GRP.G_CHG_RELEASES,

1909: -- Retrieve the tolerances
1910: PO_CO_TOLERANCES_GRP.GET_TOLERANCES (1.0,
1911: FND_API.G_TRUE,
1912: x_org_id,
1913: PO_CO_TOLERANCES_GRP.G_CHG_RELEASES,
1914: x_tol_tab,
1915: x_return_status,
1916: x_msg_count,
1917: x_msg_data);

Line 1931: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_PRICE) then

1927: -- Assign the values
1928: -- ECO 4716963: Added a condition for all tolerences to only assign not
1929: -- null values from the table
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,

Line 1940: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_SHIPMENT_QTY) then

1936: 'CO_S_PRICE_OVERRIDE_T',
1937: x_tol_tab(i).max_increment);
1938: end if;
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,

Line 1949: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_QTY) then

1945: 'CO_S_QUANTITY_T',
1946: x_tol_tab(i).max_increment);
1947: end if;
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,

Line 1960: PO_CO_TOLERANCES_GRP.G_SHIPMENT_AMOUNT_PERCENT) then

1956:
1957: end if;
1958:
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,

Line 1970: PO_CO_TOLERANCES_GRP.G_DISTRIBUTION_AMOUNT_PERCENT) then

1966: x_tol_tab(i).max_increment);
1967: end if;
1968:
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,

Line 1982: if (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_NEED_BY_DATE) then

1978: end if;
1979:
1980: if (release_type = 'BLANKET') then
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,

Line 1991: elsif (x_tol_tab(i).tolerance_name = PO_CO_TOLERANCES_GRP.G_PROMISED_DATE) then

1987: 'CO_S_NEED_BY_DATE_T',
1988: x_tol_tab(i).max_increment);
1989: end if;
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,