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 499: from po_headers_all

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

Line 621: UPDATE po_headers_all

617: -- The document is currently in 'IN PROCESS' status. Set it to 'APPROVED'
618: -- status to allow the PO Change API to process it
619:
620: IF (p_po_release_id IS NULL) THEN -- PO, PA
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