Loading

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; 
 

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

oracle apps training said...
February 6, 2015 at 12:08 AM

Oracle Applications eBusiness SuiteEmpowering today's businesses Watch our Free Tutorials80+ hours of High Quality videos
Project oriented video bas best ed tutorials &hellip.

Thanks for sharing.
With best regards
https://erpwebtutor.com/


Praveen Kumar 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.


oracle fusion hcm online Training said...
March 14, 2017 at 11:33 PM

Oracle fusion procurement education empowering present day organizations watch our loose tutorials80+ hours of wonderful motion pictures
The mission-oriented video becomes bested tutorials &help.

Thank you for sharing.
With first-rate regards
oracle fusion procurement online training
oracle fusion procurement training


ORACLE FUSION PROCUREMENT said...
March 15, 2017 at 9:19 PM

Hi,
This is valuable and interesting article.
Thanks for sharing such a wonderful article.
oracle fusion SCM on line training


oraclehcm said...
March 18, 2017 at 3:28 AM

I just read your comment such a very nice. Thank you for posting this blog, If you are looking for best Oracle fusion financials low price of fee for on-line coaching.
Oracle fusion financials training


ORACLE FUSION PROCUREMENT said...
April 9, 2017 at 10:29 PM

Hi,
this is a nice post.Thanks for sharing such a wonderful post.
oracle fusion SCM online training


Calfre India said...
April 21, 2017 at 5:24 AM

This article creates a new hope and inspiration with in me. Thanks for sharing article like this.The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.

Oracle fusion Financials Online Training in Ameerpet

Oracle Fusion Financials Training in Ameerpet


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.