Lines Matching defs:v_newVal

1045 v_newVal NUMBER(12) := 0;

1049     SELECT  genericobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1051     IF v_newVal = 1 THEN

1053       SELECT NVL(max(id),0) INTO v_newVal FROM genericobjects;

1054       v_newVal := v_newVal + 1;

1057            EXIT WHEN v_incval>=v_newVal;

1062     --mysql_utilities.identity := v_newVal;

1064    :new.id := v_newVal;

1074 v_newVal NUMBER(12) := 0;

1078     SELECT  configobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1080     IF v_newVal = 1 THEN

1082       SELECT NVL(max(id),0) INTO v_newVal FROM configobjects;

1083       v_newVal := v_newVal + 1;

1086            EXIT WHEN v_incval>=v_newVal;

1091     --mysql_utilities.identity := v_newVal;

1093    :new.id := v_newVal;

1102 v_newVal NUMBER(12) := 0;

1106     SELECT  managedobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1108     IF v_newVal = 1 THEN

1110       SELECT NVL(max(id),0) INTO v_newVal FROM managedobjects;

1111       v_newVal := v_newVal + 1;

1114            EXIT WHEN v_incval>=v_newVal;

1119     --mysql_utilities.identity := v_newVal;

1121    :new.id := v_newVal;

1130 v_newVal NUMBER(12) := 0;

1134     SELECT  clusterobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1136     IF v_newVal = 1 THEN

1138       SELECT NVL(max(id),0) INTO v_newVal FROM clusterobjects;

1139       v_newVal := v_newVal + 1;

1142            EXIT WHEN v_incval>=v_newVal;

1147     --mysql_utilities.identity := v_newVal;

1149    :new.id := v_newVal;

1158 v_newVal NUMBER(12) := 0;

1162     SELECT  schedulerobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1164     IF v_newVal = 1 THEN

1166       SELECT NVL(max(id),0) INTO v_newVal FROM schedulerobjects;

1167       v_newVal := v_newVal + 1;

1170            EXIT WHEN v_incval>=v_newVal;

1175     --mysql_utilities.identity := v_newVal;

1177    :new.id := v_newVal;

1186     v_newVal NUMBER(12) := 0;

1190       SELECT  clusterobjects_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1192       IF v_newVal = 1 THEN

1194         SELECT NVL(max(id),0) INTO v_newVal FROM clusterobjects;

1195         v_newVal := v_newVal + 1;

1198           EXIT WHEN v_incval>=v_newVal;

1203 --mysql_utilities.identity := v_newVal;

1205       :new.id := v_newVal;

1214 v_newVal NUMBER(12) := 0;

1218     SELECT  objecttypes_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1220     IF v_newVal = 1 THEN

1222       SELECT NVL(max(id),0) INTO v_newVal FROM objecttypes;

1223       v_newVal := v_newVal + 1;

1226            EXIT WHEN v_incval>=v_newVal;

1231     --mysql_utilities.identity := v_newVal;

1233    :new.id := v_newVal;

1242     v_newVal NUMBER(12) := 0;

1246       SELECT  relationships_id_SEQ.NEXTVAL INTO v_newVal FROM DUAL;

1248       IF v_newVal = 1 THEN

1250         SELECT NVL(max(id),0) INTO v_newVal FROM relationships;

1251         v_newVal := v_newVal + 1;

1254           EXIT WHEN v_incval>=v_newVal;

1259       --mysql_utilities.identity := v_newVal;

1261       :new.id := v_newVal;