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.BIS_BUCKET_PVT dependencies on BIS_BUCKET_TL

Line 10: RANGE_NAME BIS_BUCKET_TL.range1_name%TYPE

6: c_bucket_att CONSTANT VARCHAR2(20) := 'BUCKET_MEASURE';
7:
8: --Record type added for validation
9: TYPE BIS_BUCKET_RANGES_REC IS RECORD(
10: RANGE_NAME BIS_BUCKET_TL.range1_name%TYPE
11: ,RANGE_LOW BIS_BUCKET.range1_low%TYPE
12: ,RANGE_HIGH BIS_BUCKET.range1_high%TYPE
13: );
14:

Line 24: ,p_name IN BIS_BUCKET_TL.name%TYPE

20: --It should take all the data passed to it and builds a record of type BIS_BUCKET_REC_TYPE
21: --and call BIS_BUCKET_PVT. CREATE_BIS_BUCKET with it.
22: PROCEDURE CREATE_BIS_BUCKET_WRAPPER (
23: p_short_name IN BIS_BUCKET.short_name%TYPE
24: ,p_name IN BIS_BUCKET_TL.name%TYPE
25: ,p_type IN BIS_BUCKET.type%TYPE
26: ,p_application_id IN BIS_BUCKET.application_id%TYPE
27: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
28: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE

Line 27: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

23: p_short_name IN BIS_BUCKET.short_name%TYPE
24: ,p_name IN BIS_BUCKET_TL.name%TYPE
25: ,p_type IN BIS_BUCKET.type%TYPE
26: ,p_application_id IN BIS_BUCKET.application_id%TYPE
27: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
28: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
29: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
30: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
31: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE

Line 30: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE

26: ,p_application_id IN BIS_BUCKET.application_id%TYPE
27: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
28: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
29: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
30: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
31: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
32: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
33: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
34: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE

Line 33: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE

29: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
30: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
31: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
32: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
33: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
34: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
35: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
36: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
37: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE

Line 36: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE

32: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
33: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
34: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
35: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
36: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
37: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
38: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
39: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
40: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE

Line 39: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE

35: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
36: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
37: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
38: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
39: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
40: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
41: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
42: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
43: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE

Line 42: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE

38: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
39: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
40: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
41: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
42: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
43: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
44: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
45: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
46: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE

Line 45: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE

41: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
42: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
43: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
44: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
45: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
46: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
47: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
48: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
49: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE

Line 48: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE

44: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
45: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
46: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
47: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
48: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
49: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
50: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
51: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
52: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE

Line 51: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE

47: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
48: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
49: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
50: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
51: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
52: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
53: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
54: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
55: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE

Line 54: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE

50: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
51: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
52: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
53: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
54: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
55: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
56: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
57: ,p_description IN BIS_BUCKET_TL.description%TYPE
58: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'

Line 57: ,p_description IN BIS_BUCKET_TL.description%TYPE

53: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
54: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
55: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
56: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
57: ,p_description IN BIS_BUCKET_TL.description%TYPE
58: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'
59: ,p_expandable IN BIS_BUCKET.expandable%TYPE := 'F'
60: ,p_discontinuous IN BIS_BUCKET.discontinuous%TYPE := 'F'
61: ,p_overlapping IN BIS_BUCKET.overlapping%TYPE := 'F'

Line 74: ,p_name IN BIS_BUCKET_TL.name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

70: --and call BIS_BUCKET_PVT. UPDATE_BIS_BUCKET with it.
71: PROCEDURE UPDATE_BIS_BUCKET_WRAPPER (
72: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
73: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
74: ,p_name IN BIS_BUCKET_TL.name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
75: ,p_type IN BIS_BUCKET.type%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
76: ,p_application_id IN BIS_BUCKET.application_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
77: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 77: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

73: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
74: ,p_name IN BIS_BUCKET_TL.name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
75: ,p_type IN BIS_BUCKET.type%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
76: ,p_application_id IN BIS_BUCKET.application_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
77: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
79: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
80: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 80: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

76: ,p_application_id IN BIS_BUCKET.application_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
77: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
79: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
80: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
84: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 83: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

79: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
80: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
84: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
87: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 86: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

82: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
84: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
87: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
89: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
90: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 89: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

85: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
87: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
89: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
90: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
91: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
92: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 92: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

88: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
89: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
90: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
91: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
92: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
94: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
95: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
96: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 95: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

91: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
92: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
94: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
95: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
96: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
97: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
98: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
99: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 98: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

94: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
95: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
96: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
97: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
98: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
99: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
100: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
101: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
102: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 101: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

97: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
98: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
99: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
100: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
101: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
102: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
103: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
104: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
105: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

Line 104: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

100: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
101: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
102: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
103: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
104: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
105: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
106: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
107: ,p_description IN BIS_BUCKET_TL.description%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
108: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'

Line 107: ,p_description IN BIS_BUCKET_TL.description%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

103: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
104: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
105: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
106: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
107: ,p_description IN BIS_BUCKET_TL.description%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
108: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'
109: ,p_expandable IN BIS_BUCKET.expandable%TYPE := 'F'
110: ,p_discontinuous IN BIS_BUCKET.discontinuous%TYPE := 'F'
111: ,p_overlapping IN BIS_BUCKET.overlapping%TYPE := 'F'

Line 177: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE

173: --it should populates the out parameters
174: PROCEDURE RETRIEVE_BIS_BUCKET_WRAPPER (
175: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
176: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
177: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
178: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
179: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
180: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
181: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE

Line 180: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE

176: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
177: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
178: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
179: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
180: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
181: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE
182: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
183: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
184: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE

Line 183: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE

179: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
180: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
181: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE
182: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
183: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
184: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE
185: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
186: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
187: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE

Line 186: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE

182: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
183: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
184: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE
185: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
186: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
187: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE
188: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
189: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
190: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE

Line 189: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE

185: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
186: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
187: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE
188: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
189: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
190: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE
191: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
192: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
193: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE

Line 192: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE

188: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
189: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
190: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE
191: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
192: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
193: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE
194: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
195: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
196: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE

Line 195: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE

191: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
192: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
193: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE
194: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
195: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
196: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE
197: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
198: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
199: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE

Line 198: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE

194: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
195: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
196: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE
197: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
198: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
199: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE
200: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
201: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
202: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE

Line 201: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE

197: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
198: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
199: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE
200: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
201: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
202: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE
203: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
204: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
205: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE

Line 204: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE

200: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
201: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
202: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE
203: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
204: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
205: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE
206: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
207: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
208: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE

Line 207: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE

203: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
204: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
205: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE
206: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
207: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
208: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE
209: ,x_range10_high OUT NOCOPY BIS_BUCKET.range10_high%TYPE
210: ,x_description OUT NOCOPY BIS_BUCKET_TL.description%TYPE
211: ,x_updatable OUT NOCOPY BIS_BUCKET.updatable%TYPE

Line 210: ,x_description OUT NOCOPY BIS_BUCKET_TL.description%TYPE

206: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
207: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
208: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE
209: ,x_range10_high OUT NOCOPY BIS_BUCKET.range10_high%TYPE
210: ,x_description OUT NOCOPY BIS_BUCKET_TL.description%TYPE
211: ,x_updatable OUT NOCOPY BIS_BUCKET.updatable%TYPE
212: ,x_expandable OUT NOCOPY BIS_BUCKET.expandable%TYPE
213: ,x_discontinuous OUT NOCOPY BIS_BUCKET.discontinuous%TYPE
214: ,x_overlapping OUT NOCOPY BIS_BUCKET.overlapping%TYPE

Line 229: --into the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE

225: ,x_error_msg OUT NOCOPY VARCHAR2
226: );
227:
228: --This API should generate the bucket_id in sequence and insert the data passed to it,
229: --into the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE
230: PROCEDURE CREATE_BIS_BUCKET (
231: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 237: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE

233: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
234: );
235:
236:
237: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE
238: --using the short name or the bucket id as the where clause value
239: PROCEDURE UPDATE_BIS_BUCKET (
240: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
241: ,x_return_status OUT NOCOPY VARCHAR2

Line 246: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL

242: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
243: );
244:
245:
246: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL
247: --using the short name or the bucket id as the where clause value
248: PROCEDURE DELETE_BIS_BUCKET (
249: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
250: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 339: ,p_name IN BIS_BUCKET_TL.name%TYPE

335: );
336:
337: PROCEDURE VALIDATE_BUCKET_WRAPPER (
338: p_short_name IN BIS_BUCKET.short_name%TYPE
339: ,p_name IN BIS_BUCKET_TL.name%TYPE
340: ,p_type IN BIS_BUCKET.type%TYPE
341: ,p_application_id IN BIS_BUCKET.application_id%TYPE
342: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
343: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE

Line 342: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

338: p_short_name IN BIS_BUCKET.short_name%TYPE
339: ,p_name IN BIS_BUCKET_TL.name%TYPE
340: ,p_type IN BIS_BUCKET.type%TYPE
341: ,p_application_id IN BIS_BUCKET.application_id%TYPE
342: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
343: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
344: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
345: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
346: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE

Line 345: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE

341: ,p_application_id IN BIS_BUCKET.application_id%TYPE
342: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
343: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
344: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
345: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
346: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
347: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
348: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
349: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE

Line 348: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE

344: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
345: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
346: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
347: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
348: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
349: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
350: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
351: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
352: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE

Line 351: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE

347: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
348: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
349: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
350: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
351: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
352: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
353: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
354: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
355: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE

Line 354: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE

350: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
351: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
352: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
353: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
354: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
355: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
356: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
357: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
358: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE

Line 357: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE

353: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
354: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
355: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
356: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
357: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
358: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
359: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
360: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
361: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE

Line 360: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE

356: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
357: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
358: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
359: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
360: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
361: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
362: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
363: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
364: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE

Line 363: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE

359: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
360: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
361: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
362: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
363: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
364: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
365: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
366: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
367: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE

Line 366: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE

362: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
363: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
364: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
365: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
366: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
367: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
368: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
369: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
370: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE

Line 369: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE

365: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
366: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
367: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
368: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
369: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
370: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
371: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
372: ,p_description IN BIS_BUCKET_TL.description%TYPE
373: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'

Line 372: ,p_description IN BIS_BUCKET_TL.description%TYPE

368: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
369: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
370: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
371: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
372: ,p_description IN BIS_BUCKET_TL.description%TYPE
373: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'
374: ,p_expandable IN BIS_BUCKET.expandable%TYPE := 'F'
375: ,p_discontinuous IN BIS_BUCKET.discontinuous%TYPE := 'F'
376: ,p_overlapping IN BIS_BUCKET.overlapping%TYPE := 'F'