api to update ar invoice

api to update ar invoice

In this post, I will share the API to update Oracle Receivables Invoices in Oracle apps. When you Transaction/Invoice has been created and now you want to make some changes in the Invoice or update some thing then you can use this below API to update. You need to pass the Customer Trx id of the Invoice in this API. We are using the Standard API ' AR_INVOICE_SQL_FUNC_PUB' to update the Customer Transactions in Oracle receivables. Here below is the sample code of api to update ar invoice

 

Sample Script of api to update ar invoice

DECLARE

   p_choice                   VARCHAR2 (200);

   p_customer_trx_id          NUMBER;

   p_trx_type                 VARCHAR2 (200);

   p_term_count               NUMBER;

   p_term_sequence_number     NUMBER;

   p_printing_count           NUMBER;

   p_printing_original_date   DATE;

   l_print_pend               CHAR (1);

   l_print_last_printed       DATE;

BEGIN

 


  AR_INVOICE_SQL_FUNC_PUB.UPDATE_CUSTOMER_TRX

          (p_choice                      => p_choice,

           p_customer_trx_id             => p_customer_trx_id,

           p_trx_type                    => p_trx_type,

           p_term_count                  => p_term_count,

           p_term_sequence_number        => p_term_sequence_number,

           p_printing_count              => p_printing_count,

           p_printing_original_date      => p_printing_original_date

          );

 
end;