[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;
857: IS
858:
859: --added by svdeshmu
860:
861: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
862:
863:
864: -- end of additions by svdeshmu
865:
1146: , p_entity_id => p_MODIFIERS_rec.list_line_id
1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1148: , x_return_status => l_return_status
1149: );
1150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153: END IF;
1154: end;
1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1148: , x_return_status => l_return_status
1149: );
1150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153: END IF;
1154: end;
1155:
1488: BEGIN
1489:
1490: oe_debug_pub.add('BEGIN Complete_Record in QPXUMLLB');
1491:
1492: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1493: l_MODIFIERS_rec.arithmetic_operator := p_old_MODIFIERS_rec.arithmetic_operator;
1494: END IF;
1495:
1496: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1492: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1493: l_MODIFIERS_rec.arithmetic_operator := p_old_MODIFIERS_rec.arithmetic_operator;
1494: END IF;
1495:
1496: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1497: l_MODIFIERS_rec.attribute1 := p_old_MODIFIERS_rec.attribute1;
1498: END IF;
1499:
1500: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1496: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1497: l_MODIFIERS_rec.attribute1 := p_old_MODIFIERS_rec.attribute1;
1498: END IF;
1499:
1500: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1501: l_MODIFIERS_rec.attribute10 := p_old_MODIFIERS_rec.attribute10;
1502: END IF;
1503:
1504: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1500: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1501: l_MODIFIERS_rec.attribute10 := p_old_MODIFIERS_rec.attribute10;
1502: END IF;
1503:
1504: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1505: l_MODIFIERS_rec.attribute11 := p_old_MODIFIERS_rec.attribute11;
1506: END IF;
1507:
1508: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1504: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1505: l_MODIFIERS_rec.attribute11 := p_old_MODIFIERS_rec.attribute11;
1506: END IF;
1507:
1508: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1509: l_MODIFIERS_rec.attribute12 := p_old_MODIFIERS_rec.attribute12;
1510: END IF;
1511:
1512: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1508: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1509: l_MODIFIERS_rec.attribute12 := p_old_MODIFIERS_rec.attribute12;
1510: END IF;
1511:
1512: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1513: l_MODIFIERS_rec.attribute13 := p_old_MODIFIERS_rec.attribute13;
1514: END IF;
1515:
1516: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1512: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1513: l_MODIFIERS_rec.attribute13 := p_old_MODIFIERS_rec.attribute13;
1514: END IF;
1515:
1516: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1517: l_MODIFIERS_rec.attribute14 := p_old_MODIFIERS_rec.attribute14;
1518: END IF;
1519:
1520: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1516: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1517: l_MODIFIERS_rec.attribute14 := p_old_MODIFIERS_rec.attribute14;
1518: END IF;
1519:
1520: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1521: l_MODIFIERS_rec.attribute15 := p_old_MODIFIERS_rec.attribute15;
1522: END IF;
1523:
1524: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1520: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1521: l_MODIFIERS_rec.attribute15 := p_old_MODIFIERS_rec.attribute15;
1522: END IF;
1523:
1524: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1525: l_MODIFIERS_rec.attribute2 := p_old_MODIFIERS_rec.attribute2;
1526: END IF;
1527:
1528: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1524: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1525: l_MODIFIERS_rec.attribute2 := p_old_MODIFIERS_rec.attribute2;
1526: END IF;
1527:
1528: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1529: l_MODIFIERS_rec.attribute3 := p_old_MODIFIERS_rec.attribute3;
1530: END IF;
1531:
1532: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1528: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1529: l_MODIFIERS_rec.attribute3 := p_old_MODIFIERS_rec.attribute3;
1530: END IF;
1531:
1532: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1533: l_MODIFIERS_rec.attribute4 := p_old_MODIFIERS_rec.attribute4;
1534: END IF;
1535:
1536: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1532: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1533: l_MODIFIERS_rec.attribute4 := p_old_MODIFIERS_rec.attribute4;
1534: END IF;
1535:
1536: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1537: l_MODIFIERS_rec.attribute5 := p_old_MODIFIERS_rec.attribute5;
1538: END IF;
1539:
1540: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1536: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1537: l_MODIFIERS_rec.attribute5 := p_old_MODIFIERS_rec.attribute5;
1538: END IF;
1539:
1540: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1541: l_MODIFIERS_rec.attribute6 := p_old_MODIFIERS_rec.attribute6;
1542: END IF;
1543:
1544: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1540: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1541: l_MODIFIERS_rec.attribute6 := p_old_MODIFIERS_rec.attribute6;
1542: END IF;
1543:
1544: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1545: l_MODIFIERS_rec.attribute7 := p_old_MODIFIERS_rec.attribute7;
1546: END IF;
1547:
1548: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1544: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1545: l_MODIFIERS_rec.attribute7 := p_old_MODIFIERS_rec.attribute7;
1546: END IF;
1547:
1548: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1549: l_MODIFIERS_rec.attribute8 := p_old_MODIFIERS_rec.attribute8;
1550: END IF;
1551:
1552: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1548: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1549: l_MODIFIERS_rec.attribute8 := p_old_MODIFIERS_rec.attribute8;
1550: END IF;
1551:
1552: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1553: l_MODIFIERS_rec.attribute9 := p_old_MODIFIERS_rec.attribute9;
1554: END IF;
1555:
1556: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1552: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1553: l_MODIFIERS_rec.attribute9 := p_old_MODIFIERS_rec.attribute9;
1554: END IF;
1555:
1556: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1557: l_MODIFIERS_rec.automatic_flag := p_old_MODIFIERS_rec.automatic_flag;
1558: END IF;
1559:
1560: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1556: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1557: l_MODIFIERS_rec.automatic_flag := p_old_MODIFIERS_rec.automatic_flag;
1558: END IF;
1559:
1560: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1561: l_MODIFIERS_rec.base_qty := p_old_MODIFIERS_rec.base_qty;
1562: END IF;
1563: */
1564: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1560: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1561: l_MODIFIERS_rec.base_qty := p_old_MODIFIERS_rec.base_qty;
1562: END IF;
1563: */
1564: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1565: l_MODIFIERS_rec.pricing_phase_id := p_old_MODIFIERS_rec.pricing_phase_id;
1566: END IF;
1567:
1568: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1564: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1565: l_MODIFIERS_rec.pricing_phase_id := p_old_MODIFIERS_rec.pricing_phase_id;
1566: END IF;
1567:
1568: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1569: l_MODIFIERS_rec.base_uom_code := p_old_MODIFIERS_rec.base_uom_code;
1570: END IF;
1571: */
1572: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1568: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1569: l_MODIFIERS_rec.base_uom_code := p_old_MODIFIERS_rec.base_uom_code;
1570: END IF;
1571: */
1572: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1573: l_MODIFIERS_rec.comments := p_old_MODIFIERS_rec.comments;
1574: END IF;
1575:
1576: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1572: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1573: l_MODIFIERS_rec.comments := p_old_MODIFIERS_rec.comments;
1574: END IF;
1575:
1576: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1577: l_MODIFIERS_rec.context := p_old_MODIFIERS_rec.context;
1578: END IF;
1579:
1580: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1576: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1577: l_MODIFIERS_rec.context := p_old_MODIFIERS_rec.context;
1578: END IF;
1579:
1580: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1581: l_MODIFIERS_rec.created_by := p_old_MODIFIERS_rec.created_by;
1582: END IF;
1583:
1584: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1580: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1581: l_MODIFIERS_rec.created_by := p_old_MODIFIERS_rec.created_by;
1582: END IF;
1583:
1584: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1585: l_MODIFIERS_rec.creation_date := p_old_MODIFIERS_rec.creation_date;
1586: END IF;
1587:
1588: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1584: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1585: l_MODIFIERS_rec.creation_date := p_old_MODIFIERS_rec.creation_date;
1586: END IF;
1587:
1588: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1589: l_MODIFIERS_rec.effective_period_uom := p_old_MODIFIERS_rec.effective_period_uom;
1590: END IF;
1591:
1592: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1588: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1589: l_MODIFIERS_rec.effective_period_uom := p_old_MODIFIERS_rec.effective_period_uom;
1590: END IF;
1591:
1592: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1593: l_MODIFIERS_rec.end_date_active := p_old_MODIFIERS_rec.end_date_active;
1594: END IF;
1595:
1596: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1592: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1593: l_MODIFIERS_rec.end_date_active := p_old_MODIFIERS_rec.end_date_active;
1594: END IF;
1595:
1596: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1597: l_MODIFIERS_rec.estim_accrual_rate := p_old_MODIFIERS_rec.estim_accrual_rate;
1598: END IF;
1599:
1600: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1596: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1597: l_MODIFIERS_rec.estim_accrual_rate := p_old_MODIFIERS_rec.estim_accrual_rate;
1598: END IF;
1599:
1600: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1601: l_MODIFIERS_rec.generate_using_formula_id := p_old_MODIFIERS_rec.generate_using_formula_id;
1602: END IF;
1603:
1604: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1600: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1601: l_MODIFIERS_rec.generate_using_formula_id := p_old_MODIFIERS_rec.generate_using_formula_id;
1602: END IF;
1603:
1604: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1605: l_MODIFIERS_rec.inventory_item_id := p_old_MODIFIERS_rec.inventory_item_id;
1606: END IF;
1607:
1608: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1604: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1605: l_MODIFIERS_rec.inventory_item_id := p_old_MODIFIERS_rec.inventory_item_id;
1606: END IF;
1607:
1608: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1609: l_MODIFIERS_rec.last_updated_by := p_old_MODIFIERS_rec.last_updated_by;
1610: END IF;
1611:
1612: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1608: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1609: l_MODIFIERS_rec.last_updated_by := p_old_MODIFIERS_rec.last_updated_by;
1610: END IF;
1611:
1612: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1613: l_MODIFIERS_rec.last_update_date := p_old_MODIFIERS_rec.last_update_date;
1614: END IF;
1615:
1616: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1612: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1613: l_MODIFIERS_rec.last_update_date := p_old_MODIFIERS_rec.last_update_date;
1614: END IF;
1615:
1616: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1617: l_MODIFIERS_rec.last_update_login := p_old_MODIFIERS_rec.last_update_login;
1618: END IF;
1619:
1620: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1616: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1617: l_MODIFIERS_rec.last_update_login := p_old_MODIFIERS_rec.last_update_login;
1618: END IF;
1619:
1620: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1621: l_MODIFIERS_rec.list_header_id := p_old_MODIFIERS_rec.list_header_id;
1622: END IF;
1623:
1624: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1620: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1621: l_MODIFIERS_rec.list_header_id := p_old_MODIFIERS_rec.list_header_id;
1622: END IF;
1623:
1624: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1625: l_MODIFIERS_rec.list_line_id := p_old_MODIFIERS_rec.list_line_id;
1626: END IF;
1627:
1628: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1624: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1625: l_MODIFIERS_rec.list_line_id := p_old_MODIFIERS_rec.list_line_id;
1626: END IF;
1627:
1628: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1629: l_MODIFIERS_rec.list_line_type_code := p_old_MODIFIERS_rec.list_line_type_code;
1630: END IF;
1631:
1632: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1628: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1629: l_MODIFIERS_rec.list_line_type_code := p_old_MODIFIERS_rec.list_line_type_code;
1630: END IF;
1631:
1632: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1633: l_MODIFIERS_rec.list_price := p_old_MODIFIERS_rec.list_price;
1634: END IF;
1635:
1636: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1632: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
1633: l_MODIFIERS_rec.list_price := p_old_MODIFIERS_rec.list_price;
1634: END IF;
1635:
1636: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1637: l_MODIFIERS_rec.modifier_level_code := p_old_MODIFIERS_rec.modifier_level_code;
1638: END IF;
1639:
1640: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1636: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1637: l_MODIFIERS_rec.modifier_level_code := p_old_MODIFIERS_rec.modifier_level_code;
1638: END IF;
1639:
1640: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1641: l_MODIFIERS_rec.number_effective_periods := p_old_MODIFIERS_rec.number_effective_periods;
1642: END IF;
1643:
1644: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1640: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1641: l_MODIFIERS_rec.number_effective_periods := p_old_MODIFIERS_rec.number_effective_periods;
1642: END IF;
1643:
1644: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1645: l_MODIFIERS_rec.operand := p_old_MODIFIERS_rec.operand;
1646: END IF;
1647:
1648: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1644: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
1645: l_MODIFIERS_rec.operand := p_old_MODIFIERS_rec.operand;
1646: END IF;
1647:
1648: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1649: l_MODIFIERS_rec.organization_id := p_old_MODIFIERS_rec.organization_id;
1650: END IF;
1651:
1652: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1648: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
1649: l_MODIFIERS_rec.organization_id := p_old_MODIFIERS_rec.organization_id;
1650: END IF;
1651:
1652: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1653: l_MODIFIERS_rec.override_flag := p_old_MODIFIERS_rec.override_flag;
1654: END IF;
1655:
1656: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1652: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
1653: l_MODIFIERS_rec.override_flag := p_old_MODIFIERS_rec.override_flag;
1654: END IF;
1655:
1656: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1657: l_MODIFIERS_rec.percent_price := p_old_MODIFIERS_rec.percent_price;
1658: END IF;
1659:
1660: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1656: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
1657: l_MODIFIERS_rec.percent_price := p_old_MODIFIERS_rec.percent_price;
1658: END IF;
1659:
1660: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1661: l_MODIFIERS_rec.price_break_type_code := p_old_MODIFIERS_rec.price_break_type_code;
1662: END IF;
1663:
1664: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1660: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1661: l_MODIFIERS_rec.price_break_type_code := p_old_MODIFIERS_rec.price_break_type_code;
1662: END IF;
1663:
1664: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1665: l_MODIFIERS_rec.price_by_formula_id := p_old_MODIFIERS_rec.price_by_formula_id;
1666: END IF;
1667:
1668: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1664: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1665: l_MODIFIERS_rec.price_by_formula_id := p_old_MODIFIERS_rec.price_by_formula_id;
1666: END IF;
1667:
1668: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1669: l_MODIFIERS_rec.primary_uom_flag := p_old_MODIFIERS_rec.primary_uom_flag;
1670: END IF;
1671:
1672: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1668: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1669: l_MODIFIERS_rec.primary_uom_flag := p_old_MODIFIERS_rec.primary_uom_flag;
1670: END IF;
1671:
1672: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1673: l_MODIFIERS_rec.print_on_invoice_flag := p_old_MODIFIERS_rec.print_on_invoice_flag;
1674: END IF;
1675:
1676: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1672: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1673: l_MODIFIERS_rec.print_on_invoice_flag := p_old_MODIFIERS_rec.print_on_invoice_flag;
1674: END IF;
1675:
1676: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1677: l_MODIFIERS_rec.program_application_id := p_old_MODIFIERS_rec.program_application_id;
1678: END IF;
1679:
1680: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1676: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1677: l_MODIFIERS_rec.program_application_id := p_old_MODIFIERS_rec.program_application_id;
1678: END IF;
1679:
1680: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1681: l_MODIFIERS_rec.program_id := p_old_MODIFIERS_rec.program_id;
1682: END IF;
1683:
1684: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1680: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
1681: l_MODIFIERS_rec.program_id := p_old_MODIFIERS_rec.program_id;
1682: END IF;
1683:
1684: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1685: l_MODIFIERS_rec.program_update_date := p_old_MODIFIERS_rec.program_update_date;
1686: END IF;
1687:
1688: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1684: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1685: l_MODIFIERS_rec.program_update_date := p_old_MODIFIERS_rec.program_update_date;
1686: END IF;
1687:
1688: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1689: l_MODIFIERS_rec.rebate_trxn_type_code := p_old_MODIFIERS_rec.rebate_trxn_type_code;
1690: END IF;
1691:
1692: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1688: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1689: l_MODIFIERS_rec.rebate_trxn_type_code := p_old_MODIFIERS_rec.rebate_trxn_type_code;
1690: END IF;
1691:
1692: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1693: l_MODIFIERS_rec.related_item_id := p_old_MODIFIERS_rec.related_item_id;
1694: END IF;
1695:
1696: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1692: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
1693: l_MODIFIERS_rec.related_item_id := p_old_MODIFIERS_rec.related_item_id;
1694: END IF;
1695:
1696: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1697: l_MODIFIERS_rec.relationship_type_id := p_old_MODIFIERS_rec.relationship_type_id;
1698: END IF;
1699:
1700: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1696: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1697: l_MODIFIERS_rec.relationship_type_id := p_old_MODIFIERS_rec.relationship_type_id;
1698: END IF;
1699:
1700: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1701: l_MODIFIERS_rec.reprice_flag := p_old_MODIFIERS_rec.reprice_flag;
1702: END IF;
1703:
1704: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1700: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1701: l_MODIFIERS_rec.reprice_flag := p_old_MODIFIERS_rec.reprice_flag;
1702: END IF;
1703:
1704: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1705: l_MODIFIERS_rec.request_id := p_old_MODIFIERS_rec.request_id;
1706: END IF;
1707:
1708: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1704: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
1705: l_MODIFIERS_rec.request_id := p_old_MODIFIERS_rec.request_id;
1706: END IF;
1707:
1708: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1709: l_MODIFIERS_rec.revision := p_old_MODIFIERS_rec.revision;
1710: END IF;
1711:
1712: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1708: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
1709: l_MODIFIERS_rec.revision := p_old_MODIFIERS_rec.revision;
1710: END IF;
1711:
1712: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1713: l_MODIFIERS_rec.revision_date := p_old_MODIFIERS_rec.revision_date;
1714: END IF;
1715:
1716: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1712: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
1713: l_MODIFIERS_rec.revision_date := p_old_MODIFIERS_rec.revision_date;
1714: END IF;
1715:
1716: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1717: l_MODIFIERS_rec.revision_reason_code := p_old_MODIFIERS_rec.revision_reason_code;
1718: END IF;
1719:
1720: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1716: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1717: l_MODIFIERS_rec.revision_reason_code := p_old_MODIFIERS_rec.revision_reason_code;
1718: END IF;
1719:
1720: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1721: l_MODIFIERS_rec.start_date_active := p_old_MODIFIERS_rec.start_date_active;
1722: END IF;
1723:
1724: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1720: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1721: l_MODIFIERS_rec.start_date_active := p_old_MODIFIERS_rec.start_date_active;
1722: END IF;
1723:
1724: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1725: l_MODIFIERS_rec.substitution_attribute := p_old_MODIFIERS_rec.substitution_attribute;
1726: END IF;
1727:
1728: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1724: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1725: l_MODIFIERS_rec.substitution_attribute := p_old_MODIFIERS_rec.substitution_attribute;
1726: END IF;
1727:
1728: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1729: l_MODIFIERS_rec.substitution_context := p_old_MODIFIERS_rec.substitution_context;
1730: END IF;
1731:
1732: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1728: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1729: l_MODIFIERS_rec.substitution_context := p_old_MODIFIERS_rec.substitution_context;
1730: END IF;
1731:
1732: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1733: l_MODIFIERS_rec.substitution_value := p_old_MODIFIERS_rec.substitution_value;
1734: END IF;
1735:
1736: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1732: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1733: l_MODIFIERS_rec.substitution_value := p_old_MODIFIERS_rec.substitution_value;
1734: END IF;
1735:
1736: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1737: l_MODIFIERS_rec.accrual_flag := p_old_MODIFIERS_rec.accrual_flag;
1738: END IF;
1739:
1740: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1736: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
1737: l_MODIFIERS_rec.accrual_flag := p_old_MODIFIERS_rec.accrual_flag;
1738: END IF;
1739:
1740: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1741: l_MODIFIERS_rec.pricing_group_sequence := p_old_MODIFIERS_rec.pricing_group_sequence;
1742: END IF;
1743:
1744: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1740: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
1741: l_MODIFIERS_rec.pricing_group_sequence := p_old_MODIFIERS_rec.pricing_group_sequence;
1742: END IF;
1743:
1744: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1745: l_MODIFIERS_rec.incompatibility_grp_code := p_old_MODIFIERS_rec.incompatibility_grp_code;
1746: END IF;
1747:
1748: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1744: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
1745: l_MODIFIERS_rec.incompatibility_grp_code := p_old_MODIFIERS_rec.incompatibility_grp_code;
1746: END IF;
1747:
1748: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1749: l_MODIFIERS_rec.list_line_no := p_old_MODIFIERS_rec.list_line_no;
1750: END IF;
1751:
1752: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1748: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
1749: l_MODIFIERS_rec.list_line_no := p_old_MODIFIERS_rec.list_line_no;
1750: END IF;
1751:
1752: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1753: l_MODIFIERS_rec.product_precedence := p_old_MODIFIERS_rec.product_precedence;
1754: END IF;
1755:
1756: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1752: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
1753: l_MODIFIERS_rec.product_precedence := p_old_MODIFIERS_rec.product_precedence;
1754: END IF;
1755:
1756: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1757: l_MODIFIERS_rec.expiration_period_start_date := p_old_MODIFIERS_rec.expiration_period_start_date;
1758: END IF;
1759:
1760: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1756: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
1757: l_MODIFIERS_rec.expiration_period_start_date := p_old_MODIFIERS_rec.expiration_period_start_date;
1758: END IF;
1759:
1760: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1761: l_MODIFIERS_rec.number_expiration_periods := p_old_MODIFIERS_rec.number_expiration_periods;
1762: END IF;
1763:
1764: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1760: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
1761: l_MODIFIERS_rec.number_expiration_periods := p_old_MODIFIERS_rec.number_expiration_periods;
1762: END IF;
1763:
1764: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1765: l_MODIFIERS_rec.expiration_period_uom := p_old_MODIFIERS_rec.expiration_period_uom;
1766: END IF;
1767:
1768: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1764: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
1765: l_MODIFIERS_rec.expiration_period_uom := p_old_MODIFIERS_rec.expiration_period_uom;
1766: END IF;
1767:
1768: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1769: l_MODIFIERS_rec.expiration_date := p_old_MODIFIERS_rec.expiration_date;
1770: END IF;
1771:
1772: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1768: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
1769: l_MODIFIERS_rec.expiration_date := p_old_MODIFIERS_rec.expiration_date;
1770: END IF;
1771:
1772: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1773: l_MODIFIERS_rec.estim_gl_value := p_old_MODIFIERS_rec.estim_gl_value;
1774: END IF;
1775:
1776: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1772: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
1773: l_MODIFIERS_rec.estim_gl_value := p_old_MODIFIERS_rec.estim_gl_value;
1774: END IF;
1775:
1776: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1777: l_MODIFIERS_rec.benefit_price_list_line_id := p_old_MODIFIERS_rec.benefit_price_list_line_id;
1778: END IF;
1779:
1780: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1776: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
1777: l_MODIFIERS_rec.benefit_price_list_line_id := p_old_MODIFIERS_rec.benefit_price_list_line_id;
1778: END IF;
1779:
1780: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1781: l_MODIFIERS_rec.recurring_flag := p_old_MODIFIERS_rec.recurring_flag;
1782: END IF;
1783: */
1784: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1780: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
1781: l_MODIFIERS_rec.recurring_flag := p_old_MODIFIERS_rec.recurring_flag;
1782: END IF;
1783: */
1784: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1785: l_MODIFIERS_rec.benefit_limit := p_old_MODIFIERS_rec.benefit_limit;
1786: END IF;
1787:
1788: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1784: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
1785: l_MODIFIERS_rec.benefit_limit := p_old_MODIFIERS_rec.benefit_limit;
1786: END IF;
1787:
1788: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1789: l_MODIFIERS_rec.charge_type_code := p_old_MODIFIERS_rec.charge_type_code;
1790: END IF;
1791:
1792: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1788: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
1789: l_MODIFIERS_rec.charge_type_code := p_old_MODIFIERS_rec.charge_type_code;
1790: END IF;
1791:
1792: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1793: l_MODIFIERS_rec.charge_subtype_code := p_old_MODIFIERS_rec.charge_subtype_code;
1794: END IF;
1795:
1796: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1792: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
1793: l_MODIFIERS_rec.charge_subtype_code := p_old_MODIFIERS_rec.charge_subtype_code;
1794: END IF;
1795:
1796: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1797: l_MODIFIERS_rec.benefit_qty := p_old_MODIFIERS_rec.benefit_qty;
1798: END IF;
1799:
1800: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1796: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
1797: l_MODIFIERS_rec.benefit_qty := p_old_MODIFIERS_rec.benefit_qty;
1798: END IF;
1799:
1800: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1801: l_MODIFIERS_rec.benefit_uom_code := p_old_MODIFIERS_rec.benefit_uom_code;
1802: END IF;
1803:
1804: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1800: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
1801: l_MODIFIERS_rec.benefit_uom_code := p_old_MODIFIERS_rec.benefit_uom_code;
1802: END IF;
1803:
1804: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1805: l_MODIFIERS_rec.accrual_conversion_rate := p_old_MODIFIERS_rec.accrual_conversion_rate;
1806: END IF;
1807:
1808: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1804: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
1805: l_MODIFIERS_rec.accrual_conversion_rate := p_old_MODIFIERS_rec.accrual_conversion_rate;
1806: END IF;
1807:
1808: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1809: l_MODIFIERS_rec.proration_type_code := p_old_MODIFIERS_rec.proration_type_code;
1810: END IF;
1811:
1812: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1808: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
1809: l_MODIFIERS_rec.proration_type_code := p_old_MODIFIERS_rec.proration_type_code;
1810: END IF;
1811:
1812: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1813: l_MODIFIERS_rec.include_on_returns_flag := p_old_MODIFIERS_rec.include_on_returns_flag;
1814: END IF;
1815:
1816: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1812: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
1813: l_MODIFIERS_rec.include_on_returns_flag := p_old_MODIFIERS_rec.include_on_returns_flag;
1814: END IF;
1815:
1816: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1817: l_MODIFIERS_rec.from_rltd_modifier_id := p_old_MODIFIERS_rec.from_rltd_modifier_id;
1818: END IF;
1819:
1820: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1816: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1817: l_MODIFIERS_rec.from_rltd_modifier_id := p_old_MODIFIERS_rec.from_rltd_modifier_id;
1818: END IF;
1819:
1820: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1821: l_MODIFIERS_rec.to_rltd_modifier_id := p_old_MODIFIERS_rec.to_rltd_modifier_id;
1822: END IF;
1823:
1824: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1820: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1821: l_MODIFIERS_rec.to_rltd_modifier_id := p_old_MODIFIERS_rec.to_rltd_modifier_id;
1822: END IF;
1823:
1824: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1825: l_MODIFIERS_rec.rltd_modifier_grp_no := p_old_MODIFIERS_rec.rltd_modifier_grp_no;
1826: END IF;
1827:
1828: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1824: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
1825: l_MODIFIERS_rec.rltd_modifier_grp_no := p_old_MODIFIERS_rec.rltd_modifier_grp_no;
1826: END IF;
1827:
1828: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1829: l_MODIFIERS_rec.rltd_modifier_grp_type := p_old_MODIFIERS_rec.rltd_modifier_grp_type;
1830: END IF;
1831:
1832: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1828: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
1829: l_MODIFIERS_rec.rltd_modifier_grp_type := p_old_MODIFIERS_rec.rltd_modifier_grp_type;
1830: END IF;
1831:
1832: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1833: l_MODIFIERS_rec.rltd_modifier_id := p_old_MODIFIERS_rec.rltd_modifier_id;
1834: END IF;
1835:
1836: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1832: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
1833: l_MODIFIERS_rec.rltd_modifier_id := p_old_MODIFIERS_rec.rltd_modifier_id;
1834: END IF;
1835:
1836: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1837: l_MODIFIERS_rec.qualification_ind := p_old_MODIFIERS_rec.qualification_ind;
1838: END IF;
1839:
1840: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1836: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1837: l_MODIFIERS_rec.qualification_ind := p_old_MODIFIERS_rec.qualification_ind;
1838: END IF;
1839:
1840: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1841: l_MODIFIERS_rec.accum_attribute := p_old_MODIFIERS_rec.accum_attribute;
1842: END IF;
1843:
1844: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1840: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
1841: l_MODIFIERS_rec.accum_attribute := p_old_MODIFIERS_rec.accum_attribute;
1842: END IF;
1843:
1844: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1845: l_MODIFIERS_rec.net_amount_flag := p_old_MODIFIERS_rec.net_amount_flag;
1846: END IF;
1847:
1848: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1844: IF l_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR THEN
1845: l_MODIFIERS_rec.net_amount_flag := p_old_MODIFIERS_rec.net_amount_flag;
1846: END IF;
1847:
1848: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1849: l_MODIFIERS_rec.continuous_price_break_flag := p_old_MODIFIERS_rec.continuous_price_break_flag;
1850: END IF;
1851:
1852: oe_debug_pub.add('END Complete_Record in QPXUMLLB');
1865: BEGIN
1866:
1867: oe_debug_pub.add('BEGIN Convert_Miss_To_Null in QPXUMLLB');
1868:
1869: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1870: l_MODIFIERS_rec.arithmetic_operator := NULL;
1871: END IF;
1872:
1873: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1869: IF l_MODIFIERS_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1870: l_MODIFIERS_rec.arithmetic_operator := NULL;
1871: END IF;
1872:
1873: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1874: l_MODIFIERS_rec.attribute1 := NULL;
1875: END IF;
1876:
1877: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1873: IF l_MODIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1874: l_MODIFIERS_rec.attribute1 := NULL;
1875: END IF;
1876:
1877: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1878: l_MODIFIERS_rec.attribute10 := NULL;
1879: END IF;
1880:
1881: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1877: IF l_MODIFIERS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1878: l_MODIFIERS_rec.attribute10 := NULL;
1879: END IF;
1880:
1881: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1882: l_MODIFIERS_rec.attribute11 := NULL;
1883: END IF;
1884:
1885: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1881: IF l_MODIFIERS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1882: l_MODIFIERS_rec.attribute11 := NULL;
1883: END IF;
1884:
1885: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1886: l_MODIFIERS_rec.attribute12 := NULL;
1887: END IF;
1888:
1889: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1885: IF l_MODIFIERS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1886: l_MODIFIERS_rec.attribute12 := NULL;
1887: END IF;
1888:
1889: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1890: l_MODIFIERS_rec.attribute13 := NULL;
1891: END IF;
1892:
1893: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1889: IF l_MODIFIERS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1890: l_MODIFIERS_rec.attribute13 := NULL;
1891: END IF;
1892:
1893: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1894: l_MODIFIERS_rec.attribute14 := NULL;
1895: END IF;
1896:
1897: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1893: IF l_MODIFIERS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1894: l_MODIFIERS_rec.attribute14 := NULL;
1895: END IF;
1896:
1897: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1898: l_MODIFIERS_rec.attribute15 := NULL;
1899: END IF;
1900:
1901: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1897: IF l_MODIFIERS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1898: l_MODIFIERS_rec.attribute15 := NULL;
1899: END IF;
1900:
1901: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1902: l_MODIFIERS_rec.attribute2 := NULL;
1903: END IF;
1904:
1905: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1901: IF l_MODIFIERS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1902: l_MODIFIERS_rec.attribute2 := NULL;
1903: END IF;
1904:
1905: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1906: l_MODIFIERS_rec.attribute3 := NULL;
1907: END IF;
1908:
1909: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1905: IF l_MODIFIERS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1906: l_MODIFIERS_rec.attribute3 := NULL;
1907: END IF;
1908:
1909: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1910: l_MODIFIERS_rec.attribute4 := NULL;
1911: END IF;
1912:
1913: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1909: IF l_MODIFIERS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1910: l_MODIFIERS_rec.attribute4 := NULL;
1911: END IF;
1912:
1913: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1914: l_MODIFIERS_rec.attribute5 := NULL;
1915: END IF;
1916:
1917: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1913: IF l_MODIFIERS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1914: l_MODIFIERS_rec.attribute5 := NULL;
1915: END IF;
1916:
1917: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1918: l_MODIFIERS_rec.attribute6 := NULL;
1919: END IF;
1920:
1921: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1917: IF l_MODIFIERS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1918: l_MODIFIERS_rec.attribute6 := NULL;
1919: END IF;
1920:
1921: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1922: l_MODIFIERS_rec.attribute7 := NULL;
1923: END IF;
1924:
1925: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1921: IF l_MODIFIERS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1922: l_MODIFIERS_rec.attribute7 := NULL;
1923: END IF;
1924:
1925: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1926: l_MODIFIERS_rec.attribute8 := NULL;
1927: END IF;
1928:
1929: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1925: IF l_MODIFIERS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1926: l_MODIFIERS_rec.attribute8 := NULL;
1927: END IF;
1928:
1929: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1930: l_MODIFIERS_rec.attribute9 := NULL;
1931: END IF;
1932:
1933: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1929: IF l_MODIFIERS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1930: l_MODIFIERS_rec.attribute9 := NULL;
1931: END IF;
1932:
1933: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1934: l_MODIFIERS_rec.automatic_flag := NULL;
1935: END IF;
1936:
1937: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1933: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1934: l_MODIFIERS_rec.automatic_flag := NULL;
1935: END IF;
1936:
1937: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1938: l_MODIFIERS_rec.base_qty := NULL;
1939: END IF;
1940: */
1941: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1937: /* IF l_MODIFIERS_rec.base_qty = FND_API.G_MISS_NUM THEN
1938: l_MODIFIERS_rec.base_qty := NULL;
1939: END IF;
1940: */
1941: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1942: l_MODIFIERS_rec.pricing_phase_id := NULL;
1943: END IF;
1944:
1945: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1941: IF l_MODIFIERS_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1942: l_MODIFIERS_rec.pricing_phase_id := NULL;
1943: END IF;
1944:
1945: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1946: l_MODIFIERS_rec.base_uom_code := NULL;
1947: END IF;
1948: */
1949: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1945: /* IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1946: l_MODIFIERS_rec.base_uom_code := NULL;
1947: END IF;
1948: */
1949: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1950: l_MODIFIERS_rec.comments := NULL;
1951: END IF;
1952:
1953: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1949: IF l_MODIFIERS_rec.comments = FND_API.G_MISS_CHAR THEN
1950: l_MODIFIERS_rec.comments := NULL;
1951: END IF;
1952:
1953: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1954: l_MODIFIERS_rec.context := NULL;
1955: END IF;
1956:
1957: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1953: IF l_MODIFIERS_rec.context = FND_API.G_MISS_CHAR THEN
1954: l_MODIFIERS_rec.context := NULL;
1955: END IF;
1956:
1957: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1958: l_MODIFIERS_rec.created_by := NULL;
1959: END IF;
1960:
1961: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1957: IF l_MODIFIERS_rec.created_by = FND_API.G_MISS_NUM THEN
1958: l_MODIFIERS_rec.created_by := NULL;
1959: END IF;
1960:
1961: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1962: l_MODIFIERS_rec.creation_date := NULL;
1963: END IF;
1964:
1965: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1961: IF l_MODIFIERS_rec.creation_date = FND_API.G_MISS_DATE THEN
1962: l_MODIFIERS_rec.creation_date := NULL;
1963: END IF;
1964:
1965: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1966: l_MODIFIERS_rec.effective_period_uom := NULL;
1967: END IF;
1968:
1969: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1965: IF l_MODIFIERS_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1966: l_MODIFIERS_rec.effective_period_uom := NULL;
1967: END IF;
1968:
1969: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1970: l_MODIFIERS_rec.end_date_active := NULL;
1971: END IF;
1972:
1973: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1969: IF l_MODIFIERS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1970: l_MODIFIERS_rec.end_date_active := NULL;
1971: END IF;
1972:
1973: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1974: l_MODIFIERS_rec.estim_accrual_rate := NULL;
1975: END IF;
1976:
1977: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1973: IF l_MODIFIERS_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1974: l_MODIFIERS_rec.estim_accrual_rate := NULL;
1975: END IF;
1976:
1977: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1978: l_MODIFIERS_rec.generate_using_formula_id := NULL;
1979: END IF;
1980:
1981: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1977: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1978: l_MODIFIERS_rec.generate_using_formula_id := NULL;
1979: END IF;
1980:
1981: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1982: l_MODIFIERS_rec.inventory_item_id := NULL;
1983: END IF;
1984:
1985: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1981: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1982: l_MODIFIERS_rec.inventory_item_id := NULL;
1983: END IF;
1984:
1985: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1986: l_MODIFIERS_rec.last_updated_by := NULL;
1987: END IF;
1988:
1989: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1985: IF l_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1986: l_MODIFIERS_rec.last_updated_by := NULL;
1987: END IF;
1988:
1989: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1990: l_MODIFIERS_rec.last_update_date := NULL;
1991: END IF;
1992:
1993: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1989: IF l_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1990: l_MODIFIERS_rec.last_update_date := NULL;
1991: END IF;
1992:
1993: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1994: l_MODIFIERS_rec.last_update_login := NULL;
1995: END IF;
1996:
1997: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1993: IF l_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1994: l_MODIFIERS_rec.last_update_login := NULL;
1995: END IF;
1996:
1997: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1998: l_MODIFIERS_rec.list_header_id := NULL;
1999: END IF;
2000:
2001: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
1997: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
1998: l_MODIFIERS_rec.list_header_id := NULL;
1999: END IF;
2000:
2001: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2002: l_MODIFIERS_rec.list_line_id := NULL;
2003: END IF;
2004:
2005: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2001: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
2002: l_MODIFIERS_rec.list_line_id := NULL;
2003: END IF;
2004:
2005: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2006: l_MODIFIERS_rec.list_line_type_code := NULL;
2007: END IF;
2008:
2009: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2005: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
2006: l_MODIFIERS_rec.list_line_type_code := NULL;
2007: END IF;
2008:
2009: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2010: l_MODIFIERS_rec.list_price := NULL;
2011: END IF;
2012:
2013: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2009: IF l_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM THEN
2010: l_MODIFIERS_rec.list_price := NULL;
2011: END IF;
2012:
2013: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2014: l_MODIFIERS_rec.modifier_level_code := NULL;
2015: END IF;
2016:
2017: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2013: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
2014: l_MODIFIERS_rec.modifier_level_code := NULL;
2015: END IF;
2016:
2017: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2018: l_MODIFIERS_rec.number_effective_periods := NULL;
2019: END IF;
2020:
2021: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2017: IF l_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
2018: l_MODIFIERS_rec.number_effective_periods := NULL;
2019: END IF;
2020:
2021: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2022: l_MODIFIERS_rec.operand := NULL;
2023: END IF;
2024:
2025: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2021: IF l_MODIFIERS_rec.operand = FND_API.G_MISS_NUM THEN
2022: l_MODIFIERS_rec.operand := NULL;
2023: END IF;
2024:
2025: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2026: l_MODIFIERS_rec.organization_id := NULL;
2027: END IF;
2028:
2029: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2025: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
2026: l_MODIFIERS_rec.organization_id := NULL;
2027: END IF;
2028:
2029: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2030: l_MODIFIERS_rec.override_flag := NULL;
2031: END IF;
2032:
2033: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2029: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
2030: l_MODIFIERS_rec.override_flag := NULL;
2031: END IF;
2032:
2033: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2034: l_MODIFIERS_rec.percent_price := NULL;
2035: END IF;
2036:
2037: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2033: IF l_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM THEN
2034: l_MODIFIERS_rec.percent_price := NULL;
2035: END IF;
2036:
2037: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2038: l_MODIFIERS_rec.price_break_type_code := NULL;
2039: END IF;
2040:
2041: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2037: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
2038: l_MODIFIERS_rec.price_break_type_code := NULL;
2039: END IF;
2040:
2041: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2042: l_MODIFIERS_rec.price_by_formula_id := NULL;
2043: END IF;
2044:
2045: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2041: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
2042: l_MODIFIERS_rec.price_by_formula_id := NULL;
2043: END IF;
2044:
2045: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2046: l_MODIFIERS_rec.primary_uom_flag := NULL;
2047: END IF;
2048:
2049: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2045: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
2046: l_MODIFIERS_rec.primary_uom_flag := NULL;
2047: END IF;
2048:
2049: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2050: l_MODIFIERS_rec.print_on_invoice_flag := NULL;
2051: END IF;
2052:
2053: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2049: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
2050: l_MODIFIERS_rec.print_on_invoice_flag := NULL;
2051: END IF;
2052:
2053: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2054: l_MODIFIERS_rec.program_application_id := NULL;
2055: END IF;
2056:
2057: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2053: IF l_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM THEN
2054: l_MODIFIERS_rec.program_application_id := NULL;
2055: END IF;
2056:
2057: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2058: l_MODIFIERS_rec.program_id := NULL;
2059: END IF;
2060:
2061: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2057: IF l_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM THEN
2058: l_MODIFIERS_rec.program_id := NULL;
2059: END IF;
2060:
2061: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2062: l_MODIFIERS_rec.program_update_date := NULL;
2063: END IF;
2064:
2065: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2061: IF l_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
2062: l_MODIFIERS_rec.program_update_date := NULL;
2063: END IF;
2064:
2065: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2066: l_MODIFIERS_rec.rebate_trxn_type_code := NULL;
2067: END IF;
2068:
2069: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2065: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
2066: l_MODIFIERS_rec.rebate_trxn_type_code := NULL;
2067: END IF;
2068:
2069: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2070: l_MODIFIERS_rec.related_item_id := NULL;
2071: END IF;
2072:
2073: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2069: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
2070: l_MODIFIERS_rec.related_item_id := NULL;
2071: END IF;
2072:
2073: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2074: l_MODIFIERS_rec.relationship_type_id := NULL;
2075: END IF;
2076:
2077: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2073: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
2074: l_MODIFIERS_rec.relationship_type_id := NULL;
2075: END IF;
2076:
2077: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2078: l_MODIFIERS_rec.reprice_flag := NULL;
2079: END IF;
2080:
2081: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2077: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2078: l_MODIFIERS_rec.reprice_flag := NULL;
2079: END IF;
2080:
2081: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2082: l_MODIFIERS_rec.request_id := NULL;
2083: END IF;
2084:
2085: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2081: IF l_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM THEN
2082: l_MODIFIERS_rec.request_id := NULL;
2083: END IF;
2084:
2085: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2086: l_MODIFIERS_rec.revision := NULL;
2087: END IF;
2088:
2089: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2085: IF l_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR THEN
2086: l_MODIFIERS_rec.revision := NULL;
2087: END IF;
2088:
2089: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2090: l_MODIFIERS_rec.revision_date := NULL;
2091: END IF;
2092:
2093: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2089: IF l_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE THEN
2090: l_MODIFIERS_rec.revision_date := NULL;
2091: END IF;
2092:
2093: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2094: l_MODIFIERS_rec.revision_reason_code := NULL;
2095: END IF;
2096:
2097: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2093: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2094: l_MODIFIERS_rec.revision_reason_code := NULL;
2095: END IF;
2096:
2097: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2098: l_MODIFIERS_rec.start_date_active := NULL;
2099: END IF;
2100:
2101: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2097: IF l_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE THEN
2098: l_MODIFIERS_rec.start_date_active := NULL;
2099: END IF;
2100:
2101: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2102: l_MODIFIERS_rec.substitution_attribute := NULL;
2103: END IF;
2104:
2105: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2101: IF l_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
2102: l_MODIFIERS_rec.substitution_attribute := NULL;
2103: END IF;
2104:
2105: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2106: l_MODIFIERS_rec.substitution_context := NULL;
2107: END IF;
2108:
2109: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2105: IF l_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR THEN
2106: l_MODIFIERS_rec.substitution_context := NULL;
2107: END IF;
2108:
2109: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2110: l_MODIFIERS_rec.substitution_value := NULL;
2111: END IF;
2112:
2113: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2109: IF l_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR THEN
2110: l_MODIFIERS_rec.substitution_value := NULL;
2111: END IF;
2112:
2113: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2114: l_MODIFIERS_rec.accrual_flag := NULL;
2115: END IF;
2116:
2117: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2113: IF l_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
2114: l_MODIFIERS_rec.accrual_flag := NULL;
2115: END IF;
2116:
2117: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2118: l_MODIFIERS_rec.pricing_group_sequence := NULL;
2119: END IF;
2120:
2121: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2117: IF l_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
2118: l_MODIFIERS_rec.pricing_group_sequence := NULL;
2119: END IF;
2120:
2121: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2122: l_MODIFIERS_rec.incompatibility_grp_code := NULL;
2123: END IF;
2124:
2125: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2121: IF l_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR THEN
2122: l_MODIFIERS_rec.incompatibility_grp_code := NULL;
2123: END IF;
2124:
2125: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2126: l_MODIFIERS_rec.list_line_no := NULL;
2127: END IF;
2128:
2129: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2125: IF l_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR THEN
2126: l_MODIFIERS_rec.list_line_no := NULL;
2127: END IF;
2128:
2129: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2130: l_MODIFIERS_rec.product_precedence := NULL;
2131: END IF;
2132:
2133: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2129: IF l_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM THEN
2130: l_MODIFIERS_rec.product_precedence := NULL;
2131: END IF;
2132:
2133: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2134: l_MODIFIERS_rec.expiration_period_start_date := NULL;
2135: END IF;
2136:
2137: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2133: IF l_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE THEN
2134: l_MODIFIERS_rec.expiration_period_start_date := NULL;
2135: END IF;
2136:
2137: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2138: l_MODIFIERS_rec.number_expiration_periods := NULL;
2139: END IF;
2140:
2141: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2137: IF l_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM THEN
2138: l_MODIFIERS_rec.number_expiration_periods := NULL;
2139: END IF;
2140:
2141: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2142: l_MODIFIERS_rec.expiration_period_uom := NULL;
2143: END IF;
2144:
2145: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2141: IF l_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR THEN
2142: l_MODIFIERS_rec.expiration_period_uom := NULL;
2143: END IF;
2144:
2145: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2146: l_MODIFIERS_rec.expiration_date := NULL;
2147: END IF;
2148:
2149: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2145: IF l_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE THEN
2146: l_MODIFIERS_rec.expiration_date := NULL;
2147: END IF;
2148:
2149: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2150: l_MODIFIERS_rec.estim_gl_value := NULL;
2151: END IF;
2152:
2153: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2149: IF l_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM THEN
2150: l_MODIFIERS_rec.estim_gl_value := NULL;
2151: END IF;
2152:
2153: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2154: l_MODIFIERS_rec.benefit_price_list_line_id := NULL;
2155: END IF;
2156:
2157: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2153: IF l_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM THEN
2154: l_MODIFIERS_rec.benefit_price_list_line_id := NULL;
2155: END IF;
2156:
2157: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2158: l_MODIFIERS_rec.recurring_flag := NULL;
2159: END IF;
2160: */
2161: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2157: /* IF l_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR THEN
2158: l_MODIFIERS_rec.recurring_flag := NULL;
2159: END IF;
2160: */
2161: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2162: l_MODIFIERS_rec.benefit_limit := NULL;
2163: END IF;
2164:
2165: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2161: IF l_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM THEN
2162: l_MODIFIERS_rec.benefit_limit := NULL;
2163: END IF;
2164:
2165: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2166: l_MODIFIERS_rec.charge_type_code := NULL;
2167: END IF;
2168:
2169: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2165: IF l_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
2166: l_MODIFIERS_rec.charge_type_code := NULL;
2167: END IF;
2168:
2169: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2170: l_MODIFIERS_rec.charge_subtype_code := NULL;
2171: END IF;
2172:
2173: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2169: IF l_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
2170: l_MODIFIERS_rec.charge_subtype_code := NULL;
2171: END IF;
2172:
2173: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2174: l_MODIFIERS_rec.benefit_qty := NULL;
2175: END IF;
2176:
2177: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2173: IF l_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM THEN
2174: l_MODIFIERS_rec.benefit_qty := NULL;
2175: END IF;
2176:
2177: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2178: l_MODIFIERS_rec.benefit_uom_code := NULL;
2179: END IF;
2180:
2181: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2177: IF l_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
2178: l_MODIFIERS_rec.benefit_uom_code := NULL;
2179: END IF;
2180:
2181: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2182: l_MODIFIERS_rec.accrual_conversion_rate := NULL;
2183: END IF;
2184:
2185: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2181: IF l_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
2182: l_MODIFIERS_rec.accrual_conversion_rate := NULL;
2183: END IF;
2184:
2185: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2186: l_MODIFIERS_rec.proration_type_code := NULL;
2187: END IF;
2188:
2189: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2185: IF l_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
2186: l_MODIFIERS_rec.proration_type_code := NULL;
2187: END IF;
2188:
2189: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2190: l_MODIFIERS_rec.include_on_returns_flag := NULL;
2191: END IF;
2192:
2193: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2189: IF l_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
2190: l_MODIFIERS_rec.include_on_returns_flag := NULL;
2191: END IF;
2192:
2193: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2194: l_MODIFIERS_rec.from_rltd_modifier_id := NULL;
2195: END IF;
2196:
2197: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2193: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2194: l_MODIFIERS_rec.from_rltd_modifier_id := NULL;
2195: END IF;
2196:
2197: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2198: l_MODIFIERS_rec.to_rltd_modifier_id := NULL;
2199: END IF;
2200:
2201: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2197: IF l_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM THEN
2198: l_MODIFIERS_rec.to_rltd_modifier_id := NULL;
2199: END IF;
2200:
2201: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2202: l_MODIFIERS_rec.rltd_modifier_grp_no := NULL;
2203: END IF;
2204:
2205: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2201: IF l_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM THEN
2202: l_MODIFIERS_rec.rltd_modifier_grp_no := NULL;
2203: END IF;
2204:
2205: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2206: l_MODIFIERS_rec.rltd_modifier_grp_type := NULL;
2207: END IF;
2208:
2209: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2205: IF l_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR THEN
2206: l_MODIFIERS_rec.rltd_modifier_grp_type := NULL;
2207: END IF;
2208:
2209: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2210: l_MODIFIERS_rec.rltd_modifier_id := NULL;
2211: END IF;
2212:
2213: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2209: IF l_MODIFIERS_rec.rltd_modifier_id = FND_API.G_MISS_NUM THEN
2210: l_MODIFIERS_rec.rltd_modifier_id := NULL;
2211: END IF;
2212:
2213: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2214: l_MODIFIERS_rec.qualification_ind := NULL;
2215: END IF;
2216:
2217: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2213: IF l_MODIFIERS_rec.qualification_ind = FND_API.G_MISS_NUM THEN
2214: l_MODIFIERS_rec.qualification_ind := NULL;
2215: END IF;
2216:
2217: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2218: l_MODIFIERS_rec.accum_attribute := NULL;
2219: END IF;
2220:
2221: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
2217: IF l_MODIFIERS_rec.accum_attribute = FND_API.G_MISS_CHAR THEN
2218: l_MODIFIERS_rec.accum_attribute := NULL;
2219: END IF;
2220:
2221: IF l_MODIFIERS_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
2222: l_MODIFIERS_rec.continuous_price_break_flag := NULL;
2223: END IF;
2224:
2225: oe_debug_pub.add('END Complete_Record in QPXUMLLB');
2365: , 'Update_Child_Lines'
2366: );
2367: END IF;
2368:
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: oe_debug_pub.add('exp update child lines');
2371:
2372: END UPDATE_CHILD_LINES;
2373:
2392: BEGIN
2393:
2394: oe_debug_pub.add('BEGIN Update_Row in QPXUMLLB');
2395: IF (p_MODIFIERS_rec.accum_attribute IS NOT NULL AND
2396: p_MODIFIERS_rec.accum_attribute <> FND_API.G_MISS_CHAR) THEN
2397: v_accum_context := 'VOLUME';
2398:
2399: BEGIN
2400: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2563: WHEN DUP_VAL_ON_INDEX THEN
2564:
2565: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2566: OE_MSG_PUB.Add;
2567: RAISE FND_API.G_EXC_ERROR;
2568:
2569: WHEN OTHERS THEN
2570:
2571: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2575: , 'Update_Row'
2576: );
2577: END IF;
2578:
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580:
2581: END Update_Row;
2582:
2583: -- Procedure Insert_Row
2598:
2599: oe_debug_pub.add('BEGIN Insert_Row in QPXUMLLB'||p_MODIFIERS_rec.list_line_type_code);
2600:
2601: IF (p_MODIFIERS_rec.accum_attribute IS NOT NULL AND
2602: p_MODIFIERS_rec.accum_attribute <> FND_API.G_MISS_CHAR) THEN
2603: v_accum_context := 'VOLUME';
2604:
2605: BEGIN
2606: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2845: END IF;
2846:
2847: oe_debug_pub.add('UMLLB l_ret_sts create_gsa_qual '||l_return_status);
2848: /*added this code to raise exception if qualifier does not get created-spgopal*/
2849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2850: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2851: OE_MSG_PUB.Add;
2852: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: RAISE NO_DATA_FOUND;
2848: /*added this code to raise exception if qualifier does not get created-spgopal*/
2849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2850: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2851: OE_MSG_PUB.Add;
2852: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: RAISE NO_DATA_FOUND;
2854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2856: OE_MSG_PUB.Add;
2850: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2851: OE_MSG_PUB.Add;
2852: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: RAISE NO_DATA_FOUND;
2854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2856: OE_MSG_PUB.Add;
2857: --RAISE FND_API.G_EXC_ERROR;
2858: RAISE NO_DATA_FOUND;
2853: RAISE NO_DATA_FOUND;
2854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2856: OE_MSG_PUB.Add;
2857: --RAISE FND_API.G_EXC_ERROR;
2858: RAISE NO_DATA_FOUND;
2859: END IF;
2860:
2861: /* Accumulation Start */
2884: WHEN DUP_VAL_ON_INDEX THEN
2885:
2886: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2887: OE_MSG_PUB.Add;
2888: RAISE FND_API.G_EXC_ERROR;
2889:
2890: WHEN OTHERS THEN
2891:
2892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2896: , 'Insert_Row'
2897: );
2898: END IF;
2899:
2900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2901:
2902: END Insert_Row;
2903:
2904: -- Procedure Delete_Row
2937: , 'Delete_Row'
2938: );
2939: END IF;
2940:
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942:
2943: END Delete_Row;
2944:
2945: -- Function Query_Row
2961: --
2962:
2963: FUNCTION Query_Rows
2964: ( p_list_line_id IN NUMBER :=
2965: FND_API.G_MISS_NUM
2966: , p_list_header_id IN NUMBER :=
2967: FND_API.G_MISS_NUM
2968: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
2969: IS
2963: FUNCTION Query_Rows
2964: ( p_list_line_id IN NUMBER :=
2965: FND_API.G_MISS_NUM
2966: , p_list_header_id IN NUMBER :=
2967: FND_API.G_MISS_NUM
2968: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type
2969: IS
2970: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2971: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
3156:
3157: IF
3158: (p_list_line_id IS NOT NULL
3159: AND
3160: p_list_line_id <> FND_API.G_MISS_NUM)
3161: AND
3162: (p_list_header_id IS NOT NULL
3163: AND
3164: p_list_header_id <> FND_API.G_MISS_NUM)
3160: p_list_line_id <> FND_API.G_MISS_NUM)
3161: AND
3162: (p_list_header_id IS NOT NULL
3163: AND
3164: p_list_header_id <> FND_API.G_MISS_NUM)
3165: THEN
3166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3167: THEN
3168: OE_MSG_PUB.Add_Exc_Msg
3171: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
3172: );
3173: END IF;
3174:
3175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3176:
3177: END IF;
3178:
3179:
3305:
3306: IF
3307: (p_list_line_id IS NOT NULL
3308: AND
3309: p_list_line_id <> FND_API.G_MISS_NUM)
3310: AND
3311: (l_MODIFIERS_tbl.COUNT = 0)
3312: THEN
3313: RAISE NO_DATA_FOUND;
3321: RETURN l_MODIFIERS_tbl;
3322:
3323: EXCEPTION
3324:
3325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3326:
3327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3328:
3329: WHEN OTHERS THEN
3323: EXCEPTION
3324:
3325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3326:
3327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3328:
3329: WHEN OTHERS THEN
3330:
3331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3335: , 'Query_Rows'
3336: );
3337: END IF;
3338:
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340:
3341: END Query_Rows;
3342:
3343: -- Procedure lock_Row
3783: x_MODIFIERS_rec := l_MODIFIERS_rec;
3784:
3785: -- Set return status
3786:
3787: x_return_status := FND_API.G_RET_STS_SUCCESS;
3788: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3789:
3790: ELSE
3791:
3784:
3785: -- Set return status
3786:
3787: x_return_status := FND_API.G_RET_STS_SUCCESS;
3788: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3789:
3790: ELSE
3791:
3792: -- Row has changed by another user.
3790: ELSE
3791:
3792: -- Row has changed by another user.
3793:
3794: x_return_status := FND_API.G_RET_STS_ERROR;
3795: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3796:
3797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3798: THEN
3791:
3792: -- Row has changed by another user.
3793:
3794: x_return_status := FND_API.G_RET_STS_ERROR;
3795: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3796:
3797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3798: THEN
3799:
3809: EXCEPTION
3810:
3811: WHEN NO_DATA_FOUND THEN
3812:
3813: x_return_status := FND_API.G_RET_STS_ERROR;
3814: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3815:
3816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3817: THEN
3810:
3811: WHEN NO_DATA_FOUND THEN
3812:
3813: x_return_status := FND_API.G_RET_STS_ERROR;
3814: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3815:
3816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3817: THEN
3818:
3821:
3822: END IF;
3823: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_ERROR;
3826: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3827:
3828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3829: THEN
3822: END IF;
3823: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3824:
3825: x_return_status := FND_API.G_RET_STS_ERROR;
3826: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3827:
3828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3829: THEN
3830:
3833:
3834: END IF;
3835: WHEN OTHERS THEN
3836:
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3839:
3840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3841: THEN
3834: END IF;
3835: WHEN OTHERS THEN
3836:
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3839:
3840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3841: THEN
3842: OE_MSG_PUB.Add_Exc_Msg
3860:
3861: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
3862:
3863: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
3864: p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
3865: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3866: p_old_MODIFIERS_rec.automatic_flag)
3867: THEN
3868: l_MODIFIERS_val_rec.automatic := QP_Id_To_Value.Automatic
3870: );
3871: END IF;
3872:
3873: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
3874: p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
3875: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3876: p_old_MODIFIERS_rec.base_uom_code)
3877: THEN
3878: l_MODIFIERS_val_rec.base_uom := QP_Id_To_Value.Base_Uom
3880: );
3881: END IF;
3882: */
3883: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND
3884: p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
3885: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3886: p_old_MODIFIERS_rec.generate_using_formula_id)
3887: THEN
3888: l_MODIFIERS_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
3890: );
3891: END IF;
3892:
3893: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND
3894: p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
3895: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3896: p_old_MODIFIERS_rec.inventory_item_id)
3897: THEN
3898: l_MODIFIERS_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
3900: );
3901: END IF;
3902:
3903: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
3904: p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
3905: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,
3906: p_old_MODIFIERS_rec.list_header_id)
3907: THEN
3908: l_MODIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
3910: );
3911: END IF;
3912:
3913: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND
3914: p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
3915: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3916: p_old_MODIFIERS_rec.list_line_id)
3917: THEN
3918: l_MODIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
3920: );
3921: END IF;
3922:
3923: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND
3924: p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
3925: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3926: p_old_MODIFIERS_rec.list_line_type_code)
3927: THEN
3928: l_MODIFIERS_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
3930: );
3931: END IF;
3932:
3933: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND
3934: p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
3935: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3936: p_old_MODIFIERS_rec.modifier_level_code)
3937: THEN
3938: l_MODIFIERS_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
3940: );
3941: END IF;
3942:
3943: IF p_MODIFIERS_rec.organization_id IS NOT NULL AND
3944: p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM AND
3945: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3946: p_old_MODIFIERS_rec.organization_id)
3947: THEN
3948: l_MODIFIERS_val_rec.organization := QP_Id_To_Value.Organization
3950: );
3951: END IF;
3952:
3953: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
3954: p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR AND
3955: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3956: p_old_MODIFIERS_rec.override_flag)
3957: THEN
3958: l_MODIFIERS_val_rec.override := QP_Id_To_Value.Override
3960: );
3961: END IF;
3962:
3963: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND
3964: p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
3965: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3966: p_old_MODIFIERS_rec.price_break_type_code)
3967: THEN
3968: l_MODIFIERS_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
3970: );
3971: END IF;
3972:
3973: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND
3974: p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
3975: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3976: p_old_MODIFIERS_rec.price_by_formula_id)
3977: THEN
3978: l_MODIFIERS_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
3980: );
3981: END IF;
3982:
3983: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND
3984: p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
3985: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,
3986: p_old_MODIFIERS_rec.primary_uom_flag)
3987: THEN
3988: l_MODIFIERS_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
3990: );
3991: END IF;
3992:
3993: IF p_MODIFIERS_rec.print_on_invoice_flag IS NOT NULL AND
3994: p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
3995: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3996: p_old_MODIFIERS_rec.print_on_invoice_flag)
3997: THEN
3998: l_MODIFIERS_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
4000: );
4001: END IF;
4002:
4003: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND
4004: p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
4005: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
4006: p_old_MODIFIERS_rec.rebate_trxn_type_code)
4007: THEN
4008: l_MODIFIERS_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
4010: );
4011: END IF;
4012:
4013: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND
4014: p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM AND
4015: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
4016: p_old_MODIFIERS_rec.related_item_id)
4017: THEN
4018: l_MODIFIERS_val_rec.related_item := QP_Id_To_Value.Related_Item
4020: );
4021: END IF;
4022:
4023: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND
4024: p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
4025: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
4026: p_old_MODIFIERS_rec.relationship_type_id)
4027: THEN
4028: l_MODIFIERS_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
4030: );
4031: END IF;
4032:
4033: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND
4034: p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
4035: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
4036: p_old_MODIFIERS_rec.reprice_flag)
4037: THEN
4038: l_MODIFIERS_val_rec.reprice := QP_Id_To_Value.Reprice
4040: );
4041: END IF;
4042:
4043: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND
4044: p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
4045: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
4046: p_old_MODIFIERS_rec.revision_reason_code)
4047: THEN
4048: l_MODIFIERS_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
4069: oe_debug_pub.add('BEGIN Get_Ids in QPXUMLLB');
4070:
4071: -- initialize return_status.
4072:
4073: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4074:
4075: -- initialize l_MODIFIERS_rec.
4076:
4077: l_MODIFIERS_rec := p_MODIFIERS_rec;
4075: -- initialize l_MODIFIERS_rec.
4076:
4077: l_MODIFIERS_rec := p_MODIFIERS_rec;
4078:
4079: IF p_MODIFIERS_val_rec.automatic <> FND_API.G_MISS_CHAR
4080: THEN
4081:
4082: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4083:
4078:
4079: IF p_MODIFIERS_val_rec.automatic <> FND_API.G_MISS_CHAR
4080: THEN
4081:
4082: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4083:
4084: l_MODIFIERS_rec.automatic_flag := p_MODIFIERS_rec.automatic_flag;
4085:
4086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4097: l_MODIFIERS_rec.automatic_flag := QP_Value_To_Id.automatic
4098: ( p_automatic => p_MODIFIERS_val_rec.automatic
4099: );
4100:
4101: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
4102: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4103: END IF;
4104:
4105: END IF;
4098: ( p_automatic => p_MODIFIERS_val_rec.automatic
4099: );
4100:
4101: IF l_MODIFIERS_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
4102: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4103: END IF;
4104:
4105: END IF;
4106:
4105: END IF;
4106:
4107: END IF;
4108:
4109: /* IF p_MODIFIERS_val_rec.base_uom <> FND_API.G_MISS_CHAR
4110: THEN
4111:
4112: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4113:
4108:
4109: /* IF p_MODIFIERS_val_rec.base_uom <> FND_API.G_MISS_CHAR
4110: THEN
4111:
4112: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4113:
4114: l_MODIFIERS_rec.base_uom_code := p_MODIFIERS_rec.base_uom_code;
4115:
4116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4127: l_MODIFIERS_rec.base_uom_code := QP_Value_To_Id.base_uom
4128: ( p_base_uom => p_MODIFIERS_val_rec.base_uom
4129: );
4130:
4131: IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
4132: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4133: END IF;
4134:
4135: END IF;
4128: ( p_base_uom => p_MODIFIERS_val_rec.base_uom
4129: );
4130:
4131: IF l_MODIFIERS_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
4132: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4133: END IF;
4134:
4135: END IF;
4136:
4135: END IF;
4136:
4137: END IF;
4138: */
4139: IF p_MODIFIERS_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
4140: THEN
4141:
4142: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4143:
4138: */
4139: IF p_MODIFIERS_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
4140: THEN
4141:
4142: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4143:
4144: l_MODIFIERS_rec.generate_using_formula_id := p_MODIFIERS_rec.generate_using_formula_id;
4145:
4146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4157: l_MODIFIERS_rec.generate_using_formula_id := QP_Value_To_Id.generate_using_formula
4158: ( p_generate_using_formula => p_MODIFIERS_val_rec.generate_using_formula
4159: );
4160:
4161: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
4162: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4163: END IF;
4164:
4165: END IF;
4158: ( p_generate_using_formula => p_MODIFIERS_val_rec.generate_using_formula
4159: );
4160:
4161: IF l_MODIFIERS_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
4162: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4163: END IF;
4164:
4165: END IF;
4166:
4165: END IF;
4166:
4167: END IF;
4168:
4169: IF p_MODIFIERS_val_rec.inventory_item <> FND_API.G_MISS_CHAR
4170: THEN
4171:
4172: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4173:
4168:
4169: IF p_MODIFIERS_val_rec.inventory_item <> FND_API.G_MISS_CHAR
4170: THEN
4171:
4172: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4173:
4174: l_MODIFIERS_rec.inventory_item_id := p_MODIFIERS_rec.inventory_item_id;
4175:
4176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4187: l_MODIFIERS_rec.inventory_item_id := QP_Value_To_Id.inventory_item
4188: ( p_inventory_item => p_MODIFIERS_val_rec.inventory_item
4189: );
4190:
4191: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
4192: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4193: END IF;
4194:
4195: END IF;
4188: ( p_inventory_item => p_MODIFIERS_val_rec.inventory_item
4189: );
4190:
4191: IF l_MODIFIERS_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
4192: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4193: END IF;
4194:
4195: END IF;
4196:
4195: END IF;
4196:
4197: END IF;
4198:
4199: IF p_MODIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
4200: THEN
4201:
4202: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4203:
4198:
4199: IF p_MODIFIERS_val_rec.list_header <> FND_API.G_MISS_CHAR
4200: THEN
4201:
4202: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4203:
4204: l_MODIFIERS_rec.list_header_id := p_MODIFIERS_rec.list_header_id;
4205:
4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4217: l_MODIFIERS_rec.list_header_id := QP_Value_To_Id.list_header
4218: ( p_list_header => p_MODIFIERS_val_rec.list_header
4219: );
4220:
4221: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
4222: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4223: END IF;
4224:
4225: END IF;
4218: ( p_list_header => p_MODIFIERS_val_rec.list_header
4219: );
4220:
4221: IF l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM THEN
4222: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4223: END IF;
4224:
4225: END IF;
4226:
4225: END IF;
4226:
4227: END IF;
4228:
4229: IF p_MODIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
4230: THEN
4231:
4232: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4233:
4228:
4229: IF p_MODIFIERS_val_rec.list_line <> FND_API.G_MISS_CHAR
4230: THEN
4231:
4232: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4233:
4234: l_MODIFIERS_rec.list_line_id := p_MODIFIERS_rec.list_line_id;
4235:
4236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4247: l_MODIFIERS_rec.list_line_id := QP_Value_To_Id.list_line
4248: ( p_list_line => p_MODIFIERS_val_rec.list_line
4249: );
4250:
4251: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
4252: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4253: END IF;
4254:
4255: END IF;
4248: ( p_list_line => p_MODIFIERS_val_rec.list_line
4249: );
4250:
4251: IF l_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM THEN
4252: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4253: END IF;
4254:
4255: END IF;
4256:
4255: END IF;
4256:
4257: END IF;
4258:
4259: IF p_MODIFIERS_val_rec.list_line_type <> FND_API.G_MISS_CHAR
4260: THEN
4261:
4262: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4263:
4258:
4259: IF p_MODIFIERS_val_rec.list_line_type <> FND_API.G_MISS_CHAR
4260: THEN
4261:
4262: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4263:
4264: l_MODIFIERS_rec.list_line_type_code := p_MODIFIERS_rec.list_line_type_code;
4265:
4266: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4277: l_MODIFIERS_rec.list_line_type_code := QP_Value_To_Id.list_line_type
4278: ( p_list_line_type => p_MODIFIERS_val_rec.list_line_type
4279: );
4280:
4281: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
4282: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4283: END IF;
4284:
4285: END IF;
4278: ( p_list_line_type => p_MODIFIERS_val_rec.list_line_type
4279: );
4280:
4281: IF l_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
4282: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4283: END IF;
4284:
4285: END IF;
4286:
4285: END IF;
4286:
4287: END IF;
4288:
4289: IF p_MODIFIERS_val_rec.modifier_level <> FND_API.G_MISS_CHAR
4290: THEN
4291:
4292: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4293:
4288:
4289: IF p_MODIFIERS_val_rec.modifier_level <> FND_API.G_MISS_CHAR
4290: THEN
4291:
4292: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4293:
4294: l_MODIFIERS_rec.modifier_level_code := p_MODIFIERS_rec.modifier_level_code;
4295:
4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4307: l_MODIFIERS_rec.modifier_level_code := QP_Value_To_Id.modifier_level
4308: ( p_modifier_level => p_MODIFIERS_val_rec.modifier_level
4309: );
4310:
4311: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
4312: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4313: END IF;
4314:
4315: END IF;
4308: ( p_modifier_level => p_MODIFIERS_val_rec.modifier_level
4309: );
4310:
4311: IF l_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
4312: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4313: END IF;
4314:
4315: END IF;
4316:
4315: END IF;
4316:
4317: END IF;
4318:
4319: IF p_MODIFIERS_val_rec.organization <> FND_API.G_MISS_CHAR
4320: THEN
4321:
4322: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4323:
4318:
4319: IF p_MODIFIERS_val_rec.organization <> FND_API.G_MISS_CHAR
4320: THEN
4321:
4322: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4323:
4324: l_MODIFIERS_rec.organization_id := p_MODIFIERS_rec.organization_id;
4325:
4326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4337: l_MODIFIERS_rec.organization_id := QP_Value_To_Id.organization
4338: ( p_organization => p_MODIFIERS_val_rec.organization
4339: );
4340:
4341: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
4342: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4343: END IF;
4344:
4345: END IF;
4338: ( p_organization => p_MODIFIERS_val_rec.organization
4339: );
4340:
4341: IF l_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM THEN
4342: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4343: END IF;
4344:
4345: END IF;
4346:
4345: END IF;
4346:
4347: END IF;
4348:
4349: IF p_MODIFIERS_val_rec.override <> FND_API.G_MISS_CHAR
4350: THEN
4351:
4352: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4353:
4348:
4349: IF p_MODIFIERS_val_rec.override <> FND_API.G_MISS_CHAR
4350: THEN
4351:
4352: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4353:
4354: l_MODIFIERS_rec.override_flag := p_MODIFIERS_rec.override_flag;
4355:
4356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4367: l_MODIFIERS_rec.override_flag := QP_Value_To_Id.override
4368: ( p_override => p_MODIFIERS_val_rec.override
4369: );
4370:
4371: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
4372: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4373: END IF;
4374:
4375: END IF;
4368: ( p_override => p_MODIFIERS_val_rec.override
4369: );
4370:
4371: IF l_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR THEN
4372: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4373: END IF;
4374:
4375: END IF;
4376:
4375: END IF;
4376:
4377: END IF;
4378:
4379: IF p_MODIFIERS_val_rec.price_break_type <> FND_API.G_MISS_CHAR
4380: THEN
4381:
4382: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4383:
4378:
4379: IF p_MODIFIERS_val_rec.price_break_type <> FND_API.G_MISS_CHAR
4380: THEN
4381:
4382: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4383:
4384: l_MODIFIERS_rec.price_break_type_code := p_MODIFIERS_rec.price_break_type_code;
4385:
4386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4397: l_MODIFIERS_rec.price_break_type_code := QP_Value_To_Id.price_break_type
4398: ( p_price_break_type => p_MODIFIERS_val_rec.price_break_type
4399: );
4400:
4401: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
4402: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4403: END IF;
4404:
4405: END IF;
4398: ( p_price_break_type => p_MODIFIERS_val_rec.price_break_type
4399: );
4400:
4401: IF l_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
4402: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4403: END IF;
4404:
4405: END IF;
4406:
4405: END IF;
4406:
4407: END IF;
4408:
4409: IF p_MODIFIERS_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
4410: THEN
4411:
4412: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4413:
4408:
4409: IF p_MODIFIERS_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
4410: THEN
4411:
4412: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4413:
4414: l_MODIFIERS_rec.price_by_formula_id := p_MODIFIERS_rec.price_by_formula_id;
4415:
4416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4427: l_MODIFIERS_rec.price_by_formula_id := QP_Value_To_Id.price_by_formula
4428: ( p_price_by_formula => p_MODIFIERS_val_rec.price_by_formula
4429: );
4430:
4431: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
4432: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4433: END IF;
4434:
4435: END IF;
4428: ( p_price_by_formula => p_MODIFIERS_val_rec.price_by_formula
4429: );
4430:
4431: IF l_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
4432: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4433: END IF;
4434:
4435: END IF;
4436:
4435: END IF;
4436:
4437: END IF;
4438:
4439: IF p_MODIFIERS_val_rec.primary_uom <> FND_API.G_MISS_CHAR
4440: THEN
4441:
4442: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4443:
4438:
4439: IF p_MODIFIERS_val_rec.primary_uom <> FND_API.G_MISS_CHAR
4440: THEN
4441:
4442: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4443:
4444: l_MODIFIERS_rec.primary_uom_flag := p_MODIFIERS_rec.primary_uom_flag;
4445:
4446: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4457: l_MODIFIERS_rec.primary_uom_flag := QP_Value_To_Id.primary_uom
4458: ( p_primary_uom => p_MODIFIERS_val_rec.primary_uom
4459: );
4460:
4461: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
4462: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4463: END IF;
4464:
4465: END IF;
4458: ( p_primary_uom => p_MODIFIERS_val_rec.primary_uom
4459: );
4460:
4461: IF l_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
4462: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4463: END IF;
4464:
4465: END IF;
4466:
4465: END IF;
4466:
4467: END IF;
4468:
4469: IF p_MODIFIERS_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
4470: THEN
4471:
4472: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4473:
4468:
4469: IF p_MODIFIERS_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
4470: THEN
4471:
4472: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4473:
4474: l_MODIFIERS_rec.print_on_invoice_flag := p_MODIFIERS_rec.print_on_invoice_flag;
4475:
4476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4487: l_MODIFIERS_rec.print_on_invoice_flag := QP_Value_To_Id.print_on_invoice
4488: ( p_print_on_invoice => p_MODIFIERS_val_rec.print_on_invoice
4489: );
4490:
4491: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
4492: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4493: END IF;
4494:
4495: END IF;
4488: ( p_print_on_invoice => p_MODIFIERS_val_rec.print_on_invoice
4489: );
4490:
4491: IF l_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
4492: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4493: END IF;
4494:
4495: END IF;
4496:
4495: END IF;
4496:
4497: END IF;
4498:
4499: IF p_MODIFIERS_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
4500: THEN
4501:
4502: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4503:
4498:
4499: IF p_MODIFIERS_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
4500: THEN
4501:
4502: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4503:
4504: l_MODIFIERS_rec.rebate_trxn_type_code := p_MODIFIERS_rec.rebate_trxn_type_code;
4505:
4506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4517: l_MODIFIERS_rec.rebate_trxn_type_code := QP_Value_To_Id.rebate_transaction_type
4518: ( p_rebate_transaction_type => p_MODIFIERS_val_rec.rebate_transaction_type
4519: );
4520:
4521: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
4522: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4523: END IF;
4524:
4525: END IF;
4518: ( p_rebate_transaction_type => p_MODIFIERS_val_rec.rebate_transaction_type
4519: );
4520:
4521: IF l_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
4522: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4523: END IF;
4524:
4525: END IF;
4526:
4525: END IF;
4526:
4527: END IF;
4528:
4529: IF p_MODIFIERS_val_rec.related_item <> FND_API.G_MISS_CHAR
4530: THEN
4531:
4532: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4533:
4528:
4529: IF p_MODIFIERS_val_rec.related_item <> FND_API.G_MISS_CHAR
4530: THEN
4531:
4532: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4533:
4534: l_MODIFIERS_rec.related_item_id := p_MODIFIERS_rec.related_item_id;
4535:
4536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4547: l_MODIFIERS_rec.related_item_id := QP_Value_To_Id.related_item
4548: ( p_related_item => p_MODIFIERS_val_rec.related_item
4549: );
4550:
4551: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
4552: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4553: END IF;
4554:
4555: END IF;
4548: ( p_related_item => p_MODIFIERS_val_rec.related_item
4549: );
4550:
4551: IF l_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM THEN
4552: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4553: END IF;
4554:
4555: END IF;
4556:
4555: END IF;
4556:
4557: END IF;
4558:
4559: IF p_MODIFIERS_val_rec.relationship_type <> FND_API.G_MISS_CHAR
4560: THEN
4561:
4562: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4563:
4558:
4559: IF p_MODIFIERS_val_rec.relationship_type <> FND_API.G_MISS_CHAR
4560: THEN
4561:
4562: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4563:
4564: l_MODIFIERS_rec.relationship_type_id := p_MODIFIERS_rec.relationship_type_id;
4565:
4566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4577: l_MODIFIERS_rec.relationship_type_id := QP_Value_To_Id.relationship_type
4578: ( p_relationship_type => p_MODIFIERS_val_rec.relationship_type
4579: );
4580:
4581: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
4582: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4583: END IF;
4584:
4585: END IF;
4578: ( p_relationship_type => p_MODIFIERS_val_rec.relationship_type
4579: );
4580:
4581: IF l_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
4582: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4583: END IF;
4584:
4585: END IF;
4586:
4585: END IF;
4586:
4587: END IF;
4588:
4589: IF p_MODIFIERS_val_rec.reprice <> FND_API.G_MISS_CHAR
4590: THEN
4591:
4592: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4593:
4588:
4589: IF p_MODIFIERS_val_rec.reprice <> FND_API.G_MISS_CHAR
4590: THEN
4591:
4592: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4593:
4594: l_MODIFIERS_rec.reprice_flag := p_MODIFIERS_rec.reprice_flag;
4595:
4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4607: l_MODIFIERS_rec.reprice_flag := QP_Value_To_Id.reprice
4608: ( p_reprice => p_MODIFIERS_val_rec.reprice
4609: );
4610:
4611: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
4612: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4613: END IF;
4614:
4615: END IF;
4608: ( p_reprice => p_MODIFIERS_val_rec.reprice
4609: );
4610:
4611: IF l_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
4612: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4613: END IF;
4614:
4615: END IF;
4616:
4615: END IF;
4616:
4617: END IF;
4618:
4619: IF p_MODIFIERS_val_rec.revision_reason <> FND_API.G_MISS_CHAR
4620: THEN
4621:
4622: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4623:
4618:
4619: IF p_MODIFIERS_val_rec.revision_reason <> FND_API.G_MISS_CHAR
4620: THEN
4621:
4622: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4623:
4624: l_MODIFIERS_rec.revision_reason_code := p_MODIFIERS_rec.revision_reason_code;
4625:
4626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4637: l_MODIFIERS_rec.revision_reason_code := QP_Value_To_Id.revision_reason
4638: ( p_revision_reason => p_MODIFIERS_val_rec.revision_reason
4639: );
4640:
4641: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
4642: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4643: END IF;
4644:
4645: END IF;
4638: ( p_revision_reason => p_MODIFIERS_val_rec.revision_reason
4639: );
4640:
4641: IF l_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
4642: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4643: END IF;
4644:
4645: END IF;
4646:
4782: x_return_status => l_return_status);
4783: END IF;
4784:
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_ERROR THEN
4787: RAISE;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE;
4790: WHEN OTHERS THEN
4784:
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_ERROR THEN
4787: RAISE;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE;
4790: WHEN OTHERS THEN
4791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4792: THEN
4794: ( G_PKG_NAME
4795: , 'Pre_Write_Process'
4796: );
4797: END IF;
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: END Pre_Write_Process;
4800:
4801: ------------------------------fix for bug 3756625
4802: Procedure Log_Update_Phases_DL(p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type,