133: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
134: || l_api_name;
135: -- Selects the nextval from sequence, used later for defining event key
136: CURSOR okl_key_csr IS 137: SELECT okl_wf_item_s.nextval 138: FROM dual;
139:
140: cursor c_get_ref_details (p_cure_report_id IN NUMBER)
141: is select crt.report_number