107: l_qsnr_element_rec qsnr_element_rec_type := p_qsnr_element_rec;
108:
109: CURSOR c_id IS
110: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL
111: FROM dual;
112:
113: CURSOR c_id_exists (l_id IN NUMBER) IS
114: SELECT 1
115: FROM PV_GE_QSNR_ELEMENTS_B
345: order by tl.qsnr_element_id;
346:
347: CURSOR c_id IS
348: SELECT pv_ge_qsnr_elements_b_s.NEXTVAL
349: FROM dual;
350:
351: CURSOR c_id_exists (l_id IN NUMBER) IS
352: SELECT 1
353: FROM PV_GE_QSNR_ELEMENTS_B