APPS.CZ_MODEL_CONVERT dependencies on CZ_RULE_FOLDERS

Line 129: FROM cz_rule_folders

125: p_parent_rule_fldr cz_rules.rule_folder_id%TYPE;
126:
127: CURSOR c_rule_fld IS
128: SELECT rule_folder_id
129: FROM cz_rule_folders
130: WHERE deleted_flag ='0'
131: AND name = 'Rules Generated by Model Conversion'
132: AND devl_project_id = p_dev_project_id;
133: l_msg VARCHAR2(2000);

Line 145: select rule_folder_id into p_parent_rule_fldr from cz_rule_folders where devl_project_id=p_dev_project_id and deleted_flag='0' and parent_rule_folder_id is null;

141: --Create a rule folder with name "Rules Generated by Model Conversion" populate rulefolderID
142: -- INSERTING into
143:
144:
145: select rule_folder_id into p_parent_rule_fldr from cz_rule_folders where devl_project_id=p_dev_project_id and deleted_flag='0' and parent_rule_folder_id is null;
146:
147:
148: INSERT
149: INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)

Line 149: INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)

145: select rule_folder_id into p_parent_rule_fldr from cz_rule_folders where devl_project_id=p_dev_project_id and deleted_flag='0' and parent_rule_folder_id is null;
146:
147:
148: INSERT
149: INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)
150: VALUES(cz_rule_folders_s.nextval, 'Rules Generated by Model Conversion', p_dev_project_id, '1', '0', '0', '0000000000000000', cz_rule_folders_s.nextval, 'RFL', '0' , p_parent_rule_fldr)
151: RETURNING rule_folder_id INTO p_rule_folderid;
152:
153: END IF;

Line 150: VALUES(cz_rule_folders_s.nextval, 'Rules Generated by Model Conversion', p_dev_project_id, '1', '0', '0', '0000000000000000', cz_rule_folders_s.nextval, 'RFL', '0' , p_parent_rule_fldr)

146:
147:
148: INSERT
149: INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)
150: VALUES(cz_rule_folders_s.nextval, 'Rules Generated by Model Conversion', p_dev_project_id, '1', '0', '0', '0000000000000000', cz_rule_folders_s.nextval, 'RFL', '0' , p_parent_rule_fldr)
151: RETURNING rule_folder_id INTO p_rule_folderid;
152:
153: END IF;
154: RETURN p_rule_folderid;

Line 841: INSERT INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)

837: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
838:
839: -- INSERTING into cz_rules -- rule folder entry
840: -- Fixing BUG9176281 - Rule name for Default Rule
841: INSERT INTO cz_rule_folders(rule_folder_id, name, devl_project_id, tree_seq, deleted_flag, folder_type, effective_usage_mask, persistent_rule_folder_id, object_type, disabled_flag , parent_rule_folder_id)
842: VALUES(l_rule_id, V_CZ_RULES(v_cz_rule_count).name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
843:
844: --populate_cz_tables(); moved prior to inserting data to v_cz_rules
845:

Line 2061: l_rule_folderid cz_rule_folders.rule_folder_id%TYPE;

2057:
2058:
2059: --Note this procedure is called from model conversion concurrent program
2060: PROCEDURE convertModels(p_model_conversion_set_id IN NUMBER) AS
2061: l_rule_folderid cz_rule_folders.rule_folder_id%TYPE;
2062: l_msg VARCHAR2(2000);
2063: l_api_name constant VARCHAR2(30) := 'convertModels';
2064: l_run_id NUMBER;
2065: BEGIN