328: cursor csr_next_location_id IS
329: SELECT hr_locations_s.nextval
330: FROM sys.dual;
331: --
332: l_number_table dbms_describe.number_table;
333: l_varchar_table dbms_describe.varchar2_table;
334: l_package_exists boolean;
335: l_package_name varchar2(2000);
336: --
329: SELECT hr_locations_s.nextval
330: FROM sys.dual;
331: --
332: l_number_table dbms_describe.number_table;
333: l_varchar_table dbms_describe.varchar2_table;
334: l_package_exists boolean;
335: l_package_name varchar2(2000);
336: --
337: BEGIN