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; 
 

15 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 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


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


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


Hi,
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


Jone Martin said...
November 22, 2021 at 10:55 AM

Wow, you make easy for developers. They can put your code in own code and get invoice. Likewise, you can solve your rots from Dry Rots Repair Services in Sacramento CA and make your life calm.


Frank said...
January 7, 2022 at 9:45 AM

requirement to display Buy Custom Essays the invoice Accounted status in a custom form.


Anonymous said...
April 27, 2022 at 3:37 AM

CloudShine offers Oracle Fushion Cloud training courses online at affordable prices. Log on to the site to learn more about the oracle fusion training program with 10% offer.
https://cloudshinepro.com/


cloudshinepro said...
April 27, 2022 at 3:48 AM

Oracle Fusion Training | Oracle Fusion Applications Training | Oracle Cloud Consultants | CloudShine

CloudShine offers Oracle Fushion Cloud training courses online at affordable prices. Log on to the site to learn more about the oracle fusion training program with 10% offer.


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.