257: app.application_id = des.application_id AND
258: des.descriptive_flexfield_name = p_desc_flex_name;
259: app_rec app_cur%ROWTYPE;
260: BEGIN
261: fnd_flex_descval.clear_column_values;
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
258: des.descriptive_flexfield_name = p_desc_flex_name;
259: app_rec app_cur%ROWTYPE;
260: BEGIN
261: fnd_flex_descval.clear_column_values;
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
259: app_rec app_cur%ROWTYPE;
260: BEGIN
261: fnd_flex_descval.clear_column_values;
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
260: BEGIN
261: fnd_flex_descval.clear_column_values;
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
261: fnd_flex_descval.clear_column_values;
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
262: fnd_flex_descval.set_context_value(p_attribute_category);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
283: OPEN app_cur;
276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
283: OPEN app_cur;
284: FETCH app_cur INTO app_rec;
277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
283: OPEN app_cur;
284: FETCH app_cur INTO app_rec;
285: CLOSE app_cur;
278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
283: OPEN app_cur;
284: FETCH app_cur INTO app_rec;
285: CLOSE app_cur;
286: IF (fnd_flex_descval.validate_desccols( app_rec.application_short_name, p_desc_flex_name, 'I',SYSDATE)) THEN
282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
283: OPEN app_cur;
284: FETCH app_cur INTO app_rec;
285: CLOSE app_cur;
286: IF (fnd_flex_descval.validate_desccols( app_rec.application_short_name, p_desc_flex_name, 'I',SYSDATE)) THEN
287: RETURN TRUE;
288: ELSE
289: RETURN FALSE;
290: END IF;