[Home] [Help]
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';
73: Sequences(15).name:='CZ_INTL_TEXTS_S';
1326: ind:=FlowId_GRID_COL.First;
1327:
1328: LOOP
1329: BEGIN
1330: FOR i IN (SELECT grid_cell_id FROM CZ_GRID_CELLS
1331: WHERE grid_col_id=ind AND deleted_flag=NO_FLAG ORDER BY grid_cell_id)
1332: LOOP
1333: get_Next_Val(new_id,'CZ_GRID_CELLS_S');
1334: FlowId_GRID_CELL(i.grid_cell_id):=new_id;
1329: BEGIN
1330: FOR i IN (SELECT grid_cell_id FROM CZ_GRID_CELLS
1331: WHERE grid_col_id=ind AND deleted_flag=NO_FLAG ORDER BY grid_cell_id)
1332: LOOP
1333: get_Next_Val(new_id,'CZ_GRID_CELLS_S');
1334: FlowId_GRID_CELL(i.grid_cell_id):=new_id;
1335: END LOOP;
1336:
1337: FOR i IN (SELECT grid_cell_id,prev_grid_cell_id,grid_col_id,ps_node_id
1334: FlowId_GRID_CELL(i.grid_cell_id):=new_id;
1335: END LOOP;
1336:
1337: FOR i IN (SELECT grid_cell_id,prev_grid_cell_id,grid_col_id,ps_node_id
1338: FROM CZ_GRID_CELLS WHERE grid_col_id=ind AND deleted_flag=NO_FLAG ORDER BY grid_cell_id)
1339: LOOP
1340: BEGIN
1341: IF i.prev_grid_cell_id IS NOT NULL THEN
1342: new_parent:=FlowId_GRID_CELL(i.prev_grid_cell_id);
1362: ELSE
1363: new_ps_node_id:=NULL;
1364: END IF;
1365:
1366: INSERT INTO CZ_GRID_CELLS(
1367: GRID_COL_ID,
1368: GRID_CELL_ID,
1369: STR_VALUE,
1370: PREV_GRID_CELL_ID,
1380: new_ps_node_id,
1381: DELETED_FLAG,
1382: SECURITY_MASK,
1383: CHECKOUT_USER
1384: FROM CZ_GRID_CELLS
1385: WHERE grid_cell_id=i.grid_cell_id;
1386:
1387: PACK;
1388: