DBA Data[Home] [Help]

APPS.CN_QUOTA_PAY_ELEMENTS_PKG dependencies on FND_API

Line 325: fnd_api.g_miss_num, oldrow.quota_id,

321: CLOSE C;
322:
323: SELECT
324: decode(p_quota_id,
325: fnd_api.g_miss_num, oldrow.quota_id,
326: p_quota_id),
327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),

Line 328: fnd_api.g_miss_num, oldrow.pay_element_type_id,

324: decode(p_quota_id,
325: fnd_api.g_miss_num, oldrow.quota_id,
326: p_quota_id),
327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),
330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),

Line 331: fnd_api.g_miss_char, oldrow.status,

327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),
330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),
333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),

Line 334: fnd_api.g_miss_date, oldrow.start_date,

330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),
333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),
336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),

Line 337: fnd_api.g_miss_date, oldrow.end_date,

333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),
336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),
339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),

Line 340: fnd_api.g_miss_char, oldrow.attribute_category,

336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),
339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),
342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),

Line 343: fnd_api.g_miss_char, oldrow.attribute1,

339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),
342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),
345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),

Line 346: fnd_api.g_miss_char, oldrow.attribute2,

342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),
345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),
348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),

Line 349: fnd_api.g_miss_char, oldrow.attribute3,

345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),
348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),
351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),

Line 352: fnd_api.g_miss_char, oldrow.attribute4,

348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),
351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),
354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),

Line 355: fnd_api.g_miss_char, oldrow.attribute5,

351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),
354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),
357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),

Line 358: fnd_api.g_miss_char, oldrow.attribute6,

354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),
357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),
360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),

Line 361: fnd_api.g_miss_char, oldrow.attribute7,

357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),
360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),
363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),

Line 364: fnd_api.g_miss_char, oldrow.attribute8,

360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),
363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),
366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),

Line 367: fnd_api.g_miss_char, oldrow.attribute9,

363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),
366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),
369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),

Line 370: fnd_api.g_miss_char, oldrow.attribute10,

366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),
369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),
372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),

Line 373: fnd_api.g_miss_char, oldrow.attribute11,

369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),
372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),
375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),

Line 376: fnd_api.g_miss_char, oldrow.attribute12,

372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),
375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),
378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),

Line 379: fnd_api.g_miss_char, oldrow.attribute13,

375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),
378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),
381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),

Line 382: fnd_api.g_miss_char, oldrow.attribute14,

378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),
381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),
384: decode(p_attribute15,
385: fnd_api.g_miss_char, oldrow.attribute15,
386: p_attribute15)

Line 385: fnd_api.g_miss_char, oldrow.attribute15,

381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),
384: decode(p_attribute15,
385: fnd_api.g_miss_char, oldrow.attribute15,
386: p_attribute15)
387: INTO
388: l_quota_id,
389: l_pay_element_type_id,