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)),
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),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 ),
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 )
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
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,
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,
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,
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: