eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on AR_PAYMENTS_INTERFACE

Line 40: FROM ar_payments_interface_all

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;

Line 330: p_trans_req_id IN ar_payments_interface.transmission_request_id%TYPE

326: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: p_trans_req_id IN ar_payments_interface.transmission_request_id%TYPE
331: ) IS
332: ---------------------------
333: -- DECLARE Local Variables
334: ---------------------------

Line 339: l_org_id ar_payments_interface_all.org_id%TYPE;

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

Line 341: l_status CONSTANT ar_payments_interface_all.status%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

Line 343: l_trans_req_id ar_payments_interface_all.transmission_request_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

Line 345: l_transmission_id ar_payments_interface_all.transmission_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

Line 347: l_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

Line 349: l_last_transmission_record_id ar_payments_interface_all.transmission_record_id%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

Line 351: l_overflow_sequence ar_payments_interface_all.overflow_sequence%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

Line 353: l_lockbox_number ar_payments_interface_all.lockbox_number%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

Line 355: l_batch_name ar_payments_interface_all.batch_name%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

Line 375: l_customer_number ar_payments_interface_all.customer_number%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

Line 377: l_remittance_amount ar_payments_interface_all.remittance_amount%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

Line 379: l_currency_code ar_payments_interface_all.currency_code%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

Line 381: l_item_number ar_payments_interface_all.item_number%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

Line 383: l_inv_ref 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

Line 385: l_invoice ar_payments_interface_all.invoice1%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

Line 387: l_amt_appl 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

Line 389: l_amount_applied ar_payments_interface_all.amount_applied1%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

Line 391: l_check_number ar_payments_interface_all.check_number%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

Line 393: l_receipt_date ar_payments_interface_all.receipt_date%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

Line 395: l_transit_routing_number ar_payments_interface_all.transit_routing_number%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

Line 397: l_account ar_payments_interface_all.ACCOUNT%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

Line 399: l_invoice1 ar_payments_interface_all.invoice1%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

Line 401: l_invoice2 ar_payments_interface_all.invoice2%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

Line 403: l_invoice3 ar_payments_interface_all.invoice3%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

Line 405: l_invoice4 ar_payments_interface_all.invoice4%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

Line 407: l_invoice5 ar_payments_interface_all.invoice5%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

Line 409: l_invoice6 ar_payments_interface_all.invoice6%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

Line 411: l_invoice7 ar_payments_interface_all.invoice7%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

Line 413: l_invoice8 ar_payments_interface_all.invoice8%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

Line 415: l_new_invoice1 ar_payments_interface_all.invoice1%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

Line 417: l_new_invoice2 ar_payments_interface_all.invoice2%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

Line 419: l_new_invoice3 ar_payments_interface_all.invoice3%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

Line 421: l_new_invoice4 ar_payments_interface_all.invoice4%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

Line 423: l_new_invoice5 ar_payments_interface_all.invoice5%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

Line 425: l_new_invoice6 ar_payments_interface_all.invoice6%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

Line 427: l_new_invoice7 ar_payments_interface_all.invoice7%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:

Line 429: l_new_invoice8 ar_payments_interface_all.invoice8%TYPE

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

Line 434: l_amount_applied1 ar_payments_interface_all.tmp_amt_applied1%TYPE

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

Line 436: l_amount_applied2 ar_payments_interface_all.tmp_amt_applied2%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

Line 438: l_amount_applied3 ar_payments_interface_all.tmp_amt_applied3%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

Line 440: l_amount_applied4 ar_payments_interface_all.tmp_amt_applied4%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

Line 442: l_amount_applied5 ar_payments_interface_all.tmp_amt_applied5%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

Line 444: l_amount_applied6 ar_payments_interface_all.tmp_amt_applied6%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

Line 446: l_amount_applied7 ar_payments_interface_all.tmp_amt_applied7%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;

Line 448: l_amount_applied8 ar_payments_interface_all.tmp_amt_applied8%TYPE

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;

Line 450: l_amount_app_from1 ar_payments_interface_all.tmp_amt_applied_from1%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;

Line 451: l_amount_app_from2 ar_payments_interface_all.tmp_amt_applied_from2%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;

Line 452: l_amount_app_from3 ar_payments_interface_all.tmp_amt_applied_from3%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;

Line 453: l_amount_app_from4 ar_payments_interface_all.tmp_amt_applied_from4%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;

Line 454: l_amount_app_from5 ar_payments_interface_all.tmp_amt_applied_from5%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;

Line 455: l_amount_app_from6 ar_payments_interface_all.tmp_amt_applied_from6%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;

Line 456: l_amount_app_from7 ar_payments_interface_all.tmp_amt_applied_from7%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;

Line 457: l_amount_app_from8 ar_payments_interface_all.tmp_amt_applied_from8%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;

Line 458: l_trans_to_receipt_rate1 ar_payments_interface_all.trans_to_receipt_rate1%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;

Line 459: l_trans_to_receipt_rate2 ar_payments_interface_all.trans_to_receipt_rate2%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;

Line 460: l_trans_to_receipt_rate3 ar_payments_interface_all.trans_to_receipt_rate3%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;

Line 461: l_trans_to_receipt_rate4 ar_payments_interface_all.trans_to_receipt_rate4%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;

Line 462: l_trans_to_receipt_rate5 ar_payments_interface_all.trans_to_receipt_rate5%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:

Line 463: l_trans_to_receipt_rate6 ar_payments_interface_all.trans_to_receipt_rate6%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:
467: l_returned_curr_code ar_payments_interface_all.currency_code%TYPE DEFAULT NULL;

Line 464: l_trans_to_receipt_rate7 ar_payments_interface_all.trans_to_receipt_rate7%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;

Line 465: l_trans_to_receipt_rate8 ar_payments_interface_all.trans_to_receipt_rate8%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;

Line 467: l_returned_curr_code ar_payments_interface_all.currency_code%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;

Line 468: l_returned_amount_to ar_payments_interface_all.tmp_amt_applied1%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;
472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%TYPE DEFAULT NULL;

Line 469: l_returned_amount_from ar_payments_interface_all.tmp_amt_applied_from1%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;

Line 472: l_tmp_amount_applied ar_payments_interface_all.tmp_amt_applied1%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

Line 473: l_tmp_amount_app_from ar_payments_interface_all.tmp_amt_applied_from1%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
477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE

Line 474: l_tmp_currency_code ar_payments_interface_all.currency_code%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
478: DEFAULT NULL;

Line 477: l_new_amount_applied1 ar_payments_interface_all.amount_applied1%TYPE

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

Line 479: l_new_amount_applied2 ar_payments_interface_all.amount_applied2%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

Line 481: l_new_amount_applied3 ar_payments_interface_all.amount_applied3%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

Line 483: l_new_amount_applied4 ar_payments_interface_all.amount_applied4%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

Line 485: l_new_amount_applied5 ar_payments_interface_all.amount_applied5%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

Line 487: l_new_amount_applied6 ar_payments_interface_all.amount_applied6%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

Line 489: l_new_amount_applied7 ar_payments_interface_all.amount_applied7%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:

Line 491: l_new_amount_applied8 ar_payments_interface_all.amount_applied8%TYPE

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;

Line 494: l_new_amount_applied_from1 ar_payments_interface_all.amount_applied_from1%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;

Line 495: l_new_amount_applied_from2 ar_payments_interface_all.amount_applied_from2%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;

Line 496: l_new_amount_applied_from3 ar_payments_interface_all.amount_applied_from3%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;

Line 497: l_new_amount_applied_from4 ar_payments_interface_all.amount_applied_from4%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;

Line 498: l_new_amount_applied_from5 ar_payments_interface_all.amount_applied_from5%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:

Line 499: l_new_amount_applied_from6 ar_payments_interface_all.amount_applied_from6%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:
503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;

Line 500: l_new_amount_applied_from7 ar_payments_interface_all.amount_applied_from7%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;

Line 501: l_new_amount_applied_from8 ar_payments_interface_all.amount_applied_from8%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;

Line 503: l_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%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;

Line 504: l_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%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;

Line 505: l_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%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;

Line 506: l_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%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;

Line 507: l_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%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:

Line 508: l_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%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:
512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%TYPE DEFAULT NULL;

Line 509: l_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%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;

Line 510: l_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%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;

Line 512: l_new_currency_code1 ar_payments_interface_all.INVOICE_CURRENCY_CODE1%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;

Line 513: l_new_currency_code2 ar_payments_interface_all.INVOICE_CURRENCY_CODE2%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;

Line 514: l_new_currency_code3 ar_payments_interface_all.INVOICE_CURRENCY_CODE3%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;

Line 515: l_new_currency_code4 ar_payments_interface_all.INVOICE_CURRENCY_CODE4%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;

Line 516: l_new_currency_code5 ar_payments_interface_all.INVOICE_CURRENCY_CODE5%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:

Line 517: l_new_currency_code6 ar_payments_interface_all.INVOICE_CURRENCY_CODE6%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:
521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%TYPE DEFAULT NULL;

Line 518: l_new_currency_code7 ar_payments_interface_all.INVOICE_CURRENCY_CODE7%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;

Line 519: l_new_currency_code8 ar_payments_interface_all.INVOICE_CURRENCY_CODE8%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;

Line 521: l_new_trans_to_rct_rate1 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%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;

Line 522: l_new_trans_to_rct_rate2 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE2%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;

Line 523: l_new_trans_to_rct_rate3 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE3%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;

Line 524: l_new_trans_to_rct_rate4 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE4%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;

Line 525: l_new_trans_to_rct_rate5 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE5%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:

Line 526: l_new_trans_to_rct_rate6 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE6%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:
530:

Line 527: l_new_trans_to_rct_rate7 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE7%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:
531: l_tolerance okl_cash_allctn_rls.amount_tolerance_percent%TYPE

Line 528: l_new_trans_to_rct_rate8 ar_payments_interface_all.TRANS_TO_RECEIPT_RATE8%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
532: DEFAULT NULL;

Line 597: invoice_number ar_payments_interface_all.invoice1%TYPE

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

Line 599: amount_applied ar_payments_interface_all.amount_applied1%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

Line 601: amount_applied_from ar_payments_interface_all.AMOUNT_APPLIED_FROM1%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

Line 603: trans_to_receipt_rate ar_payments_interface_all.TRANS_TO_RECEIPT_RATE1%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: );

Line 605: currency_code ar_payments_interface_all.currency_code%TYPE

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

Line 750: FROM ar_payments_interface_all

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:

Line 831: FROM ar_payments_interface_all

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

Line 850: FROM ar_payments_interface_all

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

Line 864: FROM ar_payments_interface_all

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

Line 1953: SELECT ar_payments_interface_s.NEXTVAL

1949: * POWER (10, l_amt_from8_prec);
1950: l_new_currency_code8 := l_okl_rcpt_tbl (k).inv_hdr_rec.invoice_currency_code;
1951: l_new_trans_to_rct_rate8 := l_okl_rcpt_tbl (k).inv_hdr_rec.trans_to_receipt_rate;
1952:
1953: SELECT ar_payments_interface_s.NEXTVAL
1954: INTO l_transmission_rec_id_of
1955: FROM DUAL;
1956:
1957: log_debug

Line 1965: INSERT INTO ar_payments_interface_all

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,

Line 2260: UPDATE ar_payments_interface_all

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,

Line 3190: SELECT ar_payments_interface_s.NEXTVAL

3186: l_new_currency_code8 := l_okl_rcpt_tbl (k).inv_hdr_rec.invoice_currency_code;
3187: l_new_trans_to_rct_rate8 := l_okl_rcpt_tbl (k).inv_hdr_rec.trans_to_receipt_rate;
3188:
3189: -- create new overflow records
3190: SELECT ar_payments_interface_s.NEXTVAL
3191: INTO l_transmission_rec_id_of
3192: FROM DUAL;
3193:
3194: log_debug

Line 3202: INSERT INTO ar_payments_interface_all

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,

Line 3516: DELETE FROM ar_payments_interface_all

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:

Line 3555: UPDATE ar_payments_interface_all

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

Line 3642: UPDATE ar_payments_interface_all

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:

Line 3658: UPDATE ar_payments_interface_all

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;

Line 3675: UPDATE ar_payments_interface_all

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: