PO_REQUISITION_UPDATE_PUB to update requisition status to APPROVED
EBS 12.2.10
Database 19c (19.18.0.0.0)
I want to update requisition status from INCOMPLETE to APPROVED I am using below script. but it is not working although there is no error message and api returned S status.
DECLARE
l_req_hdr PO_REQUISITION_UPDATE_PUB.req_hdr;
l_req_line_tbl PO_REQUISITION_UPDATE_PUB.req_line_tbl;
l_req_dist_dtl PO_REQUISITION_UPDATE_PUB.req_dist_tbl;
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
BEGIN
fnd_global.APPS_INITIALIZE(0, 21248, 178);
l_req_hdr.requisition_header_id := 2105033;
l_req_hdr.org_id := 103;
l_req_hdr.authorization_status := 'APPROVED';