[Home] [Help]
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';
67: Sequences(9).name:='CZ_GRID_DEFS_S';
68: Sequences(10).name:='CZ_GRID_COLS_S';
69: Sequences(11).name:='CZ_GRID_CELLS_S';
921: k INTEGER;
922:
923: BEGIN
924:
925: get_Next_Val(new_id,'CZ_POPULATORS_S');
926:
927: FOR i IN (SELECT * FROM CZ_POPULATORS a WHERE deleted_flag=NO_FLAG
928: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
929: AND ps_node_id=a.owned_by_node_id AND deleted_flag=NO_FLAG))
923: BEGIN
924:
925: get_Next_Val(new_id,'CZ_POPULATORS_S');
926:
927: FOR i IN (SELECT * FROM CZ_POPULATORS a WHERE deleted_flag=NO_FLAG
928: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
929: AND ps_node_id=a.owned_by_node_id AND deleted_flag=NO_FLAG))
930: LOOP
931: BEGIN
928: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
929: AND ps_node_id=a.owned_by_node_id AND deleted_flag=NO_FLAG))
930: LOOP
931: BEGIN
932: SELECT CZ_POPULATORS_S.NEXTVAL INTO new_id FROM dual;
933:
934: new_node_id:=FlowId_PS_NODE(i.owned_by_node_id);
935: new_filter_id:=FlowId_FILTER_SET(i.filter_set_id);
936:
933:
934: new_node_id:=FlowId_PS_NODE(i.owned_by_node_id);
935: new_filter_id:=FlowId_FILTER_SET(i.filter_set_id);
936:
937: INSERT INTO CZ_POPULATORS(
938: POPULATOR_ID,
939: OWNED_BY_NODE_ID,
940: FILTER_SET_ID,
941: RESULT_TYPE,
975:
976: PACK;
977:
978: FlowId_POPULATOR(i.populator_id):=new_id;
979: get_Next_Val(new_id,'CZ_POPULATORS_S');
980:
981: EXCEPTION
982: WHEN NO_DATA_FOUND THEN
983: NULL;