[Home] [Help]
243: p_msg_text => 'v_is_ruleset = '||v_is_rule_set);
244: END IF;
245:
246: -- If rule type is ruleset, flatten the ruleset into FEM_RULESET_PROCESS_DATA
247: -- then copy it to FEM_BR_ROOT_RULES_GT before cleaning it back up.
248: IF (v_is_rule_set = 'Y') THEN
249: -- Flatten the ruleset
250: FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT(
251: p_api_version => 1.0,
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: -- Move valid flattened rule versions from the
276: -- FEM_RULESET_PROCESS_DATA table to the FEM_BR_ROOT_RULES_GT table.
277: INSERT INTO fem_br_root_rules_gt(object_definition_id)
278: SELECT child_obj_def_id
279: FROM fem_ruleset_process_data
280: WHERE rule_set_obj_id = p_object_id;
273: END IF;
274:
275: -- Move valid flattened rule versions from the
276: -- FEM_RULESET_PROCESS_DATA table to the FEM_BR_ROOT_RULES_GT table.
277: INSERT INTO fem_br_root_rules_gt(object_definition_id)
278: SELECT child_obj_def_id
279: FROM fem_ruleset_process_data
280: WHERE rule_set_obj_id = p_object_id;
281:
340: x_Err_Code => v_err_code,
341: x_Err_Msg => v_msg_data);
342:
343: IF (v_err_code = 0) THEN
344: INSERT INTO fem_br_root_rules_gt(object_definition_id)
345: VALUES(v_obj_def_id);
346: ELSE
347: -- If the rule passed validation, this routine should never error.
348: -- If it does, raise unexp error.
2260: --
2261: -- Get all root rules to be checked for disabled members
2262: CURSOR c_root_rules IS
2263: SELECT object_definition_id
2264: FROM fem_br_root_rules_gt;
2265: --
2266: BEGIN
2267: --
2268: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: -- Find the set of root rules that needs to be checked for
2339: -- disabled dimension members and place them in FEM_BR_ROOT_RULES_GT.
2340: Find_Root_Rules(p_rule_type => p_rule_type,
2341: p_ledger_id => p_ledger_id,
2342: p_effective_date => l_effective_date,
2343: p_folder_id => p_folder_id,