129: BEGIN
130:
131: FOR i IN 1..l_relationship_id.count LOOP
132:
133: FND_FLEX_DESCVAL.set_context_value(l_attribute_category(i));
134:
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
131: FOR i IN 1..l_relationship_id.count LOOP
132:
133: FND_FLEX_DESCVAL.set_context_value(l_attribute_category(i));
134:
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
132:
133: FND_FLEX_DESCVAL.set_context_value(l_attribute_category(i));
134:
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
133: FND_FLEX_DESCVAL.set_context_value(l_attribute_category(i));
134:
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
134:
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
135: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', l_attribute1(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
136: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', l_attribute2(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
137: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', l_attribute3(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
138: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', l_attribute4(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
139: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', l_attribute5(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
140: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', l_attribute6(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
141: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', l_attribute7(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
142: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', l_attribute8(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
143: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', l_attribute9(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
144: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', l_attribute10(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
145: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', l_attribute11(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
146: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', l_attribute12(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
147: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', l_attribute13(i));
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
148: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', l_attribute14(i));
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
156: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
149: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', l_attribute15(i));
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
156: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
157: 'AR',
150: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', l_attribute16(i));
151: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', l_attribute17(i));
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
156: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
157: 'AR',
158: 'HZ_ORG_CONTACTS',
152: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', l_attribute18(i));
153: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', l_attribute19(i));
154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
156: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
157: 'AR',
158: 'HZ_ORG_CONTACTS',
159: 'V',
160: p_validation_date)) THEN
213: p_validation_date IN DATE
214: ) RETURN VARCHAR2 IS
215: BEGIN
216:
217: FND_FLEX_DESCVAL.set_context_value(p_attr_category);
218:
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
215: BEGIN
216:
217: FND_FLEX_DESCVAL.set_context_value(p_attr_category);
218:
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
216:
217: FND_FLEX_DESCVAL.set_context_value(p_attr_category);
218:
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
217: FND_FLEX_DESCVAL.set_context_value(p_attr_category);
218:
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
218:
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
219: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE1', p_attr1);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
220: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE2', p_attr2);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
221: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE3', p_attr3);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
222: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE4', p_attr4);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
223: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE5', p_attr5);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
224: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE6', p_attr6);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
225: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE7', p_attr7);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
226: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE8', p_attr8);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
227: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE9', p_attr9);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
228: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE10', p_attr10);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
229: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE11', p_attr11);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
230: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE12', p_attr12);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
231: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE13', p_attr13);
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
232: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE14', p_attr14);
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
240: IF (FND_FLEX_DESCVAL.validate_desccols(
233: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE15', p_attr15);
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
240: IF (FND_FLEX_DESCVAL.validate_desccols(
241: 'AR',
234: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE16', p_attr16);
235: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE17', p_attr17);
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
240: IF (FND_FLEX_DESCVAL.validate_desccols(
241: 'AR',
242: 'HZ_ORG_CONTACTS',
236: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE18', p_attr18);
237: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE19', p_attr19);
238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
240: IF (FND_FLEX_DESCVAL.validate_desccols(
241: 'AR',
242: 'HZ_ORG_CONTACTS',
243: 'V',
244: p_validation_date)) THEN