APPS.QP_LIST_HEADERS_PVT dependencies on QP_PLL_PRICING_ATTR_UTIL

Line 1451: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1447:
1448: -- Set missing old record elements to NULL.
1449:
1450: l_old_PRICING_ATTR_rec :=
1451: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1452:
1453: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1454: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1455: THEN

Line 1466: l_old_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row

1462: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
1463: THEN
1464: oe_debug_pub.add('query pricing attributes');
1465:
1466: l_old_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row
1467: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1468: );
1469:
1470: ELSE

Line 1476: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1472: -- Set missing old record elements to NULL.
1473:
1474: oe_debug_pub.add('set missing record elements to null');
1475: l_old_PRICING_ATTR_rec :=
1476: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1477:
1478: END IF;
1479:
1480: -- Complete new record from old

Line 1485: l_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Complete_Record

1481:
1482: oe_debug_pub.add('complete new record from old');
1483:
1484:
1485: l_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Complete_Record
1486: ( p_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1487: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1488: );
1489:

Line 1555: Qp_pll_pricing_attr_Util.Clear_Dependent_Attr

1551: IF l_control_rec.change_attributes THEN
1552:
1553: oe_debug_pub.add('clear dependent attr1');
1554: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1555: Qp_pll_pricing_attr_Util.Clear_Dependent_Attr
1556: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1557: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1558: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1559: );

Line 1617: Qp_pll_pricing_attr_Util.Apply_Attribute_Changes

1613: OR l_control_rec.change_attributes
1614: THEN
1615: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1616: oe_debug_pub.add('before calling apply attribute changes');
1617: Qp_pll_pricing_attr_Util.Apply_Attribute_Changes
1618: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1619: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1620: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1621: );

Line 1656: QP_pll_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS

1652: END IF;
1653:
1654: IF l_control_rec.write_to_db THEN
1655: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1656: QP_pll_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS
1657: ( p_Pricing_Attr_rec => l_p_Pricing_Attr_rec
1658: , p_old_Pricing_Attr_rec => l_old_Pricing_Attr_rec
1659: , x_Pricing_Attr_rec => l_Pricing_Attr_rec);
1660:

Line 1669: Qp_pll_pricing_attr_Util.Delete_Row

1665: IF l_control_rec.write_to_db THEN
1666:
1667: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1668:
1669: Qp_pll_pricing_attr_Util.Delete_Row
1670: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1671: );
1672:
1673: ELSE

Line 1684: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);

1680:
1681: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1682:
1683: oe_debug_Pub.add('before update row');
1684: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1685:
1686: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1687:
1688: l_PRICING_ATTR_rec.creation_date := SYSDATE;

Line 1693: Qp_pll_pricing_attr_Util.Insert_Row (l_PRICING_ATTR_rec);

1689: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1690:
1691: oe_debug_pub.add('before insert row');
1692:
1693: Qp_pll_pricing_attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1694:
1695: END IF;
1696:
1697: END IF;

Line 2501: Qp_pll_pricing_attr_Util.Lock_Row

2497: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2498:
2499: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2500:
2501: Qp_pll_pricing_attr_Util.Lock_Row
2502: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2503: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2504: , x_return_status => l_return_status
2505: );

Line 2663: l_PRICING_ATTR_tbl := Qp_pll_pricing_attr_Util.Query_Rows

2659: FOR I2 IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
2660:
2661: -- Get PRICING_ATTR ( parent = PRICE_LIST_LINE )
2662:
2663: l_PRICING_ATTR_tbl := Qp_pll_pricing_attr_Util.Query_Rows
2664: ( p_list_line_id => l_PRICE_LIST_LINE_tbl(I2).list_line_id
2665: );
2666:
2667: FOR I3 IN 1..l_PRICING_ATTR_tbl.COUNT LOOP