DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT dependencies on QP_PRICING_ATTR_UTIL

Line 1518: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

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

Line 1532: l_old_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row

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

Line 1541: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);

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

Line 1548: l_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Complete_Record

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

Line 1636: QP_Pricing_Attr_Util.Clear_Dependent_Attr

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

Line 1666: QP_Pricing_Attr_Util.Apply_Attribute_Changes

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

Line 1708: QP_PRICING_ATTR_UTIL.PRE_WRITE_PROCESS

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

Line 1788: QP_Pricing_Attr_Util.Delete_Row

1784:
1785:
1786:
1787: oe_debug_pub.add('7777');
1788: QP_Pricing_Attr_Util.Delete_Row
1789: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1790: );
1791:
1792: ELSE

Line 1802: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);

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

Line 1809: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);

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

Line 2758: QP_Pricing_Attr_Util.Lock_Row

2754: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2755:
2756: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2757:
2758: QP_Pricing_Attr_Util.Lock_Row
2759: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2760: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2761: , x_return_status => l_return_status
2762: );

Line 2922: l_PRICING_ATTR_tbl := QP_Pricing_Attr_Util.Query_Rows

2918: FOR I2 IN 1..l_MODIFIERS_tbl.COUNT LOOP
2919:
2920: -- Get PRICING_ATTR ( parent = MODIFIERS )
2921:
2922: l_PRICING_ATTR_tbl := QP_Pricing_Attr_Util.Query_Rows
2923: ( p_list_line_id => l_MODIFIERS_tbl(I2).list_line_id
2924: );
2925:
2926: FOR I3 IN 1..l_PRICING_ATTR_tbl.COUNT LOOP