APPS.PO_CHANGE_RESPONSE_PVT dependencies on PO_HEADERS_ALL

Line 147: from po_headers_all

143: into l_acceptance_required,
144: l_authorization_status,
145: l_change_requested_by,
146: l_revision_num
147: from po_headers_all
148: where po_header_id = p_po_header_id;
149:
150: else
151:

Line 305: from po_headers_all

301: BEGIN
302:
303: select revision_num
304: into l_revision_num
305: from po_headers_all
306: where po_header_id = p_po_header_id;
307:
308: select count(*) into l_pending_count
309: from po_change_requests

Line 500: from po_headers_all

496: else
497:
498: select org_id, type_lookup_code
499: into l_s_org_id, l_document_subtype
500: from po_headers_all
501: where po_header_id = p_po_header_id;
502:
503: IF (l_document_subtype IN ('BLANKET','CONTRACT')) THEN
504: l_document_type := 'PA';

Line 622: UPDATE po_headers_all

618: -- The document is currently in 'IN PROCESS' status. Set it to 'APPROVED'
619: -- status to allow the PO Change API to process it
620:
621: IF (p_po_release_id IS NULL) THEN -- PO, PA
622: UPDATE po_headers_all
623: SET authorization_status = 'APPROVED'
624: WHERE po_header_id = p_po_header_id;
625: ELSE -- Release
626: UPDATE po_releases_all