145: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
146: SELECT pa.pa_system_numbers_s.nextval */
147: SELECT pa_system_numbers_s.nextval
148: INTO l_system_id 149: FROM DUAL; 150:
151: if p_next_number is NULL then
152: l_next_number := 1;
153: else