APPS.BIS_BUCKET_PVT dependencies on BIS_BUCKET_CUSTOMIZATIONS

Line 17: TYPE RangeLabels IS VARRAY(20) OF BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE;

13: );
14:
15: TYPE BIS_BUCKET_RANGES_TBL IS TABLE OF BIS_BUCKET_RANGES_REC INDEX BY BINARY_INTEGER;
16:
17: TYPE RangeLabels IS VARRAY(20) OF BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE;
18:
19: --Called by Java API
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.

Line 119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE

115: );
116:
117: PROCEDURE UPDATE_CUST_BUCKET (
118: p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE

Line 120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE

116:
117: PROCEDURE UPDATE_CUST_BUCKET (
118: p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE

Line 121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE

117: PROCEDURE UPDATE_CUST_BUCKET (
118: p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE

Line 122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE

118: p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE

Line 123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE

119: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE

Line 124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE

120: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE

Line 125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE

121: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE

Line 126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE

122: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE

Line 127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE

123: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE

Line 128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE

124: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE

Line 129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE

125: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE

Line 130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE

126: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE

Line 131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE

127: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE

Line 132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE

128: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE

Line 133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE

129: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE

Line 134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE

130: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE

Line 135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE

131: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE

Line 136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE

132: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE

Line 137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE

133: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE

Line 138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE

134: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE

Line 139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE

135: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE

Line 140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE

136: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE

Line 141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE

137: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE

Line 142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE

138: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE

Line 143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE

139: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE

Line 144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE

140: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE

Line 145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE

141: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE

Line 146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE

142: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE

Line 147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE

143: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE

Line 148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE

144: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE

Line 149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE

145: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE

Line 150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE

146: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE

Line 151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE

147: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE

Line 152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE

148: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE

Line 153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE

149: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE

Line 154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE

150: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE

Line 155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE

151: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
159: , p_deleted_ranges IN VARCHAR2

Line 156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE

152: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
159: , p_deleted_ranges IN VARCHAR2
160: , p_new_ranges IN VARCHAR2

Line 157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE

153: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
159: , p_deleted_ranges IN VARCHAR2
160: , p_new_ranges IN VARCHAR2
161: , x_return_status OUT NOCOPY VARCHAR2

Line 158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE

154: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
155: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
156: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
157: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
158: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
159: , p_deleted_ranges IN VARCHAR2
160: , p_new_ranges IN VARCHAR2
161: , x_return_status OUT NOCOPY VARCHAR2
162: , x_msg_count OUT NOCOPY NUMBER