APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_LINES

Line 176: from po_lines

172: and release_num = p_RELEASE_NUMBER;
173:
174: CURSOR l_po_line_csr (p_po_header_id NUMBER, p_line_number NUMBER) IS
175: select po_line_id
176: from po_lines
177: where po_header_id = p_po_header_id
178: and line_num = p_LINE_NUMBER;
179:
180: CURSOR l_po_shipment_csr (p_po_line_id NUMBER, p_shipment_number NUMBER) IS

Line 199: l_po_line_id PO_LINES.po_line_id%TYPE;

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;
203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;

Line 209: l_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE := p_secondary_qty; --

205: l_shipment_count NUMBER;
206: l_buyer_id PO_HEADERS.agent_id%TYPE;
207:
208: l_return_status VARCHAR2(1);
209: l_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE := p_secondary_qty; --
210: l_preferred_grade MTL_GRADES.grade_Code%TYPE := p_preferred_grade; --
211:
212: l_progress VARCHAR2(3) := '000';
213: --

Line 386: p_table_name => 'PO_LINES',

382: PO_DOCUMENT_UPDATE_PVT.add_error (
383: p_api_errors => x_api_errors,
384: x_return_status => l_return_status,
385: p_message_name => 'PO_CHNG_INVALID_LINE_NUM',
386: p_table_name => 'PO_LINES',
387: p_column_name => 'PO_LINE_ID'
388: );
389: x_result := 0;
390: CLOSE l_po_line_csr;

Line 406: p_table_name => 'PO_LINES',

402: PO_DOCUMENT_UPDATE_PVT.add_error (
403: p_api_errors => x_api_errors,
404: x_return_status => l_return_status,
405: p_message_name => 'PO_CHNG_NO_DATE_CHANGE_LINE',
406: p_table_name => 'PO_LINES',
407: p_column_name => 'PROMISED_DATE'
408: );
409: x_result := 0;
410: RETURN;

Line 419: p_table_name => 'PO_LINES',

415: PO_DOCUMENT_UPDATE_PVT.add_error (
416: p_api_errors => x_api_errors,
417: x_return_status => l_return_status,
418: p_message_name => 'PO_CHNG_NO_NEED_DATE_ON_LINE',
419: p_table_name => 'PO_LINES',
420: p_column_name => 'NEED_BY_DATE'
421: );
422: x_result := 0;
423: RETURN;