APPS.PO_SHIPMENTS_SV8 dependencies on PO_LINE_LOCATIONS

Line 30: FROM po_line_locations

26: */
27:
28: SELECT count(*)
29: INTO x_start_date_count
30: FROM po_line_locations
31: WHERE start_date < X_start_date
32: AND po_header_id = X_po_header_id;
33:
34: x_progress := '020';

Line 78: FROM po_line_locations

74:
75:
76: SELECT count(*)
77: INTO x_end_date_count
78: FROM po_line_locations
79: WHERE end_date > X_end_date
80: AND po_header_id = X_po_header_id;
81:
82: x_progress := '020';

Line 170: po_line_locations.consigned_flag%TYPE := NULL;

166:
167: /* CONSIGNED FPI START */
168:
169: x_consigned_flag
170: po_line_locations.consigned_flag%TYPE := NULL;
171:
172: -- OPEN is the default if the shipment line is not consigned
173: x_closed_code
174: po_line_locations.closed_code%TYPE := 'OPEN';

Line 174: po_line_locations.closed_code%TYPE := 'OPEN';

170: po_line_locations.consigned_flag%TYPE := NULL;
171:
172: -- OPEN is the default if the shipment line is not consigned
173: x_closed_code
174: po_line_locations.closed_code%TYPE := 'OPEN';
175:
176: x_closed_reason
177: po_line_locations.closed_reason%TYPE := NULL;
178:

Line 177: po_line_locations.closed_reason%TYPE := NULL;

173: x_closed_code
174: po_line_locations.closed_code%TYPE := 'OPEN';
175:
176: x_closed_reason
177: po_line_locations.closed_reason%TYPE := NULL;
178:
179: l_invoice_close_tolerance number := X_invoice_close_tolerance;
180:
181: l_inspection_required_flag

Line 182: po_line_locations.inspection_required_flag%TYPE := X_inspection_required_flag;

178:
179: l_invoice_close_tolerance number := X_invoice_close_tolerance;
180:
181: l_inspection_required_flag
182: po_line_locations.inspection_required_flag%TYPE := X_inspection_required_flag;
183:
184: l_receipt_required_flag
185: po_line_locations.receipt_required_flag%TYPE := X_receipt_required_flag;
186:

Line 185: po_line_locations.receipt_required_flag%TYPE := X_receipt_required_flag;

181: l_inspection_required_flag
182: po_line_locations.inspection_required_flag%TYPE := X_inspection_required_flag;
183:
184: l_receipt_required_flag
185: po_line_locations.receipt_required_flag%TYPE := X_receipt_required_flag;
186:
187: /* CONSIGNED FPI END */
188:
189: l_from_line_id number; -- GA FPI

Line 194: l_transaction_flow_header_id PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

190: l_from_header_id number; -- GA FPI
191: l_amount number;
192:
193: /*Bug 8559443 - Variable initialization start*/
194: l_transaction_flow_header_id PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
195: l_is_valid BOOLEAN;
196: l_in_current_sob BOOLEAN;
197: l_check_txn_flow BOOLEAN;
198: l_return_status VARCHAR2(1);

Line 299: SELECT po_line_locations_s.nextval

295:
296:
297: X_Progress := '020';
298:
299: SELECT po_line_locations_s.nextval
300: INTO X_line_location_id
301: FROM sys.dual;
302: -- Added for bug 2350043 by jbalakri
303: X_Progress:= '025';

Line 384: INSERT into po_line_locations

380: l_from_header_id := null;
381: end;
382: /* GA FPI end */
383:
384: INSERT into po_line_locations
385: (line_location_id ,
386: last_update_date ,
387: last_updated_by ,
388: creation_date ,