APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_LINES

Line 174: from po_lines

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

Line 197: l_po_line_id PO_LINES.po_line_id%TYPE;

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

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

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

Line 384: p_table_name => 'PO_LINES',

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

Line 404: p_table_name => 'PO_LINES',

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

Line 417: p_table_name => 'PO_LINES',

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