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.QP_PRICE_LIST_PVT dependencies on QP_PRICE_LIST_PVT

Line 1: PACKAGE BODY QP_PRICE_LIST_PVT AS

1: PACKAGE BODY QP_PRICE_LIST_PVT AS
2: /* $Header: OEXVPRLB.pls 120.2 2005/07/07 05:35:34 appldev ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_LIST_PVT';

2: /* $Header: OEXVPRLB.pls 120.2 2005/07/07 05:35:34 appldev ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_LIST_PVT';
7:
8: G_Fetch_Level NUMBER := 0;
9:
10: -- Utility function called by Fetch)List_Price API.

Line 1445: QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1441: AND TRUNC(L_PRICING_DATE)
1442: BETWEEN NVL( QPLIN.START_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
1443: AND NVL( QPLIN.END_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
1444: AND Decode(l_pricing_attribute1,Null,
1445: QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1446: p_inventory_item_id, p_unit_code,
1447: --the following two attributes must
1448: -- not be hardcoded...Kannan..10/01/99
1449: 'ALL',

Line 1455: QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist (

1451: 'ALL',
1452: Null,
1453: qplin.list_line_id,
1454: qplin.list_header_id),
1455: QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist (
1456: 'ITEM', 'PRICING_ATTRIBUTE1',
1457: p_inventory_item_id, p_unit_code,
1458: --the following two attributes must
1459: -- not be hardcoded...Kannan..10/01/99

Line 1466: AND Decode(l_pricing_attribute2,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1462: l_pricing_attribute1,
1463: l_pricing_attribute1,
1464: qplin.list_line_id,
1465: qplin.list_header_id)) = 'Y'
1466: AND Decode(l_pricing_attribute2,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1467: p_inventory_item_id, p_unit_code,
1468: --the following two attributes must
1469: -- not be hardcoded...Kannan..10/01/99
1470: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1476: AND Decode(l_pricing_attribute3,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1472: l_pricing_attribute2,
1473: l_pricing_attribute2,
1474: qplin.list_line_id,
1475: qplin.list_header_id)) = 'Y'
1476: AND Decode(l_pricing_attribute3,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1477: p_inventory_item_id, p_unit_code,
1478: --the following two attributes must
1479: -- not be hardcoded...Kannan..10/01/99
1480: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1486: AND Decode(l_pricing_attribute4,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1482: l_pricing_attribute3,
1483: l_pricing_attribute3,
1484: qplin.list_line_id,
1485: qplin.list_header_id)) = 'Y'
1486: AND Decode(l_pricing_attribute4,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1487: p_inventory_item_id, p_unit_code,
1488: --the following two attributes must
1489: -- not be hardcoded...Kannan..10/01/99
1490: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1496: AND Decode(l_pricing_attribute5,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1492: l_pricing_attribute4,
1493: l_pricing_attribute4,
1494: qplin.list_line_id,
1495: qplin.list_header_id)) = 'Y'
1496: AND Decode(l_pricing_attribute5,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1497: p_inventory_item_id, p_unit_code,
1498: --the following two attributes must
1499: -- not be hardcoded...Kannan..10/01/99
1500: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1506: AND Decode(l_pricing_attribute6,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1502: l_pricing_attribute5,
1503: l_pricing_attribute5,
1504: qplin.list_line_id,
1505: qplin.list_header_id)) = 'Y'
1506: AND Decode(l_pricing_attribute6,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1507: p_inventory_item_id, p_unit_code,
1508: --the following two attributes must
1509: -- not be hardcoded...Kannan..10/01/99
1510: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1516: AND Decode(l_pricing_attribute7,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1512: l_pricing_attribute6,
1513: l_pricing_attribute6,
1514: qplin.list_line_id,
1515: qplin.list_header_id)) = 'Y'
1516: AND Decode(l_pricing_attribute7,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1517: p_inventory_item_id, p_unit_code,
1518: --the following two attributes must
1519: -- not be hardcoded...Kannan..10/01/99
1520: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1526: AND Decode(l_pricing_attribute8,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1522: l_pricing_attribute7,
1523: l_pricing_attribute7,
1524: qplin.list_line_id,
1525: qplin.list_header_id)) = 'Y'
1526: AND Decode(l_pricing_attribute8,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1527: p_inventory_item_id, p_unit_code,
1528: --the following two attributes must
1529: -- not be hardcoded...Kannan..10/01/99
1530: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1536: AND Decode(l_pricing_attribute9,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1532: l_pricing_attribute8,
1533: l_pricing_attribute8,
1534: qplin.list_line_id,
1535: qplin.list_header_id)) = 'Y'
1536: AND Decode(l_pricing_attribute9,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1537: p_inventory_item_id, p_unit_code,
1538: --the following two attributes must
1539: -- not be hardcoded...Kannan..10/01/99
1540: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1546: AND Decode(l_pricing_attribute10,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1542: l_pricing_attribute9,
1543: l_pricing_attribute9,
1544: qplin.list_line_id,
1545: qplin.list_header_id)) = 'Y'
1546: AND Decode(l_pricing_attribute10,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1547: p_inventory_item_id, p_unit_code,
1548: --the following two attributes must
1549: -- not be hardcoded...Kannan..10/01/99
1550: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1556: AND Decode(l_pricing_attribute11,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1552: l_pricing_attribute10,
1553: l_pricing_attribute10,
1554: qplin.list_line_id,
1555: qplin.list_header_id)) = 'Y'
1556: AND Decode(l_pricing_attribute11,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1557: p_inventory_item_id, p_unit_code,
1558: --the following two attributes must
1559: -- not be hardcoded...Kannan..10/01/99
1560: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1566: AND Decode(l_pricing_attribute12,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1562: l_pricing_attribute11,
1563: l_pricing_attribute11,
1564: qplin.list_line_id,
1565: qplin.list_header_id)) = 'Y'
1566: AND Decode(l_pricing_attribute12,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1567: p_inventory_item_id, p_unit_code,
1568: --the following two attributes must
1569: -- not be hardcoded...Kannan..10/01/99
1570: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1576: AND Decode(l_pricing_attribute13,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1572: l_pricing_attribute12,
1573: l_pricing_attribute12,
1574: qplin.list_line_id,
1575: qplin.list_header_id)) = 'Y'
1576: AND Decode(l_pricing_attribute13,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1577: p_inventory_item_id, p_unit_code,
1578: --the following two attributes must
1579: -- not be hardcoded...Kannan..10/01/99
1580: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1586: AND Decode(l_pricing_attribute14,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1582: l_pricing_attribute13,
1583: l_pricing_attribute13,
1584: qplin.list_line_id,
1585: qplin.list_header_id)) = 'Y'
1586: AND Decode(l_pricing_attribute14,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1587: p_inventory_item_id, p_unit_code,
1588: --the following two attributes must
1589: -- not be hardcoded...Kannan..10/01/99
1590: 'PRICING_ATTRIBUTE_CONTEXT',

Line 1596: AND Decode(l_pricing_attribute15,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',

1592: l_pricing_attribute14,
1593: l_pricing_attribute14,
1594: qplin.list_line_id,
1595: qplin.list_header_id)) = 'Y'
1596: AND Decode(l_pricing_attribute15,Null,'Y',QP_PRICE_LIST_PVT.Does_Pricing_Attribute_Exist ( 'ITEM', 'PRICING_ATTRIBUTE1',
1597: p_inventory_item_id, p_unit_code,
1598: --the following two attributes must
1599: -- not be hardcoded...Kannan..10/01/99
1600: 'PRICING_ATTRIBUTE_CONTEXT',

Line 2276: END QP_PRICE_LIST_PVT;

2272:
2273: end Get_Product_UOM_Code;
2274:
2275:
2276: END QP_PRICE_LIST_PVT;