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;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
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.
15 Responses to “API to check the AP Invoice Accounting Status AP_INVOICES_PKG.GET_POSTING_STATUS”
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/
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.
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
Hi,
This is valuable and interesting article.
Thanks for sharing such a wonderful article.
oracle fusion SCM on line training
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
Hi,
this is a nice post.Thanks for sharing such a wonderful post.
oracle fusion SCM online training
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
June 16, 2017 at 4:05 AM
Hi,
this is very informative post.Thanks for sharing such a nice post.
oracle fusion HCM training.
August 4, 2017 at 3:24 AM
thanks for sharing such nice post
RPA online training
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
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
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.
January 7, 2022 at 9:45 AM
requirement to display Buy Custom Essays the invoice Accounted status in a custom form.
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/
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