Chuck Oracle Engineer

Oracel EBS 在AR模組中有一個Aging取個期間逾期總金額，這段程式跑蠻快的拿來套用一下

DECLARE
   p_outstanding_balance NUMBER;
   p_bucket_titletop_0 VARCHAR2(200);
   p_bucket_titlebottom_0 VARCHAR2(200);
   p_bucket_amount_0 NUMBER;
   p_bucket_titletop_1 VARCHAR2(200);
   p_bucket_titlebottom_1 VARCHAR2(200);
   p_bucket_amount_1 NUMBER;
   p_bucket_titletop_2 VARCHAR2(200);
   p_bucket_titlebottom_2 VARCHAR2(200);
   p_bucket_amount_2 NUMBER;
   p_bucket_titletop_3 VARCHAR2(200);
   p_bucket_titlebottom_3 VARCHAR2(200);
   p_bucket_amount_3 NUMBER;
   p_bucket_titletop_4 VARCHAR2(200);
   p_bucket_titlebottom_4 VARCHAR2(200);
   p_bucket_amount_4 NUMBER;
   p_bucket_titletop_5 VARCHAR2(200);
   p_bucket_titlebottom_5 VARCHAR2(200);
   p_bucket_amount_5 NUMBER;
   p_bucket_titletop_6 VARCHAR2(200);
   p_bucket_titlebottom_6 VARCHAR2(200);
   p_bucket_amount_6 NUMBER;
   
BEGIN

   dbms_application_info.set_client_infO(136);

   arp_customer_aging.calc_aging_buckets(
                                         7717962, --p_customer_id
                                         NULL, --p_customer_site_use_id
                                         to_date('2020/07/08', 'yyyy/mm/dd'), --p_as_of_date,
                                         NULL, --p_currency_code,
                                         'AGE', --p_credit_option,
                                         NULL, --p_invoice_type_low,
                                         NULL, --p_invoice_type_high2,
                                         0, --p_ps_max_id,
                                         0, --p_app_max_id,
                                         'Collections', --p_bucket_name,
                                         p_outstanding_balance,
                                         p_bucket_titletop_0,
                                         p_bucket_titlebottom_0,
                                         p_bucket_amount_0    ,
                                         p_bucket_titletop_1,
                                         p_bucket_titlebottom_1,
                                         p_bucket_amount_1    ,
                                         p_bucket_titletop_2,
                                         p_bucket_titlebottom_2,
                                         p_bucket_amount_2    ,
                                         p_bucket_titletop_3,
                                         p_bucket_titlebottom_3,
                                         p_bucket_amount_3    ,
                                         p_bucket_titletop_4,
                                         p_bucket_titlebottom_4,
                                         p_bucket_amount_4    ,
                                         p_bucket_titletop_5,
                                         p_bucket_titlebottom_5,
                                         p_bucket_amount_5    ,
                                         p_bucket_titletop_6,
                                         p_bucket_titlebottom_6,
                                         p_bucket_amount_6    
                                        );
                                        
   dbms_output.put_line(p_bucket_amount_0);
   dbms_output.put_line(p_bucket_amount_1);
   dbms_output.put_line(p_bucket_amount_2);
   dbms_output.put_line(p_bucket_amount_3);
   dbms_output.put_line(p_bucket_amount_4);
   dbms_output.put_line(p_bucket_amount_5);
   dbms_output.put_line(p_bucket_amount_6);
END;