DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT dependencies on QP_PRICING_ATTR_UTIL

Line 1515: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1511:
1512: -- Set missing old record elements to NULL.
1513:
1514: l_old_PRICING_ATTR_rec :=
1515: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1516:
1517: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1518: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1519: THEN

Line 1529: l_old_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row

1525: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
1526: THEN
1527:
1528: oe_debug_pub.add('before query');
1529: l_old_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row
1530: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1531: );
1532:
1533: ELSE

Line 1538: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

1534:
1535: -- Set missing old record elements to NULL.
1536:
1537: l_old_PRICING_ATTR_rec :=
1538: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1539:
1540: END IF;
1541:
1542: -- Complete new record from old

Line 1545: l_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Complete_Record

1541:
1542: -- Complete new record from old
1543:
1544: oe_debug_pub.add('1111');
1545: l_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Complete_Record
1546: ( p_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1547: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1548: );
1549:

Line 1633: QP_Pricing_Attr_Util.Clear_Dependent_Attr

1629: -- Clear dependent attributes.
1630:
1631: IF l_control_rec.change_attributes THEN
1632: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1633: QP_Pricing_Attr_Util.Clear_Dependent_Attr
1634: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1635: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1636: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1637: );

Line 1663: QP_Pricing_Attr_Util.Apply_Attribute_Changes

1659: THEN
1660:
1661: oe_debug_pub.add('7777');
1662: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1663: QP_Pricing_Attr_Util.Apply_Attribute_Changes
1664: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1665: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1666: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1667: );

Line 1705: QP_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS

1701: END IF;
1702:
1703: IF l_control_rec.write_to_db THEN
1704: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1705: QP_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS
1706: ( p_Pricing_Attr_rec => l_p_Pricing_Attr_rec
1707: , p_old_Pricing_Attr_rec => l_old_Pricing_Attr_rec
1708: , x_Pricing_Attr_rec => l_Pricing_Attr_rec);
1709:

Line 1785: QP_Pricing_Attr_Util.Delete_Row

1781:
1782:
1783:
1784: oe_debug_pub.add('7777');
1785: QP_Pricing_Attr_Util.Delete_Row
1786: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1787: );
1788:
1789: ELSE

Line 1799: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);

1795: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1796:
1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1798:
1799: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
1800:
1801: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1802:
1803: l_PRICING_ATTR_rec.creation_date := SYSDATE;

Line 1806: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);

1802:
1803: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1804: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1805: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');
1806: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1807:
1808: END IF;
1809:
1810: END IF;

Line 2751: QP_Pricing_Attr_Util.Lock_Row

2747: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2748:
2749: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2750:
2751: QP_Pricing_Attr_Util.Lock_Row
2752: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2753: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2754: , x_return_status => l_return_status
2755: );

Line 2915: l_PRICING_ATTR_tbl := QP_Pricing_Attr_Util.Query_Rows

2911: FOR I2 IN 1..l_MODIFIERS_tbl.COUNT LOOP
2912:
2913: -- Get PRICING_ATTR ( parent = MODIFIERS )
2914:
2915: l_PRICING_ATTR_tbl := QP_Pricing_Attr_Util.Query_Rows
2916: ( p_list_line_id => l_MODIFIERS_tbl(I2).list_line_id
2917: );
2918:
2919: FOR I3 IN 1..l_PRICING_ATTR_tbl.COUNT LOOP