[Home] [Help]
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';
74: Sequences(16).name:='CZ_MODEL_REF_EXPLS_S';
75:
76: FlowId_PS_NODE.DELETE;
77: FlowId_INTL_TEXT.DELETE;
216: (p_new_name IN VARCHAR2) IS
217:
218: i CZ_DEVL_PROJECTS%ROWTYPE;
219: var_name CZ_DEVL_PROJECTS.NAME%TYPE;
220: var_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
221:
222: BEGIN
223:
224: SELECT CZ_PS_NODES_S.NEXTVAL INTO NEW_PROJECT_ID FROM dual;
234: END IF;
235:
236: var_intl_text_id:=NULL;
237: IF i.intl_text_id IS NOT NULL THEN
238: get_Next_Val(var_intl_text_id,'CZ_INTL_TEXTS_S');
239: Copy_INTL_TEXT(i.intl_text_id,var_intl_text_id,NEW_PROJECT_ID,NULL);
240: END IF;
241:
242:
673: new_child:=NEW_PROJECT_ID;
674: new_intl_text_id:=NULL;
675: END IF;
676: IF i.intl_text_id IS NOT NULL THEN
677: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
678: Copy_INTL_TEXT(i.intl_text_id,new_intl_text_id,NEW_PROJECT_ID,NULL);
679: ELSE
680: new_intl_text_id:=NULL;
681: END IF;
1537: BEGIN
1538: new_parent:=FlowId_UI_NODE(i.parent_id);
1539: new_child:=FlowId_UI_NODE(i.ui_node_id);
1540:
1541: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
1542: Copy_INTL_TEXT(i.caption_id,new_intl_text_id,NEW_PROJECT_ID,new_ui_def_id);
1543:
1544: /* *** tool tips are not used anymore ***
1545: *get_Next_Val(new_tool_tip_id,'CZ_INTL_TEXTS_S');
1541: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
1542: Copy_INTL_TEXT(i.caption_id,new_intl_text_id,NEW_PROJECT_ID,new_ui_def_id);
1543:
1544: /* *** tool tips are not used anymore ***
1545: *get_Next_Val(new_tool_tip_id,'CZ_INTL_TEXTS_S');
1546: *get_Next_Val(new_tool_tip_id,'CZ_INTL_TEXTS_S');
1547: *Copy_INTL_TEXT(i.tool_tip_id,new_tool_tip_id);
1548: */
1549:
1542: Copy_INTL_TEXT(i.caption_id,new_intl_text_id,NEW_PROJECT_ID,new_ui_def_id);
1543:
1544: /* *** tool tips are not used anymore ***
1545: *get_Next_Val(new_tool_tip_id,'CZ_INTL_TEXTS_S');
1546: *get_Next_Val(new_tool_tip_id,'CZ_INTL_TEXTS_S');
1547: *Copy_INTL_TEXT(i.tool_tip_id,new_tool_tip_id);
1548: */
1549:
1550: IF i.ps_node_id IS NOT NULL THEN
1880: get_Next_Val(new_id,'CZ_RULES_S');
1881: FlowId_RULE(i.rule_id):=new_id;
1882:
1883: IF i.reason_id IS NOT NULL THEN
1884: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
1885: new_reason_id:=new_intl_text_id;
1886: Copy_INTL_TEXT(i.reason_id,new_reason_id,NEW_PROJECT_ID,NULL);
1887: ELSE
1888: new_reason_id:=NULL;
1888: new_reason_id:=NULL;
1889: END IF;
1890:
1891: IF i.unsatisfied_msg_id IS NOT NULL THEN
1892: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
1893: new_msg_id:=new_intl_text_id;
1894: Copy_INTL_TEXT(i.unsatisfied_msg_id,new_msg_id,NEW_PROJECT_ID,NULL);
1895: ELSE
1896: new_msg_id:=i.unsatisfied_msg_id;
2302:
2303: new_child:=FlowId_PS_NODE(i.ps_node_id);
2304:
2305: IF i.intl_text_id IS NOT NULL THEN
2306: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
2307: Copy_INTL_TEXT(i.intl_text_id,new_intl_text_id,NEW_PROJECT_ID,NULL);
2308: ELSE
2309: new_intl_text_id:=NULL;
2310: END IF;
2809: FOR i IN (SELECT * FROM CZ_RULES
2810: WHERE rule_id=p_rule_id AND deleted_flag=NO_FLAG)
2811: LOOP
2812:
2813: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
2814: new_reason_id:=new_intl_text_id;
2815: Copy_INTL_TEXT(i.reason_id,new_reason_id,NEW_PROJECT_ID,NULL);
2816:
2817: IF i.unsatisfied_msg_id IS NOT NULL THEN
2814: new_reason_id:=new_intl_text_id;
2815: Copy_INTL_TEXT(i.reason_id,new_reason_id,NEW_PROJECT_ID,NULL);
2816:
2817: IF i.unsatisfied_msg_id IS NOT NULL THEN
2818: get_Next_Val(new_intl_text_id,'CZ_INTL_TEXTS_S');
2819: new_msg_id:=new_intl_text_id;
2820: Copy_INTL_TEXT(i.unsatisfied_msg_id,new_msg_id,NEW_PROJECT_ID,NULL);
2821: ELSE
2822: new_msg_id:=i.unsatisfied_msg_id;