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)
1 Responses to “API to check the AP Invoice Accounting Status AP_INVOICES_PKG.GET_POSTING_STATUS”
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