58: numRecords:=0;
59: Sequences(1).name:='CZ_PS_NODES_S';
60: Sequences(2).name:='CZ_FILTER_SETS_S';
61: Sequences(3).name:='CZ_SUB_CON_SETS_S';
62: Sequences(4).name:='CZ_EXPRESSIONS_S';
63: Sequences(5).name:='CZ_RULES_S';
64: Sequences(6).name:='CZ_EXPRESSION_NODES_S';
65: Sequences(7).name:='CZ_POPULATORS_S';
66: Sequences(8).name:='CZ_RULE_FOLDERS_S';
294: new_id INTEGER;
295:
296: BEGIN
297:
298: FOR i IN (SELECT * FROM CZ_EXPRESSIONS
299: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
300: LOOP
301: BEGIN
302: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
298: FOR i IN (SELECT * FROM CZ_EXPRESSIONS
299: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
300: LOOP
301: BEGIN
302: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
303:
304: INSERT INTO CZ_EXPRESSIONS(
305: EXPRESS_ID,
306: DEVL_PROJECT_ID,
300: LOOP
301: BEGIN
302: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
303:
304: INSERT INTO CZ_EXPRESSIONS(
305: EXPRESS_ID,
306: DEVL_PROJECT_ID,
307: NAME,
308: EXPR_STR,
2584: new_id INTEGER;
2585:
2586: BEGIN
2587:
2588: FOR i IN (SELECT * FROM CZ_EXPRESSIONS
2589: WHERE EXPRESS_ID=p_express_id AND deleted_flag=NO_FLAG)
2590: LOOP
2591: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
2592:
2587:
2588: FOR i IN (SELECT * FROM CZ_EXPRESSIONS
2589: WHERE EXPRESS_ID=p_express_id AND deleted_flag=NO_FLAG)
2590: LOOP
2591: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
2592:
2593: INSERT INTO CZ_EXPRESSIONS(
2594: EXPRESS_ID,
2595: DEVL_PROJECT_ID,
2589: WHERE EXPRESS_ID=p_express_id AND deleted_flag=NO_FLAG)
2590: LOOP
2591: get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
2592:
2593: INSERT INTO CZ_EXPRESSIONS(
2594: EXPRESS_ID,
2595: DEVL_PROJECT_ID,
2596: NAME,
2597: EXPR_STR,