[Home] [Help]
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
13: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
14: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_Rec_Type
28:
29: -- If attr_id is missing compare old and new records and for
30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
35: THEN
36: l_index := l_index + 1;
869: IS
870:
871: --added by svdeshmu
872:
873: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
874:
875:
876: -- end of additions by svdeshmu
877:
1174: , p_entity_id => p_MODIFIERS_rec.list_line_id
1175: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1176: , x_return_status => l_return_status
1177: );
1178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182: end;
1175: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1176: , x_return_status => l_return_status
1177: );
1178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182: end;
1183:
1543: BEGIN
1544:
1545: oe_debug_pub.add('BEGIN Complete_Record in QPXUMLLB');
1546:
1547: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1548: l_MODIFIERS_rec.arithmetic_operator := p_old_MODIFIERS_rec.arithmetic_operator;
1549: END IF;
1550:
1551: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1547: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1548: l_MODIFIERS_rec.arithmetic_operator := p_old_MODIFIERS_rec.arithmetic_operator;
1549: END IF;
1550:
1551: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1552: l_MODIFIERS_rec.attribute1 := p_old_MODIFIERS_rec.attribute1;
1553: END IF;
1554:
1555: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1551: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1552: l_MODIFIERS_rec.attribute1 := p_old_MODIFIERS_rec.attribute1;
1553: END IF;
1554:
1555: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1556: l_MODIFIERS_rec.attribute10 := p_old_MODIFIERS_rec.attribute10;
1557: END IF;
1558:
1559: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1555: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1556: l_MODIFIERS_rec.attribute10 := p_old_MODIFIERS_rec.attribute10;
1557: END IF;
1558:
1559: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1560: l_MODIFIERS_rec.attribute11 := p_old_MODIFIERS_rec.attribute11;
1561: END IF;
1562:
1563: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1559: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1560: l_MODIFIERS_rec.attribute11 := p_old_MODIFIERS_rec.attribute11;
1561: END IF;
1562:
1563: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1564: l_MODIFIERS_rec.attribute12 := p_old_MODIFIERS_rec.attribute12;
1565: END IF;
1566:
1567: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1563: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1564: l_MODIFIERS_rec.attribute12 := p_old_MODIFIERS_rec.attribute12;
1565: END IF;
1566:
1567: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1568: l_MODIFIERS_rec.attribute13 := p_old_MODIFIERS_rec.attribute13;
1569: END IF;
1570:
1571: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1567: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1568: l_MODIFIERS_rec.attribute13 := p_old_MODIFIERS_rec.attribute13;
1569: END IF;
1570:
1571: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1572: l_MODIFIERS_rec.attribute14 := p_old_MODIFIERS_rec.attribute14;
1573: END IF;
1574:
1575: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1571: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1572: l_MODIFIERS_rec.attribute14 := p_old_MODIFIERS_rec.attribute14;
1573: END IF;
1574:
1575: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1576: l_MODIFIERS_rec.attribute15 := p_old_MODIFIERS_rec.attribute15;
1577: END IF;
1578:
1579: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1575: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1576: l_MODIFIERS_rec.attribute15 := p_old_MODIFIERS_rec.attribute15;
1577: END IF;
1578:
1579: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1580: l_MODIFIERS_rec.attribute2 := p_old_MODIFIERS_rec.attribute2;
1581: END IF;
1582:
1583: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1579: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1580: l_MODIFIERS_rec.attribute2 := p_old_MODIFIERS_rec.attribute2;
1581: END IF;
1582:
1583: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1584: l_MODIFIERS_rec.attribute3 := p_old_MODIFIERS_rec.attribute3;
1585: END IF;
1586:
1587: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1583: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1584: l_MODIFIERS_rec.attribute3 := p_old_MODIFIERS_rec.attribute3;
1585: END IF;
1586:
1587: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1588: l_MODIFIERS_rec.attribute4 := p_old_MODIFIERS_rec.attribute4;
1589: END IF;
1590:
1591: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1587: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1588: l_MODIFIERS_rec.attribute4 := p_old_MODIFIERS_rec.attribute4;
1589: END IF;
1590:
1591: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1592: l_MODIFIERS_rec.attribute5 := p_old_MODIFIERS_rec.attribute5;
1593: END IF;
1594:
1595: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1591: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1592: l_MODIFIERS_rec.attribute5 := p_old_MODIFIERS_rec.attribute5;
1593: END IF;
1594:
1595: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1596: l_MODIFIERS_rec.attribute6 := p_old_MODIFIERS_rec.attribute6;
1597: END IF;
1598:
1599: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1595: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1596: l_MODIFIERS_rec.attribute6 := p_old_MODIFIERS_rec.attribute6;
1597: END IF;
1598:
1599: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1600: l_MODIFIERS_rec.attribute7 := p_old_MODIFIERS_rec.attribute7;
1601: END IF;
1602:
1603: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1599: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1600: l_MODIFIERS_rec.attribute7 := p_old_MODIFIERS_rec.attribute7;
1601: END IF;
1602:
1603: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1604: l_MODIFIERS_rec.attribute8 := p_old_MODIFIERS_rec.attribute8;
1605: END IF;
1606:
1607: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1603: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1604: l_MODIFIERS_rec.attribute8 := p_old_MODIFIERS_rec.attribute8;
1605: END IF;
1606:
1607: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1608: l_MODIFIERS_rec.attribute9 := p_old_MODIFIERS_rec.attribute9;
1609: END IF;
1610:
1611: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1607: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1608: l_MODIFIERS_rec.attribute9 := p_old_MODIFIERS_rec.attribute9;
1609: END IF;
1610:
1611: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1612: l_MODIFIERS_rec.automatic_flag := p_old_MODIFIERS_rec.automatic_flag;
1613: END IF;
1614:
1615: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1611: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1612: l_MODIFIERS_rec.automatic_flag := p_old_MODIFIERS_rec.automatic_flag;
1613: END IF;
1614:
1615: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1616: l_MODIFIERS_rec.base_qty := p_old_MODIFIERS_rec.base_qty;
1617: END IF;
1618: */
1619: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1615: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1616: l_MODIFIERS_rec.base_qty := p_old_MODIFIERS_rec.base_qty;
1617: END IF;
1618: */
1619: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1620: l_MODIFIERS_rec.pricing_phase_id := p_old_MODIFIERS_rec.pricing_phase_id;
1621: END IF;
1622:
1623: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1619: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1620: l_MODIFIERS_rec.pricing_phase_id := p_old_MODIFIERS_rec.pricing_phase_id;
1621: END IF;
1622:
1623: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1624: l_MODIFIERS_rec.base_uom_code := p_old_MODIFIERS_rec.base_uom_code;
1625: END IF;
1626: */
1627: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1623: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1624: l_MODIFIERS_rec.base_uom_code := p_old_MODIFIERS_rec.base_uom_code;
1625: END IF;
1626: */
1627: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1628: l_MODIFIERS_rec.comments := p_old_MODIFIERS_rec.comments;
1629: END IF;
1630:
1631: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1627: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1628: l_MODIFIERS_rec.comments := p_old_MODIFIERS_rec.comments;
1629: END IF;
1630:
1631: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1632: l_MODIFIERS_rec.context := p_old_MODIFIERS_rec.context;
1633: END IF;
1634:
1635: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1631: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1632: l_MODIFIERS_rec.context := p_old_MODIFIERS_rec.context;
1633: END IF;
1634:
1635: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1636: l_MODIFIERS_rec.created_by := p_old_MODIFIERS_rec.created_by;
1637: END IF;
1638:
1639: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1635: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1636: l_MODIFIERS_rec.created_by := p_old_MODIFIERS_rec.created_by;
1637: END IF;
1638:
1639: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1640: l_MODIFIERS_rec.creation_date := p_old_MODIFIERS_rec.creation_date;
1641: END IF;
1642:
1643: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1639: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1640: l_MODIFIERS_rec.creation_date := p_old_MODIFIERS_rec.creation_date;
1641: END IF;
1642:
1643: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1644: l_MODIFIERS_rec.effective_period_uom := p_old_MODIFIERS_rec.effective_period_uom;
1645: END IF;
1646:
1647: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1643: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1644: l_MODIFIERS_rec.effective_period_uom := p_old_MODIFIERS_rec.effective_period_uom;
1645: END IF;
1646:
1647: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1648: l_MODIFIERS_rec.end_date_active := p_old_MODIFIERS_rec.end_date_active;
1649: END IF;
1650:
1651: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1647: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1648: l_MODIFIERS_rec.end_date_active := p_old_MODIFIERS_rec.end_date_active;
1649: END IF;
1650:
1651: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1652: l_MODIFIERS_rec.estim_accrual_rate := p_old_MODIFIERS_rec.estim_accrual_rate;
1653: END IF;
1654:
1655: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1651: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1652: l_MODIFIERS_rec.estim_accrual_rate := p_old_MODIFIERS_rec.estim_accrual_rate;
1653: END IF;
1654:
1655: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1656: l_MODIFIERS_rec.generate_using_formula_id := p_old_MODIFIERS_rec.generate_using_formula_id;
1657: END IF;
1658:
1659: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1655: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1656: l_MODIFIERS_rec.generate_using_formula_id := p_old_MODIFIERS_rec.generate_using_formula_id;
1657: END IF;
1658:
1659: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1660: l_MODIFIERS_rec.inventory_item_id := p_old_MODIFIERS_rec.inventory_item_id;
1661: END IF;
1662:
1663: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1659: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1660: l_MODIFIERS_rec.inventory_item_id := p_old_MODIFIERS_rec.inventory_item_id;
1661: END IF;
1662:
1663: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1664: l_MODIFIERS_rec.last_updated_by := p_old_MODIFIERS_rec.last_updated_by;
1665: END IF;
1666:
1667: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1663: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1664: l_MODIFIERS_rec.last_updated_by := p_old_MODIFIERS_rec.last_updated_by;
1665: END IF;
1666:
1667: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1668: l_MODIFIERS_rec.last_update_date := p_old_MODIFIERS_rec.last_update_date;
1669: END IF;
1670:
1671: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1667: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1668: l_MODIFIERS_rec.last_update_date := p_old_MODIFIERS_rec.last_update_date;
1669: END IF;
1670:
1671: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1672: l_MODIFIERS_rec.last_update_login := p_old_MODIFIERS_rec.last_update_login;
1673: END IF;
1674:
1675: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1671: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1672: l_MODIFIERS_rec.last_update_login := p_old_MODIFIERS_rec.last_update_login;
1673: END IF;
1674:
1675: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1676: l_MODIFIERS_rec.list_header_id := p_old_MODIFIERS_rec.list_header_id;
1677: END IF;
1678:
1679: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1675: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1676: l_MODIFIERS_rec.list_header_id := p_old_MODIFIERS_rec.list_header_id;
1677: END IF;
1678:
1679: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1680: l_MODIFIERS_rec.list_line_id := p_old_MODIFIERS_rec.list_line_id;
1681: END IF;
1682:
1683: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1679: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1680: l_MODIFIERS_rec.list_line_id := p_old_MODIFIERS_rec.list_line_id;
1681: END IF;
1682:
1683: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1684: l_MODIFIERS_rec.list_line_type_code := p_old_MODIFIERS_rec.list_line_type_code;
1685: END IF;
1686:
1687: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1683: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1684: l_MODIFIERS_rec.list_line_type_code := p_old_MODIFIERS_rec.list_line_type_code;
1685: END IF;
1686:
1687: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1688: l_MODIFIERS_rec.list_price := p_old_MODIFIERS_rec.list_price;
1689: END IF;
1690:
1691: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1687: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1688: l_MODIFIERS_rec.list_price := p_old_MODIFIERS_rec.list_price;
1689: END IF;
1690:
1691: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1692: l_MODIFIERS_rec.modifier_level_code := p_old_MODIFIERS_rec.modifier_level_code;
1693: END IF;
1694:
1695: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1691: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1692: l_MODIFIERS_rec.modifier_level_code := p_old_MODIFIERS_rec.modifier_level_code;
1693: END IF;
1694:
1695: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1696: l_MODIFIERS_rec.number_effective_periods := p_old_MODIFIERS_rec.number_effective_periods;
1697: END IF;
1698:
1699: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1695: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1696: l_MODIFIERS_rec.number_effective_periods := p_old_MODIFIERS_rec.number_effective_periods;
1697: END IF;
1698:
1699: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1700: l_MODIFIERS_rec.operand := p_old_MODIFIERS_rec.operand;
1701: END IF;
1702:
1703: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1699: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1700: l_MODIFIERS_rec.operand := p_old_MODIFIERS_rec.operand;
1701: END IF;
1702:
1703: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1704: l_MODIFIERS_rec.organization_id := p_old_MODIFIERS_rec.organization_id;
1705: END IF;
1706:
1707: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1703: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1704: l_MODIFIERS_rec.organization_id := p_old_MODIFIERS_rec.organization_id;
1705: END IF;
1706:
1707: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1708: l_MODIFIERS_rec.override_flag := p_old_MODIFIERS_rec.override_flag;
1709: END IF;
1710:
1711: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1707: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1708: l_MODIFIERS_rec.override_flag := p_old_MODIFIERS_rec.override_flag;
1709: END IF;
1710:
1711: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1712: l_MODIFIERS_rec.percent_price := p_old_MODIFIERS_rec.percent_price;
1713: END IF;
1714:
1715: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1711: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1712: l_MODIFIERS_rec.percent_price := p_old_MODIFIERS_rec.percent_price;
1713: END IF;
1714:
1715: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1716: l_MODIFIERS_rec.price_break_type_code := p_old_MODIFIERS_rec.price_break_type_code;
1717: END IF;
1718:
1719: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1715: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1716: l_MODIFIERS_rec.price_break_type_code := p_old_MODIFIERS_rec.price_break_type_code;
1717: END IF;
1718:
1719: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1720: l_MODIFIERS_rec.price_by_formula_id := p_old_MODIFIERS_rec.price_by_formula_id;
1721: END IF;
1722:
1723: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1719: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1720: l_MODIFIERS_rec.price_by_formula_id := p_old_MODIFIERS_rec.price_by_formula_id;
1721: END IF;
1722:
1723: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1724: l_MODIFIERS_rec.primary_uom_flag := p_old_MODIFIERS_rec.primary_uom_flag;
1725: END IF;
1726:
1727: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1723: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1724: l_MODIFIERS_rec.primary_uom_flag := p_old_MODIFIERS_rec.primary_uom_flag;
1725: END IF;
1726:
1727: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1728: l_MODIFIERS_rec.print_on_invoice_flag := p_old_MODIFIERS_rec.print_on_invoice_flag;
1729: END IF;
1730:
1731: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1727: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1728: l_MODIFIERS_rec.print_on_invoice_flag := p_old_MODIFIERS_rec.print_on_invoice_flag;
1729: END IF;
1730:
1731: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1732: l_MODIFIERS_rec.program_application_id := p_old_MODIFIERS_rec.program_application_id;
1733: END IF;
1734:
1735: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1731: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1732: l_MODIFIERS_rec.program_application_id := p_old_MODIFIERS_rec.program_application_id;
1733: END IF;
1734:
1735: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1736: l_MODIFIERS_rec.program_id := p_old_MODIFIERS_rec.program_id;
1737: END IF;
1738:
1739: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1735: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1736: l_MODIFIERS_rec.program_id := p_old_MODIFIERS_rec.program_id;
1737: END IF;
1738:
1739: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1740: l_MODIFIERS_rec.program_update_date := p_old_MODIFIERS_rec.program_update_date;
1741: END IF;
1742:
1743: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1739: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1740: l_MODIFIERS_rec.program_update_date := p_old_MODIFIERS_rec.program_update_date;
1741: END IF;
1742:
1743: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1744: l_MODIFIERS_rec.rebate_trxn_type_code := p_old_MODIFIERS_rec.rebate_trxn_type_code;
1745: END IF;
1746:
1747: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1743: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1744: l_MODIFIERS_rec.rebate_trxn_type_code := p_old_MODIFIERS_rec.rebate_trxn_type_code;
1745: END IF;
1746:
1747: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1748: l_MODIFIERS_rec.related_item_id := p_old_MODIFIERS_rec.related_item_id;
1749: END IF;
1750:
1751: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1747: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1748: l_MODIFIERS_rec.related_item_id := p_old_MODIFIERS_rec.related_item_id;
1749: END IF;
1750:
1751: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1752: l_MODIFIERS_rec.relationship_type_id := p_old_MODIFIERS_rec.relationship_type_id;
1753: END IF;
1754:
1755: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1751: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1752: l_MODIFIERS_rec.relationship_type_id := p_old_MODIFIERS_rec.relationship_type_id;
1753: END IF;
1754:
1755: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1756: l_MODIFIERS_rec.reprice_flag := p_old_MODIFIERS_rec.reprice_flag;
1757: END IF;
1758:
1759: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1755: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1756: l_MODIFIERS_rec.reprice_flag := p_old_MODIFIERS_rec.reprice_flag;
1757: END IF;
1758:
1759: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1760: l_MODIFIERS_rec.request_id := p_old_MODIFIERS_rec.request_id;
1761: END IF;
1762:
1763: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1759: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1760: l_MODIFIERS_rec.request_id := p_old_MODIFIERS_rec.request_id;
1761: END IF;
1762:
1763: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1764: l_MODIFIERS_rec.revision := p_old_MODIFIERS_rec.revision;
1765: END IF;
1766:
1767: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1763: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1764: l_MODIFIERS_rec.revision := p_old_MODIFIERS_rec.revision;
1765: END IF;
1766:
1767: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1768: l_MODIFIERS_rec.revision_date := p_old_MODIFIERS_rec.revision_date;
1769: END IF;
1770:
1771: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1767: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1768: l_MODIFIERS_rec.revision_date := p_old_MODIFIERS_rec.revision_date;
1769: END IF;
1770:
1771: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1772: l_MODIFIERS_rec.revision_reason_code := p_old_MODIFIERS_rec.revision_reason_code;
1773: END IF;
1774:
1775: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1771: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1772: l_MODIFIERS_rec.revision_reason_code := p_old_MODIFIERS_rec.revision_reason_code;
1773: END IF;
1774:
1775: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1776: l_MODIFIERS_rec.start_date_active := p_old_MODIFIERS_rec.start_date_active;
1777: END IF;
1778:
1779: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1775: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1776: l_MODIFIERS_rec.start_date_active := p_old_MODIFIERS_rec.start_date_active;
1777: END IF;
1778:
1779: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1780: l_MODIFIERS_rec.substitution_attribute := p_old_MODIFIERS_rec.substitution_attribute;
1781: END IF;
1782:
1783: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1779: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1780: l_MODIFIERS_rec.substitution_attribute := p_old_MODIFIERS_rec.substitution_attribute;
1781: END IF;
1782:
1783: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1784: l_MODIFIERS_rec.substitution_context := p_old_MODIFIERS_rec.substitution_context;
1785: END IF;
1786:
1787: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1783: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1784: l_MODIFIERS_rec.substitution_context := p_old_MODIFIERS_rec.substitution_context;
1785: END IF;
1786:
1787: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1788: l_MODIFIERS_rec.substitution_value := p_old_MODIFIERS_rec.substitution_value;
1789: END IF;
1790:
1791: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1787: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1788: l_MODIFIERS_rec.substitution_value := p_old_MODIFIERS_rec.substitution_value;
1789: END IF;
1790:
1791: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1792: l_MODIFIERS_rec.accrual_flag := p_old_MODIFIERS_rec.accrual_flag;
1793: END IF;
1794:
1795: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1791: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1792: l_MODIFIERS_rec.accrual_flag := p_old_MODIFIERS_rec.accrual_flag;
1793: END IF;
1794:
1795: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1796: l_MODIFIERS_rec.pricing_group_sequence := p_old_MODIFIERS_rec.pricing_group_sequence;
1797: END IF;
1798:
1799: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1795: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1796: l_MODIFIERS_rec.pricing_group_sequence := p_old_MODIFIERS_rec.pricing_group_sequence;
1797: END IF;
1798:
1799: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1800: l_MODIFIERS_rec.incompatibility_grp_code := p_old_MODIFIERS_rec.incompatibility_grp_code;
1801: END IF;
1802:
1803: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1799: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1800: l_MODIFIERS_rec.incompatibility_grp_code := p_old_MODIFIERS_rec.incompatibility_grp_code;
1801: END IF;
1802:
1803: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1804: l_MODIFIERS_rec.list_line_no := p_old_MODIFIERS_rec.list_line_no;
1805: END IF;
1806:
1807: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1803: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1804: l_MODIFIERS_rec.list_line_no := p_old_MODIFIERS_rec.list_line_no;
1805: END IF;
1806:
1807: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1808: l_MODIFIERS_rec.product_precedence := p_old_MODIFIERS_rec.product_precedence;
1809: END IF;
1810:
1811: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1807: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1808: l_MODIFIERS_rec.product_precedence := p_old_MODIFIERS_rec.product_precedence;
1809: END IF;
1810:
1811: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1812: l_MODIFIERS_rec.expiration_period_start_date := p_old_MODIFIERS_rec.expiration_period_start_date;
1813: END IF;
1814:
1815: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1811: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1812: l_MODIFIERS_rec.expiration_period_start_date := p_old_MODIFIERS_rec.expiration_period_start_date;
1813: END IF;
1814:
1815: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1816: l_MODIFIERS_rec.number_expiration_periods := p_old_MODIFIERS_rec.number_expiration_periods;
1817: END IF;
1818:
1819: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1815: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1816: l_MODIFIERS_rec.number_expiration_periods := p_old_MODIFIERS_rec.number_expiration_periods;
1817: END IF;
1818:
1819: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1820: l_MODIFIERS_rec.expiration_period_uom := p_old_MODIFIERS_rec.expiration_period_uom;
1821: END IF;
1822:
1823: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1819: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1820: l_MODIFIERS_rec.expiration_period_uom := p_old_MODIFIERS_rec.expiration_period_uom;
1821: END IF;
1822:
1823: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1824: l_MODIFIERS_rec.expiration_date := p_old_MODIFIERS_rec.expiration_date;
1825: END IF;
1826:
1827: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1823: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1824: l_MODIFIERS_rec.expiration_date := p_old_MODIFIERS_rec.expiration_date;
1825: END IF;
1826:
1827: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1828: l_MODIFIERS_rec.estim_gl_value := p_old_MODIFIERS_rec.estim_gl_value;
1829: END IF;
1830:
1831: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1827: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1828: l_MODIFIERS_rec.estim_gl_value := p_old_MODIFIERS_rec.estim_gl_value;
1829: END IF;
1830:
1831: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1832: l_MODIFIERS_rec.benefit_price_list_line_id := p_old_MODIFIERS_rec.benefit_price_list_line_id;
1833: END IF;
1834:
1835: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1831: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1832: l_MODIFIERS_rec.benefit_price_list_line_id := p_old_MODIFIERS_rec.benefit_price_list_line_id;
1833: END IF;
1834:
1835: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1836: l_MODIFIERS_rec.recurring_flag := p_old_MODIFIERS_rec.recurring_flag;
1837: END IF;
1838: */
1839: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1835: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1836: l_MODIFIERS_rec.recurring_flag := p_old_MODIFIERS_rec.recurring_flag;
1837: END IF;
1838: */
1839: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1840: l_MODIFIERS_rec.benefit_limit := p_old_MODIFIERS_rec.benefit_limit;
1841: END IF;
1842:
1843: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1839: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1840: l_MODIFIERS_rec.benefit_limit := p_old_MODIFIERS_rec.benefit_limit;
1841: END IF;
1842:
1843: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1844: l_MODIFIERS_rec.charge_type_code := p_old_MODIFIERS_rec.charge_type_code;
1845: END IF;
1846:
1847: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1843: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1844: l_MODIFIERS_rec.charge_type_code := p_old_MODIFIERS_rec.charge_type_code;
1845: END IF;
1846:
1847: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1848: l_MODIFIERS_rec.charge_subtype_code := p_old_MODIFIERS_rec.charge_subtype_code;
1849: END IF;
1850:
1851: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1847: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1848: l_MODIFIERS_rec.charge_subtype_code := p_old_MODIFIERS_rec.charge_subtype_code;
1849: END IF;
1850:
1851: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1852: l_MODIFIERS_rec.benefit_qty := p_old_MODIFIERS_rec.benefit_qty;
1853: END IF;
1854:
1855: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1851: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1852: l_MODIFIERS_rec.benefit_qty := p_old_MODIFIERS_rec.benefit_qty;
1853: END IF;
1854:
1855: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1856: l_MODIFIERS_rec.benefit_uom_code := p_old_MODIFIERS_rec.benefit_uom_code;
1857: END IF;
1858:
1859: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1855: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1856: l_MODIFIERS_rec.benefit_uom_code := p_old_MODIFIERS_rec.benefit_uom_code;
1857: END IF;
1858:
1859: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1860: l_MODIFIERS_rec.accrual_conversion_rate := p_old_MODIFIERS_rec.accrual_conversion_rate;
1861: END IF;
1862:
1863: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1859: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1860: l_MODIFIERS_rec.accrual_conversion_rate := p_old_MODIFIERS_rec.accrual_conversion_rate;
1861: END IF;
1862:
1863: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1864: l_MODIFIERS_rec.proration_type_code := p_old_MODIFIERS_rec.proration_type_code;
1865: END IF;
1866:
1867: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1863: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1864: l_MODIFIERS_rec.proration_type_code := p_old_MODIFIERS_rec.proration_type_code;
1865: END IF;
1866:
1867: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1868: l_MODIFIERS_rec.include_on_returns_flag := p_old_MODIFIERS_rec.include_on_returns_flag;
1869: END IF;
1870:
1871: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1867: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1868: l_MODIFIERS_rec.include_on_returns_flag := p_old_MODIFIERS_rec.include_on_returns_flag;
1869: END IF;
1870:
1871: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1872: l_MODIFIERS_rec.from_rltd_modifier_id := p_old_MODIFIERS_rec.from_rltd_modifier_id;
1873: END IF;
1874:
1875: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1871: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1872: l_MODIFIERS_rec.from_rltd_modifier_id := p_old_MODIFIERS_rec.from_rltd_modifier_id;
1873: END IF;
1874:
1875: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1876: l_MODIFIERS_rec.to_rltd_modifier_id := p_old_MODIFIERS_rec.to_rltd_modifier_id;
1877: END IF;
1878:
1879: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1875: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1876: l_MODIFIERS_rec.to_rltd_modifier_id := p_old_MODIFIERS_rec.to_rltd_modifier_id;
1877: END IF;
1878:
1879: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1880: l_MODIFIERS_rec.rltd_modifier_grp_no := p_old_MODIFIERS_rec.rltd_modifier_grp_no;
1881: END IF;
1882:
1883: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1879: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1880: l_MODIFIERS_rec.rltd_modifier_grp_no := p_old_MODIFIERS_rec.rltd_modifier_grp_no;
1881: END IF;
1882:
1883: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1884: l_MODIFIERS_rec.rltd_modifier_grp_type := p_old_MODIFIERS_rec.rltd_modifier_grp_type;
1885: END IF;
1886:
1887: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1883: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1884: l_MODIFIERS_rec.rltd_modifier_grp_type := p_old_MODIFIERS_rec.rltd_modifier_grp_type;
1885: END IF;
1886:
1887: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1888: l_MODIFIERS_rec.rltd_modifier_id := p_old_MODIFIERS_rec.rltd_modifier_id;
1889: END IF;
1890:
1891: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1887: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1888: l_MODIFIERS_rec.rltd_modifier_id := p_old_MODIFIERS_rec.rltd_modifier_id;
1889: END IF;
1890:
1891: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1892: l_MODIFIERS_rec.qualification_ind := p_old_MODIFIERS_rec.qualification_ind;
1893: END IF;
1894:
1895: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1891: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1892: l_MODIFIERS_rec.qualification_ind := p_old_MODIFIERS_rec.qualification_ind;
1893: END IF;
1894:
1895: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1896: l_MODIFIERS_rec.accum_attribute := p_old_MODIFIERS_rec.accum_attribute;
1897: END IF;
1898:
1899: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1895: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1896: l_MODIFIERS_rec.accum_attribute := p_old_MODIFIERS_rec.accum_attribute;
1897: END IF;
1898:
1899: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1900: l_MODIFIERS_rec.net_amount_flag := p_old_MODIFIERS_rec.net_amount_flag;
1901: END IF;
1902:
1903: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1899: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1900: l_MODIFIERS_rec.net_amount_flag := p_old_MODIFIERS_rec.net_amount_flag;
1901: END IF;
1902:
1903: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1904: l_MODIFIERS_rec.continuous_price_break_flag := p_old_MODIFIERS_rec.continuous_price_break_flag;
1905: END IF;
1906: -- service project
1907: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
1903: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1904: l_MODIFIERS_rec.continuous_price_break_flag := p_old_MODIFIERS_rec.continuous_price_break_flag;
1905: END IF;
1906: -- service project
1907: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
1908: l_MODIFIERS_rec.service_duration := p_old_MODIFIERS_rec.service_duration;
1909: END IF;
1910: IF l_MODIFIERS_rec.service_period = FND_API.G_MISS_CHAR THEN
1911: l_MODIFIERS_rec.service_period := p_old_MODIFIERS_rec.service_period;
1906: -- service project
1907: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
1908: l_MODIFIERS_rec.service_duration := p_old_MODIFIERS_rec.service_duration;
1909: END IF;
1910: IF l_MODIFIERS_rec.service_period = FND_API.G_MISS_CHAR THEN
1911: l_MODIFIERS_rec.service_period := p_old_MODIFIERS_rec.service_period;
1912: END IF;
1913: -- service project
1914:
1928: BEGIN
1929:
1930: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUMLLB');
1931:
1932: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1933: l_MODIFIERS_rec.arithmetic_operator := NULL;
1934: END IF;
1935:
1936: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1932: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1933: l_MODIFIERS_rec.arithmetic_operator := NULL;
1934: END IF;
1935:
1936: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1937: l_MODIFIERS_rec.attribute1 := NULL;
1938: END IF;
1939:
1940: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1936: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1937: l_MODIFIERS_rec.attribute1 := NULL;
1938: END IF;
1939:
1940: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1941: l_MODIFIERS_rec.attribute10 := NULL;
1942: END IF;
1943:
1944: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1940: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1941: l_MODIFIERS_rec.attribute10 := NULL;
1942: END IF;
1943:
1944: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1945: l_MODIFIERS_rec.attribute11 := NULL;
1946: END IF;
1947:
1948: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1944: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1945: l_MODIFIERS_rec.attribute11 := NULL;
1946: END IF;
1947:
1948: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1949: l_MODIFIERS_rec.attribute12 := NULL;
1950: END IF;
1951:
1952: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1948: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1949: l_MODIFIERS_rec.attribute12 := NULL;
1950: END IF;
1951:
1952: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1953: l_MODIFIERS_rec.attribute13 := NULL;
1954: END IF;
1955:
1956: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1952: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1953: l_MODIFIERS_rec.attribute13 := NULL;
1954: END IF;
1955:
1956: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1957: l_MODIFIERS_rec.attribute14 := NULL;
1958: END IF;
1959:
1960: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1956: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1957: l_MODIFIERS_rec.attribute14 := NULL;
1958: END IF;
1959:
1960: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1961: l_MODIFIERS_rec.attribute15 := NULL;
1962: END IF;
1963:
1964: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1960: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1961: l_MODIFIERS_rec.attribute15 := NULL;
1962: END IF;
1963:
1964: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1965: l_MODIFIERS_rec.attribute2 := NULL;
1966: END IF;
1967:
1968: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1964: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1965: l_MODIFIERS_rec.attribute2 := NULL;
1966: END IF;
1967:
1968: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1969: l_MODIFIERS_rec.attribute3 := NULL;
1970: END IF;
1971:
1972: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1968: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1969: l_MODIFIERS_rec.attribute3 := NULL;
1970: END IF;
1971:
1972: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1973: l_MODIFIERS_rec.attribute4 := NULL;
1974: END IF;
1975:
1976: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1972: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1973: l_MODIFIERS_rec.attribute4 := NULL;
1974: END IF;
1975:
1976: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1977: l_MODIFIERS_rec.attribute5 := NULL;
1978: END IF;
1979:
1980: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1976: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1977: l_MODIFIERS_rec.attribute5 := NULL;
1978: END IF;
1979:
1980: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1981: l_MODIFIERS_rec.attribute6 := NULL;
1982: END IF;
1983:
1984: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1980: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1981: l_MODIFIERS_rec.attribute6 := NULL;
1982: END IF;
1983:
1984: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1985: l_MODIFIERS_rec.attribute7 := NULL;
1986: END IF;
1987:
1988: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1984: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1985: l_MODIFIERS_rec.attribute7 := NULL;
1986: END IF;
1987:
1988: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1989: l_MODIFIERS_rec.attribute8 := NULL;
1990: END IF;
1991:
1992: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1988: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1989: l_MODIFIERS_rec.attribute8 := NULL;
1990: END IF;
1991:
1992: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1993: l_MODIFIERS_rec.attribute9 := NULL;
1994: END IF;
1995:
1996: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1992: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1993: l_MODIFIERS_rec.attribute9 := NULL;
1994: END IF;
1995:
1996: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1997: l_MODIFIERS_rec.automatic_flag := NULL;
1998: END IF;
1999:
2000: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1996: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1997: l_MODIFIERS_rec.automatic_flag := NULL;
1998: END IF;
1999:
2000: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
2001: l_MODIFIERS_rec.base_qty := NULL;
2002: END IF;
2003: */
2004: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2000: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
2001: l_MODIFIERS_rec.base_qty := NULL;
2002: END IF;
2003: */
2004: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2005: l_MODIFIERS_rec.pricing_phase_id := NULL;
2006: END IF;
2007:
2008: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
2004: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
2005: l_MODIFIERS_rec.pricing_phase_id := NULL;
2006: END IF;
2007:
2008: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
2009: l_MODIFIERS_rec.base_uom_code := NULL;
2010: END IF;
2011: */
2012: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
2008: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
2009: l_MODIFIERS_rec.base_uom_code := NULL;
2010: END IF;
2011: */
2012: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
2013: l_MODIFIERS_rec.comments := NULL;
2014: END IF;
2015:
2016: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
2012: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
2013: l_MODIFIERS_rec.comments := NULL;
2014: END IF;
2015:
2016: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
2017: l_MODIFIERS_rec.context := NULL;
2018: END IF;
2019:
2020: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
2016: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
2017: l_MODIFIERS_rec.context := NULL;
2018: END IF;
2019:
2020: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
2021: l_MODIFIERS_rec.created_by := NULL;
2022: END IF;
2023:
2024: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
2020: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
2021: l_MODIFIERS_rec.created_by := NULL;
2022: END IF;
2023:
2024: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
2025: l_MODIFIERS_rec.creation_date := NULL;
2026: END IF;
2027:
2028: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
2024: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
2025: l_MODIFIERS_rec.creation_date := NULL;
2026: END IF;
2027:
2028: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
2029: l_MODIFIERS_rec.effective_period_uom := NULL;
2030: END IF;
2031:
2032: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
2028: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
2029: l_MODIFIERS_rec.effective_period_uom := NULL;
2030: END IF;
2031:
2032: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
2033: l_MODIFIERS_rec.end_date_active := NULL;
2034: END IF;
2035:
2036: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
2032: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
2033: l_MODIFIERS_rec.end_date_active := NULL;
2034: END IF;
2035:
2036: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
2037: l_MODIFIERS_rec.estim_accrual_rate := NULL;
2038: END IF;
2039:
2040: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
2036: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
2037: l_MODIFIERS_rec.estim_accrual_rate := NULL;
2038: END IF;
2039:
2040: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
2041: l_MODIFIERS_rec.generate_using_formula_id := NULL;
2042: END IF;
2043:
2044: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
2040: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
2041: l_MODIFIERS_rec.generate_using_formula_id := NULL;
2042: END IF;
2043:
2044: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
2045: l_MODIFIERS_rec.inventory_item_id := NULL;
2046: END IF;
2047:
2048: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2044: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
2045: l_MODIFIERS_rec.inventory_item_id := NULL;
2046: END IF;
2047:
2048: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2049: l_MODIFIERS_rec.last_updated_by := NULL;
2050: END IF;
2051:
2052: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
2048: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2049: l_MODIFIERS_rec.last_updated_by := NULL;
2050: END IF;
2051:
2052: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
2053: l_MODIFIERS_rec.last_update_date := NULL;
2054: END IF;
2055:
2056: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
2052: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
2053: l_MODIFIERS_rec.last_update_date := NULL;
2054: END IF;
2055:
2056: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
2057: l_MODIFIERS_rec.last_update_login := NULL;
2058: END IF;
2059:
2060: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2056: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
2057: l_MODIFIERS_rec.last_update_login := NULL;
2058: END IF;
2059:
2060: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2061: l_MODIFIERS_rec.list_header_id := NULL;
2062: END IF;
2063:
2064: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2060: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
2061: l_MODIFIERS_rec.list_header_id := NULL;
2062: END IF;
2063:
2064: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2065: l_MODIFIERS_rec.list_line_id := NULL;
2066: END IF;
2067:
2068: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2064: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2065: l_MODIFIERS_rec.list_line_id := NULL;
2066: END IF;
2067:
2068: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2069: l_MODIFIERS_rec.list_line_type_code := NULL;
2070: END IF;
2071:
2072: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2068: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2069: l_MODIFIERS_rec.list_line_type_code := NULL;
2070: END IF;
2071:
2072: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2073: l_MODIFIERS_rec.list_price := NULL;
2074: END IF;
2075:
2076: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2072: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2073: l_MODIFIERS_rec.list_price := NULL;
2074: END IF;
2075:
2076: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2077: l_MODIFIERS_rec.modifier_level_code := NULL;
2078: END IF;
2079:
2080: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2076: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2077: l_MODIFIERS_rec.modifier_level_code := NULL;
2078: END IF;
2079:
2080: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2081: l_MODIFIERS_rec.number_effective_periods := NULL;
2082: END IF;
2083:
2084: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2080: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2081: l_MODIFIERS_rec.number_effective_periods := NULL;
2082: END IF;
2083:
2084: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2085: l_MODIFIERS_rec.operand := NULL;
2086: END IF;
2087:
2088: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2084: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2085: l_MODIFIERS_rec.operand := NULL;
2086: END IF;
2087:
2088: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2089: l_MODIFIERS_rec.organization_id := NULL;
2090: END IF;
2091:
2092: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2088: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2089: l_MODIFIERS_rec.organization_id := NULL;
2090: END IF;
2091:
2092: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2093: l_MODIFIERS_rec.override_flag := NULL;
2094: END IF;
2095:
2096: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2092: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2093: l_MODIFIERS_rec.override_flag := NULL;
2094: END IF;
2095:
2096: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2097: l_MODIFIERS_rec.percent_price := NULL;
2098: END IF;
2099:
2100: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2096: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2097: l_MODIFIERS_rec.percent_price := NULL;
2098: END IF;
2099:
2100: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2101: l_MODIFIERS_rec.price_break_type_code := NULL;
2102: END IF;
2103:
2104: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2100: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2101: l_MODIFIERS_rec.price_break_type_code := NULL;
2102: END IF;
2103:
2104: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2105: l_MODIFIERS_rec.price_by_formula_id := NULL;
2106: END IF;
2107:
2108: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2104: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2105: l_MODIFIERS_rec.price_by_formula_id := NULL;
2106: END IF;
2107:
2108: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2109: l_MODIFIERS_rec.primary_uom_flag := NULL;
2110: END IF;
2111:
2112: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2108: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2109: l_MODIFIERS_rec.primary_uom_flag := NULL;
2110: END IF;
2111:
2112: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2113: l_MODIFIERS_rec.print_on_invoice_flag := NULL;
2114: END IF;
2115:
2116: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2112: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2113: l_MODIFIERS_rec.print_on_invoice_flag := NULL;
2114: END IF;
2115:
2116: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2117: l_MODIFIERS_rec.program_application_id := NULL;
2118: END IF;
2119:
2120: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2116: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2117: l_MODIFIERS_rec.program_application_id := NULL;
2118: END IF;
2119:
2120: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2121: l_MODIFIERS_rec.program_id := NULL;
2122: END IF;
2123:
2124: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2120: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2121: l_MODIFIERS_rec.program_id := NULL;
2122: END IF;
2123:
2124: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2125: l_MODIFIERS_rec.program_update_date := NULL;
2126: END IF;
2127:
2128: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2124: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2125: l_MODIFIERS_rec.program_update_date := NULL;
2126: END IF;
2127:
2128: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2129: l_MODIFIERS_rec.rebate_trxn_type_code := NULL;
2130: END IF;
2131:
2132: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2128: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2129: l_MODIFIERS_rec.rebate_trxn_type_code := NULL;
2130: END IF;
2131:
2132: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2133: l_MODIFIERS_rec.related_item_id := NULL;
2134: END IF;
2135:
2136: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2132: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2133: l_MODIFIERS_rec.related_item_id := NULL;
2134: END IF;
2135:
2136: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2137: l_MODIFIERS_rec.relationship_type_id := NULL;
2138: END IF;
2139:
2140: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2136: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2137: l_MODIFIERS_rec.relationship_type_id := NULL;
2138: END IF;
2139:
2140: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2141: l_MODIFIERS_rec.reprice_flag := NULL;
2142: END IF;
2143:
2144: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2140: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2141: l_MODIFIERS_rec.reprice_flag := NULL;
2142: END IF;
2143:
2144: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2145: l_MODIFIERS_rec.request_id := NULL;
2146: END IF;
2147:
2148: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2144: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2145: l_MODIFIERS_rec.request_id := NULL;
2146: END IF;
2147:
2148: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2149: l_MODIFIERS_rec.revision := NULL;
2150: END IF;
2151:
2152: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2148: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2149: l_MODIFIERS_rec.revision := NULL;
2150: END IF;
2151:
2152: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2153: l_MODIFIERS_rec.revision_date := NULL;
2154: END IF;
2155:
2156: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2152: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2153: l_MODIFIERS_rec.revision_date := NULL;
2154: END IF;
2155:
2156: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2157: l_MODIFIERS_rec.revision_reason_code := NULL;
2158: END IF;
2159:
2160: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2156: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2157: l_MODIFIERS_rec.revision_reason_code := NULL;
2158: END IF;
2159:
2160: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2161: l_MODIFIERS_rec.start_date_active := NULL;
2162: END IF;
2163:
2164: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2160: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2161: l_MODIFIERS_rec.start_date_active := NULL;
2162: END IF;
2163:
2164: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2165: l_MODIFIERS_rec.substitution_attribute := NULL;
2166: END IF;
2167:
2168: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2164: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2165: l_MODIFIERS_rec.substitution_attribute := NULL;
2166: END IF;
2167:
2168: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2169: l_MODIFIERS_rec.substitution_context := NULL;
2170: END IF;
2171:
2172: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2168: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2169: l_MODIFIERS_rec.substitution_context := NULL;
2170: END IF;
2171:
2172: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2173: l_MODIFIERS_rec.substitution_value := NULL;
2174: END IF;
2175:
2176: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2172: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2173: l_MODIFIERS_rec.substitution_value := NULL;
2174: END IF;
2175:
2176: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2177: l_MODIFIERS_rec.accrual_flag := NULL;
2178: END IF;
2179:
2180: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2176: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2177: l_MODIFIERS_rec.accrual_flag := NULL;
2178: END IF;
2179:
2180: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2181: l_MODIFIERS_rec.pricing_group_sequence := NULL;
2182: END IF;
2183:
2184: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2180: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2181: l_MODIFIERS_rec.pricing_group_sequence := NULL;
2182: END IF;
2183:
2184: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2185: l_MODIFIERS_rec.incompatibility_grp_code := NULL;
2186: END IF;
2187:
2188: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2184: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2185: l_MODIFIERS_rec.incompatibility_grp_code := NULL;
2186: END IF;
2187:
2188: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2189: l_MODIFIERS_rec.list_line_no := NULL;
2190: END IF;
2191:
2192: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2188: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2189: l_MODIFIERS_rec.list_line_no := NULL;
2190: END IF;
2191:
2192: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2193: l_MODIFIERS_rec.product_precedence := NULL;
2194: END IF;
2195:
2196: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2192: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2193: l_MODIFIERS_rec.product_precedence := NULL;
2194: END IF;
2195:
2196: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2197: l_MODIFIERS_rec.expiration_period_start_date := NULL;
2198: END IF;
2199:
2200: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2196: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2197: l_MODIFIERS_rec.expiration_period_start_date := NULL;
2198: END IF;
2199:
2200: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2201: l_MODIFIERS_rec.number_expiration_periods := NULL;
2202: END IF;
2203:
2204: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2200: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2201: l_MODIFIERS_rec.number_expiration_periods := NULL;
2202: END IF;
2203:
2204: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2205: l_MODIFIERS_rec.expiration_period_uom := NULL;
2206: END IF;
2207:
2208: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2204: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2205: l_MODIFIERS_rec.expiration_period_uom := NULL;
2206: END IF;
2207:
2208: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2209: l_MODIFIERS_rec.expiration_date := NULL;
2210: END IF;
2211:
2212: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2208: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2209: l_MODIFIERS_rec.expiration_date := NULL;
2210: END IF;
2211:
2212: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2213: l_MODIFIERS_rec.estim_gl_value := NULL;
2214: END IF;
2215:
2216: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2212: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2213: l_MODIFIERS_rec.estim_gl_value := NULL;
2214: END IF;
2215:
2216: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2217: l_MODIFIERS_rec.benefit_price_list_line_id := NULL;
2218: END IF;
2219:
2220: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2216: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2217: l_MODIFIERS_rec.benefit_price_list_line_id := NULL;
2218: END IF;
2219:
2220: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2221: l_MODIFIERS_rec.recurring_flag := NULL;
2222: END IF;
2223: */
2224: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2220: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2221: l_MODIFIERS_rec.recurring_flag := NULL;
2222: END IF;
2223: */
2224: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2225: l_MODIFIERS_rec.benefit_limit := NULL;
2226: END IF;
2227:
2228: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2224: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2225: l_MODIFIERS_rec.benefit_limit := NULL;
2226: END IF;
2227:
2228: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2229: l_MODIFIERS_rec.charge_type_code := NULL;
2230: END IF;
2231:
2232: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2228: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2229: l_MODIFIERS_rec.charge_type_code := NULL;
2230: END IF;
2231:
2232: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2233: l_MODIFIERS_rec.charge_subtype_code := NULL;
2234: END IF;
2235:
2236: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2232: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2233: l_MODIFIERS_rec.charge_subtype_code := NULL;
2234: END IF;
2235:
2236: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2237: l_MODIFIERS_rec.benefit_qty := NULL;
2238: END IF;
2239:
2240: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2236: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2237: l_MODIFIERS_rec.benefit_qty := NULL;
2238: END IF;
2239:
2240: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2241: l_MODIFIERS_rec.benefit_uom_code := NULL;
2242: END IF;
2243:
2244: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2240: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2241: l_MODIFIERS_rec.benefit_uom_code := NULL;
2242: END IF;
2243:
2244: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2245: l_MODIFIERS_rec.accrual_conversion_rate := NULL;
2246: END IF;
2247:
2248: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2244: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2245: l_MODIFIERS_rec.accrual_conversion_rate := NULL;
2246: END IF;
2247:
2248: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2249: l_MODIFIERS_rec.proration_type_code := NULL;
2250: END IF;
2251:
2252: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2248: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2249: l_MODIFIERS_rec.proration_type_code := NULL;
2250: END IF;
2251:
2252: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2253: l_MODIFIERS_rec.include_on_returns_flag := NULL;
2254: END IF;
2255:
2256: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2252: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2253: l_MODIFIERS_rec.include_on_returns_flag := NULL;
2254: END IF;
2255:
2256: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2257: l_MODIFIERS_rec.from_rltd_modifier_id := NULL;
2258: END IF;
2259:
2260: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2256: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2257: l_MODIFIERS_rec.from_rltd_modifier_id := NULL;
2258: END IF;
2259:
2260: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2261: l_MODIFIERS_rec.to_rltd_modifier_id := NULL;
2262: END IF;
2263:
2264: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2260: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2261: l_MODIFIERS_rec.to_rltd_modifier_id := NULL;
2262: END IF;
2263:
2264: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2265: l_MODIFIERS_rec.rltd_modifier_grp_no := NULL;
2266: END IF;
2267:
2268: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2264: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2265: l_MODIFIERS_rec.rltd_modifier_grp_no := NULL;
2266: END IF;
2267:
2268: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2269: l_MODIFIERS_rec.rltd_modifier_grp_type := NULL;
2270: END IF;
2271:
2272: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2268: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2269: l_MODIFIERS_rec.rltd_modifier_grp_type := NULL;
2270: END IF;
2271:
2272: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2273: l_MODIFIERS_rec.rltd_modifier_id := NULL;
2274: END IF;
2275:
2276: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2272: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2273: l_MODIFIERS_rec.rltd_modifier_id := NULL;
2274: END IF;
2275:
2276: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2277: l_MODIFIERS_rec.qualification_ind := NULL;
2278: END IF;
2279:
2280: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2276: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2277: l_MODIFIERS_rec.qualification_ind := NULL;
2278: END IF;
2279:
2280: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2281: l_MODIFIERS_rec.accum_attribute := NULL;
2282: END IF;
2283:
2284: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
2280: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2281: l_MODIFIERS_rec.accum_attribute := NULL;
2282: END IF;
2283:
2284: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
2285: l_MODIFIERS_rec.continuous_price_break_flag := NULL;
2286: END IF;
2287: -- service project
2288: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
2284: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
2285: l_MODIFIERS_rec.continuous_price_break_flag := NULL;
2286: END IF;
2287: -- service project
2288: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
2289: l_MODIFIERS_rec.service_duration := NULL;
2290: END IF;
2291: IF l_MODIFIERS_rec.service_period = FND_API.G_MISS_CHAR THEN
2292: l_MODIFIERS_rec.service_period := NULL;
2287: -- service project
2288: IF l_MODIFIERS_rec.service_duration = FND_API.G_MISS_NUM THEN
2289: l_MODIFIERS_rec.service_duration := NULL;
2290: END IF;
2291: IF l_MODIFIERS_rec.service_period = FND_API.G_MISS_CHAR THEN
2292: l_MODIFIERS_rec.service_period := NULL;
2293: END IF;
2294: -- service project
2295:
2436: , 'Update_Child_Lines'
2437: );
2438: END IF;
2439:
2440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2441: oe_debug_pub.add('exp update child lines');
2442:
2443: END UPDATE_CHILD_LINES;
2444:
2463: BEGIN
2464:
2465: oe_debug_pub.add('BEGIN Update_Row in QPXUMLLB');
2466: IF (p_MODIFIERS_rec.accum_attribute IS NOT NULL AND
2467: p_MODIFIERS_rec.accum_attribute <> FND_API.G_MISS_CHAR) THEN
2468: v_accum_context := 'VOLUME';
2469:
2470: BEGIN
2471: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2636: WHEN DUP_VAL_ON_INDEX THEN
2637:
2638: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2639: OE_MSG_PUB.Add;
2640: RAISE FND_API.G_EXC_ERROR;
2641:
2642: WHEN OTHERS THEN
2643:
2644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2648: , 'Update_Row'
2649: );
2650: END IF;
2651:
2652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2653:
2654: END Update_Row;
2655:
2656: -- Procedure Insert_Row
2671:
2672: oe_debug_pub.add('BEGIN Insert_Row in QPXUMLLB'||p_MODIFIERS_rec.list_line_type_code);
2673:
2674: IF (p_MODIFIERS_rec.accum_attribute IS NOT NULL AND
2675: p_MODIFIERS_rec.accum_attribute <> FND_API.G_MISS_CHAR) THEN
2676: v_accum_context := 'VOLUME';
2677:
2678: BEGIN
2679: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2922: END IF;
2923:
2924: oe_debug_pub.add('UMLLB l_ret_sts create_gsa_qual '||l_return_status);
2925: /*added this code to raise exception if qualifier does not get created-spgopal*/
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2928: OE_MSG_PUB.Add;
2929: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: RAISE NO_DATA_FOUND;
2925: /*added this code to raise exception if qualifier does not get created-spgopal*/
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2928: OE_MSG_PUB.Add;
2929: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: RAISE NO_DATA_FOUND;
2931: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2932: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2933: OE_MSG_PUB.Add;
2927: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2928: OE_MSG_PUB.Add;
2929: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: RAISE NO_DATA_FOUND;
2931: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2932: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2933: OE_MSG_PUB.Add;
2934: --RAISE FND_API.G_EXC_ERROR;
2935: RAISE NO_DATA_FOUND;
2930: RAISE NO_DATA_FOUND;
2931: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2932: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2933: OE_MSG_PUB.Add;
2934: --RAISE FND_API.G_EXC_ERROR;
2935: RAISE NO_DATA_FOUND;
2936: END IF;
2937:
2938: /* Accumulation Start */
2961: WHEN DUP_VAL_ON_INDEX THEN
2962:
2963: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2964: OE_MSG_PUB.Add;
2965: RAISE FND_API.G_EXC_ERROR;
2966:
2967: WHEN OTHERS THEN
2968:
2969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2973: , 'Insert_Row'
2974: );
2975: END IF;
2976:
2977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2978:
2979: END Insert_Row;
2980:
2981: -- Procedure Delete_Row
3014: , 'Delete_Row'
3015: );
3016: END IF;
3017:
3018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3019:
3020: END Delete_Row;
3021:
3022: -- Function Query_Row
3038: --
3039:
3040: FUNCTION Query_Rows
3041: ( p_list_line_id IN NUMBER :=
3042: FND_API.G_MISS_NUM
3043: , p_list_header_id IN NUMBER :=
3044: FND_API.G_MISS_NUM
3045: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
3046: IS
3040: FUNCTION Query_Rows
3041: ( p_list_line_id IN NUMBER :=
3042: FND_API.G_MISS_NUM
3043: , p_list_header_id IN NUMBER :=
3044: FND_API.G_MISS_NUM
3045: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
3046: IS
3047: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
3048: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
3237:
3238: IF
3239: (p_list_line_id IS NOT NULL
3240: AND
3241: p_list_line_id <> FND_API.G_MISS_NUM)
3242: AND
3243: (p_list_header_id IS NOT NULL
3244: AND
3245: p_list_header_id <> FND_API.G_MISS_NUM)
3241: p_list_line_id <> FND_API.G_MISS_NUM)
3242: AND
3243: (p_list_header_id IS NOT NULL
3244: AND
3245: p_list_header_id <> FND_API.G_MISS_NUM)
3246: THEN
3247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3248: THEN
3249: OE_MSG_PUB.Add_Exc_Msg
3252: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
3253: );
3254: END IF;
3255:
3256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3257:
3258: END IF;
3259:
3260:
3388:
3389: IF
3390: (p_list_line_id IS NOT NULL
3391: AND
3392: p_list_line_id <> FND_API.G_MISS_NUM)
3393: AND
3394: (l_MODIFIERS_tbl.COUNT = 0)
3395: THEN
3396: RAISE NO_DATA_FOUND;
3404: RETURN l_MODIFIERS_tbl;
3405:
3406: EXCEPTION
3407:
3408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3409:
3410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3411:
3412: WHEN OTHERS THEN
3406: EXCEPTION
3407:
3408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3409:
3410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3411:
3412: WHEN OTHERS THEN
3413:
3414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3418: , 'Query_Rows'
3419: );
3420: END IF;
3421:
3422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3423:
3424: END Query_Rows;
3425:
3426: -- Procedure lock_Row
3876: x_MODIFIERS_rec := l_MODIFIERS_rec;
3877:
3878: -- Set return status
3879:
3880: x_return_status := FND_API.G_RET_STS_SUCCESS;
3881: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3882:
3883: ELSE
3884:
3877:
3878: -- Set return status
3879:
3880: x_return_status := FND_API.G_RET_STS_SUCCESS;
3881: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3882:
3883: ELSE
3884:
3885: -- smbalara Fix for Bug 6340093 - messages added for debugging oe_lock_row issue in the modifier lines block
3966: oe_debug_pub.add('p_MODIFIERS_rec.accum_attribute :'||p_MODIFIERS_rec.accum_attribute||':'||'l_MODIFIERS_rec.accum_attribute:'||l_MODIFIERS_rec.accum_attribute||':');
3967:
3968: -- Row has changed by another user.
3969:
3970: x_return_status := FND_API.G_RET_STS_ERROR;
3971: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3972:
3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3974: THEN
3967:
3968: -- Row has changed by another user.
3969:
3970: x_return_status := FND_API.G_RET_STS_ERROR;
3971: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3972:
3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3974: THEN
3975:
3985: EXCEPTION
3986:
3987: WHEN NO_DATA_FOUND THEN
3988:
3989: x_return_status := FND_API.G_RET_STS_ERROR;
3990: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3991:
3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3993: THEN
3986:
3987: WHEN NO_DATA_FOUND THEN
3988:
3989: x_return_status := FND_API.G_RET_STS_ERROR;
3990: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3991:
3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3993: THEN
3994:
3997:
3998: END IF;
3999: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4000:
4001: x_return_status := FND_API.G_RET_STS_ERROR;
4002: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4003:
4004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4005: THEN
3998: END IF;
3999: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4000:
4001: x_return_status := FND_API.G_RET_STS_ERROR;
4002: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4003:
4004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4005: THEN
4006:
4009:
4010: END IF;
4011: WHEN OTHERS THEN
4012:
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015:
4016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4017: THEN
4010: END IF;
4011: WHEN OTHERS THEN
4012:
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015:
4016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4017: THEN
4018: OE_MSG_PUB.Add_Exc_Msg
4036:
4037: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
4038:
4039: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
4040: p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
4041: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
4042: p_old_MODIFIERS_rec.automatic_flag)
4043: THEN
4044: l_MODIFIERS_val_rec.automatic := QP_Id_To_Value.Automatic
4046: );
4047: END IF;
4048:
4049: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
4050: p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
4051: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
4052: p_old_MODIFIERS_rec.base_uom_code)
4053: THEN
4054: l_MODIFIERS_val_rec.base_uom := QP_Id_To_Value.Base_Uom
4056: );
4057: END IF;
4058: */
4059: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND
4060: p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
4061: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
4062: p_old_MODIFIERS_rec.generate_using_formula_id)
4063: THEN
4064: l_MODIFIERS_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
4066: );
4067: END IF;
4068:
4069: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND
4070: p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
4071: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
4072: p_old_MODIFIERS_rec.inventory_item_id)
4073: THEN
4074: l_MODIFIERS_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
4076: );
4077: END IF;
4078:
4079: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
4080: p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
4081: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,
4082: p_old_MODIFIERS_rec.list_header_id)
4083: THEN
4084: l_MODIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
4086: );
4087: END IF;
4088:
4089: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND
4090: p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
4091: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
4092: p_old_MODIFIERS_rec.list_line_id)
4093: THEN
4094: l_MODIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
4096: );
4097: END IF;
4098:
4099: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND
4100: p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
4101: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
4102: p_old_MODIFIERS_rec.list_line_type_code)
4103: THEN
4104: l_MODIFIERS_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
4106: );
4107: END IF;
4108:
4109: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND
4110: p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
4111: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
4112: p_old_MODIFIERS_rec.modifier_level_code)
4113: THEN
4114: l_MODIFIERS_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
4116: );
4117: END IF;
4118:
4119: IF p_MODIFIERS_rec.organization_id IS NOT NULL AND
4120: p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM AND
4121: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
4122: p_old_MODIFIERS_rec.organization_id)
4123: THEN
4124: l_MODIFIERS_val_rec.organization := QP_Id_To_Value.Organization
4126: );
4127: END IF;
4128:
4129: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
4130: p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR AND
4131: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
4132: p_old_MODIFIERS_rec.override_flag)
4133: THEN
4134: l_MODIFIERS_val_rec.override := QP_Id_To_Value.Override
4136: );
4137: END IF;
4138:
4139: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND
4140: p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
4141: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
4142: p_old_MODIFIERS_rec.price_break_type_code)
4143: THEN
4144: l_MODIFIERS_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
4146: );
4147: END IF;
4148:
4149: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND
4150: p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
4151: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
4152: p_old_MODIFIERS_rec.price_by_formula_id)
4153: THEN
4154: l_MODIFIERS_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
4156: );
4157: END IF;
4158:
4159: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND
4160: p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
4161: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,
4162: p_old_MODIFIERS_rec.primary_uom_flag)
4163: THEN
4164: l_MODIFIERS_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
4166: );
4167: END IF;
4168:
4169: IF p_MODIFIERS_rec.print_on_invoice_flag IS NOT NULL AND
4170: p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
4171: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
4172: p_old_MODIFIERS_rec.print_on_invoice_flag)
4173: THEN
4174: l_MODIFIERS_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
4176: );
4177: END IF;
4178:
4179: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND
4180: p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
4181: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
4182: p_old_MODIFIERS_rec.rebate_trxn_type_code)
4183: THEN
4184: l_MODIFIERS_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
4186: );
4187: END IF;
4188:
4189: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND
4190: p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM AND
4191: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
4192: p_old_MODIFIERS_rec.related_item_id)
4193: THEN
4194: l_MODIFIERS_val_rec.related_item := QP_Id_To_Value.Related_Item
4196: );
4197: END IF;
4198:
4199: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND
4200: p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
4201: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
4202: p_old_MODIFIERS_rec.relationship_type_id)
4203: THEN
4204: l_MODIFIERS_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
4206: );
4207: END IF;
4208:
4209: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND
4210: p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
4211: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
4212: p_old_MODIFIERS_rec.reprice_flag)
4213: THEN
4214: l_MODIFIERS_val_rec.reprice := QP_Id_To_Value.Reprice
4216: );
4217: END IF;
4218:
4219: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND
4220: p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
4221: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
4222: p_old_MODIFIERS_rec.revision_reason_code)
4223: THEN
4224: l_MODIFIERS_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
4245: oe_debug_pub.add('BEGIN Get_Ids in QPXUMLLB');
4246:
4247: -- initialize return_status.
4248:
4249: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4250:
4251: -- initialize l_MODIFIERS_rec.
4252:
4253: l_MODIFIERS_rec := p_MODIFIERS_rec;
4251: -- initialize l_MODIFIERS_rec.
4252:
4253: l_MODIFIERS_rec := p_MODIFIERS_rec;
4254:
4255: IF p_MODIFIERS_val_rec.automatic <> FND_API.G_MISS_CHAR
4256: THEN
4257:
4258: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4259:
4254:
4255: IF p_MODIFIERS_val_rec.automatic <> FND_API.G_MISS_CHAR
4256: THEN
4257:
4258: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4259:
4260: l_MODIFIERS_rec.automatic_flag := p_MODIFIERS_rec.automatic_flag;
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4273: l_MODIFIERS_rec.automatic_flag := QP_Value_To_Id.automatic
4274: ( p_automatic => p_MODIFIERS_val_rec.automatic
4275: );
4276:
4277: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
4278: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4279: END IF;
4280:
4281: END IF;
4274: ( p_automatic => p_MODIFIERS_val_rec.automatic
4275: );
4276:
4277: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
4278: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4279: END IF;
4280:
4281: END IF;
4282:
4281: END IF;
4282:
4283: END IF;
4284:
4285: /* IF p_MODIFIERS_val_rec.base_uom <> FND_API.G_MISS_CHAR
4286: THEN
4287:
4288: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4289:
4284:
4285: /* IF p_MODIFIERS_val_rec.base_uom <> FND_API.G_MISS_CHAR
4286: THEN
4287:
4288: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4289:
4290: l_MODIFIERS_rec.base_uom_code := p_MODIFIERS_rec.base_uom_code;
4291:
4292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4303: l_MODIFIERS_rec.base_uom_code := QP_Value_To_Id.base_uom
4304: ( p_base_uom => p_MODIFIERS_val_rec.base_uom
4305: );
4306:
4307: IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
4308: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4309: END IF;
4310:
4311: END IF;
4304: ( p_base_uom => p_MODIFIERS_val_rec.base_uom
4305: );
4306:
4307: IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
4308: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4309: END IF;
4310:
4311: END IF;
4312:
4311: END IF;
4312:
4313: END IF;
4314: */
4315: IF p_MODIFIERS_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
4316: THEN
4317:
4318: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4319:
4314: */
4315: IF p_MODIFIERS_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
4316: THEN
4317:
4318: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4319:
4320: l_MODIFIERS_rec.generate_using_formula_id := p_MODIFIERS_rec.generate_using_formula_id;
4321:
4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4333: l_MODIFIERS_rec.generate_using_formula_id := QP_Value_To_Id.generate_using_formula
4334: ( p_generate_using_formula => p_MODIFIERS_val_rec.generate_using_formula
4335: );
4336:
4337: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
4338: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4339: END IF;
4340:
4341: END IF;
4334: ( p_generate_using_formula => p_MODIFIERS_val_rec.generate_using_formula
4335: );
4336:
4337: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
4338: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4339: END IF;
4340:
4341: END IF;
4342:
4341: END IF;
4342:
4343: END IF;
4344:
4345: IF p_MODIFIERS_val_rec.inventory_item <> FND_API.G_MISS_CHAR
4346: THEN
4347:
4348: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4349:
4344:
4345: IF p_MODIFIERS_val_rec.inventory_item <> FND_API.G_MISS_CHAR
4346: THEN
4347:
4348: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4349:
4350: l_MODIFIERS_rec.inventory_item_id := p_MODIFIERS_rec.inventory_item_id;
4351:
4352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4363: l_MODIFIERS_rec.inventory_item_id := QP_Value_To_Id.inventory_item
4364: ( p_inventory_item => p_MODIFIERS_val_rec.inventory_item
4365: );
4366:
4367: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
4368: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4369: END IF;
4370:
4371: END IF;
4364: ( p_inventory_item => p_MODIFIERS_val_rec.inventory_item
4365: );
4366:
4367: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
4368: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4369: END IF;
4370:
4371: END IF;
4372:
4371: END IF;
4372:
4373: END IF;
4374:
4375: IF p_MODIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
4376: THEN
4377:
4378: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4379:
4374:
4375: IF p_MODIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
4376: THEN
4377:
4378: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4379:
4380: l_MODIFIERS_rec.list_header_id := p_MODIFIERS_rec.list_header_id;
4381:
4382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4393: l_MODIFIERS_rec.list_header_id := QP_Value_To_Id.list_header
4394: ( p_list_header => p_MODIFIERS_val_rec.list_header
4395: );
4396:
4397: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
4398: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4399: END IF;
4400:
4401: END IF;
4394: ( p_list_header => p_MODIFIERS_val_rec.list_header
4395: );
4396:
4397: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
4398: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4399: END IF;
4400:
4401: END IF;
4402:
4401: END IF;
4402:
4403: END IF;
4404:
4405: IF p_MODIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
4406: THEN
4407:
4408: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4409:
4404:
4405: IF p_MODIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
4406: THEN
4407:
4408: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4409:
4410: l_MODIFIERS_rec.list_line_id := p_MODIFIERS_rec.list_line_id;
4411:
4412: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4423: l_MODIFIERS_rec.list_line_id := QP_Value_To_Id.list_line
4424: ( p_list_line => p_MODIFIERS_val_rec.list_line
4425: );
4426:
4427: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
4428: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4429: END IF;
4430:
4431: END IF;
4424: ( p_list_line => p_MODIFIERS_val_rec.list_line
4425: );
4426:
4427: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
4428: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4429: END IF;
4430:
4431: END IF;
4432:
4431: END IF;
4432:
4433: END IF;
4434:
4435: IF p_MODIFIERS_val_rec.list_line_type <> FND_API.G_MISS_CHAR
4436: THEN
4437:
4438: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4439:
4434:
4435: IF p_MODIFIERS_val_rec.list_line_type <> FND_API.G_MISS_CHAR
4436: THEN
4437:
4438: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4439:
4440: l_MODIFIERS_rec.list_line_type_code := p_MODIFIERS_rec.list_line_type_code;
4441:
4442: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4453: l_MODIFIERS_rec.list_line_type_code := QP_Value_To_Id.list_line_type
4454: ( p_list_line_type => p_MODIFIERS_val_rec.list_line_type
4455: );
4456:
4457: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
4458: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4459: END IF;
4460:
4461: END IF;
4454: ( p_list_line_type => p_MODIFIERS_val_rec.list_line_type
4455: );
4456:
4457: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
4458: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4459: END IF;
4460:
4461: END IF;
4462:
4461: END IF;
4462:
4463: END IF;
4464:
4465: IF p_MODIFIERS_val_rec.modifier_level <> FND_API.G_MISS_CHAR
4466: THEN
4467:
4468: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4469:
4464:
4465: IF p_MODIFIERS_val_rec.modifier_level <> FND_API.G_MISS_CHAR
4466: THEN
4467:
4468: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4469:
4470: l_MODIFIERS_rec.modifier_level_code := p_MODIFIERS_rec.modifier_level_code;
4471:
4472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4483: l_MODIFIERS_rec.modifier_level_code := QP_Value_To_Id.modifier_level
4484: ( p_modifier_level => p_MODIFIERS_val_rec.modifier_level
4485: );
4486:
4487: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
4488: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4489: END IF;
4490:
4491: END IF;
4484: ( p_modifier_level => p_MODIFIERS_val_rec.modifier_level
4485: );
4486:
4487: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
4488: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4489: END IF;
4490:
4491: END IF;
4492:
4491: END IF;
4492:
4493: END IF;
4494:
4495: IF p_MODIFIERS_val_rec.organization <> FND_API.G_MISS_CHAR
4496: THEN
4497:
4498: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4499:
4494:
4495: IF p_MODIFIERS_val_rec.organization <> FND_API.G_MISS_CHAR
4496: THEN
4497:
4498: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4499:
4500: l_MODIFIERS_rec.organization_id := p_MODIFIERS_rec.organization_id;
4501:
4502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4513: l_MODIFIERS_rec.organization_id := QP_Value_To_Id.organization
4514: ( p_organization => p_MODIFIERS_val_rec.organization
4515: );
4516:
4517: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
4518: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4519: END IF;
4520:
4521: END IF;
4514: ( p_organization => p_MODIFIERS_val_rec.organization
4515: );
4516:
4517: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
4518: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4519: END IF;
4520:
4521: END IF;
4522:
4521: END IF;
4522:
4523: END IF;
4524:
4525: IF p_MODIFIERS_val_rec.override <> FND_API.G_MISS_CHAR
4526: THEN
4527:
4528: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4529:
4524:
4525: IF p_MODIFIERS_val_rec.override <> FND_API.G_MISS_CHAR
4526: THEN
4527:
4528: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4529:
4530: l_MODIFIERS_rec.override_flag := p_MODIFIERS_rec.override_flag;
4531:
4532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4543: l_MODIFIERS_rec.override_flag := QP_Value_To_Id.override
4544: ( p_override => p_MODIFIERS_val_rec.override
4545: );
4546:
4547: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
4548: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4549: END IF;
4550:
4551: END IF;
4544: ( p_override => p_MODIFIERS_val_rec.override
4545: );
4546:
4547: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
4548: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4549: END IF;
4550:
4551: END IF;
4552:
4551: END IF;
4552:
4553: END IF;
4554:
4555: IF p_MODIFIERS_val_rec.price_break_type <> FND_API.G_MISS_CHAR
4556: THEN
4557:
4558: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4559:
4554:
4555: IF p_MODIFIERS_val_rec.price_break_type <> FND_API.G_MISS_CHAR
4556: THEN
4557:
4558: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4559:
4560: l_MODIFIERS_rec.price_break_type_code := p_MODIFIERS_rec.price_break_type_code;
4561:
4562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4573: l_MODIFIERS_rec.price_break_type_code := QP_Value_To_Id.price_break_type
4574: ( p_price_break_type => p_MODIFIERS_val_rec.price_break_type
4575: );
4576:
4577: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
4578: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4579: END IF;
4580:
4581: END IF;
4574: ( p_price_break_type => p_MODIFIERS_val_rec.price_break_type
4575: );
4576:
4577: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
4578: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4579: END IF;
4580:
4581: END IF;
4582:
4581: END IF;
4582:
4583: END IF;
4584:
4585: IF p_MODIFIERS_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
4586: THEN
4587:
4588: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4589:
4584:
4585: IF p_MODIFIERS_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
4586: THEN
4587:
4588: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4589:
4590: l_MODIFIERS_rec.price_by_formula_id := p_MODIFIERS_rec.price_by_formula_id;
4591:
4592: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4603: l_MODIFIERS_rec.price_by_formula_id := QP_Value_To_Id.price_by_formula
4604: ( p_price_by_formula => p_MODIFIERS_val_rec.price_by_formula
4605: );
4606:
4607: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
4608: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4609: END IF;
4610:
4611: END IF;
4604: ( p_price_by_formula => p_MODIFIERS_val_rec.price_by_formula
4605: );
4606:
4607: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
4608: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4609: END IF;
4610:
4611: END IF;
4612:
4611: END IF;
4612:
4613: END IF;
4614:
4615: IF p_MODIFIERS_val_rec.primary_uom <> FND_API.G_MISS_CHAR
4616: THEN
4617:
4618: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4619:
4614:
4615: IF p_MODIFIERS_val_rec.primary_uom <> FND_API.G_MISS_CHAR
4616: THEN
4617:
4618: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4619:
4620: l_MODIFIERS_rec.primary_uom_flag := p_MODIFIERS_rec.primary_uom_flag;
4621:
4622: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4633: l_MODIFIERS_rec.primary_uom_flag := QP_Value_To_Id.primary_uom
4634: ( p_primary_uom => p_MODIFIERS_val_rec.primary_uom
4635: );
4636:
4637: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
4638: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4639: END IF;
4640:
4641: END IF;
4634: ( p_primary_uom => p_MODIFIERS_val_rec.primary_uom
4635: );
4636:
4637: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
4638: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4639: END IF;
4640:
4641: END IF;
4642:
4642:
4643: END IF;
4644:
4645: --ER 11828647
4646: /*IF p_MODIFIERS_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
4647: THEN
4648:
4649: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4650:
4645: --ER 11828647
4646: /*IF p_MODIFIERS_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
4647: THEN
4648:
4649: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4650:
4651: l_MODIFIERS_rec.print_on_invoice_flag := p_MODIFIERS_rec.print_on_invoice_flag;
4652:
4653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4664: l_MODIFIERS_rec.print_on_invoice_flag := QP_Value_To_Id.print_on_invoice
4665: ( p_print_on_invoice => p_MODIFIERS_val_rec.print_on_invoice
4666: );
4667:
4668: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
4669: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4670: END IF;
4671:
4672: END IF;
4665: ( p_print_on_invoice => p_MODIFIERS_val_rec.print_on_invoice
4666: );
4667:
4668: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
4669: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4670: END IF;
4671:
4672: END IF;
4673:
4672: END IF;
4673:
4674: END IF;*/
4675:
4676: IF p_MODIFIERS_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
4677: THEN
4678:
4679: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4680:
4675:
4676: IF p_MODIFIERS_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
4677: THEN
4678:
4679: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4680:
4681: l_MODIFIERS_rec.rebate_trxn_type_code := p_MODIFIERS_rec.rebate_trxn_type_code;
4682:
4683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4694: l_MODIFIERS_rec.rebate_trxn_type_code := QP_Value_To_Id.rebate_transaction_type
4695: ( p_rebate_transaction_type => p_MODIFIERS_val_rec.rebate_transaction_type
4696: );
4697:
4698: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
4699: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4700: END IF;
4701:
4702: END IF;
4695: ( p_rebate_transaction_type => p_MODIFIERS_val_rec.rebate_transaction_type
4696: );
4697:
4698: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
4699: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4700: END IF;
4701:
4702: END IF;
4703:
4702: END IF;
4703:
4704: END IF;
4705:
4706: IF p_MODIFIERS_val_rec.related_item <> FND_API.G_MISS_CHAR
4707: THEN
4708:
4709: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4710:
4705:
4706: IF p_MODIFIERS_val_rec.related_item <> FND_API.G_MISS_CHAR
4707: THEN
4708:
4709: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4710:
4711: l_MODIFIERS_rec.related_item_id := p_MODIFIERS_rec.related_item_id;
4712:
4713: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4724: l_MODIFIERS_rec.related_item_id := QP_Value_To_Id.related_item
4725: ( p_related_item => p_MODIFIERS_val_rec.related_item
4726: );
4727:
4728: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
4729: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4730: END IF;
4731:
4732: END IF;
4725: ( p_related_item => p_MODIFIERS_val_rec.related_item
4726: );
4727:
4728: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
4729: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4730: END IF;
4731:
4732: END IF;
4733:
4732: END IF;
4733:
4734: END IF;
4735:
4736: IF p_MODIFIERS_val_rec.relationship_type <> FND_API.G_MISS_CHAR
4737: THEN
4738:
4739: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4740:
4735:
4736: IF p_MODIFIERS_val_rec.relationship_type <> FND_API.G_MISS_CHAR
4737: THEN
4738:
4739: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4740:
4741: l_MODIFIERS_rec.relationship_type_id := p_MODIFIERS_rec.relationship_type_id;
4742:
4743: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4754: l_MODIFIERS_rec.relationship_type_id := QP_Value_To_Id.relationship_type
4755: ( p_relationship_type => p_MODIFIERS_val_rec.relationship_type
4756: );
4757:
4758: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
4759: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4760: END IF;
4761:
4762: END IF;
4755: ( p_relationship_type => p_MODIFIERS_val_rec.relationship_type
4756: );
4757:
4758: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
4759: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4760: END IF;
4761:
4762: END IF;
4763:
4762: END IF;
4763:
4764: END IF;
4765:
4766: IF p_MODIFIERS_val_rec.reprice <> FND_API.G_MISS_CHAR
4767: THEN
4768:
4769: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4770:
4765:
4766: IF p_MODIFIERS_val_rec.reprice <> FND_API.G_MISS_CHAR
4767: THEN
4768:
4769: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4770:
4771: l_MODIFIERS_rec.reprice_flag := p_MODIFIERS_rec.reprice_flag;
4772:
4773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4784: l_MODIFIERS_rec.reprice_flag := QP_Value_To_Id.reprice
4785: ( p_reprice => p_MODIFIERS_val_rec.reprice
4786: );
4787:
4788: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
4789: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4790: END IF;
4791:
4792: END IF;
4785: ( p_reprice => p_MODIFIERS_val_rec.reprice
4786: );
4787:
4788: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
4789: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4790: END IF;
4791:
4792: END IF;
4793:
4792: END IF;
4793:
4794: END IF;
4795:
4796: IF p_MODIFIERS_val_rec.revision_reason <> FND_API.G_MISS_CHAR
4797: THEN
4798:
4799: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4800:
4795:
4796: IF p_MODIFIERS_val_rec.revision_reason <> FND_API.G_MISS_CHAR
4797: THEN
4798:
4799: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4800:
4801: l_MODIFIERS_rec.revision_reason_code := p_MODIFIERS_rec.revision_reason_code;
4802:
4803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4814: l_MODIFIERS_rec.revision_reason_code := QP_Value_To_Id.revision_reason
4815: ( p_revision_reason => p_MODIFIERS_val_rec.revision_reason
4816: );
4817:
4818: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
4819: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4820: END IF;
4821:
4822: END IF;
4815: ( p_revision_reason => p_MODIFIERS_val_rec.revision_reason
4816: );
4817:
4818: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
4819: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4820: END IF;
4821:
4822: END IF;
4823:
4977: x_return_status => l_return_status);
4978: END IF;
4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: RAISE;
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: RAISE;
4985: WHEN OTHERS THEN
4979:
4980: EXCEPTION
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: RAISE;
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: RAISE;
4985: WHEN OTHERS THEN
4986: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4987: THEN
4989: ( G_PKG_NAME
4990: , 'Pre_Write_Process'
4991: );
4992: END IF;
4993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4994: END Pre_Write_Process;
4995:
4996: ------------------------------fix for bug 3756625
4997: Procedure Log_Update_Phases_DL(p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type,