730:
731: l_party_id NUMBER;
732: l_bucket_name AR_AGING_BUCKETS.BUCKET_NAME%TYPE;
733: l_outstanding_balance NUMBER;
734: l_bucket_titletop_0 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
735: l_bucket_titlebottom_0 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
736: l_bucket_amount_0 NUMBER;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
731: l_party_id NUMBER;
732: l_bucket_name AR_AGING_BUCKETS.BUCKET_NAME%TYPE;
733: l_outstanding_balance NUMBER;
734: l_bucket_titletop_0 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
735: l_bucket_titlebottom_0 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
736: l_bucket_amount_0 NUMBER;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
739: l_bucket_amount_1 NUMBER;
733: l_outstanding_balance NUMBER;
734: l_bucket_titletop_0 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
735: l_bucket_titlebottom_0 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
736: l_bucket_amount_0 NUMBER;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
739: l_bucket_amount_1 NUMBER;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
734: l_bucket_titletop_0 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
735: l_bucket_titlebottom_0 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
736: l_bucket_amount_0 NUMBER;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
739: l_bucket_amount_1 NUMBER;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
742: l_bucket_amount_2 NUMBER;
736: l_bucket_amount_0 NUMBER;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
739: l_bucket_amount_1 NUMBER;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
742: l_bucket_amount_2 NUMBER;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
737: l_bucket_titletop_1 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
738: l_bucket_titlebottom_1 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
739: l_bucket_amount_1 NUMBER;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
742: l_bucket_amount_2 NUMBER;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
745: l_bucket_amount_3 NUMBER;
739: l_bucket_amount_1 NUMBER;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
742: l_bucket_amount_2 NUMBER;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
745: l_bucket_amount_3 NUMBER;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
740: l_bucket_titletop_2 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
741: l_bucket_titlebottom_2 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
742: l_bucket_amount_2 NUMBER;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
745: l_bucket_amount_3 NUMBER;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
748: l_bucket_amount_4 NUMBER;
742: l_bucket_amount_2 NUMBER;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
745: l_bucket_amount_3 NUMBER;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
748: l_bucket_amount_4 NUMBER;
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
743: l_bucket_titletop_3 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
744: l_bucket_titlebottom_3 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
745: l_bucket_amount_3 NUMBER;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
748: l_bucket_amount_4 NUMBER;
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
751: l_bucket_amount_5 NUMBER;
745: l_bucket_amount_3 NUMBER;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
748: l_bucket_amount_4 NUMBER;
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
751: l_bucket_amount_5 NUMBER;
752: l_bucket_titletop_6 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
753: l_bucket_titlebottom_6 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
746: l_bucket_titletop_4 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
747: l_bucket_titlebottom_4 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
748: l_bucket_amount_4 NUMBER;
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
751: l_bucket_amount_5 NUMBER;
752: l_bucket_titletop_6 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
753: l_bucket_titlebottom_6 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
754: l_bucket_amount_6 NUMBER;
748: l_bucket_amount_4 NUMBER;
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
751: l_bucket_amount_5 NUMBER;
752: l_bucket_titletop_6 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
753: l_bucket_titlebottom_6 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
754: l_bucket_amount_6 NUMBER;
755:
756: l_error_message VARCHAR2(2000);
749: l_bucket_titletop_5 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
750: l_bucket_titlebottom_5 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
751: l_bucket_amount_5 NUMBER;
752: l_bucket_titletop_6 AR_AGING_BUCKET_LINES.REPORT_HEADING1%TYPE;
753: l_bucket_titlebottom_6 AR_AGING_BUCKET_LINES.REPORT_HEADING2%TYPE;
754: l_bucket_amount_6 NUMBER;
755:
756: l_error_message VARCHAR2(2000);
757: l_cycle_start_date DATE;