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.
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
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
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
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
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
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
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
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
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
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