APPS.CZ_RULE_IMPORT dependencies on CZ_RULE_FOLDERS

Line 76: ' FROM cz_rule_folders ' ||

72: ' AND e.model_id = r.object_id';
73:
74: getRootFolderId VARCHAR2(4000) :=
75: 'SELECT rule_folder_id ' ||
76: ' FROM cz_rule_folders ' ||
77: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
78: ' AND object_type = ''' || CZRI_TYPE_RULE_FOLDER || ''' ' ||
79: ' AND devl_project_id = :1 ' ||
80: ' AND parent_rule_folder_id IS NULL';

Line 84: ' FROM cz_rule_folders ' ||

80: ' AND parent_rule_folder_id IS NULL';
81:
82: validateFolder VARCHAR2(4000) :=
83: 'SELECT NULL ' ||
84: ' FROM cz_rule_folders ' ||
85: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
86: ' AND object_type = ''' || CZRI_TYPE_RULE_FOLDER || ''' ' ||
87: ' AND devl_project_id = :1 ' ||
88: ' AND rule_folder_id = :2';

Line 757: INSERT INTO cz_rule_folders

753: t_ui_page_element_id(i), t_rule_folder_type(i));
754: END LOOP;
755:
756: FORALL i IN 1..t_rule_folder_id.COUNT
757: INSERT INTO cz_rule_folders
758: (rule_folder_id, parent_rule_folder_id, devl_project_id, desc_text, name, object_type, folder_type,
759: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
760: effective_usage_mask, tree_seq, effective_from, effective_until, effectivity_set_id)
761: VALUES

Line 915: UPDATE cz_rule_folders SET

911: WHERE rule_id = t_rule_id(i);
912: END LOOP;
913:
914: FORALL i IN 1..t_rule_id.COUNT
915: UPDATE cz_rule_folders SET
916: parent_rule_folder_id = t_rule_folder_id(i),
917: desc_text = t_desc_text(i),
918: name = t_name(i),
919: folder_type = t_rule_folder_type(i),

Line 1033: INSERT INTO cz_rule_folders

1029: t_presentation_flag(i), t_template_token(i), t_rule_text(i), t_notes(i),
1030: t_class_name(i), t_instantiation_scope(i), t_mutable_flag(i), t_seeded_flag(i),
1031: t_ui_def_id(i), t_ui_page_id(i), t_ui_page_element_id(i), t_rule_folder_type(i));
1032:
1033: INSERT INTO cz_rule_folders
1034: (rule_folder_id, parent_rule_folder_id, devl_project_id, desc_text, name, object_type, folder_type,
1035: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1036: effective_usage_mask, tree_seq, effective_from, effective_until, effectivity_set_id)
1037: VALUES

Line 1120: UPDATE cz_rule_folders SET

1116: ui_page_element_id = t_ui_page_element_id(i),
1117: rule_folder_type = t_rule_folder_type(i)
1118: WHERE rule_id = t_rule_id(i);
1119:
1120: UPDATE cz_rule_folders SET
1121: parent_rule_folder_id = t_rule_folder_id(i),
1122: desc_text = t_desc_text(i),
1123: name = t_name(i),
1124: folder_type = t_rule_folder_type(i),