23: if (x_location_id is null ) THEN
24:
25: SELECT pa_locations_s.nextval
26: INTO x_location_id 27: FROM sys.dual; 28:
29: end if;
30:
31: insert into PA_LOCATIONS (
Line 51: from sys.dual
47: p_CREATED_BY,
48: p_LAST_UPDATE_DATE,
49: p_LAST_UPDATED_BY,
50: p_LAST_UPDATE_LOGIN 51: from sys.dual 52: where not exists
53: (select NULL
54: from PA_LOCATIONS L
55: where L.LOCATION_ID = X_LOCATION_ID );