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_QUESTIONS_PKG dependencies on FND_API

Line 339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),

335: X_LAST_UPDATE_LOGIN in NUMBER
336: ) is
337: begin
338: update CS_TP_QUESTIONS_B set
339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),

Line 340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),

336: ) is
337: begin
338: update CS_TP_QUESTIONS_B set
339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),

Line 341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),

337: begin
338: update CS_TP_QUESTIONS_B set
339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),

Line 342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),

338: update CS_TP_QUESTIONS_B set
339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),

Line 343: fnd_api.g_miss_char, attribute_category, x_attribute_category),

339: lookup_id = decode(nvl(x_lookup_id,fnd_api.g_miss_num), fnd_api.g_miss_num, lookup_id, x_lookup_id),
340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),

Line 344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),

340: mandtory_flag = decode(nvl(x_mandtory_flag, fnd_api.g_miss_char), fnd_api.g_miss_char , mandtory_flag, x_mandtory_flag),
341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),

Line 345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),

341: scoring_flag = decode(nvl(x_scoring_flag,fnd_api.g_miss_char), fnd_api.g_miss_char , scoring_flag, x_scoring_flag),
342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),

Line 346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),

342: attribute_category = decode(nvl(x_attribute_category,fnd_api.g_miss_char),
343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),

Line 347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),

343: fnd_api.g_miss_char, attribute_category, x_attribute_category),
344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),

Line 348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),

344: attribute1 = decode(nvl(x_attribute1, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute1 , x_attribute1 ),
345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),

Line 349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),

345: attribute2 = decode(nvl(x_attribute2, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute2 , x_attribute2 ),
346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),

Line 350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),

346: attribute3 = decode(nvl(x_attribute3, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute3 , x_attribute3 ),
347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),

Line 351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),

347: attribute4 = decode(nvl(x_attribute4, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute4 , x_attribute4 ),
348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),

Line 352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),

348: attribute5 = decode(nvl(x_attribute5, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute5 , x_attribute5 ),
349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),

Line 353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),

349: attribute6 = decode(nvl(x_attribute6, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute6 , x_attribute6 ),
350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),

Line 354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),

350: attribute7 = decode(nvl(x_attribute7, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute7 , x_attribute7 ),
351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),

Line 355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),

351: attribute8 = decode(nvl(x_attribute8, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute8 , x_attribute8 ),
352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),

Line 356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),

352: attribute9 = decode(nvl(x_attribute9, fnd_api.g_miss_char), fnd_api.g_miss_char, attribute9 , x_attribute9 ),
353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,

Line 357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),

353: attribute10 = decode(nvl(x_attribute10,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute10, x_attribute10),
354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),

Line 358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),

354: attribute11 = decode(nvl(x_attribute11,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute11, x_attribute11),
355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),
362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,

Line 359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),

355: attribute12 = decode(nvl(x_attribute12,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute12, x_attribute12),
356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),
362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
363: start_date_active, x_start_date_active),

Line 360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,

356: attribute13 = decode(nvl(x_attribute13,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute13, x_attribute13),
357: attribute14 = decode(nvl(x_attribute14,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute14, x_attribute14),
358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),
362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
363: start_date_active, x_start_date_active),
364: end_date_active = decode(nvl(x_end_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,

Line 362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,

358: attribute15 = decode(nvl(x_attribute15,fnd_api.g_miss_char), fnd_api.g_miss_char, attribute15, x_attribute15),
359: note_type = decode(nvl(x_note_type, fnd_api.g_miss_char), fnd_api.g_miss_char, note_type, x_note_type),
360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),
362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
363: start_date_active, x_start_date_active),
364: end_date_active = decode(nvl(x_end_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
365: end_date_active, x_end_date_active),
366: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 364: end_date_active = decode(nvl(x_end_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,

360: show_on_creation_flag = decode(nvl(x_show_on_creation_flag, fnd_api.g_miss_char), fnd_api.g_miss_char,
361: show_on_creation_flag, x_show_on_creation_flag),
362: start_date_active = decode(nvl(x_start_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
363: start_date_active, x_start_date_active),
364: end_date_active = decode(nvl(x_end_date_active, fnd_api.g_miss_date), fnd_api.g_miss_date,
365: end_date_active, x_end_date_active),
366: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
367: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
368: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 376: name = decode(nvl(x_name, fnd_api.g_miss_char), fnd_api.g_miss_char, name,x_name),

372: raise no_data_found;
373: end if;
374:
375: update CS_TP_QUESTIONS_TL set
376: name = decode(nvl(x_name, fnd_api.g_miss_char), fnd_api.g_miss_char, name,x_name),
377: text = decode(nvl(x_text, fnd_api.g_miss_char), fnd_api.g_miss_char, text,x_text),
378: description = decode(nvl(x_description, fnd_api.g_miss_char), fnd_api.g_miss_char,description, x_description),
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
380: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 377: text = decode(nvl(x_text, fnd_api.g_miss_char), fnd_api.g_miss_char, text,x_text),

373: end if;
374:
375: update CS_TP_QUESTIONS_TL set
376: name = decode(nvl(x_name, fnd_api.g_miss_char), fnd_api.g_miss_char, name,x_name),
377: text = decode(nvl(x_text, fnd_api.g_miss_char), fnd_api.g_miss_char, text,x_text),
378: description = decode(nvl(x_description, fnd_api.g_miss_char), fnd_api.g_miss_char,description, x_description),
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
380: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
381: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 378: description = decode(nvl(x_description, fnd_api.g_miss_char), fnd_api.g_miss_char,description, x_description),

374:
375: update CS_TP_QUESTIONS_TL set
376: name = decode(nvl(x_name, fnd_api.g_miss_char), fnd_api.g_miss_char, name,x_name),
377: text = decode(nvl(x_text, fnd_api.g_miss_char), fnd_api.g_miss_char, text,x_text),
378: description = decode(nvl(x_description, fnd_api.g_miss_char), fnd_api.g_miss_char,description, x_description),
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
380: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
381: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
382: SOURCE_LANG = userenv('LANG')