7741: END IF;
7742: CLOSE desc_flex_exists;
7743:
7744:
7745: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
7746:
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7743:
7744:
7745: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
7746:
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7744:
7745: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
7746:
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7745: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
7746:
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7746:
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7747: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7748: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7749: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7750: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7751: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7752: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7753: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7754: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7762: /* Bugfix 2531340 */
7755: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7762: /* Bugfix 2531340 */
7763: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
7756: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7762: /* Bugfix 2531340 */
7763: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
7764: THEN
7757: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
7758: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7762: /* Bugfix 2531340 */
7763: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
7764: THEN
7765:
7759: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
7760: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
7761: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
7762: /* Bugfix 2531340 */
7763: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
7764: THEN
7765:
7766: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
7767: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
7768: FND_MSG_PUB.ADD ;
7769: p_return_status := FND_API.G_RET_STS_ERROR;
7770: END IF;
7771:
7772: l_count := fnd_flex_descval.segment_count;
7773:
7774: FOR i in 1..l_count LOOP
7775: l_col_name := fnd_flex_descval.segment_column_name(i);
7776:
7771:
7772: l_count := fnd_flex_descval.segment_count;
7773:
7774: FOR i in 1..l_count LOOP
7775: l_col_name := fnd_flex_descval.segment_column_name(i);
7776:
7777: /* Bug fix 3184559
7778: The calls to fnd_flex_descval.segment_value(i) are replaced with
7779: fnd_flex_descval.segment_id(i)*/
7774: FOR i in 1..l_count LOOP
7775: l_col_name := fnd_flex_descval.segment_column_name(i);
7776:
7777: /* Bug fix 3184559
7778: The calls to fnd_flex_descval.segment_value(i) are replaced with
7779: fnd_flex_descval.segment_id(i)*/
7780: IF l_col_name = 'ATTRIBUTE1' THEN
7781: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
7782: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
7775: l_col_name := fnd_flex_descval.segment_column_name(i);
7776:
7777: /* Bug fix 3184559
7778: The calls to fnd_flex_descval.segment_value(i) are replaced with
7779: fnd_flex_descval.segment_id(i)*/
7780: IF l_col_name = 'ATTRIBUTE1' THEN
7781: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
7782: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
7783: /* Bugfix 2531340 */
7777: /* Bug fix 3184559
7778: The calls to fnd_flex_descval.segment_value(i) are replaced with
7779: fnd_flex_descval.segment_id(i)*/
7780: IF l_col_name = 'ATTRIBUTE1' THEN
7781: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
7782: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
7783: /* Bugfix 2531340 */
7784: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
7785: ELSIF l_col_name = 'ATTRIBUTE2' THEN
7780: IF l_col_name = 'ATTRIBUTE1' THEN
7781: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
7782: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
7783: /* Bugfix 2531340 */
7784: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
7785: ELSIF l_col_name = 'ATTRIBUTE2' THEN
7786: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
7787: ELSIF l_col_name = 'ATTRIBUTE3' THEN
7788: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
7782: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
7783: /* Bugfix 2531340 */
7784: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
7785: ELSIF l_col_name = 'ATTRIBUTE2' THEN
7786: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
7787: ELSIF l_col_name = 'ATTRIBUTE3' THEN
7788: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
7789: ELSIF l_col_name = 'ATTRIBUTE4' THEN
7790: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
7784: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
7785: ELSIF l_col_name = 'ATTRIBUTE2' THEN
7786: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
7787: ELSIF l_col_name = 'ATTRIBUTE3' THEN
7788: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
7789: ELSIF l_col_name = 'ATTRIBUTE4' THEN
7790: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
7791: ELSIF l_col_name = 'ATTRIBUTE5' THEN
7792: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
7786: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
7787: ELSIF l_col_name = 'ATTRIBUTE3' THEN
7788: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
7789: ELSIF l_col_name = 'ATTRIBUTE4' THEN
7790: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
7791: ELSIF l_col_name = 'ATTRIBUTE5' THEN
7792: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
7793: ELSIF l_col_name = 'ATTRIBUTE6' THEN
7794: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
7788: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
7789: ELSIF l_col_name = 'ATTRIBUTE4' THEN
7790: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
7791: ELSIF l_col_name = 'ATTRIBUTE5' THEN
7792: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
7793: ELSIF l_col_name = 'ATTRIBUTE6' THEN
7794: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
7795: ELSIF l_col_name = 'ATTRIBUTE7' THEN
7796: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
7790: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
7791: ELSIF l_col_name = 'ATTRIBUTE5' THEN
7792: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
7793: ELSIF l_col_name = 'ATTRIBUTE6' THEN
7794: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
7795: ELSIF l_col_name = 'ATTRIBUTE7' THEN
7796: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
7797: ELSIF l_col_name = 'ATTRIBUTE8' THEN
7798: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
7792: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
7793: ELSIF l_col_name = 'ATTRIBUTE6' THEN
7794: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
7795: ELSIF l_col_name = 'ATTRIBUTE7' THEN
7796: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
7797: ELSIF l_col_name = 'ATTRIBUTE8' THEN
7798: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
7799: ELSIF l_col_name = 'ATTRIBUTE9' THEN
7800: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
7794: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
7795: ELSIF l_col_name = 'ATTRIBUTE7' THEN
7796: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
7797: ELSIF l_col_name = 'ATTRIBUTE8' THEN
7798: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
7799: ELSIF l_col_name = 'ATTRIBUTE9' THEN
7800: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
7801: ELSIF l_col_name = 'ATTRIBUTE10' THEN
7802: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
7796: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
7797: ELSIF l_col_name = 'ATTRIBUTE8' THEN
7798: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
7799: ELSIF l_col_name = 'ATTRIBUTE9' THEN
7800: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
7801: ELSIF l_col_name = 'ATTRIBUTE10' THEN
7802: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
7803: ELSIF l_col_name = 'ATTRIBUTE11' THEN
7804: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
7798: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
7799: ELSIF l_col_name = 'ATTRIBUTE9' THEN
7800: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
7801: ELSIF l_col_name = 'ATTRIBUTE10' THEN
7802: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
7803: ELSIF l_col_name = 'ATTRIBUTE11' THEN
7804: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
7805: ELSIF l_col_name = 'ATTRIBUTE12' THEN
7806: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
7800: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
7801: ELSIF l_col_name = 'ATTRIBUTE10' THEN
7802: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
7803: ELSIF l_col_name = 'ATTRIBUTE11' THEN
7804: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
7805: ELSIF l_col_name = 'ATTRIBUTE12' THEN
7806: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
7807: ELSIF l_col_name = 'ATTRIBUTE13' THEN
7808: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
7802: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
7803: ELSIF l_col_name = 'ATTRIBUTE11' THEN
7804: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
7805: ELSIF l_col_name = 'ATTRIBUTE12' THEN
7806: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
7807: ELSIF l_col_name = 'ATTRIBUTE13' THEN
7808: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
7809: ELSIF l_col_name = 'ATTRIBUTE14' THEN
7810: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
7804: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
7805: ELSIF l_col_name = 'ATTRIBUTE12' THEN
7806: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
7807: ELSIF l_col_name = 'ATTRIBUTE13' THEN
7808: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
7809: ELSIF l_col_name = 'ATTRIBUTE14' THEN
7810: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
7811: ELSIF l_col_name = 'ATTRIBUTE15' THEN
7812: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
7806: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
7807: ELSIF l_col_name = 'ATTRIBUTE13' THEN
7808: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
7809: ELSIF l_col_name = 'ATTRIBUTE14' THEN
7810: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
7811: ELSIF l_col_name = 'ATTRIBUTE15' THEN
7812: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
7813: END IF;
7814:
7808: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
7809: ELSIF l_col_name = 'ATTRIBUTE14' THEN
7810: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
7811: ELSIF l_col_name = 'ATTRIBUTE15' THEN
7812: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
7813: END IF;
7814:
7815: IF i > l_count THEN
7816: EXIT;