define curser and record

TYPE invoice_header ISRECORD(

   batch_source_name            VARCHAR(50),

   remit_to_address_id          VARCHAR(20),

   trx_date                     VARCHAR(20),

   purchase_order_number        VARCHAR(50)

)

 

   CURSOR service_request_lines (

      p_chr_session_id    VARCHAR2,

      p_num_cust_trx_id   NUMBER

   )

   IS

      SELECTDISTINCT service_request_no

                 FROM xxar_invoice_print_temps_ivs

                WHERE session_id = p_chr_session_id

                  AND inv_trx_id = p_num_cust_trx_id;