DBA Data[Home] [Help]

APPS.IGS_FI_LOAD_EXT_CHG dependencies on FND_FLEX_DESCVAL

Line 261: fnd_flex_descval.clear_column_values;

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);

Line 262: fnd_flex_descval.set_context_value(p_attribute_category);

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);

Line 263: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);

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);

Line 264: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);

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);

Line 265: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);

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);

Line 266: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);

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);

Line 267: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);

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);

Line 268: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);

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);

Line 269: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);

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);

Line 270: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);

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);

Line 271: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);

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);

Line 272: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);

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);

Line 273: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);

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);

Line 274: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);

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);

Line 275: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);

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);

Line 276: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);

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);

Line 277: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);

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);

Line 278: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);

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);

Line 279: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);

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;

Line 280: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);

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;

Line 281: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);

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;

Line 282: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);

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

Line 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;