[Home] [Help]
24:
25:
26: PROCEDURE Query_Rows
27: ( p_order_price_attrib_id IN NUMBER :=
28: FND_API.G_MISS_NUM
29: , p_header_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
32: )
26: PROCEDURE Query_Rows
27: ( p_order_price_attrib_id IN NUMBER :=
28: FND_API.G_MISS_NUM
29: , p_header_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
32: )
33: IS
34: l_count NUMBER;
181:
182: IF
183: (p_order_price_attrib_id IS NOT NULL
184: AND
185: p_order_price_attrib_id <> FND_API.G_MISS_NUM)
186: AND
187: (p_header_id IS NOT NULL
188: AND
189: p_header_id <> FND_API.G_MISS_NUM)
185: p_order_price_attrib_id <> FND_API.G_MISS_NUM)
186: AND
187: (p_header_id IS NOT NULL
188: AND
189: p_header_id <> FND_API.G_MISS_NUM)
190: THEN
191:
192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
196: , 'Query Rows'
197: , 'Keys are mutually exclusive'
198: );
199: END IF;
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203: l_count := 1;
204: FOR imp_rec IN l_Header_Price_Attr_csr LOOP
345: x_Header_Price_Att_tbl(l_count).override_flag := imp_rec.override_flag;
346: x_Header_Price_Att_tbl(l_count).lock_control := imp_rec.lock_control;
347:
348: -- set values for non-DB fields
349: x_Header_Price_Att_tbl(l_count).db_flag := FND_API.G_TRUE;
350: x_Header_Price_Att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
351: x_Header_Price_Att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
352:
353: l_count := l_count + 1;
346: x_Header_Price_Att_tbl(l_count).lock_control := imp_rec.lock_control;
347:
348: -- set values for non-DB fields
349: x_Header_Price_Att_tbl(l_count).db_flag := FND_API.G_TRUE;
350: x_Header_Price_Att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
351: x_Header_Price_Att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
352:
353: l_count := l_count + 1;
354: END LOOP;
347:
348: -- set values for non-DB fields
349: x_Header_Price_Att_tbl(l_count).db_flag := FND_API.G_TRUE;
350: x_Header_Price_Att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
351: x_Header_Price_Att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
352:
353: l_count := l_count + 1;
354: END LOOP;
355:
353: l_count := l_count + 1;
354: END LOOP;
355:
356: IF ( p_order_price_attrib_id IS NOT NULL
357: and p_order_price_attrib_id <> FND_API.G_MISS_NUM )
358: AND
359: (x_Header_Price_Att_tbl.COUNT = 0 )
360: THEN
361: RAISE NO_DATA_FOUND;
362: END IF;
363:
364: EXCEPTION
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367:
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369:
370: WHEN OTHERS THEN
364: EXCEPTION
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367:
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369:
370: WHEN OTHERS THEN
371:
372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: , 'Query_Rows'
377: );
378: END IF;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381:
382: END Query_Rows;
383:
384: PROCEDURE Clear_Dependent_Attr
381:
382: END Query_Rows;
383:
384: PROCEDURE Clear_Dependent_Attr
385: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
386: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
387: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
388: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
389: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
403:
404: -- If attr_id is missing compare old and new records and for
405: -- every changed attribute clear its dependent fields.
406:
407: IF p_attr_id = FND_API.G_MISS_NUM THEN
408:
409: IF NOT OE_GLOBALS.Equal(p_x_Header_Price_Att_rec.attribute1,p_old_Header_Price_Att_rec.attribute1)
410: THEN
411: l_index := l_index + 1;
1600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1601: --
1602: BEGIN
1603:
1604: IF l_Header_Price_Att_Rec.override_flag = FND_API.G_MISS_CHAR THEN
1605: l_Header_Price_Att_Rec.override_flag := p_old_Header_Price_Att_Rec.override_flag;
1606: END IF;
1607:
1608:
1606: END IF;
1607:
1608:
1609:
1610: IF l_Header_Price_Att_Rec.attribute1 = FND_API.G_MISS_CHAR THEN
1611: l_Header_Price_Att_Rec.attribute1 := p_old_Header_Price_Att_Rec.attribute1;
1612: END IF;
1613:
1614: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
1610: IF l_Header_Price_Att_Rec.attribute1 = FND_API.G_MISS_CHAR THEN
1611: l_Header_Price_Att_Rec.attribute1 := p_old_Header_Price_Att_Rec.attribute1;
1612: END IF;
1613:
1614: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
1615: l_Header_Price_Att_Rec.attribute10 := p_old_Header_Price_Att_Rec.attribute10;
1616: END IF;
1617:
1618: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
1614: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
1615: l_Header_Price_Att_Rec.attribute10 := p_old_Header_Price_Att_Rec.attribute10;
1616: END IF;
1617:
1618: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
1619: l_Header_Price_Att_Rec.attribute11 := p_old_Header_Price_Att_Rec.attribute11;
1620: END IF;
1621:
1622: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
1618: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
1619: l_Header_Price_Att_Rec.attribute11 := p_old_Header_Price_Att_Rec.attribute11;
1620: END IF;
1621:
1622: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
1623: l_Header_Price_Att_Rec.attribute12 := p_old_Header_Price_Att_Rec.attribute12;
1624: END IF;
1625:
1626: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
1622: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
1623: l_Header_Price_Att_Rec.attribute12 := p_old_Header_Price_Att_Rec.attribute12;
1624: END IF;
1625:
1626: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
1627: l_Header_Price_Att_Rec.attribute13 := p_old_Header_Price_Att_Rec.attribute13;
1628: END IF;
1629:
1630: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
1626: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
1627: l_Header_Price_Att_Rec.attribute13 := p_old_Header_Price_Att_Rec.attribute13;
1628: END IF;
1629:
1630: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
1631: l_Header_Price_Att_Rec.attribute14 := p_old_Header_Price_Att_Rec.attribute14;
1632: END IF;
1633:
1634: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
1630: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
1631: l_Header_Price_Att_Rec.attribute14 := p_old_Header_Price_Att_Rec.attribute14;
1632: END IF;
1633:
1634: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
1635: l_Header_Price_Att_Rec.attribute15 := p_old_Header_Price_Att_Rec.attribute15;
1636: END IF;
1637:
1638: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
1634: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
1635: l_Header_Price_Att_Rec.attribute15 := p_old_Header_Price_Att_Rec.attribute15;
1636: END IF;
1637:
1638: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
1639: l_Header_Price_Att_Rec.attribute2 := p_old_Header_Price_Att_Rec.attribute2;
1640: END IF;
1641:
1642: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
1638: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
1639: l_Header_Price_Att_Rec.attribute2 := p_old_Header_Price_Att_Rec.attribute2;
1640: END IF;
1641:
1642: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
1643: l_Header_Price_Att_Rec.attribute3 := p_old_Header_Price_Att_Rec.attribute3;
1644: END IF;
1645:
1646: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
1642: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
1643: l_Header_Price_Att_Rec.attribute3 := p_old_Header_Price_Att_Rec.attribute3;
1644: END IF;
1645:
1646: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
1647: l_Header_Price_Att_Rec.attribute4 := p_old_Header_Price_Att_Rec.attribute4;
1648: END IF;
1649:
1650: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
1646: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
1647: l_Header_Price_Att_Rec.attribute4 := p_old_Header_Price_Att_Rec.attribute4;
1648: END IF;
1649:
1650: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
1651: l_Header_Price_Att_Rec.attribute5 := p_old_Header_Price_Att_Rec.attribute5;
1652: END IF;
1653:
1654: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
1650: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
1651: l_Header_Price_Att_Rec.attribute5 := p_old_Header_Price_Att_Rec.attribute5;
1652: END IF;
1653:
1654: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
1655: l_Header_Price_Att_Rec.attribute6 := p_old_Header_Price_Att_Rec.attribute6;
1656: END IF;
1657:
1658: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
1654: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
1655: l_Header_Price_Att_Rec.attribute6 := p_old_Header_Price_Att_Rec.attribute6;
1656: END IF;
1657:
1658: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
1659: l_Header_Price_Att_Rec.attribute7 := p_old_Header_Price_Att_Rec.attribute7;
1660: END IF;
1661:
1662: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
1658: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
1659: l_Header_Price_Att_Rec.attribute7 := p_old_Header_Price_Att_Rec.attribute7;
1660: END IF;
1661:
1662: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
1663: l_Header_Price_Att_Rec.attribute8 := p_old_Header_Price_Att_Rec.attribute8;
1664: END IF;
1665:
1666: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
1662: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
1663: l_Header_Price_Att_Rec.attribute8 := p_old_Header_Price_Att_Rec.attribute8;
1664: END IF;
1665:
1666: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
1667: l_Header_Price_Att_Rec.attribute9 := p_old_Header_Price_Att_Rec.attribute9;
1668: END IF;
1669:
1670: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
1666: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
1667: l_Header_Price_Att_Rec.attribute9 := p_old_Header_Price_Att_Rec.attribute9;
1668: END IF;
1669:
1670: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
1671: l_Header_Price_Att_Rec.context := p_old_Header_Price_Att_Rec.context;
1672: END IF;
1673:
1674: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
1670: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
1671: l_Header_Price_Att_Rec.context := p_old_Header_Price_Att_Rec.context;
1672: END IF;
1673:
1674: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
1675: l_Header_Price_Att_Rec.created_by := p_old_Header_Price_Att_Rec.created_by;
1676: END IF;
1677:
1678: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
1674: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
1675: l_Header_Price_Att_Rec.created_by := p_old_Header_Price_Att_Rec.created_by;
1676: END IF;
1677:
1678: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
1679: l_Header_Price_Att_Rec.creation_date := p_old_Header_Price_Att_Rec.creation_date;
1680: END IF;
1681:
1682: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
1678: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
1679: l_Header_Price_Att_Rec.creation_date := p_old_Header_Price_Att_Rec.creation_date;
1680: END IF;
1681:
1682: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
1683: l_Header_Price_Att_Rec.flex_title := p_old_Header_Price_Att_Rec.flex_title;
1684: END IF;
1685:
1686: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
1682: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
1683: l_Header_Price_Att_Rec.flex_title := p_old_Header_Price_Att_Rec.flex_title;
1684: END IF;
1685:
1686: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
1687: l_Header_Price_Att_Rec.header_id := p_old_Header_Price_Att_Rec.header_id;
1688: END IF;
1689:
1690: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
1686: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
1687: l_Header_Price_Att_Rec.header_id := p_old_Header_Price_Att_Rec.header_id;
1688: END IF;
1689:
1690: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
1691: l_Header_Price_Att_Rec.last_updated_by := p_old_Header_Price_Att_Rec.last_updated_by;
1692: END IF;
1693:
1694: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
1690: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
1691: l_Header_Price_Att_Rec.last_updated_by := p_old_Header_Price_Att_Rec.last_updated_by;
1692: END IF;
1693:
1694: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
1695: l_Header_Price_Att_Rec.last_update_date := p_old_Header_Price_Att_Rec.last_update_date;
1696: END IF;
1697:
1698: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
1694: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
1695: l_Header_Price_Att_Rec.last_update_date := p_old_Header_Price_Att_Rec.last_update_date;
1696: END IF;
1697:
1698: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
1699: l_Header_Price_Att_Rec.last_update_login := p_old_Header_Price_Att_Rec.last_update_login;
1700: END IF;
1701:
1702: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
1698: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
1699: l_Header_Price_Att_Rec.last_update_login := p_old_Header_Price_Att_Rec.last_update_login;
1700: END IF;
1701:
1702: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
1703: l_Header_Price_Att_Rec.line_id := p_old_Header_Price_Att_Rec.line_id;
1704: END IF;
1705:
1706: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
1702: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
1703: l_Header_Price_Att_Rec.line_id := p_old_Header_Price_Att_Rec.line_id;
1704: END IF;
1705:
1706: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
1707: l_Header_Price_Att_Rec.order_price_attrib_id := p_old_Header_Price_Att_Rec.order_price_attrib_id;
1708: END IF;
1709:
1710: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1706: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
1707: l_Header_Price_Att_Rec.order_price_attrib_id := p_old_Header_Price_Att_Rec.order_price_attrib_id;
1708: END IF;
1709:
1710: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1711: l_Header_Price_Att_Rec.pricing_attribute1 := p_old_Header_Price_Att_Rec.pricing_attribute1;
1712: END IF;
1713:
1714: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1710: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1711: l_Header_Price_Att_Rec.pricing_attribute1 := p_old_Header_Price_Att_Rec.pricing_attribute1;
1712: END IF;
1713:
1714: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1715: l_Header_Price_Att_Rec.pricing_attribute10 := p_old_Header_Price_Att_Rec.pricing_attribute10;
1716: END IF;
1717:
1718: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
1714: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1715: l_Header_Price_Att_Rec.pricing_attribute10 := p_old_Header_Price_Att_Rec.pricing_attribute10;
1716: END IF;
1717:
1718: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
1719: l_Header_Price_Att_Rec.pricing_attribute100 := p_old_Header_Price_Att_Rec.pricing_attribute100;
1720: END IF;
1721:
1722: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1718: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
1719: l_Header_Price_Att_Rec.pricing_attribute100 := p_old_Header_Price_Att_Rec.pricing_attribute100;
1720: END IF;
1721:
1722: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1723: l_Header_Price_Att_Rec.pricing_attribute11 := p_old_Header_Price_Att_Rec.pricing_attribute11;
1724: END IF;
1725:
1726: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1722: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1723: l_Header_Price_Att_Rec.pricing_attribute11 := p_old_Header_Price_Att_Rec.pricing_attribute11;
1724: END IF;
1725:
1726: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1727: l_Header_Price_Att_Rec.pricing_attribute12 := p_old_Header_Price_Att_Rec.pricing_attribute12;
1728: END IF;
1729:
1730: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1726: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1727: l_Header_Price_Att_Rec.pricing_attribute12 := p_old_Header_Price_Att_Rec.pricing_attribute12;
1728: END IF;
1729:
1730: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1731: l_Header_Price_Att_Rec.pricing_attribute13 := p_old_Header_Price_Att_Rec.pricing_attribute13;
1732: END IF;
1733:
1734: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1730: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1731: l_Header_Price_Att_Rec.pricing_attribute13 := p_old_Header_Price_Att_Rec.pricing_attribute13;
1732: END IF;
1733:
1734: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1735: l_Header_Price_Att_Rec.pricing_attribute14 := p_old_Header_Price_Att_Rec.pricing_attribute14;
1736: END IF;
1737:
1738: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1734: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1735: l_Header_Price_Att_Rec.pricing_attribute14 := p_old_Header_Price_Att_Rec.pricing_attribute14;
1736: END IF;
1737:
1738: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1739: l_Header_Price_Att_Rec.pricing_attribute15 := p_old_Header_Price_Att_Rec.pricing_attribute15;
1740: END IF;
1741:
1742: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
1738: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1739: l_Header_Price_Att_Rec.pricing_attribute15 := p_old_Header_Price_Att_Rec.pricing_attribute15;
1740: END IF;
1741:
1742: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
1743: l_Header_Price_Att_Rec.pricing_attribute16 := p_old_Header_Price_Att_Rec.pricing_attribute16;
1744: END IF;
1745:
1746: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
1742: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
1743: l_Header_Price_Att_Rec.pricing_attribute16 := p_old_Header_Price_Att_Rec.pricing_attribute16;
1744: END IF;
1745:
1746: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
1747: l_Header_Price_Att_Rec.pricing_attribute17 := p_old_Header_Price_Att_Rec.pricing_attribute17;
1748: END IF;
1749:
1750: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
1746: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
1747: l_Header_Price_Att_Rec.pricing_attribute17 := p_old_Header_Price_Att_Rec.pricing_attribute17;
1748: END IF;
1749:
1750: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
1751: l_Header_Price_Att_Rec.pricing_attribute18 := p_old_Header_Price_Att_Rec.pricing_attribute18;
1752: END IF;
1753:
1754: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
1750: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
1751: l_Header_Price_Att_Rec.pricing_attribute18 := p_old_Header_Price_Att_Rec.pricing_attribute18;
1752: END IF;
1753:
1754: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
1755: l_Header_Price_Att_Rec.pricing_attribute19 := p_old_Header_Price_Att_Rec.pricing_attribute19;
1756: END IF;
1757:
1758: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1754: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
1755: l_Header_Price_Att_Rec.pricing_attribute19 := p_old_Header_Price_Att_Rec.pricing_attribute19;
1756: END IF;
1757:
1758: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1759: l_Header_Price_Att_Rec.pricing_attribute2 := p_old_Header_Price_Att_Rec.pricing_attribute2;
1760: END IF;
1761:
1762: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
1758: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1759: l_Header_Price_Att_Rec.pricing_attribute2 := p_old_Header_Price_Att_Rec.pricing_attribute2;
1760: END IF;
1761:
1762: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
1763: l_Header_Price_Att_Rec.pricing_attribute20 := p_old_Header_Price_Att_Rec.pricing_attribute20;
1764: END IF;
1765:
1766: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
1762: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
1763: l_Header_Price_Att_Rec.pricing_attribute20 := p_old_Header_Price_Att_Rec.pricing_attribute20;
1764: END IF;
1765:
1766: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
1767: l_Header_Price_Att_Rec.pricing_attribute21 := p_old_Header_Price_Att_Rec.pricing_attribute21;
1768: END IF;
1769:
1770: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
1766: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
1767: l_Header_Price_Att_Rec.pricing_attribute21 := p_old_Header_Price_Att_Rec.pricing_attribute21;
1768: END IF;
1769:
1770: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
1771: l_Header_Price_Att_Rec.pricing_attribute22 := p_old_Header_Price_Att_Rec.pricing_attribute22;
1772: END IF;
1773:
1774: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
1770: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
1771: l_Header_Price_Att_Rec.pricing_attribute22 := p_old_Header_Price_Att_Rec.pricing_attribute22;
1772: END IF;
1773:
1774: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
1775: l_Header_Price_Att_Rec.pricing_attribute23 := p_old_Header_Price_Att_Rec.pricing_attribute23;
1776: END IF;
1777:
1778: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
1774: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
1775: l_Header_Price_Att_Rec.pricing_attribute23 := p_old_Header_Price_Att_Rec.pricing_attribute23;
1776: END IF;
1777:
1778: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
1779: l_Header_Price_Att_Rec.pricing_attribute24 := p_old_Header_Price_Att_Rec.pricing_attribute24;
1780: END IF;
1781:
1782: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
1778: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
1779: l_Header_Price_Att_Rec.pricing_attribute24 := p_old_Header_Price_Att_Rec.pricing_attribute24;
1780: END IF;
1781:
1782: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
1783: l_Header_Price_Att_Rec.pricing_attribute25 := p_old_Header_Price_Att_Rec.pricing_attribute25;
1784: END IF;
1785:
1786: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
1782: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
1783: l_Header_Price_Att_Rec.pricing_attribute25 := p_old_Header_Price_Att_Rec.pricing_attribute25;
1784: END IF;
1785:
1786: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
1787: l_Header_Price_Att_Rec.pricing_attribute26 := p_old_Header_Price_Att_Rec.pricing_attribute26;
1788: END IF;
1789:
1790: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
1786: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
1787: l_Header_Price_Att_Rec.pricing_attribute26 := p_old_Header_Price_Att_Rec.pricing_attribute26;
1788: END IF;
1789:
1790: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
1791: l_Header_Price_Att_Rec.pricing_attribute27 := p_old_Header_Price_Att_Rec.pricing_attribute27;
1792: END IF;
1793:
1794: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
1790: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
1791: l_Header_Price_Att_Rec.pricing_attribute27 := p_old_Header_Price_Att_Rec.pricing_attribute27;
1792: END IF;
1793:
1794: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
1795: l_Header_Price_Att_Rec.pricing_attribute28 := p_old_Header_Price_Att_Rec.pricing_attribute28;
1796: END IF;
1797:
1798: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
1794: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
1795: l_Header_Price_Att_Rec.pricing_attribute28 := p_old_Header_Price_Att_Rec.pricing_attribute28;
1796: END IF;
1797:
1798: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
1799: l_Header_Price_Att_Rec.pricing_attribute29 := p_old_Header_Price_Att_Rec.pricing_attribute29;
1800: END IF;
1801:
1802: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1798: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
1799: l_Header_Price_Att_Rec.pricing_attribute29 := p_old_Header_Price_Att_Rec.pricing_attribute29;
1800: END IF;
1801:
1802: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1803: l_Header_Price_Att_Rec.pricing_attribute3 := p_old_Header_Price_Att_Rec.pricing_attribute3;
1804: END IF;
1805:
1806: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
1802: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1803: l_Header_Price_Att_Rec.pricing_attribute3 := p_old_Header_Price_Att_Rec.pricing_attribute3;
1804: END IF;
1805:
1806: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
1807: l_Header_Price_Att_Rec.pricing_attribute30 := p_old_Header_Price_Att_Rec.pricing_attribute30;
1808: END IF;
1809:
1810: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
1806: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
1807: l_Header_Price_Att_Rec.pricing_attribute30 := p_old_Header_Price_Att_Rec.pricing_attribute30;
1808: END IF;
1809:
1810: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
1811: l_Header_Price_Att_Rec.pricing_attribute31 := p_old_Header_Price_Att_Rec.pricing_attribute31;
1812: END IF;
1813:
1814: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
1810: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
1811: l_Header_Price_Att_Rec.pricing_attribute31 := p_old_Header_Price_Att_Rec.pricing_attribute31;
1812: END IF;
1813:
1814: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
1815: l_Header_Price_Att_Rec.pricing_attribute32 := p_old_Header_Price_Att_Rec.pricing_attribute32;
1816: END IF;
1817:
1818: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
1814: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
1815: l_Header_Price_Att_Rec.pricing_attribute32 := p_old_Header_Price_Att_Rec.pricing_attribute32;
1816: END IF;
1817:
1818: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
1819: l_Header_Price_Att_Rec.pricing_attribute33 := p_old_Header_Price_Att_Rec.pricing_attribute33;
1820: END IF;
1821:
1822: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
1818: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
1819: l_Header_Price_Att_Rec.pricing_attribute33 := p_old_Header_Price_Att_Rec.pricing_attribute33;
1820: END IF;
1821:
1822: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
1823: l_Header_Price_Att_Rec.pricing_attribute34 := p_old_Header_Price_Att_Rec.pricing_attribute34;
1824: END IF;
1825:
1826: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
1822: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
1823: l_Header_Price_Att_Rec.pricing_attribute34 := p_old_Header_Price_Att_Rec.pricing_attribute34;
1824: END IF;
1825:
1826: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
1827: l_Header_Price_Att_Rec.pricing_attribute35 := p_old_Header_Price_Att_Rec.pricing_attribute35;
1828: END IF;
1829:
1830: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
1826: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
1827: l_Header_Price_Att_Rec.pricing_attribute35 := p_old_Header_Price_Att_Rec.pricing_attribute35;
1828: END IF;
1829:
1830: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
1831: l_Header_Price_Att_Rec.pricing_attribute36 := p_old_Header_Price_Att_Rec.pricing_attribute36;
1832: END IF;
1833:
1834: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
1830: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
1831: l_Header_Price_Att_Rec.pricing_attribute36 := p_old_Header_Price_Att_Rec.pricing_attribute36;
1832: END IF;
1833:
1834: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
1835: l_Header_Price_Att_Rec.pricing_attribute37 := p_old_Header_Price_Att_Rec.pricing_attribute37;
1836: END IF;
1837:
1838: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
1834: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
1835: l_Header_Price_Att_Rec.pricing_attribute37 := p_old_Header_Price_Att_Rec.pricing_attribute37;
1836: END IF;
1837:
1838: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
1839: l_Header_Price_Att_Rec.pricing_attribute38 := p_old_Header_Price_Att_Rec.pricing_attribute38;
1840: END IF;
1841:
1842: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
1838: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
1839: l_Header_Price_Att_Rec.pricing_attribute38 := p_old_Header_Price_Att_Rec.pricing_attribute38;
1840: END IF;
1841:
1842: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
1843: l_Header_Price_Att_Rec.pricing_attribute39 := p_old_Header_Price_Att_Rec.pricing_attribute39;
1844: END IF;
1845:
1846: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1842: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
1843: l_Header_Price_Att_Rec.pricing_attribute39 := p_old_Header_Price_Att_Rec.pricing_attribute39;
1844: END IF;
1845:
1846: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1847: l_Header_Price_Att_Rec.pricing_attribute4 := p_old_Header_Price_Att_Rec.pricing_attribute4;
1848: END IF;
1849:
1850: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
1846: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1847: l_Header_Price_Att_Rec.pricing_attribute4 := p_old_Header_Price_Att_Rec.pricing_attribute4;
1848: END IF;
1849:
1850: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
1851: l_Header_Price_Att_Rec.pricing_attribute40 := p_old_Header_Price_Att_Rec.pricing_attribute40;
1852: END IF;
1853:
1854: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
1850: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
1851: l_Header_Price_Att_Rec.pricing_attribute40 := p_old_Header_Price_Att_Rec.pricing_attribute40;
1852: END IF;
1853:
1854: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
1855: l_Header_Price_Att_Rec.pricing_attribute41 := p_old_Header_Price_Att_Rec.pricing_attribute41;
1856: END IF;
1857:
1858: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
1854: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
1855: l_Header_Price_Att_Rec.pricing_attribute41 := p_old_Header_Price_Att_Rec.pricing_attribute41;
1856: END IF;
1857:
1858: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
1859: l_Header_Price_Att_Rec.pricing_attribute42 := p_old_Header_Price_Att_Rec.pricing_attribute42;
1860: END IF;
1861:
1862: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
1858: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
1859: l_Header_Price_Att_Rec.pricing_attribute42 := p_old_Header_Price_Att_Rec.pricing_attribute42;
1860: END IF;
1861:
1862: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
1863: l_Header_Price_Att_Rec.pricing_attribute43 := p_old_Header_Price_Att_Rec.pricing_attribute43;
1864: END IF;
1865:
1866: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
1862: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
1863: l_Header_Price_Att_Rec.pricing_attribute43 := p_old_Header_Price_Att_Rec.pricing_attribute43;
1864: END IF;
1865:
1866: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
1867: l_Header_Price_Att_Rec.pricing_attribute44 := p_old_Header_Price_Att_Rec.pricing_attribute44;
1868: END IF;
1869:
1870: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
1866: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
1867: l_Header_Price_Att_Rec.pricing_attribute44 := p_old_Header_Price_Att_Rec.pricing_attribute44;
1868: END IF;
1869:
1870: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
1871: l_Header_Price_Att_Rec.pricing_attribute45 := p_old_Header_Price_Att_Rec.pricing_attribute45;
1872: END IF;
1873:
1874: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
1870: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
1871: l_Header_Price_Att_Rec.pricing_attribute45 := p_old_Header_Price_Att_Rec.pricing_attribute45;
1872: END IF;
1873:
1874: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
1875: l_Header_Price_Att_Rec.pricing_attribute46 := p_old_Header_Price_Att_Rec.pricing_attribute46;
1876: END IF;
1877:
1878: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
1874: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
1875: l_Header_Price_Att_Rec.pricing_attribute46 := p_old_Header_Price_Att_Rec.pricing_attribute46;
1876: END IF;
1877:
1878: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
1879: l_Header_Price_Att_Rec.pricing_attribute47 := p_old_Header_Price_Att_Rec.pricing_attribute47;
1880: END IF;
1881:
1882: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
1878: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
1879: l_Header_Price_Att_Rec.pricing_attribute47 := p_old_Header_Price_Att_Rec.pricing_attribute47;
1880: END IF;
1881:
1882: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
1883: l_Header_Price_Att_Rec.pricing_attribute48 := p_old_Header_Price_Att_Rec.pricing_attribute48;
1884: END IF;
1885:
1886: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
1882: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
1883: l_Header_Price_Att_Rec.pricing_attribute48 := p_old_Header_Price_Att_Rec.pricing_attribute48;
1884: END IF;
1885:
1886: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
1887: l_Header_Price_Att_Rec.pricing_attribute49 := p_old_Header_Price_Att_Rec.pricing_attribute49;
1888: END IF;
1889:
1890: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1886: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
1887: l_Header_Price_Att_Rec.pricing_attribute49 := p_old_Header_Price_Att_Rec.pricing_attribute49;
1888: END IF;
1889:
1890: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1891: l_Header_Price_Att_Rec.pricing_attribute5 := p_old_Header_Price_Att_Rec.pricing_attribute5;
1892: END IF;
1893:
1894: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
1890: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1891: l_Header_Price_Att_Rec.pricing_attribute5 := p_old_Header_Price_Att_Rec.pricing_attribute5;
1892: END IF;
1893:
1894: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
1895: l_Header_Price_Att_Rec.pricing_attribute50 := p_old_Header_Price_Att_Rec.pricing_attribute50;
1896: END IF;
1897:
1898: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
1894: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
1895: l_Header_Price_Att_Rec.pricing_attribute50 := p_old_Header_Price_Att_Rec.pricing_attribute50;
1896: END IF;
1897:
1898: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
1899: l_Header_Price_Att_Rec.pricing_attribute51 := p_old_Header_Price_Att_Rec.pricing_attribute51;
1900: END IF;
1901:
1902: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
1898: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
1899: l_Header_Price_Att_Rec.pricing_attribute51 := p_old_Header_Price_Att_Rec.pricing_attribute51;
1900: END IF;
1901:
1902: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
1903: l_Header_Price_Att_Rec.pricing_attribute52 := p_old_Header_Price_Att_Rec.pricing_attribute52;
1904: END IF;
1905:
1906: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
1902: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
1903: l_Header_Price_Att_Rec.pricing_attribute52 := p_old_Header_Price_Att_Rec.pricing_attribute52;
1904: END IF;
1905:
1906: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
1907: l_Header_Price_Att_Rec.pricing_attribute53 := p_old_Header_Price_Att_Rec.pricing_attribute53;
1908: END IF;
1909:
1910: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
1906: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
1907: l_Header_Price_Att_Rec.pricing_attribute53 := p_old_Header_Price_Att_Rec.pricing_attribute53;
1908: END IF;
1909:
1910: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
1911: l_Header_Price_Att_Rec.pricing_attribute54 := p_old_Header_Price_Att_Rec.pricing_attribute54;
1912: END IF;
1913:
1914: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
1910: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
1911: l_Header_Price_Att_Rec.pricing_attribute54 := p_old_Header_Price_Att_Rec.pricing_attribute54;
1912: END IF;
1913:
1914: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
1915: l_Header_Price_Att_Rec.pricing_attribute55 := p_old_Header_Price_Att_Rec.pricing_attribute55;
1916: END IF;
1917:
1918: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
1914: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
1915: l_Header_Price_Att_Rec.pricing_attribute55 := p_old_Header_Price_Att_Rec.pricing_attribute55;
1916: END IF;
1917:
1918: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
1919: l_Header_Price_Att_Rec.pricing_attribute56 := p_old_Header_Price_Att_Rec.pricing_attribute56;
1920: END IF;
1921:
1922: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
1918: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
1919: l_Header_Price_Att_Rec.pricing_attribute56 := p_old_Header_Price_Att_Rec.pricing_attribute56;
1920: END IF;
1921:
1922: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
1923: l_Header_Price_Att_Rec.pricing_attribute57 := p_old_Header_Price_Att_Rec.pricing_attribute57;
1924: END IF;
1925:
1926: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
1922: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
1923: l_Header_Price_Att_Rec.pricing_attribute57 := p_old_Header_Price_Att_Rec.pricing_attribute57;
1924: END IF;
1925:
1926: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
1927: l_Header_Price_Att_Rec.pricing_attribute58 := p_old_Header_Price_Att_Rec.pricing_attribute58;
1928: END IF;
1929:
1930: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
1926: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
1927: l_Header_Price_Att_Rec.pricing_attribute58 := p_old_Header_Price_Att_Rec.pricing_attribute58;
1928: END IF;
1929:
1930: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
1931: l_Header_Price_Att_Rec.pricing_attribute59 := p_old_Header_Price_Att_Rec.pricing_attribute59;
1932: END IF;
1933:
1934: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1930: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
1931: l_Header_Price_Att_Rec.pricing_attribute59 := p_old_Header_Price_Att_Rec.pricing_attribute59;
1932: END IF;
1933:
1934: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1935: l_Header_Price_Att_Rec.pricing_attribute6 := p_old_Header_Price_Att_Rec.pricing_attribute6;
1936: END IF;
1937:
1938: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
1934: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1935: l_Header_Price_Att_Rec.pricing_attribute6 := p_old_Header_Price_Att_Rec.pricing_attribute6;
1936: END IF;
1937:
1938: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
1939: l_Header_Price_Att_Rec.pricing_attribute60 := p_old_Header_Price_Att_Rec.pricing_attribute60;
1940: END IF;
1941:
1942: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
1938: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
1939: l_Header_Price_Att_Rec.pricing_attribute60 := p_old_Header_Price_Att_Rec.pricing_attribute60;
1940: END IF;
1941:
1942: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
1943: l_Header_Price_Att_Rec.pricing_attribute61 := p_old_Header_Price_Att_Rec.pricing_attribute61;
1944: END IF;
1945:
1946: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
1942: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
1943: l_Header_Price_Att_Rec.pricing_attribute61 := p_old_Header_Price_Att_Rec.pricing_attribute61;
1944: END IF;
1945:
1946: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
1947: l_Header_Price_Att_Rec.pricing_attribute62 := p_old_Header_Price_Att_Rec.pricing_attribute62;
1948: END IF;
1949:
1950: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
1946: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
1947: l_Header_Price_Att_Rec.pricing_attribute62 := p_old_Header_Price_Att_Rec.pricing_attribute62;
1948: END IF;
1949:
1950: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
1951: l_Header_Price_Att_Rec.pricing_attribute63 := p_old_Header_Price_Att_Rec.pricing_attribute63;
1952: END IF;
1953:
1954: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
1950: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
1951: l_Header_Price_Att_Rec.pricing_attribute63 := p_old_Header_Price_Att_Rec.pricing_attribute63;
1952: END IF;
1953:
1954: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
1955: l_Header_Price_Att_Rec.pricing_attribute64 := p_old_Header_Price_Att_Rec.pricing_attribute64;
1956: END IF;
1957:
1958: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
1954: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
1955: l_Header_Price_Att_Rec.pricing_attribute64 := p_old_Header_Price_Att_Rec.pricing_attribute64;
1956: END IF;
1957:
1958: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
1959: l_Header_Price_Att_Rec.pricing_attribute65 := p_old_Header_Price_Att_Rec.pricing_attribute65;
1960: END IF;
1961:
1962: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
1958: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
1959: l_Header_Price_Att_Rec.pricing_attribute65 := p_old_Header_Price_Att_Rec.pricing_attribute65;
1960: END IF;
1961:
1962: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
1963: l_Header_Price_Att_Rec.pricing_attribute66 := p_old_Header_Price_Att_Rec.pricing_attribute66;
1964: END IF;
1965:
1966: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
1962: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
1963: l_Header_Price_Att_Rec.pricing_attribute66 := p_old_Header_Price_Att_Rec.pricing_attribute66;
1964: END IF;
1965:
1966: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
1967: l_Header_Price_Att_Rec.pricing_attribute67 := p_old_Header_Price_Att_Rec.pricing_attribute67;
1968: END IF;
1969:
1970: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
1966: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
1967: l_Header_Price_Att_Rec.pricing_attribute67 := p_old_Header_Price_Att_Rec.pricing_attribute67;
1968: END IF;
1969:
1970: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
1971: l_Header_Price_Att_Rec.pricing_attribute68 := p_old_Header_Price_Att_Rec.pricing_attribute68;
1972: END IF;
1973:
1974: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
1970: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
1971: l_Header_Price_Att_Rec.pricing_attribute68 := p_old_Header_Price_Att_Rec.pricing_attribute68;
1972: END IF;
1973:
1974: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
1975: l_Header_Price_Att_Rec.pricing_attribute69 := p_old_Header_Price_Att_Rec.pricing_attribute69;
1976: END IF;
1977:
1978: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1974: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
1975: l_Header_Price_Att_Rec.pricing_attribute69 := p_old_Header_Price_Att_Rec.pricing_attribute69;
1976: END IF;
1977:
1978: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1979: l_Header_Price_Att_Rec.pricing_attribute7 := p_old_Header_Price_Att_Rec.pricing_attribute7;
1980: END IF;
1981:
1982: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
1978: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1979: l_Header_Price_Att_Rec.pricing_attribute7 := p_old_Header_Price_Att_Rec.pricing_attribute7;
1980: END IF;
1981:
1982: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
1983: l_Header_Price_Att_Rec.pricing_attribute70 := p_old_Header_Price_Att_Rec.pricing_attribute70;
1984: END IF;
1985:
1986: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
1982: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
1983: l_Header_Price_Att_Rec.pricing_attribute70 := p_old_Header_Price_Att_Rec.pricing_attribute70;
1984: END IF;
1985:
1986: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
1987: l_Header_Price_Att_Rec.pricing_attribute71 := p_old_Header_Price_Att_Rec.pricing_attribute71;
1988: END IF;
1989:
1990: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
1986: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
1987: l_Header_Price_Att_Rec.pricing_attribute71 := p_old_Header_Price_Att_Rec.pricing_attribute71;
1988: END IF;
1989:
1990: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
1991: l_Header_Price_Att_Rec.pricing_attribute72 := p_old_Header_Price_Att_Rec.pricing_attribute72;
1992: END IF;
1993:
1994: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
1990: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
1991: l_Header_Price_Att_Rec.pricing_attribute72 := p_old_Header_Price_Att_Rec.pricing_attribute72;
1992: END IF;
1993:
1994: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
1995: l_Header_Price_Att_Rec.pricing_attribute73 := p_old_Header_Price_Att_Rec.pricing_attribute73;
1996: END IF;
1997:
1998: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
1994: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
1995: l_Header_Price_Att_Rec.pricing_attribute73 := p_old_Header_Price_Att_Rec.pricing_attribute73;
1996: END IF;
1997:
1998: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
1999: l_Header_Price_Att_Rec.pricing_attribute74 := p_old_Header_Price_Att_Rec.pricing_attribute74;
2000: END IF;
2001:
2002: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
1998: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
1999: l_Header_Price_Att_Rec.pricing_attribute74 := p_old_Header_Price_Att_Rec.pricing_attribute74;
2000: END IF;
2001:
2002: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2003: l_Header_Price_Att_Rec.pricing_attribute75 := p_old_Header_Price_Att_Rec.pricing_attribute75;
2004: END IF;
2005:
2006: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2002: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2003: l_Header_Price_Att_Rec.pricing_attribute75 := p_old_Header_Price_Att_Rec.pricing_attribute75;
2004: END IF;
2005:
2006: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2007: l_Header_Price_Att_Rec.pricing_attribute76 := p_old_Header_Price_Att_Rec.pricing_attribute76;
2008: END IF;
2009:
2010: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2006: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2007: l_Header_Price_Att_Rec.pricing_attribute76 := p_old_Header_Price_Att_Rec.pricing_attribute76;
2008: END IF;
2009:
2010: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2011: l_Header_Price_Att_Rec.pricing_attribute77 := p_old_Header_Price_Att_Rec.pricing_attribute77;
2012: END IF;
2013:
2014: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2010: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2011: l_Header_Price_Att_Rec.pricing_attribute77 := p_old_Header_Price_Att_Rec.pricing_attribute77;
2012: END IF;
2013:
2014: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2015: l_Header_Price_Att_Rec.pricing_attribute78 := p_old_Header_Price_Att_Rec.pricing_attribute78;
2016: END IF;
2017:
2018: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2014: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2015: l_Header_Price_Att_Rec.pricing_attribute78 := p_old_Header_Price_Att_Rec.pricing_attribute78;
2016: END IF;
2017:
2018: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2019: l_Header_Price_Att_Rec.pricing_attribute79 := p_old_Header_Price_Att_Rec.pricing_attribute79;
2020: END IF;
2021:
2022: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2018: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2019: l_Header_Price_Att_Rec.pricing_attribute79 := p_old_Header_Price_Att_Rec.pricing_attribute79;
2020: END IF;
2021:
2022: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2023: l_Header_Price_Att_Rec.pricing_attribute8 := p_old_Header_Price_Att_Rec.pricing_attribute8;
2024: END IF;
2025:
2026: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2022: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2023: l_Header_Price_Att_Rec.pricing_attribute8 := p_old_Header_Price_Att_Rec.pricing_attribute8;
2024: END IF;
2025:
2026: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2027: l_Header_Price_Att_Rec.pricing_attribute80 := p_old_Header_Price_Att_Rec.pricing_attribute80;
2028: END IF;
2029:
2030: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2026: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2027: l_Header_Price_Att_Rec.pricing_attribute80 := p_old_Header_Price_Att_Rec.pricing_attribute80;
2028: END IF;
2029:
2030: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2031: l_Header_Price_Att_Rec.pricing_attribute81 := p_old_Header_Price_Att_Rec.pricing_attribute81;
2032: END IF;
2033:
2034: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2030: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2031: l_Header_Price_Att_Rec.pricing_attribute81 := p_old_Header_Price_Att_Rec.pricing_attribute81;
2032: END IF;
2033:
2034: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2035: l_Header_Price_Att_Rec.pricing_attribute82 := p_old_Header_Price_Att_Rec.pricing_attribute82;
2036: END IF;
2037:
2038: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2034: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2035: l_Header_Price_Att_Rec.pricing_attribute82 := p_old_Header_Price_Att_Rec.pricing_attribute82;
2036: END IF;
2037:
2038: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2039: l_Header_Price_Att_Rec.pricing_attribute83 := p_old_Header_Price_Att_Rec.pricing_attribute83;
2040: END IF;
2041:
2042: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2038: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2039: l_Header_Price_Att_Rec.pricing_attribute83 := p_old_Header_Price_Att_Rec.pricing_attribute83;
2040: END IF;
2041:
2042: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2043: l_Header_Price_Att_Rec.pricing_attribute84 := p_old_Header_Price_Att_Rec.pricing_attribute84;
2044: END IF;
2045:
2046: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2042: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2043: l_Header_Price_Att_Rec.pricing_attribute84 := p_old_Header_Price_Att_Rec.pricing_attribute84;
2044: END IF;
2045:
2046: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2047: l_Header_Price_Att_Rec.pricing_attribute85 := p_old_Header_Price_Att_Rec.pricing_attribute85;
2048: END IF;
2049:
2050: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2046: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2047: l_Header_Price_Att_Rec.pricing_attribute85 := p_old_Header_Price_Att_Rec.pricing_attribute85;
2048: END IF;
2049:
2050: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2051: l_Header_Price_Att_Rec.pricing_attribute86 := p_old_Header_Price_Att_Rec.pricing_attribute86;
2052: END IF;
2053:
2054: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2050: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2051: l_Header_Price_Att_Rec.pricing_attribute86 := p_old_Header_Price_Att_Rec.pricing_attribute86;
2052: END IF;
2053:
2054: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2055: l_Header_Price_Att_Rec.pricing_attribute87 := p_old_Header_Price_Att_Rec.pricing_attribute87;
2056: END IF;
2057:
2058: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2054: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2055: l_Header_Price_Att_Rec.pricing_attribute87 := p_old_Header_Price_Att_Rec.pricing_attribute87;
2056: END IF;
2057:
2058: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2059: l_Header_Price_Att_Rec.pricing_attribute88 := p_old_Header_Price_Att_Rec.pricing_attribute88;
2060: END IF;
2061:
2062: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2058: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2059: l_Header_Price_Att_Rec.pricing_attribute88 := p_old_Header_Price_Att_Rec.pricing_attribute88;
2060: END IF;
2061:
2062: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2063: l_Header_Price_Att_Rec.pricing_attribute89 := p_old_Header_Price_Att_Rec.pricing_attribute89;
2064: END IF;
2065:
2066: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2062: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2063: l_Header_Price_Att_Rec.pricing_attribute89 := p_old_Header_Price_Att_Rec.pricing_attribute89;
2064: END IF;
2065:
2066: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2067: l_Header_Price_Att_Rec.pricing_attribute9 := p_old_Header_Price_Att_Rec.pricing_attribute9;
2068: END IF;
2069:
2070: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2066: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2067: l_Header_Price_Att_Rec.pricing_attribute9 := p_old_Header_Price_Att_Rec.pricing_attribute9;
2068: END IF;
2069:
2070: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2071: l_Header_Price_Att_Rec.pricing_attribute90 := p_old_Header_Price_Att_Rec.pricing_attribute90;
2072: END IF;
2073:
2074: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2070: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2071: l_Header_Price_Att_Rec.pricing_attribute90 := p_old_Header_Price_Att_Rec.pricing_attribute90;
2072: END IF;
2073:
2074: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2075: l_Header_Price_Att_Rec.pricing_attribute91 := p_old_Header_Price_Att_Rec.pricing_attribute91;
2076: END IF;
2077:
2078: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2074: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2075: l_Header_Price_Att_Rec.pricing_attribute91 := p_old_Header_Price_Att_Rec.pricing_attribute91;
2076: END IF;
2077:
2078: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2079: l_Header_Price_Att_Rec.pricing_attribute92 := p_old_Header_Price_Att_Rec.pricing_attribute92;
2080: END IF;
2081:
2082: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2078: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2079: l_Header_Price_Att_Rec.pricing_attribute92 := p_old_Header_Price_Att_Rec.pricing_attribute92;
2080: END IF;
2081:
2082: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2083: l_Header_Price_Att_Rec.pricing_attribute93 := p_old_Header_Price_Att_Rec.pricing_attribute93;
2084: END IF;
2085:
2086: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2082: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2083: l_Header_Price_Att_Rec.pricing_attribute93 := p_old_Header_Price_Att_Rec.pricing_attribute93;
2084: END IF;
2085:
2086: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2087: l_Header_Price_Att_Rec.pricing_attribute94 := p_old_Header_Price_Att_Rec.pricing_attribute94;
2088: END IF;
2089:
2090: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2086: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2087: l_Header_Price_Att_Rec.pricing_attribute94 := p_old_Header_Price_Att_Rec.pricing_attribute94;
2088: END IF;
2089:
2090: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2091: l_Header_Price_Att_Rec.pricing_attribute95 := p_old_Header_Price_Att_Rec.pricing_attribute95;
2092: END IF;
2093:
2094: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2090: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2091: l_Header_Price_Att_Rec.pricing_attribute95 := p_old_Header_Price_Att_Rec.pricing_attribute95;
2092: END IF;
2093:
2094: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2095: l_Header_Price_Att_Rec.pricing_attribute96 := p_old_Header_Price_Att_Rec.pricing_attribute96;
2096: END IF;
2097:
2098: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2094: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2095: l_Header_Price_Att_Rec.pricing_attribute96 := p_old_Header_Price_Att_Rec.pricing_attribute96;
2096: END IF;
2097:
2098: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2099: l_Header_Price_Att_Rec.pricing_attribute97 := p_old_Header_Price_Att_Rec.pricing_attribute97;
2100: END IF;
2101:
2102: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2098: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2099: l_Header_Price_Att_Rec.pricing_attribute97 := p_old_Header_Price_Att_Rec.pricing_attribute97;
2100: END IF;
2101:
2102: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2103: l_Header_Price_Att_Rec.pricing_attribute98 := p_old_Header_Price_Att_Rec.pricing_attribute98;
2104: END IF;
2105:
2106: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2102: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2103: l_Header_Price_Att_Rec.pricing_attribute98 := p_old_Header_Price_Att_Rec.pricing_attribute98;
2104: END IF;
2105:
2106: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2107: l_Header_Price_Att_Rec.pricing_attribute99 := p_old_Header_Price_Att_Rec.pricing_attribute99;
2108: END IF;
2109:
2110: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2106: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2107: l_Header_Price_Att_Rec.pricing_attribute99 := p_old_Header_Price_Att_Rec.pricing_attribute99;
2108: END IF;
2109:
2110: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2111: l_Header_Price_Att_Rec.pricing_context := p_old_Header_Price_Att_Rec.pricing_context;
2112: END IF;
2113:
2114: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2110: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2111: l_Header_Price_Att_Rec.pricing_context := p_old_Header_Price_Att_Rec.pricing_context;
2112: END IF;
2113:
2114: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2115: l_Header_Price_Att_Rec.program_application_id := p_old_Header_Price_Att_Rec.program_application_id;
2116: END IF;
2117:
2118: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2114: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2115: l_Header_Price_Att_Rec.program_application_id := p_old_Header_Price_Att_Rec.program_application_id;
2116: END IF;
2117:
2118: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2119: l_Header_Price_Att_Rec.program_id := p_old_Header_Price_Att_Rec.program_id;
2120: END IF;
2121:
2122: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2118: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2119: l_Header_Price_Att_Rec.program_id := p_old_Header_Price_Att_Rec.program_id;
2120: END IF;
2121:
2122: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2123: l_Header_Price_Att_Rec.program_update_date := p_old_Header_Price_Att_Rec.program_update_date;
2124: END IF;
2125:
2126: IF l_Header_Price_Att_Rec.request_id = FND_API.G_MISS_NUM THEN
2122: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2123: l_Header_Price_Att_Rec.program_update_date := p_old_Header_Price_Att_Rec.program_update_date;
2124: END IF;
2125:
2126: IF l_Header_Price_Att_Rec.request_id = FND_API.G_MISS_NUM THEN
2127: l_Header_Price_Att_Rec.request_id := p_old_Header_Price_Att_Rec.request_id;
2128: END IF;
2129:
2130: -- RETURN l_Header_Price_Att_Rec;
2142: --
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: --
2145: BEGIN
2146: IF l_Header_Price_Att_Rec.override_flag = FND_API.G_MISS_CHAR THEN
2147: l_Header_Price_Att_Rec.override_flag := NULL;
2148: END IF;
2149:
2150: IF l_Header_Price_Att_Rec.attribute1 = FND_API.G_MISS_CHAR THEN
2146: IF l_Header_Price_Att_Rec.override_flag = FND_API.G_MISS_CHAR THEN
2147: l_Header_Price_Att_Rec.override_flag := NULL;
2148: END IF;
2149:
2150: IF l_Header_Price_Att_Rec.attribute1 = FND_API.G_MISS_CHAR THEN
2151: l_Header_Price_Att_Rec.attribute1 := NULL;
2152: END IF;
2153:
2154: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
2150: IF l_Header_Price_Att_Rec.attribute1 = FND_API.G_MISS_CHAR THEN
2151: l_Header_Price_Att_Rec.attribute1 := NULL;
2152: END IF;
2153:
2154: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
2155: l_Header_Price_Att_Rec.attribute10 := NULL;
2156: END IF;
2157:
2158: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
2154: IF l_Header_Price_Att_Rec.attribute10 = FND_API.G_MISS_CHAR THEN
2155: l_Header_Price_Att_Rec.attribute10 := NULL;
2156: END IF;
2157:
2158: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
2159: l_Header_Price_Att_Rec.attribute11 := NULL;
2160: END IF;
2161:
2162: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
2158: IF l_Header_Price_Att_Rec.attribute11 = FND_API.G_MISS_CHAR THEN
2159: l_Header_Price_Att_Rec.attribute11 := NULL;
2160: END IF;
2161:
2162: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
2163: l_Header_Price_Att_Rec.attribute12 := NULL;
2164: END IF;
2165:
2166: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
2162: IF l_Header_Price_Att_Rec.attribute12 = FND_API.G_MISS_CHAR THEN
2163: l_Header_Price_Att_Rec.attribute12 := NULL;
2164: END IF;
2165:
2166: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
2167: l_Header_Price_Att_Rec.attribute13 := NULL;
2168: END IF;
2169:
2170: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
2166: IF l_Header_Price_Att_Rec.attribute13 = FND_API.G_MISS_CHAR THEN
2167: l_Header_Price_Att_Rec.attribute13 := NULL;
2168: END IF;
2169:
2170: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
2171: l_Header_Price_Att_Rec.attribute14 := NULL;
2172: END IF;
2173:
2174: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
2170: IF l_Header_Price_Att_Rec.attribute14 = FND_API.G_MISS_CHAR THEN
2171: l_Header_Price_Att_Rec.attribute14 := NULL;
2172: END IF;
2173:
2174: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
2175: l_Header_Price_Att_Rec.attribute15 := NULL;
2176: END IF;
2177:
2178: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
2174: IF l_Header_Price_Att_Rec.attribute15 = FND_API.G_MISS_CHAR THEN
2175: l_Header_Price_Att_Rec.attribute15 := NULL;
2176: END IF;
2177:
2178: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
2179: l_Header_Price_Att_Rec.attribute2 := NULL;
2180: END IF;
2181:
2182: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
2178: IF l_Header_Price_Att_Rec.attribute2 = FND_API.G_MISS_CHAR THEN
2179: l_Header_Price_Att_Rec.attribute2 := NULL;
2180: END IF;
2181:
2182: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
2183: l_Header_Price_Att_Rec.attribute3 := NULL;
2184: END IF;
2185:
2186: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
2182: IF l_Header_Price_Att_Rec.attribute3 = FND_API.G_MISS_CHAR THEN
2183: l_Header_Price_Att_Rec.attribute3 := NULL;
2184: END IF;
2185:
2186: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
2187: l_Header_Price_Att_Rec.attribute4 := NULL;
2188: END IF;
2189:
2190: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
2186: IF l_Header_Price_Att_Rec.attribute4 = FND_API.G_MISS_CHAR THEN
2187: l_Header_Price_Att_Rec.attribute4 := NULL;
2188: END IF;
2189:
2190: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
2191: l_Header_Price_Att_Rec.attribute5 := NULL;
2192: END IF;
2193:
2194: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
2190: IF l_Header_Price_Att_Rec.attribute5 = FND_API.G_MISS_CHAR THEN
2191: l_Header_Price_Att_Rec.attribute5 := NULL;
2192: END IF;
2193:
2194: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
2195: l_Header_Price_Att_Rec.attribute6 := NULL;
2196: END IF;
2197:
2198: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
2194: IF l_Header_Price_Att_Rec.attribute6 = FND_API.G_MISS_CHAR THEN
2195: l_Header_Price_Att_Rec.attribute6 := NULL;
2196: END IF;
2197:
2198: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
2199: l_Header_Price_Att_Rec.attribute7 := NULL;
2200: END IF;
2201:
2202: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
2198: IF l_Header_Price_Att_Rec.attribute7 = FND_API.G_MISS_CHAR THEN
2199: l_Header_Price_Att_Rec.attribute7 := NULL;
2200: END IF;
2201:
2202: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
2203: l_Header_Price_Att_Rec.attribute8 := NULL;
2204: END IF;
2205:
2206: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
2202: IF l_Header_Price_Att_Rec.attribute8 = FND_API.G_MISS_CHAR THEN
2203: l_Header_Price_Att_Rec.attribute8 := NULL;
2204: END IF;
2205:
2206: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
2207: l_Header_Price_Att_Rec.attribute9 := NULL;
2208: END IF;
2209:
2210: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
2206: IF l_Header_Price_Att_Rec.attribute9 = FND_API.G_MISS_CHAR THEN
2207: l_Header_Price_Att_Rec.attribute9 := NULL;
2208: END IF;
2209:
2210: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
2211: l_Header_Price_Att_Rec.context := NULL;
2212: END IF;
2213:
2214: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
2210: IF l_Header_Price_Att_Rec.context = FND_API.G_MISS_CHAR THEN
2211: l_Header_Price_Att_Rec.context := NULL;
2212: END IF;
2213:
2214: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
2215: l_Header_Price_Att_Rec.created_by := NULL;
2216: END IF;
2217:
2218: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
2214: IF l_Header_Price_Att_Rec.created_by = FND_API.G_MISS_NUM THEN
2215: l_Header_Price_Att_Rec.created_by := NULL;
2216: END IF;
2217:
2218: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
2219: l_Header_Price_Att_Rec.creation_date := NULL;
2220: END IF;
2221:
2222: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
2218: IF l_Header_Price_Att_Rec.creation_date = FND_API.G_MISS_DATE THEN
2219: l_Header_Price_Att_Rec.creation_date := NULL;
2220: END IF;
2221:
2222: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
2223: l_Header_Price_Att_Rec.flex_title := NULL;
2224: END IF;
2225:
2226: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
2222: IF l_Header_Price_Att_Rec.flex_title = FND_API.G_MISS_CHAR THEN
2223: l_Header_Price_Att_Rec.flex_title := NULL;
2224: END IF;
2225:
2226: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
2227: l_Header_Price_Att_Rec.header_id := NULL;
2228: END IF;
2229:
2230: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
2226: IF l_Header_Price_Att_Rec.header_id = FND_API.G_MISS_NUM THEN
2227: l_Header_Price_Att_Rec.header_id := NULL;
2228: END IF;
2229:
2230: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
2231: l_Header_Price_Att_Rec.last_updated_by := NULL;
2232: END IF;
2233:
2234: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
2230: IF l_Header_Price_Att_Rec.last_updated_by = FND_API.G_MISS_NUM THEN
2231: l_Header_Price_Att_Rec.last_updated_by := NULL;
2232: END IF;
2233:
2234: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
2235: l_Header_Price_Att_Rec.last_update_date := NULL;
2236: END IF;
2237:
2238: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
2234: IF l_Header_Price_Att_Rec.last_update_date = FND_API.G_MISS_DATE THEN
2235: l_Header_Price_Att_Rec.last_update_date := NULL;
2236: END IF;
2237:
2238: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
2239: l_Header_Price_Att_Rec.last_update_login := NULL;
2240: END IF;
2241:
2242: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
2238: IF l_Header_Price_Att_Rec.last_update_login = FND_API.G_MISS_NUM THEN
2239: l_Header_Price_Att_Rec.last_update_login := NULL;
2240: END IF;
2241:
2242: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
2243: l_Header_Price_Att_Rec.line_id := NULL;
2244: END IF;
2245:
2246: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2242: IF l_Header_Price_Att_Rec.line_id = FND_API.G_MISS_NUM THEN
2243: l_Header_Price_Att_Rec.line_id := NULL;
2244: END IF;
2245:
2246: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2247: l_Header_Price_Att_Rec.order_price_attrib_id := NULL;
2248: END IF;
2249:
2250: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2246: IF l_Header_Price_Att_Rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2247: l_Header_Price_Att_Rec.order_price_attrib_id := NULL;
2248: END IF;
2249:
2250: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2251: l_Header_Price_Att_Rec.pricing_attribute1 := NULL;
2252: END IF;
2253:
2254: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2250: IF l_Header_Price_Att_Rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2251: l_Header_Price_Att_Rec.pricing_attribute1 := NULL;
2252: END IF;
2253:
2254: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2255: l_Header_Price_Att_Rec.pricing_attribute10 := NULL;
2256: END IF;
2257:
2258: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2254: IF l_Header_Price_Att_Rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2255: l_Header_Price_Att_Rec.pricing_attribute10 := NULL;
2256: END IF;
2257:
2258: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2259: l_Header_Price_Att_Rec.pricing_attribute100 := NULL;
2260: END IF;
2261:
2262: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2258: IF l_Header_Price_Att_Rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2259: l_Header_Price_Att_Rec.pricing_attribute100 := NULL;
2260: END IF;
2261:
2262: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2263: l_Header_Price_Att_Rec.pricing_attribute11 := NULL;
2264: END IF;
2265:
2266: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2262: IF l_Header_Price_Att_Rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2263: l_Header_Price_Att_Rec.pricing_attribute11 := NULL;
2264: END IF;
2265:
2266: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2267: l_Header_Price_Att_Rec.pricing_attribute12 := NULL;
2268: END IF;
2269:
2270: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2266: IF l_Header_Price_Att_Rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2267: l_Header_Price_Att_Rec.pricing_attribute12 := NULL;
2268: END IF;
2269:
2270: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2271: l_Header_Price_Att_Rec.pricing_attribute13 := NULL;
2272: END IF;
2273:
2274: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2270: IF l_Header_Price_Att_Rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2271: l_Header_Price_Att_Rec.pricing_attribute13 := NULL;
2272: END IF;
2273:
2274: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2275: l_Header_Price_Att_Rec.pricing_attribute14 := NULL;
2276: END IF;
2277:
2278: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2274: IF l_Header_Price_Att_Rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2275: l_Header_Price_Att_Rec.pricing_attribute14 := NULL;
2276: END IF;
2277:
2278: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2279: l_Header_Price_Att_Rec.pricing_attribute15 := NULL;
2280: END IF;
2281:
2282: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2278: IF l_Header_Price_Att_Rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2279: l_Header_Price_Att_Rec.pricing_attribute15 := NULL;
2280: END IF;
2281:
2282: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2283: l_Header_Price_Att_Rec.pricing_attribute16 := NULL;
2284: END IF;
2285:
2286: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2282: IF l_Header_Price_Att_Rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2283: l_Header_Price_Att_Rec.pricing_attribute16 := NULL;
2284: END IF;
2285:
2286: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2287: l_Header_Price_Att_Rec.pricing_attribute17 := NULL;
2288: END IF;
2289:
2290: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2286: IF l_Header_Price_Att_Rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2287: l_Header_Price_Att_Rec.pricing_attribute17 := NULL;
2288: END IF;
2289:
2290: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2291: l_Header_Price_Att_Rec.pricing_attribute18 := NULL;
2292: END IF;
2293:
2294: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2290: IF l_Header_Price_Att_Rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2291: l_Header_Price_Att_Rec.pricing_attribute18 := NULL;
2292: END IF;
2293:
2294: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2295: l_Header_Price_Att_Rec.pricing_attribute19 := NULL;
2296: END IF;
2297:
2298: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2294: IF l_Header_Price_Att_Rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2295: l_Header_Price_Att_Rec.pricing_attribute19 := NULL;
2296: END IF;
2297:
2298: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2299: l_Header_Price_Att_Rec.pricing_attribute2 := NULL;
2300: END IF;
2301:
2302: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2298: IF l_Header_Price_Att_Rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2299: l_Header_Price_Att_Rec.pricing_attribute2 := NULL;
2300: END IF;
2301:
2302: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2303: l_Header_Price_Att_Rec.pricing_attribute20 := NULL;
2304: END IF;
2305:
2306: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2302: IF l_Header_Price_Att_Rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2303: l_Header_Price_Att_Rec.pricing_attribute20 := NULL;
2304: END IF;
2305:
2306: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2307: l_Header_Price_Att_Rec.pricing_attribute21 := NULL;
2308: END IF;
2309:
2310: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2306: IF l_Header_Price_Att_Rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2307: l_Header_Price_Att_Rec.pricing_attribute21 := NULL;
2308: END IF;
2309:
2310: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2311: l_Header_Price_Att_Rec.pricing_attribute22 := NULL;
2312: END IF;
2313:
2314: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2310: IF l_Header_Price_Att_Rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2311: l_Header_Price_Att_Rec.pricing_attribute22 := NULL;
2312: END IF;
2313:
2314: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2315: l_Header_Price_Att_Rec.pricing_attribute23 := NULL;
2316: END IF;
2317:
2318: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2314: IF l_Header_Price_Att_Rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2315: l_Header_Price_Att_Rec.pricing_attribute23 := NULL;
2316: END IF;
2317:
2318: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2319: l_Header_Price_Att_Rec.pricing_attribute24 := NULL;
2320: END IF;
2321:
2322: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2318: IF l_Header_Price_Att_Rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2319: l_Header_Price_Att_Rec.pricing_attribute24 := NULL;
2320: END IF;
2321:
2322: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2323: l_Header_Price_Att_Rec.pricing_attribute25 := NULL;
2324: END IF;
2325:
2326: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2322: IF l_Header_Price_Att_Rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2323: l_Header_Price_Att_Rec.pricing_attribute25 := NULL;
2324: END IF;
2325:
2326: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2327: l_Header_Price_Att_Rec.pricing_attribute26 := NULL;
2328: END IF;
2329:
2330: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2326: IF l_Header_Price_Att_Rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2327: l_Header_Price_Att_Rec.pricing_attribute26 := NULL;
2328: END IF;
2329:
2330: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2331: l_Header_Price_Att_Rec.pricing_attribute27 := NULL;
2332: END IF;
2333:
2334: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2330: IF l_Header_Price_Att_Rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2331: l_Header_Price_Att_Rec.pricing_attribute27 := NULL;
2332: END IF;
2333:
2334: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2335: l_Header_Price_Att_Rec.pricing_attribute28 := NULL;
2336: END IF;
2337:
2338: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2334: IF l_Header_Price_Att_Rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2335: l_Header_Price_Att_Rec.pricing_attribute28 := NULL;
2336: END IF;
2337:
2338: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2339: l_Header_Price_Att_Rec.pricing_attribute29 := NULL;
2340: END IF;
2341:
2342: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2338: IF l_Header_Price_Att_Rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2339: l_Header_Price_Att_Rec.pricing_attribute29 := NULL;
2340: END IF;
2341:
2342: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2343: l_Header_Price_Att_Rec.pricing_attribute3 := NULL;
2344: END IF;
2345:
2346: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2342: IF l_Header_Price_Att_Rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2343: l_Header_Price_Att_Rec.pricing_attribute3 := NULL;
2344: END IF;
2345:
2346: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2347: l_Header_Price_Att_Rec.pricing_attribute30 := NULL;
2348: END IF;
2349:
2350: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2346: IF l_Header_Price_Att_Rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2347: l_Header_Price_Att_Rec.pricing_attribute30 := NULL;
2348: END IF;
2349:
2350: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2351: l_Header_Price_Att_Rec.pricing_attribute31 := NULL;
2352: END IF;
2353:
2354: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2350: IF l_Header_Price_Att_Rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2351: l_Header_Price_Att_Rec.pricing_attribute31 := NULL;
2352: END IF;
2353:
2354: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2355: l_Header_Price_Att_Rec.pricing_attribute32 := NULL;
2356: END IF;
2357:
2358: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2354: IF l_Header_Price_Att_Rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2355: l_Header_Price_Att_Rec.pricing_attribute32 := NULL;
2356: END IF;
2357:
2358: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2359: l_Header_Price_Att_Rec.pricing_attribute33 := NULL;
2360: END IF;
2361:
2362: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2358: IF l_Header_Price_Att_Rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2359: l_Header_Price_Att_Rec.pricing_attribute33 := NULL;
2360: END IF;
2361:
2362: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2363: l_Header_Price_Att_Rec.pricing_attribute34 := NULL;
2364: END IF;
2365:
2366: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2362: IF l_Header_Price_Att_Rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2363: l_Header_Price_Att_Rec.pricing_attribute34 := NULL;
2364: END IF;
2365:
2366: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2367: l_Header_Price_Att_Rec.pricing_attribute35 := NULL;
2368: END IF;
2369:
2370: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2366: IF l_Header_Price_Att_Rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2367: l_Header_Price_Att_Rec.pricing_attribute35 := NULL;
2368: END IF;
2369:
2370: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2371: l_Header_Price_Att_Rec.pricing_attribute36 := NULL;
2372: END IF;
2373:
2374: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2370: IF l_Header_Price_Att_Rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2371: l_Header_Price_Att_Rec.pricing_attribute36 := NULL;
2372: END IF;
2373:
2374: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2375: l_Header_Price_Att_Rec.pricing_attribute37 := NULL;
2376: END IF;
2377:
2378: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2374: IF l_Header_Price_Att_Rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2375: l_Header_Price_Att_Rec.pricing_attribute37 := NULL;
2376: END IF;
2377:
2378: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2379: l_Header_Price_Att_Rec.pricing_attribute38 := NULL;
2380: END IF;
2381:
2382: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2378: IF l_Header_Price_Att_Rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2379: l_Header_Price_Att_Rec.pricing_attribute38 := NULL;
2380: END IF;
2381:
2382: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2383: l_Header_Price_Att_Rec.pricing_attribute39 := NULL;
2384: END IF;
2385:
2386: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2382: IF l_Header_Price_Att_Rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2383: l_Header_Price_Att_Rec.pricing_attribute39 := NULL;
2384: END IF;
2385:
2386: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2387: l_Header_Price_Att_Rec.pricing_attribute4 := NULL;
2388: END IF;
2389:
2390: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2386: IF l_Header_Price_Att_Rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2387: l_Header_Price_Att_Rec.pricing_attribute4 := NULL;
2388: END IF;
2389:
2390: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2391: l_Header_Price_Att_Rec.pricing_attribute40 := NULL;
2392: END IF;
2393:
2394: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2390: IF l_Header_Price_Att_Rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2391: l_Header_Price_Att_Rec.pricing_attribute40 := NULL;
2392: END IF;
2393:
2394: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2395: l_Header_Price_Att_Rec.pricing_attribute41 := NULL;
2396: END IF;
2397:
2398: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2394: IF l_Header_Price_Att_Rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2395: l_Header_Price_Att_Rec.pricing_attribute41 := NULL;
2396: END IF;
2397:
2398: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2399: l_Header_Price_Att_Rec.pricing_attribute42 := NULL;
2400: END IF;
2401:
2402: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2398: IF l_Header_Price_Att_Rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2399: l_Header_Price_Att_Rec.pricing_attribute42 := NULL;
2400: END IF;
2401:
2402: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2403: l_Header_Price_Att_Rec.pricing_attribute43 := NULL;
2404: END IF;
2405:
2406: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2402: IF l_Header_Price_Att_Rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2403: l_Header_Price_Att_Rec.pricing_attribute43 := NULL;
2404: END IF;
2405:
2406: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2407: l_Header_Price_Att_Rec.pricing_attribute44 := NULL;
2408: END IF;
2409:
2410: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2406: IF l_Header_Price_Att_Rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2407: l_Header_Price_Att_Rec.pricing_attribute44 := NULL;
2408: END IF;
2409:
2410: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2411: l_Header_Price_Att_Rec.pricing_attribute45 := NULL;
2412: END IF;
2413:
2414: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2410: IF l_Header_Price_Att_Rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2411: l_Header_Price_Att_Rec.pricing_attribute45 := NULL;
2412: END IF;
2413:
2414: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2415: l_Header_Price_Att_Rec.pricing_attribute46 := NULL;
2416: END IF;
2417:
2418: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2414: IF l_Header_Price_Att_Rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2415: l_Header_Price_Att_Rec.pricing_attribute46 := NULL;
2416: END IF;
2417:
2418: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2419: l_Header_Price_Att_Rec.pricing_attribute47 := NULL;
2420: END IF;
2421:
2422: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2418: IF l_Header_Price_Att_Rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2419: l_Header_Price_Att_Rec.pricing_attribute47 := NULL;
2420: END IF;
2421:
2422: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2423: l_Header_Price_Att_Rec.pricing_attribute48 := NULL;
2424: END IF;
2425:
2426: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2422: IF l_Header_Price_Att_Rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2423: l_Header_Price_Att_Rec.pricing_attribute48 := NULL;
2424: END IF;
2425:
2426: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2427: l_Header_Price_Att_Rec.pricing_attribute49 := NULL;
2428: END IF;
2429:
2430: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2426: IF l_Header_Price_Att_Rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2427: l_Header_Price_Att_Rec.pricing_attribute49 := NULL;
2428: END IF;
2429:
2430: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2431: l_Header_Price_Att_Rec.pricing_attribute5 := NULL;
2432: END IF;
2433:
2434: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2430: IF l_Header_Price_Att_Rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2431: l_Header_Price_Att_Rec.pricing_attribute5 := NULL;
2432: END IF;
2433:
2434: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2435: l_Header_Price_Att_Rec.pricing_attribute50 := NULL;
2436: END IF;
2437:
2438: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2434: IF l_Header_Price_Att_Rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2435: l_Header_Price_Att_Rec.pricing_attribute50 := NULL;
2436: END IF;
2437:
2438: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2439: l_Header_Price_Att_Rec.pricing_attribute51 := NULL;
2440: END IF;
2441:
2442: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2438: IF l_Header_Price_Att_Rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2439: l_Header_Price_Att_Rec.pricing_attribute51 := NULL;
2440: END IF;
2441:
2442: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2443: l_Header_Price_Att_Rec.pricing_attribute52 := NULL;
2444: END IF;
2445:
2446: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2442: IF l_Header_Price_Att_Rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2443: l_Header_Price_Att_Rec.pricing_attribute52 := NULL;
2444: END IF;
2445:
2446: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2447: l_Header_Price_Att_Rec.pricing_attribute53 := NULL;
2448: END IF;
2449:
2450: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2446: IF l_Header_Price_Att_Rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2447: l_Header_Price_Att_Rec.pricing_attribute53 := NULL;
2448: END IF;
2449:
2450: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2451: l_Header_Price_Att_Rec.pricing_attribute54 := NULL;
2452: END IF;
2453:
2454: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2450: IF l_Header_Price_Att_Rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2451: l_Header_Price_Att_Rec.pricing_attribute54 := NULL;
2452: END IF;
2453:
2454: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2455: l_Header_Price_Att_Rec.pricing_attribute55 := NULL;
2456: END IF;
2457:
2458: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2454: IF l_Header_Price_Att_Rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2455: l_Header_Price_Att_Rec.pricing_attribute55 := NULL;
2456: END IF;
2457:
2458: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2459: l_Header_Price_Att_Rec.pricing_attribute56 := NULL;
2460: END IF;
2461:
2462: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2458: IF l_Header_Price_Att_Rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2459: l_Header_Price_Att_Rec.pricing_attribute56 := NULL;
2460: END IF;
2461:
2462: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2463: l_Header_Price_Att_Rec.pricing_attribute57 := NULL;
2464: END IF;
2465:
2466: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2462: IF l_Header_Price_Att_Rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2463: l_Header_Price_Att_Rec.pricing_attribute57 := NULL;
2464: END IF;
2465:
2466: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2467: l_Header_Price_Att_Rec.pricing_attribute58 := NULL;
2468: END IF;
2469:
2470: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2466: IF l_Header_Price_Att_Rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2467: l_Header_Price_Att_Rec.pricing_attribute58 := NULL;
2468: END IF;
2469:
2470: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2471: l_Header_Price_Att_Rec.pricing_attribute59 := NULL;
2472: END IF;
2473:
2474: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2470: IF l_Header_Price_Att_Rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2471: l_Header_Price_Att_Rec.pricing_attribute59 := NULL;
2472: END IF;
2473:
2474: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2475: l_Header_Price_Att_Rec.pricing_attribute6 := NULL;
2476: END IF;
2477:
2478: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2474: IF l_Header_Price_Att_Rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2475: l_Header_Price_Att_Rec.pricing_attribute6 := NULL;
2476: END IF;
2477:
2478: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2479: l_Header_Price_Att_Rec.pricing_attribute60 := NULL;
2480: END IF;
2481:
2482: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2478: IF l_Header_Price_Att_Rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2479: l_Header_Price_Att_Rec.pricing_attribute60 := NULL;
2480: END IF;
2481:
2482: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2483: l_Header_Price_Att_Rec.pricing_attribute61 := NULL;
2484: END IF;
2485:
2486: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2482: IF l_Header_Price_Att_Rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2483: l_Header_Price_Att_Rec.pricing_attribute61 := NULL;
2484: END IF;
2485:
2486: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2487: l_Header_Price_Att_Rec.pricing_attribute62 := NULL;
2488: END IF;
2489:
2490: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2486: IF l_Header_Price_Att_Rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2487: l_Header_Price_Att_Rec.pricing_attribute62 := NULL;
2488: END IF;
2489:
2490: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2491: l_Header_Price_Att_Rec.pricing_attribute63 := NULL;
2492: END IF;
2493:
2494: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2490: IF l_Header_Price_Att_Rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2491: l_Header_Price_Att_Rec.pricing_attribute63 := NULL;
2492: END IF;
2493:
2494: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2495: l_Header_Price_Att_Rec.pricing_attribute64 := NULL;
2496: END IF;
2497:
2498: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2494: IF l_Header_Price_Att_Rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2495: l_Header_Price_Att_Rec.pricing_attribute64 := NULL;
2496: END IF;
2497:
2498: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2499: l_Header_Price_Att_Rec.pricing_attribute65 := NULL;
2500: END IF;
2501:
2502: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2498: IF l_Header_Price_Att_Rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2499: l_Header_Price_Att_Rec.pricing_attribute65 := NULL;
2500: END IF;
2501:
2502: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2503: l_Header_Price_Att_Rec.pricing_attribute66 := NULL;
2504: END IF;
2505:
2506: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2502: IF l_Header_Price_Att_Rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2503: l_Header_Price_Att_Rec.pricing_attribute66 := NULL;
2504: END IF;
2505:
2506: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2507: l_Header_Price_Att_Rec.pricing_attribute67 := NULL;
2508: END IF;
2509:
2510: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2506: IF l_Header_Price_Att_Rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2507: l_Header_Price_Att_Rec.pricing_attribute67 := NULL;
2508: END IF;
2509:
2510: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2511: l_Header_Price_Att_Rec.pricing_attribute68 := NULL;
2512: END IF;
2513:
2514: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2510: IF l_Header_Price_Att_Rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2511: l_Header_Price_Att_Rec.pricing_attribute68 := NULL;
2512: END IF;
2513:
2514: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2515: l_Header_Price_Att_Rec.pricing_attribute69 := NULL;
2516: END IF;
2517:
2518: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2514: IF l_Header_Price_Att_Rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2515: l_Header_Price_Att_Rec.pricing_attribute69 := NULL;
2516: END IF;
2517:
2518: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2519: l_Header_Price_Att_Rec.pricing_attribute7 := NULL;
2520: END IF;
2521:
2522: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2518: IF l_Header_Price_Att_Rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2519: l_Header_Price_Att_Rec.pricing_attribute7 := NULL;
2520: END IF;
2521:
2522: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2523: l_Header_Price_Att_Rec.pricing_attribute70 := NULL;
2524: END IF;
2525:
2526: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2522: IF l_Header_Price_Att_Rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2523: l_Header_Price_Att_Rec.pricing_attribute70 := NULL;
2524: END IF;
2525:
2526: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2527: l_Header_Price_Att_Rec.pricing_attribute71 := NULL;
2528: END IF;
2529:
2530: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2526: IF l_Header_Price_Att_Rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2527: l_Header_Price_Att_Rec.pricing_attribute71 := NULL;
2528: END IF;
2529:
2530: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2531: l_Header_Price_Att_Rec.pricing_attribute72 := NULL;
2532: END IF;
2533:
2534: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2530: IF l_Header_Price_Att_Rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2531: l_Header_Price_Att_Rec.pricing_attribute72 := NULL;
2532: END IF;
2533:
2534: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2535: l_Header_Price_Att_Rec.pricing_attribute73 := NULL;
2536: END IF;
2537:
2538: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2534: IF l_Header_Price_Att_Rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2535: l_Header_Price_Att_Rec.pricing_attribute73 := NULL;
2536: END IF;
2537:
2538: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2539: l_Header_Price_Att_Rec.pricing_attribute74 := NULL;
2540: END IF;
2541:
2542: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2538: IF l_Header_Price_Att_Rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2539: l_Header_Price_Att_Rec.pricing_attribute74 := NULL;
2540: END IF;
2541:
2542: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2543: l_Header_Price_Att_Rec.pricing_attribute75 := NULL;
2544: END IF;
2545:
2546: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2542: IF l_Header_Price_Att_Rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2543: l_Header_Price_Att_Rec.pricing_attribute75 := NULL;
2544: END IF;
2545:
2546: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2547: l_Header_Price_Att_Rec.pricing_attribute76 := NULL;
2548: END IF;
2549:
2550: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2546: IF l_Header_Price_Att_Rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2547: l_Header_Price_Att_Rec.pricing_attribute76 := NULL;
2548: END IF;
2549:
2550: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2551: l_Header_Price_Att_Rec.pricing_attribute77 := NULL;
2552: END IF;
2553:
2554: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2550: IF l_Header_Price_Att_Rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2551: l_Header_Price_Att_Rec.pricing_attribute77 := NULL;
2552: END IF;
2553:
2554: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2555: l_Header_Price_Att_Rec.pricing_attribute78 := NULL;
2556: END IF;
2557:
2558: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2554: IF l_Header_Price_Att_Rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2555: l_Header_Price_Att_Rec.pricing_attribute78 := NULL;
2556: END IF;
2557:
2558: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2559: l_Header_Price_Att_Rec.pricing_attribute79 := NULL;
2560: END IF;
2561:
2562: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2558: IF l_Header_Price_Att_Rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2559: l_Header_Price_Att_Rec.pricing_attribute79 := NULL;
2560: END IF;
2561:
2562: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2563: l_Header_Price_Att_Rec.pricing_attribute8 := NULL;
2564: END IF;
2565:
2566: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2562: IF l_Header_Price_Att_Rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2563: l_Header_Price_Att_Rec.pricing_attribute8 := NULL;
2564: END IF;
2565:
2566: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2567: l_Header_Price_Att_Rec.pricing_attribute80 := NULL;
2568: END IF;
2569:
2570: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2566: IF l_Header_Price_Att_Rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2567: l_Header_Price_Att_Rec.pricing_attribute80 := NULL;
2568: END IF;
2569:
2570: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2571: l_Header_Price_Att_Rec.pricing_attribute81 := NULL;
2572: END IF;
2573:
2574: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2570: IF l_Header_Price_Att_Rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2571: l_Header_Price_Att_Rec.pricing_attribute81 := NULL;
2572: END IF;
2573:
2574: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2575: l_Header_Price_Att_Rec.pricing_attribute82 := NULL;
2576: END IF;
2577:
2578: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2574: IF l_Header_Price_Att_Rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2575: l_Header_Price_Att_Rec.pricing_attribute82 := NULL;
2576: END IF;
2577:
2578: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2579: l_Header_Price_Att_Rec.pricing_attribute83 := NULL;
2580: END IF;
2581:
2582: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2578: IF l_Header_Price_Att_Rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2579: l_Header_Price_Att_Rec.pricing_attribute83 := NULL;
2580: END IF;
2581:
2582: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2583: l_Header_Price_Att_Rec.pricing_attribute84 := NULL;
2584: END IF;
2585:
2586: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2582: IF l_Header_Price_Att_Rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2583: l_Header_Price_Att_Rec.pricing_attribute84 := NULL;
2584: END IF;
2585:
2586: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2587: l_Header_Price_Att_Rec.pricing_attribute85 := NULL;
2588: END IF;
2589:
2590: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2586: IF l_Header_Price_Att_Rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2587: l_Header_Price_Att_Rec.pricing_attribute85 := NULL;
2588: END IF;
2589:
2590: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2591: l_Header_Price_Att_Rec.pricing_attribute86 := NULL;
2592: END IF;
2593:
2594: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2590: IF l_Header_Price_Att_Rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2591: l_Header_Price_Att_Rec.pricing_attribute86 := NULL;
2592: END IF;
2593:
2594: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2595: l_Header_Price_Att_Rec.pricing_attribute87 := NULL;
2596: END IF;
2597:
2598: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2594: IF l_Header_Price_Att_Rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2595: l_Header_Price_Att_Rec.pricing_attribute87 := NULL;
2596: END IF;
2597:
2598: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2599: l_Header_Price_Att_Rec.pricing_attribute88 := NULL;
2600: END IF;
2601:
2602: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2598: IF l_Header_Price_Att_Rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2599: l_Header_Price_Att_Rec.pricing_attribute88 := NULL;
2600: END IF;
2601:
2602: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2603: l_Header_Price_Att_Rec.pricing_attribute89 := NULL;
2604: END IF;
2605:
2606: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2602: IF l_Header_Price_Att_Rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2603: l_Header_Price_Att_Rec.pricing_attribute89 := NULL;
2604: END IF;
2605:
2606: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2607: l_Header_Price_Att_Rec.pricing_attribute9 := NULL;
2608: END IF;
2609:
2610: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2606: IF l_Header_Price_Att_Rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2607: l_Header_Price_Att_Rec.pricing_attribute9 := NULL;
2608: END IF;
2609:
2610: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2611: l_Header_Price_Att_Rec.pricing_attribute90 := NULL;
2612: END IF;
2613:
2614: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2610: IF l_Header_Price_Att_Rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2611: l_Header_Price_Att_Rec.pricing_attribute90 := NULL;
2612: END IF;
2613:
2614: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2615: l_Header_Price_Att_Rec.pricing_attribute91 := NULL;
2616: END IF;
2617:
2618: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2614: IF l_Header_Price_Att_Rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2615: l_Header_Price_Att_Rec.pricing_attribute91 := NULL;
2616: END IF;
2617:
2618: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2619: l_Header_Price_Att_Rec.pricing_attribute92 := NULL;
2620: END IF;
2621:
2622: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2618: IF l_Header_Price_Att_Rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2619: l_Header_Price_Att_Rec.pricing_attribute92 := NULL;
2620: END IF;
2621:
2622: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2623: l_Header_Price_Att_Rec.pricing_attribute93 := NULL;
2624: END IF;
2625:
2626: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2622: IF l_Header_Price_Att_Rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2623: l_Header_Price_Att_Rec.pricing_attribute93 := NULL;
2624: END IF;
2625:
2626: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2627: l_Header_Price_Att_Rec.pricing_attribute94 := NULL;
2628: END IF;
2629:
2630: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2626: IF l_Header_Price_Att_Rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2627: l_Header_Price_Att_Rec.pricing_attribute94 := NULL;
2628: END IF;
2629:
2630: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2631: l_Header_Price_Att_Rec.pricing_attribute95 := NULL;
2632: END IF;
2633:
2634: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2630: IF l_Header_Price_Att_Rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2631: l_Header_Price_Att_Rec.pricing_attribute95 := NULL;
2632: END IF;
2633:
2634: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2635: l_Header_Price_Att_Rec.pricing_attribute96 := NULL;
2636: END IF;
2637:
2638: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2634: IF l_Header_Price_Att_Rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2635: l_Header_Price_Att_Rec.pricing_attribute96 := NULL;
2636: END IF;
2637:
2638: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2639: l_Header_Price_Att_Rec.pricing_attribute97 := NULL;
2640: END IF;
2641:
2642: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2638: IF l_Header_Price_Att_Rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2639: l_Header_Price_Att_Rec.pricing_attribute97 := NULL;
2640: END IF;
2641:
2642: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2643: l_Header_Price_Att_Rec.pricing_attribute98 := NULL;
2644: END IF;
2645:
2646: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2642: IF l_Header_Price_Att_Rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2643: l_Header_Price_Att_Rec.pricing_attribute98 := NULL;
2644: END IF;
2645:
2646: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2647: l_Header_Price_Att_Rec.pricing_attribute99 := NULL;
2648: END IF;
2649:
2650: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2646: IF l_Header_Price_Att_Rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2647: l_Header_Price_Att_Rec.pricing_attribute99 := NULL;
2648: END IF;
2649:
2650: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2651: l_Header_Price_Att_Rec.pricing_context := NULL;
2652: END IF;
2653:
2654: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2650: IF l_Header_Price_Att_Rec.pricing_context = FND_API.G_MISS_CHAR THEN
2651: l_Header_Price_Att_Rec.pricing_context := NULL;
2652: END IF;
2653:
2654: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2655: l_Header_Price_Att_Rec.program_application_id := NULL;
2656: END IF;
2657:
2658: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2654: IF l_Header_Price_Att_Rec.program_application_id = FND_API.G_MISS_NUM THEN
2655: l_Header_Price_Att_Rec.program_application_id := NULL;
2656: END IF;
2657:
2658: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2659: l_Header_Price_Att_Rec.program_id := NULL;
2660: END IF;
2661:
2662: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2658: IF l_Header_Price_Att_Rec.program_id = FND_API.G_MISS_NUM THEN
2659: l_Header_Price_Att_Rec.program_id := NULL;
2660: END IF;
2661:
2662: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2663: l_Header_Price_Att_Rec.program_update_date := NULL;
2664: END IF;
2665:
2666: IF l_Header_Price_Att_Rec.request_id = FND_API.G_MISS_NUM THEN
2662: IF l_Header_Price_Att_Rec.program_update_date = FND_API.G_MISS_DATE THEN
2663: l_Header_Price_Att_Rec.program_update_date := NULL;
2664: END IF;
2665:
2666: IF l_Header_Price_Att_Rec.request_id = FND_API.G_MISS_NUM THEN
2667: l_Header_Price_Att_Rec.request_id := NULL;
2668: END IF;
2669:
2670: -- RETURN l_Header_Price_Att_Rec;
3468: */
3469:
3470: Begin
3471: -- use order_header cache instead of sql : bug 4200055
3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3537:
3538: END Apply_Attribute_Changes;
3539:
3540: PROCEDURE Delete_Row
3541: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
3542: , p_Header_id NUMBER := FND_API.G_MISS_NUM
3543: )
3544: IS
3545: --
3538: END Apply_Attribute_Changes;
3539:
3540: PROCEDURE Delete_Row
3541: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
3542: , p_Header_id NUMBER := FND_API.G_MISS_NUM
3543: )
3544: IS
3545: --
3546: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3545: --
3546: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3547: --
3548: BEGIN
3549: IF p_Header_id <> FND_API.G_MISS_NUM Then
3550:
3551: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3552: WHERE Header_Id = p_Header_id;
3553: Else
3566: ( G_PKG_NAME
3567: , 'Delete_Row'
3568: );
3569: END IF;
3570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3571:
3572: END Delete_Row;
3573:
3574: PROCEDURE Insert_Row
3870: ( G_PKG_NAME
3871: , 'Insert_Row'
3872: );
3873: END IF;
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875:
3876:
3877: END Insert_Row;
3878:
4050: ( G_PKG_NAME
4051: , 'Update_Row'
4052: );
4053: END IF;
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055:
4056: END Update_Row;
4057:
4058: -- Procedure lock_Row
4061: PROCEDURE Lock_Row
4062: ( x_return_status OUT NOCOPY VARCHAR2
4063:
4064: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
4065: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4066: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
4067: )
4068: IS
4069: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
4081: SAVEPOINT Lock_Row;
4082:
4083: l_lock_control := NULL;
4084:
4085: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4086: l_order_price_attrib_id := p_order_price_attrib_id;
4087: ELSE
4088: l_order_price_attrib_id := p_x_Header_Price_Att_rec.order_price_attrib_id;
4089: l_lock_control := p_x_Header_Price_Att_rec.lock_control;
4108: -- If lock_control is not passed(is null or missing), then return the locked record.
4109:
4110:
4111: IF l_lock_control is null OR
4112: l_lock_control = FND_API.G_MISS_NUM
4113: THEN
4114:
4115: -- Set return status
4116: x_return_status := FND_API.G_RET_STS_SUCCESS;
4112: l_lock_control = FND_API.G_MISS_NUM
4113: THEN
4114:
4115: -- Set return status
4116: x_return_status := FND_API.G_RET_STS_SUCCESS;
4117: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4118:
4119: -- return for lock by ID.
4120: RETURN;
4113: THEN
4114:
4115: -- Set return status
4116: x_return_status := FND_API.G_RET_STS_SUCCESS;
4117: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4118:
4119: -- return for lock by ID.
4120: RETURN;
4121:
4139: END IF;
4140:
4141: -- Set return status
4142:
4143: x_return_status := FND_API.G_RET_STS_SUCCESS;
4144: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4145:
4146: ELSE
4147:
4140:
4141: -- Set return status
4142:
4143: x_return_status := FND_API.G_RET_STS_SUCCESS;
4144: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4145:
4146: ELSE
4147:
4148: -- Row has changed by another user.
4149: IF l_debug_level > 0 THEN
4150: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4151: END IF;
4152:
4153: x_return_status := FND_API.G_RET_STS_ERROR;
4154: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4155:
4156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4157: THEN
4150: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4151: END IF;
4152:
4153: x_return_status := FND_API.G_RET_STS_ERROR;
4154: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4155:
4156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4157: THEN
4158:
4169: EXCEPTION
4170:
4171: WHEN NO_DATA_FOUND THEN
4172:
4173: x_return_status := FND_API.G_RET_STS_ERROR;
4174: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4175:
4176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4177: THEN
4170:
4171: WHEN NO_DATA_FOUND THEN
4172:
4173: x_return_status := FND_API.G_RET_STS_ERROR;
4174: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4175:
4176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4177: THEN
4178:
4181:
4182: END IF;
4183: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4184:
4185: x_return_status := FND_API.G_RET_STS_ERROR;
4186: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4187:
4188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4189: THEN
4182: END IF;
4183: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4184:
4185: x_return_status := FND_API.G_RET_STS_ERROR;
4186: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4187:
4188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4189: THEN
4190:
4193:
4194: END IF;
4195: WHEN OTHERS THEN
4196:
4197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4198: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199:
4200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4201: THEN
4194: END IF;
4195: WHEN OTHERS THEN
4196:
4197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4198: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199:
4200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4201: THEN
4202: FND_MSG_PUB.Add_Exc_Msg
4209:
4210: -- procedure lock_rows
4211: PROCEDURE Lock_Rows
4212: ( p_order_price_attrib_id IN NUMBER
4213: := FND_API.G_MISS_NUM
4214: , p_header_id IN NUMBER
4215: := FND_API.G_MISS_NUM
4216: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
4217: , x_return_status OUT NOCOPY VARCHAR2
4211: PROCEDURE Lock_Rows
4212: ( p_order_price_attrib_id IN NUMBER
4213: := FND_API.G_MISS_NUM
4214: , p_header_id IN NUMBER
4215: := FND_API.G_MISS_NUM
4216: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
4217: , x_return_status OUT NOCOPY VARCHAR2
4218:
4219: )
4238: oe_debug_pub.add( 'ENTERING OE_HEADER_PATTR_UTIL.LOCK_ROWS.' , 1 ) ;
4239: END IF;
4240:
4241: IF (p_order_price_attrib_id IS NOT NULL AND
4242: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4243: (p_header_id IS NOT NULL AND
4244: p_header_id <> FND_API.G_MISS_NUM)
4245: THEN
4246: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4240:
4241: IF (p_order_price_attrib_id IS NOT NULL AND
4242: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4243: (p_header_id IS NOT NULL AND
4244: p_header_id <> FND_API.G_MISS_NUM)
4245: THEN
4246: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4247: OE_MSG_PUB.Add_Exc_Msg
4248: ( G_PKG_NAME
4250: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4251: p_order_price_attrib_id || ', header_id = ' || p_header_id );
4252: END IF;
4253:
4254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4255: END IF;
4256:
4257: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4258:
4253:
4254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4255: END IF;
4256:
4257: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4258:
4259: SELECT order_price_attrib_id
4260: INTO l_order_price_attrib_id
4261: FROM oe_order_price_attribs
4265:
4266: -- null header_id shouldn't be passed in unnecessarily if
4267: -- order_price_attrib_id is passed in already.
4268: BEGIN
4269: IF p_header_id <> FND_API.G_MISS_NUM THEN
4270: SAVEPOINT LOCK_ROWS;
4271: OPEN lock_pattr_hdr(p_header_id);
4272:
4273: LOOP
4293: , p_header_id => p_header_id
4294: , x_Header_Price_Att_tbl => x_Header_Price_Att_tbl
4295: );
4296:
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: EXCEPTION
4300: WHEN NO_DATA_FOUND THEN
4301: x_return_status := FND_API.G_RET_STS_ERROR;
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: EXCEPTION
4300: WHEN NO_DATA_FOUND THEN
4301: x_return_status := FND_API.G_RET_STS_ERROR;
4302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4303: THEN
4304: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4305: OE_MSG_PUB.Add;
4305: OE_MSG_PUB.Add;
4306: END IF;
4307:
4308: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4309: x_return_status := FND_API.G_RET_STS_ERROR;
4310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4311: THEN
4312: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4313: OE_MSG_PUB.Add;
4313: OE_MSG_PUB.Add;
4314: END IF;
4315:
4316: WHEN OTHERS THEN
4317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4319: THEN
4320: OE_MSG_PUB.Add_Exc_Msg
4321: ( G_PKG_NAME