APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_LINE_LOCATIONS

Line 182: from po_line_locations

178: and line_num = p_LINE_NUMBER;
179:
180: CURSOR l_po_shipment_csr (p_po_line_id NUMBER, p_shipment_number NUMBER) IS
181: select line_location_id
182: from po_line_locations
183: where po_line_id = p_po_line_id
184: and shipment_num = p_SHIPMENT_NUMBER;
185:
186: CURSOR l_release_shipment_csr (p_po_release_id NUMBER, p_po_line_id NUMBER,

Line 189: from po_line_locations

185:
186: CURSOR l_release_shipment_csr (p_po_release_id NUMBER, p_po_line_id NUMBER,
187: p_shipment_number NUMBER) IS
188: select line_location_id
189: from po_line_locations
190: where po_line_id = p_po_line_id
191: and po_release_id = p_po_release_id
192: and shipment_num = p_SHIPMENT_NUMBER;
193:

Line 196: l_new_shipment_price PO_LINE_LOCATIONS.price_override%TYPE;

192: and shipment_num = p_SHIPMENT_NUMBER;
193:
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;

Line 200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%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;
204: l_launch_approvals_flag VARCHAR2(1);

Line 450: p_table_name => 'PO_LINE_LOCATIONS',

446: PO_DOCUMENT_UPDATE_PVT.add_error (
447: p_api_errors => x_api_errors,
448: x_return_status => l_return_status,
449: p_message_name => 'PO_CHNG_INVALID_SHIPMENT_NUM',
450: p_table_name => 'PO_LINE_LOCATIONS',
451: p_column_name => 'LINE_LOCATION_ID'
452: );
453: x_result := 0;
454: CLOSE l_po_shipment_csr;

Line 469: p_table_name => 'PO_LINE_LOCATIONS',

465: PO_DOCUMENT_UPDATE_PVT.add_error (
466: p_api_errors => x_api_errors,
467: x_return_status => l_return_status,
468: p_message_name => 'PO_CHNG_INVALID_SHIPMENT_NUM',
469: p_table_name => 'PO_LINE_LOCATIONS',
470: p_column_name => 'LINE_LOCATION_ID'
471: );
472: x_result := 0;
473: CLOSE l_release_shipment_csr;

Line 493: FROM po_line_locations

489:
490: -- SQL What: Returns the number of shipments on this line.
491: SELECT count(*)
492: INTO l_shipment_count
493: FROM po_line_locations
494: WHERE po_line_id = l_po_line_id
495: AND shipment_type = l_document_subtype;
496:
497: IF (l_shipment_count > 1) THEN

Line 504: p_table_name => 'PO_LINE_LOCATIONS',

500: PO_DOCUMENT_UPDATE_PVT.add_error (
501: p_api_errors => x_api_errors,
502: x_return_status => l_return_status,
503: p_message_name => 'PO_CHNG_PO_NO_SHIP_PRICE',
504: p_table_name => 'PO_LINE_LOCATIONS',
505: p_column_name => 'PRICE_OVERRIDE'
506: );
507: x_result := 0;
508: RETURN;