[Home] [Help]
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';
72: Sequences(14).name:='CZ_FUNC_COMP_SPECS_S';
1238:
1239: ind:=FlowId_GRID_DEF.First;
1240: LOOP
1241: BEGIN
1242: FOR i IN (SELECT grid_col_id FROM CZ_GRID_COLS
1243: WHERE grid_id=ind AND deleted_flag=NO_FLAG)
1244: LOOP
1245: get_Next_Val(new_id,'CZ_GRID_COLS_S');
1246: FlowId_GRID_COL(i.grid_col_id):=new_id;
1241: BEGIN
1242: FOR i IN (SELECT grid_col_id FROM CZ_GRID_COLS
1243: WHERE grid_id=ind AND deleted_flag=NO_FLAG)
1244: LOOP
1245: get_Next_Val(new_id,'CZ_GRID_COLS_S');
1246: FlowId_GRID_COL(i.grid_col_id):=new_id;
1247: END LOOP;
1248:
1249: FOR i IN (SELECT grid_col_id,prev_grid_col_id,grid_id FROM CZ_GRID_COLS
1245: get_Next_Val(new_id,'CZ_GRID_COLS_S');
1246: FlowId_GRID_COL(i.grid_col_id):=new_id;
1247: END LOOP;
1248:
1249: FOR i IN (SELECT grid_col_id,prev_grid_col_id,grid_id FROM CZ_GRID_COLS
1250: WHERE grid_id=ind AND deleted_flag=NO_FLAG
1251: START WITH prev_grid_col_id IS NULL
1252: CONNECT BY PRIOR grid_col_id=prev_grid_col_id)
1253: LOOP
1261: new_child:=FlowId_GRID_COL(i.grid_col_id);
1262:
1263: new_grid_id:=FlowId_GRID_DEF(i.grid_id);
1264:
1265: INSERT INTO CZ_GRID_COLS
1266: (GRID_ID,
1267: GRID_COL_ID,
1268: PREV_GRID_COL_ID,
1269: DATA_TYPE,
1277: DATA_TYPE,
1278: DELETED_FLAG,
1279: SECURITY_MASK,
1280: CHECKOUT_USER
1281: FROM CZ_GRID_COLS
1282: WHERE grid_col_id=i.grid_col_id;
1283:
1284: PACK;
1285: