1689: END IF;
1690: CLOSE desc_flex_exists;
1691:
1692:
1693: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1690: CLOSE desc_flex_exists;
1691:
1692:
1693: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1691:
1692:
1693: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1692:
1693: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1693: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1694: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1695: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1696: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1697: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1698: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1699: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1700: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1701: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1709:
1702: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1709:
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1703: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1709:
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1711: THEN
1704: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
1705: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1709:
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1711: THEN
1712:
1706: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
1707: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
1708: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
1709:
1710: IF ( NOT fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, p_value_or_id) )
1711: THEN
1712:
1713: FND_MESSAGE.SET_NAME('ASO', 'ASO_DESC_FLEX_INVALID');
1714: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
1713: FND_MESSAGE.SET_NAME('ASO', 'ASO_DESC_FLEX_INVALID');
1714: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
1715: FND_MSG_PUB.ADD ;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: l_error_msg := FND_FLEX_DESCVAL.error_message;
1718: FND_MESSAGE.SET_NAME('ASO', 'ASO_FLEX_INVALID_MSG');
1719: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_error_msg);
1720: FND_MSG_PUB.ADD ;
1721: END IF;
1719: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_error_msg);
1720: FND_MSG_PUB.ADD ;
1721: END IF;
1722:
1723: l_count := fnd_flex_descval.segment_count;
1724:
1725: FOR i in 1..l_count LOOP
1726: l_col_name := fnd_flex_descval.segment_column_name(i);
1727:
1722:
1723: l_count := fnd_flex_descval.segment_count;
1724:
1725: FOR i in 1..l_count LOOP
1726: l_col_name := fnd_flex_descval.segment_column_name(i);
1727:
1728: IF l_col_name = 'ATTRIBUTE1' THEN
1729: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_value(i);
1730: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
1725: FOR i in 1..l_count LOOP
1726: l_col_name := fnd_flex_descval.segment_column_name(i);
1727:
1728: IF l_col_name = 'ATTRIBUTE1' THEN
1729: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_value(i);
1730: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
1731: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_value(i);
1732: ELSIF l_col_name = 'ATTRIBUTE2' THEN
1733: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_value(i);
1727:
1728: IF l_col_name = 'ATTRIBUTE1' THEN
1729: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_value(i);
1730: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
1731: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_value(i);
1732: ELSIF l_col_name = 'ATTRIBUTE2' THEN
1733: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_value(i);
1734: ELSIF l_col_name = 'ATTRIBUTE3' THEN
1735: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_value(i);
1729: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_value(i);
1730: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
1731: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_value(i);
1732: ELSIF l_col_name = 'ATTRIBUTE2' THEN
1733: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_value(i);
1734: ELSIF l_col_name = 'ATTRIBUTE3' THEN
1735: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_value(i);
1736: ELSIF l_col_name = 'ATTRIBUTE4' THEN
1737: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_value(i);
1731: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_value(i);
1732: ELSIF l_col_name = 'ATTRIBUTE2' THEN
1733: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_value(i);
1734: ELSIF l_col_name = 'ATTRIBUTE3' THEN
1735: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_value(i);
1736: ELSIF l_col_name = 'ATTRIBUTE4' THEN
1737: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_value(i);
1738: ELSIF l_col_name = 'ATTRIBUTE5' THEN
1739: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_value(i);
1733: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_value(i);
1734: ELSIF l_col_name = 'ATTRIBUTE3' THEN
1735: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_value(i);
1736: ELSIF l_col_name = 'ATTRIBUTE4' THEN
1737: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_value(i);
1738: ELSIF l_col_name = 'ATTRIBUTE5' THEN
1739: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_value(i);
1740: ELSIF l_col_name = 'ATTRIBUTE6' THEN
1741: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_value(i);
1735: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_value(i);
1736: ELSIF l_col_name = 'ATTRIBUTE4' THEN
1737: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_value(i);
1738: ELSIF l_col_name = 'ATTRIBUTE5' THEN
1739: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_value(i);
1740: ELSIF l_col_name = 'ATTRIBUTE6' THEN
1741: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_value(i);
1742: ELSIF l_col_name = 'ATTRIBUTE7' THEN
1743: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_value(i);
1737: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_value(i);
1738: ELSIF l_col_name = 'ATTRIBUTE5' THEN
1739: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_value(i);
1740: ELSIF l_col_name = 'ATTRIBUTE6' THEN
1741: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_value(i);
1742: ELSIF l_col_name = 'ATTRIBUTE7' THEN
1743: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_value(i);
1744: ELSIF l_col_name = 'ATTRIBUTE8' THEN
1745: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_value(i);
1739: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_value(i);
1740: ELSIF l_col_name = 'ATTRIBUTE6' THEN
1741: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_value(i);
1742: ELSIF l_col_name = 'ATTRIBUTE7' THEN
1743: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_value(i);
1744: ELSIF l_col_name = 'ATTRIBUTE8' THEN
1745: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_value(i);
1746: ELSIF l_col_name = 'ATTRIBUTE9' THEN
1747: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_value(i);
1741: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_value(i);
1742: ELSIF l_col_name = 'ATTRIBUTE7' THEN
1743: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_value(i);
1744: ELSIF l_col_name = 'ATTRIBUTE8' THEN
1745: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_value(i);
1746: ELSIF l_col_name = 'ATTRIBUTE9' THEN
1747: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_value(i);
1748: ELSIF l_col_name = 'ATTRIBUTE10' THEN
1749: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_value(i);
1743: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_value(i);
1744: ELSIF l_col_name = 'ATTRIBUTE8' THEN
1745: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_value(i);
1746: ELSIF l_col_name = 'ATTRIBUTE9' THEN
1747: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_value(i);
1748: ELSIF l_col_name = 'ATTRIBUTE10' THEN
1749: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_value(i);
1750: ELSIF l_col_name = 'ATTRIBUTE11' THEN
1751: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_value(i);
1745: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_value(i);
1746: ELSIF l_col_name = 'ATTRIBUTE9' THEN
1747: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_value(i);
1748: ELSIF l_col_name = 'ATTRIBUTE10' THEN
1749: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_value(i);
1750: ELSIF l_col_name = 'ATTRIBUTE11' THEN
1751: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_value(i);
1752: ELSIF l_col_name = 'ATTRIBUTE12' THEN
1753: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_value(i);
1747: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_value(i);
1748: ELSIF l_col_name = 'ATTRIBUTE10' THEN
1749: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_value(i);
1750: ELSIF l_col_name = 'ATTRIBUTE11' THEN
1751: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_value(i);
1752: ELSIF l_col_name = 'ATTRIBUTE12' THEN
1753: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_value(i);
1754: ELSIF l_col_name = 'ATTRIBUTE13' THEN
1755: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_value(i);
1749: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_value(i);
1750: ELSIF l_col_name = 'ATTRIBUTE11' THEN
1751: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_value(i);
1752: ELSIF l_col_name = 'ATTRIBUTE12' THEN
1753: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_value(i);
1754: ELSIF l_col_name = 'ATTRIBUTE13' THEN
1755: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_value(i);
1756: ELSIF l_col_name = 'ATTRIBUTE14' THEN
1757: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_value(i);
1751: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_value(i);
1752: ELSIF l_col_name = 'ATTRIBUTE12' THEN
1753: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_value(i);
1754: ELSIF l_col_name = 'ATTRIBUTE13' THEN
1755: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_value(i);
1756: ELSIF l_col_name = 'ATTRIBUTE14' THEN
1757: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_value(i);
1758: ELSIF l_col_name = 'ATTRIBUTE15' THEN
1759: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_value(i);
1753: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_value(i);
1754: ELSIF l_col_name = 'ATTRIBUTE13' THEN
1755: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_value(i);
1756: ELSIF l_col_name = 'ATTRIBUTE14' THEN
1757: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_value(i);
1758: ELSIF l_col_name = 'ATTRIBUTE15' THEN
1759: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_value(i);
1760: END IF;
1761:
1755: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_value(i);
1756: ELSIF l_col_name = 'ATTRIBUTE14' THEN
1757: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_value(i);
1758: ELSIF l_col_name = 'ATTRIBUTE15' THEN
1759: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_value(i);
1760: END IF;
1761:
1762: IF i > l_count THEN
1763: EXIT;