36: trans_count NUMBER DEFAULT NULL;
37: BEGIN
38: SELECT COUNT (*)
39: INTO trans_count
40: FROM ar_payments_interface_all
41: WHERE transmission_request_id = req_id;
42:
43: RETURN trans_count;
44: END get_rec_count;
335: l_lockbox_run_already VARCHAR (1) DEFAULT NULL;
336: --asawanka modified for lla start
337: -- removed default assignement to mo_global.current_org_id as current org id might not be set from AR side
338: -- we need to take org_id from interface records instead
339: l_org_id ar_payments_interface_all.org_id%TYPE;
340: --asawanka modified for lla end
341: l_status CONSTANT ar_payments_interface_all.status%TYPE
342: := 'AR_PLB_NEW_RECORD';
343: l_trans_req_id ar_payments_interface_all.transmission_request_id%TYPE
337: -- removed default assignement to mo_global.current_org_id as current org id might not be set from AR side
338: -- we need to take org_id from interface records instead
339: l_org_id ar_payments_interface_all.org_id%TYPE;
340: --asawanka modified for lla end
341: l_status CONSTANT ar_payments_interface_all.status%TYPE
342: := 'AR_PLB_NEW_RECORD';
343: l_trans_req_id ar_payments_interface_all.transmission_request_id%TYPE
344: DEFAULT NULL;
345: l_transmission_id ar_payments_interface_all.transmission_id%TYPE
339: l_org_id ar_payments_interface_all.org_id%TYPE;
340: --asawanka modified for lla end
341: l_status CONSTANT ar_payments_interface_all.status%TYPE
342: := 'AR_PLB_NEW_RECORD';
343: l_trans_req_id ar_payments_interface_all.transmission_request_id%TYPE
344: DEFAULT NULL;
345: l_transmission_id ar_payments_interface_all.transmission_id%TYPE
346: DEFAULT NULL;
347: l_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
341: l_status CONSTANT ar_payments_interface_all.status%TYPE
342: := 'AR_PLB_NEW_RECORD';
343: l_trans_req_id ar_payments_interface_all.transmission_request_id%TYPE
344: DEFAULT NULL;
345: l_transmission_id ar_payments_interface_all.transmission_id%TYPE
346: DEFAULT NULL;
347: l_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
348: DEFAULT NULL;
349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
343: l_trans_req_id ar_payments_interface_all.transmission_request_id%TYPE
344: DEFAULT NULL;
345: l_transmission_id ar_payments_interface_all.transmission_id%TYPE
346: DEFAULT NULL;
347: l_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
348: DEFAULT NULL;
349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
350: DEFAULT NULL;
351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%TYPE
345: l_transmission_id ar_payments_interface_all.transmission_id%TYPE
346: DEFAULT NULL;
347: l_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
348: DEFAULT NULL;
349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
350: DEFAULT NULL;
351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%TYPE
352: DEFAULT NULL;
353: l_lockbox_number ar_payments_interface_all.lockbox_number%TYPE
347: l_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
348: DEFAULT NULL;
349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
350: DEFAULT NULL;
351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%TYPE
352: DEFAULT NULL;
353: l_lockbox_number ar_payments_interface_all.lockbox_number%TYPE
354: DEFAULT NULL;
355: l_batch_name ar_payments_interface_all.batch_name%TYPE
349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%TYPE
350: DEFAULT NULL;
351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%TYPE
352: DEFAULT NULL;
353: l_lockbox_number ar_payments_interface_all.lockbox_number%TYPE
354: DEFAULT NULL;
355: l_batch_name ar_payments_interface_all.batch_name%TYPE
356: DEFAULT NULL;
357: l_transmission_format_id ar_transmission_formats.transmission_format_id%TYPE
351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%TYPE
352: DEFAULT NULL;
353: l_lockbox_number ar_payments_interface_all.lockbox_number%TYPE
354: DEFAULT NULL;
355: l_batch_name ar_payments_interface_all.batch_name%TYPE
356: DEFAULT NULL;
357: l_transmission_format_id ar_transmission_formats.transmission_format_id%TYPE
358: DEFAULT NULL;
359: l_record_identifier ar_trans_record_formats.record_identifier%TYPE
371: l_overflow ar_trans_record_formats.record_identifier%TYPE
372: DEFAULT NULL;
373: l_service ar_trans_record_formats.record_identifier%TYPE
374: DEFAULT NULL;
375: l_customer_number ar_payments_interface_all.customer_number%TYPE
376: DEFAULT NULL;
377: l_remittance_amount ar_payments_interface_all.remittance_amount%TYPE
378: DEFAULT NULL;
379: l_currency_code ar_payments_interface_all.currency_code%TYPE
373: l_service ar_trans_record_formats.record_identifier%TYPE
374: DEFAULT NULL;
375: l_customer_number ar_payments_interface_all.customer_number%TYPE
376: DEFAULT NULL;
377: l_remittance_amount ar_payments_interface_all.remittance_amount%TYPE
378: DEFAULT NULL;
379: l_currency_code ar_payments_interface_all.currency_code%TYPE
380: DEFAULT NULL;
381: l_item_number ar_payments_interface_all.item_number%TYPE
375: l_customer_number ar_payments_interface_all.customer_number%TYPE
376: DEFAULT NULL;
377: l_remittance_amount ar_payments_interface_all.remittance_amount%TYPE
378: DEFAULT NULL;
379: l_currency_code ar_payments_interface_all.currency_code%TYPE
380: DEFAULT NULL;
381: l_item_number ar_payments_interface_all.item_number%TYPE
382: DEFAULT NULL;
383: l_inv_ref ar_payments_interface_all.invoice1%TYPE
377: l_remittance_amount ar_payments_interface_all.remittance_amount%TYPE
378: DEFAULT NULL;
379: l_currency_code ar_payments_interface_all.currency_code%TYPE
380: DEFAULT NULL;
381: l_item_number ar_payments_interface_all.item_number%TYPE
382: DEFAULT NULL;
383: l_inv_ref ar_payments_interface_all.invoice1%TYPE
384: DEFAULT NULL;
385: l_invoice ar_payments_interface_all.invoice1%TYPE
379: l_currency_code ar_payments_interface_all.currency_code%TYPE
380: DEFAULT NULL;
381: l_item_number ar_payments_interface_all.item_number%TYPE
382: DEFAULT NULL;
383: l_inv_ref ar_payments_interface_all.invoice1%TYPE
384: DEFAULT NULL;
385: l_invoice ar_payments_interface_all.invoice1%TYPE
386: DEFAULT NULL;
387: l_amt_appl ar_payments_interface_all.amount_applied1%TYPE
381: l_item_number ar_payments_interface_all.item_number%TYPE
382: DEFAULT NULL;
383: l_inv_ref ar_payments_interface_all.invoice1%TYPE
384: DEFAULT NULL;
385: l_invoice ar_payments_interface_all.invoice1%TYPE
386: DEFAULT NULL;
387: l_amt_appl ar_payments_interface_all.amount_applied1%TYPE
388: DEFAULT NULL;
389: l_amount_applied ar_payments_interface_all.amount_applied1%TYPE
383: l_inv_ref ar_payments_interface_all.invoice1%TYPE
384: DEFAULT NULL;
385: l_invoice ar_payments_interface_all.invoice1%TYPE
386: DEFAULT NULL;
387: l_amt_appl ar_payments_interface_all.amount_applied1%TYPE
388: DEFAULT NULL;
389: l_amount_applied ar_payments_interface_all.amount_applied1%TYPE
390: DEFAULT NULL;
391: l_check_number ar_payments_interface_all.check_number%TYPE
385: l_invoice ar_payments_interface_all.invoice1%TYPE
386: DEFAULT NULL;
387: l_amt_appl ar_payments_interface_all.amount_applied1%TYPE
388: DEFAULT NULL;
389: l_amount_applied ar_payments_interface_all.amount_applied1%TYPE
390: DEFAULT NULL;
391: l_check_number ar_payments_interface_all.check_number%TYPE
392: DEFAULT NULL;
393: l_receipt_date ar_payments_interface_all.receipt_date%TYPE
387: l_amt_appl ar_payments_interface_all.amount_applied1%TYPE
388: DEFAULT NULL;
389: l_amount_applied ar_payments_interface_all.amount_applied1%TYPE
390: DEFAULT NULL;
391: l_check_number ar_payments_interface_all.check_number%TYPE
392: DEFAULT NULL;
393: l_receipt_date ar_payments_interface_all.receipt_date%TYPE
394: DEFAULT NULL;
395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%TYPE
389: l_amount_applied ar_payments_interface_all.amount_applied1%TYPE
390: DEFAULT NULL;
391: l_check_number ar_payments_interface_all.check_number%TYPE
392: DEFAULT NULL;
393: l_receipt_date ar_payments_interface_all.receipt_date%TYPE
394: DEFAULT NULL;
395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%TYPE
396: DEFAULT NULL;
397: l_account ar_payments_interface_all.ACCOUNT%TYPE
391: l_check_number ar_payments_interface_all.check_number%TYPE
392: DEFAULT NULL;
393: l_receipt_date ar_payments_interface_all.receipt_date%TYPE
394: DEFAULT NULL;
395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%TYPE
396: DEFAULT NULL;
397: l_account ar_payments_interface_all.ACCOUNT%TYPE
398: DEFAULT NULL;
399: l_invoice1 ar_payments_interface_all.invoice1%TYPE
393: l_receipt_date ar_payments_interface_all.receipt_date%TYPE
394: DEFAULT NULL;
395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%TYPE
396: DEFAULT NULL;
397: l_account ar_payments_interface_all.ACCOUNT%TYPE
398: DEFAULT NULL;
399: l_invoice1 ar_payments_interface_all.invoice1%TYPE
400: DEFAULT NULL;
401: l_invoice2 ar_payments_interface_all.invoice2%TYPE
395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%TYPE
396: DEFAULT NULL;
397: l_account ar_payments_interface_all.ACCOUNT%TYPE
398: DEFAULT NULL;
399: l_invoice1 ar_payments_interface_all.invoice1%TYPE
400: DEFAULT NULL;
401: l_invoice2 ar_payments_interface_all.invoice2%TYPE
402: DEFAULT NULL;
403: l_invoice3 ar_payments_interface_all.invoice3%TYPE
397: l_account ar_payments_interface_all.ACCOUNT%TYPE
398: DEFAULT NULL;
399: l_invoice1 ar_payments_interface_all.invoice1%TYPE
400: DEFAULT NULL;
401: l_invoice2 ar_payments_interface_all.invoice2%TYPE
402: DEFAULT NULL;
403: l_invoice3 ar_payments_interface_all.invoice3%TYPE
404: DEFAULT NULL;
405: l_invoice4 ar_payments_interface_all.invoice4%TYPE
399: l_invoice1 ar_payments_interface_all.invoice1%TYPE
400: DEFAULT NULL;
401: l_invoice2 ar_payments_interface_all.invoice2%TYPE
402: DEFAULT NULL;
403: l_invoice3 ar_payments_interface_all.invoice3%TYPE
404: DEFAULT NULL;
405: l_invoice4 ar_payments_interface_all.invoice4%TYPE
406: DEFAULT NULL;
407: l_invoice5 ar_payments_interface_all.invoice5%TYPE
401: l_invoice2 ar_payments_interface_all.invoice2%TYPE
402: DEFAULT NULL;
403: l_invoice3 ar_payments_interface_all.invoice3%TYPE
404: DEFAULT NULL;
405: l_invoice4 ar_payments_interface_all.invoice4%TYPE
406: DEFAULT NULL;
407: l_invoice5 ar_payments_interface_all.invoice5%TYPE
408: DEFAULT NULL;
409: l_invoice6 ar_payments_interface_all.invoice6%TYPE
403: l_invoice3 ar_payments_interface_all.invoice3%TYPE
404: DEFAULT NULL;
405: l_invoice4 ar_payments_interface_all.invoice4%TYPE
406: DEFAULT NULL;
407: l_invoice5 ar_payments_interface_all.invoice5%TYPE
408: DEFAULT NULL;
409: l_invoice6 ar_payments_interface_all.invoice6%TYPE
410: DEFAULT NULL;
411: l_invoice7 ar_payments_interface_all.invoice7%TYPE
405: l_invoice4 ar_payments_interface_all.invoice4%TYPE
406: DEFAULT NULL;
407: l_invoice5 ar_payments_interface_all.invoice5%TYPE
408: DEFAULT NULL;
409: l_invoice6 ar_payments_interface_all.invoice6%TYPE
410: DEFAULT NULL;
411: l_invoice7 ar_payments_interface_all.invoice7%TYPE
412: DEFAULT NULL;
413: l_invoice8 ar_payments_interface_all.invoice8%TYPE
407: l_invoice5 ar_payments_interface_all.invoice5%TYPE
408: DEFAULT NULL;
409: l_invoice6 ar_payments_interface_all.invoice6%TYPE
410: DEFAULT NULL;
411: l_invoice7 ar_payments_interface_all.invoice7%TYPE
412: DEFAULT NULL;
413: l_invoice8 ar_payments_interface_all.invoice8%TYPE
414: DEFAULT NULL;
415: l_new_invoice1 ar_payments_interface_all.invoice1%TYPE
409: l_invoice6 ar_payments_interface_all.invoice6%TYPE
410: DEFAULT NULL;
411: l_invoice7 ar_payments_interface_all.invoice7%TYPE
412: DEFAULT NULL;
413: l_invoice8 ar_payments_interface_all.invoice8%TYPE
414: DEFAULT NULL;
415: l_new_invoice1 ar_payments_interface_all.invoice1%TYPE
416: DEFAULT NULL;
417: l_new_invoice2 ar_payments_interface_all.invoice2%TYPE
411: l_invoice7 ar_payments_interface_all.invoice7%TYPE
412: DEFAULT NULL;
413: l_invoice8 ar_payments_interface_all.invoice8%TYPE
414: DEFAULT NULL;
415: l_new_invoice1 ar_payments_interface_all.invoice1%TYPE
416: DEFAULT NULL;
417: l_new_invoice2 ar_payments_interface_all.invoice2%TYPE
418: DEFAULT NULL;
419: l_new_invoice3 ar_payments_interface_all.invoice3%TYPE
413: l_invoice8 ar_payments_interface_all.invoice8%TYPE
414: DEFAULT NULL;
415: l_new_invoice1 ar_payments_interface_all.invoice1%TYPE
416: DEFAULT NULL;
417: l_new_invoice2 ar_payments_interface_all.invoice2%TYPE
418: DEFAULT NULL;
419: l_new_invoice3 ar_payments_interface_all.invoice3%TYPE
420: DEFAULT NULL;
421: l_new_invoice4 ar_payments_interface_all.invoice4%TYPE
415: l_new_invoice1 ar_payments_interface_all.invoice1%TYPE
416: DEFAULT NULL;
417: l_new_invoice2 ar_payments_interface_all.invoice2%TYPE
418: DEFAULT NULL;
419: l_new_invoice3 ar_payments_interface_all.invoice3%TYPE
420: DEFAULT NULL;
421: l_new_invoice4 ar_payments_interface_all.invoice4%TYPE
422: DEFAULT NULL;
423: l_new_invoice5 ar_payments_interface_all.invoice5%TYPE
417: l_new_invoice2 ar_payments_interface_all.invoice2%TYPE
418: DEFAULT NULL;
419: l_new_invoice3 ar_payments_interface_all.invoice3%TYPE
420: DEFAULT NULL;
421: l_new_invoice4 ar_payments_interface_all.invoice4%TYPE
422: DEFAULT NULL;
423: l_new_invoice5 ar_payments_interface_all.invoice5%TYPE
424: DEFAULT NULL;
425: l_new_invoice6 ar_payments_interface_all.invoice6%TYPE
419: l_new_invoice3 ar_payments_interface_all.invoice3%TYPE
420: DEFAULT NULL;
421: l_new_invoice4 ar_payments_interface_all.invoice4%TYPE
422: DEFAULT NULL;
423: l_new_invoice5 ar_payments_interface_all.invoice5%TYPE
424: DEFAULT NULL;
425: l_new_invoice6 ar_payments_interface_all.invoice6%TYPE
426: DEFAULT NULL;
427: l_new_invoice7 ar_payments_interface_all.invoice7%TYPE
421: l_new_invoice4 ar_payments_interface_all.invoice4%TYPE
422: DEFAULT NULL;
423: l_new_invoice5 ar_payments_interface_all.invoice5%TYPE
424: DEFAULT NULL;
425: l_new_invoice6 ar_payments_interface_all.invoice6%TYPE
426: DEFAULT NULL;
427: l_new_invoice7 ar_payments_interface_all.invoice7%TYPE
428: DEFAULT NULL;
429: l_new_invoice8 ar_payments_interface_all.invoice8%TYPE
423: l_new_invoice5 ar_payments_interface_all.invoice5%TYPE
424: DEFAULT NULL;
425: l_new_invoice6 ar_payments_interface_all.invoice6%TYPE
426: DEFAULT NULL;
427: l_new_invoice7 ar_payments_interface_all.invoice7%TYPE
428: DEFAULT NULL;
429: l_new_invoice8 ar_payments_interface_all.invoice8%TYPE
430: DEFAULT NULL;
431:
425: l_new_invoice6 ar_payments_interface_all.invoice6%TYPE
426: DEFAULT NULL;
427: l_new_invoice7 ar_payments_interface_all.invoice7%TYPE
428: DEFAULT NULL;
429: l_new_invoice8 ar_payments_interface_all.invoice8%TYPE
430: DEFAULT NULL;
431:
432: -- varao - Bug#5075248 - Modified - Start
433: -- Datatype matched with the new column from which amount is queried from
430: DEFAULT NULL;
431:
432: -- varao - Bug#5075248 - Modified - Start
433: -- Datatype matched with the new column from which amount is queried from
434: l_amount_applied1 ar_payments_interface_all.tmp_amt_applied1%TYPE
435: DEFAULT NULL;
436: l_amount_applied2 ar_payments_interface_all.tmp_amt_applied2%TYPE
437: DEFAULT NULL;
438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%TYPE
432: -- varao - Bug#5075248 - Modified - Start
433: -- Datatype matched with the new column from which amount is queried from
434: l_amount_applied1 ar_payments_interface_all.tmp_amt_applied1%TYPE
435: DEFAULT NULL;
436: l_amount_applied2 ar_payments_interface_all.tmp_amt_applied2%TYPE
437: DEFAULT NULL;
438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%TYPE
439: DEFAULT NULL;
440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%TYPE
434: l_amount_applied1 ar_payments_interface_all.tmp_amt_applied1%TYPE
435: DEFAULT NULL;
436: l_amount_applied2 ar_payments_interface_all.tmp_amt_applied2%TYPE
437: DEFAULT NULL;
438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%TYPE
439: DEFAULT NULL;
440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%TYPE
441: DEFAULT NULL;
442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%TYPE
436: l_amount_applied2 ar_payments_interface_all.tmp_amt_applied2%TYPE
437: DEFAULT NULL;
438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%TYPE
439: DEFAULT NULL;
440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%TYPE
441: DEFAULT NULL;
442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%TYPE
443: DEFAULT NULL;
444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%TYPE
438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%TYPE
439: DEFAULT NULL;
440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%TYPE
441: DEFAULT NULL;
442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%TYPE
443: DEFAULT NULL;
444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%TYPE
445: DEFAULT NULL;
446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%TYPE
440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%TYPE
441: DEFAULT NULL;
442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%TYPE
443: DEFAULT NULL;
444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%TYPE
445: DEFAULT NULL;
446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%TYPE
447: DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%TYPE
443: DEFAULT NULL;
444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%TYPE
445: DEFAULT NULL;
446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%TYPE
447: DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%TYPE
445: DEFAULT NULL;
446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%TYPE
447: DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%TYPE
447: DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
447: DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
449: DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%TYPE DEFAULT NULL;
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%TYPE DEFAULT NULL;
462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%TYPE DEFAULT NULL;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%TYPE DEFAULT NULL;
466:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
474: l_tmp_currency_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
475:
476: -- varao - Bug#5075248 - Modified - End
469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
474: l_tmp_currency_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
475:
476: -- varao - Bug#5075248 - Modified - End
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE
470: l_returned_precision_to NUMBER;
471: l_returned_precision_from NUMBER;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;
473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
474: l_tmp_currency_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
475:
476: -- varao - Bug#5075248 - Modified - End
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE
478: DEFAULT NULL;
473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%TYPE DEFAULT NULL;
474: l_tmp_currency_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;
475:
476: -- varao - Bug#5075248 - Modified - End
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE
478: DEFAULT NULL;
479: l_new_amount_applied2 ar_payments_interface_all.amount_applied2%TYPE
480: DEFAULT NULL;
481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%TYPE
475:
476: -- varao - Bug#5075248 - Modified - End
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE
478: DEFAULT NULL;
479: l_new_amount_applied2 ar_payments_interface_all.amount_applied2%TYPE
480: DEFAULT NULL;
481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%TYPE
482: DEFAULT NULL;
483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%TYPE
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE
478: DEFAULT NULL;
479: l_new_amount_applied2 ar_payments_interface_all.amount_applied2%TYPE
480: DEFAULT NULL;
481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%TYPE
482: DEFAULT NULL;
483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%TYPE
484: DEFAULT NULL;
485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%TYPE
479: l_new_amount_applied2 ar_payments_interface_all.amount_applied2%TYPE
480: DEFAULT NULL;
481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%TYPE
482: DEFAULT NULL;
483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%TYPE
484: DEFAULT NULL;
485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%TYPE
486: DEFAULT NULL;
487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%TYPE
481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%TYPE
482: DEFAULT NULL;
483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%TYPE
484: DEFAULT NULL;
485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%TYPE
486: DEFAULT NULL;
487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%TYPE
488: DEFAULT NULL;
489: l_new_amount_applied7 ar_payments_interface_all.amount_applied7%TYPE
483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%TYPE
484: DEFAULT NULL;
485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%TYPE
486: DEFAULT NULL;
487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%TYPE
488: DEFAULT NULL;
489: l_new_amount_applied7 ar_payments_interface_all.amount_applied7%TYPE
490: DEFAULT NULL;
491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE
485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%TYPE
486: DEFAULT NULL;
487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%TYPE
488: DEFAULT NULL;
489: l_new_amount_applied7 ar_payments_interface_all.amount_applied7%TYPE
490: DEFAULT NULL;
491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE
492: DEFAULT NULL;
493:
487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%TYPE
488: DEFAULT NULL;
489: l_new_amount_applied7 ar_payments_interface_all.amount_applied7%TYPE
490: DEFAULT NULL;
491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE
492: DEFAULT NULL;
493:
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
490: DEFAULT NULL;
491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE
492: DEFAULT NULL;
493:
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE
492: DEFAULT NULL;
493:
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
492: DEFAULT NULL;
493:
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
493:
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%TYPE DEFAULT NULL;
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%TYPE DEFAULT NULL;
498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
502:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
511:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%TYPE DEFAULT NULL;
516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
520:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%TYPE DEFAULT NULL;
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%TYPE DEFAULT NULL;
529:
522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%TYPE DEFAULT NULL;
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%TYPE DEFAULT NULL;
529:
530:
523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%TYPE DEFAULT NULL;
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%TYPE DEFAULT NULL;
529:
530:
531: l_tolerance okl_cash_allctn_rls.amount_tolerance_percent%TYPE
524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%TYPE DEFAULT NULL;
525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%TYPE DEFAULT NULL;
526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%TYPE DEFAULT NULL;
527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%TYPE DEFAULT NULL;
528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%TYPE DEFAULT NULL;
529:
530:
531: l_tolerance okl_cash_allctn_rls.amount_tolerance_percent%TYPE
532: DEFAULT NULL;
593: -- DECLARE Record/Table Types
594: ------------------------------
595: -- Internal Trans
596: TYPE l_orig_rcpt_rec_type IS RECORD (
597: invoice_number ar_payments_interface_all.invoice1%TYPE
598: DEFAULT NULL,
599: amount_applied ar_payments_interface_all.amount_applied1%TYPE
600: DEFAULT NULL,
601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%TYPE
595: -- Internal Trans
596: TYPE l_orig_rcpt_rec_type IS RECORD (
597: invoice_number ar_payments_interface_all.invoice1%TYPE
598: DEFAULT NULL,
599: amount_applied ar_payments_interface_all.amount_applied1%TYPE
600: DEFAULT NULL,
601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%TYPE
602: DEFAULT NULL,
603: trans_to_receipt_rate ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE
597: invoice_number ar_payments_interface_all.invoice1%TYPE
598: DEFAULT NULL,
599: amount_applied ar_payments_interface_all.amount_applied1%TYPE
600: DEFAULT NULL,
601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%TYPE
602: DEFAULT NULL,
603: trans_to_receipt_rate ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE
604: DEFAULT NULL,
605: currency_code ar_payments_interface_all.currency_code%TYPE
599: amount_applied ar_payments_interface_all.amount_applied1%TYPE
600: DEFAULT NULL,
601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%TYPE
602: DEFAULT NULL,
603: trans_to_receipt_rate ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE
604: DEFAULT NULL,
605: currency_code ar_payments_interface_all.currency_code%TYPE
606: DEFAULT NULL
607: );
601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%TYPE
602: DEFAULT NULL,
603: trans_to_receipt_rate ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE
604: DEFAULT NULL,
605: currency_code ar_payments_interface_all.currency_code%TYPE
606: DEFAULT NULL
607: );
608:
609: TYPE l_orig_rcpt_tbl_type IS TABLE OF l_orig_rcpt_rec_type
746: TMP_INV_CURRENCY_CODE6,
747: TMP_INV_CURRENCY_CODE7,
748: TMP_INV_CURRENCY_CODE8, */
749: org_id
750: FROM ar_payments_interface_all
751: WHERE transmission_request_id = cp_trans_req_id
752: AND record_type = cp_rec_type
753: ORDER BY item_number;
754:
827: TMP_INV_CURRENCY_CODE5,
828: TMP_INV_CURRENCY_CODE6,
829: TMP_INV_CURRENCY_CODE7,
830: TMP_INV_CURRENCY_CODE8*/
831: FROM ar_payments_interface_all
832: WHERE transmission_request_id = cp_trans_req_id
833: AND record_type = cp_rec_type
834: AND item_number = cp_item_number
835: AND overflow_sequence IS NOT NULL
846: cp_item_number IN NUMBER,
847: cp_batch_name IN VARCHAR2
848: ) IS
849: SELECT transmission_record_id
850: FROM ar_payments_interface_all
851: WHERE transmission_request_id = cp_trans_req_id
852: AND record_type = cp_rec_type
853: AND item_number = cp_item_number
854: AND overflow_sequence IS NULL
860: -- get transmission count
861: CURSOR c_get_trans_rec_count (cp_trans_req_id IN NUMBER) IS
862: -- , cp_rec_type IN VARCHAR2 ) IS
863: SELECT COUNT (*)
864: FROM ar_payments_interface_all
865: WHERE transmission_request_id = cp_trans_req_id;
866:
867: --AND record_type <> cp_rec_type;
868: ----------
1961: ( 'Transmission Record Id of new overflow record = '
1962: || l_transmission_rec_id_of
1963: );
1964:
1965: INSERT INTO ar_payments_interface_all
1966: (transmission_record_id,
1967: item_number,
1968: record_type,
1969: status,
2256: j := 1;
2257:
2258: -- need to keep references that returned nothing and
2259: -- need to null out invoice references for which we found match
2260: UPDATE ar_payments_interface_all
2261: SET invoice1 = l_no_mtch_rcpt_tbl (j).invoice_number,
2262: amount_applied1 = l_no_mtch_rcpt_tbl (j).amount_applied,
2263: resolved_matching_number1 =
2264: l_no_mtch_rcpt_tbl (j).invoice_number,
3198: ( 'Transmission Record Id of new overflow record = '
3199: || l_transmission_rec_id_of
3200: );
3201:
3202: INSERT INTO ar_payments_interface_all
3203: (transmission_record_id,
3204: item_number,
3205: record_type,
3206: status,
3512: log_debug
3513: ('All invoice references in this overflow record matched.Deleting this over flow record.'
3514: );
3515:
3516: DELETE FROM ar_payments_interface_all
3517: -- no need to keep old overflow rec
3518: WHERE transmission_record_id = l_transmission_record_id;
3519: END IF;
3520:
3551: log_debug
3552: ('Nulling out invoice references which were matched successfully and retaining those which did not match at all'
3553: );
3554:
3555: UPDATE ar_payments_interface_all
3556: SET overflow_sequence =
3557: NULL
3558: -- we'll take care of this later.see below
3559: ,
3638: INTO l_transmission_record_id;
3639:
3640: EXIT WHEN c_get_ovrflw_recs_new%NOTFOUND;
3641:
3642: UPDATE ar_payments_interface_all
3643: SET overflow_sequence = seq_num,
3644: overflow_indicator = l_overflow_rec_indicator
3645: WHERE transmission_record_id = l_transmission_record_id;
3646:
3654: ELSE
3655: l_ovf_ind := '0';
3656: END IF;
3657:
3658: UPDATE ar_payments_interface_all
3659: SET overflow_indicator = l_ovf_ind
3660: WHERE transmission_record_id = l_last_transmission_record_id;
3661:
3662: CLOSE c_get_ovrflw_recs_new;
3671: -- update transmission records in lock box.
3672: log_debug ('All payment records processed.');
3673: l_trans_rec_count := get_rec_count (l_trans_req_id);
3674:
3675: UPDATE ar_payments_interface_all
3676: SET transmission_record_count = l_trans_rec_count
3677: WHERE transmission_request_id = l_trans_req_id
3678: AND record_type IN (l_transmission_hdr, l_transmission_trl);
3679: