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 491: from po_releases_all

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

Line 626: UPDATE po_releases_all

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
627: SET authorization_status = 'APPROVED'
628: WHERE po_release_id = p_po_release_id;
629: END IF;
630: