APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_LINE_LOCATIONS

Line 180: from po_line_locations

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

Line 187: from po_line_locations

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

Line 194: l_new_shipment_price PO_LINE_LOCATIONS.price_override%TYPE;

190: and shipment_num = p_SHIPMENT_NUMBER;
191:
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;

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

Line 448: p_table_name => 'PO_LINE_LOCATIONS',

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

Line 467: p_table_name => 'PO_LINE_LOCATIONS',

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

Line 491: FROM po_line_locations

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

Line 502: p_table_name => 'PO_LINE_LOCATIONS',

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