1: package pqh_ATTRIBUTE_RANGES_pkg AUTHID CURRENT_USER as
2: /* $Header: pqrngchk.pkh 115.12 2002/12/12 22:47:38 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Record
14:
15: type att_tab is table of att_rec index by binary_integer;
16:
17: type att_ranges_rec is record(
18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
15: type att_tab is table of att_rec index by binary_integer;
16:
17: type att_ranges_rec is record(
18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
16:
17: type att_ranges_rec is record(
18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
17: type att_ranges_rec is record(
18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
26: ovn pqh_attribute_ranges.object_version_number%type,
19: attribute_id pqh_attribute_ranges.attribute_id%type,
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
26: ovn pqh_attribute_ranges.object_version_number%type,
27: operation varchar2(1));
20: from_char pqh_attribute_ranges.from_char%type,
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
26: ovn pqh_attribute_ranges.object_version_number%type,
27: operation varchar2(1));
28:
21: to_char pqh_attribute_ranges.to_char%type,
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
26: ovn pqh_attribute_ranges.object_version_number%type,
27: operation varchar2(1));
28:
29:
22: from_date pqh_attribute_ranges.from_date%type,
23: to_date pqh_attribute_ranges.to_date%type,
24: from_number pqh_attribute_ranges.from_number%type,
25: to_number pqh_attribute_ranges.to_number%type,
26: ovn pqh_attribute_ranges.object_version_number%type,
27: operation varchar2(1));
28:
29:
30: type att_ranges is table of att_ranges_rec index by binary_integer;
33: --
34: type rule_attr_rec is record
35: (attribute_id pqh_attributes.attribute_id%type,
36: datatype pqh_attributes.column_type%type,
37: from_char pqh_attribute_ranges.from_char%type,
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
34: type rule_attr_rec is record
35: (attribute_id pqh_attributes.attribute_id%type,
36: datatype pqh_attributes.column_type%type,
37: from_char pqh_attribute_ranges.from_char%type,
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
42: to_date pqh_attribute_ranges.to_date%type);
35: (attribute_id pqh_attributes.attribute_id%type,
36: datatype pqh_attributes.column_type%type,
37: from_char pqh_attribute_ranges.from_char%type,
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
42: to_date pqh_attribute_ranges.to_date%type);
43:
36: datatype pqh_attributes.column_type%type,
37: from_char pqh_attribute_ranges.from_char%type,
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
42: to_date pqh_attribute_ranges.to_date%type);
43:
44: type rule_attr_tab is table of rule_attr_rec index by binary_integer;
37: from_char pqh_attribute_ranges.from_char%type,
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
42: to_date pqh_attribute_ranges.to_date%type);
43:
44: type rule_attr_tab is table of rule_attr_rec index by binary_integer;
45: --
38: to_char pqh_attribute_ranges.to_char%type,
39: from_number pqh_attribute_ranges.from_number%type,
40: to_number pqh_attribute_ranges.to_number%type,
41: from_date pqh_attribute_ranges.from_date%type,
42: to_date pqh_attribute_ranges.to_date%type);
43:
44: type rule_attr_tab is table of rule_attr_rec index by binary_integer;
45: --
46: -- used to fetch database values for validating ranges
45: --
46: -- used to fetch database values for validating ranges
47: --
48: type other_ranges_rec is record
49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
46: -- used to fetch database values for validating ranges
47: --
48: type other_ranges_rec is record
49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
47: --
48: type other_ranges_rec is record
49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
48: type other_ranges_rec is record
49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
57: to_date pqh_attribute_ranges.to_date%type);
50: range_name pqh_attribute_ranges.range_name%type,
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
57: to_date pqh_attribute_ranges.to_date%type);
58:
51: attribute_id pqh_attribute_ranges.attribute_id%type,
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
57: to_date pqh_attribute_ranges.to_date%type);
58:
59: type other_ranges_tab is table of other_ranges_rec index by binary_integer;
52: from_char pqh_attribute_ranges.from_char%type,
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
57: to_date pqh_attribute_ranges.to_date%type);
58:
59: type other_ranges_tab is table of other_ranges_rec index by binary_integer;
60: --
53: to_char pqh_attribute_ranges.to_char%type,
54: from_number pqh_attribute_ranges.from_number%type,
55: to_number pqh_attribute_ranges.to_number%type,
56: from_date pqh_attribute_ranges.from_date%type,
57: to_date pqh_attribute_ranges.to_date%type);
58:
59: type other_ranges_tab is table of other_ranges_rec index by binary_integer;
60: --
61: -- fetch attributes for the entered transaction category
145: del_attr_ranges_table in out nocopy att_ranges,
146: p_no_attributes in number);
147: --
148: -- Procedure to raise error when a list / member identifier with
149: -- child records in pqh_attribute_ranges is unmarked
150: --
151: Procedure Delete_attribute_ranges(p_attribute_id IN number,
152: p_delete_attr_ranges_flag IN varchar2,
153: p_primary_flag IN varchar2);