Sunday, August 17, 2014

API to check the AP Invoice Accounting Status AP_INVOICES_PKG.GET_POSTING_STATUS















In my recent project, we have a requirement to display the invoice Accounted status in a custom form. We have used the API AP_INVOICES_PKG.GET_POSTING_STATUS 

Script:

  -------------------------------------------------------------------------
  -- Function get_inv_accounted_status
  -- This function returns the accounting status of the given ap invoice id  
  -------------------------------------------------------------------------   
  FUNCTION get_inv_accounted_status (pin_invoice_id IN NUMBER)
  RETURN VARCHAR2
  IS
  lv_return_status  VARCHAR2(2) DEFAULT NULL;
  BEGIN  
    RETURN (ap_invoices_pkg.get_posting_status(pin_invoice_id));  
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
   RETURN 'N';
 WHEN OTHERS THEN
   RETURN 'N';
  END get_inv_accounted_status; 
 

1 Responses to “API to check the AP Invoice Accounting Status AP_INVOICES_PKG.GET_POSTING_STATUS”

Praveen said...
June 22, 2016 at 12:22 AM

When I tried to find the AP invoice status from backend, I found the column name APPROVAL_STATUS_LOOKUP_CODE under the view name AP_INVOICE_V. Since it is org based view, setting the context is mandatory.If anyone interested to take Oracle Apps Functional Training in Bangalore, please reach us KBS Training located at Bangalore. Rated as best training institute in Bangalore.


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.