425: batch_id NUMBER DEFAULT NULL
426: );
427:
428: g_api_outputs api_outputs_type;
429: g_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
430: g_dist_exist boolean;
431: g_sc_exist boolean;
432: g_cont_exist boolean;
433:
548: delete_flag VARCHAR2(1) := 'N',
549: dist_amount NUMBER := 0,
550: gl_date DATE,
551: Accounting_rule_duration
552: ra_customer_trx_lines.Accounting_rule_duration%type,
553: Accounting_rule_id
554: ra_customer_trx_lines.Accounting_rule_id%type,
555: Attribute1
556: ra_customer_trx_lines.Attribute1%type,
550: gl_date DATE,
551: Accounting_rule_duration
552: ra_customer_trx_lines.Accounting_rule_duration%type,
553: Accounting_rule_id
554: ra_customer_trx_lines.Accounting_rule_id%type,
555: Attribute1
556: ra_customer_trx_lines.Attribute1%type,
557: Attribute10
558: ra_customer_trx_lines.Attribute10%type,
552: ra_customer_trx_lines.Accounting_rule_duration%type,
553: Accounting_rule_id
554: ra_customer_trx_lines.Accounting_rule_id%type,
555: Attribute1
556: ra_customer_trx_lines.Attribute1%type,
557: Attribute10
558: ra_customer_trx_lines.Attribute10%type,
559: Attribute11
560: ra_customer_trx_lines.Attribute11%type,
554: ra_customer_trx_lines.Accounting_rule_id%type,
555: Attribute1
556: ra_customer_trx_lines.Attribute1%type,
557: Attribute10
558: ra_customer_trx_lines.Attribute10%type,
559: Attribute11
560: ra_customer_trx_lines.Attribute11%type,
561: Attribute12
562: ra_customer_trx_lines.Attribute12%type,
556: ra_customer_trx_lines.Attribute1%type,
557: Attribute10
558: ra_customer_trx_lines.Attribute10%type,
559: Attribute11
560: ra_customer_trx_lines.Attribute11%type,
561: Attribute12
562: ra_customer_trx_lines.Attribute12%type,
563: Attribute13
564: ra_customer_trx_lines.Attribute13%type,
558: ra_customer_trx_lines.Attribute10%type,
559: Attribute11
560: ra_customer_trx_lines.Attribute11%type,
561: Attribute12
562: ra_customer_trx_lines.Attribute12%type,
563: Attribute13
564: ra_customer_trx_lines.Attribute13%type,
565: Attribute14
566: ra_customer_trx_lines.Attribute14%type,
560: ra_customer_trx_lines.Attribute11%type,
561: Attribute12
562: ra_customer_trx_lines.Attribute12%type,
563: Attribute13
564: ra_customer_trx_lines.Attribute13%type,
565: Attribute14
566: ra_customer_trx_lines.Attribute14%type,
567: Attribute15
568: ra_customer_trx_lines.Attribute15%type,
562: ra_customer_trx_lines.Attribute12%type,
563: Attribute13
564: ra_customer_trx_lines.Attribute13%type,
565: Attribute14
566: ra_customer_trx_lines.Attribute14%type,
567: Attribute15
568: ra_customer_trx_lines.Attribute15%type,
569: Attribute2
570: ra_customer_trx_lines.Attribute2%type,
564: ra_customer_trx_lines.Attribute13%type,
565: Attribute14
566: ra_customer_trx_lines.Attribute14%type,
567: Attribute15
568: ra_customer_trx_lines.Attribute15%type,
569: Attribute2
570: ra_customer_trx_lines.Attribute2%type,
571: Attribute3
572: ra_customer_trx_lines.Attribute3%type,
566: ra_customer_trx_lines.Attribute14%type,
567: Attribute15
568: ra_customer_trx_lines.Attribute15%type,
569: Attribute2
570: ra_customer_trx_lines.Attribute2%type,
571: Attribute3
572: ra_customer_trx_lines.Attribute3%type,
573: Attribute4
574: ra_customer_trx_lines.Attribute4%type,
568: ra_customer_trx_lines.Attribute15%type,
569: Attribute2
570: ra_customer_trx_lines.Attribute2%type,
571: Attribute3
572: ra_customer_trx_lines.Attribute3%type,
573: Attribute4
574: ra_customer_trx_lines.Attribute4%type,
575: Attribute5
576: ra_customer_trx_lines.Attribute5%type,
570: ra_customer_trx_lines.Attribute2%type,
571: Attribute3
572: ra_customer_trx_lines.Attribute3%type,
573: Attribute4
574: ra_customer_trx_lines.Attribute4%type,
575: Attribute5
576: ra_customer_trx_lines.Attribute5%type,
577: Attribute6
578: ra_customer_trx_lines.Attribute6%type,
572: ra_customer_trx_lines.Attribute3%type,
573: Attribute4
574: ra_customer_trx_lines.Attribute4%type,
575: Attribute5
576: ra_customer_trx_lines.Attribute5%type,
577: Attribute6
578: ra_customer_trx_lines.Attribute6%type,
579: Attribute7
580: ra_customer_trx_lines.Attribute7%type,
574: ra_customer_trx_lines.Attribute4%type,
575: Attribute5
576: ra_customer_trx_lines.Attribute5%type,
577: Attribute6
578: ra_customer_trx_lines.Attribute6%type,
579: Attribute7
580: ra_customer_trx_lines.Attribute7%type,
581: Attribute8
582: ra_customer_trx_lines.Attribute8%type,
576: ra_customer_trx_lines.Attribute5%type,
577: Attribute6
578: ra_customer_trx_lines.Attribute6%type,
579: Attribute7
580: ra_customer_trx_lines.Attribute7%type,
581: Attribute8
582: ra_customer_trx_lines.Attribute8%type,
583: Attribute9
584: ra_customer_trx_lines.Attribute9%type,
578: ra_customer_trx_lines.Attribute6%type,
579: Attribute7
580: ra_customer_trx_lines.Attribute7%type,
581: Attribute8
582: ra_customer_trx_lines.Attribute8%type,
583: Attribute9
584: ra_customer_trx_lines.Attribute9%type,
585: Attribute_category
586: ra_customer_trx_lines.Attribute_category%type,
580: ra_customer_trx_lines.Attribute7%type,
581: Attribute8
582: ra_customer_trx_lines.Attribute8%type,
583: Attribute9
584: ra_customer_trx_lines.Attribute9%type,
585: Attribute_category
586: ra_customer_trx_lines.Attribute_category%type,
587: Autorule_complete_flag
588: ra_customer_trx_lines.Autorule_complete_flag%type,
582: ra_customer_trx_lines.Attribute8%type,
583: Attribute9
584: ra_customer_trx_lines.Attribute9%type,
585: Attribute_category
586: ra_customer_trx_lines.Attribute_category%type,
587: Autorule_complete_flag
588: ra_customer_trx_lines.Autorule_complete_flag%type,
589: Autorule_duration_processed
590: ra_customer_trx_lines.Autorule_duration_processed%type,
584: ra_customer_trx_lines.Attribute9%type,
585: Attribute_category
586: ra_customer_trx_lines.Attribute_category%type,
587: Autorule_complete_flag
588: ra_customer_trx_lines.Autorule_complete_flag%type,
589: Autorule_duration_processed
590: ra_customer_trx_lines.Autorule_duration_processed%type,
591: Autotax
592: ra_customer_trx_lines.Autotax%type,
586: ra_customer_trx_lines.Attribute_category%type,
587: Autorule_complete_flag
588: ra_customer_trx_lines.Autorule_complete_flag%type,
589: Autorule_duration_processed
590: ra_customer_trx_lines.Autorule_duration_processed%type,
591: Autotax
592: ra_customer_trx_lines.Autotax%type,
593: Created_by
594: ra_customer_trx_lines.Created_by%type,
588: ra_customer_trx_lines.Autorule_complete_flag%type,
589: Autorule_duration_processed
590: ra_customer_trx_lines.Autorule_duration_processed%type,
591: Autotax
592: ra_customer_trx_lines.Autotax%type,
593: Created_by
594: ra_customer_trx_lines.Created_by%type,
595: Creation_date
596: ra_customer_trx_lines.Creation_date%type,
590: ra_customer_trx_lines.Autorule_duration_processed%type,
591: Autotax
592: ra_customer_trx_lines.Autotax%type,
593: Created_by
594: ra_customer_trx_lines.Created_by%type,
595: Creation_date
596: ra_customer_trx_lines.Creation_date%type,
597: Customer_trx_id
598: ra_customer_trx_lines.Customer_trx_id%type,
592: ra_customer_trx_lines.Autotax%type,
593: Created_by
594: ra_customer_trx_lines.Created_by%type,
595: Creation_date
596: ra_customer_trx_lines.Creation_date%type,
597: Customer_trx_id
598: ra_customer_trx_lines.Customer_trx_id%type,
599: Customer_trx_line_id
600: ra_customer_trx_lines.Customer_trx_line_id%type,
594: ra_customer_trx_lines.Created_by%type,
595: Creation_date
596: ra_customer_trx_lines.Creation_date%type,
597: Customer_trx_id
598: ra_customer_trx_lines.Customer_trx_id%type,
599: Customer_trx_line_id
600: ra_customer_trx_lines.Customer_trx_line_id%type,
601: Default_ussgl_transaction_code
602: ra_customer_trx_lines.Default_ussgl_transaction_code%type,
596: ra_customer_trx_lines.Creation_date%type,
597: Customer_trx_id
598: ra_customer_trx_lines.Customer_trx_id%type,
599: Customer_trx_line_id
600: ra_customer_trx_lines.Customer_trx_line_id%type,
601: Default_ussgl_transaction_code
602: ra_customer_trx_lines.Default_ussgl_transaction_code%type,
603: Default_ussgl_trx_code_context
604: ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
598: ra_customer_trx_lines.Customer_trx_id%type,
599: Customer_trx_line_id
600: ra_customer_trx_lines.Customer_trx_line_id%type,
601: Default_ussgl_transaction_code
602: ra_customer_trx_lines.Default_ussgl_transaction_code%type,
603: Default_ussgl_trx_code_context
604: ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
605: Description
606: ra_customer_trx_lines.Description%type,
600: ra_customer_trx_lines.Customer_trx_line_id%type,
601: Default_ussgl_transaction_code
602: ra_customer_trx_lines.Default_ussgl_transaction_code%type,
603: Default_ussgl_trx_code_context
604: ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
605: Description
606: ra_customer_trx_lines.Description%type,
607: Extended_amount
608: ra_customer_trx_lines.Extended_amount%type,
602: ra_customer_trx_lines.Default_ussgl_transaction_code%type,
603: Default_ussgl_trx_code_context
604: ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
605: Description
606: ra_customer_trx_lines.Description%type,
607: Extended_amount
608: ra_customer_trx_lines.Extended_amount%type,
609: Global_attribute1
610: ra_customer_trx_lines.Global_attribute1%type,
604: ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
605: Description
606: ra_customer_trx_lines.Description%type,
607: Extended_amount
608: ra_customer_trx_lines.Extended_amount%type,
609: Global_attribute1
610: ra_customer_trx_lines.Global_attribute1%type,
611: Global_attribute10
612: ra_customer_trx_lines.Global_attribute10%type,
606: ra_customer_trx_lines.Description%type,
607: Extended_amount
608: ra_customer_trx_lines.Extended_amount%type,
609: Global_attribute1
610: ra_customer_trx_lines.Global_attribute1%type,
611: Global_attribute10
612: ra_customer_trx_lines.Global_attribute10%type,
613: Global_attribute11
614: ra_customer_trx_lines.Global_attribute11%type,
608: ra_customer_trx_lines.Extended_amount%type,
609: Global_attribute1
610: ra_customer_trx_lines.Global_attribute1%type,
611: Global_attribute10
612: ra_customer_trx_lines.Global_attribute10%type,
613: Global_attribute11
614: ra_customer_trx_lines.Global_attribute11%type,
615: Global_attribute12
616: ra_customer_trx_lines.Global_attribute12%type,
610: ra_customer_trx_lines.Global_attribute1%type,
611: Global_attribute10
612: ra_customer_trx_lines.Global_attribute10%type,
613: Global_attribute11
614: ra_customer_trx_lines.Global_attribute11%type,
615: Global_attribute12
616: ra_customer_trx_lines.Global_attribute12%type,
617: Global_attribute13
618: ra_customer_trx_lines.Global_attribute13%type,
612: ra_customer_trx_lines.Global_attribute10%type,
613: Global_attribute11
614: ra_customer_trx_lines.Global_attribute11%type,
615: Global_attribute12
616: ra_customer_trx_lines.Global_attribute12%type,
617: Global_attribute13
618: ra_customer_trx_lines.Global_attribute13%type,
619: Global_attribute14
620: ra_customer_trx_lines.Global_attribute14%type,
614: ra_customer_trx_lines.Global_attribute11%type,
615: Global_attribute12
616: ra_customer_trx_lines.Global_attribute12%type,
617: Global_attribute13
618: ra_customer_trx_lines.Global_attribute13%type,
619: Global_attribute14
620: ra_customer_trx_lines.Global_attribute14%type,
621: Global_attribute15
622: ra_customer_trx_lines.Global_attribute15%type,
616: ra_customer_trx_lines.Global_attribute12%type,
617: Global_attribute13
618: ra_customer_trx_lines.Global_attribute13%type,
619: Global_attribute14
620: ra_customer_trx_lines.Global_attribute14%type,
621: Global_attribute15
622: ra_customer_trx_lines.Global_attribute15%type,
623: Global_attribute16
624: ra_customer_trx_lines.Global_attribute16%type,
618: ra_customer_trx_lines.Global_attribute13%type,
619: Global_attribute14
620: ra_customer_trx_lines.Global_attribute14%type,
621: Global_attribute15
622: ra_customer_trx_lines.Global_attribute15%type,
623: Global_attribute16
624: ra_customer_trx_lines.Global_attribute16%type,
625: Global_attribute17
626: ra_customer_trx_lines.Global_attribute17%type,
620: ra_customer_trx_lines.Global_attribute14%type,
621: Global_attribute15
622: ra_customer_trx_lines.Global_attribute15%type,
623: Global_attribute16
624: ra_customer_trx_lines.Global_attribute16%type,
625: Global_attribute17
626: ra_customer_trx_lines.Global_attribute17%type,
627: Global_attribute18
628: ra_customer_trx_lines.Global_attribute18%type,
622: ra_customer_trx_lines.Global_attribute15%type,
623: Global_attribute16
624: ra_customer_trx_lines.Global_attribute16%type,
625: Global_attribute17
626: ra_customer_trx_lines.Global_attribute17%type,
627: Global_attribute18
628: ra_customer_trx_lines.Global_attribute18%type,
629: Global_attribute19
630: ra_customer_trx_lines.Global_attribute19%type,
624: ra_customer_trx_lines.Global_attribute16%type,
625: Global_attribute17
626: ra_customer_trx_lines.Global_attribute17%type,
627: Global_attribute18
628: ra_customer_trx_lines.Global_attribute18%type,
629: Global_attribute19
630: ra_customer_trx_lines.Global_attribute19%type,
631: Global_attribute2
632: ra_customer_trx_lines.Global_attribute2%type,
626: ra_customer_trx_lines.Global_attribute17%type,
627: Global_attribute18
628: ra_customer_trx_lines.Global_attribute18%type,
629: Global_attribute19
630: ra_customer_trx_lines.Global_attribute19%type,
631: Global_attribute2
632: ra_customer_trx_lines.Global_attribute2%type,
633: Global_attribute20
634: ra_customer_trx_lines.Global_attribute20%type,
628: ra_customer_trx_lines.Global_attribute18%type,
629: Global_attribute19
630: ra_customer_trx_lines.Global_attribute19%type,
631: Global_attribute2
632: ra_customer_trx_lines.Global_attribute2%type,
633: Global_attribute20
634: ra_customer_trx_lines.Global_attribute20%type,
635: Global_attribute3
636: ra_customer_trx_lines.Global_attribute3%type,
630: ra_customer_trx_lines.Global_attribute19%type,
631: Global_attribute2
632: ra_customer_trx_lines.Global_attribute2%type,
633: Global_attribute20
634: ra_customer_trx_lines.Global_attribute20%type,
635: Global_attribute3
636: ra_customer_trx_lines.Global_attribute3%type,
637: Global_attribute4
638: ra_customer_trx_lines.Global_attribute4%type,
632: ra_customer_trx_lines.Global_attribute2%type,
633: Global_attribute20
634: ra_customer_trx_lines.Global_attribute20%type,
635: Global_attribute3
636: ra_customer_trx_lines.Global_attribute3%type,
637: Global_attribute4
638: ra_customer_trx_lines.Global_attribute4%type,
639: Global_attribute5
640: ra_customer_trx_lines.Global_attribute5%type,
634: ra_customer_trx_lines.Global_attribute20%type,
635: Global_attribute3
636: ra_customer_trx_lines.Global_attribute3%type,
637: Global_attribute4
638: ra_customer_trx_lines.Global_attribute4%type,
639: Global_attribute5
640: ra_customer_trx_lines.Global_attribute5%type,
641: Global_attribute6
642: ra_customer_trx_lines.Global_attribute6%type,
636: ra_customer_trx_lines.Global_attribute3%type,
637: Global_attribute4
638: ra_customer_trx_lines.Global_attribute4%type,
639: Global_attribute5
640: ra_customer_trx_lines.Global_attribute5%type,
641: Global_attribute6
642: ra_customer_trx_lines.Global_attribute6%type,
643: Global_attribute7
644: ra_customer_trx_lines.Global_attribute7%type,
638: ra_customer_trx_lines.Global_attribute4%type,
639: Global_attribute5
640: ra_customer_trx_lines.Global_attribute5%type,
641: Global_attribute6
642: ra_customer_trx_lines.Global_attribute6%type,
643: Global_attribute7
644: ra_customer_trx_lines.Global_attribute7%type,
645: Global_attribute8
646: ra_customer_trx_lines.Global_attribute8%type,
640: ra_customer_trx_lines.Global_attribute5%type,
641: Global_attribute6
642: ra_customer_trx_lines.Global_attribute6%type,
643: Global_attribute7
644: ra_customer_trx_lines.Global_attribute7%type,
645: Global_attribute8
646: ra_customer_trx_lines.Global_attribute8%type,
647: Global_attribute9
648: ra_customer_trx_lines.Global_attribute9%type,
642: ra_customer_trx_lines.Global_attribute6%type,
643: Global_attribute7
644: ra_customer_trx_lines.Global_attribute7%type,
645: Global_attribute8
646: ra_customer_trx_lines.Global_attribute8%type,
647: Global_attribute9
648: ra_customer_trx_lines.Global_attribute9%type,
649: Global_attribute_category
650: ra_customer_trx_lines.Global_attribute_category%type,
644: ra_customer_trx_lines.Global_attribute7%type,
645: Global_attribute8
646: ra_customer_trx_lines.Global_attribute8%type,
647: Global_attribute9
648: ra_customer_trx_lines.Global_attribute9%type,
649: Global_attribute_category
650: ra_customer_trx_lines.Global_attribute_category%type,
651: Initial_customer_trx_line_id
652: ra_customer_trx_lines.Initial_customer_trx_line_id%type,
646: ra_customer_trx_lines.Global_attribute8%type,
647: Global_attribute9
648: ra_customer_trx_lines.Global_attribute9%type,
649: Global_attribute_category
650: ra_customer_trx_lines.Global_attribute_category%type,
651: Initial_customer_trx_line_id
652: ra_customer_trx_lines.Initial_customer_trx_line_id%type,
653: Interface_line_attribute1
654: ra_customer_trx_lines.Interface_line_attribute1%type,
648: ra_customer_trx_lines.Global_attribute9%type,
649: Global_attribute_category
650: ra_customer_trx_lines.Global_attribute_category%type,
651: Initial_customer_trx_line_id
652: ra_customer_trx_lines.Initial_customer_trx_line_id%type,
653: Interface_line_attribute1
654: ra_customer_trx_lines.Interface_line_attribute1%type,
655: Interface_line_attribute10
656: ra_customer_trx_lines.Interface_line_attribute10%type,
650: ra_customer_trx_lines.Global_attribute_category%type,
651: Initial_customer_trx_line_id
652: ra_customer_trx_lines.Initial_customer_trx_line_id%type,
653: Interface_line_attribute1
654: ra_customer_trx_lines.Interface_line_attribute1%type,
655: Interface_line_attribute10
656: ra_customer_trx_lines.Interface_line_attribute10%type,
657: Interface_line_attribute11
658: ra_customer_trx_lines.Interface_line_attribute11%type,
652: ra_customer_trx_lines.Initial_customer_trx_line_id%type,
653: Interface_line_attribute1
654: ra_customer_trx_lines.Interface_line_attribute1%type,
655: Interface_line_attribute10
656: ra_customer_trx_lines.Interface_line_attribute10%type,
657: Interface_line_attribute11
658: ra_customer_trx_lines.Interface_line_attribute11%type,
659: Interface_line_attribute12
660: ra_customer_trx_lines.Interface_line_attribute12%type,
654: ra_customer_trx_lines.Interface_line_attribute1%type,
655: Interface_line_attribute10
656: ra_customer_trx_lines.Interface_line_attribute10%type,
657: Interface_line_attribute11
658: ra_customer_trx_lines.Interface_line_attribute11%type,
659: Interface_line_attribute12
660: ra_customer_trx_lines.Interface_line_attribute12%type,
661: Interface_line_attribute13
662: ra_customer_trx_lines.Interface_line_attribute13%type,
656: ra_customer_trx_lines.Interface_line_attribute10%type,
657: Interface_line_attribute11
658: ra_customer_trx_lines.Interface_line_attribute11%type,
659: Interface_line_attribute12
660: ra_customer_trx_lines.Interface_line_attribute12%type,
661: Interface_line_attribute13
662: ra_customer_trx_lines.Interface_line_attribute13%type,
663: Interface_line_attribute14
664: ra_customer_trx_lines.Interface_line_attribute14%type,
658: ra_customer_trx_lines.Interface_line_attribute11%type,
659: Interface_line_attribute12
660: ra_customer_trx_lines.Interface_line_attribute12%type,
661: Interface_line_attribute13
662: ra_customer_trx_lines.Interface_line_attribute13%type,
663: Interface_line_attribute14
664: ra_customer_trx_lines.Interface_line_attribute14%type,
665: Interface_line_attribute15
666: ra_customer_trx_lines.Interface_line_attribute15%type,
660: ra_customer_trx_lines.Interface_line_attribute12%type,
661: Interface_line_attribute13
662: ra_customer_trx_lines.Interface_line_attribute13%type,
663: Interface_line_attribute14
664: ra_customer_trx_lines.Interface_line_attribute14%type,
665: Interface_line_attribute15
666: ra_customer_trx_lines.Interface_line_attribute15%type,
667: Interface_line_attribute2
668: ra_customer_trx_lines.Interface_line_attribute2%type,
662: ra_customer_trx_lines.Interface_line_attribute13%type,
663: Interface_line_attribute14
664: ra_customer_trx_lines.Interface_line_attribute14%type,
665: Interface_line_attribute15
666: ra_customer_trx_lines.Interface_line_attribute15%type,
667: Interface_line_attribute2
668: ra_customer_trx_lines.Interface_line_attribute2%type,
669: Interface_line_attribute3
670: ra_customer_trx_lines.Interface_line_attribute3%type,
664: ra_customer_trx_lines.Interface_line_attribute14%type,
665: Interface_line_attribute15
666: ra_customer_trx_lines.Interface_line_attribute15%type,
667: Interface_line_attribute2
668: ra_customer_trx_lines.Interface_line_attribute2%type,
669: Interface_line_attribute3
670: ra_customer_trx_lines.Interface_line_attribute3%type,
671: Interface_line_attribute4
672: ra_customer_trx_lines.Interface_line_attribute4%type,
666: ra_customer_trx_lines.Interface_line_attribute15%type,
667: Interface_line_attribute2
668: ra_customer_trx_lines.Interface_line_attribute2%type,
669: Interface_line_attribute3
670: ra_customer_trx_lines.Interface_line_attribute3%type,
671: Interface_line_attribute4
672: ra_customer_trx_lines.Interface_line_attribute4%type,
673: Interface_line_attribute5
674: ra_customer_trx_lines.Interface_line_attribute5%type,
668: ra_customer_trx_lines.Interface_line_attribute2%type,
669: Interface_line_attribute3
670: ra_customer_trx_lines.Interface_line_attribute3%type,
671: Interface_line_attribute4
672: ra_customer_trx_lines.Interface_line_attribute4%type,
673: Interface_line_attribute5
674: ra_customer_trx_lines.Interface_line_attribute5%type,
675: Interface_line_attribute6
676: ra_customer_trx_lines.Interface_line_attribute6%type,
670: ra_customer_trx_lines.Interface_line_attribute3%type,
671: Interface_line_attribute4
672: ra_customer_trx_lines.Interface_line_attribute4%type,
673: Interface_line_attribute5
674: ra_customer_trx_lines.Interface_line_attribute5%type,
675: Interface_line_attribute6
676: ra_customer_trx_lines.Interface_line_attribute6%type,
677: Interface_line_attribute7
678: ra_customer_trx_lines.Interface_line_attribute7%type,
672: ra_customer_trx_lines.Interface_line_attribute4%type,
673: Interface_line_attribute5
674: ra_customer_trx_lines.Interface_line_attribute5%type,
675: Interface_line_attribute6
676: ra_customer_trx_lines.Interface_line_attribute6%type,
677: Interface_line_attribute7
678: ra_customer_trx_lines.Interface_line_attribute7%type,
679: Interface_line_attribute8
680: ra_customer_trx_lines.Interface_line_attribute8%type,
674: ra_customer_trx_lines.Interface_line_attribute5%type,
675: Interface_line_attribute6
676: ra_customer_trx_lines.Interface_line_attribute6%type,
677: Interface_line_attribute7
678: ra_customer_trx_lines.Interface_line_attribute7%type,
679: Interface_line_attribute8
680: ra_customer_trx_lines.Interface_line_attribute8%type,
681: Interface_line_attribute9
682: ra_customer_trx_lines.Interface_line_attribute9%type,
676: ra_customer_trx_lines.Interface_line_attribute6%type,
677: Interface_line_attribute7
678: ra_customer_trx_lines.Interface_line_attribute7%type,
679: Interface_line_attribute8
680: ra_customer_trx_lines.Interface_line_attribute8%type,
681: Interface_line_attribute9
682: ra_customer_trx_lines.Interface_line_attribute9%type,
683: Interface_line_context
684: ra_customer_trx_lines.Interface_line_context%type,
678: ra_customer_trx_lines.Interface_line_attribute7%type,
679: Interface_line_attribute8
680: ra_customer_trx_lines.Interface_line_attribute8%type,
681: Interface_line_attribute9
682: ra_customer_trx_lines.Interface_line_attribute9%type,
683: Interface_line_context
684: ra_customer_trx_lines.Interface_line_context%type,
685: Inventory_item_id
686: ra_customer_trx_lines.Inventory_item_id%type,
680: ra_customer_trx_lines.Interface_line_attribute8%type,
681: Interface_line_attribute9
682: ra_customer_trx_lines.Interface_line_attribute9%type,
683: Interface_line_context
684: ra_customer_trx_lines.Interface_line_context%type,
685: Inventory_item_id
686: ra_customer_trx_lines.Inventory_item_id%type,
687: Item_context
688: ra_customer_trx_lines.Item_context%type,
682: ra_customer_trx_lines.Interface_line_attribute9%type,
683: Interface_line_context
684: ra_customer_trx_lines.Interface_line_context%type,
685: Inventory_item_id
686: ra_customer_trx_lines.Inventory_item_id%type,
687: Item_context
688: ra_customer_trx_lines.Item_context%type,
689: Item_exception_rate_id
690: ra_customer_trx_lines.Item_exception_rate_id%type,
684: ra_customer_trx_lines.Interface_line_context%type,
685: Inventory_item_id
686: ra_customer_trx_lines.Inventory_item_id%type,
687: Item_context
688: ra_customer_trx_lines.Item_context%type,
689: Item_exception_rate_id
690: ra_customer_trx_lines.Item_exception_rate_id%type,
691: Last_period_to_credit
692: ra_customer_trx_lines.Last_period_to_credit%type,
686: ra_customer_trx_lines.Inventory_item_id%type,
687: Item_context
688: ra_customer_trx_lines.Item_context%type,
689: Item_exception_rate_id
690: ra_customer_trx_lines.Item_exception_rate_id%type,
691: Last_period_to_credit
692: ra_customer_trx_lines.Last_period_to_credit%type,
693: Last_update_date
694: ra_customer_trx_lines.Last_update_date%type,
688: ra_customer_trx_lines.Item_context%type,
689: Item_exception_rate_id
690: ra_customer_trx_lines.Item_exception_rate_id%type,
691: Last_period_to_credit
692: ra_customer_trx_lines.Last_period_to_credit%type,
693: Last_update_date
694: ra_customer_trx_lines.Last_update_date%type,
695: Last_update_login
696: ra_customer_trx_lines.Last_update_login%type,
690: ra_customer_trx_lines.Item_exception_rate_id%type,
691: Last_period_to_credit
692: ra_customer_trx_lines.Last_period_to_credit%type,
693: Last_update_date
694: ra_customer_trx_lines.Last_update_date%type,
695: Last_update_login
696: ra_customer_trx_lines.Last_update_login%type,
697: Last_updated_by
698: ra_customer_trx_lines.Last_updated_by%type,
692: ra_customer_trx_lines.Last_period_to_credit%type,
693: Last_update_date
694: ra_customer_trx_lines.Last_update_date%type,
695: Last_update_login
696: ra_customer_trx_lines.Last_update_login%type,
697: Last_updated_by
698: ra_customer_trx_lines.Last_updated_by%type,
699: Line_number
700: ra_customer_trx_lines.Line_number%type,
694: ra_customer_trx_lines.Last_update_date%type,
695: Last_update_login
696: ra_customer_trx_lines.Last_update_login%type,
697: Last_updated_by
698: ra_customer_trx_lines.Last_updated_by%type,
699: Line_number
700: ra_customer_trx_lines.Line_number%type,
701: Line_type
702: ra_customer_trx_lines.Line_type%type,
696: ra_customer_trx_lines.Last_update_login%type,
697: Last_updated_by
698: ra_customer_trx_lines.Last_updated_by%type,
699: Line_number
700: ra_customer_trx_lines.Line_number%type,
701: Line_type
702: ra_customer_trx_lines.Line_type%type,
703: Link_to_cust_trx_line_id
704: ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
698: ra_customer_trx_lines.Last_updated_by%type,
699: Line_number
700: ra_customer_trx_lines.Line_number%type,
701: Line_type
702: ra_customer_trx_lines.Line_type%type,
703: Link_to_cust_trx_line_id
704: ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
705: Location_segment_id
706: ra_customer_trx_lines.Location_segment_id%type,
700: ra_customer_trx_lines.Line_number%type,
701: Line_type
702: ra_customer_trx_lines.Line_type%type,
703: Link_to_cust_trx_line_id
704: ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
705: Location_segment_id
706: ra_customer_trx_lines.Location_segment_id%type,
707: Memo_line_id
708: ra_customer_trx_lines.Memo_line_id%type,
702: ra_customer_trx_lines.Line_type%type,
703: Link_to_cust_trx_line_id
704: ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
705: Location_segment_id
706: ra_customer_trx_lines.Location_segment_id%type,
707: Memo_line_id
708: ra_customer_trx_lines.Memo_line_id%type,
709: Memo_line_type VARCHAR2(30),
710: Movement_id
704: ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
705: Location_segment_id
706: ra_customer_trx_lines.Location_segment_id%type,
707: Memo_line_id
708: ra_customer_trx_lines.Memo_line_id%type,
709: Memo_line_type VARCHAR2(30),
710: Movement_id
711: ra_customer_trx_lines.Movement_id%type,
712: Org_id
707: Memo_line_id
708: ra_customer_trx_lines.Memo_line_id%type,
709: Memo_line_type VARCHAR2(30),
710: Movement_id
711: ra_customer_trx_lines.Movement_id%type,
712: Org_id
713: ra_customer_trx_lines.Org_id%type,
714: Previous_customer_trx_id
715: ra_customer_trx_lines.Previous_customer_trx_id%type,
709: Memo_line_type VARCHAR2(30),
710: Movement_id
711: ra_customer_trx_lines.Movement_id%type,
712: Org_id
713: ra_customer_trx_lines.Org_id%type,
714: Previous_customer_trx_id
715: ra_customer_trx_lines.Previous_customer_trx_id%type,
716: Previous_customer_trx_line_id
717: ra_customer_trx_lines.Previous_customer_trx_line_id%type,
711: ra_customer_trx_lines.Movement_id%type,
712: Org_id
713: ra_customer_trx_lines.Org_id%type,
714: Previous_customer_trx_id
715: ra_customer_trx_lines.Previous_customer_trx_id%type,
716: Previous_customer_trx_line_id
717: ra_customer_trx_lines.Previous_customer_trx_line_id%type,
718: Program_application_id
719: ra_customer_trx_lines.Program_application_id%type,
713: ra_customer_trx_lines.Org_id%type,
714: Previous_customer_trx_id
715: ra_customer_trx_lines.Previous_customer_trx_id%type,
716: Previous_customer_trx_line_id
717: ra_customer_trx_lines.Previous_customer_trx_line_id%type,
718: Program_application_id
719: ra_customer_trx_lines.Program_application_id%type,
720: Program_id
721: ra_customer_trx_lines.Program_id%type,
715: ra_customer_trx_lines.Previous_customer_trx_id%type,
716: Previous_customer_trx_line_id
717: ra_customer_trx_lines.Previous_customer_trx_line_id%type,
718: Program_application_id
719: ra_customer_trx_lines.Program_application_id%type,
720: Program_id
721: ra_customer_trx_lines.Program_id%type,
722: Program_update_date
723: ra_customer_trx_lines.Program_update_date%type,
717: ra_customer_trx_lines.Previous_customer_trx_line_id%type,
718: Program_application_id
719: ra_customer_trx_lines.Program_application_id%type,
720: Program_id
721: ra_customer_trx_lines.Program_id%type,
722: Program_update_date
723: ra_customer_trx_lines.Program_update_date%type,
724: Quantity_credited
725: ra_customer_trx_lines.Quantity_credited%type,
719: ra_customer_trx_lines.Program_application_id%type,
720: Program_id
721: ra_customer_trx_lines.Program_id%type,
722: Program_update_date
723: ra_customer_trx_lines.Program_update_date%type,
724: Quantity_credited
725: ra_customer_trx_lines.Quantity_credited%type,
726: Quantity_invoiced
727: ra_customer_trx_lines.Quantity_invoiced%type,
721: ra_customer_trx_lines.Program_id%type,
722: Program_update_date
723: ra_customer_trx_lines.Program_update_date%type,
724: Quantity_credited
725: ra_customer_trx_lines.Quantity_credited%type,
726: Quantity_invoiced
727: ra_customer_trx_lines.Quantity_invoiced%type,
728: Quantity_ordered
729: ra_customer_trx_lines.Quantity_ordered%type,
723: ra_customer_trx_lines.Program_update_date%type,
724: Quantity_credited
725: ra_customer_trx_lines.Quantity_credited%type,
726: Quantity_invoiced
727: ra_customer_trx_lines.Quantity_invoiced%type,
728: Quantity_ordered
729: ra_customer_trx_lines.Quantity_ordered%type,
730: Reason_code
731: ra_customer_trx_lines.Reason_code%type,
725: ra_customer_trx_lines.Quantity_credited%type,
726: Quantity_invoiced
727: ra_customer_trx_lines.Quantity_invoiced%type,
728: Quantity_ordered
729: ra_customer_trx_lines.Quantity_ordered%type,
730: Reason_code
731: ra_customer_trx_lines.Reason_code%type,
732: Request_id
733: ra_customer_trx_lines.Request_id%type,
727: ra_customer_trx_lines.Quantity_invoiced%type,
728: Quantity_ordered
729: ra_customer_trx_lines.Quantity_ordered%type,
730: Reason_code
731: ra_customer_trx_lines.Reason_code%type,
732: Request_id
733: ra_customer_trx_lines.Request_id%type,
734: Revenue_amount
735: ra_customer_trx_lines.Revenue_amount%type,
729: ra_customer_trx_lines.Quantity_ordered%type,
730: Reason_code
731: ra_customer_trx_lines.Reason_code%type,
732: Request_id
733: ra_customer_trx_lines.Request_id%type,
734: Revenue_amount
735: ra_customer_trx_lines.Revenue_amount%type,
736: Rule_start_date
737: ra_customer_trx_lines.Rule_start_date%type,
731: ra_customer_trx_lines.Reason_code%type,
732: Request_id
733: ra_customer_trx_lines.Request_id%type,
734: Revenue_amount
735: ra_customer_trx_lines.Revenue_amount%type,
736: Rule_start_date
737: ra_customer_trx_lines.Rule_start_date%type,
738: Sales_order
739: ra_customer_trx_lines.Sales_order%type,
733: ra_customer_trx_lines.Request_id%type,
734: Revenue_amount
735: ra_customer_trx_lines.Revenue_amount%type,
736: Rule_start_date
737: ra_customer_trx_lines.Rule_start_date%type,
738: Sales_order
739: ra_customer_trx_lines.Sales_order%type,
740: Sales_order_date
741: ra_customer_trx_lines.Sales_order_date%type,
735: ra_customer_trx_lines.Revenue_amount%type,
736: Rule_start_date
737: ra_customer_trx_lines.Rule_start_date%type,
738: Sales_order
739: ra_customer_trx_lines.Sales_order%type,
740: Sales_order_date
741: ra_customer_trx_lines.Sales_order_date%type,
742: Sales_order_line
743: ra_customer_trx_lines.Sales_order_line%type,
737: ra_customer_trx_lines.Rule_start_date%type,
738: Sales_order
739: ra_customer_trx_lines.Sales_order%type,
740: Sales_order_date
741: ra_customer_trx_lines.Sales_order_date%type,
742: Sales_order_line
743: ra_customer_trx_lines.Sales_order_line%type,
744: Sales_order_revision
745: ra_customer_trx_lines.Sales_order_revision%type,
739: ra_customer_trx_lines.Sales_order%type,
740: Sales_order_date
741: ra_customer_trx_lines.Sales_order_date%type,
742: Sales_order_line
743: ra_customer_trx_lines.Sales_order_line%type,
744: Sales_order_revision
745: ra_customer_trx_lines.Sales_order_revision%type,
746: Sales_order_source
747: ra_customer_trx_lines.Sales_order_source%type,
741: ra_customer_trx_lines.Sales_order_date%type,
742: Sales_order_line
743: ra_customer_trx_lines.Sales_order_line%type,
744: Sales_order_revision
745: ra_customer_trx_lines.Sales_order_revision%type,
746: Sales_order_source
747: ra_customer_trx_lines.Sales_order_source%type,
748: Sales_tax_id
749: ra_customer_trx_lines.Sales_tax_id%type,
743: ra_customer_trx_lines.Sales_order_line%type,
744: Sales_order_revision
745: ra_customer_trx_lines.Sales_order_revision%type,
746: Sales_order_source
747: ra_customer_trx_lines.Sales_order_source%type,
748: Sales_tax_id
749: ra_customer_trx_lines.Sales_tax_id%type,
750: Set_of_books_id
751: ra_customer_trx_lines.Set_of_books_id%type,
745: ra_customer_trx_lines.Sales_order_revision%type,
746: Sales_order_source
747: ra_customer_trx_lines.Sales_order_source%type,
748: Sales_tax_id
749: ra_customer_trx_lines.Sales_tax_id%type,
750: Set_of_books_id
751: ra_customer_trx_lines.Set_of_books_id%type,
752: Tax_exempt_flag
753: ra_customer_trx_lines.Tax_exempt_flag%type,
747: ra_customer_trx_lines.Sales_order_source%type,
748: Sales_tax_id
749: ra_customer_trx_lines.Sales_tax_id%type,
750: Set_of_books_id
751: ra_customer_trx_lines.Set_of_books_id%type,
752: Tax_exempt_flag
753: ra_customer_trx_lines.Tax_exempt_flag%type,
754: Tax_exempt_number
755: ra_customer_trx_lines.Tax_exempt_number%type,
749: ra_customer_trx_lines.Sales_tax_id%type,
750: Set_of_books_id
751: ra_customer_trx_lines.Set_of_books_id%type,
752: Tax_exempt_flag
753: ra_customer_trx_lines.Tax_exempt_flag%type,
754: Tax_exempt_number
755: ra_customer_trx_lines.Tax_exempt_number%type,
756: Tax_exempt_reason_code
757: ra_customer_trx_lines.Tax_exempt_reason_code%type,
751: ra_customer_trx_lines.Set_of_books_id%type,
752: Tax_exempt_flag
753: ra_customer_trx_lines.Tax_exempt_flag%type,
754: Tax_exempt_number
755: ra_customer_trx_lines.Tax_exempt_number%type,
756: Tax_exempt_reason_code
757: ra_customer_trx_lines.Tax_exempt_reason_code%type,
758: Tax_exemption_id
759: ra_customer_trx_lines.Tax_exemption_id%type,
753: ra_customer_trx_lines.Tax_exempt_flag%type,
754: Tax_exempt_number
755: ra_customer_trx_lines.Tax_exempt_number%type,
756: Tax_exempt_reason_code
757: ra_customer_trx_lines.Tax_exempt_reason_code%type,
758: Tax_exemption_id
759: ra_customer_trx_lines.Tax_exemption_id%type,
760: Tax_precedence
761: ra_customer_trx_lines.Tax_precedence%type,
755: ra_customer_trx_lines.Tax_exempt_number%type,
756: Tax_exempt_reason_code
757: ra_customer_trx_lines.Tax_exempt_reason_code%type,
758: Tax_exemption_id
759: ra_customer_trx_lines.Tax_exemption_id%type,
760: Tax_precedence
761: ra_customer_trx_lines.Tax_precedence%type,
762: Tax_rate
763: ra_customer_trx_lines.Tax_rate%type,
757: ra_customer_trx_lines.Tax_exempt_reason_code%type,
758: Tax_exemption_id
759: ra_customer_trx_lines.Tax_exemption_id%type,
760: Tax_precedence
761: ra_customer_trx_lines.Tax_precedence%type,
762: Tax_rate
763: ra_customer_trx_lines.Tax_rate%type,
764: Tax_vendor_return_code
765: ra_customer_trx_lines.Tax_vendor_return_code%type,
759: ra_customer_trx_lines.Tax_exemption_id%type,
760: Tax_precedence
761: ra_customer_trx_lines.Tax_precedence%type,
762: Tax_rate
763: ra_customer_trx_lines.Tax_rate%type,
764: Tax_vendor_return_code
765: ra_customer_trx_lines.Tax_vendor_return_code%type,
766: Taxable_flag
767: ra_customer_trx_lines.Taxable_flag%type,
761: ra_customer_trx_lines.Tax_precedence%type,
762: Tax_rate
763: ra_customer_trx_lines.Tax_rate%type,
764: Tax_vendor_return_code
765: ra_customer_trx_lines.Tax_vendor_return_code%type,
766: Taxable_flag
767: ra_customer_trx_lines.Taxable_flag%type,
768: Unit_selling_price
769: ra_customer_trx_lines.Unit_selling_price%type,
763: ra_customer_trx_lines.Tax_rate%type,
764: Tax_vendor_return_code
765: ra_customer_trx_lines.Tax_vendor_return_code%type,
766: Taxable_flag
767: ra_customer_trx_lines.Taxable_flag%type,
768: Unit_selling_price
769: ra_customer_trx_lines.Unit_selling_price%type,
770: Unit_standard_price
771: ra_customer_trx_lines.Unit_standard_price%type,
765: ra_customer_trx_lines.Tax_vendor_return_code%type,
766: Taxable_flag
767: ra_customer_trx_lines.Taxable_flag%type,
768: Unit_selling_price
769: ra_customer_trx_lines.Unit_selling_price%type,
770: Unit_standard_price
771: ra_customer_trx_lines.Unit_standard_price%type,
772: Uom_code
773: ra_customer_trx_lines.Uom_code%type,
767: ra_customer_trx_lines.Taxable_flag%type,
768: Unit_selling_price
769: ra_customer_trx_lines.Unit_selling_price%type,
770: Unit_standard_price
771: ra_customer_trx_lines.Unit_standard_price%type,
772: Uom_code
773: ra_customer_trx_lines.Uom_code%type,
774: Vat_tax_id
775: ra_customer_trx_lines.Vat_tax_id%type,
769: ra_customer_trx_lines.Unit_selling_price%type,
770: Unit_standard_price
771: ra_customer_trx_lines.Unit_standard_price%type,
772: Uom_code
773: ra_customer_trx_lines.Uom_code%type,
774: Vat_tax_id
775: ra_customer_trx_lines.Vat_tax_id%type,
776: Wh_update_date
777: ra_customer_trx_lines.Wh_update_date%type,
771: ra_customer_trx_lines.Unit_standard_price%type,
772: Uom_code
773: ra_customer_trx_lines.Uom_code%type,
774: Vat_tax_id
775: ra_customer_trx_lines.Vat_tax_id%type,
776: Wh_update_date
777: ra_customer_trx_lines.Wh_update_date%type,
778: Gross_unit_selling_price
779: ra_customer_trx_lines.gross_unit_selling_price%type,
773: ra_customer_trx_lines.Uom_code%type,
774: Vat_tax_id
775: ra_customer_trx_lines.Vat_tax_id%type,
776: Wh_update_date
777: ra_customer_trx_lines.Wh_update_date%type,
778: Gross_unit_selling_price
779: ra_customer_trx_lines.gross_unit_selling_price%type,
780: Gross_extended_amount
781: ra_customer_trx_lines.gross_extended_amount%type,
775: ra_customer_trx_lines.Vat_tax_id%type,
776: Wh_update_date
777: ra_customer_trx_lines.Wh_update_date%type,
778: Gross_unit_selling_price
779: ra_customer_trx_lines.gross_unit_selling_price%type,
780: Gross_extended_amount
781: ra_customer_trx_lines.gross_extended_amount%type,
782: amount_includes_tax_flag
783: ra_customer_trx_lines.amount_includes_tax_flag%type
777: ra_customer_trx_lines.Wh_update_date%type,
778: Gross_unit_selling_price
779: ra_customer_trx_lines.gross_unit_selling_price%type,
780: Gross_extended_amount
781: ra_customer_trx_lines.gross_extended_amount%type,
782: amount_includes_tax_flag
783: ra_customer_trx_lines.amount_includes_tax_flag%type
784: );
785:
779: ra_customer_trx_lines.gross_unit_selling_price%type,
780: Gross_extended_amount
781: ra_customer_trx_lines.gross_extended_amount%type,
782: amount_includes_tax_flag
783: ra_customer_trx_lines.amount_includes_tax_flag%type
784: );
785:
786: TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
787: INDEX BY BINARY_INTEGER;
798: p_api_version IN number,
799: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
800: p_commit IN varchar2 := FND_API.G_FALSE,
801: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
802: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
803: p_return_status OUT NOCOPY varchar2,
804: p_msg_count IN OUT NOCOPY NUMBER,
805: p_msg_data IN OUT NOCOPY varchar2,
806: p_errors IN OUT NOCOPY arp_trx_validate.Message_Tbl_Type);
811: -- Bug12668756
812: PROCEDURE GET_TRXN_LINE_BALANCE(
813: p_api_version IN NUMBER,
814: p_customer_trx_id IN NUMBER,
815: p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,
816: x_amount_due_remaining OUT NOCOPY NUMBER,
817: x_acctd_amount_due_remaining OUT NOCOPY NUMBER,
818: x_return_status OUT NOCOPY VARCHAR2,
819: x_msg_count OUT NOCOPY NUMBER,