[Home] [Help]
PACKAGE: APPS.OKL_BUCKETS_PUB_W
Source
1 package okl_buckets_pub_w as
2 /* $Header: OKLUBKTS.pls 120.1 2005/07/07 12:48:49 asawanka noship $ */
3 procedure insert_buckets(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy NUMBER
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy VARCHAR2
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy NUMBER
15 , p6_a7 out nocopy NUMBER
16 , p6_a8 out nocopy NUMBER
17 , p6_a9 out nocopy DATE
18 , p6_a10 out nocopy DATE
19 , p6_a11 out nocopy DATE
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy DATE
22 , p6_a14 out nocopy NUMBER
23 , p6_a15 out nocopy DATE
24 , p6_a16 out nocopy NUMBER
25 , p5_a0 NUMBER := 0-1962.0724
26 , p5_a1 NUMBER := 0-1962.0724
27 , p5_a2 NUMBER := 0-1962.0724
28 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
30 , p5_a5 NUMBER := 0-1962.0724
31 , p5_a6 NUMBER := 0-1962.0724
32 , p5_a7 NUMBER := 0-1962.0724
33 , p5_a8 NUMBER := 0-1962.0724
34 , p5_a9 DATE := fnd_api.g_miss_date
35 , p5_a10 DATE := fnd_api.g_miss_date
36 , p5_a11 DATE := fnd_api.g_miss_date
37 , p5_a12 NUMBER := 0-1962.0724
38 , p5_a13 DATE := fnd_api.g_miss_date
39 , p5_a14 NUMBER := 0-1962.0724
40 , p5_a15 DATE := fnd_api.g_miss_date
41 , p5_a16 NUMBER := 0-1962.0724
42 );
43 procedure insert_buckets(p_api_version NUMBER
44 , p_init_msg_list VARCHAR2
45 , x_return_status out nocopy VARCHAR2
46 , x_msg_count out nocopy NUMBER
47 , x_msg_data out nocopy VARCHAR2
48 , p5_a0 JTF_NUMBER_TABLE
49 , p5_a1 JTF_NUMBER_TABLE
50 , p5_a2 JTF_NUMBER_TABLE
51 , p5_a3 JTF_VARCHAR2_TABLE_100
52 , p5_a4 JTF_VARCHAR2_TABLE_2000
53 , p5_a5 JTF_NUMBER_TABLE
54 , p5_a6 JTF_NUMBER_TABLE
55 , p5_a7 JTF_NUMBER_TABLE
56 , p5_a8 JTF_NUMBER_TABLE
57 , p5_a9 JTF_DATE_TABLE
58 , p5_a10 JTF_DATE_TABLE
59 , p5_a11 JTF_DATE_TABLE
60 , p5_a12 JTF_NUMBER_TABLE
61 , p5_a13 JTF_DATE_TABLE
62 , p5_a14 JTF_NUMBER_TABLE
63 , p5_a15 JTF_DATE_TABLE
64 , p5_a16 JTF_NUMBER_TABLE
65 , p6_a0 out nocopy JTF_NUMBER_TABLE
66 , p6_a1 out nocopy JTF_NUMBER_TABLE
67 , p6_a2 out nocopy JTF_NUMBER_TABLE
68 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70 , p6_a5 out nocopy JTF_NUMBER_TABLE
71 , p6_a6 out nocopy JTF_NUMBER_TABLE
72 , p6_a7 out nocopy JTF_NUMBER_TABLE
73 , p6_a8 out nocopy JTF_NUMBER_TABLE
74 , p6_a9 out nocopy JTF_DATE_TABLE
75 , p6_a10 out nocopy JTF_DATE_TABLE
76 , p6_a11 out nocopy JTF_DATE_TABLE
77 , p6_a12 out nocopy JTF_NUMBER_TABLE
78 , p6_a13 out nocopy JTF_DATE_TABLE
79 , p6_a14 out nocopy JTF_NUMBER_TABLE
80 , p6_a15 out nocopy JTF_DATE_TABLE
81 , p6_a16 out nocopy JTF_NUMBER_TABLE
82 );
83 procedure lock_buckets(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , x_return_status out nocopy VARCHAR2
86 , x_msg_count out nocopy NUMBER
87 , x_msg_data out nocopy VARCHAR2
88 , p5_a0 NUMBER := 0-1962.0724
89 , p5_a1 NUMBER := 0-1962.0724
90 , p5_a2 NUMBER := 0-1962.0724
91 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
92 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a5 NUMBER := 0-1962.0724
94 , p5_a6 NUMBER := 0-1962.0724
95 , p5_a7 NUMBER := 0-1962.0724
96 , p5_a8 NUMBER := 0-1962.0724
97 , p5_a9 DATE := fnd_api.g_miss_date
98 , p5_a10 DATE := fnd_api.g_miss_date
99 , p5_a11 DATE := fnd_api.g_miss_date
100 , p5_a12 NUMBER := 0-1962.0724
101 , p5_a13 DATE := fnd_api.g_miss_date
102 , p5_a14 NUMBER := 0-1962.0724
103 , p5_a15 DATE := fnd_api.g_miss_date
104 , p5_a16 NUMBER := 0-1962.0724
105 );
106 procedure lock_buckets(p_api_version NUMBER
107 , p_init_msg_list VARCHAR2
108 , x_return_status out nocopy VARCHAR2
109 , x_msg_count out nocopy NUMBER
110 , x_msg_data out nocopy VARCHAR2
111 , p5_a0 JTF_NUMBER_TABLE
112 , p5_a1 JTF_NUMBER_TABLE
113 , p5_a2 JTF_NUMBER_TABLE
114 , p5_a3 JTF_VARCHAR2_TABLE_100
115 , p5_a4 JTF_VARCHAR2_TABLE_2000
116 , p5_a5 JTF_NUMBER_TABLE
117 , p5_a6 JTF_NUMBER_TABLE
118 , p5_a7 JTF_NUMBER_TABLE
119 , p5_a8 JTF_NUMBER_TABLE
120 , p5_a9 JTF_DATE_TABLE
121 , p5_a10 JTF_DATE_TABLE
122 , p5_a11 JTF_DATE_TABLE
123 , p5_a12 JTF_NUMBER_TABLE
124 , p5_a13 JTF_DATE_TABLE
125 , p5_a14 JTF_NUMBER_TABLE
126 , p5_a15 JTF_DATE_TABLE
127 , p5_a16 JTF_NUMBER_TABLE
128 );
129 procedure update_buckets(p_api_version NUMBER
130 , p_init_msg_list VARCHAR2
131 , x_return_status out nocopy VARCHAR2
132 , x_msg_count out nocopy NUMBER
133 , x_msg_data out nocopy VARCHAR2
134 , p6_a0 out nocopy NUMBER
135 , p6_a1 out nocopy NUMBER
136 , p6_a2 out nocopy NUMBER
137 , p6_a3 out nocopy VARCHAR2
138 , p6_a4 out nocopy VARCHAR2
139 , p6_a5 out nocopy NUMBER
140 , p6_a6 out nocopy NUMBER
141 , p6_a7 out nocopy NUMBER
142 , p6_a8 out nocopy NUMBER
143 , p6_a9 out nocopy DATE
144 , p6_a10 out nocopy DATE
145 , p6_a11 out nocopy DATE
146 , p6_a12 out nocopy NUMBER
147 , p6_a13 out nocopy DATE
148 , p6_a14 out nocopy NUMBER
149 , p6_a15 out nocopy DATE
150 , p6_a16 out nocopy NUMBER
151 , p5_a0 NUMBER := 0-1962.0724
152 , p5_a1 NUMBER := 0-1962.0724
153 , p5_a2 NUMBER := 0-1962.0724
154 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a5 NUMBER := 0-1962.0724
157 , p5_a6 NUMBER := 0-1962.0724
158 , p5_a7 NUMBER := 0-1962.0724
159 , p5_a8 NUMBER := 0-1962.0724
160 , p5_a9 DATE := fnd_api.g_miss_date
161 , p5_a10 DATE := fnd_api.g_miss_date
162 , p5_a11 DATE := fnd_api.g_miss_date
163 , p5_a12 NUMBER := 0-1962.0724
164 , p5_a13 DATE := fnd_api.g_miss_date
165 , p5_a14 NUMBER := 0-1962.0724
166 , p5_a15 DATE := fnd_api.g_miss_date
167 , p5_a16 NUMBER := 0-1962.0724
168 );
169 procedure update_buckets(p_api_version NUMBER
170 , p_init_msg_list VARCHAR2
171 , x_return_status out nocopy VARCHAR2
172 , x_msg_count out nocopy NUMBER
173 , x_msg_data out nocopy VARCHAR2
174 , p5_a0 JTF_NUMBER_TABLE
175 , p5_a1 JTF_NUMBER_TABLE
176 , p5_a2 JTF_NUMBER_TABLE
177 , p5_a3 JTF_VARCHAR2_TABLE_100
178 , p5_a4 JTF_VARCHAR2_TABLE_2000
179 , p5_a5 JTF_NUMBER_TABLE
180 , p5_a6 JTF_NUMBER_TABLE
181 , p5_a7 JTF_NUMBER_TABLE
182 , p5_a8 JTF_NUMBER_TABLE
183 , p5_a9 JTF_DATE_TABLE
184 , p5_a10 JTF_DATE_TABLE
185 , p5_a11 JTF_DATE_TABLE
186 , p5_a12 JTF_NUMBER_TABLE
187 , p5_a13 JTF_DATE_TABLE
188 , p5_a14 JTF_NUMBER_TABLE
189 , p5_a15 JTF_DATE_TABLE
190 , p5_a16 JTF_NUMBER_TABLE
191 , p6_a0 out nocopy JTF_NUMBER_TABLE
192 , p6_a1 out nocopy JTF_NUMBER_TABLE
193 , p6_a2 out nocopy JTF_NUMBER_TABLE
194 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196 , p6_a5 out nocopy JTF_NUMBER_TABLE
197 , p6_a6 out nocopy JTF_NUMBER_TABLE
198 , p6_a7 out nocopy JTF_NUMBER_TABLE
199 , p6_a8 out nocopy JTF_NUMBER_TABLE
200 , p6_a9 out nocopy JTF_DATE_TABLE
201 , p6_a10 out nocopy JTF_DATE_TABLE
202 , p6_a11 out nocopy JTF_DATE_TABLE
203 , p6_a12 out nocopy JTF_NUMBER_TABLE
204 , p6_a13 out nocopy JTF_DATE_TABLE
205 , p6_a14 out nocopy JTF_NUMBER_TABLE
206 , p6_a15 out nocopy JTF_DATE_TABLE
207 , p6_a16 out nocopy JTF_NUMBER_TABLE
208 );
209 procedure delete_buckets(p_api_version NUMBER
210 , p_init_msg_list VARCHAR2
211 , x_return_status out nocopy VARCHAR2
212 , x_msg_count out nocopy NUMBER
213 , x_msg_data out nocopy VARCHAR2
214 , p5_a0 NUMBER := 0-1962.0724
215 , p5_a1 NUMBER := 0-1962.0724
216 , p5_a2 NUMBER := 0-1962.0724
217 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
218 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
219 , p5_a5 NUMBER := 0-1962.0724
220 , p5_a6 NUMBER := 0-1962.0724
221 , p5_a7 NUMBER := 0-1962.0724
222 , p5_a8 NUMBER := 0-1962.0724
223 , p5_a9 DATE := fnd_api.g_miss_date
224 , p5_a10 DATE := fnd_api.g_miss_date
225 , p5_a11 DATE := fnd_api.g_miss_date
226 , p5_a12 NUMBER := 0-1962.0724
227 , p5_a13 DATE := fnd_api.g_miss_date
228 , p5_a14 NUMBER := 0-1962.0724
229 , p5_a15 DATE := fnd_api.g_miss_date
230 , p5_a16 NUMBER := 0-1962.0724
231 );
232 procedure delete_buckets(p_api_version NUMBER
233 , p_init_msg_list VARCHAR2
234 , x_return_status out nocopy VARCHAR2
235 , x_msg_count out nocopy NUMBER
236 , x_msg_data out nocopy VARCHAR2
237 , p5_a0 JTF_NUMBER_TABLE
238 , p5_a1 JTF_NUMBER_TABLE
239 , p5_a2 JTF_NUMBER_TABLE
240 , p5_a3 JTF_VARCHAR2_TABLE_100
241 , p5_a4 JTF_VARCHAR2_TABLE_2000
242 , p5_a5 JTF_NUMBER_TABLE
243 , p5_a6 JTF_NUMBER_TABLE
244 , p5_a7 JTF_NUMBER_TABLE
245 , p5_a8 JTF_NUMBER_TABLE
246 , p5_a9 JTF_DATE_TABLE
247 , p5_a10 JTF_DATE_TABLE
248 , p5_a11 JTF_DATE_TABLE
249 , p5_a12 JTF_NUMBER_TABLE
250 , p5_a13 JTF_DATE_TABLE
251 , p5_a14 JTF_NUMBER_TABLE
252 , p5_a15 JTF_DATE_TABLE
253 , p5_a16 JTF_NUMBER_TABLE
254 );
255 procedure validate_buckets(p_api_version NUMBER
256 , p_init_msg_list VARCHAR2
257 , x_return_status out nocopy VARCHAR2
258 , x_msg_count out nocopy NUMBER
259 , x_msg_data out nocopy VARCHAR2
260 , p5_a0 NUMBER := 0-1962.0724
261 , p5_a1 NUMBER := 0-1962.0724
262 , p5_a2 NUMBER := 0-1962.0724
263 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
264 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
265 , p5_a5 NUMBER := 0-1962.0724
266 , p5_a6 NUMBER := 0-1962.0724
267 , p5_a7 NUMBER := 0-1962.0724
268 , p5_a8 NUMBER := 0-1962.0724
269 , p5_a9 DATE := fnd_api.g_miss_date
270 , p5_a10 DATE := fnd_api.g_miss_date
271 , p5_a11 DATE := fnd_api.g_miss_date
272 , p5_a12 NUMBER := 0-1962.0724
273 , p5_a13 DATE := fnd_api.g_miss_date
274 , p5_a14 NUMBER := 0-1962.0724
275 , p5_a15 DATE := fnd_api.g_miss_date
276 , p5_a16 NUMBER := 0-1962.0724
277 );
278 procedure validate_buckets(p_api_version NUMBER
279 , p_init_msg_list VARCHAR2
280 , x_return_status out nocopy VARCHAR2
281 , x_msg_count out nocopy NUMBER
282 , x_msg_data out nocopy VARCHAR2
283 , p5_a0 JTF_NUMBER_TABLE
284 , p5_a1 JTF_NUMBER_TABLE
285 , p5_a2 JTF_NUMBER_TABLE
286 , p5_a3 JTF_VARCHAR2_TABLE_100
287 , p5_a4 JTF_VARCHAR2_TABLE_2000
288 , p5_a5 JTF_NUMBER_TABLE
289 , p5_a6 JTF_NUMBER_TABLE
290 , p5_a7 JTF_NUMBER_TABLE
291 , p5_a8 JTF_NUMBER_TABLE
292 , p5_a9 JTF_DATE_TABLE
293 , p5_a10 JTF_DATE_TABLE
294 , p5_a11 JTF_DATE_TABLE
295 , p5_a12 JTF_NUMBER_TABLE
296 , p5_a13 JTF_DATE_TABLE
297 , p5_a14 JTF_NUMBER_TABLE
298 , p5_a15 JTF_DATE_TABLE
299 , p5_a16 JTF_NUMBER_TABLE
300 );
301 end okl_buckets_pub_w;