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';
67: Sequences(9).name:='CZ_GRID_DEFS_S';
68: Sequences(10).name:='CZ_GRID_COLS_S';
69: Sequences(11).name:='CZ_GRID_CELLS_S';
70: Sequences(12).name:='CZ_UI_DEFS_S';
71: Sequences(13).name:='CZ_UI_NODES_S';
1192: new_id INTEGER;
1193:
1194: BEGIN
1195:
1196: FOR i IN (SELECT * FROM CZ_GRID_DEFS
1197: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');
1196: FOR i IN (SELECT * FROM CZ_GRID_DEFS
1197: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');
1201:
1202: INSERT INTO CZ_GRID_DEFS(
1203: GRID_ID,
1204: DEVL_PROJECT_ID,
1198: LOOP
1199:
1200: get_Next_Val(new_id,'CZ_GRID_DEFS_S');
1201:
1202: INSERT INTO CZ_GRID_DEFS(
1203: GRID_ID,
1204: DEVL_PROJECT_ID,
1205: NAME,
1206: DESC_TEXT,
2768:
2769: OLD_PROJECT_ID:=NEW_PROJECT_ID;
2770:
2771: IF var_grid_id IS NOT NULL THEN
2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(
2771: IF var_grid_id IS NOT NULL THEN
2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(
2777: GRID_ID,
2778: DEVL_PROJECT_ID,
2779: NAME,
2772: FOR i IN (SELECT * FROM CZ_GRID_DEFS
2773: WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
2774: LOOP
2775: get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
2776: INSERT INTO CZ_GRID_DEFS(
2777: GRID_ID,
2778: DEVL_PROJECT_ID,
2779: NAME,
2780: DESC_TEXT,