eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TP_TEMPLATES_PKG dependencies on FND_API

Line 15: | 1. Modify Update_Row to check fnd_api.g_miss_XXX and null |

11: | HISTORY |
12: | 03-11-2002 Adding two new column: UNI_QUESTION_NOTE_FLAG, |
13: | UNI_QUESTION_NOTE_TYPE |
14: | 12-APR-2002 KLOU |
15: | 1. Modify Update_Row to check fnd_api.g_miss_XXX and null |
16: | when updating the table. |
17: | 15-MAY-2002 KLOU |
18: | 1. Modify Insert_Row to null into uni_question_note_flag |
19: | and uni_question_note_type if they are |

Line 20: | fnd_api.g_miss_char. |

16: | when updating the table. |
17: | 15-MAY-2002 KLOU |
18: | 1. Modify Insert_Row to null into uni_question_note_flag |
19: | and uni_question_note_type if they are |
20: | fnd_api.g_miss_char. |
21: | 115.9 03-DEC-2002 WZLI changed OUT and IN OUT calls to use NOCOPY hint|
22: | to enable pass by reference. |
23: | |
24: +==========================================================================*/

Line 114: decode(X_UNI_QUESTION_NOTE_FLAG, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_FLAG),

110: X_ATTRIBUTE12,
111: X_ATTRIBUTE13,
112: X_ATTRIBUTE14,
113: X_ATTRIBUTE15,
114: decode(X_UNI_QUESTION_NOTE_FLAG, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_FLAG),
115: decode(X_UNI_QUESTION_NOTE_TYPE, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_TYPE),
116: X_CREATION_DATE,
117: X_CREATED_BY,
118: X_LAST_UPDATE_DATE,

Line 115: decode(X_UNI_QUESTION_NOTE_TYPE, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_TYPE),

111: X_ATTRIBUTE13,
112: X_ATTRIBUTE14,
113: X_ATTRIBUTE15,
114: decode(X_UNI_QUESTION_NOTE_FLAG, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_FLAG),
115: decode(X_UNI_QUESTION_NOTE_TYPE, fnd_api.g_miss_char, null, X_UNI_QUESTION_NOTE_TYPE),
116: X_CREATION_DATE,
117: X_CREATED_BY,
118: X_LAST_UPDATE_DATE,
119: X_LAST_UPDATED_BY,

Line 366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),

362: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
363: where TEMPLATE_ID = X_TEMPLATE_ID;
364: */
365: Update CS_TP_TEMPLATES_B set
366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),

Line 367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),

363: where TEMPLATE_ID = X_TEMPLATE_ID;
364: */
365: Update CS_TP_TEMPLATES_B set
366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),

Line 368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),

364: */
365: Update CS_TP_TEMPLATES_B set
366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),

Line 369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),

365: Update CS_TP_TEMPLATES_B set
366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),

Line 370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),

366: DEFAULT_FLAG = DECODE(NVL(X_DEFAULT_FLAG,FND_API.G_MISS_CHAR),
367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),

Line 371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),

367: FND_API.G_MISS_CHAR, DEFAULT_FLAG, X_DEFAULT_FLAG),
368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),

Line 372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),

368: START_DATE_ACTIVE = DECODE(NVL(X_START_DATE_ACTIVE, FND_API.G_MISS_DATE),
369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),

Line 373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),

369: FND_API.G_MISS_DATE, START_DATE_ACTIVE, X_START_DATE_ACTIVE),
370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),

Line 374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),

370: END_DATE_ACTIVE = DECODE(NVL(X_END_DATE_ACTIVE, FND_API.G_MISS_DATE),
371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),

Line 375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),

371: FND_API.G_MISS_DATE, END_DATE_ACTIVE, X_END_DATE_ACTIVE),
372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),

Line 376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),

372: ATTRIBUTE_CATEGORY = DECODE(NVL(X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR),
373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),

Line 377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),

373: FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, X_ATTRIBUTE_CATEGORY),
374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),

Line 378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),

374: ATTRIBUTE1 = DECODE(NVL(X_ATTRIBUTE1, FND_API.G_MISS_CHAR),
375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),

Line 379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),

375: FND_API.G_MISS_CHAR, ATTRIBUTE1, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),

Line 380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),

376: ATTRIBUTE2 = DECODE(NVL(X_ATTRIBUTE2, FND_API.G_MISS_CHAR),
377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),

Line 381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),

377: FND_API.G_MISS_CHAR, ATTRIBUTE2, X_ATTRIBUTE2 ),
378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),

Line 382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),

378: ATTRIBUTE3 = DECODE(NVL(X_ATTRIBUTE3, FND_API.G_MISS_CHAR),
379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),

Line 383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),

379: FND_API.G_MISS_CHAR, ATTRIBUTE3, X_ATTRIBUTE3 ),
380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),

Line 384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),

380: ATTRIBUTE4 = DECODE(NVL(X_ATTRIBUTE4, FND_API.G_MISS_CHAR),
381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),

Line 385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),

381: FND_API.G_MISS_CHAR, ATTRIBUTE4, X_ATTRIBUTE4 ),
382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),

Line 386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),

382: ATTRIBUTE5 = DECODE(NVL(X_ATTRIBUTE5, FND_API.G_MISS_CHAR),
383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),

Line 387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),

383: FND_API.G_MISS_CHAR, ATTRIBUTE5, X_ATTRIBUTE5 ),
384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),

Line 388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),

384: ATTRIBUTE6 = DECODE(NVL(X_ATTRIBUTE6, FND_API.G_MISS_CHAR),
385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),

Line 389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),

385: FND_API.G_MISS_CHAR, ATTRIBUTE6, X_ATTRIBUTE6 ),
386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),

Line 390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),

386: ATTRIBUTE7 = DECODE(NVL(X_ATTRIBUTE7, FND_API.G_MISS_CHAR),
387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),

Line 391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),

387: FND_API.G_MISS_CHAR, ATTRIBUTE7, X_ATTRIBUTE7 ),
388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),

Line 392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),

388: ATTRIBUTE8 = DECODE(NVL(X_ATTRIBUTE8, FND_API.G_MISS_CHAR),
389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),

Line 393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),

389: FND_API.G_MISS_CHAR, ATTRIBUTE8, X_ATTRIBUTE8 ),
390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),

Line 394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),

390: ATTRIBUTE9 = DECODE(NVL(X_ATTRIBUTE9, FND_API.G_MISS_CHAR),
391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),

Line 395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),

391: FND_API.G_MISS_CHAR, ATTRIBUTE9, X_ATTRIBUTE9 ),
392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),

Line 396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),

392: ATTRIBUTE10 = DECODE(NVL(X_ATTRIBUTE10, FND_API.G_MISS_CHAR),
393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),

Line 397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),

393: FND_API.G_MISS_CHAR, ATTRIBUTE10, X_ATTRIBUTE10),
394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),

Line 398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),

394: ATTRIBUTE11 = DECODE(NVL(X_ATTRIBUTE11, FND_API.G_MISS_CHAR),
395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),

Line 399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),

395: FND_API.G_MISS_CHAR, ATTRIBUTE11, X_ATTRIBUTE11),
396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),

Line 400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),

396: ATTRIBUTE12 = DECODE(NVL(X_ATTRIBUTE12, FND_API.G_MISS_CHAR),
397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),

Line 401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),

397: FND_API.G_MISS_CHAR, ATTRIBUTE12, X_ATTRIBUTE12),
398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,

Line 402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),

398: ATTRIBUTE13 = DECODE(NVL(X_ATTRIBUTE13, FND_API.G_MISS_CHAR),
399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),

Line 403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),

399: FND_API.G_MISS_CHAR, ATTRIBUTE13, X_ATTRIBUTE13),
400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),

Line 404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),

400: ATTRIBUTE14 = DECODE(NVL(X_ATTRIBUTE14, FND_API.G_MISS_CHAR),
401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),

Line 405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,

401: FND_API.G_MISS_CHAR, ATTRIBUTE14, X_ATTRIBUTE14),
402: ATTRIBUTE15 = DECODE(NVL(X_ATTRIBUTE15, FND_API.G_MISS_CHAR),
403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),

Line 407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),

403: FND_API.G_MISS_CHAR, ATTRIBUTE15, X_ATTRIBUTE15),
404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),

Line 408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),

404: UNI_QUESTION_NOTE_FLAG = DECODE(NVL(X_UNI_QUESTION_NOTE_FLAG, FND_API.G_MISS_CHAR),
405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),

Line 409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),

405: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_FLAG,
406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),

Line 410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),

406: X_UNI_QUESTION_NOTE_FLAG),
407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),
414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)

Line 411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),

407: UNI_QUESTION_NOTE_TYPE = DECODE(NVL(X_UNI_QUESTION_NOTE_TYPE,FND_API.G_MISS_CHAR),
408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),
414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
415: Where TEMPLATE_ID = X_TEMPLATE_ID;

Line 412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),

408: FND_API.G_MISS_CHAR, UNI_QUESTION_NOTE_TYPE, X_UNI_QUESTION_NOTE_TYPE),
409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),
414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
415: Where TEMPLATE_ID = X_TEMPLATE_ID;
416:

Line 413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),

409: LAST_UPDATE_DATE = DECODE(NVL(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE),
410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),
414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
415: Where TEMPLATE_ID = X_TEMPLATE_ID;
416:
417: if (sql%notfound) then

Line 414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)

410: FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
411: LAST_UPDATED_BY = DECODE(NVL(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM),
412: FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY ),
413: LAST_UPDATE_LOGIN = DECODE(NVL(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM),
414: FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
415: Where TEMPLATE_ID = X_TEMPLATE_ID;
416:
417: if (sql%notfound) then
418: raise no_data_found;

Line 422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),

418: raise no_data_found;
419: end if;
420:
421: update CS_TP_TEMPLATES_TL set
422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),

Line 423: fnd_api.g_miss_char, name, x_name),

419: end if;
420:
421: update CS_TP_TEMPLATES_TL set
422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),

Line 424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),

420:
421: update CS_TP_TEMPLATES_TL set
422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),

Line 425: fnd_api.g_miss_char, description, x_description),

421: update CS_TP_TEMPLATES_TL set
422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),

Line 426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),

422: NAME = decode(nvl(X_NAME, fnd_api.g_miss_char),
423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),

Line 427: fnd_api.g_miss_date, last_update_date, x_last_update_date),

423: fnd_api.g_miss_char, name, x_name),
424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),
431: fnd_api.g_miss_num, last_update_login, x_last_update_login),

Line 428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),

424: DESCRIPTION = decode(nvl(X_DESCRIPTION, fnd_api.g_miss_char),
425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),
431: fnd_api.g_miss_num, last_update_login, x_last_update_login),
432: SOURCE_LANG = userenv('LANG')

Line 429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),

425: fnd_api.g_miss_char, description, x_description),
426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),
431: fnd_api.g_miss_num, last_update_login, x_last_update_login),
432: SOURCE_LANG = userenv('LANG')
433: where TEMPLATE_ID = X_TEMPLATE_ID

Line 430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),

426: LAST_UPDATE_DATE = decode(nvl(X_LAST_UPDATE_DATE, fnd_api.g_miss_date),
427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),
431: fnd_api.g_miss_num, last_update_login, x_last_update_login),
432: SOURCE_LANG = userenv('LANG')
433: where TEMPLATE_ID = X_TEMPLATE_ID
434: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 431: fnd_api.g_miss_num, last_update_login, x_last_update_login),

427: fnd_api.g_miss_date, last_update_date, x_last_update_date),
428: LAST_UPDATED_BY = decode(nvl(X_LAST_UPDATED_BY, fnd_api.g_miss_num),
429: fnd_api.g_miss_num, last_updated_by, x_last_updated_by),
430: LAST_UPDATE_LOGIN = decode(nvl(X_LAST_UPDATE_LOGIN, fnd_api.g_miss_num),
431: fnd_api.g_miss_num, last_update_login, x_last_update_login),
432: SOURCE_LANG = userenv('LANG')
433: where TEMPLATE_ID = X_TEMPLATE_ID
434: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
435: