APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_RELEASES

Line 170: from po_releases

166:
167: CURSOR l_po_release_csr (p_po_header_id NUMBER, p_release_number NUMBER) IS
168: select po_release_id, revision_num,
169: NVL(authorization_status, 'INCOMPLETE'), release_type
170: from po_releases
171: where po_header_id = p_po_header_id
172: and release_num = p_RELEASE_NUMBER;
173:
174: CURSOR l_po_line_csr (p_po_header_id NUMBER, p_line_number NUMBER) IS

Line 198: l_po_release_id PO_RELEASES.po_release_id%TYPE;

194: l_header_table_name VARCHAR2(30);
195: l_changes PO_CHANGES_REC_TYPE;
196: l_new_shipment_price PO_LINE_LOCATIONS.price_override%TYPE;
197: l_po_header_id PO_HEADERS.po_header_id%TYPE;
198: l_po_release_id PO_RELEASES.po_release_id%TYPE;
199: l_po_line_id PO_LINES.po_line_id%TYPE;
200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
201: l_revision_num PO_HEADERS.revision_num%TYPE;
202: l_authorization_status PO_HEADERS.authorization_status%TYPE;

Line 288: p_table_name => 'PO_RELEASES',

284: PO_DOCUMENT_UPDATE_PVT.add_error (
285: p_api_errors => x_api_errors,
286: x_return_status => l_return_status,
287: p_message_name => 'PO_CHNG_INVALID_RELEASE_NUM',
288: p_table_name => 'PO_RELEASES',
289: p_column_name => 'PO_RELEASE_ID'
290: );
291: x_result := 0;
292: CLOSE l_po_release_csr;

Line 324: l_header_table_name := 'PO_RELEASES';

320: x_result := 0;
321: RETURN;
322: END IF; -- l_document_subtype
323: ELSE -- Release
324: l_header_table_name := 'PO_RELEASES';
325: IF l_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
326: PO_DOCUMENT_UPDATE_PVT.add_error (
327: p_api_errors => x_api_errors,
328: x_return_status => l_return_status,