498: END;
499: /* Populate the l_unres_inv_arr to be passed to the custom procedure
500: with mathcing numbers to be resolved. */
501: FOR app_rec IN get_applications( in_trans_req_id ) LOOP
502: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
503: app_rec.transmission_record_id,'AMT APP 1');
504: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
505: app_rec.transmission_record_id,'AMT APP 2');
506: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
500: with mathcing numbers to be resolved. */
501: FOR app_rec IN get_applications( in_trans_req_id ) LOOP
502: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
503: app_rec.transmission_record_id,'AMT APP 1');
504: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
505: app_rec.transmission_record_id,'AMT APP 2');
506: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
507: app_rec.transmission_record_id,'AMT APP 3');
508: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
502: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
503: app_rec.transmission_record_id,'AMT APP 1');
504: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
505: app_rec.transmission_record_id,'AMT APP 2');
506: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
507: app_rec.transmission_record_id,'AMT APP 3');
508: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
509: app_rec.transmission_record_id,'AMT APP 4');
510: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
504: format_amount2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
505: app_rec.transmission_record_id,'AMT APP 2');
506: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
507: app_rec.transmission_record_id,'AMT APP 3');
508: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
509: app_rec.transmission_record_id,'AMT APP 4');
510: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
511: app_rec.transmission_record_id,'AMT APP 5');
512: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
506: format_amount3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
507: app_rec.transmission_record_id,'AMT APP 3');
508: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
509: app_rec.transmission_record_id,'AMT APP 4');
510: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
511: app_rec.transmission_record_id,'AMT APP 5');
512: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
513: app_rec.transmission_record_id,'AMT APP 6');
514: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
508: format_amount4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
509: app_rec.transmission_record_id,'AMT APP 4');
510: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
511: app_rec.transmission_record_id,'AMT APP 5');
512: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
513: app_rec.transmission_record_id,'AMT APP 6');
514: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
515: app_rec.transmission_record_id,'AMT APP 7');
516: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
510: format_amount5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
511: app_rec.transmission_record_id,'AMT APP 5');
512: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
513: app_rec.transmission_record_id,'AMT APP 6');
514: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
515: app_rec.transmission_record_id,'AMT APP 7');
516: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
517: app_rec.transmission_record_id,'AMT APP 8');
518: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
512: format_amount6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
513: app_rec.transmission_record_id,'AMT APP 6');
514: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
515: app_rec.transmission_record_id,'AMT APP 7');
516: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
517: app_rec.transmission_record_id,'AMT APP 8');
518: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
519: app_rec.transmission_record_id,'AMT APP FROM 1');
520: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
514: format_amount7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
515: app_rec.transmission_record_id,'AMT APP 7');
516: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
517: app_rec.transmission_record_id,'AMT APP 8');
518: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
519: app_rec.transmission_record_id,'AMT APP FROM 1');
520: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
521: app_rec.transmission_record_id,'AMT APP FROM 2');
522: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
516: format_amount8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
517: app_rec.transmission_record_id,'AMT APP 8');
518: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
519: app_rec.transmission_record_id,'AMT APP FROM 1');
520: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
521: app_rec.transmission_record_id,'AMT APP FROM 2');
522: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
523: app_rec.transmission_record_id,'AMT APP FROM 3');
524: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
518: format_amount_app1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
519: app_rec.transmission_record_id,'AMT APP FROM 1');
520: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
521: app_rec.transmission_record_id,'AMT APP FROM 2');
522: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
523: app_rec.transmission_record_id,'AMT APP FROM 3');
524: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
525: app_rec.transmission_record_id,'AMT APP FROM 4');
526: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
520: format_amount_app2 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
521: app_rec.transmission_record_id,'AMT APP FROM 2');
522: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
523: app_rec.transmission_record_id,'AMT APP FROM 3');
524: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
525: app_rec.transmission_record_id,'AMT APP FROM 4');
526: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
527: app_rec.transmission_record_id,'AMT APP FROM 5');
528: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
522: format_amount_app3 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
523: app_rec.transmission_record_id,'AMT APP FROM 3');
524: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
525: app_rec.transmission_record_id,'AMT APP FROM 4');
526: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
527: app_rec.transmission_record_id,'AMT APP FROM 5');
528: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
529: app_rec.transmission_record_id,'AMT APP FROM 6');
530: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
524: format_amount_app4 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
525: app_rec.transmission_record_id,'AMT APP FROM 4');
526: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
527: app_rec.transmission_record_id,'AMT APP FROM 5');
528: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
529: app_rec.transmission_record_id,'AMT APP FROM 6');
530: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
531: app_rec.transmission_record_id,'AMT APP FROM 7');
532: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
526: format_amount_app5 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
527: app_rec.transmission_record_id,'AMT APP FROM 5');
528: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
529: app_rec.transmission_record_id,'AMT APP FROM 6');
530: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
531: app_rec.transmission_record_id,'AMT APP FROM 7');
532: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
533: app_rec.transmission_record_id,'AMT APP FROM 8');
534: format_amount_app := format_amount_app1;
528: format_amount_app6 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
529: app_rec.transmission_record_id,'AMT APP FROM 6');
530: format_amount_app7 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
531: app_rec.transmission_record_id,'AMT APP FROM 7');
532: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,
533: app_rec.transmission_record_id,'AMT APP FROM 8');
534: format_amount_app := format_amount_app1;
535:
536: select max(fc.precision)