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 276: SELECT po_line_locations_s.nextval

272: end if;
273:
274: X_Progress := '020';
275:
276: SELECT po_line_locations_s.nextval
277: INTO X_line_location_id
278: FROM sys.dual;
279: -- Added for bug 2350043 by jbalakri
280: X_Progress:= '025';

Line 325: INSERT into po_line_locations

321: l_from_header_id := null;
322: end;
323: /* GA FPI end */
324:
325: INSERT into po_line_locations
326: (line_location_id ,
327: last_update_date ,
328: last_updated_by ,
329: creation_date ,