Line 23: CURSOR C2 IS SELECT HZ_TIMEZONE_MAP_s.nextval FROM sys.dual;
19: x_LAST_UPDATE_LOGIN NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM HZ_TIMEZONE_MAPPING
22: WHERE MAPPING_ID = x_MAPPING_ID; 23: CURSOR C2 IS SELECT HZ_TIMEZONE_MAP_s.nextval FROM sys.dual; 24: v_MAPPING_ID number;
25: v_ROWID varchar2(30);
26: BEGIN
27: If (x_MAPPING_ID IS NULL) then