DBA Data[Home] [Help]

APPS.ARP_LOCKBOX_HOOK_PVT dependencies on ARP_PROCESS_LOCKBOX

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)