[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO CZ_DB_LOGS
(RUN_ID,
LOGTIME,
LOGUSER,
URGENCY,
CALLER,
STATUSCODE,
MESSAGE)
VALUES (GLOBAL_RUN_ID,
SYSDATE,
USER,
1,
p_caller,
var_status,
p_error_message);
FlowId_PS_NODE.DELETE;
FlowId_INTL_TEXT.DELETE;
FlowId_EXPRESSION.DELETE;
FlowId_FILTER_SET.DELETE;
FlowId_RULE.DELETE;
FlowId_SUB_CON_SET.DELETE;
FlowId_POPULATOR.DELETE;
FlowId_EXPRESSION_NODE.DELETE;
FlowId_GRID_DEF.DELETE;
FlowId_GRID_COL.DELETE;
FlowId_GRID_CELL.DELETE;
FlowId_UI_DEF.DELETE;
FlowId_UI_NODE.DELETE;
FlowId_FUNC_COMP_SPEC.DELETE;
FlowId_RULE_FOLDER.DELETE;
FlowId_MODEL_REF_EXPL.DELETE;
SELECT value INTO BATCH_SIZE FROM
CZ_DB_SETTINGS WHERE UPPER(setting_id)='BATCHSIZE';
EXECUTE IMMEDIATE 'SELECT '||p_sequence_name||'.NEXTVAL FROM dual'
INTO var_id;
INSERT INTO CZ_LOCALIZED_TEXTS
(INTL_TEXT_ID,
LOCALIZED_STR,
LANGUAGE,
SOURCE_LANG,
ORIG_SYS_REF,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
UI_DEF_ID,
MODEL_ID,
SEEDED_FLAG)
SELECT
p_new_intl_text_id,
LOCALIZED_STR,
LANGUAGE,
SOURCE_LANG,
ORIG_SYS_REF,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
p_ui_def_id,
p_model_id,
SEEDED_FLAG
FROM CZ_LOCALIZED_TEXTS
WHERE intl_text_id=p_old_intl_text_id AND deleted_flag=NO_FLAG;
SELECT CZ_PS_NODES_S.NEXTVAL INTO NEW_PROJECT_ID FROM dual;
SELECT * INTO i FROM CZ_DEVL_PROJECTS
WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
INSERT INTO CZ_DEVL_PROJECTS
(DEVL_PROJECT_ID,
INTL_TEXT_ID,
NAME,
PERSISTENT_PROJECT_ID,
VERSION,
DESC_TEXT ,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
ORIG_SYS_REF,
LAST_STRUCT_UPDATE,
LAST_LOGIC_UPDATE,
PUBLISHED,
MODEL_TYPE,
PRODUCT_KEY,
ORGANIZATION_ID,
INVENTORY_ITEM_ID)
VALUES(
NEW_PROJECT_ID,
var_intl_text_id,
var_name,
i.PERSISTENT_PROJECT_ID,
i.VERSION,
i.DESC_TEXT ,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.ORIG_SYS_REF,
i.LAST_STRUCT_UPDATE,
i.LAST_LOGIC_UPDATE,
i.PUBLISHED,
i.MODEL_TYPE,
i.PRODUCT_KEY,
i.ORGANIZATION_ID,
i.INVENTORY_ITEM_ID);
INSERT INTO CZ_RP_ENTRIES(object_type,object_id,enclosing_folder,deleted_flag,name)
SELECT object_type,NEW_PROJECT_ID,DECODE(ENCLOSE_FOLDER,-1,enclosing_folder,ENCLOSE_FOLDER),deleted_flag,var_name
FROM CZ_RP_ENTRIES
WHERE object_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
FOR i IN (SELECT * FROM CZ_EXPRESSIONS
WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
INSERT INTO CZ_EXPRESSIONS(
EXPRESS_ID,
DEVL_PROJECT_ID,
NAME,
EXPR_STR,
DESC_TEXT,
PRESENT_TYPE,
PARSED_FLAG,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
PERSISTENT_EXPRESSION_ID)
VALUES(
new_id,
NEW_PROJECT_ID,
i.NAME,
i.EXPR_STR,
i.DESC_TEXT,
i.PRESENT_TYPE,
i.PARSED_FLAG,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.PERSISTENT_EXPRESSION_ID);
INSERT INTO CZ_XFR_PROJECT_BILLS
(ORGANIZATION_ID,
COMPONENT_ITEM_ID,
DESCRIPTION,
LAST_IMPORT_RUN_ID,
LAST_IMPORT_DATE,
SOURCE_BILL_DELETED,
TOP_ITEM_ID,
DELETED_FLAG,
EXPLOSION_TYPE,
BILL_REVISION_DATE,
EFF_FROM,
EFF_TO,
SOURCE_SERVER,
MODEL_PS_NODE_ID,
COPY_ADDL_CHILD_MODELS)
SELECT
ORGANIZATION_ID,
COMPONENT_ITEM_ID,
DESCRIPTION,
LAST_IMPORT_RUN_ID,
LAST_IMPORT_DATE,
SOURCE_BILL_DELETED,
TOP_ITEM_ID,
YES_FLAG,
EXPLOSION_TYPE,
BILL_REVISION_DATE,
EFF_FROM,
EFF_TO,
SOURCE_SERVER,
NEW_PROJECT_ID,
COPY_ADDL_CHILD_MODELS
FROM CZ_XFR_PROJECT_BILLS
WHERE model_ps_node_id=OLD_PROJECT_ID;
FOR i IN (SELECT * FROM CZ_FILTER_SETS
WHERE express_id=k AND deleted_flag=NO_FLAG)
LOOP
BEGIN
new_exp_id:=FlowId_EXPRESSION(k);
INSERT INTO CZ_FILTER_SETS
(FILTER_SET_ID,
DEVL_PROJECT_ID,
EXPRESS_ID,
SOURCE_TYPE,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
SOURCE_VIEW_NAME,
SOURCE_VIEW_OWNER,
SOURCE_SYNTAX)
VALUES ( new_id,
NEW_PROJECT_ID,
new_exp_id,
i.SOURCE_TYPE,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.SOURCE_VIEW_NAME,
i.SOURCE_VIEW_OWNER,
i.SOURCE_SYNTAX);
INSERT INTO CZ_SUB_CON_SETS
(SUB_CONS_ID,
NAME,
DESC_TEXT,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
SELECT new_id,
NAME,
DESC_TEXT,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_SUB_CON_SETS
WHERE sub_cons_id=p_old_sub_id AND deleted_flag=NO_FLAG;
FOR i IN (SELECT ps_node_id,property_id,data_value,data_num_value
FROM CZ_PS_PROP_VALS
WHERE ps_node_id=p_old_ps_id AND deleted_flag='0')
LOOP
INSERT INTO CZ_PS_PROP_VALS
(PS_NODE_ID,
PROPERTY_ID,
DATA_VALUE,
DATA_NUM_VALUE, -- sselahi
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
SELECT p_new_ps_id,
PROPERTY_ID,
DATA_VALUE,
DATA_NUM_VALUE, -- sselahi
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_PS_PROP_VALS
WHERE PS_NODE_ID=p_old_ps_id AND property_id=i.property_id
AND data_value=i.data_value AND data_num_value=i.data_num_value AND deleted_flag=NO_FLAG;
FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
WHERE model_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_MODEL_REF_EXPLS_S');
FOR i IN (SELECT * FROM CZ_MODEL_REF_EXPLS
WHERE model_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
IF i.parent_expl_node_id IS NOT NULL THEN
new_parent:=FlowId_MODEL_REF_EXPL(i.parent_expl_node_id);
INSERT INTO CZ_MODEL_REF_EXPLS
(model_ref_expl_id,
parent_expl_node_id,
referring_node_id,
model_id,
component_id,
child_model_expl_id,
ps_node_type,
virtual_flag,
node_depth,
expl_node_type,
has_trackable_children,
deleted_flag)
VALUES( new_child,
new_parent,
new_referring_node_id,
NEW_PROJECT_ID,
new_component_id,
new_child_model_expl_id,
i.ps_node_type,
i.virtual_flag,
i.node_depth,
i.expl_node_type,
i.has_trackable_children,
i.deleted_flag);
FOR i IN (SELECT ps_node_id FROM CZ_PS_NODES
WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_PS_NODES_S');
FOR i IN (SELECT * FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
IF i.parent_id IS NOT NULL THEN
new_parent:=FlowId_PS_NODE(i.parent_id);
INSERT INTO CZ_PS_NODES
(PS_NODE_ID,
DEVL_PROJECT_ID,
FROM_POPULATOR_ID,
PROPERTY_BACKPTR,
ITEM_TYPE_BACKPTR,
INTL_TEXT_ID,
SUB_CONS_ID,
ITEM_ID,
NAME,
RESOURCE_FLAG,
INITIAL_VALUE,
initial_num_value, -- sselahi
PARENT_ID,
MINIMUM,
MAXIMUM,
PS_NODE_TYPE,
FEATURE_TYPE,
PRODUCT_FLAG,
REFERENCE_ID,
MULTI_CONFIG_FLAG,
ORDER_SEQ_FLAG,
SYSTEM_NODE_FLAG,
TREE_SEQ,
COUNTED_OPTIONS_FLAG,
UI_OMIT,
UI_SECTION,
BOM_TREATMENT,
ORIG_SYS_REF,
BOM_REQUIRED_FLAG,
SO_ITEM_TYPE_CODE,
MINIMUM_SELECTED,
MAXIMUM_SELECTED,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
USER_NUM01,
USER_NUM02,
USER_NUM03,
USER_NUM04,
USER_STR01,
USER_STR02,
USER_STR03,
USER_STR04,
VIRTUAL_FLAG,
DECIMAL_QTY_FLAG,
VIOLATION_TEXT_ID,
EFFECTIVITY_SET_ID,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVE_USAGE_MASK,
COMPONENT_SEQUENCE_ID,
QUOTEABLE_FLAG,
PRIMARY_UOM_CODE,
PERSISTENT_NODE_ID,
BOM_SORT_ORDER,
COMPONENT_SEQUENCE_PATH,
IB_TRACKABLE)
VALUES( new_child,
NEW_PROJECT_ID,
i.FROM_POPULATOR_ID,
i.PROPERTY_BACKPTR,
i.ITEM_TYPE_BACKPTR,
new_intl_text_id,
new_sub_cons_id,
i.ITEM_ID,
i.NAME,
i.RESOURCE_FLAG,
i.INITIAL_VALUE,
i.initial_num_value, -- sselahi
new_parent,
i.MINIMUM,
i.MAXIMUM,
i.PS_NODE_TYPE,
i.FEATURE_TYPE,
i.PRODUCT_FLAG,
i.REFERENCE_ID,
i.MULTI_CONFIG_FLAG,
i.ORDER_SEQ_FLAG,
i.SYSTEM_NODE_FLAG,
i.TREE_SEQ,
i.COUNTED_OPTIONS_FLAG,
i.UI_OMIT,
i.UI_SECTION,
i.BOM_TREATMENT,
i.ORIG_SYS_REF,
i.BOM_REQUIRED_FLAG,
i.SO_ITEM_TYPE_CODE,
i.MINIMUM_SELECTED,
i.MAXIMUM_SELECTED,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.USER_NUM01,
i.USER_NUM02,
i.USER_NUM03,
i.USER_NUM04,
i.USER_STR01,
i.USER_STR02,
i.USER_STR03,
i.USER_STR04,
i.VIRTUAL_FLAG,
i.DECIMAL_QTY_FLAG,
i.VIOLATION_TEXT_ID,
i.EFFECTIVITY_SET_ID,
i.EFFECTIVE_FROM,
i.EFFECTIVE_UNTIL,
i.EFFECTIVE_USAGE_MASK,
i.COMPONENT_SEQUENCE_ID,
i.QUOTEABLE_FLAG,
i.PRIMARY_UOM_CODE,
i.PERSISTENT_NODE_ID,
i.BOM_SORT_ORDER,
i.COMPONENT_SEQUENCE_PATH,
i.IB_TRACKABLE);
FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');
INSERT INTO CZ_FUNC_COMP_SPECS(
FUNC_COMP_ID,
COMPANION_TYPE,
DEVL_PROJECT_ID,
COMPONENT_ID,
NAME,
DESC_TEXT,
PROGRAM_STRING,
IMPLEMENTATION_TYPE,
RULE_FOLDER_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID)
VALUES(
new_id,
i.COMPANION_TYPE,
NEW_PROJECT_ID,
new_component_id,
i.NAME,
i.DESC_TEXT,
i.PROGRAM_STRING,
i.IMPLEMENTATION_TYPE,
new_rule_folder_id,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
new_model_ref_expl_id);
FOR i IN (SELECT * FROM CZ_POPULATORS a WHERE deleted_flag=NO_FLAG
AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
AND ps_node_id=a.owned_by_node_id AND deleted_flag=NO_FLAG))
LOOP
BEGIN
SELECT CZ_POPULATORS_S.NEXTVAL INTO new_id FROM dual;
INSERT INTO CZ_POPULATORS(
POPULATOR_ID,
OWNED_BY_NODE_ID,
FILTER_SET_ID,
RESULT_TYPE,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
PERSISTENT_POPULATOR_ID,
FEATURE_TYPE,
VIEW_NAME,
HAS_ITEM,
HAS_ITEM_TYPE,
HAS_PROPERTY,
HAS_DESCRIPTION,
HAS_LEVEL,
QUERY_SYNTAX,
NAME,
DESCRIPTION)
VALUES(
new_id,
new_node_id,
new_filter_id,
i.RESULT_TYPE,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.PERSISTENT_POPULATOR_ID,
i.FEATURE_TYPE,
i.VIEW_NAME,
i.HAS_ITEM,
i.HAS_ITEM_TYPE,
i.HAS_PROPERTY,
i.HAS_DESCRIPTION,
i.HAS_LEVEL,
i.QUERY_SYNTAX,
i.NAME,
i.DESCRIPTION);
UPDATE CZ_PS_NODES SET from_populator_id=FlowId_POPULATOR(k)
WHERE from_populator_id=k AND devl_project_id=NEW_PROJECT_ID;
FOR i IN (SELECT expr_node_id FROM CZ_EXPRESSION_NODES
WHERE express_id=ind AND deleted_flag=NO_FLAG
ORDER BY expr_node_id)
LOOP
get_Next_Val(new_id,'CZ_EXPRESSION_NODES_S');
FOR i IN (SELECT * FROM CZ_EXPRESSION_NODES
WHERE express_id=ind AND deleted_flag=NO_FLAG
ORDER BY expr_node_id)
LOOP
BEGIN
IF i.expr_parent_id IS NOT NULL THEN
new_parent:=FlowId_EXPRESSION_NODE(i.expr_parent_id);
INSERT INTO CZ_EXPRESSION_NODES(
EXPR_NODE_ID,
EXPRESS_ID,
SEQ_NBR,
ITEM_TYPE_ID,
PS_NODE_ID,
ITEM_ID,
FILTER_SET_ID,
GRID_COL_ID,
EXPR_PARENT_ID,
PROPERTY_ID,
COMPILE_ADVICE,
COL,
DATA_VALUE,
DATA_NUM_VALUE, -- sselahi
FIELD_NAME,
EXPR_TYPE,
EXPR_SUBTYPE,
TOKEN_LIST_SEQ,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
CONSEQUENT_FLAG,
MODEL_REF_EXPL_ID,
RULE_ID,
TEMPLATE_ID,
ARGUMENT_SIGNATURE_ID,
ARGUMENT_INDEX,
PARAM_SIGNATURE_ID,
PARAM_INDEX,
ARGUMENT_NAME,
DATA_TYPE,
DISPLAY_NODE_DEPTH,
COLLECTION_FLAG,
SOURCE_OFFSET,
SOURCE_LENGTH,
RELATIVE_NODE_PATH,
MUTABLE_FLAG,
EVENT_EXECUTION_SCOPE)
VALUES(
new_child,
new_express_id,
i.SEQ_NBR,
i.ITEM_TYPE_ID,
new_ps_node_id,
i.ITEM_ID,
i.FILTER_SET_ID,
i.GRID_COL_ID,
new_parent,
i.PROPERTY_ID,
i.COMPILE_ADVICE,
i.COL,
i.DATA_VALUE,
i.DATA_NUM_VALUE, -- sselahi
i.FIELD_NAME,
i.EXPR_TYPE,
i.EXPR_SUBTYPE,
i.TOKEN_LIST_SEQ,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.CONSEQUENT_FLAG,
new_model_ref_expl_id,
p_rule_id,
i.TEMPLATE_ID,
i.ARGUMENT_SIGNATURE_ID,
i.ARGUMENT_INDEX,
i.PARAM_SIGNATURE_ID,
i.PARAM_INDEX,
i.ARGUMENT_NAME,
i.DATA_TYPE,
i.DISPLAY_NODE_DEPTH,
i.COLLECTION_FLAG,
i.SOURCE_OFFSET,
i.SOURCE_LENGTH,
i.RELATIVE_NODE_PATH,
i.MUTABLE_FLAG,
i.EVENT_EXECUTION_SCOPE);
FOR i IN (SELECT * FROM CZ_GRID_DEFS
WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_GRID_DEFS_S');
INSERT INTO CZ_GRID_DEFS(
GRID_ID,
DEVL_PROJECT_ID,
NAME,
DESC_TEXT,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
VALUES(
new_id,
NEW_PROJECT_ID,
i.NAME,
i.DESC_TEXT,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER);
FOR i IN (SELECT grid_col_id FROM CZ_GRID_COLS
WHERE grid_id=ind AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_GRID_COLS_S');
FOR i IN (SELECT grid_col_id,prev_grid_col_id,grid_id FROM CZ_GRID_COLS
WHERE grid_id=ind AND deleted_flag=NO_FLAG
START WITH prev_grid_col_id IS NULL
CONNECT BY PRIOR grid_col_id=prev_grid_col_id)
LOOP
BEGIN
IF i.prev_grid_col_id IS not NULL THEN
new_parent:=FlowId_GRID_COL(i.prev_grid_col_id);
INSERT INTO CZ_GRID_COLS
(GRID_ID,
GRID_COL_ID,
PREV_GRID_COL_ID,
DATA_TYPE,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
SELECT
new_grid_id,
new_child,
new_parent,
DATA_TYPE,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_GRID_COLS
WHERE grid_col_id=i.grid_col_id;
FOR i IN (SELECT grid_cell_id FROM CZ_GRID_CELLS
WHERE grid_col_id=ind AND deleted_flag=NO_FLAG ORDER BY grid_cell_id)
LOOP
get_Next_Val(new_id,'CZ_GRID_CELLS_S');
FOR i IN (SELECT grid_cell_id,prev_grid_cell_id,grid_col_id,ps_node_id
FROM CZ_GRID_CELLS WHERE grid_col_id=ind AND deleted_flag=NO_FLAG ORDER BY grid_cell_id)
LOOP
BEGIN
IF i.prev_grid_cell_id IS NOT NULL THEN
new_parent:=FlowId_GRID_CELL(i.prev_grid_cell_id);
INSERT INTO CZ_GRID_CELLS(
GRID_COL_ID,
GRID_CELL_ID,
STR_VALUE,
PREV_GRID_CELL_ID,
PS_NODE_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
SELECT
new_grid_col_id,
new_child,
STR_VALUE,
new_parent,
new_ps_node_id,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_GRID_CELLS
WHERE grid_cell_id=i.grid_cell_id;
FOR k IN (SELECT * FROM CZ_UI_DEFS
WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
get_Next_Val(new_ui_def_id,'CZ_UI_DEFS_S');
INSERT INTO CZ_UI_DEFS
(UI_DEF_ID,
DESC_TEXT,
NAME,
DEVL_PROJECT_ID,
COMPONENT_ID,
TREE_SEQ,
DELETED_FLAG,
EFF_FROM,
EFF_TO,
SECURITY_MASK,
EFF_MASK,
CHECKOUT_USER,
UI_STYLE,
GEN_VERSION,
TREENODE_DISPLAY_SOURCE,
GEN_HEADER,
LOOK_AND_FEEL,
CONTROLS_PER_SCREEN,
PERSISTENT_UI_DEF_ID,
MODEL_TIMESTAMP,
UI_STATUS,
FROM_MASTER_TEMPLATE_ID,
PAGE_SET_ID,
START_PAGE_ID,
ERR_RUN_ID)
VALUES(
new_ui_def_id,
k.DESC_TEXT,
k.NAME,
NEW_PROJECT_ID,
new_comp_id,
k.TREE_SEQ+1,
k.DELETED_FLAG,
k.EFF_FROM,
k.EFF_TO,
k.SECURITY_MASK,
k.EFF_MASK,
k.CHECKOUT_USER,
k.UI_STYLE,
k.GEN_VERSION,
k.TREENODE_DISPLAY_SOURCE,
k.GEN_HEADER,
k.LOOK_AND_FEEL,
k.CONTROLS_PER_SCREEN,
k.PERSISTENT_UI_DEF_ID,
k.MODEL_TIMESTAMP,
k.UI_STATUS,
k.FROM_MASTER_TEMPLATE_ID,
k.PAGE_SET_ID,
k.START_PAGE_ID,
k.ERR_RUN_ID);
INSERT INTO CZ_UI_PROPERTIES
(KEY_STR,
UI_DEF_ID,
VALUE_STR,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
SELECT
KEY_STR,
new_ui_def_id,
VALUE_STR,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_UI_PROPERTIES
WHERE ui_def_id=k.ui_def_id;
FOR i IN (SELECT ui_node_id FROM CZ_UI_NODES WHERE
ui_def_id=k.ui_def_id AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_UI_NODES_S');
FOR i IN (SELECT * FROM CZ_UI_NODES
WHERE ui_def_id=k.ui_def_id AND deleted_flag=NO_FLAG)
LOOP
BEGIN
new_parent:=FlowId_UI_NODE(i.parent_id);
INSERT INTO CZ_UI_NODES(
UI_NODE_ID,
UI_DEF_ID,
FUNC_COMP_ID,
REL_TOP_POS,
WIDTH,
HEIGHT,
PARENT_ID,
REL_LEFT_POS,
COMPONENT_ID,
CONTAINER_ID,
CAPTION_ID,
UI_NODE_TYPE,
PS_NODE_ID,
NAME,
UI_NODE_REF_ID,
BACKGROUND_COLOR,
LCE_IDENTIFIER,
DESC_TEXT,
TREE_SEQ,
TREE_DISPLAY_FLAG,
MODIFIED_FLAGS,
TAB_ORDER,
DEFAULT_FONT_FLAG,
TOOL_TIP_ID,
DEFAULT_BKGRND_COLOR_FLAG,
DEFAULT_BKGRND_PICTURE_FLAG,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID,
FONTBOLD,
FONTCOLOR,
FONTITALIC,
FONTUNDERLINE,
FONTSIZE,
FONTNAME,
BACKGROUNDSTYLE,
CONTROLTYPE,
BACKGROUNDPICTURE,
BORDERS,
PICTURENAME,
UI_DEF_REF_ID,
OPTION_SORT_METHOD,
OPTION_SORT_PROPERTY,
OPTION_SORT_ORDER,
OPTION_SORT_SELECT_FIRST,
PAGE_NUMBER,
PROPERTY_ID,
PERSISTENT_UI_NODE_ID)
VALUES(
new_child,
new_ui_def_id,
new_func_comp_id,
i.REL_TOP_POS,
i.WIDTH,
i.HEIGHT,
new_parent,
i.REL_LEFT_POS,
new_component_id,
new_container_id,
new_intl_text_id,
i.UI_NODE_TYPE,
new_ps_node_id,
i.NAME,
new_ui_node_ref_id,
i.BACKGROUND_COLOR,
new_lce_identifier,
i.DESC_TEXT,
i.TREE_SEQ,
i.TREE_DISPLAY_FLAG,
i.MODIFIED_FLAGS,
i.TAB_ORDER,
i.DEFAULT_FONT_FLAG,
new_tool_tip_id,
i.DEFAULT_BKGRND_COLOR_FLAG,
i.DEFAULT_BKGRND_PICTURE_FLAG,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
new_model_ref_expl_id,
i.FONTBOLD,
i.FONTCOLOR,
i.FONTITALIC,
i.FONTUNDERLINE,
i.FONTSIZE,
i.FONTNAME,
i.BACKGROUNDSTYLE,
i.CONTROLTYPE,
i.BACKGROUNDPICTURE,
i.BORDERS,
i.PICTURENAME,
i.ui_def_ref_id,
i.OPTION_SORT_METHOD,
i.OPTION_SORT_PROPERTY,
i.OPTION_SORT_ORDER,
i.OPTION_SORT_SELECT_FIRST,
i.PAGE_NUMBER,
i.PROPERTY_ID,
i.PERSISTENT_UI_NODE_ID);
INSERT INTO CZ_UI_NODE_PROPS
(UI_NODE_ID,
UI_DEF_ID,
KEY_STR,
VALUE_STR,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
CONTAINER_ID)
SELECT
new_child,
new_ui_def_id,
KEY_STR,
VALUE_STR,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
CONTAINER_ID
FROM CZ_UI_NODE_PROPS
WHERE ui_node_id=i.ui_node_id AND ui_def_id=k.ui_def_id AND deleted_flag=NO_FLAG;
FOR i IN (SELECT rule_folder_id FROM CZ_RULE_FOLDERS
WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_RULE_FOLDERS_S');
FOR i IN (SELECT * FROM CZ_RULE_FOLDERS
WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
IF i.parent_rule_folder_id IS NOT NULL THEN
new_parent:=FlowId_RULE_FOLDER(i.parent_rule_folder_id);
INSERT INTO CZ_RULE_FOLDERS
(RULE_FOLDER_ID,
NAME,
DESC_TEXT,
PARENT_RULE_FOLDER_ID,
DEVL_PROJECT_ID,
TREE_SEQ,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
FOLDER_TYPE,
EFFECTIVE_USAGE_MASK,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVITY_SET_ID,
PERSISTENT_RULE_FOLDER_ID,
OBJECT_TYPE,
DISABLED_FLAG,
ORIG_SYS_REF)
VALUES(
new_child,
i.NAME,
i.DESC_TEXT,
new_parent,
NEW_PROJECT_ID,
i.TREE_SEQ,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.FOLDER_TYPE,
i.EFFECTIVE_USAGE_MASK,
i.EFFECTIVE_FROM,
i.EFFECTIVE_UNTIL,
i.EFFECTIVITY_SET_ID,
i.PERSISTENT_RULE_FOLDER_ID,
i.OBJECT_TYPE,
i.DISABLED_FLAG,
i.ORIG_SYS_REF);
FOR i IN (SELECT * FROM CZ_RULES
WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
LOOP
BEGIN
get_Next_Val(new_id,'CZ_RULES_S');
INSERT INTO CZ_RULES(
RULE_ID,
SUB_CONS_ID,
REASON_ID,
AMOUNT_ID,
GRID_ID,
RULE_FOLDER_ID,
DEVL_PROJECT_ID,
INVALID_FLAG,
DESC_TEXT,
NAME,
ANTECEDENT_ID,
CONSEQUENT_ID,
RULE_TYPE,
EXPR_RULE_TYPE,
COMPONENT_ID,
REASON_TYPE,
DISABLED_FLAG,
ORIG_SYS_REF,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
EFFECTIVITY_SET_ID,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVE_USAGE_MASK,
PERSISTENT_RULE_ID,
SEQ_NBR,
RULE_FOLDER_TYPE,
UNSATISFIED_MSG_ID,
UNSATISFIED_MSG_SOURCE,
SEEDED_FLAG)
VALUES( new_id,
new_sub_cons_id,
new_reason_id,
new_amount_id,
new_grid_id,
new_rule_folder_id,
NEW_PROJECT_ID,
i.INVALID_FLAG,
i.DESC_TEXT,
i.NAME,
new_antecedent_id,
new_consequent_id,
i.RULE_TYPE,
i.EXPR_RULE_TYPE,
new_component_id,
i.REASON_TYPE,
i.DISABLED_FLAG,
i.ORIG_SYS_REF,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.EFFECTIVITY_SET_ID,
i.EFFECTIVE_FROM,
i.EFFECTIVE_UNTIL,
i.EFFECTIVE_USAGE_MASK,
i.PERSISTENT_RULE_ID,
i.SEQ_NBR,
i.RULE_FOLDER_TYPE,
new_msg_id,
i.UNSATISFIED_MSG_SOURCE,
i.SEEDED_FLAG);
FOR i IN(SELECT b.* FROM CZ_RULES a,CZ_COMBO_FEATURES b
WHERE a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
LOOP
BEGIN
BEGIN
new_feature_id:=FlowId_PS_NODE(i.feature_id);
INSERT INTO CZ_COMBO_FEATURES
(FEATURE_ID,
GRID_COL_ID,
RULE_ID,
COL_TYPE,
MINIMUM,
MAXIMUM,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID)
VALUES(
new_feature_id,
new_grid_col_id,
new_rule_id,
i.COL_TYPE,
i.MINIMUM,
i.MAXIMUM,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
new_model_ref_expl_id);
FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_CELLS b
WHERE a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
LOOP
BEGIN
new_rule_id:=FlowId_RULE(i.rule_id);
INSERT INTO CZ_DES_CHART_CELLS
(RULE_ID,
PRIMARY_OPT_ID,
SECONDARY_OPT_ID,
MARK_CHAR,
SECONDARY_FEAT_EXPL_ID,
SECONDARY_FEATURE_ID,
DELETED_FLAG,
SECURITY_MASK ,
CHECKOUT_USER )
VALUES(
new_rule_id,
new_primary_opt_id,
new_secondary_opt_id,
i.MARK_CHAR,
new_secondary_feat_expl_id,
new_secondary_feature_id,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER);
FOR i IN (SELECT b.* FROM CZ_RULES a,CZ_DES_CHART_FEATURES b WHERE
a.devl_project_id=OLD_PROJECT_ID AND a.rule_id=b.rule_id
AND a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG)
LOOP
BEGIN
new_rule_id:=FlowId_RULE(i.rule_id);
INSERT INTO CZ_DES_CHART_FEATURES
(RULE_ID,
FEATURE_ID,
FEATURE_TYPE ,
MODEL_REF_EXPL_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
VALUES(
new_rule_id,
new_feature_id,
i.FEATURE_TYPE ,
new_ref_id,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER);
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
FOR i IN (SELECT * FROM CZ_PS_NODES
WHERE devl_project_id=p_project_id AND deleted_flag=NO_FLAG
START WITH parent_id=p_parent_id
CONNECT BY PRIOR ps_node_id=parent_id)
LOOP
get_Next_Val(new_id,'CZ_PS_NODES_S');
FOR i IN (SELECT * FROM CZ_PS_NODES
WHERE ps_node_id=ind AND deleted_flag=NO_FLAG)
LOOP
IF i.parent_id IS NOT NULL THEN
new_parent:=FlowId_PS_NODE(i.parent_id);
INSERT INTO CZ_PS_NODES
(PS_NODE_ID,
DEVL_PROJECT_ID,
FROM_POPULATOR_ID,
PROPERTY_BACKPTR,
ITEM_TYPE_BACKPTR,
INTL_TEXT_ID,
SUB_CONS_ID,
ITEM_ID,
NAME,
RESOURCE_FLAG,
INITIAL_VALUE,
initial_num_value, -- sselahi
PARENT_ID,
MINIMUM,
MAXIMUM,
PS_NODE_TYPE,
FEATURE_TYPE,
PRODUCT_FLAG,
REFERENCE_ID,
MULTI_CONFIG_FLAG,
ORDER_SEQ_FLAG,
SYSTEM_NODE_FLAG,
TREE_SEQ,
COUNTED_OPTIONS_FLAG,
UI_OMIT,
UI_SECTION,
BOM_TREATMENT,
ORIG_SYS_REF,
BOM_REQUIRED_FLAG,
SO_ITEM_TYPE_CODE,
MINIMUM_SELECTED,
MAXIMUM_SELECTED,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
USER_NUM01,
USER_NUM02,
USER_NUM03,
USER_NUM04,
USER_STR01,
USER_STR02,
USER_STR03,
USER_STR04,
VIRTUAL_FLAG,
VIOLATION_TEXT_ID,
DECIMAL_QTY_FLAG,
EFFECTIVITY_SET_ID,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVE_USAGE_MASK,
COMPONENT_SEQUENCE_ID,
PERSISTENT_NODE_ID,
QUOTEABLE_FLAG,
PRIMARY_UOM_CODE,
BOM_SORT_ORDER,
COMPONENT_SEQUENCE_PATH,
IB_TRACKABLE)
VALUES(
new_child,
NEW_PROJECT_ID,
i.FROM_POPULATOR_ID,
i.PROPERTY_BACKPTR,
i.ITEM_TYPE_BACKPTR,
new_intl_text_id,
i.SUB_CONS_ID,
i.ITEM_ID,
i.NAME,
i.RESOURCE_FLAG,
i.INITIAL_VALUE,
i.initial_num_value, -- sselahi
new_parent,
i.MINIMUM,
i.MAXIMUM,
i.PS_NODE_TYPE,
i.FEATURE_TYPE,
i.PRODUCT_FLAG,
i.REFERENCE_ID,
i.MULTI_CONFIG_FLAG,
i.ORDER_SEQ_FLAG,
i.SYSTEM_NODE_FLAG,
i.TREE_SEQ,
i.COUNTED_OPTIONS_FLAG,
i.UI_OMIT,
i.UI_SECTION,
i.BOM_TREATMENT,
i.ORIG_SYS_REF,
i.BOM_REQUIRED_FLAG,
i.SO_ITEM_TYPE_CODE,
i.MINIMUM_SELECTED,
i.MAXIMUM_SELECTED,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.USER_NUM01,
i.USER_NUM02,
i.USER_NUM03,
i.USER_NUM04,
i.USER_STR01,
i.USER_STR02,
i.USER_STR03,
i.USER_STR04,
i.VIRTUAL_FLAG,
i.VIOLATION_TEXT_ID,
i.DECIMAL_QTY_FLAG,
i.EFFECTIVITY_SET_ID,
i.EFFECTIVE_FROM,
i.EFFECTIVE_UNTIL,
i.EFFECTIVE_USAGE_MASK,
i.COMPONENT_SEQUENCE_ID,
i.PERSISTENT_NODE_ID,
i.QUOTEABLE_FLAG,
i.PRIMARY_UOM_CODE,
i.BOM_SORT_ORDER,
i.COMPONENT_SEQUENCE_PATH,
i.IB_TRACKABLE);
FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
WHERE DEVL_PROJECT_ID=p_project_id
AND RULE_FOLDER_ID=p_old_rule_folder_id AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_FUNC_COMP_SPECS_S');
INSERT INTO CZ_FUNC_COMP_SPECS
(FUNC_COMP_ID,
COMPANION_TYPE,
DEVL_PROJECT_ID,
COMPONENT_ID,
NAME,
DESC_TEXT,
PROGRAM_STRING,
IMPLEMENTATION_TYPE,
RULE_FOLDER_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID)
VALUES(
new_id,
i.COMPANION_TYPE,
i.DEVL_PROJECT_ID,
i.COMPONENT_ID,
i.NAME,
i.DESC_TEXT,
i.PROGRAM_STRING,
i.IMPLEMENTATION_TYPE,
p_new_rule_folder_id,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.MODEL_REF_EXPL_ID);
SELECT CZ_FUNC_COMP_SPECS_S.NEXTVAL INTO p_out_new_func_comp_id FROM dual;
FOR i IN(SELECT component_id FROM CZ_FUNC_COMP_SPECS
WHERE devl_project_id=p_project_id
AND func_comp_id=p_func_comp_id AND deleted_flag=NO_FLAG)
LOOP
var_component_id:=i.component_id;
FOR i IN (SELECT * FROM CZ_FUNC_COMP_SPECS
WHERE func_comp_id=p_func_comp_id
AND devl_project_id=p_project_id AND deleted_flag=NO_FLAG)
LOOP
IF p_new_rule_folder_id IS NOT NULL AND p_new_rule_folder_id<>-1 THEN
new_rule_folder_id:=p_new_rule_folder_id;
INSERT INTO CZ_FUNC_COMP_SPECS(
FUNC_COMP_ID,
COMPANION_TYPE,
DEVL_PROJECT_ID,
COMPONENT_ID,
NAME,
DESC_TEXT,
PROGRAM_STRING,
IMPLEMENTATION_TYPE,
RULE_FOLDER_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID)
VALUES(
p_out_new_func_comp_id,
i.COMPANION_TYPE,
p_project_id,
var_component_id,
i.NAME||'-'||TO_CHAR(p_out_new_func_comp_id),
i.DESC_TEXT,
i.PROGRAM_STRING,
i.IMPLEMENTATION_TYPE,
new_rule_folder_id,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.MODEL_REF_EXPL_ID);
FOR i IN (SELECT * FROM CZ_EXPRESSIONS
WHERE EXPRESS_ID=p_express_id AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_id,'CZ_EXPRESSIONS_S');
INSERT INTO CZ_EXPRESSIONS(
EXPRESS_ID,
DEVL_PROJECT_ID,
NAME,
EXPR_STR,
DESC_TEXT,
PRESENT_TYPE,
PARSED_FLAG,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
PERSISTENT_EXPRESSION_ID)
VALUES(
new_id,
i.DEVL_PROJECT_ID,
i.NAME,
i.EXPR_STR,
i.DESC_TEXT,
i.PRESENT_TYPE,
i.PARSED_FLAG,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.PERSISTENT_EXPRESSION_ID);
UPDATE CZ_RULES SET ANTECEDENT_ID=new_id WHERE rule_id=p_rule_id;
UPDATE CZ_RULES SET CONSEQUENT_ID=new_id WHERE rule_id=p_rule_id;
UPDATE CZ_RULES SET AMOUNT_ID=new_id WHERE rule_id=p_rule_id;
INSERT INTO CZ_DES_CHART_CELLS
(RULE_ID,
PRIMARY_OPT_ID,
SECONDARY_OPT_ID,
MARK_CHAR,
SECONDARY_FEAT_EXPL_ID,
SECONDARY_FEATURE_ID,
DELETED_FLAG,
SECURITY_MASK ,
CHECKOUT_USER )
SELECT
p_new_rule_id,
PRIMARY_OPT_ID,
SECONDARY_OPT_ID,
MARK_CHAR,
SECONDARY_FEAT_EXPL_ID,
SECONDARY_FEATURE_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_DES_CHART_CELLS
WHERE rule_id=p_old_rule_id AND deleted_flag=NO_FLAG;
INSERT INTO CZ_DES_CHART_FEATURES
(RULE_ID,
FEATURE_ID,
FEATURE_TYPE ,
MODEL_REF_EXPL_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER )
SELECT
p_new_rule_id,
FEATURE_ID,
FEATURE_TYPE ,
MODEL_REF_EXPL_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER
FROM CZ_DES_CHART_FEATURES
WHERE rule_id=p_old_rule_id AND deleted_flag=NO_FLAG;
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_RULE_FOLDERS
WHERE rule_folder_id=p_rule_id AND deleted_flag=NO_FLAG;
SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_FUNC_COMP_SPECS
WHERE func_comp_id=p_rule_id AND deleted_flag=NO_FLAG;
SELECT grid_id,devl_project_id,rule_folder_id,
antecedent_id,consequent_id,amount_id
INTO var_grid_id,NEW_PROJECT_ID,var_folder_id,
var_antecedent_id,var_consequent_id,var_amount_id
FROM CZ_RULES
WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG;
FOR i IN (SELECT * FROM CZ_GRID_DEFS
WHERE grid_id=var_grid_id AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_grid_id,'CZ_GRID_DEFS_S');
INSERT INTO CZ_GRID_DEFS(
GRID_ID,
DEVL_PROJECT_ID,
NAME,
DESC_TEXT,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER)
VALUES( new_grid_id,
i.DEVL_PROJECT_ID,
i.NAME,
i.DESC_TEXT,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER);
FOR i IN (SELECT * FROM CZ_RULES
WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
LOOP
get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
SELECT NVL(MAX(SEQ_NBR),0)+1 INTO new_SEQ_NBR FROM CZ_RULES
WHERE rule_folder_id=p_rule_folder_id AND deleted_flag=NO_FLAG;
INSERT INTO CZ_RULES(
RULE_ID,
SUB_CONS_ID,
REASON_ID,
AMOUNT_ID,
GRID_ID,
RULE_FOLDER_ID,
DEVL_PROJECT_ID,
INVALID_FLAG,
DESC_TEXT,
NAME,
ANTECEDENT_ID,
CONSEQUENT_ID,
RULE_TYPE,
EXPR_RULE_TYPE,
COMPONENT_ID,
REASON_TYPE,
DISABLED_FLAG,
ORIG_SYS_REF,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
EFFECTIVITY_SET_ID,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVE_USAGE_MASK,
SEQ_NBR,
RULE_FOLDER_TYPE,
UNSATISFIED_MSG_ID,
UNSATISFIED_MSG_SOURCE,
SIGNATURE_ID,
TEMPLATE_PRIMITIVE_FLAG,
PRESENTATION_FLAG,
TEMPLATE_TOKEN,
RULE_TEXT,
NOTES,
CLASS_NAME,
INSTANTIATION_SCOPE,
MODEL_REF_EXPL_ID,
MUTABLE_FLAG,
SEEDED_FLAG)
VALUES(
new_rule_id,
i.SUB_CONS_ID,
new_reason_id,
i.AMOUNT_ID,
new_grid_id,
new_RULE_FOLDER_ID,
i.DEVL_PROJECT_ID,
i.INVALID_FLAG,
i.DESC_TEXT,
i.NAME||'-'||TO_CHAR(new_rule_id),
i.ANTECEDENT_ID,
i.CONSEQUENT_ID,
i.RULE_TYPE,
i.EXPR_RULE_TYPE,
i.COMPONENT_ID,
i.REASON_TYPE,
i.DISABLED_FLAG,
i.ORIG_SYS_REF,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
new_EFFECTIVITY_SET_ID,
new_EFFECTIVE_FROM,
new_EFFECTIVE_UNTIL,
i.EFFECTIVE_USAGE_MASK,
new_SEQ_NBR,
i.RULE_FOLDER_TYPE,
new_msg_id,
i.UNSATISFIED_MSG_SOURCE,
i.SIGNATURE_ID,
i.TEMPLATE_PRIMITIVE_FLAG,
i.PRESENTATION_FLAG,
i.TEMPLATE_TOKEN,
i.RULE_TEXT,
i.NOTES,
i.CLASS_NAME,
i.INSTANTIATION_SCOPE,
i.MODEL_REF_EXPL_ID,
i.MUTABLE_FLAG,
i.SEEDED_FLAG);
FOR i IN (SELECT * FROM CZ_COMBO_FEATURES
WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
LOOP
IF i.grid_col_id IS NOT NULL THEN
new_grid_col_id:=FlowId_GRID_COL(i.grid_col_id);
INSERT INTO CZ_COMBO_FEATURES
(FEATURE_ID,
GRID_COL_ID,
RULE_ID,
COL_TYPE,
MINIMUM,
MAXIMUM,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
MODEL_REF_EXPL_ID)
VALUES(i.FEATURE_ID,
new_grid_col_id,
new_rule_id,
i.COL_TYPE,
i.MINIMUM,
i.MAXIMUM,
i.DELETED_FLAG,
i.SECURITY_MASK,
i.CHECKOUT_USER,
i.MODEL_REF_EXPL_ID);
FOR i IN(SELECT * FROM CZ_DES_CHART_COLUMNS WHERE rule_id IN
(SELECT rule_id FROM CZ_RULES WHERE devl_project_id=OLD_PROJECT_ID
AND deleted_flag=NO_FLAG) AND option_id IN
(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=OLD_PROJECT_ID
AND deleted_flag=NO_FLAG))
LOOP
BEGIN
BEGIN
new_rule_id:=FlowId_Rule(i.rule_id);
INSERT INTO CZ_DES_CHART_COLUMNS
(RULE_ID,
OPTION_ID,
COLUMN_WIDTH,
FEATURE_ID,
MODEL_REF_EXPL_ID)
SELECT
new_rule_id,
new_option_id,
i.COLUMN_WIDTH,
new_feature_id,
new_model_ref_expl_id
FROM CZ_DES_CHART_COLUMNS
WHERE rule_id=i.rule_id AND option_id=i.option_id;
SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;
INSERT INTO CZ_RULE_FOLDERS
(RULE_FOLDER_ID,
FOLDER_TYPE,
NAME,
DESC_TEXT,
PARENT_RULE_FOLDER_ID,
TREE_SEQ,
DEVL_PROJECT_ID,
PERSISTENT_RULE_FOLDER_ID,
EFFECTIVE_USAGE_MASK,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVITY_SET_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
OBJECT_TYPE,
DISABLED_FLAG,
ORIG_SYS_REF)
SELECT p_new_rule_seq_id,
FOLDER_TYPE,
NAME||'-'||TO_CHAR(p_new_rule_seq_id),
DESC_TEXT,
PARENT_RULE_FOLDER_ID,
TREE_SEQ,
DEVL_PROJECT_ID,
PERSISTENT_RULE_FOLDER_ID,
EFFECTIVE_USAGE_MASK,
EFFECTIVE_FROM,
EFFECTIVE_UNTIL,
EFFECTIVITY_SET_ID,
DELETED_FLAG,
SECURITY_MASK,
CHECKOUT_USER,
OBJECT_TYPE,
DISABLED_FLAG,
ORIG_SYS_REF
FROM CZ_RULE_FOLDERS WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG;
FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
LOOP
Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
WHERE rule_id=new_rule_id;
FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)
LOOP
Copy_RULES_subschema(i.rule_id,new_rule_id, '0', NULL, '0');
UPDATE CZ_RULES SET rule_folder_id=p_new_rule_seq_id
WHERE rule_id=new_rule_id;
SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;