513: END;
514: /* Populate the l_unres_inv_arr to be passed to the custom procedure
515: with mathcing numbers to be resolved. */
516: FOR app_rec IN get_applications( in_trans_req_id ) LOOP
517: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
518: app_rec.transmission_record_id,'AMT APP 1');
519: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
520: app_rec.transmission_record_id,'AMT APP 2');
521: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
515: with mathcing numbers to be resolved. */
516: FOR app_rec IN get_applications( in_trans_req_id ) LOOP
517: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
518: app_rec.transmission_record_id,'AMT APP 1');
519: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
520: app_rec.transmission_record_id,'AMT APP 2');
521: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
522: app_rec.transmission_record_id,'AMT APP 3');
523: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
517: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
518: app_rec.transmission_record_id,'AMT APP 1');
519: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
520: app_rec.transmission_record_id,'AMT APP 2');
521: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
522: app_rec.transmission_record_id,'AMT APP 3');
523: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
524: app_rec.transmission_record_id,'AMT APP 4');
525: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
519: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
520: app_rec.transmission_record_id,'AMT APP 2');
521: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
522: app_rec.transmission_record_id,'AMT APP 3');
523: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
524: app_rec.transmission_record_id,'AMT APP 4');
525: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
526: app_rec.transmission_record_id,'AMT APP 5');
527: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
521: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
522: app_rec.transmission_record_id,'AMT APP 3');
523: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
524: app_rec.transmission_record_id,'AMT APP 4');
525: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
526: app_rec.transmission_record_id,'AMT APP 5');
527: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
528: app_rec.transmission_record_id,'AMT APP 6');
529: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
523: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
524: app_rec.transmission_record_id,'AMT APP 4');
525: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
526: app_rec.transmission_record_id,'AMT APP 5');
527: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
528: app_rec.transmission_record_id,'AMT APP 6');
529: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
530: app_rec.transmission_record_id,'AMT APP 7');
531: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
525: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
526: app_rec.transmission_record_id,'AMT APP 5');
527: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
528: app_rec.transmission_record_id,'AMT APP 6');
529: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
530: app_rec.transmission_record_id,'AMT APP 7');
531: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
532: app_rec.transmission_record_id,'AMT APP 8');
533: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
527: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
528: app_rec.transmission_record_id,'AMT APP 6');
529: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
530: app_rec.transmission_record_id,'AMT APP 7');
531: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
532: app_rec.transmission_record_id,'AMT APP 8');
533: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
534: app_rec.transmission_record_id,'AMT APP FROM 1');
535: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
529: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
530: app_rec.transmission_record_id,'AMT APP 7');
531: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
532: app_rec.transmission_record_id,'AMT APP 8');
533: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
534: app_rec.transmission_record_id,'AMT APP FROM 1');
535: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
536: app_rec.transmission_record_id,'AMT APP FROM 2');
537: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
531: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
532: app_rec.transmission_record_id,'AMT APP 8');
533: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
534: app_rec.transmission_record_id,'AMT APP FROM 1');
535: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
536: app_rec.transmission_record_id,'AMT APP FROM 2');
537: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
538: app_rec.transmission_record_id,'AMT APP FROM 3');
539: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
533: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
534: app_rec.transmission_record_id,'AMT APP FROM 1');
535: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
536: app_rec.transmission_record_id,'AMT APP FROM 2');
537: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
538: app_rec.transmission_record_id,'AMT APP FROM 3');
539: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
540: app_rec.transmission_record_id,'AMT APP FROM 4');
541: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
535: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
536: app_rec.transmission_record_id,'AMT APP FROM 2');
537: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
538: app_rec.transmission_record_id,'AMT APP FROM 3');
539: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
540: app_rec.transmission_record_id,'AMT APP FROM 4');
541: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
542: app_rec.transmission_record_id,'AMT APP FROM 5');
543: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
537: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
538: app_rec.transmission_record_id,'AMT APP FROM 3');
539: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
540: app_rec.transmission_record_id,'AMT APP FROM 4');
541: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
542: app_rec.transmission_record_id,'AMT APP FROM 5');
543: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
544: app_rec.transmission_record_id,'AMT APP FROM 6');
545: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
539: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
540: app_rec.transmission_record_id,'AMT APP FROM 4');
541: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
542: app_rec.transmission_record_id,'AMT APP FROM 5');
543: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
544: app_rec.transmission_record_id,'AMT APP FROM 6');
545: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
546: app_rec.transmission_record_id,'AMT APP FROM 7');
547: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
541: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
542: app_rec.transmission_record_id,'AMT APP FROM 5');
543: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
544: app_rec.transmission_record_id,'AMT APP FROM 6');
545: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
546: app_rec.transmission_record_id,'AMT APP FROM 7');
547: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
548: app_rec.transmission_record_id,'AMT APP FROM 8');
549: format_amount_app := format_amount_app1;
543: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
544: app_rec.transmission_record_id,'AMT APP FROM 6');
545: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
546: app_rec.transmission_record_id,'AMT APP FROM 7');
547: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
548: app_rec.transmission_record_id,'AMT APP FROM 8');
549: format_amount_app := format_amount_app1;
550:
551: select max(fc.precision)