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 


  -- 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)
  lv_return_status  VARCHAR2(2) DEFAULT NULL;
    RETURN (ap_invoices_pkg.get_posting_status(pin_invoice_id));  
   RETURN 'N';
   RETURN 'N';
  END get_inv_accounted_status; 

11 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

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.

oracle procurement 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

March 15, 2017 at 9:19 PM

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

April 9, 2017 at 10:29 PM

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

Unknown 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

oracle hcm online said...
June 16, 2017 at 4:05 AM

this is very informative post.Thanks for sharing such a nice post.
oracle fusion HCM training.

itorigins said...
August 4, 2017 at 3:24 AM

thanks for sharing such nice post
RPA online training

Oracle Fusion Human capital Management Training said...
September 17, 2017 at 11:35 PM

thanks for sharing such a post this sharing article like this.The way Keep blogging like this Thanks. Oracle Fusion HCM Training

Unknown said...
December 21, 2017 at 9:59 PM

Nice blog,good information about oracle fusion modules.Fore more details to check our website.

Fusion Cloud Financials Training Centre in Ameerpet Hyderabad

Post a Comment


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.