96: BEGIN
97:
98: SELECT count('Price Breaks with Effectivity Dates')
99: INTO l_count
100: FROM po_line_locations_all
101: WHERE po_line_id = p_po_line_id
102: AND ( ( start_date IS NOT NULL )
103: OR ( end_date IS NOT NULL ) );
104:
195: --< NBD TZ/Timestamp FPJ End >
196: into X_line_location_id,
197: X_promised_date,
198: X_need_by
199: from po_line_locations
200: where po_line_id = X_po_line_id;
201:
202:
203: exception
407: INTO X_quantity_received,
408: X_quantity_billed,
409: X_amount_received,
410: X_amount_billed
411: FROM po_line_locations
412: WHERE po_line_id = X_po_line_id
413: AND shipment_type in ('STANDARD', 'PLANNED');
414:
415: X_Progress := '030';
441: )
442: )
443: INTO X_quantity_released,
444: X_amount_released
445: FROM po_line_locations
446: WHERE po_header_id = X_po_header_id and
447: shipment_type = 'BLANKET'and
448: po_line_id = X_po_line_id;
449:
466: sum(price_override* (nvl(quantity,0) -
467: nvl(quantity_cancelled,0)))
468: INTO X_quantity_released,
469: X_amount_released
470: FROM po_line_locations
471: WHERE po_header_id = X_po_header_id and
472: shipment_type = 'SCHEDULED' and
473: po_line_id = X_po_line_id;
474: end if;