948: CLOSE desc_flex_exists;
949:
950: IF p_desc_flex_name = 'RA_INTERCACE_LINES'
951: THEN
952: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_line_context);
953:
954: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
955: p_desc_flex_rec.interface_LINE_attribute1);
956: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
950: IF p_desc_flex_name = 'RA_INTERCACE_LINES'
951: THEN
952: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_line_context);
953:
954: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
955: p_desc_flex_rec.interface_LINE_attribute1);
956: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
957: p_desc_flex_rec.interface_LINE_attribute2);
958: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
952: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_line_context);
953:
954: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
955: p_desc_flex_rec.interface_LINE_attribute1);
956: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
957: p_desc_flex_rec.interface_LINE_attribute2);
958: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
959: p_desc_flex_rec.interface_LINE_attribute3);
960: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
954: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
955: p_desc_flex_rec.interface_LINE_attribute1);
956: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
957: p_desc_flex_rec.interface_LINE_attribute2);
958: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
959: p_desc_flex_rec.interface_LINE_attribute3);
960: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
961: p_desc_flex_rec.interface_LINE_attribute4);
962: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
956: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
957: p_desc_flex_rec.interface_LINE_attribute2);
958: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
959: p_desc_flex_rec.interface_LINE_attribute3);
960: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
961: p_desc_flex_rec.interface_LINE_attribute4);
962: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
963: p_desc_flex_rec.interface_LINE_attribute5);
964: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
958: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
959: p_desc_flex_rec.interface_LINE_attribute3);
960: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
961: p_desc_flex_rec.interface_LINE_attribute4);
962: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
963: p_desc_flex_rec.interface_LINE_attribute5);
964: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
965: p_desc_flex_rec.interface_LINE_attribute6);
966: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
960: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
961: p_desc_flex_rec.interface_LINE_attribute4);
962: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
963: p_desc_flex_rec.interface_LINE_attribute5);
964: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
965: p_desc_flex_rec.interface_LINE_attribute6);
966: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
967: p_desc_flex_rec.interface_LINE_attribute7);
968: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
962: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
963: p_desc_flex_rec.interface_LINE_attribute5);
964: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
965: p_desc_flex_rec.interface_LINE_attribute6);
966: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
967: p_desc_flex_rec.interface_LINE_attribute7);
968: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
969: p_desc_flex_rec.interface_LINE_attribute8);
970: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
964: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
965: p_desc_flex_rec.interface_LINE_attribute6);
966: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
967: p_desc_flex_rec.interface_LINE_attribute7);
968: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
969: p_desc_flex_rec.interface_LINE_attribute8);
970: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
971: p_desc_flex_rec.interface_LINE_attribute9);
972: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
966: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
967: p_desc_flex_rec.interface_LINE_attribute7);
968: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
969: p_desc_flex_rec.interface_LINE_attribute8);
970: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
971: p_desc_flex_rec.interface_LINE_attribute9);
972: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
973: p_desc_flex_rec.interface_LINE_attribute10);
974: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
968: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
969: p_desc_flex_rec.interface_LINE_attribute8);
970: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
971: p_desc_flex_rec.interface_LINE_attribute9);
972: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
973: p_desc_flex_rec.interface_LINE_attribute10);
974: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
975: p_desc_flex_rec.interface_LINE_attribute11);
976: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
970: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
971: p_desc_flex_rec.interface_LINE_attribute9);
972: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
973: p_desc_flex_rec.interface_LINE_attribute10);
974: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
975: p_desc_flex_rec.interface_LINE_attribute11);
976: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
977: p_desc_flex_rec.interface_LINE_attribute12);
978: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
972: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
973: p_desc_flex_rec.interface_LINE_attribute10);
974: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
975: p_desc_flex_rec.interface_LINE_attribute11);
976: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
977: p_desc_flex_rec.interface_LINE_attribute12);
978: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
979: p_desc_flex_rec.interface_LINE_attribute13);
980: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
974: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
975: p_desc_flex_rec.interface_LINE_attribute11);
976: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
977: p_desc_flex_rec.interface_LINE_attribute12);
978: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
979: p_desc_flex_rec.interface_LINE_attribute13);
980: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
981: p_desc_flex_rec.interface_LINE_attribute14);
982: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
976: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
977: p_desc_flex_rec.interface_LINE_attribute12);
978: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
979: p_desc_flex_rec.interface_LINE_attribute13);
980: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
981: p_desc_flex_rec.interface_LINE_attribute14);
982: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
983: p_desc_flex_rec.interface_LINE_attribute15);
984:
978: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
979: p_desc_flex_rec.interface_LINE_attribute13);
980: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
981: p_desc_flex_rec.interface_LINE_attribute14);
982: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
983: p_desc_flex_rec.interface_LINE_attribute15);
984:
985:
986: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
982: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
983: p_desc_flex_rec.interface_LINE_attribute15);
984:
985:
986: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
987: THEN
988: p_return_status := FND_API.G_RET_STS_ERROR;
989: END IF;
990:
987: THEN
988: p_return_status := FND_API.G_RET_STS_ERROR;
989: END IF;
990:
991: l_count := fnd_flex_descval.segment_count;
992:
993:
994: FOR i in 1..l_count LOOP
995: l_col_name := fnd_flex_descval.segment_column_name(i);
991: l_count := fnd_flex_descval.segment_count;
992:
993:
994: FOR i in 1..l_count LOOP
995: l_col_name := fnd_flex_descval.segment_column_name(i);
996:
997: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
998: p_desc_flex_rec.INTERFACE_LINE_attribute1 := fnd_flex_descval.segment_id(i);
999: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
994: FOR i in 1..l_count LOOP
995: l_col_name := fnd_flex_descval.segment_column_name(i);
996:
997: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
998: p_desc_flex_rec.INTERFACE_LINE_attribute1 := fnd_flex_descval.segment_id(i);
999: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
1000: p_desc_flex_rec.interface_LINE_context := fnd_flex_descval.segment_id(i);
1001: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
1002: p_desc_flex_rec.INTERFACE_LINE_attribute2 := fnd_flex_descval.segment_id(i);
996:
997: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
998: p_desc_flex_rec.INTERFACE_LINE_attribute1 := fnd_flex_descval.segment_id(i);
999: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
1000: p_desc_flex_rec.interface_LINE_context := fnd_flex_descval.segment_id(i);
1001: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
1002: p_desc_flex_rec.INTERFACE_LINE_attribute2 := fnd_flex_descval.segment_id(i);
1003: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
1004: p_desc_flex_rec.INTERFACE_LINE_attribute3 := fnd_flex_descval.segment_id(i);
998: p_desc_flex_rec.INTERFACE_LINE_attribute1 := fnd_flex_descval.segment_id(i);
999: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
1000: p_desc_flex_rec.interface_LINE_context := fnd_flex_descval.segment_id(i);
1001: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
1002: p_desc_flex_rec.INTERFACE_LINE_attribute2 := fnd_flex_descval.segment_id(i);
1003: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
1004: p_desc_flex_rec.INTERFACE_LINE_attribute3 := fnd_flex_descval.segment_id(i);
1005: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
1006: p_desc_flex_rec.INTERFACE_LINE_attribute4 := fnd_flex_descval.segment_id(i);
1000: p_desc_flex_rec.interface_LINE_context := fnd_flex_descval.segment_id(i);
1001: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
1002: p_desc_flex_rec.INTERFACE_LINE_attribute2 := fnd_flex_descval.segment_id(i);
1003: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
1004: p_desc_flex_rec.INTERFACE_LINE_attribute3 := fnd_flex_descval.segment_id(i);
1005: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
1006: p_desc_flex_rec.INTERFACE_LINE_attribute4 := fnd_flex_descval.segment_id(i);
1007: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
1008: p_desc_flex_rec.INTERFACE_LINE_attribute5 := fnd_flex_descval.segment_id(i);
1002: p_desc_flex_rec.INTERFACE_LINE_attribute2 := fnd_flex_descval.segment_id(i);
1003: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
1004: p_desc_flex_rec.INTERFACE_LINE_attribute3 := fnd_flex_descval.segment_id(i);
1005: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
1006: p_desc_flex_rec.INTERFACE_LINE_attribute4 := fnd_flex_descval.segment_id(i);
1007: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
1008: p_desc_flex_rec.INTERFACE_LINE_attribute5 := fnd_flex_descval.segment_id(i);
1009: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
1010: p_desc_flex_rec.INTERFACE_LINE_attribute6 := fnd_flex_descval.segment_id(i);
1004: p_desc_flex_rec.INTERFACE_LINE_attribute3 := fnd_flex_descval.segment_id(i);
1005: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
1006: p_desc_flex_rec.INTERFACE_LINE_attribute4 := fnd_flex_descval.segment_id(i);
1007: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
1008: p_desc_flex_rec.INTERFACE_LINE_attribute5 := fnd_flex_descval.segment_id(i);
1009: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
1010: p_desc_flex_rec.INTERFACE_LINE_attribute6 := fnd_flex_descval.segment_id(i);
1011: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
1012: p_desc_flex_rec.INTERFACE_LINE_attribute7 := fnd_flex_descval.segment_id(i);
1006: p_desc_flex_rec.INTERFACE_LINE_attribute4 := fnd_flex_descval.segment_id(i);
1007: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
1008: p_desc_flex_rec.INTERFACE_LINE_attribute5 := fnd_flex_descval.segment_id(i);
1009: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
1010: p_desc_flex_rec.INTERFACE_LINE_attribute6 := fnd_flex_descval.segment_id(i);
1011: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
1012: p_desc_flex_rec.INTERFACE_LINE_attribute7 := fnd_flex_descval.segment_id(i);
1013: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
1014: p_desc_flex_rec.INTERFACE_LINE_attribute8 := fnd_flex_descval.segment_id(i);
1008: p_desc_flex_rec.INTERFACE_LINE_attribute5 := fnd_flex_descval.segment_id(i);
1009: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
1010: p_desc_flex_rec.INTERFACE_LINE_attribute6 := fnd_flex_descval.segment_id(i);
1011: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
1012: p_desc_flex_rec.INTERFACE_LINE_attribute7 := fnd_flex_descval.segment_id(i);
1013: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
1014: p_desc_flex_rec.INTERFACE_LINE_attribute8 := fnd_flex_descval.segment_id(i);
1015: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
1016: p_desc_flex_rec.INTERFACE_LINE_attribute9 := fnd_flex_descval.segment_id(i);
1010: p_desc_flex_rec.INTERFACE_LINE_attribute6 := fnd_flex_descval.segment_id(i);
1011: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
1012: p_desc_flex_rec.INTERFACE_LINE_attribute7 := fnd_flex_descval.segment_id(i);
1013: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
1014: p_desc_flex_rec.INTERFACE_LINE_attribute8 := fnd_flex_descval.segment_id(i);
1015: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
1016: p_desc_flex_rec.INTERFACE_LINE_attribute9 := fnd_flex_descval.segment_id(i);
1017: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
1018: p_desc_flex_rec.INTERFACE_LINE_attribute10 := fnd_flex_descval.segment_id(i);
1012: p_desc_flex_rec.INTERFACE_LINE_attribute7 := fnd_flex_descval.segment_id(i);
1013: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
1014: p_desc_flex_rec.INTERFACE_LINE_attribute8 := fnd_flex_descval.segment_id(i);
1015: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
1016: p_desc_flex_rec.INTERFACE_LINE_attribute9 := fnd_flex_descval.segment_id(i);
1017: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
1018: p_desc_flex_rec.INTERFACE_LINE_attribute10 := fnd_flex_descval.segment_id(i);
1019: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
1020: p_desc_flex_rec.INTERFACE_LINE_attribute11 := fnd_flex_descval.segment_id(i);
1014: p_desc_flex_rec.INTERFACE_LINE_attribute8 := fnd_flex_descval.segment_id(i);
1015: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
1016: p_desc_flex_rec.INTERFACE_LINE_attribute9 := fnd_flex_descval.segment_id(i);
1017: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
1018: p_desc_flex_rec.INTERFACE_LINE_attribute10 := fnd_flex_descval.segment_id(i);
1019: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
1020: p_desc_flex_rec.INTERFACE_LINE_attribute11 := fnd_flex_descval.segment_id(i);
1021: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
1022: p_desc_flex_rec.INTERFACE_LINE_attribute12 := fnd_flex_descval.segment_id(i);
1016: p_desc_flex_rec.INTERFACE_LINE_attribute9 := fnd_flex_descval.segment_id(i);
1017: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
1018: p_desc_flex_rec.INTERFACE_LINE_attribute10 := fnd_flex_descval.segment_id(i);
1019: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
1020: p_desc_flex_rec.INTERFACE_LINE_attribute11 := fnd_flex_descval.segment_id(i);
1021: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
1022: p_desc_flex_rec.INTERFACE_LINE_attribute12 := fnd_flex_descval.segment_id(i);
1023: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
1024: p_desc_flex_rec.INTERFACE_LINE_attribute13 := fnd_flex_descval.segment_id(i);
1018: p_desc_flex_rec.INTERFACE_LINE_attribute10 := fnd_flex_descval.segment_id(i);
1019: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
1020: p_desc_flex_rec.INTERFACE_LINE_attribute11 := fnd_flex_descval.segment_id(i);
1021: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
1022: p_desc_flex_rec.INTERFACE_LINE_attribute12 := fnd_flex_descval.segment_id(i);
1023: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
1024: p_desc_flex_rec.INTERFACE_LINE_attribute13 := fnd_flex_descval.segment_id(i);
1025: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
1026: p_desc_flex_rec.INTERFACE_LINE_attribute14 := fnd_flex_descval.segment_id(i);
1020: p_desc_flex_rec.INTERFACE_LINE_attribute11 := fnd_flex_descval.segment_id(i);
1021: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
1022: p_desc_flex_rec.INTERFACE_LINE_attribute12 := fnd_flex_descval.segment_id(i);
1023: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
1024: p_desc_flex_rec.INTERFACE_LINE_attribute13 := fnd_flex_descval.segment_id(i);
1025: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
1026: p_desc_flex_rec.INTERFACE_LINE_attribute14 := fnd_flex_descval.segment_id(i);
1027: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
1028: p_desc_flex_rec.INTERFACE_LINE_attribute15 := fnd_flex_descval.segment_id(i);
1022: p_desc_flex_rec.INTERFACE_LINE_attribute12 := fnd_flex_descval.segment_id(i);
1023: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
1024: p_desc_flex_rec.INTERFACE_LINE_attribute13 := fnd_flex_descval.segment_id(i);
1025: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
1026: p_desc_flex_rec.INTERFACE_LINE_attribute14 := fnd_flex_descval.segment_id(i);
1027: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
1028: p_desc_flex_rec.INTERFACE_LINE_attribute15 := fnd_flex_descval.segment_id(i);
1029: END IF;
1030:
1024: p_desc_flex_rec.INTERFACE_LINE_attribute13 := fnd_flex_descval.segment_id(i);
1025: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
1026: p_desc_flex_rec.INTERFACE_LINE_attribute14 := fnd_flex_descval.segment_id(i);
1027: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
1028: p_desc_flex_rec.INTERFACE_LINE_attribute15 := fnd_flex_descval.segment_id(i);
1029: END IF;
1030:
1031: IF i > l_count THEN
1032: EXIT;
1069: CLOSE desc_flex_exists;
1070:
1071: IF p_desc_flex_name = 'RA_INTERFACE_HEADER'
1072: THEN
1073: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_header_context);
1074:
1075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
1076: p_desc_flex_rec.interface_header_attribute1);
1077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
1071: IF p_desc_flex_name = 'RA_INTERFACE_HEADER'
1072: THEN
1073: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_header_context);
1074:
1075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
1076: p_desc_flex_rec.interface_header_attribute1);
1077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
1078: p_desc_flex_rec.interface_header_attribute2);
1079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
1073: fnd_flex_descval.set_context_value(p_desc_flex_rec.interface_header_context);
1074:
1075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
1076: p_desc_flex_rec.interface_header_attribute1);
1077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
1078: p_desc_flex_rec.interface_header_attribute2);
1079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
1080: p_desc_flex_rec.interface_header_attribute3);
1081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
1075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
1076: p_desc_flex_rec.interface_header_attribute1);
1077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
1078: p_desc_flex_rec.interface_header_attribute2);
1079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
1080: p_desc_flex_rec.interface_header_attribute3);
1081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
1082: p_desc_flex_rec.interface_header_attribute4);
1083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
1077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
1078: p_desc_flex_rec.interface_header_attribute2);
1079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
1080: p_desc_flex_rec.interface_header_attribute3);
1081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
1082: p_desc_flex_rec.interface_header_attribute4);
1083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
1084: p_desc_flex_rec.interface_header_attribute5);
1085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
1079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
1080: p_desc_flex_rec.interface_header_attribute3);
1081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
1082: p_desc_flex_rec.interface_header_attribute4);
1083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
1084: p_desc_flex_rec.interface_header_attribute5);
1085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
1086: p_desc_flex_rec.interface_header_attribute6);
1087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
1081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
1082: p_desc_flex_rec.interface_header_attribute4);
1083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
1084: p_desc_flex_rec.interface_header_attribute5);
1085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
1086: p_desc_flex_rec.interface_header_attribute6);
1087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
1088: p_desc_flex_rec.interface_header_attribute7);
1089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
1083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
1084: p_desc_flex_rec.interface_header_attribute5);
1085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
1086: p_desc_flex_rec.interface_header_attribute6);
1087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
1088: p_desc_flex_rec.interface_header_attribute7);
1089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
1090: p_desc_flex_rec.interface_header_attribute8);
1091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
1085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
1086: p_desc_flex_rec.interface_header_attribute6);
1087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
1088: p_desc_flex_rec.interface_header_attribute7);
1089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
1090: p_desc_flex_rec.interface_header_attribute8);
1091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
1092: p_desc_flex_rec.interface_header_attribute9);
1093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
1087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
1088: p_desc_flex_rec.interface_header_attribute7);
1089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
1090: p_desc_flex_rec.interface_header_attribute8);
1091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
1092: p_desc_flex_rec.interface_header_attribute9);
1093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
1094: p_desc_flex_rec.interface_header_attribute10);
1095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
1089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
1090: p_desc_flex_rec.interface_header_attribute8);
1091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
1092: p_desc_flex_rec.interface_header_attribute9);
1093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
1094: p_desc_flex_rec.interface_header_attribute10);
1095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
1096: p_desc_flex_rec.interface_header_attribute11);
1097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
1091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
1092: p_desc_flex_rec.interface_header_attribute9);
1093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
1094: p_desc_flex_rec.interface_header_attribute10);
1095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
1096: p_desc_flex_rec.interface_header_attribute11);
1097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
1098: p_desc_flex_rec.interface_header_attribute12);
1099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
1093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
1094: p_desc_flex_rec.interface_header_attribute10);
1095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
1096: p_desc_flex_rec.interface_header_attribute11);
1097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
1098: p_desc_flex_rec.interface_header_attribute12);
1099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
1100: p_desc_flex_rec.interface_header_attribute13);
1101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
1095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
1096: p_desc_flex_rec.interface_header_attribute11);
1097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
1098: p_desc_flex_rec.interface_header_attribute12);
1099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
1100: p_desc_flex_rec.interface_header_attribute13);
1101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
1102: p_desc_flex_rec.interface_header_attribute14);
1103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
1097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
1098: p_desc_flex_rec.interface_header_attribute12);
1099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
1100: p_desc_flex_rec.interface_header_attribute13);
1101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
1102: p_desc_flex_rec.interface_header_attribute14);
1103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
1104: p_desc_flex_rec.interface_header_attribute15);
1105:
1099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
1100: p_desc_flex_rec.interface_header_attribute13);
1101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
1102: p_desc_flex_rec.interface_header_attribute14);
1103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
1104: p_desc_flex_rec.interface_header_attribute15);
1105:
1106:
1107: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
1104: p_desc_flex_rec.interface_header_attribute15);
1105:
1106:
1107: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1108: THEN
1109: p_return_status := FND_API.G_RET_STS_ERROR;
1110: END IF;
1111:
1108: THEN
1109: p_return_status := FND_API.G_RET_STS_ERROR;
1110: END IF;
1111:
1112: l_count := fnd_flex_descval.segment_count;
1113:
1114:
1115: FOR i in 1..l_count LOOP
1116: l_col_name := fnd_flex_descval.segment_column_name(i);
1112: l_count := fnd_flex_descval.segment_count;
1113:
1114:
1115: FOR i in 1..l_count LOOP
1116: l_col_name := fnd_flex_descval.segment_column_name(i);
1117:
1118: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
1119: p_desc_flex_rec.INTERFACE_HEADER_attribute1 := fnd_flex_descval.segment_id(i);
1120: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
1115: FOR i in 1..l_count LOOP
1116: l_col_name := fnd_flex_descval.segment_column_name(i);
1117:
1118: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
1119: p_desc_flex_rec.INTERFACE_HEADER_attribute1 := fnd_flex_descval.segment_id(i);
1120: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
1121: p_desc_flex_rec.interface_header_context := fnd_flex_descval.segment_id(i);
1122: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
1123: p_desc_flex_rec.INTERFACE_HEADER_attribute2 := fnd_flex_descval.segment_id(i);
1117:
1118: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
1119: p_desc_flex_rec.INTERFACE_HEADER_attribute1 := fnd_flex_descval.segment_id(i);
1120: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
1121: p_desc_flex_rec.interface_header_context := fnd_flex_descval.segment_id(i);
1122: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
1123: p_desc_flex_rec.INTERFACE_HEADER_attribute2 := fnd_flex_descval.segment_id(i);
1124: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
1125: p_desc_flex_rec.INTERFACE_HEADER_attribute3 := fnd_flex_descval.segment_id(i);
1119: p_desc_flex_rec.INTERFACE_HEADER_attribute1 := fnd_flex_descval.segment_id(i);
1120: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
1121: p_desc_flex_rec.interface_header_context := fnd_flex_descval.segment_id(i);
1122: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
1123: p_desc_flex_rec.INTERFACE_HEADER_attribute2 := fnd_flex_descval.segment_id(i);
1124: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
1125: p_desc_flex_rec.INTERFACE_HEADER_attribute3 := fnd_flex_descval.segment_id(i);
1126: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
1127: p_desc_flex_rec.INTERFACE_HEADER_attribute4 := fnd_flex_descval.segment_id(i);
1121: p_desc_flex_rec.interface_header_context := fnd_flex_descval.segment_id(i);
1122: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
1123: p_desc_flex_rec.INTERFACE_HEADER_attribute2 := fnd_flex_descval.segment_id(i);
1124: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
1125: p_desc_flex_rec.INTERFACE_HEADER_attribute3 := fnd_flex_descval.segment_id(i);
1126: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
1127: p_desc_flex_rec.INTERFACE_HEADER_attribute4 := fnd_flex_descval.segment_id(i);
1128: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
1129: p_desc_flex_rec.INTERFACE_HEADER_attribute5 := fnd_flex_descval.segment_id(i);
1123: p_desc_flex_rec.INTERFACE_HEADER_attribute2 := fnd_flex_descval.segment_id(i);
1124: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
1125: p_desc_flex_rec.INTERFACE_HEADER_attribute3 := fnd_flex_descval.segment_id(i);
1126: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
1127: p_desc_flex_rec.INTERFACE_HEADER_attribute4 := fnd_flex_descval.segment_id(i);
1128: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
1129: p_desc_flex_rec.INTERFACE_HEADER_attribute5 := fnd_flex_descval.segment_id(i);
1130: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
1131: p_desc_flex_rec.INTERFACE_HEADER_attribute6 := fnd_flex_descval.segment_id(i);
1125: p_desc_flex_rec.INTERFACE_HEADER_attribute3 := fnd_flex_descval.segment_id(i);
1126: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
1127: p_desc_flex_rec.INTERFACE_HEADER_attribute4 := fnd_flex_descval.segment_id(i);
1128: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
1129: p_desc_flex_rec.INTERFACE_HEADER_attribute5 := fnd_flex_descval.segment_id(i);
1130: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
1131: p_desc_flex_rec.INTERFACE_HEADER_attribute6 := fnd_flex_descval.segment_id(i);
1132: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
1133: p_desc_flex_rec.INTERFACE_HEADER_attribute7 := fnd_flex_descval.segment_id(i);
1127: p_desc_flex_rec.INTERFACE_HEADER_attribute4 := fnd_flex_descval.segment_id(i);
1128: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
1129: p_desc_flex_rec.INTERFACE_HEADER_attribute5 := fnd_flex_descval.segment_id(i);
1130: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
1131: p_desc_flex_rec.INTERFACE_HEADER_attribute6 := fnd_flex_descval.segment_id(i);
1132: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
1133: p_desc_flex_rec.INTERFACE_HEADER_attribute7 := fnd_flex_descval.segment_id(i);
1134: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
1135: p_desc_flex_rec.INTERFACE_HEADER_attribute8 := fnd_flex_descval.segment_id(i);
1129: p_desc_flex_rec.INTERFACE_HEADER_attribute5 := fnd_flex_descval.segment_id(i);
1130: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
1131: p_desc_flex_rec.INTERFACE_HEADER_attribute6 := fnd_flex_descval.segment_id(i);
1132: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
1133: p_desc_flex_rec.INTERFACE_HEADER_attribute7 := fnd_flex_descval.segment_id(i);
1134: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
1135: p_desc_flex_rec.INTERFACE_HEADER_attribute8 := fnd_flex_descval.segment_id(i);
1136: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
1137: p_desc_flex_rec.INTERFACE_HEADER_attribute9 := fnd_flex_descval.segment_id(i);
1131: p_desc_flex_rec.INTERFACE_HEADER_attribute6 := fnd_flex_descval.segment_id(i);
1132: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
1133: p_desc_flex_rec.INTERFACE_HEADER_attribute7 := fnd_flex_descval.segment_id(i);
1134: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
1135: p_desc_flex_rec.INTERFACE_HEADER_attribute8 := fnd_flex_descval.segment_id(i);
1136: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
1137: p_desc_flex_rec.INTERFACE_HEADER_attribute9 := fnd_flex_descval.segment_id(i);
1138: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
1139: p_desc_flex_rec.INTERFACE_HEADER_attribute10 := fnd_flex_descval.segment_id(i);
1133: p_desc_flex_rec.INTERFACE_HEADER_attribute7 := fnd_flex_descval.segment_id(i);
1134: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
1135: p_desc_flex_rec.INTERFACE_HEADER_attribute8 := fnd_flex_descval.segment_id(i);
1136: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
1137: p_desc_flex_rec.INTERFACE_HEADER_attribute9 := fnd_flex_descval.segment_id(i);
1138: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
1139: p_desc_flex_rec.INTERFACE_HEADER_attribute10 := fnd_flex_descval.segment_id(i);
1140: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
1141: p_desc_flex_rec.INTERFACE_HEADER_attribute11 := fnd_flex_descval.segment_id(i);
1135: p_desc_flex_rec.INTERFACE_HEADER_attribute8 := fnd_flex_descval.segment_id(i);
1136: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
1137: p_desc_flex_rec.INTERFACE_HEADER_attribute9 := fnd_flex_descval.segment_id(i);
1138: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
1139: p_desc_flex_rec.INTERFACE_HEADER_attribute10 := fnd_flex_descval.segment_id(i);
1140: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
1141: p_desc_flex_rec.INTERFACE_HEADER_attribute11 := fnd_flex_descval.segment_id(i);
1142: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
1143: p_desc_flex_rec.INTERFACE_HEADER_attribute12 := fnd_flex_descval.segment_id(i);
1137: p_desc_flex_rec.INTERFACE_HEADER_attribute9 := fnd_flex_descval.segment_id(i);
1138: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
1139: p_desc_flex_rec.INTERFACE_HEADER_attribute10 := fnd_flex_descval.segment_id(i);
1140: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
1141: p_desc_flex_rec.INTERFACE_HEADER_attribute11 := fnd_flex_descval.segment_id(i);
1142: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
1143: p_desc_flex_rec.INTERFACE_HEADER_attribute12 := fnd_flex_descval.segment_id(i);
1144: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
1145: p_desc_flex_rec.INTERFACE_HEADER_attribute13 := fnd_flex_descval.segment_id(i);
1139: p_desc_flex_rec.INTERFACE_HEADER_attribute10 := fnd_flex_descval.segment_id(i);
1140: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
1141: p_desc_flex_rec.INTERFACE_HEADER_attribute11 := fnd_flex_descval.segment_id(i);
1142: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
1143: p_desc_flex_rec.INTERFACE_HEADER_attribute12 := fnd_flex_descval.segment_id(i);
1144: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
1145: p_desc_flex_rec.INTERFACE_HEADER_attribute13 := fnd_flex_descval.segment_id(i);
1146: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
1147: p_desc_flex_rec.INTERFACE_HEADER_attribute14 := fnd_flex_descval.segment_id(i);
1141: p_desc_flex_rec.INTERFACE_HEADER_attribute11 := fnd_flex_descval.segment_id(i);
1142: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
1143: p_desc_flex_rec.INTERFACE_HEADER_attribute12 := fnd_flex_descval.segment_id(i);
1144: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
1145: p_desc_flex_rec.INTERFACE_HEADER_attribute13 := fnd_flex_descval.segment_id(i);
1146: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
1147: p_desc_flex_rec.INTERFACE_HEADER_attribute14 := fnd_flex_descval.segment_id(i);
1148: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
1149: p_desc_flex_rec.INTERFACE_HEADER_attribute15 := fnd_flex_descval.segment_id(i);
1143: p_desc_flex_rec.INTERFACE_HEADER_attribute12 := fnd_flex_descval.segment_id(i);
1144: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
1145: p_desc_flex_rec.INTERFACE_HEADER_attribute13 := fnd_flex_descval.segment_id(i);
1146: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
1147: p_desc_flex_rec.INTERFACE_HEADER_attribute14 := fnd_flex_descval.segment_id(i);
1148: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
1149: p_desc_flex_rec.INTERFACE_HEADER_attribute15 := fnd_flex_descval.segment_id(i);
1150: END IF;
1151:
1145: p_desc_flex_rec.INTERFACE_HEADER_attribute13 := fnd_flex_descval.segment_id(i);
1146: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
1147: p_desc_flex_rec.INTERFACE_HEADER_attribute14 := fnd_flex_descval.segment_id(i);
1148: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
1149: p_desc_flex_rec.INTERFACE_HEADER_attribute15 := fnd_flex_descval.segment_id(i);
1150: END IF;
1151:
1152: IF i > l_count THEN
1153: EXIT;