[Home] [Help]
382: -- FROM_REGION_ID and TO_REGION_ID
383: -- If FROM_REGION_ID or TO_REGION_ID attribute doesn't exist in the table
384: -- convert the value to -1 for number comparision purpose
385: -- Note that this query joins with FTE_SEL_RULES table
386: -- to eliminate the junk data that exist in FTE_SEL_RULE_RESTRICTIONS table
387: -- but don't have the corresponding rule in FTE_SEL_RULES table
388:
389: CURSOR c_get_ranges(x_group_id NUMBER, x_attr_name VARCHAR2) IS
390: select nvl(fr.attribute_value_from_number, -1) from_region,
391: nvl(tr.attribute_value_from_number, -1) to_region,
392: attr.attribute_value_from_number, attr.attribute_value_to_number,
393: attr.attribute_value_from, attr.attribute_value_to,
394: attr.rule_attribute_id, attr.range_overlap_flag
395: from fte_sel_rule_restrictions attr, fte_sel_rule_restrictions fr,
396: fte_sel_rule_restrictions tr, fte_sel_rules rr
397: where attr.group_id = x_group_id and attr.attribute_name = x_attr_name
398: and fr.rule_id (+)= attr.rule_id
399: and fr.attribute_name (+)= 'FROM_REGION_ID'
392: attr.attribute_value_from_number, attr.attribute_value_to_number,
393: attr.attribute_value_from, attr.attribute_value_to,
394: attr.rule_attribute_id, attr.range_overlap_flag
395: from fte_sel_rule_restrictions attr, fte_sel_rule_restrictions fr,
396: fte_sel_rule_restrictions tr, fte_sel_rules rr
397: where attr.group_id = x_group_id and attr.attribute_name = x_attr_name
398: and fr.rule_id (+)= attr.rule_id
399: and fr.attribute_name (+)= 'FROM_REGION_ID'
400: and tr.rule_id (+)= attr.rule_id
452:
453: if (l_rule_attribute_id_tab.COUNT >= 1) then
454:
455: FORALL i IN 1..l_rule_attribute_id_tab.COUNT
456: UPDATE fte_sel_rule_restrictions
457: SET range_overlap_flag = l_overlap_flag_tab(i)
458: WHERE rule_attribute_id = l_rule_attribute_id_tab(i);
459: end if;
460: