APPS.CZ_RULE_IMPORT dependencies on CZ_RULE_FOLDERS

Line 94: ' FROM cz_rule_folders ' ||

90: ' AND e.model_id = r.object_id';
91:
92: getRootFolderId VARCHAR2(4000) :=
93: 'SELECT rule_folder_id ' ||
94: ' FROM cz_rule_folders ' ||
95: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
96: ' AND object_type = ''' || CZRI_TYPE_RULE_FOLDER || ''' ' ||
97: ' AND devl_project_id = :1 ' ||
98: ' AND parent_rule_folder_id IS NULL';

Line 102: ' FROM cz_rule_folders ' ||

98: ' AND parent_rule_folder_id IS NULL';
99:
100: validateFolder VARCHAR2(4000) :=
101: 'SELECT NULL ' ||
102: ' FROM cz_rule_folders ' ||
103: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
104: ' AND object_type = ''' || CZRI_TYPE_RULE_FOLDER || ''' ' ||
105: ' AND devl_project_id = :1 ' ||
106: ' AND rule_folder_id = :2';

Line 663: FROM cz_rule_folders

659: END;
660: BEGIN
661: SELECT 1
662: INTO v_error_flag
663: FROM cz_rule_folders
664: WHERE deleted_flag = CZRI_FLAG_NOT_DELETED
665: AND devl_project_id = t_devl_project_id(i)
666: AND name = t_name(i)
667: AND rule_folder_id <> t_rule_id(i)

Line 1045: INSERT INTO cz_rule_folders

1041: t_rule_class(i), t_class_seq(i),t_config_engine_type(i),t_accumulator_flag(i),t_top_level_constraint_flag(i)); --Bug9467066
1042: END LOOP;
1043:
1044: FORALL i IN 1..t_rule_folder_id.COUNT
1045: INSERT INTO cz_rule_folders
1046: (rule_folder_id, parent_rule_folder_id, devl_project_id, desc_text, name, object_type, folder_type,
1047: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1048: effective_usage_mask, tree_seq, effective_from, effective_until, effectivity_set_id)
1049: VALUES

Line 1220: UPDATE cz_rule_folders SET

1216: WHERE rule_id = t_rule_id(i);
1217: END LOOP;
1218:
1219: FORALL i IN 1..t_rule_id.COUNT
1220: UPDATE cz_rule_folders SET
1221: parent_rule_folder_id = t_rule_folder_id(i),
1222: desc_text = t_desc_text(i),
1223: name = t_name(i),
1224: folder_type = t_rule_folder_type(i),

Line 1352: INSERT INTO cz_rule_folders

1348: t_presentation_flag(i), t_template_token(i), t_rule_text(i), t_notes(i),
1349: t_class_name(i), t_instantiation_scope(i), t_mutable_flag(i), t_seeded_flag(i),
1350: t_ui_def_id(i), t_ui_page_id(i), t_ui_page_element_id(i), t_rule_folder_type(i),
1351: t_rule_class(i), t_class_seq(i),t_config_engine_type(i),t_accumulator_flag(i), t_top_level_constraint_flag(i)); --Bug9467066
1352: INSERT INTO cz_rule_folders
1353: (rule_folder_id, parent_rule_folder_id, devl_project_id, desc_text, name, object_type, folder_type,
1354: disabled_flag, orig_sys_ref, deleted_flag, security_mask, checkout_user, last_update_login,
1355: effective_usage_mask, tree_seq, effective_from, effective_until, effectivity_set_id)
1356: VALUES

Line 1445: UPDATE cz_rule_folders SET

1441: accumulator_flag = t_accumulator_flag(i), --Bug9467066
1442: top_level_constraint_flag = t_top_level_constraint_flag(i) --Bug9467066
1443: WHERE rule_id = t_rule_id(i);
1444:
1445: UPDATE cz_rule_folders SET
1446: parent_rule_folder_id = t_rule_folder_id(i),
1447: desc_text = t_desc_text(i),
1448: name = t_name(i),
1449: folder_type = t_rule_folder_type(i),