DBA Data[Home] [Help]

APPS.PO_CHANGE_RESPONSE_PVT dependencies on PO_RELEASES_ALL

Line 160: from po_releases_all

156: into l_acceptance_required,
157: l_authorization_status,
158: l_change_requested_by,
159: l_revision_num
160: from po_releases_all
161: where po_release_id = p_po_release_id;
162:
163: end if;
164:

Line 490: from po_releases_all

486: if (p_po_release_id is not null) then
487:
488: select org_id, release_type
489: into l_s_org_id, l_document_subtype
490: from po_releases_all
491: where po_release_id = p_po_release_id;
492:
493: l_document_type := 'RELEASE';
494:

Line 625: UPDATE po_releases_all

621: UPDATE po_headers_all
622: SET authorization_status = 'APPROVED'
623: WHERE po_header_id = p_po_header_id;
624: ELSE -- Release
625: UPDATE po_releases_all
626: SET authorization_status = 'APPROVED'
627: WHERE po_release_id = p_po_release_id;
628: END IF;
629: