93: l_dummy NUMBER;
94: l_return_status VARCHAR2(1);
95: CURSOR c_seq IS
96: SELECT ams_user_statuses_b_s.NEXTVAL
97: FROM dual;
98: CURSOR c_id_exists (x_id IN NUMBER) IS
99: SELECT 1
100: FROM dual
101: WHERE EXISTS (SELECT 1
96: SELECT ams_user_statuses_b_s.NEXTVAL
97: FROM dual;
98: CURSOR c_id_exists (x_id IN NUMBER) IS
99: SELECT 1
100: FROM dual
101: WHERE EXISTS (SELECT 1
102: FROM ams_user_statuses_vl
103: WHERE user_status_id = x_id);
104: BEGIN