288:
289: PROCEDURE compare_ranges(p_attr_name IN VARCHAR2,
290: p_attr_from_number_tab IN FTE_ID_TAB_TYPE,
291: p_attr_to_number_tab IN FTE_ID_TAB_TYPE,
292: p_attr_from_char_tab IN FTE_NAME_TAB_TYPE,
293: p_attr_to_char_tab IN FTE_NAME_TAB_TYPE,
294: p_compare_start IN NUMBER,
295: p_compare_end IN NUMBER,
296: p_overlap_flag_tab IN OUT NOCOPY FTE_NAME_TAB_TYPE) is
289: PROCEDURE compare_ranges(p_attr_name IN VARCHAR2,
290: p_attr_from_number_tab IN FTE_ID_TAB_TYPE,
291: p_attr_to_number_tab IN FTE_ID_TAB_TYPE,
292: p_attr_from_char_tab IN FTE_NAME_TAB_TYPE,
293: p_attr_to_char_tab IN FTE_NAME_TAB_TYPE,
294: p_compare_start IN NUMBER,
295: p_compare_end IN NUMBER,
296: p_overlap_flag_tab IN OUT NOCOPY FTE_NAME_TAB_TYPE) is
297:
292: p_attr_from_char_tab IN FTE_NAME_TAB_TYPE,
293: p_attr_to_char_tab IN FTE_NAME_TAB_TYPE,
294: p_compare_start IN NUMBER,
295: p_compare_end IN NUMBER,
296: p_overlap_flag_tab IN OUT NOCOPY FTE_NAME_TAB_TYPE) is
297:
298: base_value_from VARCHAR2(30);
299: base_value_to VARCHAR2(30);
300: cmp_value_from VARCHAR2(30);
371: l_from_region_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
372: l_to_region_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
373: l_attr_from_number_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
374: l_attr_to_number_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
375: l_attr_from_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
376: l_attr_to_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
377: l_rule_attribute_id_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
378: l_overlap_flag_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
379:
372: l_to_region_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
373: l_attr_from_number_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
374: l_attr_to_number_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
375: l_attr_from_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
376: l_attr_to_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
377: l_rule_attribute_id_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
378: l_overlap_flag_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
379:
380:
374: l_attr_to_number_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
375: l_attr_from_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
376: l_attr_to_char_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
377: l_rule_attribute_id_tab FTE_ID_TAB_TYPE := FTE_ID_TAB_TYPE();
378: l_overlap_flag_tab FTE_NAME_TAB_TYPE := FTE_NAME_TAB_TYPE();
379:
380:
381: -- Cursor to grab the specified attribute values ordered by
382: -- FROM_REGION_ID and TO_REGION_ID