DBMS_OUTPUT questions

SPOOL c:\oraclescripts\customer_report.txt
DECLARE
	v_temp_id NUMBER(6);
	v_temp_total NUMBER(10,2);
	
CURSOR c_cus_details IS
	SELECT customer_id,
	Name,
	Phone_number
	FROM customer
	WHERE salesperson_id = 
	(
		SELECT employee_id
		FROM employee
		WHERE last_name = 'SHAW'
	)
	AND customer_id IN
	(
		SELECT customer_id
		FROM sales_order
		WHERE EXTRACT(YEAR FROM order_date) = '1990'
	)
;
CURSOR c_order_details IS
	SELECT customer_id,
	order_date,
	ship_date,
	total
	FROM sales_order
	WHERE customer_id = v_temp_id
	AND EXTRACT(YEAR FROM order_date) = '1990'
	ORDER BY order_date
;
BEGIN
	FOR cus_details IN c_cus_details
	LOOP
		v_temp_id := cus_details.customer_id;
		v_temp_total := 0;

		DBMS_OUTPUT.PUT_LINE('------------- Details --------------');
		DBMS_OUTPUT.PUT_LINE('Customer ID: '||cus_details.customer_id);
		DBMS_OUTPUT.PUT_LINE('Name:        '||cus_details.name);
		DBMS_OUTPUT.PUT_LINE('Phone:       '||cus_details.phone_number);
		DBMS_OUTPUT.PUT_LINE('-');
		DBMS_OUTPUT.PUT_LINE('------------- Orders ---------------');
		DBMS_OUTPUT.PUT_LINE('-');
		
		--USE TABS ON NEXT LINE INSTEAD OF SPACES

		DBMS_OUTPUT.PUT_LINE('-Order Date-  -Ship Date-   -Total-');
		
		FOR order_details IN c_order_details
		LOOP
			DBMS_OUTPUT.PUT_LINE('-'||order_details.order_date||'    '||order_details.ship_date||'     

'||order_details.total);
			v_temp_total := v_temp_total + order_details.total;
		END LOOP;

		DBMS_OUTPUT.PUT_LINE('-                          -------');

		DBMS_OUTPUT.PUT_LINE('-                           '||v_temp_total);

		DBMS_OUTPUT.PUT_LINE('-                          -------');

		--MOVE OUTPUT TO NEW PAGE. SPECIFIED PAGE LENGTH of XX lines. WITH PAGE HEADERS

	END LOOP;
END;
/
SPOOL OFF;