APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_RELEASES

Line 168: from po_releases

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

Line 196: l_po_release_id PO_RELEASES.po_release_id%TYPE;

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

Line 286: p_table_name => 'PO_RELEASES',

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

Line 322: l_header_table_name := 'PO_RELEASES';

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