750: activities_rec activities_cur%rowtype;
751:
752: CURSOR notes_cur is
753: SELECT text
754: FROM ar_notes
755: WHERE customer_trx_id = x_customer_trx_id;
756:
757: notes_rec notes_cur%rowtype;
758:
953: arp_util.debug ('get_request_status: ' || 'Getting the notes text');
954: END IF;
955: SELECT count(*)
956: INTO l_count_notes
957: FROM ar_notes
958: WHERE customer_trx_id = x_customer_trx_id;
959:
960: OPEN notes_cur;
961: FOR k in 1..l_count_notes