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 27: ,p_name IN BIS_BUCKET_TL.name%TYPE

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

Line 30: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

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

Line 33: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE

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

Line 36: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE

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

Line 39: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE

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

Line 42: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE

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

Line 45: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE

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

Line 48: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE

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

Line 51: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE

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

Line 54: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE

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

Line 57: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE

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

Line 60: ,p_description IN BIS_BUCKET_TL.description%TYPE

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

Line 152: ,p_name IN BIS_BUCKET_TL.name%TYPE

148: --and call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET with it.
149: PROCEDURE UPDATE_BIS_BUCKET_WRAPPER (
150: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE
151: ,p_short_name IN BIS_BUCKET.short_name%TYPE
152: ,p_name IN BIS_BUCKET_TL.name%TYPE
153: ,p_type IN BIS_BUCKET.type%TYPE
154: ,p_application_id IN BIS_BUCKET.application_id%TYPE
155: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
156: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE

Line 155: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

151: ,p_short_name IN BIS_BUCKET.short_name%TYPE
152: ,p_name IN BIS_BUCKET_TL.name%TYPE
153: ,p_type IN BIS_BUCKET.type%TYPE
154: ,p_application_id IN BIS_BUCKET.application_id%TYPE
155: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
156: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
157: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
158: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
159: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE

Line 158: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE

154: ,p_application_id IN BIS_BUCKET.application_id%TYPE
155: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
156: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
157: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
158: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
159: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
160: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
161: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
162: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE

Line 161: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE

157: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
158: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
159: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
160: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
161: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
162: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
163: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
164: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
165: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE

Line 164: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE

160: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
161: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
162: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
163: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
164: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
165: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
166: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
167: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
168: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE

Line 167: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE

163: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
164: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
165: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
166: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
167: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
168: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
169: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
170: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
171: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE

Line 170: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE

166: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
167: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
168: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
169: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
170: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
171: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
172: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
173: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
174: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE

Line 173: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE

169: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
170: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
171: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
172: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
173: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
174: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
175: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
176: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
177: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE

Line 176: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE

172: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
173: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
174: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
175: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
176: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
177: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
178: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
179: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
180: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE

Line 179: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE

175: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
176: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
177: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
178: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
179: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
180: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
181: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
182: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
183: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE

Line 182: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE

178: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
179: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
180: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
181: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
182: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
183: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
184: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
185: ,p_description IN BIS_BUCKET_TL.description%TYPE
186: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'

Line 185: ,p_description IN BIS_BUCKET_TL.description%TYPE

181: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
182: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
183: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
184: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
185: ,p_description IN BIS_BUCKET_TL.description%TYPE
186: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'
187: ,p_expandable IN BIS_BUCKET.expandable%TYPE := 'F'
188: ,p_discontinuous IN BIS_BUCKET.discontinuous%TYPE := 'F'
189: ,p_overlapping IN BIS_BUCKET.overlapping%TYPE := 'F'

Line 623: FROM bis_bucket_tl

619: range7_name,
620: range8_name,
621: range9_name,
622: range10_name
623: FROM bis_bucket_tl
624: WHERE bucket_id = p_bucket_id
625: AND language = p_lang;
626: l_base_bucket_tl_rec c_base_bucket_tl%ROWTYPE;
627:

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

728: --it should populates the out parameters
729: PROCEDURE RETRIEVE_BIS_BUCKET_WRAPPER (
730: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
731: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
732: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
733: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
734: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
735: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
736: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE

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

731: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
732: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
733: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
734: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
735: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
736: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE
737: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
738: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
739: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE

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

734: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE
735: ,x_range1_name OUT NOCOPY BIS_BUCKET_TL.range1_name%TYPE
736: ,x_range1_low OUT NOCOPY BIS_BUCKET.range1_low%TYPE
737: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
738: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
739: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE
740: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
741: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
742: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE

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

737: ,x_range1_high OUT NOCOPY BIS_BUCKET.range1_high%TYPE
738: ,x_range2_name OUT NOCOPY BIS_BUCKET_TL.range2_name%TYPE
739: ,x_range2_low OUT NOCOPY BIS_BUCKET.range2_low%TYPE
740: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
741: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
742: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE
743: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
744: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
745: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE

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

740: ,x_range2_high OUT NOCOPY BIS_BUCKET.range2_high%TYPE
741: ,x_range3_name OUT NOCOPY BIS_BUCKET_TL.range3_name%TYPE
742: ,x_range3_low OUT NOCOPY BIS_BUCKET.range3_low%TYPE
743: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
744: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
745: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE
746: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
747: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
748: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE

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

743: ,x_range3_high OUT NOCOPY BIS_BUCKET.range3_high%TYPE
744: ,x_range4_name OUT NOCOPY BIS_BUCKET_TL.range4_name%TYPE
745: ,x_range4_low OUT NOCOPY BIS_BUCKET.range4_low%TYPE
746: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
747: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
748: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE
749: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
750: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
751: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE

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

746: ,x_range4_high OUT NOCOPY BIS_BUCKET.range4_high%TYPE
747: ,x_range5_name OUT NOCOPY BIS_BUCKET_TL.range5_name%TYPE
748: ,x_range5_low OUT NOCOPY BIS_BUCKET.range5_low%TYPE
749: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
750: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
751: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE
752: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
753: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
754: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE

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

749: ,x_range5_high OUT NOCOPY BIS_BUCKET.range5_high%TYPE
750: ,x_range6_name OUT NOCOPY BIS_BUCKET_TL.range6_name%TYPE
751: ,x_range6_low OUT NOCOPY BIS_BUCKET.range6_low%TYPE
752: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
753: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
754: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE
755: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
756: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
757: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE

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

752: ,x_range6_high OUT NOCOPY BIS_BUCKET.range6_high%TYPE
753: ,x_range7_name OUT NOCOPY BIS_BUCKET_TL.range7_name%TYPE
754: ,x_range7_low OUT NOCOPY BIS_BUCKET.range7_low%TYPE
755: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
756: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
757: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE
758: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
759: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
760: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE

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

755: ,x_range7_high OUT NOCOPY BIS_BUCKET.range7_high%TYPE
756: ,x_range8_name OUT NOCOPY BIS_BUCKET_TL.range8_name%TYPE
757: ,x_range8_low OUT NOCOPY BIS_BUCKET.range8_low%TYPE
758: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
759: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
760: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE
761: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
762: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
763: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE

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

758: ,x_range8_high OUT NOCOPY BIS_BUCKET.range8_high%TYPE
759: ,x_range9_name OUT NOCOPY BIS_BUCKET_TL.range9_name%TYPE
760: ,x_range9_low OUT NOCOPY BIS_BUCKET.range9_low%TYPE
761: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
762: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
763: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE
764: ,x_range10_high OUT NOCOPY BIS_BUCKET.range10_high%TYPE
765: ,x_description OUT NOCOPY BIS_BUCKET_TL.description%TYPE
766: ,x_updatable OUT NOCOPY BIS_BUCKET.updatable%TYPE

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

761: ,x_range9_high OUT NOCOPY BIS_BUCKET.range9_high%TYPE
762: ,x_range10_name OUT NOCOPY BIS_BUCKET_TL.range10_name%TYPE
763: ,x_range10_low OUT NOCOPY BIS_BUCKET.range10_low%TYPE
764: ,x_range10_high OUT NOCOPY BIS_BUCKET.range10_high%TYPE
765: ,x_description OUT NOCOPY BIS_BUCKET_TL.description%TYPE
766: ,x_updatable OUT NOCOPY BIS_BUCKET.updatable%TYPE
767: ,x_expandable OUT NOCOPY BIS_BUCKET.expandable%TYPE
768: ,x_discontinuous OUT NOCOPY BIS_BUCKET.discontinuous%TYPE
769: ,x_overlapping OUT NOCOPY BIS_BUCKET.overlapping%TYPE

Line 890: --into the tables BIS_BUCKET, BIS_BUCKET_TL

886: END DELETE_BIS_BUCKET_WRAPPER;
887:
888:
889: --This API should generate the bucket_id in sequence and insert the data passed to it,
890: --into the tables BIS_BUCKET, BIS_BUCKET_TL
891: PROCEDURE CREATE_BIS_BUCKET (
892: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1016: INSERT into BIS_BUCKET_TL (

1012: l_user_id,
1013: l_login_id
1014: );
1015:
1016: INSERT into BIS_BUCKET_TL (
1017: BUCKET_ID,
1018: LANGUAGE,
1019: NAME,
1020: RANGE1_NAME,

Line 1065: FROM BIS_BUCKET_TL B

1061: FROM FND_LANGUAGES L
1062: WHERE L.INSTALLED_FLAG in ('I', 'B')
1063: AND NOT exists (
1064: SELECT NULL
1065: FROM BIS_BUCKET_TL B
1066: WHERE B.BUCKET_ID = l_bucket_id
1067: AND B.LANGUAGE = L.LANGUAGE_CODE
1068: );
1069:

Line 1209: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL

1205:
1206:
1207:
1208:
1209: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL
1210: --using the short name or the bucket id as the where clause value
1211: PROCEDURE UPDATE_BIS_BUCKET (
1212: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1213: ,x_return_status OUT NOCOPY VARCHAR2

Line 1344: UPDATE BIS_BUCKET_TL SET

1340: ,LAST_UPDATED_BY = l_user_id
1341: ,LAST_UPDATE_LOGIN = l_login_id
1342: WHERE SHORT_NAME = l_short_name;
1343:
1344: UPDATE BIS_BUCKET_TL SET
1345: NAME = l_bis_bucket_rec.name
1346: ,RANGE1_NAME = l_bis_bucket_rec.range1_name
1347: ,RANGE2_NAME = l_bis_bucket_rec.range2_name
1348: ,RANGE3_NAME = l_bis_bucket_rec.range3_name

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

1449:
1450: END UPDATE_BIS_BUCKET;
1451:
1452:
1453: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL
1454: --using the short name or the bucket id as the where clause value
1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (

Line 1490: DELETE from BIS_BUCKET_TL

1486:
1487: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1488: WHERE bucket_id = l_bucket_id;
1489:
1490: DELETE from BIS_BUCKET_TL
1491: WHERE bucket_id = l_bucket_id;
1492:
1493: DELETE from BIS_BUCKET
1494: WHERE short_name = p_short_name;

Line 1521: DELETE from BIS_BUCKET_TL

1517:
1518: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1519: WHERE bucket_id = p_bucket_id;
1520:
1521: DELETE from BIS_BUCKET_TL
1522: WHERE bucket_id = p_bucket_id;
1523:
1524: DELETE from BIS_BUCKET
1525: WHERE bucket_id = p_bucket_id;

Line 1779: UPDATE BIS_BUCKET_TL

1775: END IF;
1776:
1777: l_login_id := fnd_global.LOGIN_ID;
1778:
1779: UPDATE BIS_BUCKET_TL
1780: SET
1781: NAME = l_bis_bucket_rec.name
1782: ,RANGE1_NAME = l_bis_bucket_rec.range1_name
1783: ,RANGE2_NAME = l_bis_bucket_rec.range2_name

Line 2811: ,p_name IN BIS_BUCKET_TL.name%TYPE

2807: --=============================================================================
2808: --This is the java wrapper for bucket customization UI.
2809: PROCEDURE VALIDATE_BUCKET_WRAPPER (
2810: p_short_name IN BIS_BUCKET.short_name%TYPE
2811: ,p_name IN BIS_BUCKET_TL.name%TYPE
2812: ,p_type IN BIS_BUCKET.type%TYPE
2813: ,p_application_id IN BIS_BUCKET.application_id%TYPE
2814: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
2815: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE

Line 2814: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

2810: p_short_name IN BIS_BUCKET.short_name%TYPE
2811: ,p_name IN BIS_BUCKET_TL.name%TYPE
2812: ,p_type IN BIS_BUCKET.type%TYPE
2813: ,p_application_id IN BIS_BUCKET.application_id%TYPE
2814: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
2815: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
2816: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
2817: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
2818: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE

Line 2817: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE

2813: ,p_application_id IN BIS_BUCKET.application_id%TYPE
2814: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE
2815: ,p_range1_low IN BIS_BUCKET.range1_low%TYPE
2816: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
2817: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
2818: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
2819: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
2820: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
2821: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE

Line 2820: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE

2816: ,p_range1_high IN BIS_BUCKET.range1_high%TYPE
2817: ,p_range2_name IN BIS_BUCKET_TL.range2_name%TYPE
2818: ,p_range2_low IN BIS_BUCKET.range2_low%TYPE
2819: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
2820: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
2821: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
2822: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
2823: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
2824: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE

Line 2823: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE

2819: ,p_range2_high IN BIS_BUCKET.range2_high%TYPE
2820: ,p_range3_name IN BIS_BUCKET_TL.range3_name%TYPE
2821: ,p_range3_low IN BIS_BUCKET.range3_low%TYPE
2822: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
2823: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
2824: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
2825: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
2826: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
2827: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE

Line 2826: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE

2822: ,p_range3_high IN BIS_BUCKET.range3_high%TYPE
2823: ,p_range4_name IN BIS_BUCKET_TL.range4_name%TYPE
2824: ,p_range4_low IN BIS_BUCKET.range4_low%TYPE
2825: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
2826: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
2827: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
2828: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
2829: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
2830: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE

Line 2829: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE

2825: ,p_range4_high IN BIS_BUCKET.range4_high%TYPE
2826: ,p_range5_name IN BIS_BUCKET_TL.range5_name%TYPE
2827: ,p_range5_low IN BIS_BUCKET.range5_low%TYPE
2828: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
2829: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
2830: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
2831: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
2832: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
2833: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE

Line 2832: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE

2828: ,p_range5_high IN BIS_BUCKET.range5_high%TYPE
2829: ,p_range6_name IN BIS_BUCKET_TL.range6_name%TYPE
2830: ,p_range6_low IN BIS_BUCKET.range6_low%TYPE
2831: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
2832: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
2833: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
2834: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
2835: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
2836: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE

Line 2835: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE

2831: ,p_range6_high IN BIS_BUCKET.range6_high%TYPE
2832: ,p_range7_name IN BIS_BUCKET_TL.range7_name%TYPE
2833: ,p_range7_low IN BIS_BUCKET.range7_low%TYPE
2834: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
2835: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
2836: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
2837: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
2838: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
2839: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE

Line 2838: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE

2834: ,p_range7_high IN BIS_BUCKET.range7_high%TYPE
2835: ,p_range8_name IN BIS_BUCKET_TL.range8_name%TYPE
2836: ,p_range8_low IN BIS_BUCKET.range8_low%TYPE
2837: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
2838: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
2839: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
2840: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
2841: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
2842: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE

Line 2841: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE

2837: ,p_range8_high IN BIS_BUCKET.range8_high%TYPE
2838: ,p_range9_name IN BIS_BUCKET_TL.range9_name%TYPE
2839: ,p_range9_low IN BIS_BUCKET.range9_low%TYPE
2840: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
2841: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
2842: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
2843: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
2844: ,p_description IN BIS_BUCKET_TL.description%TYPE
2845: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'

Line 2844: ,p_description IN BIS_BUCKET_TL.description%TYPE

2840: ,p_range9_high IN BIS_BUCKET.range9_high%TYPE
2841: ,p_range10_name IN BIS_BUCKET_TL.range10_name%TYPE
2842: ,p_range10_low IN BIS_BUCKET.range10_low%TYPE
2843: ,p_range10_high IN BIS_BUCKET.range10_high%TYPE
2844: ,p_description IN BIS_BUCKET_TL.description%TYPE
2845: ,p_updatable IN BIS_BUCKET.updatable%TYPE := 'F'
2846: ,p_expandable IN BIS_BUCKET.expandable%TYPE := 'F'
2847: ,p_discontinuous IN BIS_BUCKET.discontinuous%TYPE := 'F'
2848: ,p_overlapping IN BIS_BUCKET.overlapping%TYPE := 'F'

Line 3073: DELETE FROM BIS_BUCKET_TL T

3069:
3070: PROCEDURE ADD_LANGUAGE
3071: IS
3072: BEGIN
3073: DELETE FROM BIS_BUCKET_TL T
3074: WHERE NOT EXISTS
3075: (SELECT NULL
3076: FROM BIS_BUCKET B
3077: WHERE B.BUCKET_ID = T.BUCKET_ID

Line 3080: UPDATE BIS_BUCKET_TL T SET (

3076: FROM BIS_BUCKET B
3077: WHERE B.BUCKET_ID = T.BUCKET_ID
3078: );
3079:
3080: UPDATE BIS_BUCKET_TL T SET (
3081: NAME,
3082: RANGE1_NAME,
3083: RANGE2_NAME,
3084: RANGE3_NAME,

Line 3106: FROM BIS_BUCKET_TL B

3102: B.RANGE8_NAME,
3103: B.RANGE9_NAME,
3104: B.RANGE10_NAME,
3105: B.DESCRIPTION
3106: FROM BIS_BUCKET_TL B
3107: WHERE B.BUCKET_ID = T.BUCKET_ID
3108: AND B.LANGUAGE = T.SOURCE_LANG)
3109: WHERE (
3110: T.BUCKET_ID,

Line 3115: FROM BIS_BUCKET_TL SUBB, BIS_BUCKET_TL SUBT

3111: T.LANGUAGE
3112: ) IN (SELECT
3113: SUBT.BUCKET_ID,
3114: SUBT.LANGUAGE
3115: FROM BIS_BUCKET_TL SUBB, BIS_BUCKET_TL SUBT
3116: WHERE SUBB.BUCKET_ID = SUBT.BUCKET_ID
3117: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
3118: AND (SUBB.NAME <> SUBT.NAME
3119: OR SUBB.RANGE1_NAME <> SUBT.RANGE1_NAME

Line 3154: INSERT INTO BIS_BUCKET_TL (

3150: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
3151: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
3152: ));
3153:
3154: INSERT INTO BIS_BUCKET_TL (
3155: CREATED_BY,
3156: CREATION_DATE,
3157: LAST_UPDATED_BY,
3158: LAST_UPDATE_DATE,

Line 3196: FROM BIS_BUCKET_TL B, FND_LANGUAGES L

3192: B.RANGE10_NAME,
3193: B.DESCRIPTION,
3194: L.LANGUAGE_CODE,
3195: B.SOURCE_LANG
3196: FROM BIS_BUCKET_TL B, FND_LANGUAGES L
3197: WHERE L.INSTALLED_FLAG in ('I', 'B')
3198: AND B.LANGUAGE = userenv('LANG')
3199: AND NOT EXISTS
3200: (SELECT NULL

Line 3201: FROM BIS_BUCKET_TL T

3197: WHERE L.INSTALLED_FLAG in ('I', 'B')
3198: AND B.LANGUAGE = userenv('LANG')
3199: AND NOT EXISTS
3200: (SELECT NULL
3201: FROM BIS_BUCKET_TL T
3202: WHERE T.BUCKET_ID = B.BUCKET_ID
3203: AND T.LANGUAGE = L.LANGUAGE_CODE);
3204: END ADD_LANGUAGE;
3205: