[Home] [Help]
PACKAGE: APPS.OKL_TRX_TYPES_PUB_W
Source
1 package okl_trx_types_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUTRYS.pls 120.2 2005/07/20 07:15:55 asawanka noship $ */
3 procedure insert_trx_types(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 VARCHAR2
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy NUMBER
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy NUMBER
15 , p6_a7 out nocopy VARCHAR2
16 , p6_a8 out nocopy VARCHAR2
17 , p6_a9 out nocopy VARCHAR2
18 , p6_a10 out nocopy VARCHAR2
19 , p6_a11 out nocopy VARCHAR2
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy NUMBER
22 , p6_a14 out nocopy DATE
23 , p6_a15 out nocopy NUMBER
24 , p6_a16 out nocopy DATE
25 , p6_a17 out nocopy NUMBER
26 , p6_a18 out nocopy VARCHAR2
27 , p6_a19 out nocopy VARCHAR2
28 , p6_a20 out nocopy VARCHAR2
29 , p6_a21 out nocopy VARCHAR2
30 , p5_a0 NUMBER := 0-1962.0724
31 , p5_a1 NUMBER := 0-1962.0724
32 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a4 NUMBER := 0-1962.0724
35 , p5_a5 NUMBER := 0-1962.0724
36 , p5_a6 NUMBER := 0-1962.0724
37 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
39 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p5_a12 NUMBER := 0-1962.0724
43 , p5_a13 NUMBER := 0-1962.0724
44 , p5_a14 DATE := fnd_api.g_miss_date
45 , p5_a15 NUMBER := 0-1962.0724
46 , p5_a16 DATE := fnd_api.g_miss_date
47 , p5_a17 NUMBER := 0-1962.0724
48 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
52 );
53 procedure insert_trx_types(p_api_version NUMBER
54 , p_init_msg_list VARCHAR2
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 , p5_a0 JTF_NUMBER_TABLE
59 , p5_a1 JTF_NUMBER_TABLE
60 , p5_a2 JTF_VARCHAR2_TABLE_100
61 , p5_a3 JTF_VARCHAR2_TABLE_100
62 , p5_a4 JTF_NUMBER_TABLE
63 , p5_a5 JTF_NUMBER_TABLE
64 , p5_a6 JTF_NUMBER_TABLE
65 , p5_a7 JTF_VARCHAR2_TABLE_100
66 , p5_a8 JTF_VARCHAR2_TABLE_200
67 , p5_a9 JTF_VARCHAR2_TABLE_2000
68 , p5_a10 JTF_VARCHAR2_TABLE_100
69 , p5_a11 JTF_VARCHAR2_TABLE_100
70 , p5_a12 JTF_NUMBER_TABLE
71 , p5_a13 JTF_NUMBER_TABLE
72 , p5_a14 JTF_DATE_TABLE
73 , p5_a15 JTF_NUMBER_TABLE
74 , p5_a16 JTF_DATE_TABLE
75 , p5_a17 JTF_NUMBER_TABLE
76 , p5_a18 JTF_VARCHAR2_TABLE_100
77 , p5_a19 JTF_VARCHAR2_TABLE_100
78 , p5_a20 JTF_VARCHAR2_TABLE_100
79 , p5_a21 JTF_VARCHAR2_TABLE_100
80 , p6_a0 out nocopy JTF_NUMBER_TABLE
81 , p6_a1 out nocopy JTF_NUMBER_TABLE
82 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
83 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
84 , p6_a4 out nocopy JTF_NUMBER_TABLE
85 , p6_a5 out nocopy JTF_NUMBER_TABLE
86 , p6_a6 out nocopy JTF_NUMBER_TABLE
87 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
88 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
89 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
90 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
91 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
92 , p6_a12 out nocopy JTF_NUMBER_TABLE
93 , p6_a13 out nocopy JTF_NUMBER_TABLE
94 , p6_a14 out nocopy JTF_DATE_TABLE
95 , p6_a15 out nocopy JTF_NUMBER_TABLE
96 , p6_a16 out nocopy JTF_DATE_TABLE
97 , p6_a17 out nocopy JTF_NUMBER_TABLE
98 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
99 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
100 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
101 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
102 );
103 procedure lock_trx_types(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 , p5_a0 NUMBER := 0-1962.0724
109 , p5_a1 NUMBER := 0-1962.0724
110 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a4 NUMBER := 0-1962.0724
113 , p5_a5 NUMBER := 0-1962.0724
114 , p5_a6 NUMBER := 0-1962.0724
115 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
117 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a12 NUMBER := 0-1962.0724
121 , p5_a13 NUMBER := 0-1962.0724
122 , p5_a14 DATE := fnd_api.g_miss_date
123 , p5_a15 NUMBER := 0-1962.0724
124 , p5_a16 DATE := fnd_api.g_miss_date
125 , p5_a17 NUMBER := 0-1962.0724
126 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
130 );
131 procedure lock_trx_types(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , p5_a0 JTF_NUMBER_TABLE
137 , p5_a1 JTF_NUMBER_TABLE
138 , p5_a2 JTF_VARCHAR2_TABLE_100
139 , p5_a3 JTF_VARCHAR2_TABLE_100
140 , p5_a4 JTF_NUMBER_TABLE
141 , p5_a5 JTF_NUMBER_TABLE
142 , p5_a6 JTF_NUMBER_TABLE
143 , p5_a7 JTF_VARCHAR2_TABLE_100
144 , p5_a8 JTF_VARCHAR2_TABLE_200
145 , p5_a9 JTF_VARCHAR2_TABLE_2000
146 , p5_a10 JTF_VARCHAR2_TABLE_100
147 , p5_a11 JTF_VARCHAR2_TABLE_100
148 , p5_a12 JTF_NUMBER_TABLE
149 , p5_a13 JTF_NUMBER_TABLE
150 , p5_a14 JTF_DATE_TABLE
151 , p5_a15 JTF_NUMBER_TABLE
152 , p5_a16 JTF_DATE_TABLE
153 , p5_a17 JTF_NUMBER_TABLE
154 , p5_a18 JTF_VARCHAR2_TABLE_100
155 , p5_a19 JTF_VARCHAR2_TABLE_100
156 , p5_a20 JTF_VARCHAR2_TABLE_100
157 , p5_a21 JTF_VARCHAR2_TABLE_100
158 );
159 procedure update_trx_types(p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , x_return_status out nocopy VARCHAR2
162 , x_msg_count out nocopy NUMBER
163 , x_msg_data out nocopy VARCHAR2
164 , p6_a0 out nocopy NUMBER
165 , p6_a1 out nocopy NUMBER
166 , p6_a2 out nocopy VARCHAR2
167 , p6_a3 out nocopy VARCHAR2
168 , p6_a4 out nocopy NUMBER
169 , p6_a5 out nocopy NUMBER
170 , p6_a6 out nocopy NUMBER
171 , p6_a7 out nocopy VARCHAR2
172 , p6_a8 out nocopy VARCHAR2
173 , p6_a9 out nocopy VARCHAR2
174 , p6_a10 out nocopy VARCHAR2
175 , p6_a11 out nocopy VARCHAR2
176 , p6_a12 out nocopy NUMBER
177 , p6_a13 out nocopy NUMBER
178 , p6_a14 out nocopy DATE
179 , p6_a15 out nocopy NUMBER
180 , p6_a16 out nocopy DATE
181 , p6_a17 out nocopy NUMBER
182 , p6_a18 out nocopy VARCHAR2
183 , p6_a19 out nocopy VARCHAR2
184 , p6_a20 out nocopy VARCHAR2
185 , p6_a21 out nocopy VARCHAR2
186 , p5_a0 NUMBER := 0-1962.0724
187 , p5_a1 NUMBER := 0-1962.0724
188 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
189 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
190 , p5_a4 NUMBER := 0-1962.0724
191 , p5_a5 NUMBER := 0-1962.0724
192 , p5_a6 NUMBER := 0-1962.0724
193 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
194 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
196 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
197 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
198 , p5_a12 NUMBER := 0-1962.0724
199 , p5_a13 NUMBER := 0-1962.0724
200 , p5_a14 DATE := fnd_api.g_miss_date
201 , p5_a15 NUMBER := 0-1962.0724
202 , p5_a16 DATE := fnd_api.g_miss_date
203 , p5_a17 NUMBER := 0-1962.0724
204 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
205 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
206 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
207 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
208 );
209 procedure update_trx_types(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 JTF_NUMBER_TABLE
215 , p5_a1 JTF_NUMBER_TABLE
216 , p5_a2 JTF_VARCHAR2_TABLE_100
217 , p5_a3 JTF_VARCHAR2_TABLE_100
218 , p5_a4 JTF_NUMBER_TABLE
219 , p5_a5 JTF_NUMBER_TABLE
220 , p5_a6 JTF_NUMBER_TABLE
221 , p5_a7 JTF_VARCHAR2_TABLE_100
222 , p5_a8 JTF_VARCHAR2_TABLE_200
223 , p5_a9 JTF_VARCHAR2_TABLE_2000
224 , p5_a10 JTF_VARCHAR2_TABLE_100
225 , p5_a11 JTF_VARCHAR2_TABLE_100
226 , p5_a12 JTF_NUMBER_TABLE
227 , p5_a13 JTF_NUMBER_TABLE
228 , p5_a14 JTF_DATE_TABLE
229 , p5_a15 JTF_NUMBER_TABLE
230 , p5_a16 JTF_DATE_TABLE
231 , p5_a17 JTF_NUMBER_TABLE
232 , p5_a18 JTF_VARCHAR2_TABLE_100
233 , p5_a19 JTF_VARCHAR2_TABLE_100
234 , p5_a20 JTF_VARCHAR2_TABLE_100
235 , p5_a21 JTF_VARCHAR2_TABLE_100
236 , p6_a0 out nocopy JTF_NUMBER_TABLE
237 , p6_a1 out nocopy JTF_NUMBER_TABLE
238 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
239 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
240 , p6_a4 out nocopy JTF_NUMBER_TABLE
241 , p6_a5 out nocopy JTF_NUMBER_TABLE
242 , p6_a6 out nocopy JTF_NUMBER_TABLE
243 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
244 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
245 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
246 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
247 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
248 , p6_a12 out nocopy JTF_NUMBER_TABLE
249 , p6_a13 out nocopy JTF_NUMBER_TABLE
250 , p6_a14 out nocopy JTF_DATE_TABLE
251 , p6_a15 out nocopy JTF_NUMBER_TABLE
252 , p6_a16 out nocopy JTF_DATE_TABLE
253 , p6_a17 out nocopy JTF_NUMBER_TABLE
254 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
255 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
256 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
258 );
259 procedure delete_trx_types(p_api_version NUMBER
260 , p_init_msg_list VARCHAR2
261 , x_return_status out nocopy VARCHAR2
262 , x_msg_count out nocopy NUMBER
263 , x_msg_data out nocopy VARCHAR2
264 , p5_a0 NUMBER := 0-1962.0724
265 , p5_a1 NUMBER := 0-1962.0724
266 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
267 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a4 NUMBER := 0-1962.0724
269 , p5_a5 NUMBER := 0-1962.0724
270 , p5_a6 NUMBER := 0-1962.0724
271 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a12 NUMBER := 0-1962.0724
277 , p5_a13 NUMBER := 0-1962.0724
278 , p5_a14 DATE := fnd_api.g_miss_date
279 , p5_a15 NUMBER := 0-1962.0724
280 , p5_a16 DATE := fnd_api.g_miss_date
281 , p5_a17 NUMBER := 0-1962.0724
282 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
283 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
284 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
285 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
286 );
287 procedure delete_trx_types(p_api_version NUMBER
288 , p_init_msg_list VARCHAR2
289 , x_return_status out nocopy VARCHAR2
290 , x_msg_count out nocopy NUMBER
291 , x_msg_data out nocopy VARCHAR2
292 , p5_a0 JTF_NUMBER_TABLE
293 , p5_a1 JTF_NUMBER_TABLE
294 , p5_a2 JTF_VARCHAR2_TABLE_100
295 , p5_a3 JTF_VARCHAR2_TABLE_100
296 , p5_a4 JTF_NUMBER_TABLE
297 , p5_a5 JTF_NUMBER_TABLE
298 , p5_a6 JTF_NUMBER_TABLE
299 , p5_a7 JTF_VARCHAR2_TABLE_100
300 , p5_a8 JTF_VARCHAR2_TABLE_200
301 , p5_a9 JTF_VARCHAR2_TABLE_2000
302 , p5_a10 JTF_VARCHAR2_TABLE_100
303 , p5_a11 JTF_VARCHAR2_TABLE_100
304 , p5_a12 JTF_NUMBER_TABLE
305 , p5_a13 JTF_NUMBER_TABLE
306 , p5_a14 JTF_DATE_TABLE
307 , p5_a15 JTF_NUMBER_TABLE
308 , p5_a16 JTF_DATE_TABLE
309 , p5_a17 JTF_NUMBER_TABLE
310 , p5_a18 JTF_VARCHAR2_TABLE_100
311 , p5_a19 JTF_VARCHAR2_TABLE_100
312 , p5_a20 JTF_VARCHAR2_TABLE_100
313 , p5_a21 JTF_VARCHAR2_TABLE_100
314 );
315 procedure validate_trx_types(p_api_version NUMBER
316 , p_init_msg_list VARCHAR2
317 , x_return_status out nocopy VARCHAR2
318 , x_msg_count out nocopy NUMBER
319 , x_msg_data out nocopy VARCHAR2
320 , p5_a0 NUMBER := 0-1962.0724
321 , p5_a1 NUMBER := 0-1962.0724
322 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
323 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
324 , p5_a4 NUMBER := 0-1962.0724
325 , p5_a5 NUMBER := 0-1962.0724
326 , p5_a6 NUMBER := 0-1962.0724
327 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
329 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
330 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
331 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a12 NUMBER := 0-1962.0724
333 , p5_a13 NUMBER := 0-1962.0724
334 , p5_a14 DATE := fnd_api.g_miss_date
335 , p5_a15 NUMBER := 0-1962.0724
336 , p5_a16 DATE := fnd_api.g_miss_date
337 , p5_a17 NUMBER := 0-1962.0724
338 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
339 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
340 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
342 );
343 procedure validate_trx_types(p_api_version NUMBER
344 , p_init_msg_list VARCHAR2
345 , x_return_status out nocopy VARCHAR2
346 , x_msg_count out nocopy NUMBER
347 , x_msg_data out nocopy VARCHAR2
348 , p5_a0 JTF_NUMBER_TABLE
349 , p5_a1 JTF_NUMBER_TABLE
350 , p5_a2 JTF_VARCHAR2_TABLE_100
351 , p5_a3 JTF_VARCHAR2_TABLE_100
352 , p5_a4 JTF_NUMBER_TABLE
353 , p5_a5 JTF_NUMBER_TABLE
354 , p5_a6 JTF_NUMBER_TABLE
355 , p5_a7 JTF_VARCHAR2_TABLE_100
356 , p5_a8 JTF_VARCHAR2_TABLE_200
357 , p5_a9 JTF_VARCHAR2_TABLE_2000
358 , p5_a10 JTF_VARCHAR2_TABLE_100
359 , p5_a11 JTF_VARCHAR2_TABLE_100
360 , p5_a12 JTF_NUMBER_TABLE
361 , p5_a13 JTF_NUMBER_TABLE
362 , p5_a14 JTF_DATE_TABLE
363 , p5_a15 JTF_NUMBER_TABLE
364 , p5_a16 JTF_DATE_TABLE
365 , p5_a17 JTF_NUMBER_TABLE
366 , p5_a18 JTF_VARCHAR2_TABLE_100
367 , p5_a19 JTF_VARCHAR2_TABLE_100
368 , p5_a20 JTF_VARCHAR2_TABLE_100
369 , p5_a21 JTF_VARCHAR2_TABLE_100
370 );
371 end okl_trx_types_pub_w;