• Oracle EBS AR 事务处理到期余额总计API


    declare 
      -- Local variables here
      i integer;
      x_line_original NUMBER;
      x_line_remaining NUMBER;
      x_tax_original NUMBER;
      x_tax_remaining NUMBER;
      x_freight_orginal NUMBER;
      x_freight_remaining NUMBER;
      x_charges_original NUMBER;
      x_charges_remaining NUMBER;
      x_total_original NUMBER;
      x_total_remaining NUMBER;
    begin
      -- Test statements here
      mo_global.init('AR');
      mo_global.set_policy_context('S',104);
      ARP_BAL_UTIL.get_summary_trx_balances(p_customer_trx_id => 10002
                                           ,p_open_receivables_flag =>ra_cust_trx_types_all.accounting_affect_flag --未结应收款
                                           ,p_line_original => x_line_original
                                           ,p_line_remaining => x_line_remaining
                                           ,p_tax_original => x_tax_original
                                           ,p_freight_original => x_freight_orginal
                                           ,p_freight_remaining => x_freight_remaining
                                           ,p_tax_remaining => x_tax_remaining
                                           ,p_charges_original => x_charges_original
                                           ,p_charges_remaining => x_charges_remaining
                                           ,p_total_original => x_total_original
                                           ,p_total_remaining => x_total_remaining);
                                           
     dbms_output.put_line('x_line_original:'||x_line_original);    
     dbms_output.put_line('x_line_remaining:'||x_line_remaining); 
     dbms_output.put_line('x_tax_original:'||x_tax_original); 
     dbms_output.put_line('x_tax_remaining:'||x_tax_remaining); 
     dbms_output.put_line('x_freight_orginal:'||x_freight_orginal); 
     dbms_output.put_line('x_freight_remaining:'||x_freight_remaining); 
     dbms_output.put_line('x_charges_original:'||x_charges_original); 
     dbms_output.put_line('x_charges_remaining:'||x_charges_remaining); 
     dbms_output.put_line('x_total_original:'||x_total_original); 
     dbms_output.put_line('x_total_remaining:'||x_total_remaining);                                   
    end;
    土豆君
  • 相关阅读:
    mysql5.7安装
    win10 安装docker
    快速去水印(win10换图3D工具)
    爬虫---国家食品药品监督管理总局
    食品伙伴网爬虫
    驴妈妈旅游爬虫
    天气预测(CNN)
    ConcurrentDictionary线程不安全么,你难道没疑惑,你难道弄懂了么?
    C#线程篇---线程池如何管理线程(6完结篇)
    C#线程篇---Task(任务)和线程池不得不说的秘密(5)
  • 原文地址:https://www.cnblogs.com/jenrry/p/10007115.html
Copyright © 2020-2023  润新知