APPS.PO_SHIPMENTS_SV3 dependencies on PO_RELEASES

Line 446: UPDATE po_releases

442:
443: /*
444: ** Call the routine to update release header approval status
445: */
446: UPDATE po_releases
447: SET approved_flag = 'R',
448: authorization_status = 'REQUIRES REAPPROVAL'
449: WHERE po_release_id = X_po_release_id
450: AND nvl(approved_flag,'N') not in ('N', 'R');