eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_ATTRIBUTE_RANGES_PKG dependencies on PQH_ATTRIBUTE_RANGES

Line 1: package pqh_ATTRIBUTE_RANGES_pkg AUTHID CURRENT_USER as

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

Line 18: attribute_range_id pqh_attribute_ranges.attribute_range_id%type,

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,

Line 19: attribute_id pqh_attribute_ranges.attribute_id%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,

Line 20: from_char pqh_attribute_ranges.from_char%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,

Line 21: to_char pqh_attribute_ranges.to_char%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,

Line 22: from_date pqh_attribute_ranges.from_date%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,

Line 23: to_date pqh_attribute_ranges.to_date%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));

Line 24: from_number pqh_attribute_ranges.from_number%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));
28:

Line 25: to_number pqh_attribute_ranges.to_number%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:
29:

Line 26: ovn pqh_attribute_ranges.object_version_number%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:
30: type att_ranges is table of att_ranges_rec index by binary_integer;

Line 37: from_char pqh_attribute_ranges.from_char%type,

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,

Line 38: to_char pqh_attribute_ranges.to_char%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);

Line 39: from_number pqh_attribute_ranges.from_number%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:

Line 40: to_number pqh_attribute_ranges.to_number%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:
44: type rule_attr_tab is table of rule_attr_rec index by binary_integer;

Line 41: from_date pqh_attribute_ranges.from_date%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;
45: --

Line 42: to_date pqh_attribute_ranges.to_date%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: --
46: -- used to fetch database values for validating ranges

Line 49: (routing_category_id pqh_attribute_ranges.routing_category_id%type,

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,

Line 50: range_name pqh_attribute_ranges.range_name%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,

Line 51: attribute_id pqh_attribute_ranges.attribute_id%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,

Line 52: from_char pqh_attribute_ranges.from_char%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,

Line 53: to_char pqh_attribute_ranges.to_char%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);

Line 54: from_number pqh_attribute_ranges.from_number%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:

Line 55: to_number pqh_attribute_ranges.to_number%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:
59: type other_ranges_tab is table of other_ranges_rec index by binary_integer;

Line 56: from_date pqh_attribute_ranges.from_date%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;
60: --

Line 57: to_date pqh_attribute_ranges.to_date%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: --
61: -- fetch attributes for the entered transaction category

Line 149: -- child records in pqh_attribute_ranges is unmarked

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);