Line 307: CURSOR C2 IS SELECT hr_locations_s.nextval FROM sys.dual;
303: ) IS
304: CURSOR C IS SELECT rowid FROM hr_locations
305: WHERE location_id = X_Location_Id;
306: -- 307: CURSOR C2 IS SELECT hr_locations_s.nextval FROM sys.dual; 308: BEGIN
309: hr_locations_pkg.validate_insert_location
310: (X_Location_code,
311: X_Location_id,