DBA Data[Home] [Help]

APPS.GMA_STANDARD dependencies on FND_FLEX_DESCVAL

Line 291: FND_FLEX_DESCVAL.set_context_value(p_category);

287: END IF;
288: CLOSE c_get_exists;
289:
290: /* Validate flexfield values */
291: FND_FLEX_DESCVAL.set_context_value(p_category);
292:
293: i := 0;
294: IF p_category IS NOT NULL THEN
295: i := i +1;

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

301: IF c_get_flex1%FOUND THEN
302: IF l_count >= i THEN
303: i := i + 1;
304: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
305: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
306: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
307: END IF;
308: IF l_count >= i THEN
309: i := i + 1;

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

307: END IF;
308: IF l_count >= i THEN
309: i := i + 1;
310: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
311: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
312: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
313: END IF;
314: IF l_count >= i THEN
315: i := i + 1;

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

313: END IF;
314: IF l_count >= i THEN
315: i := i + 1;
316: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
317: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
318: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
319: END IF;
320: IF l_count >= i THEN
321: i := i + 1;

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

319: END IF;
320: IF l_count >= i THEN
321: i := i + 1;
322: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
324: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
325: END IF;
326: IF l_count >= i THEN
327: i := i + 1;

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

325: END IF;
326: IF l_count >= i THEN
327: i := i + 1;
328: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
329: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
330: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
331: END IF;
332: IF l_count >= i THEN
333: i := i + 1;

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

331: END IF;
332: IF l_count >= i THEN
333: i := i + 1;
334: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
335: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
336: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
337: END IF;
338: IF l_count >= i THEN
339: i := i + 1;

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

337: END IF;
338: IF l_count >= i THEN
339: i := i + 1;
340: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
341: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
342: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
343: END IF;
344: IF l_count >= i THEN
345: i := i + 1;

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

343: END IF;
344: IF l_count >= i THEN
345: i := i + 1;
346: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
347: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
348: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
349: END IF;
350: IF l_count >= i THEN
351: i := i + 1;

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

349: END IF;
350: IF l_count >= i THEN
351: i := i + 1;
352: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
353: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
354: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
355: END IF;
356: IF l_count >= i THEN
357: i := i + 1;

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

355: END IF;
356: IF l_count >= i THEN
357: i := i + 1;
358: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield columns */
359: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
360: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */
361: END IF;
362: END IF;
363: CLOSE c_get_flex1;

Line 367: IF NOT (FND_FLEX_DESCVAL.validate_desccols('EDR', 'EDR_FILE_ATTRIBUTES',

363: CLOSE c_get_flex1;
364:
365: /* 25 Aug 2003 Bug 3103346 Mercy Thomas Added the following code to validate the descriptive flexfield */
366:
367: IF NOT (FND_FLEX_DESCVAL.validate_desccols('EDR', 'EDR_FILE_ATTRIBUTES',
368: 'V', SYSDATE)) THEN
369: RAISE EDR_FILES_INV_FLEX_VALUE;
370: END IF;
371: /* 25 Aug 2003 Bug 3103346 Mercy Thomas End of the code changes */