Search from 700 + Posts

Apr 6, 2011

API to Check Status of Purchase Order in Oracle Applications.

Below is API that return you the status of Purchase Order -


DECLARE
l_po_header_id          NUMBER;
l_po_status_rec         PO_STATUS_REC_TYPE;
l_return_status         VARCHAR2(1);
l_autorization_status   VARCHAR2(30);
l_po_release_id         NUMBER;
BEGIN
 PO_DOCUMENT_CHECKS_GRP.po_status_check
                                (p_api_version => 1.0
                                , p_header_id => l_po_header_id
                                , p_release_id => l_po_release_id
                                , p_mode => 'GET_STATUS'
                                , x_po_status_rec => l_po_status_rec
                                , x_return_status => l_return_status);
                               
l_autorization_status := l_po_status_rec.authorization_status(1);
dbms_output.put_line('Status = '||l_autorization_status);
END;

No comments:

Post a Comment