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 835: 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)

831: V_CZ_RULES(v_cz_rule_count).seeded_flag:= '0';
832:
833: -- INSERTING into cz_rules -- rule folder entry
834:
835: 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)
836: VALUES(l_rule_id, 'Constraint-' || l_ps_node_name , p_devl_project_id, '1', '0', '0', '0000000000000000', l_rule_id, 'RUL', '0' , V_CZ_RULES(v_cz_rule_count).rule_folder_id );
837:
838: populate_cz_tables();
839:

Line 2034: l_rule_folderid cz_rule_folders.rule_folder_id%TYPE;

2030:
2031:
2032: --Note this procedure is called from model conversion concurrent program
2033: PROCEDURE convertModels(p_model_conversion_set_id IN NUMBER) AS
2034: l_rule_folderid cz_rule_folders.rule_folder_id%TYPE;
2035: l_msg VARCHAR2(2000);
2036: l_api_name constant VARCHAR2(30) := 'convertModels';
2037: l_run_id NUMBER;
2038: BEGIN