DBA Data[Home] [Help]

APPS.RA_LL_RCV_GROUPS_PKG dependencies on FND_API

Line 231: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),

227: VALUES (
228: l_line_id,
229: lintax_row.apply_to,
230: lintax_row.line_id,
231: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
232: DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),
233: arpcurr.currRound(nvl(line_2b_applied ,0)),
234: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code ),
235: arpcurr.currRound(nvl(tax_2b_applied ,0)),

Line 232: DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),

228: l_line_id,
229: lintax_row.apply_to,
230: lintax_row.line_id,
231: DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
232: DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),
233: arpcurr.currRound(nvl(line_2b_applied ,0)),
234: arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code ),
235: arpcurr.currRound(nvl(tax_2b_applied ,0)),
236: NVL(FND_GLOBAL.user_id,-1),

Line 379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),

375:
376: BEGIN
377:
378: SELECT
379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),

Line 380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),

376: BEGIN
377:
378: SELECT
379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),

Line 381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),

377:
378: SELECT
379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),

Line 382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),

378: SELECT
379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),

Line 383: NVL( TAX,FND_API.G_MISS_NUM ),

379: NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),

Line 384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),

380: NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),

Line 385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),

381: NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),

Line 386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),

382: NVL( COMMENTS,FND_API.G_MISS_CHAR ),
383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),

Line 387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),

383: NVL( TAX,FND_API.G_MISS_NUM ),
384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),

Line 388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),

384: NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),

Line 389: NVL( AMOUNT,FND_API.G_MISS_NUM ),

385: NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),

Line 390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),

386: NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),

Line 391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),

387: NVL( GROUP_ID,FND_API.G_MISS_NUM ),
388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),

Line 392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),

388: NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),

Line 393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),

389: NVL( AMOUNT,FND_API.G_MISS_NUM ),
390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),

Line 394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),

390: NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),

Line 395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),

391: NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),

Line 396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),

392: NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),

Line 397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),

393: NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),

Line 398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),

394: NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),

Line 399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),

395: NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),

Line 400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),

396: NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),

Line 401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),

397: NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),

Line 402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),

398: NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )

Line 403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),

399: NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )
407: INTO

Line 404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),

400: NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )
407: INTO
408: X_APPLY_TO,

Line 405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),

401: NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )
407: INTO
408: X_APPLY_TO,
409: X_TAX_BALANCE,

Line 406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )

402: NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
403: NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
404: NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
405: NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
406: NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )
407: INTO
408: X_APPLY_TO,
409: X_TAX_BALANCE,
410: X_CUSTOMER_TRX_LINE_ID,

Line 449: RAISE FND_API.G_EXC_ERROR;

445: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_API_NO_RECORD' );
446: FND_MESSAGE.SET_TOKEN( 'RECORD', 'p_AR_ACTIVITY_DETAILS_rec');
447: FND_MESSAGE.SET_TOKEN( 'VALUE', '' );
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: END Select_Row;
451:
452:
453: