APPS.QP_LIST_HEADERS_PVT dependencies on QP_PLL_PRICING_ATTR_UTIL

Line 1446: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1442:
1443: -- Set missing old record elements to NULL.
1444:
1445: l_old_PRICING_ATTR_rec :=
1446: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1447:
1448: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1449: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1450: THEN

Line 1461: l_old_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row

1457: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
1458: THEN
1459: oe_debug_pub.add('query pricing attributes');
1460:
1461: l_old_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row
1462: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1463: );
1464:
1465: ELSE

Line 1471: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1467: -- Set missing old record elements to NULL.
1468:
1469: oe_debug_pub.add('set missing record elements to null');
1470: l_old_PRICING_ATTR_rec :=
1471: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1472:
1473: END IF;
1474:
1475: -- Complete new record from old

Line 1480: l_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Complete_Record

1476:
1477: oe_debug_pub.add('complete new record from old');
1478:
1479:
1480: l_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Complete_Record
1481: ( p_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1482: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1483: );
1484:

Line 1550: Qp_pll_pricing_attr_Util.Clear_Dependent_Attr

1546: IF l_control_rec.change_attributes THEN
1547:
1548: oe_debug_pub.add('clear dependent attr1');
1549: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1550: Qp_pll_pricing_attr_Util.Clear_Dependent_Attr
1551: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1552: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1553: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1554: );

Line 1612: Qp_pll_pricing_attr_Util.Apply_Attribute_Changes

1608: OR l_control_rec.change_attributes
1609: THEN
1610: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1611: oe_debug_pub.add('before calling apply attribute changes');
1612: Qp_pll_pricing_attr_Util.Apply_Attribute_Changes
1613: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1614: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1615: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1616: );

Line 1651: QP_pll_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS

1647: END IF;
1648:
1649: IF l_control_rec.write_to_db THEN
1650: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1651: QP_pll_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS
1652: ( p_Pricing_Attr_rec => l_p_Pricing_Attr_rec
1653: , p_old_Pricing_Attr_rec => l_old_Pricing_Attr_rec
1654: , x_Pricing_Attr_rec => l_Pricing_Attr_rec);
1655:

Line 1664: Qp_pll_pricing_attr_Util.Delete_Row

1660: IF l_control_rec.write_to_db THEN
1661:
1662: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1663:
1664: Qp_pll_pricing_attr_Util.Delete_Row
1665: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1666: );
1667:
1668: ELSE

Line 1679: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);

1675:
1676: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1677:
1678: oe_debug_Pub.add('before update row');
1679: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1680:
1681: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1682:
1683: l_PRICING_ATTR_rec.creation_date := SYSDATE;

Line 1688: Qp_pll_pricing_attr_Util.Insert_Row (l_PRICING_ATTR_rec);

1684: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1685:
1686: oe_debug_pub.add('before insert row');
1687:
1688: Qp_pll_pricing_attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1689:
1690: END IF;
1691:
1692: END IF;

Line 2496: Qp_pll_pricing_attr_Util.Lock_Row

2492: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2493:
2494: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2495:
2496: Qp_pll_pricing_attr_Util.Lock_Row
2497: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2498: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2499: , x_return_status => l_return_status
2500: );

Line 2658: l_PRICING_ATTR_tbl := Qp_pll_pricing_attr_Util.Query_Rows

2654: FOR I2 IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
2655:
2656: -- Get PRICING_ATTR ( parent = PRICE_LIST_LINE )
2657:
2658: l_PRICING_ATTR_tbl := Qp_pll_pricing_attr_Util.Query_Rows
2659: ( p_list_line_id => l_PRICE_LIST_LINE_tbl(I2).list_line_id
2660: );
2661:
2662: FOR I3 IN 1..l_PRICING_ATTR_tbl.COUNT LOOP