DBA Data[Home] [Help]

APPS.ARP_LOCKBOX_HOOK_PVT dependencies on ARP_PROCESS_LOCKBOX

Line 517: format_amount1 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,

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,

Line 519: format_amount2 := 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,

Line 521: format_amount3 := 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,

Line 523: format_amount4 := 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,

Line 525: format_amount5 := 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,

Line 527: format_amount6 := 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,

Line 529: format_amount7 := 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,

Line 531: format_amount8 := 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,

Line 533: format_amount_app1 := 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,

Line 535: format_amount_app2 := 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,

Line 537: format_amount_app3 := 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,

Line 539: format_amount_app4 := 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,

Line 541: format_amount_app5 := 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,

Line 543: format_amount_app6 := 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,

Line 545: format_amount_app7 := 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;

Line 547: format_amount_app8 := ARP_PROCESS_LOCKBOX.get_format_amount(in_trans_req_id,

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)