How to write ref cursor query in Oracle Reports

select c.key_segment, p.supplier_id, 
             decode(:in_col_nm, 'BRAND',nvl(p.product_brand,'<Unknown Brand>'), 'PLN',nvl(p.product_legal_name,'<Unknown Legal Name>')) COL_NM,
             sum(a.ext_price) sales_dols,
             sum(comp_allow_pkg.get_comp_allow_stddiv(a.control_loc_id, a.product_id, a.sold_to_customer_id,
                                                                                       a.doc_dt, a.ext_price, a.units)) cust_reb_dols, 
             sum(a.units) units, 
             sum(a.ext_cost) cost_dols
      from sales a, key_segment_plns c, product p, rep_wrtr_dw_cust h
      where a.doc_dt between :in_start_dt and :in_end_dt
      and   a.customer_oc = h.control_loc_id
      and   a.sold_to_customer_id = h.sold_to_cust_id
      and   a.ship_to_customer_id = h.ship_to_cust_id
      and   ((:in_dg_cd = 'B' and h.dealer_grower_cd in ('D','G')) or h.dealer_grower_cd = :in_dg_cd)
      and   a.product_id = p.product_id
      and   p.product_gl_class_cd = 'CHEM'
      and   p.product_legal_name = c.product_legal_name
      and   c.key_segment in ('GLYPHOSATE','PLANT HEALTH/RUST FUNGICIDES','PYRETHROIDS','STROBI FUNGICIDES')--&IN_KEY_SEGMENTS
     -- and    (:in_oc = 'ALL' or (a.control_loc_id in (select control_loc from control_loc_comb_ocs where control_loc_comb = :in_oc)))
      -- SALES DATA FILTERS TO MATCH ACCUM_SALES_DG_MV
      and   a.sale_type_cd in ('02','08')
      and   a.document_type_cd in ('I','C','D')
      and   (substr(a.product_id,-1) in ('0','1') OR nvl(upper(trim(p.product_brand)),'X') = 'TECH FEE')
      and   a.units <> 0
      and   a.unit_cost <> 0
      and   a.unit_price <> 0    
      -- NEW FILTERS  ADDED 9/11/07: LOCATION(BRANCH), BUSINESS TYPE, RSM/ASM/REP
      and   ((:in_loc = 'ALL') or (nvl(a.warehouse_id,'<blank>') in (SELECT param_value
                                                                        FROM   report_param
                                                                        WHERE  report_id = :IN_REPORT_ID
                                                                        AND    session_id= :IN_SESSION_ID
                                                                        AND    USER_ID   = :IN_USER_ID
                                                                        AND    param_name='LOCATION_TYPE')))
      and   ((:in_uhs_ag = 'ALL') or (:in_uhs_ag = 'NA' and p.product_uhs_ag != 'A') or (p.product_uhs_ag = :in_uhs_ag))
      and   ((:in_sales_rep = 'ALL') or  (nvl(a.territory_id,'<blank>') in (SELECT param_value
                                                                        FROM   report_param
                                                                        WHERE  report_id = :IN_REPORT_ID
                                                                        AND    session_id= :IN_SESSION_ID
                                                                        AND    USER_ID   = :IN_USER_ID
                                                                        AND    param_name='SALES_REP_TYPE')))
      and    EXISTS
            (SELECT '1'
             FROM  locations l, report_param rp
             WHERE rp.report_id = :IN_REPORT_ID
             AND   rp.session_id= :IN_SESSION_ID
             AND   rp.user_id   = :IN_USER_ID
             AND   rp.param_value = l.region
             AND   rp.param_name = 'REGION_TYPE'
             AND   a.warehouse_id = L.ARS_LOCATION) 
      and    EXISTS
            (SELECT '1'
             FROM  locations l, report_param rp
             WHERE rp.report_id = :IN_REPORT_ID
             AND   rp.session_id= :IN_SESSION_ID
             AND   rp.user_id   = :IN_USER_ID
             AND   rp.param_value = l.region
             AND   rp.param_name = 'DIVISION_TYPE'
            AND   a.warehouse_id = L.ARS_LOCATION)        
      group by c.key_segment, P.supplier_id, 
      decode(:in_col_nm, 'BRAND',nvl(p.product_brand,'<Unknown Brand>'), 'PLN',nvl(p.product_legal_name,'<Unknown Legal Name>'))

                                  

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59: