APPS.CZ_PS_COPY dependencies on CZ_RULE_FOLDERS

Line 66: Sequences(8).name:='CZ_RULE_FOLDERS_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';
70: Sequences(12).name:='CZ_UI_DEFS_S';

Line 1787: FOR i IN (SELECT rule_folder_id FROM CZ_RULE_FOLDERS

1783: new_child INTEGER;
1784:
1785: BEGIN
1786:
1787: FOR i IN (SELECT rule_folder_id FROM CZ_RULE_FOLDERS
1788: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1789: LOOP
1790: get_Next_Val(new_id,'CZ_RULE_FOLDERS_S');
1791: FlowId_RULE_FOLDER(i.rule_folder_id):=new_id;

Line 1790: get_Next_Val(new_id,'CZ_RULE_FOLDERS_S');

1786:
1787: FOR i IN (SELECT rule_folder_id FROM CZ_RULE_FOLDERS
1788: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1789: LOOP
1790: get_Next_Val(new_id,'CZ_RULE_FOLDERS_S');
1791: FlowId_RULE_FOLDER(i.rule_folder_id):=new_id;
1792: END LOOP;
1793:
1794: FOR i IN (SELECT * FROM CZ_RULE_FOLDERS

Line 1794: FOR i IN (SELECT * FROM CZ_RULE_FOLDERS

1790: get_Next_Val(new_id,'CZ_RULE_FOLDERS_S');
1791: FlowId_RULE_FOLDER(i.rule_folder_id):=new_id;
1792: END LOOP;
1793:
1794: FOR i IN (SELECT * FROM CZ_RULE_FOLDERS
1795: WHERE devl_project_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG)
1796: LOOP
1797: BEGIN
1798: IF i.parent_rule_folder_id IS NOT NULL THEN

Line 1805: INSERT INTO CZ_RULE_FOLDERS

1801: new_parent:=NULL;
1802: END IF;
1803: new_child:=FlowId_RULE_FOLDER(i.rule_folder_id);
1804:
1805: INSERT INTO CZ_RULE_FOLDERS
1806: (RULE_FOLDER_ID,
1807: NAME,
1808: DESC_TEXT,
1809: PARENT_RULE_FOLDER_ID,

Line 2745: SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_RULE_FOLDERS

2741:
2742: Initialize;
2743:
2744: IF p_Rules_Seq_Flag='1' THEN
2745: SELECT devl_project_id INTO OLD_PROJECT_ID FROM CZ_RULE_FOLDERS
2746: WHERE rule_folder_id=p_rule_id AND deleted_flag=NO_FLAG;
2747: NEW_PROJECT_ID:=OLD_PROJECT_ID;
2748: copy_RULE_SEQ(p_rule_id,p_out_new_rule_id);
2749: RAISE END_OPERATION;

Line 3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;

3085:
3086: /* Exception is raised for BUG No.4028599*/
3087: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3088:
3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;
3090: INSERT INTO CZ_RULE_FOLDERS
3091: (RULE_FOLDER_ID,
3092: FOLDER_TYPE,
3093: NAME,

Line 3090: INSERT INTO CZ_RULE_FOLDERS

3086: /* Exception is raised for BUG No.4028599*/
3087: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3088:
3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;
3090: INSERT INTO CZ_RULE_FOLDERS
3091: (RULE_FOLDER_ID,
3092: FOLDER_TYPE,
3093: NAME,
3094: DESC_TEXT,

Line 3127: FROM CZ_RULE_FOLDERS WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG;

3123: CHECKOUT_USER,
3124: OBJECT_TYPE,
3125: DISABLED_FLAG,
3126: ORIG_SYS_REF
3127: FROM CZ_RULE_FOLDERS WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG;
3128:
3129: PACK;
3130:
3131: FOR i IN ( SELECT rule_id FROM CZ_RULES WHERE rule_folder_id=p_rule_seq_id AND deleted_flag=NO_FLAG)