[Home] [Help]
PACKAGE: APPS.OKL_TRANS_CONTRACTS_PVT_W
Source
1 package okl_trans_contracts_pvt_w as
2 /* $Header: OKLETCTS.pls 120.7.12010000.3 2008/11/12 23:51:19 apaul ship $ */
3 procedure create_trx_contracts(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 JTF_NUMBER_TABLE
9 , p6_a1 JTF_NUMBER_TABLE
10 , p6_a2 JTF_NUMBER_TABLE
11 , p6_a3 JTF_NUMBER_TABLE
12 , p6_a4 JTF_NUMBER_TABLE
13 , p6_a5 JTF_NUMBER_TABLE
14 , p6_a6 JTF_NUMBER_TABLE
15 , p6_a7 JTF_NUMBER_TABLE
16 , p6_a8 JTF_VARCHAR2_TABLE_100
17 , p6_a9 JTF_NUMBER_TABLE
18 , p6_a10 JTF_VARCHAR2_TABLE_2000
19 , p6_a11 JTF_NUMBER_TABLE
20 , p6_a12 JTF_VARCHAR2_TABLE_200
21 , p6_a13 JTF_VARCHAR2_TABLE_100
22 , p6_a14 JTF_VARCHAR2_TABLE_100
23 , p6_a15 JTF_VARCHAR2_TABLE_500
24 , p6_a16 JTF_VARCHAR2_TABLE_500
25 , p6_a17 JTF_VARCHAR2_TABLE_500
26 , p6_a18 JTF_VARCHAR2_TABLE_500
27 , p6_a19 JTF_VARCHAR2_TABLE_500
28 , p6_a20 JTF_VARCHAR2_TABLE_500
29 , p6_a21 JTF_VARCHAR2_TABLE_500
30 , p6_a22 JTF_VARCHAR2_TABLE_500
31 , p6_a23 JTF_VARCHAR2_TABLE_500
32 , p6_a24 JTF_VARCHAR2_TABLE_500
33 , p6_a25 JTF_VARCHAR2_TABLE_500
34 , p6_a26 JTF_VARCHAR2_TABLE_500
35 , p6_a27 JTF_VARCHAR2_TABLE_500
36 , p6_a28 JTF_VARCHAR2_TABLE_500
37 , p6_a29 JTF_VARCHAR2_TABLE_500
38 , p6_a30 JTF_VARCHAR2_TABLE_100
39 , p6_a31 JTF_NUMBER_TABLE
40 , p6_a32 JTF_DATE_TABLE
41 , p6_a33 JTF_NUMBER_TABLE
42 , p6_a34 JTF_DATE_TABLE
43 , p6_a35 JTF_NUMBER_TABLE
44 , p6_a36 JTF_NUMBER_TABLE
45 , p6_a37 JTF_NUMBER_TABLE
46 , p6_a38 JTF_NUMBER_TABLE
47 , p6_a39 JTF_DATE_TABLE
48 , p6_a40 JTF_NUMBER_TABLE
49 , p6_a41 JTF_NUMBER_TABLE
50 , p6_a42 JTF_NUMBER_TABLE
51 , p6_a43 JTF_NUMBER_TABLE
52 , p6_a44 JTF_NUMBER_TABLE
53 , p6_a45 JTF_VARCHAR2_TABLE_100
54 , p6_a46 JTF_VARCHAR2_TABLE_200
55 , p6_a47 JTF_NUMBER_TABLE
56 , p6_a48 JTF_VARCHAR2_TABLE_200
57 , p6_a49 JTF_NUMBER_TABLE
58 , p6_a50 JTF_VARCHAR2_TABLE_200
59 , p6_a51 JTF_NUMBER_TABLE
60 , p6_a52 JTF_DATE_TABLE
61 , p6_a53 JTF_NUMBER_TABLE
62 , p6_a54 JTF_VARCHAR2_TABLE_200
63 , p6_a55 JTF_VARCHAR2_TABLE_300
64 , p6_a56 JTF_VARCHAR2_TABLE_100
65 , p6_a57 JTF_VARCHAR2_TABLE_100
66 , p7_a0 out nocopy NUMBER
67 , p7_a1 out nocopy NUMBER
68 , p7_a2 out nocopy VARCHAR2
69 , p7_a3 out nocopy VARCHAR2
70 , p7_a4 out nocopy VARCHAR2
71 , p7_a5 out nocopy VARCHAR2
72 , p7_a6 out nocopy NUMBER
73 , p7_a7 out nocopy NUMBER
74 , p7_a8 out nocopy NUMBER
75 , p7_a9 out nocopy NUMBER
76 , p7_a10 out nocopy NUMBER
77 , p7_a11 out nocopy NUMBER
78 , p7_a12 out nocopy VARCHAR2
79 , p7_a13 out nocopy VARCHAR2
80 , p7_a14 out nocopy DATE
81 , p7_a15 out nocopy VARCHAR2
82 , p7_a16 out nocopy VARCHAR2
83 , p7_a17 out nocopy NUMBER
84 , p7_a18 out nocopy VARCHAR2
85 , p7_a19 out nocopy VARCHAR2
86 , p7_a20 out nocopy VARCHAR2
87 , p7_a21 out nocopy VARCHAR2
88 , p7_a22 out nocopy VARCHAR2
89 , p7_a23 out nocopy VARCHAR2
90 , p7_a24 out nocopy VARCHAR2
91 , p7_a25 out nocopy VARCHAR2
92 , p7_a26 out nocopy VARCHAR2
93 , p7_a27 out nocopy VARCHAR2
94 , p7_a28 out nocopy VARCHAR2
95 , p7_a29 out nocopy VARCHAR2
96 , p7_a30 out nocopy VARCHAR2
97 , p7_a31 out nocopy VARCHAR2
98 , p7_a32 out nocopy VARCHAR2
99 , p7_a33 out nocopy VARCHAR2
100 , p7_a34 out nocopy VARCHAR2
101 , p7_a35 out nocopy VARCHAR2
102 , p7_a36 out nocopy VARCHAR2
103 , p7_a37 out nocopy NUMBER
104 , p7_a38 out nocopy VARCHAR2
105 , p7_a39 out nocopy NUMBER
106 , p7_a40 out nocopy VARCHAR2
107 , p7_a41 out nocopy VARCHAR2
108 , p7_a42 out nocopy NUMBER
109 , p7_a43 out nocopy NUMBER
110 , p7_a44 out nocopy NUMBER
111 , p7_a45 out nocopy NUMBER
112 , p7_a46 out nocopy NUMBER
113 , p7_a47 out nocopy NUMBER
114 , p7_a48 out nocopy DATE
115 , p7_a49 out nocopy NUMBER
116 , p7_a50 out nocopy DATE
117 , p7_a51 out nocopy NUMBER
118 , p7_a52 out nocopy DATE
119 , p7_a53 out nocopy NUMBER
120 , p7_a54 out nocopy NUMBER
121 , p7_a55 out nocopy VARCHAR2
122 , p7_a56 out nocopy NUMBER
123 , p7_a57 out nocopy VARCHAR2
124 , p7_a58 out nocopy DATE
125 , p7_a59 out nocopy VARCHAR2
126 , p7_a60 out nocopy VARCHAR2
127 , p7_a61 out nocopy VARCHAR2
128 , p7_a62 out nocopy VARCHAR2
129 , p7_a63 out nocopy VARCHAR2
130 , p7_a64 out nocopy VARCHAR2
131 , p7_a65 out nocopy VARCHAR2
132 , p7_a66 out nocopy VARCHAR2
133 , p7_a67 out nocopy VARCHAR2
134 , p7_a68 out nocopy VARCHAR2
135 , p7_a69 out nocopy VARCHAR2
136 , p7_a70 out nocopy VARCHAR2
137 , p7_a71 out nocopy VARCHAR2
138 , p7_a72 out nocopy VARCHAR2
139 , p7_a73 out nocopy VARCHAR2
140 , p7_a74 out nocopy VARCHAR2
141 , p7_a75 out nocopy VARCHAR2
142 , p7_a76 out nocopy VARCHAR2
143 , p7_a77 out nocopy NUMBER
144 , p7_a78 out nocopy DATE
145 , p7_a79 out nocopy NUMBER
146 , p7_a80 out nocopy NUMBER
147 , p7_a81 out nocopy VARCHAR2
148 , p7_a82 out nocopy DATE
149 , p7_a83 out nocopy NUMBER
150 , p7_a84 out nocopy DATE
151 , p7_a85 out nocopy VARCHAR2
152 , p7_a86 out nocopy VARCHAR2
153 , p7_a87 out nocopy VARCHAR2
154 , p7_a88 out nocopy VARCHAR2
155 , p7_a89 out nocopy VARCHAR2
156 , p7_a90 out nocopy VARCHAR2
157 , p7_a91 out nocopy VARCHAR2
158 , p7_a92 out nocopy VARCHAR2
159 , p7_a93 out nocopy DATE
160 , p8_a0 out nocopy JTF_NUMBER_TABLE
161 , p8_a1 out nocopy JTF_NUMBER_TABLE
162 , p8_a2 out nocopy JTF_NUMBER_TABLE
163 , p8_a3 out nocopy JTF_NUMBER_TABLE
164 , p8_a4 out nocopy JTF_NUMBER_TABLE
165 , p8_a5 out nocopy JTF_NUMBER_TABLE
166 , p8_a6 out nocopy JTF_NUMBER_TABLE
167 , p8_a7 out nocopy JTF_NUMBER_TABLE
168 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
169 , p8_a9 out nocopy JTF_NUMBER_TABLE
170 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
171 , p8_a11 out nocopy JTF_NUMBER_TABLE
172 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
173 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
174 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
175 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
176 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
177 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
178 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
179 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
180 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
181 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
182 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
183 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
184 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
185 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_500
186 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_500
187 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_500
188 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_500
189 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
190 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
191 , p8_a31 out nocopy JTF_NUMBER_TABLE
192 , p8_a32 out nocopy JTF_DATE_TABLE
193 , p8_a33 out nocopy JTF_NUMBER_TABLE
194 , p8_a34 out nocopy JTF_DATE_TABLE
195 , p8_a35 out nocopy JTF_NUMBER_TABLE
196 , p8_a36 out nocopy JTF_NUMBER_TABLE
197 , p8_a37 out nocopy JTF_NUMBER_TABLE
198 , p8_a38 out nocopy JTF_NUMBER_TABLE
199 , p8_a39 out nocopy JTF_DATE_TABLE
200 , p8_a40 out nocopy JTF_NUMBER_TABLE
201 , p8_a41 out nocopy JTF_NUMBER_TABLE
202 , p8_a42 out nocopy JTF_NUMBER_TABLE
203 , p8_a43 out nocopy JTF_NUMBER_TABLE
204 , p8_a44 out nocopy JTF_NUMBER_TABLE
205 , p8_a45 out nocopy JTF_VARCHAR2_TABLE_100
206 , p8_a46 out nocopy JTF_VARCHAR2_TABLE_200
207 , p8_a47 out nocopy JTF_NUMBER_TABLE
208 , p8_a48 out nocopy JTF_VARCHAR2_TABLE_200
209 , p8_a49 out nocopy JTF_NUMBER_TABLE
210 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_200
211 , p8_a51 out nocopy JTF_NUMBER_TABLE
212 , p8_a52 out nocopy JTF_DATE_TABLE
213 , p8_a53 out nocopy JTF_NUMBER_TABLE
214 , p8_a54 out nocopy JTF_VARCHAR2_TABLE_200
215 , p8_a55 out nocopy JTF_VARCHAR2_TABLE_300
216 , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
217 , p8_a57 out nocopy JTF_VARCHAR2_TABLE_100
218 , p5_a0 NUMBER := 0-1962.0724
219 , p5_a1 NUMBER := 0-1962.0724
220 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
221 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
223 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a6 NUMBER := 0-1962.0724
225 , p5_a7 NUMBER := 0-1962.0724
226 , p5_a8 NUMBER := 0-1962.0724
227 , p5_a9 NUMBER := 0-1962.0724
228 , p5_a10 NUMBER := 0-1962.0724
229 , p5_a11 NUMBER := 0-1962.0724
230 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a14 DATE := fnd_api.g_miss_date
233 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
234 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a17 NUMBER := 0-1962.0724
236 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
238 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
239 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
240 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
241 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
242 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
243 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
244 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
245 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
246 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
247 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
248 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
249 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
250 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
251 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
252 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
253 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
254 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
255 , p5_a37 NUMBER := 0-1962.0724
256 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
257 , p5_a39 NUMBER := 0-1962.0724
258 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
259 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
260 , p5_a42 NUMBER := 0-1962.0724
261 , p5_a43 NUMBER := 0-1962.0724
262 , p5_a44 NUMBER := 0-1962.0724
263 , p5_a45 NUMBER := 0-1962.0724
264 , p5_a46 NUMBER := 0-1962.0724
265 , p5_a47 NUMBER := 0-1962.0724
266 , p5_a48 DATE := fnd_api.g_miss_date
267 , p5_a49 NUMBER := 0-1962.0724
268 , p5_a50 DATE := fnd_api.g_miss_date
269 , p5_a51 NUMBER := 0-1962.0724
270 , p5_a52 DATE := fnd_api.g_miss_date
271 , p5_a53 NUMBER := 0-1962.0724
272 , p5_a54 NUMBER := 0-1962.0724
273 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a56 NUMBER := 0-1962.0724
275 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a58 DATE := fnd_api.g_miss_date
277 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
281 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
282 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
283 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
284 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
285 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
286 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
288 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
289 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
290 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
291 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
292 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
293 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
294 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
295 , p5_a77 NUMBER := 0-1962.0724
296 , p5_a78 DATE := fnd_api.g_miss_date
297 , p5_a79 NUMBER := 0-1962.0724
298 , p5_a80 NUMBER := 0-1962.0724
299 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
300 , p5_a82 DATE := fnd_api.g_miss_date
301 , p5_a83 NUMBER := 0-1962.0724
302 , p5_a84 DATE := fnd_api.g_miss_date
303 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
304 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
305 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
306 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
307 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
308 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
309 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
310 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
311 , p5_a93 DATE := fnd_api.g_miss_date
312 );
313 procedure create_trx_contracts(p_api_version NUMBER
314 , p_init_msg_list VARCHAR2
315 , x_return_status out nocopy VARCHAR2
316 , x_msg_count out nocopy NUMBER
317 , x_msg_data out nocopy VARCHAR2
318 , p6_a0 out nocopy NUMBER
319 , p6_a1 out nocopy NUMBER
320 , p6_a2 out nocopy VARCHAR2
321 , p6_a3 out nocopy VARCHAR2
322 , p6_a4 out nocopy VARCHAR2
323 , p6_a5 out nocopy VARCHAR2
324 , p6_a6 out nocopy NUMBER
325 , p6_a7 out nocopy NUMBER
326 , p6_a8 out nocopy NUMBER
327 , p6_a9 out nocopy NUMBER
328 , p6_a10 out nocopy NUMBER
329 , p6_a11 out nocopy NUMBER
330 , p6_a12 out nocopy VARCHAR2
331 , p6_a13 out nocopy VARCHAR2
332 , p6_a14 out nocopy DATE
333 , p6_a15 out nocopy VARCHAR2
334 , p6_a16 out nocopy VARCHAR2
335 , p6_a17 out nocopy NUMBER
336 , p6_a18 out nocopy VARCHAR2
337 , p6_a19 out nocopy VARCHAR2
338 , p6_a20 out nocopy VARCHAR2
339 , p6_a21 out nocopy VARCHAR2
340 , p6_a22 out nocopy VARCHAR2
341 , p6_a23 out nocopy VARCHAR2
342 , p6_a24 out nocopy VARCHAR2
343 , p6_a25 out nocopy VARCHAR2
344 , p6_a26 out nocopy VARCHAR2
345 , p6_a27 out nocopy VARCHAR2
346 , p6_a28 out nocopy VARCHAR2
347 , p6_a29 out nocopy VARCHAR2
348 , p6_a30 out nocopy VARCHAR2
349 , p6_a31 out nocopy VARCHAR2
350 , p6_a32 out nocopy VARCHAR2
351 , p6_a33 out nocopy VARCHAR2
352 , p6_a34 out nocopy VARCHAR2
353 , p6_a35 out nocopy VARCHAR2
354 , p6_a36 out nocopy VARCHAR2
355 , p6_a37 out nocopy NUMBER
356 , p6_a38 out nocopy VARCHAR2
357 , p6_a39 out nocopy NUMBER
358 , p6_a40 out nocopy VARCHAR2
359 , p6_a41 out nocopy VARCHAR2
360 , p6_a42 out nocopy NUMBER
361 , p6_a43 out nocopy NUMBER
362 , p6_a44 out nocopy NUMBER
363 , p6_a45 out nocopy NUMBER
364 , p6_a46 out nocopy NUMBER
365 , p6_a47 out nocopy NUMBER
366 , p6_a48 out nocopy DATE
367 , p6_a49 out nocopy NUMBER
368 , p6_a50 out nocopy DATE
369 , p6_a51 out nocopy NUMBER
370 , p6_a52 out nocopy DATE
371 , p6_a53 out nocopy NUMBER
372 , p6_a54 out nocopy NUMBER
373 , p6_a55 out nocopy VARCHAR2
374 , p6_a56 out nocopy NUMBER
375 , p6_a57 out nocopy VARCHAR2
376 , p6_a58 out nocopy DATE
377 , p6_a59 out nocopy VARCHAR2
378 , p6_a60 out nocopy VARCHAR2
379 , p6_a61 out nocopy VARCHAR2
380 , p6_a62 out nocopy VARCHAR2
381 , p6_a63 out nocopy VARCHAR2
382 , p6_a64 out nocopy VARCHAR2
383 , p6_a65 out nocopy VARCHAR2
384 , p6_a66 out nocopy VARCHAR2
385 , p6_a67 out nocopy VARCHAR2
386 , p6_a68 out nocopy VARCHAR2
387 , p6_a69 out nocopy VARCHAR2
388 , p6_a70 out nocopy VARCHAR2
389 , p6_a71 out nocopy VARCHAR2
390 , p6_a72 out nocopy VARCHAR2
391 , p6_a73 out nocopy VARCHAR2
392 , p6_a74 out nocopy VARCHAR2
393 , p6_a75 out nocopy VARCHAR2
394 , p6_a76 out nocopy VARCHAR2
395 , p6_a77 out nocopy NUMBER
396 , p6_a78 out nocopy DATE
397 , p6_a79 out nocopy NUMBER
398 , p6_a80 out nocopy NUMBER
399 , p6_a81 out nocopy VARCHAR2
400 , p6_a82 out nocopy DATE
401 , p6_a83 out nocopy NUMBER
402 , p6_a84 out nocopy DATE
403 , p6_a85 out nocopy VARCHAR2
404 , p6_a86 out nocopy VARCHAR2
405 , p6_a87 out nocopy VARCHAR2
406 , p6_a88 out nocopy VARCHAR2
407 , p6_a89 out nocopy VARCHAR2
408 , p6_a90 out nocopy VARCHAR2
409 , p6_a91 out nocopy VARCHAR2
410 , p6_a92 out nocopy VARCHAR2
411 , p6_a93 out nocopy DATE
412 , p5_a0 NUMBER := 0-1962.0724
413 , p5_a1 NUMBER := 0-1962.0724
414 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
415 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
416 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a6 NUMBER := 0-1962.0724
419 , p5_a7 NUMBER := 0-1962.0724
420 , p5_a8 NUMBER := 0-1962.0724
421 , p5_a9 NUMBER := 0-1962.0724
422 , p5_a10 NUMBER := 0-1962.0724
423 , p5_a11 NUMBER := 0-1962.0724
424 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
425 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
426 , p5_a14 DATE := fnd_api.g_miss_date
427 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
428 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
429 , p5_a17 NUMBER := 0-1962.0724
430 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
431 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
432 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
433 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
434 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
435 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
436 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
437 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
438 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
439 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
440 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
441 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
442 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
443 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
444 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
445 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
446 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
447 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
448 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
449 , p5_a37 NUMBER := 0-1962.0724
450 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
451 , p5_a39 NUMBER := 0-1962.0724
452 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
453 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
454 , p5_a42 NUMBER := 0-1962.0724
455 , p5_a43 NUMBER := 0-1962.0724
456 , p5_a44 NUMBER := 0-1962.0724
457 , p5_a45 NUMBER := 0-1962.0724
458 , p5_a46 NUMBER := 0-1962.0724
459 , p5_a47 NUMBER := 0-1962.0724
460 , p5_a48 DATE := fnd_api.g_miss_date
461 , p5_a49 NUMBER := 0-1962.0724
462 , p5_a50 DATE := fnd_api.g_miss_date
463 , p5_a51 NUMBER := 0-1962.0724
464 , p5_a52 DATE := fnd_api.g_miss_date
465 , p5_a53 NUMBER := 0-1962.0724
466 , p5_a54 NUMBER := 0-1962.0724
467 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
468 , p5_a56 NUMBER := 0-1962.0724
469 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
470 , p5_a58 DATE := fnd_api.g_miss_date
471 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
472 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
473 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
474 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
475 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
476 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
477 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
478 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
479 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
480 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
481 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
482 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
483 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
484 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
485 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
487 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a77 NUMBER := 0-1962.0724
490 , p5_a78 DATE := fnd_api.g_miss_date
491 , p5_a79 NUMBER := 0-1962.0724
492 , p5_a80 NUMBER := 0-1962.0724
493 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
494 , p5_a82 DATE := fnd_api.g_miss_date
495 , p5_a83 NUMBER := 0-1962.0724
496 , p5_a84 DATE := fnd_api.g_miss_date
497 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
499 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
500 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
501 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
502 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
503 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
504 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
505 , p5_a93 DATE := fnd_api.g_miss_date
506 );
507 procedure create_trx_contracts(p_api_version NUMBER
508 , p_init_msg_list VARCHAR2
509 , x_return_status out nocopy VARCHAR2
510 , x_msg_count out nocopy NUMBER
511 , x_msg_data out nocopy VARCHAR2
512 , p5_a0 JTF_NUMBER_TABLE
513 , p5_a1 JTF_NUMBER_TABLE
514 , p5_a2 JTF_VARCHAR2_TABLE_100
515 , p5_a3 JTF_VARCHAR2_TABLE_100
516 , p5_a4 JTF_VARCHAR2_TABLE_100
517 , p5_a5 JTF_VARCHAR2_TABLE_100
518 , p5_a6 JTF_NUMBER_TABLE
519 , p5_a7 JTF_NUMBER_TABLE
520 , p5_a8 JTF_NUMBER_TABLE
521 , p5_a9 JTF_NUMBER_TABLE
522 , p5_a10 JTF_NUMBER_TABLE
523 , p5_a11 JTF_NUMBER_TABLE
524 , p5_a12 JTF_VARCHAR2_TABLE_100
525 , p5_a13 JTF_VARCHAR2_TABLE_100
526 , p5_a14 JTF_DATE_TABLE
527 , p5_a15 JTF_VARCHAR2_TABLE_100
528 , p5_a16 JTF_VARCHAR2_TABLE_100
529 , p5_a17 JTF_NUMBER_TABLE
530 , p5_a18 JTF_VARCHAR2_TABLE_200
531 , p5_a19 JTF_VARCHAR2_TABLE_100
532 , p5_a20 JTF_VARCHAR2_TABLE_500
533 , p5_a21 JTF_VARCHAR2_TABLE_500
534 , p5_a22 JTF_VARCHAR2_TABLE_500
535 , p5_a23 JTF_VARCHAR2_TABLE_500
536 , p5_a24 JTF_VARCHAR2_TABLE_500
537 , p5_a25 JTF_VARCHAR2_TABLE_500
538 , p5_a26 JTF_VARCHAR2_TABLE_500
539 , p5_a27 JTF_VARCHAR2_TABLE_500
540 , p5_a28 JTF_VARCHAR2_TABLE_500
541 , p5_a29 JTF_VARCHAR2_TABLE_500
542 , p5_a30 JTF_VARCHAR2_TABLE_500
543 , p5_a31 JTF_VARCHAR2_TABLE_500
544 , p5_a32 JTF_VARCHAR2_TABLE_500
545 , p5_a33 JTF_VARCHAR2_TABLE_500
546 , p5_a34 JTF_VARCHAR2_TABLE_500
547 , p5_a35 JTF_VARCHAR2_TABLE_100
548 , p5_a36 JTF_VARCHAR2_TABLE_100
549 , p5_a37 JTF_NUMBER_TABLE
550 , p5_a38 JTF_VARCHAR2_TABLE_100
551 , p5_a39 JTF_NUMBER_TABLE
552 , p5_a40 JTF_VARCHAR2_TABLE_100
553 , p5_a41 JTF_VARCHAR2_TABLE_100
554 , p5_a42 JTF_NUMBER_TABLE
555 , p5_a43 JTF_NUMBER_TABLE
556 , p5_a44 JTF_NUMBER_TABLE
557 , p5_a45 JTF_NUMBER_TABLE
558 , p5_a46 JTF_NUMBER_TABLE
559 , p5_a47 JTF_NUMBER_TABLE
560 , p5_a48 JTF_DATE_TABLE
561 , p5_a49 JTF_NUMBER_TABLE
562 , p5_a50 JTF_DATE_TABLE
563 , p5_a51 JTF_NUMBER_TABLE
564 , p5_a52 JTF_DATE_TABLE
565 , p5_a53 JTF_NUMBER_TABLE
566 , p5_a54 JTF_NUMBER_TABLE
567 , p5_a55 JTF_VARCHAR2_TABLE_100
568 , p5_a56 JTF_NUMBER_TABLE
569 , p5_a57 JTF_VARCHAR2_TABLE_2000
570 , p5_a58 JTF_DATE_TABLE
571 , p5_a59 JTF_VARCHAR2_TABLE_100
572 , p5_a60 JTF_VARCHAR2_TABLE_100
573 , p5_a61 JTF_VARCHAR2_TABLE_100
574 , p5_a62 JTF_VARCHAR2_TABLE_100
575 , p5_a63 JTF_VARCHAR2_TABLE_100
576 , p5_a64 JTF_VARCHAR2_TABLE_100
577 , p5_a65 JTF_VARCHAR2_TABLE_100
578 , p5_a66 JTF_VARCHAR2_TABLE_100
579 , p5_a67 JTF_VARCHAR2_TABLE_100
580 , p5_a68 JTF_VARCHAR2_TABLE_100
581 , p5_a69 JTF_VARCHAR2_TABLE_100
582 , p5_a70 JTF_VARCHAR2_TABLE_100
583 , p5_a71 JTF_VARCHAR2_TABLE_100
584 , p5_a72 JTF_VARCHAR2_TABLE_100
585 , p5_a73 JTF_VARCHAR2_TABLE_100
586 , p5_a74 JTF_VARCHAR2_TABLE_100
587 , p5_a75 JTF_VARCHAR2_TABLE_100
588 , p5_a76 JTF_VARCHAR2_TABLE_100
589 , p5_a77 JTF_NUMBER_TABLE
590 , p5_a78 JTF_DATE_TABLE
591 , p5_a79 JTF_NUMBER_TABLE
592 , p5_a80 JTF_NUMBER_TABLE
593 , p5_a81 JTF_VARCHAR2_TABLE_100
594 , p5_a82 JTF_DATE_TABLE
595 , p5_a83 JTF_NUMBER_TABLE
596 , p5_a84 JTF_DATE_TABLE
597 , p5_a85 JTF_VARCHAR2_TABLE_100
598 , p5_a86 JTF_VARCHAR2_TABLE_200
599 , p5_a87 JTF_VARCHAR2_TABLE_100
600 , p5_a88 JTF_VARCHAR2_TABLE_200
601 , p5_a89 JTF_VARCHAR2_TABLE_100
602 , p5_a90 JTF_VARCHAR2_TABLE_100
603 , p5_a91 JTF_VARCHAR2_TABLE_100
604 , p5_a92 JTF_VARCHAR2_TABLE_100
605 , p5_a93 JTF_DATE_TABLE
606 , p6_a0 out nocopy JTF_NUMBER_TABLE
607 , p6_a1 out nocopy JTF_NUMBER_TABLE
608 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
609 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
610 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
611 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
612 , p6_a6 out nocopy JTF_NUMBER_TABLE
613 , p6_a7 out nocopy JTF_NUMBER_TABLE
614 , p6_a8 out nocopy JTF_NUMBER_TABLE
615 , p6_a9 out nocopy JTF_NUMBER_TABLE
616 , p6_a10 out nocopy JTF_NUMBER_TABLE
617 , p6_a11 out nocopy JTF_NUMBER_TABLE
618 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
619 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
620 , p6_a14 out nocopy JTF_DATE_TABLE
621 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
622 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
623 , p6_a17 out nocopy JTF_NUMBER_TABLE
624 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
625 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
626 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
627 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
628 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
629 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
630 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
631 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
632 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
633 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
634 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
635 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
636 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
637 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
638 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
639 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
640 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
641 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
642 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
643 , p6_a37 out nocopy JTF_NUMBER_TABLE
644 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
645 , p6_a39 out nocopy JTF_NUMBER_TABLE
646 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
647 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
648 , p6_a42 out nocopy JTF_NUMBER_TABLE
649 , p6_a43 out nocopy JTF_NUMBER_TABLE
650 , p6_a44 out nocopy JTF_NUMBER_TABLE
651 , p6_a45 out nocopy JTF_NUMBER_TABLE
652 , p6_a46 out nocopy JTF_NUMBER_TABLE
653 , p6_a47 out nocopy JTF_NUMBER_TABLE
654 , p6_a48 out nocopy JTF_DATE_TABLE
655 , p6_a49 out nocopy JTF_NUMBER_TABLE
656 , p6_a50 out nocopy JTF_DATE_TABLE
657 , p6_a51 out nocopy JTF_NUMBER_TABLE
658 , p6_a52 out nocopy JTF_DATE_TABLE
659 , p6_a53 out nocopy JTF_NUMBER_TABLE
660 , p6_a54 out nocopy JTF_NUMBER_TABLE
661 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
662 , p6_a56 out nocopy JTF_NUMBER_TABLE
663 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_2000
664 , p6_a58 out nocopy JTF_DATE_TABLE
665 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
666 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
667 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
668 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
669 , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
670 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
671 , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
672 , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
673 , p6_a67 out nocopy JTF_VARCHAR2_TABLE_100
674 , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
675 , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
676 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
677 , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
678 , p6_a72 out nocopy JTF_VARCHAR2_TABLE_100
679 , p6_a73 out nocopy JTF_VARCHAR2_TABLE_100
680 , p6_a74 out nocopy JTF_VARCHAR2_TABLE_100
681 , p6_a75 out nocopy JTF_VARCHAR2_TABLE_100
682 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
683 , p6_a77 out nocopy JTF_NUMBER_TABLE
684 , p6_a78 out nocopy JTF_DATE_TABLE
685 , p6_a79 out nocopy JTF_NUMBER_TABLE
686 , p6_a80 out nocopy JTF_NUMBER_TABLE
687 , p6_a81 out nocopy JTF_VARCHAR2_TABLE_100
688 , p6_a82 out nocopy JTF_DATE_TABLE
689 , p6_a83 out nocopy JTF_NUMBER_TABLE
690 , p6_a84 out nocopy JTF_DATE_TABLE
691 , p6_a85 out nocopy JTF_VARCHAR2_TABLE_100
692 , p6_a86 out nocopy JTF_VARCHAR2_TABLE_200
693 , p6_a87 out nocopy JTF_VARCHAR2_TABLE_100
694 , p6_a88 out nocopy JTF_VARCHAR2_TABLE_200
695 , p6_a89 out nocopy JTF_VARCHAR2_TABLE_100
696 , p6_a90 out nocopy JTF_VARCHAR2_TABLE_100
697 , p6_a91 out nocopy JTF_VARCHAR2_TABLE_100
698 , p6_a92 out nocopy JTF_VARCHAR2_TABLE_100
699 , p6_a93 out nocopy JTF_DATE_TABLE
700 );
701 procedure create_trx_cntrct_lines(p_api_version NUMBER
702 , p_init_msg_list VARCHAR2
703 , x_return_status out nocopy VARCHAR2
704 , x_msg_count out nocopy NUMBER
705 , x_msg_data out nocopy VARCHAR2
706 , p6_a0 out nocopy NUMBER
707 , p6_a1 out nocopy NUMBER
708 , p6_a2 out nocopy NUMBER
709 , p6_a3 out nocopy NUMBER
710 , p6_a4 out nocopy NUMBER
711 , p6_a5 out nocopy NUMBER
712 , p6_a6 out nocopy NUMBER
713 , p6_a7 out nocopy NUMBER
714 , p6_a8 out nocopy VARCHAR2
715 , p6_a9 out nocopy NUMBER
716 , p6_a10 out nocopy VARCHAR2
717 , p6_a11 out nocopy NUMBER
718 , p6_a12 out nocopy VARCHAR2
719 , p6_a13 out nocopy VARCHAR2
720 , p6_a14 out nocopy VARCHAR2
721 , p6_a15 out nocopy VARCHAR2
722 , p6_a16 out nocopy VARCHAR2
723 , p6_a17 out nocopy VARCHAR2
724 , p6_a18 out nocopy VARCHAR2
725 , p6_a19 out nocopy VARCHAR2
726 , p6_a20 out nocopy VARCHAR2
727 , p6_a21 out nocopy VARCHAR2
728 , p6_a22 out nocopy VARCHAR2
729 , p6_a23 out nocopy VARCHAR2
730 , p6_a24 out nocopy VARCHAR2
731 , p6_a25 out nocopy VARCHAR2
732 , p6_a26 out nocopy VARCHAR2
733 , p6_a27 out nocopy VARCHAR2
734 , p6_a28 out nocopy VARCHAR2
735 , p6_a29 out nocopy VARCHAR2
736 , p6_a30 out nocopy VARCHAR2
737 , p6_a31 out nocopy NUMBER
738 , p6_a32 out nocopy DATE
739 , p6_a33 out nocopy NUMBER
740 , p6_a34 out nocopy DATE
741 , p6_a35 out nocopy NUMBER
742 , p6_a36 out nocopy NUMBER
743 , p6_a37 out nocopy NUMBER
744 , p6_a38 out nocopy NUMBER
745 , p6_a39 out nocopy DATE
746 , p6_a40 out nocopy NUMBER
747 , p6_a41 out nocopy NUMBER
748 , p6_a42 out nocopy NUMBER
749 , p6_a43 out nocopy NUMBER
750 , p6_a44 out nocopy NUMBER
751 , p6_a45 out nocopy VARCHAR2
752 , p6_a46 out nocopy VARCHAR2
753 , p6_a47 out nocopy NUMBER
754 , p6_a48 out nocopy VARCHAR2
755 , p6_a49 out nocopy NUMBER
756 , p6_a50 out nocopy VARCHAR2
757 , p6_a51 out nocopy NUMBER
758 , p6_a52 out nocopy DATE
759 , p6_a53 out nocopy NUMBER
760 , p6_a54 out nocopy VARCHAR2
761 , p6_a55 out nocopy VARCHAR2
762 , p6_a56 out nocopy VARCHAR2
763 , p6_a57 out nocopy VARCHAR2
764 , p5_a0 NUMBER := 0-1962.0724
765 , p5_a1 NUMBER := 0-1962.0724
766 , p5_a2 NUMBER := 0-1962.0724
767 , p5_a3 NUMBER := 0-1962.0724
768 , p5_a4 NUMBER := 0-1962.0724
769 , p5_a5 NUMBER := 0-1962.0724
770 , p5_a6 NUMBER := 0-1962.0724
771 , p5_a7 NUMBER := 0-1962.0724
772 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a9 NUMBER := 0-1962.0724
774 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a11 NUMBER := 0-1962.0724
776 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795 , p5_a31 NUMBER := 0-1962.0724
796 , p5_a32 DATE := fnd_api.g_miss_date
797 , p5_a33 NUMBER := 0-1962.0724
798 , p5_a34 DATE := fnd_api.g_miss_date
799 , p5_a35 NUMBER := 0-1962.0724
800 , p5_a36 NUMBER := 0-1962.0724
801 , p5_a37 NUMBER := 0-1962.0724
802 , p5_a38 NUMBER := 0-1962.0724
803 , p5_a39 DATE := fnd_api.g_miss_date
804 , p5_a40 NUMBER := 0-1962.0724
805 , p5_a41 NUMBER := 0-1962.0724
806 , p5_a42 NUMBER := 0-1962.0724
807 , p5_a43 NUMBER := 0-1962.0724
808 , p5_a44 NUMBER := 0-1962.0724
809 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
810 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
811 , p5_a47 NUMBER := 0-1962.0724
812 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
813 , p5_a49 NUMBER := 0-1962.0724
814 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
815 , p5_a51 NUMBER := 0-1962.0724
816 , p5_a52 DATE := fnd_api.g_miss_date
817 , p5_a53 NUMBER := 0-1962.0724
818 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
819 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
820 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
821 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
822 );
823 procedure create_trx_cntrct_lines(p_api_version NUMBER
824 , p_init_msg_list VARCHAR2
825 , x_return_status out nocopy VARCHAR2
826 , x_msg_count out nocopy NUMBER
827 , x_msg_data out nocopy VARCHAR2
828 , p5_a0 JTF_NUMBER_TABLE
829 , p5_a1 JTF_NUMBER_TABLE
830 , p5_a2 JTF_NUMBER_TABLE
831 , p5_a3 JTF_NUMBER_TABLE
832 , p5_a4 JTF_NUMBER_TABLE
833 , p5_a5 JTF_NUMBER_TABLE
834 , p5_a6 JTF_NUMBER_TABLE
835 , p5_a7 JTF_NUMBER_TABLE
836 , p5_a8 JTF_VARCHAR2_TABLE_100
837 , p5_a9 JTF_NUMBER_TABLE
838 , p5_a10 JTF_VARCHAR2_TABLE_2000
839 , p5_a11 JTF_NUMBER_TABLE
840 , p5_a12 JTF_VARCHAR2_TABLE_200
841 , p5_a13 JTF_VARCHAR2_TABLE_100
842 , p5_a14 JTF_VARCHAR2_TABLE_100
843 , p5_a15 JTF_VARCHAR2_TABLE_500
844 , p5_a16 JTF_VARCHAR2_TABLE_500
845 , p5_a17 JTF_VARCHAR2_TABLE_500
846 , p5_a18 JTF_VARCHAR2_TABLE_500
847 , p5_a19 JTF_VARCHAR2_TABLE_500
848 , p5_a20 JTF_VARCHAR2_TABLE_500
849 , p5_a21 JTF_VARCHAR2_TABLE_500
850 , p5_a22 JTF_VARCHAR2_TABLE_500
851 , p5_a23 JTF_VARCHAR2_TABLE_500
852 , p5_a24 JTF_VARCHAR2_TABLE_500
853 , p5_a25 JTF_VARCHAR2_TABLE_500
854 , p5_a26 JTF_VARCHAR2_TABLE_500
855 , p5_a27 JTF_VARCHAR2_TABLE_500
856 , p5_a28 JTF_VARCHAR2_TABLE_500
857 , p5_a29 JTF_VARCHAR2_TABLE_500
858 , p5_a30 JTF_VARCHAR2_TABLE_100
859 , p5_a31 JTF_NUMBER_TABLE
860 , p5_a32 JTF_DATE_TABLE
861 , p5_a33 JTF_NUMBER_TABLE
862 , p5_a34 JTF_DATE_TABLE
863 , p5_a35 JTF_NUMBER_TABLE
864 , p5_a36 JTF_NUMBER_TABLE
865 , p5_a37 JTF_NUMBER_TABLE
866 , p5_a38 JTF_NUMBER_TABLE
867 , p5_a39 JTF_DATE_TABLE
868 , p5_a40 JTF_NUMBER_TABLE
869 , p5_a41 JTF_NUMBER_TABLE
870 , p5_a42 JTF_NUMBER_TABLE
871 , p5_a43 JTF_NUMBER_TABLE
872 , p5_a44 JTF_NUMBER_TABLE
873 , p5_a45 JTF_VARCHAR2_TABLE_100
874 , p5_a46 JTF_VARCHAR2_TABLE_200
875 , p5_a47 JTF_NUMBER_TABLE
876 , p5_a48 JTF_VARCHAR2_TABLE_200
877 , p5_a49 JTF_NUMBER_TABLE
878 , p5_a50 JTF_VARCHAR2_TABLE_200
879 , p5_a51 JTF_NUMBER_TABLE
880 , p5_a52 JTF_DATE_TABLE
881 , p5_a53 JTF_NUMBER_TABLE
882 , p5_a54 JTF_VARCHAR2_TABLE_200
883 , p5_a55 JTF_VARCHAR2_TABLE_300
884 , p5_a56 JTF_VARCHAR2_TABLE_100
885 , p5_a57 JTF_VARCHAR2_TABLE_100
886 , p6_a0 out nocopy JTF_NUMBER_TABLE
887 , p6_a1 out nocopy JTF_NUMBER_TABLE
888 , p6_a2 out nocopy JTF_NUMBER_TABLE
889 , p6_a3 out nocopy JTF_NUMBER_TABLE
890 , p6_a4 out nocopy JTF_NUMBER_TABLE
891 , p6_a5 out nocopy JTF_NUMBER_TABLE
892 , p6_a6 out nocopy JTF_NUMBER_TABLE
893 , p6_a7 out nocopy JTF_NUMBER_TABLE
894 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
895 , p6_a9 out nocopy JTF_NUMBER_TABLE
896 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
897 , p6_a11 out nocopy JTF_NUMBER_TABLE
898 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
899 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
900 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
901 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
902 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
903 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
904 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
905 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
906 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
907 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
908 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
909 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
910 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
911 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
912 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
913 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
914 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
915 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
916 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
917 , p6_a31 out nocopy JTF_NUMBER_TABLE
918 , p6_a32 out nocopy JTF_DATE_TABLE
919 , p6_a33 out nocopy JTF_NUMBER_TABLE
920 , p6_a34 out nocopy JTF_DATE_TABLE
921 , p6_a35 out nocopy JTF_NUMBER_TABLE
922 , p6_a36 out nocopy JTF_NUMBER_TABLE
923 , p6_a37 out nocopy JTF_NUMBER_TABLE
924 , p6_a38 out nocopy JTF_NUMBER_TABLE
925 , p6_a39 out nocopy JTF_DATE_TABLE
926 , p6_a40 out nocopy JTF_NUMBER_TABLE
927 , p6_a41 out nocopy JTF_NUMBER_TABLE
928 , p6_a42 out nocopy JTF_NUMBER_TABLE
929 , p6_a43 out nocopy JTF_NUMBER_TABLE
930 , p6_a44 out nocopy JTF_NUMBER_TABLE
931 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
932 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_200
933 , p6_a47 out nocopy JTF_NUMBER_TABLE
934 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_200
935 , p6_a49 out nocopy JTF_NUMBER_TABLE
936 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_200
937 , p6_a51 out nocopy JTF_NUMBER_TABLE
938 , p6_a52 out nocopy JTF_DATE_TABLE
939 , p6_a53 out nocopy JTF_NUMBER_TABLE
940 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_200
941 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_300
942 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
943 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
944 );
945 procedure update_trx_contracts(p_api_version NUMBER
946 , p_init_msg_list VARCHAR2
947 , x_return_status out nocopy VARCHAR2
948 , x_msg_count out nocopy NUMBER
949 , x_msg_data out nocopy VARCHAR2
950 , p6_a0 JTF_NUMBER_TABLE
951 , p6_a1 JTF_NUMBER_TABLE
952 , p6_a2 JTF_NUMBER_TABLE
953 , p6_a3 JTF_NUMBER_TABLE
954 , p6_a4 JTF_NUMBER_TABLE
955 , p6_a5 JTF_NUMBER_TABLE
956 , p6_a6 JTF_NUMBER_TABLE
957 , p6_a7 JTF_NUMBER_TABLE
958 , p6_a8 JTF_VARCHAR2_TABLE_100
959 , p6_a9 JTF_NUMBER_TABLE
960 , p6_a10 JTF_VARCHAR2_TABLE_2000
961 , p6_a11 JTF_NUMBER_TABLE
962 , p6_a12 JTF_VARCHAR2_TABLE_200
963 , p6_a13 JTF_VARCHAR2_TABLE_100
964 , p6_a14 JTF_VARCHAR2_TABLE_100
965 , p6_a15 JTF_VARCHAR2_TABLE_500
966 , p6_a16 JTF_VARCHAR2_TABLE_500
967 , p6_a17 JTF_VARCHAR2_TABLE_500
968 , p6_a18 JTF_VARCHAR2_TABLE_500
969 , p6_a19 JTF_VARCHAR2_TABLE_500
970 , p6_a20 JTF_VARCHAR2_TABLE_500
971 , p6_a21 JTF_VARCHAR2_TABLE_500
972 , p6_a22 JTF_VARCHAR2_TABLE_500
973 , p6_a23 JTF_VARCHAR2_TABLE_500
974 , p6_a24 JTF_VARCHAR2_TABLE_500
975 , p6_a25 JTF_VARCHAR2_TABLE_500
976 , p6_a26 JTF_VARCHAR2_TABLE_500
977 , p6_a27 JTF_VARCHAR2_TABLE_500
978 , p6_a28 JTF_VARCHAR2_TABLE_500
979 , p6_a29 JTF_VARCHAR2_TABLE_500
980 , p6_a30 JTF_VARCHAR2_TABLE_100
981 , p6_a31 JTF_NUMBER_TABLE
982 , p6_a32 JTF_DATE_TABLE
983 , p6_a33 JTF_NUMBER_TABLE
984 , p6_a34 JTF_DATE_TABLE
985 , p6_a35 JTF_NUMBER_TABLE
986 , p6_a36 JTF_NUMBER_TABLE
987 , p6_a37 JTF_NUMBER_TABLE
988 , p6_a38 JTF_NUMBER_TABLE
989 , p6_a39 JTF_DATE_TABLE
990 , p6_a40 JTF_NUMBER_TABLE
991 , p6_a41 JTF_NUMBER_TABLE
992 , p6_a42 JTF_NUMBER_TABLE
993 , p6_a43 JTF_NUMBER_TABLE
994 , p6_a44 JTF_NUMBER_TABLE
995 , p6_a45 JTF_VARCHAR2_TABLE_100
996 , p6_a46 JTF_VARCHAR2_TABLE_200
997 , p6_a47 JTF_NUMBER_TABLE
998 , p6_a48 JTF_VARCHAR2_TABLE_200
999 , p6_a49 JTF_NUMBER_TABLE
1000 , p6_a50 JTF_VARCHAR2_TABLE_200
1001 , p6_a51 JTF_NUMBER_TABLE
1002 , p6_a52 JTF_DATE_TABLE
1003 , p6_a53 JTF_NUMBER_TABLE
1004 , p6_a54 JTF_VARCHAR2_TABLE_200
1005 , p6_a55 JTF_VARCHAR2_TABLE_300
1006 , p6_a56 JTF_VARCHAR2_TABLE_100
1007 , p6_a57 JTF_VARCHAR2_TABLE_100
1008 , p7_a0 out nocopy NUMBER
1009 , p7_a1 out nocopy NUMBER
1010 , p7_a2 out nocopy VARCHAR2
1011 , p7_a3 out nocopy VARCHAR2
1012 , p7_a4 out nocopy VARCHAR2
1013 , p7_a5 out nocopy VARCHAR2
1014 , p7_a6 out nocopy NUMBER
1015 , p7_a7 out nocopy NUMBER
1016 , p7_a8 out nocopy NUMBER
1017 , p7_a9 out nocopy NUMBER
1018 , p7_a10 out nocopy NUMBER
1019 , p7_a11 out nocopy NUMBER
1020 , p7_a12 out nocopy VARCHAR2
1021 , p7_a13 out nocopy VARCHAR2
1022 , p7_a14 out nocopy DATE
1023 , p7_a15 out nocopy VARCHAR2
1024 , p7_a16 out nocopy VARCHAR2
1025 , p7_a17 out nocopy NUMBER
1026 , p7_a18 out nocopy VARCHAR2
1027 , p7_a19 out nocopy VARCHAR2
1028 , p7_a20 out nocopy VARCHAR2
1029 , p7_a21 out nocopy VARCHAR2
1030 , p7_a22 out nocopy VARCHAR2
1031 , p7_a23 out nocopy VARCHAR2
1032 , p7_a24 out nocopy VARCHAR2
1033 , p7_a25 out nocopy VARCHAR2
1034 , p7_a26 out nocopy VARCHAR2
1035 , p7_a27 out nocopy VARCHAR2
1036 , p7_a28 out nocopy VARCHAR2
1037 , p7_a29 out nocopy VARCHAR2
1038 , p7_a30 out nocopy VARCHAR2
1039 , p7_a31 out nocopy VARCHAR2
1040 , p7_a32 out nocopy VARCHAR2
1041 , p7_a33 out nocopy VARCHAR2
1042 , p7_a34 out nocopy VARCHAR2
1043 , p7_a35 out nocopy VARCHAR2
1044 , p7_a36 out nocopy VARCHAR2
1045 , p7_a37 out nocopy NUMBER
1046 , p7_a38 out nocopy VARCHAR2
1047 , p7_a39 out nocopy NUMBER
1048 , p7_a40 out nocopy VARCHAR2
1049 , p7_a41 out nocopy VARCHAR2
1050 , p7_a42 out nocopy NUMBER
1051 , p7_a43 out nocopy NUMBER
1052 , p7_a44 out nocopy NUMBER
1053 , p7_a45 out nocopy NUMBER
1054 , p7_a46 out nocopy NUMBER
1055 , p7_a47 out nocopy NUMBER
1056 , p7_a48 out nocopy DATE
1057 , p7_a49 out nocopy NUMBER
1058 , p7_a50 out nocopy DATE
1059 , p7_a51 out nocopy NUMBER
1060 , p7_a52 out nocopy DATE
1061 , p7_a53 out nocopy NUMBER
1062 , p7_a54 out nocopy NUMBER
1063 , p7_a55 out nocopy VARCHAR2
1064 , p7_a56 out nocopy NUMBER
1065 , p7_a57 out nocopy VARCHAR2
1066 , p7_a58 out nocopy DATE
1067 , p7_a59 out nocopy VARCHAR2
1068 , p7_a60 out nocopy VARCHAR2
1069 , p7_a61 out nocopy VARCHAR2
1070 , p7_a62 out nocopy VARCHAR2
1071 , p7_a63 out nocopy VARCHAR2
1072 , p7_a64 out nocopy VARCHAR2
1073 , p7_a65 out nocopy VARCHAR2
1074 , p7_a66 out nocopy VARCHAR2
1075 , p7_a67 out nocopy VARCHAR2
1076 , p7_a68 out nocopy VARCHAR2
1077 , p7_a69 out nocopy VARCHAR2
1078 , p7_a70 out nocopy VARCHAR2
1079 , p7_a71 out nocopy VARCHAR2
1080 , p7_a72 out nocopy VARCHAR2
1081 , p7_a73 out nocopy VARCHAR2
1082 , p7_a74 out nocopy VARCHAR2
1083 , p7_a75 out nocopy VARCHAR2
1084 , p7_a76 out nocopy VARCHAR2
1085 , p7_a77 out nocopy NUMBER
1086 , p7_a78 out nocopy DATE
1087 , p7_a79 out nocopy NUMBER
1088 , p7_a80 out nocopy NUMBER
1089 , p7_a81 out nocopy VARCHAR2
1090 , p7_a82 out nocopy DATE
1091 , p7_a83 out nocopy NUMBER
1092 , p7_a84 out nocopy DATE
1093 , p7_a85 out nocopy VARCHAR2
1094 , p7_a86 out nocopy VARCHAR2
1095 , p7_a87 out nocopy VARCHAR2
1096 , p7_a88 out nocopy VARCHAR2
1097 , p7_a89 out nocopy VARCHAR2
1098 , p7_a90 out nocopy VARCHAR2
1099 , p7_a91 out nocopy VARCHAR2
1100 , p7_a92 out nocopy VARCHAR2
1101 , p7_a93 out nocopy DATE
1102 , p8_a0 out nocopy JTF_NUMBER_TABLE
1103 , p8_a1 out nocopy JTF_NUMBER_TABLE
1104 , p8_a2 out nocopy JTF_NUMBER_TABLE
1105 , p8_a3 out nocopy JTF_NUMBER_TABLE
1106 , p8_a4 out nocopy JTF_NUMBER_TABLE
1107 , p8_a5 out nocopy JTF_NUMBER_TABLE
1108 , p8_a6 out nocopy JTF_NUMBER_TABLE
1109 , p8_a7 out nocopy JTF_NUMBER_TABLE
1110 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
1111 , p8_a9 out nocopy JTF_NUMBER_TABLE
1112 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1113 , p8_a11 out nocopy JTF_NUMBER_TABLE
1114 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
1115 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1116 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1117 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
1118 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
1119 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
1120 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
1121 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
1122 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
1123 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
1124 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
1125 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
1126 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
1127 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_500
1128 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_500
1129 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_500
1130 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_500
1131 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
1132 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
1133 , p8_a31 out nocopy JTF_NUMBER_TABLE
1134 , p8_a32 out nocopy JTF_DATE_TABLE
1135 , p8_a33 out nocopy JTF_NUMBER_TABLE
1136 , p8_a34 out nocopy JTF_DATE_TABLE
1137 , p8_a35 out nocopy JTF_NUMBER_TABLE
1138 , p8_a36 out nocopy JTF_NUMBER_TABLE
1139 , p8_a37 out nocopy JTF_NUMBER_TABLE
1140 , p8_a38 out nocopy JTF_NUMBER_TABLE
1141 , p8_a39 out nocopy JTF_DATE_TABLE
1142 , p8_a40 out nocopy JTF_NUMBER_TABLE
1143 , p8_a41 out nocopy JTF_NUMBER_TABLE
1144 , p8_a42 out nocopy JTF_NUMBER_TABLE
1145 , p8_a43 out nocopy JTF_NUMBER_TABLE
1146 , p8_a44 out nocopy JTF_NUMBER_TABLE
1147 , p8_a45 out nocopy JTF_VARCHAR2_TABLE_100
1148 , p8_a46 out nocopy JTF_VARCHAR2_TABLE_200
1149 , p8_a47 out nocopy JTF_NUMBER_TABLE
1150 , p8_a48 out nocopy JTF_VARCHAR2_TABLE_200
1151 , p8_a49 out nocopy JTF_NUMBER_TABLE
1152 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_200
1153 , p8_a51 out nocopy JTF_NUMBER_TABLE
1154 , p8_a52 out nocopy JTF_DATE_TABLE
1155 , p8_a53 out nocopy JTF_NUMBER_TABLE
1156 , p8_a54 out nocopy JTF_VARCHAR2_TABLE_200
1157 , p8_a55 out nocopy JTF_VARCHAR2_TABLE_300
1158 , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
1159 , p8_a57 out nocopy JTF_VARCHAR2_TABLE_100
1160 , p5_a0 NUMBER := 0-1962.0724
1161 , p5_a1 NUMBER := 0-1962.0724
1162 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1163 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1164 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1165 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1166 , p5_a6 NUMBER := 0-1962.0724
1167 , p5_a7 NUMBER := 0-1962.0724
1168 , p5_a8 NUMBER := 0-1962.0724
1169 , p5_a9 NUMBER := 0-1962.0724
1170 , p5_a10 NUMBER := 0-1962.0724
1171 , p5_a11 NUMBER := 0-1962.0724
1172 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1173 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1174 , p5_a14 DATE := fnd_api.g_miss_date
1175 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1176 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1177 , p5_a17 NUMBER := 0-1962.0724
1178 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1179 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1180 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1181 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1182 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1183 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1184 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1185 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1186 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1187 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1188 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1189 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1190 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1191 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1192 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1193 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1194 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1195 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1196 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1197 , p5_a37 NUMBER := 0-1962.0724
1198 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1199 , p5_a39 NUMBER := 0-1962.0724
1200 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1201 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1202 , p5_a42 NUMBER := 0-1962.0724
1203 , p5_a43 NUMBER := 0-1962.0724
1204 , p5_a44 NUMBER := 0-1962.0724
1205 , p5_a45 NUMBER := 0-1962.0724
1206 , p5_a46 NUMBER := 0-1962.0724
1207 , p5_a47 NUMBER := 0-1962.0724
1208 , p5_a48 DATE := fnd_api.g_miss_date
1209 , p5_a49 NUMBER := 0-1962.0724
1210 , p5_a50 DATE := fnd_api.g_miss_date
1211 , p5_a51 NUMBER := 0-1962.0724
1212 , p5_a52 DATE := fnd_api.g_miss_date
1213 , p5_a53 NUMBER := 0-1962.0724
1214 , p5_a54 NUMBER := 0-1962.0724
1215 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1216 , p5_a56 NUMBER := 0-1962.0724
1217 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1218 , p5_a58 DATE := fnd_api.g_miss_date
1219 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1220 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1221 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1222 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1223 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1224 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1225 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1226 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
1227 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
1228 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
1229 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1230 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1231 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
1232 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1233 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
1234 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
1235 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1236 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1237 , p5_a77 NUMBER := 0-1962.0724
1238 , p5_a78 DATE := fnd_api.g_miss_date
1239 , p5_a79 NUMBER := 0-1962.0724
1240 , p5_a80 NUMBER := 0-1962.0724
1241 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
1242 , p5_a82 DATE := fnd_api.g_miss_date
1243 , p5_a83 NUMBER := 0-1962.0724
1244 , p5_a84 DATE := fnd_api.g_miss_date
1245 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
1246 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
1247 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
1248 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
1249 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
1250 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
1251 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
1252 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
1253 , p5_a93 DATE := fnd_api.g_miss_date
1254 );
1255 procedure update_trx_contracts(p_api_version NUMBER
1256 , p_init_msg_list VARCHAR2
1257 , x_return_status out nocopy VARCHAR2
1258 , x_msg_count out nocopy NUMBER
1259 , x_msg_data out nocopy VARCHAR2
1260 , p6_a0 out nocopy NUMBER
1261 , p6_a1 out nocopy NUMBER
1262 , p6_a2 out nocopy VARCHAR2
1263 , p6_a3 out nocopy VARCHAR2
1264 , p6_a4 out nocopy VARCHAR2
1265 , p6_a5 out nocopy VARCHAR2
1266 , p6_a6 out nocopy NUMBER
1267 , p6_a7 out nocopy NUMBER
1268 , p6_a8 out nocopy NUMBER
1269 , p6_a9 out nocopy NUMBER
1270 , p6_a10 out nocopy NUMBER
1271 , p6_a11 out nocopy NUMBER
1272 , p6_a12 out nocopy VARCHAR2
1273 , p6_a13 out nocopy VARCHAR2
1274 , p6_a14 out nocopy DATE
1275 , p6_a15 out nocopy VARCHAR2
1276 , p6_a16 out nocopy VARCHAR2
1277 , p6_a17 out nocopy NUMBER
1278 , p6_a18 out nocopy VARCHAR2
1279 , p6_a19 out nocopy VARCHAR2
1280 , p6_a20 out nocopy VARCHAR2
1281 , p6_a21 out nocopy VARCHAR2
1282 , p6_a22 out nocopy VARCHAR2
1283 , p6_a23 out nocopy VARCHAR2
1284 , p6_a24 out nocopy VARCHAR2
1285 , p6_a25 out nocopy VARCHAR2
1286 , p6_a26 out nocopy VARCHAR2
1287 , p6_a27 out nocopy VARCHAR2
1288 , p6_a28 out nocopy VARCHAR2
1289 , p6_a29 out nocopy VARCHAR2
1290 , p6_a30 out nocopy VARCHAR2
1291 , p6_a31 out nocopy VARCHAR2
1292 , p6_a32 out nocopy VARCHAR2
1293 , p6_a33 out nocopy VARCHAR2
1294 , p6_a34 out nocopy VARCHAR2
1295 , p6_a35 out nocopy VARCHAR2
1296 , p6_a36 out nocopy VARCHAR2
1297 , p6_a37 out nocopy NUMBER
1298 , p6_a38 out nocopy VARCHAR2
1299 , p6_a39 out nocopy NUMBER
1300 , p6_a40 out nocopy VARCHAR2
1301 , p6_a41 out nocopy VARCHAR2
1302 , p6_a42 out nocopy NUMBER
1303 , p6_a43 out nocopy NUMBER
1304 , p6_a44 out nocopy NUMBER
1305 , p6_a45 out nocopy NUMBER
1306 , p6_a46 out nocopy NUMBER
1307 , p6_a47 out nocopy NUMBER
1308 , p6_a48 out nocopy DATE
1309 , p6_a49 out nocopy NUMBER
1310 , p6_a50 out nocopy DATE
1311 , p6_a51 out nocopy NUMBER
1312 , p6_a52 out nocopy DATE
1313 , p6_a53 out nocopy NUMBER
1314 , p6_a54 out nocopy NUMBER
1315 , p6_a55 out nocopy VARCHAR2
1316 , p6_a56 out nocopy NUMBER
1317 , p6_a57 out nocopy VARCHAR2
1318 , p6_a58 out nocopy DATE
1319 , p6_a59 out nocopy VARCHAR2
1320 , p6_a60 out nocopy VARCHAR2
1321 , p6_a61 out nocopy VARCHAR2
1322 , p6_a62 out nocopy VARCHAR2
1323 , p6_a63 out nocopy VARCHAR2
1324 , p6_a64 out nocopy VARCHAR2
1325 , p6_a65 out nocopy VARCHAR2
1326 , p6_a66 out nocopy VARCHAR2
1327 , p6_a67 out nocopy VARCHAR2
1328 , p6_a68 out nocopy VARCHAR2
1329 , p6_a69 out nocopy VARCHAR2
1330 , p6_a70 out nocopy VARCHAR2
1331 , p6_a71 out nocopy VARCHAR2
1332 , p6_a72 out nocopy VARCHAR2
1333 , p6_a73 out nocopy VARCHAR2
1334 , p6_a74 out nocopy VARCHAR2
1335 , p6_a75 out nocopy VARCHAR2
1336 , p6_a76 out nocopy VARCHAR2
1337 , p6_a77 out nocopy NUMBER
1338 , p6_a78 out nocopy DATE
1339 , p6_a79 out nocopy NUMBER
1340 , p6_a80 out nocopy NUMBER
1341 , p6_a81 out nocopy VARCHAR2
1342 , p6_a82 out nocopy DATE
1343 , p6_a83 out nocopy NUMBER
1344 , p6_a84 out nocopy DATE
1345 , p6_a85 out nocopy VARCHAR2
1346 , p6_a86 out nocopy VARCHAR2
1347 , p6_a87 out nocopy VARCHAR2
1348 , p6_a88 out nocopy VARCHAR2
1349 , p6_a89 out nocopy VARCHAR2
1350 , p6_a90 out nocopy VARCHAR2
1351 , p6_a91 out nocopy VARCHAR2
1352 , p6_a92 out nocopy VARCHAR2
1353 , p6_a93 out nocopy DATE
1354 , p5_a0 NUMBER := 0-1962.0724
1355 , p5_a1 NUMBER := 0-1962.0724
1356 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1357 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1358 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1359 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1360 , p5_a6 NUMBER := 0-1962.0724
1361 , p5_a7 NUMBER := 0-1962.0724
1362 , p5_a8 NUMBER := 0-1962.0724
1363 , p5_a9 NUMBER := 0-1962.0724
1364 , p5_a10 NUMBER := 0-1962.0724
1365 , p5_a11 NUMBER := 0-1962.0724
1366 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1367 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1368 , p5_a14 DATE := fnd_api.g_miss_date
1369 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1370 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1371 , p5_a17 NUMBER := 0-1962.0724
1372 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1373 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1374 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1375 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1376 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1377 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1378 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1379 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1380 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1381 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1382 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1383 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1384 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1385 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1386 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1387 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1388 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1389 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1390 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1391 , p5_a37 NUMBER := 0-1962.0724
1392 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1393 , p5_a39 NUMBER := 0-1962.0724
1394 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1395 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1396 , p5_a42 NUMBER := 0-1962.0724
1397 , p5_a43 NUMBER := 0-1962.0724
1398 , p5_a44 NUMBER := 0-1962.0724
1399 , p5_a45 NUMBER := 0-1962.0724
1400 , p5_a46 NUMBER := 0-1962.0724
1401 , p5_a47 NUMBER := 0-1962.0724
1402 , p5_a48 DATE := fnd_api.g_miss_date
1403 , p5_a49 NUMBER := 0-1962.0724
1404 , p5_a50 DATE := fnd_api.g_miss_date
1405 , p5_a51 NUMBER := 0-1962.0724
1406 , p5_a52 DATE := fnd_api.g_miss_date
1407 , p5_a53 NUMBER := 0-1962.0724
1408 , p5_a54 NUMBER := 0-1962.0724
1409 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1410 , p5_a56 NUMBER := 0-1962.0724
1411 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1412 , p5_a58 DATE := fnd_api.g_miss_date
1413 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1414 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1415 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1416 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1417 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1418 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1419 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
1421 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
1422 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1427 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
1429 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1430 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1431 , p5_a77 NUMBER := 0-1962.0724
1432 , p5_a78 DATE := fnd_api.g_miss_date
1433 , p5_a79 NUMBER := 0-1962.0724
1434 , p5_a80 NUMBER := 0-1962.0724
1435 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
1436 , p5_a82 DATE := fnd_api.g_miss_date
1437 , p5_a83 NUMBER := 0-1962.0724
1438 , p5_a84 DATE := fnd_api.g_miss_date
1439 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
1440 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
1445 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
1446 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
1447 , p5_a93 DATE := fnd_api.g_miss_date
1448 );
1449 procedure update_trx_contracts(p_api_version NUMBER
1450 , p_init_msg_list VARCHAR2
1451 , x_return_status out nocopy VARCHAR2
1452 , x_msg_count out nocopy NUMBER
1453 , x_msg_data out nocopy VARCHAR2
1454 , p5_a0 JTF_NUMBER_TABLE
1455 , p5_a1 JTF_NUMBER_TABLE
1456 , p5_a2 JTF_VARCHAR2_TABLE_100
1457 , p5_a3 JTF_VARCHAR2_TABLE_100
1458 , p5_a4 JTF_VARCHAR2_TABLE_100
1459 , p5_a5 JTF_VARCHAR2_TABLE_100
1460 , p5_a6 JTF_NUMBER_TABLE
1461 , p5_a7 JTF_NUMBER_TABLE
1462 , p5_a8 JTF_NUMBER_TABLE
1463 , p5_a9 JTF_NUMBER_TABLE
1464 , p5_a10 JTF_NUMBER_TABLE
1465 , p5_a11 JTF_NUMBER_TABLE
1466 , p5_a12 JTF_VARCHAR2_TABLE_100
1467 , p5_a13 JTF_VARCHAR2_TABLE_100
1468 , p5_a14 JTF_DATE_TABLE
1469 , p5_a15 JTF_VARCHAR2_TABLE_100
1470 , p5_a16 JTF_VARCHAR2_TABLE_100
1471 , p5_a17 JTF_NUMBER_TABLE
1472 , p5_a18 JTF_VARCHAR2_TABLE_200
1473 , p5_a19 JTF_VARCHAR2_TABLE_100
1474 , p5_a20 JTF_VARCHAR2_TABLE_500
1475 , p5_a21 JTF_VARCHAR2_TABLE_500
1476 , p5_a22 JTF_VARCHAR2_TABLE_500
1477 , p5_a23 JTF_VARCHAR2_TABLE_500
1478 , p5_a24 JTF_VARCHAR2_TABLE_500
1479 , p5_a25 JTF_VARCHAR2_TABLE_500
1480 , p5_a26 JTF_VARCHAR2_TABLE_500
1481 , p5_a27 JTF_VARCHAR2_TABLE_500
1482 , p5_a28 JTF_VARCHAR2_TABLE_500
1483 , p5_a29 JTF_VARCHAR2_TABLE_500
1484 , p5_a30 JTF_VARCHAR2_TABLE_500
1485 , p5_a31 JTF_VARCHAR2_TABLE_500
1486 , p5_a32 JTF_VARCHAR2_TABLE_500
1487 , p5_a33 JTF_VARCHAR2_TABLE_500
1488 , p5_a34 JTF_VARCHAR2_TABLE_500
1489 , p5_a35 JTF_VARCHAR2_TABLE_100
1490 , p5_a36 JTF_VARCHAR2_TABLE_100
1491 , p5_a37 JTF_NUMBER_TABLE
1492 , p5_a38 JTF_VARCHAR2_TABLE_100
1493 , p5_a39 JTF_NUMBER_TABLE
1494 , p5_a40 JTF_VARCHAR2_TABLE_100
1495 , p5_a41 JTF_VARCHAR2_TABLE_100
1496 , p5_a42 JTF_NUMBER_TABLE
1497 , p5_a43 JTF_NUMBER_TABLE
1498 , p5_a44 JTF_NUMBER_TABLE
1499 , p5_a45 JTF_NUMBER_TABLE
1500 , p5_a46 JTF_NUMBER_TABLE
1501 , p5_a47 JTF_NUMBER_TABLE
1502 , p5_a48 JTF_DATE_TABLE
1503 , p5_a49 JTF_NUMBER_TABLE
1504 , p5_a50 JTF_DATE_TABLE
1505 , p5_a51 JTF_NUMBER_TABLE
1506 , p5_a52 JTF_DATE_TABLE
1507 , p5_a53 JTF_NUMBER_TABLE
1508 , p5_a54 JTF_NUMBER_TABLE
1509 , p5_a55 JTF_VARCHAR2_TABLE_100
1510 , p5_a56 JTF_NUMBER_TABLE
1511 , p5_a57 JTF_VARCHAR2_TABLE_2000
1512 , p5_a58 JTF_DATE_TABLE
1513 , p5_a59 JTF_VARCHAR2_TABLE_100
1514 , p5_a60 JTF_VARCHAR2_TABLE_100
1515 , p5_a61 JTF_VARCHAR2_TABLE_100
1516 , p5_a62 JTF_VARCHAR2_TABLE_100
1517 , p5_a63 JTF_VARCHAR2_TABLE_100
1518 , p5_a64 JTF_VARCHAR2_TABLE_100
1519 , p5_a65 JTF_VARCHAR2_TABLE_100
1520 , p5_a66 JTF_VARCHAR2_TABLE_100
1521 , p5_a67 JTF_VARCHAR2_TABLE_100
1522 , p5_a68 JTF_VARCHAR2_TABLE_100
1523 , p5_a69 JTF_VARCHAR2_TABLE_100
1524 , p5_a70 JTF_VARCHAR2_TABLE_100
1525 , p5_a71 JTF_VARCHAR2_TABLE_100
1526 , p5_a72 JTF_VARCHAR2_TABLE_100
1527 , p5_a73 JTF_VARCHAR2_TABLE_100
1528 , p5_a74 JTF_VARCHAR2_TABLE_100
1529 , p5_a75 JTF_VARCHAR2_TABLE_100
1530 , p5_a76 JTF_VARCHAR2_TABLE_100
1531 , p5_a77 JTF_NUMBER_TABLE
1532 , p5_a78 JTF_DATE_TABLE
1533 , p5_a79 JTF_NUMBER_TABLE
1534 , p5_a80 JTF_NUMBER_TABLE
1535 , p5_a81 JTF_VARCHAR2_TABLE_100
1536 , p5_a82 JTF_DATE_TABLE
1537 , p5_a83 JTF_NUMBER_TABLE
1538 , p5_a84 JTF_DATE_TABLE
1539 , p5_a85 JTF_VARCHAR2_TABLE_100
1540 , p5_a86 JTF_VARCHAR2_TABLE_200
1541 , p5_a87 JTF_VARCHAR2_TABLE_100
1542 , p5_a88 JTF_VARCHAR2_TABLE_200
1543 , p5_a89 JTF_VARCHAR2_TABLE_100
1544 , p5_a90 JTF_VARCHAR2_TABLE_100
1545 , p5_a91 JTF_VARCHAR2_TABLE_100
1546 , p5_a92 JTF_VARCHAR2_TABLE_100
1547 , p5_a93 JTF_DATE_TABLE
1548 , p6_a0 out nocopy JTF_NUMBER_TABLE
1549 , p6_a1 out nocopy JTF_NUMBER_TABLE
1550 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1551 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1553 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1554 , p6_a6 out nocopy JTF_NUMBER_TABLE
1555 , p6_a7 out nocopy JTF_NUMBER_TABLE
1556 , p6_a8 out nocopy JTF_NUMBER_TABLE
1557 , p6_a9 out nocopy JTF_NUMBER_TABLE
1558 , p6_a10 out nocopy JTF_NUMBER_TABLE
1559 , p6_a11 out nocopy JTF_NUMBER_TABLE
1560 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1561 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1562 , p6_a14 out nocopy JTF_DATE_TABLE
1563 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1564 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1565 , p6_a17 out nocopy JTF_NUMBER_TABLE
1566 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
1567 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1568 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1569 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1570 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1571 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1572 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1573 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1574 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1575 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1576 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1577 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1578 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1579 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1580 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1581 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1582 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1583 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1584 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1585 , p6_a37 out nocopy JTF_NUMBER_TABLE
1586 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1587 , p6_a39 out nocopy JTF_NUMBER_TABLE
1588 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1589 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1590 , p6_a42 out nocopy JTF_NUMBER_TABLE
1591 , p6_a43 out nocopy JTF_NUMBER_TABLE
1592 , p6_a44 out nocopy JTF_NUMBER_TABLE
1593 , p6_a45 out nocopy JTF_NUMBER_TABLE
1594 , p6_a46 out nocopy JTF_NUMBER_TABLE
1595 , p6_a47 out nocopy JTF_NUMBER_TABLE
1596 , p6_a48 out nocopy JTF_DATE_TABLE
1597 , p6_a49 out nocopy JTF_NUMBER_TABLE
1598 , p6_a50 out nocopy JTF_DATE_TABLE
1599 , p6_a51 out nocopy JTF_NUMBER_TABLE
1600 , p6_a52 out nocopy JTF_DATE_TABLE
1601 , p6_a53 out nocopy JTF_NUMBER_TABLE
1602 , p6_a54 out nocopy JTF_NUMBER_TABLE
1603 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1604 , p6_a56 out nocopy JTF_NUMBER_TABLE
1605 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_2000
1606 , p6_a58 out nocopy JTF_DATE_TABLE
1607 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
1608 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
1609 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1610 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1611 , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
1612 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
1613 , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
1614 , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
1615 , p6_a67 out nocopy JTF_VARCHAR2_TABLE_100
1616 , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
1617 , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
1618 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
1619 , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
1620 , p6_a72 out nocopy JTF_VARCHAR2_TABLE_100
1621 , p6_a73 out nocopy JTF_VARCHAR2_TABLE_100
1622 , p6_a74 out nocopy JTF_VARCHAR2_TABLE_100
1623 , p6_a75 out nocopy JTF_VARCHAR2_TABLE_100
1624 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
1625 , p6_a77 out nocopy JTF_NUMBER_TABLE
1626 , p6_a78 out nocopy JTF_DATE_TABLE
1627 , p6_a79 out nocopy JTF_NUMBER_TABLE
1628 , p6_a80 out nocopy JTF_NUMBER_TABLE
1629 , p6_a81 out nocopy JTF_VARCHAR2_TABLE_100
1630 , p6_a82 out nocopy JTF_DATE_TABLE
1631 , p6_a83 out nocopy JTF_NUMBER_TABLE
1632 , p6_a84 out nocopy JTF_DATE_TABLE
1633 , p6_a85 out nocopy JTF_VARCHAR2_TABLE_100
1634 , p6_a86 out nocopy JTF_VARCHAR2_TABLE_200
1635 , p6_a87 out nocopy JTF_VARCHAR2_TABLE_100
1636 , p6_a88 out nocopy JTF_VARCHAR2_TABLE_200
1637 , p6_a89 out nocopy JTF_VARCHAR2_TABLE_100
1638 , p6_a90 out nocopy JTF_VARCHAR2_TABLE_100
1639 , p6_a91 out nocopy JTF_VARCHAR2_TABLE_100
1640 , p6_a92 out nocopy JTF_VARCHAR2_TABLE_100
1641 , p6_a93 out nocopy JTF_DATE_TABLE
1642 );
1643 procedure update_trx_cntrct_lines(p_api_version NUMBER
1644 , p_init_msg_list VARCHAR2
1645 , x_return_status out nocopy VARCHAR2
1646 , x_msg_count out nocopy NUMBER
1647 , x_msg_data out nocopy VARCHAR2
1648 , p6_a0 out nocopy NUMBER
1649 , p6_a1 out nocopy NUMBER
1650 , p6_a2 out nocopy NUMBER
1651 , p6_a3 out nocopy NUMBER
1652 , p6_a4 out nocopy NUMBER
1653 , p6_a5 out nocopy NUMBER
1654 , p6_a6 out nocopy NUMBER
1655 , p6_a7 out nocopy NUMBER
1656 , p6_a8 out nocopy VARCHAR2
1657 , p6_a9 out nocopy NUMBER
1658 , p6_a10 out nocopy VARCHAR2
1659 , p6_a11 out nocopy NUMBER
1660 , p6_a12 out nocopy VARCHAR2
1661 , p6_a13 out nocopy VARCHAR2
1662 , p6_a14 out nocopy VARCHAR2
1663 , p6_a15 out nocopy VARCHAR2
1664 , p6_a16 out nocopy VARCHAR2
1665 , p6_a17 out nocopy VARCHAR2
1666 , p6_a18 out nocopy VARCHAR2
1667 , p6_a19 out nocopy VARCHAR2
1668 , p6_a20 out nocopy VARCHAR2
1669 , p6_a21 out nocopy VARCHAR2
1670 , p6_a22 out nocopy VARCHAR2
1671 , p6_a23 out nocopy VARCHAR2
1672 , p6_a24 out nocopy VARCHAR2
1673 , p6_a25 out nocopy VARCHAR2
1674 , p6_a26 out nocopy VARCHAR2
1675 , p6_a27 out nocopy VARCHAR2
1676 , p6_a28 out nocopy VARCHAR2
1677 , p6_a29 out nocopy VARCHAR2
1678 , p6_a30 out nocopy VARCHAR2
1679 , p6_a31 out nocopy NUMBER
1680 , p6_a32 out nocopy DATE
1681 , p6_a33 out nocopy NUMBER
1682 , p6_a34 out nocopy DATE
1683 , p6_a35 out nocopy NUMBER
1684 , p6_a36 out nocopy NUMBER
1685 , p6_a37 out nocopy NUMBER
1686 , p6_a38 out nocopy NUMBER
1687 , p6_a39 out nocopy DATE
1688 , p6_a40 out nocopy NUMBER
1689 , p6_a41 out nocopy NUMBER
1690 , p6_a42 out nocopy NUMBER
1691 , p6_a43 out nocopy NUMBER
1692 , p6_a44 out nocopy NUMBER
1693 , p6_a45 out nocopy VARCHAR2
1694 , p6_a46 out nocopy VARCHAR2
1695 , p6_a47 out nocopy NUMBER
1696 , p6_a48 out nocopy VARCHAR2
1697 , p6_a49 out nocopy NUMBER
1698 , p6_a50 out nocopy VARCHAR2
1699 , p6_a51 out nocopy NUMBER
1700 , p6_a52 out nocopy DATE
1701 , p6_a53 out nocopy NUMBER
1702 , p6_a54 out nocopy VARCHAR2
1703 , p6_a55 out nocopy VARCHAR2
1704 , p6_a56 out nocopy VARCHAR2
1705 , p6_a57 out nocopy VARCHAR2
1706 , p5_a0 NUMBER := 0-1962.0724
1707 , p5_a1 NUMBER := 0-1962.0724
1708 , p5_a2 NUMBER := 0-1962.0724
1709 , p5_a3 NUMBER := 0-1962.0724
1710 , p5_a4 NUMBER := 0-1962.0724
1711 , p5_a5 NUMBER := 0-1962.0724
1712 , p5_a6 NUMBER := 0-1962.0724
1713 , p5_a7 NUMBER := 0-1962.0724
1714 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1715 , p5_a9 NUMBER := 0-1962.0724
1716 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1717 , p5_a11 NUMBER := 0-1962.0724
1718 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1719 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1720 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1721 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1722 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1723 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1724 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1725 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1726 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1727 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1728 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1729 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1730 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1731 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1732 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1733 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1734 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1735 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1736 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1737 , p5_a31 NUMBER := 0-1962.0724
1738 , p5_a32 DATE := fnd_api.g_miss_date
1739 , p5_a33 NUMBER := 0-1962.0724
1740 , p5_a34 DATE := fnd_api.g_miss_date
1741 , p5_a35 NUMBER := 0-1962.0724
1742 , p5_a36 NUMBER := 0-1962.0724
1743 , p5_a37 NUMBER := 0-1962.0724
1744 , p5_a38 NUMBER := 0-1962.0724
1745 , p5_a39 DATE := fnd_api.g_miss_date
1746 , p5_a40 NUMBER := 0-1962.0724
1747 , p5_a41 NUMBER := 0-1962.0724
1748 , p5_a42 NUMBER := 0-1962.0724
1749 , p5_a43 NUMBER := 0-1962.0724
1750 , p5_a44 NUMBER := 0-1962.0724
1751 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1752 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1753 , p5_a47 NUMBER := 0-1962.0724
1754 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1755 , p5_a49 NUMBER := 0-1962.0724
1756 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1757 , p5_a51 NUMBER := 0-1962.0724
1758 , p5_a52 DATE := fnd_api.g_miss_date
1759 , p5_a53 NUMBER := 0-1962.0724
1760 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1761 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1762 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1763 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1764 );
1765 procedure update_trx_cntrct_lines(p_api_version NUMBER
1766 , p_init_msg_list VARCHAR2
1767 , x_return_status out nocopy VARCHAR2
1768 , x_msg_count out nocopy NUMBER
1769 , x_msg_data out nocopy VARCHAR2
1770 , p5_a0 JTF_NUMBER_TABLE
1771 , p5_a1 JTF_NUMBER_TABLE
1772 , p5_a2 JTF_NUMBER_TABLE
1773 , p5_a3 JTF_NUMBER_TABLE
1774 , p5_a4 JTF_NUMBER_TABLE
1775 , p5_a5 JTF_NUMBER_TABLE
1776 , p5_a6 JTF_NUMBER_TABLE
1777 , p5_a7 JTF_NUMBER_TABLE
1778 , p5_a8 JTF_VARCHAR2_TABLE_100
1779 , p5_a9 JTF_NUMBER_TABLE
1780 , p5_a10 JTF_VARCHAR2_TABLE_2000
1781 , p5_a11 JTF_NUMBER_TABLE
1782 , p5_a12 JTF_VARCHAR2_TABLE_200
1783 , p5_a13 JTF_VARCHAR2_TABLE_100
1784 , p5_a14 JTF_VARCHAR2_TABLE_100
1785 , p5_a15 JTF_VARCHAR2_TABLE_500
1786 , p5_a16 JTF_VARCHAR2_TABLE_500
1787 , p5_a17 JTF_VARCHAR2_TABLE_500
1788 , p5_a18 JTF_VARCHAR2_TABLE_500
1789 , p5_a19 JTF_VARCHAR2_TABLE_500
1790 , p5_a20 JTF_VARCHAR2_TABLE_500
1791 , p5_a21 JTF_VARCHAR2_TABLE_500
1792 , p5_a22 JTF_VARCHAR2_TABLE_500
1793 , p5_a23 JTF_VARCHAR2_TABLE_500
1794 , p5_a24 JTF_VARCHAR2_TABLE_500
1795 , p5_a25 JTF_VARCHAR2_TABLE_500
1796 , p5_a26 JTF_VARCHAR2_TABLE_500
1797 , p5_a27 JTF_VARCHAR2_TABLE_500
1798 , p5_a28 JTF_VARCHAR2_TABLE_500
1799 , p5_a29 JTF_VARCHAR2_TABLE_500
1800 , p5_a30 JTF_VARCHAR2_TABLE_100
1801 , p5_a31 JTF_NUMBER_TABLE
1802 , p5_a32 JTF_DATE_TABLE
1803 , p5_a33 JTF_NUMBER_TABLE
1804 , p5_a34 JTF_DATE_TABLE
1805 , p5_a35 JTF_NUMBER_TABLE
1806 , p5_a36 JTF_NUMBER_TABLE
1807 , p5_a37 JTF_NUMBER_TABLE
1808 , p5_a38 JTF_NUMBER_TABLE
1809 , p5_a39 JTF_DATE_TABLE
1810 , p5_a40 JTF_NUMBER_TABLE
1811 , p5_a41 JTF_NUMBER_TABLE
1812 , p5_a42 JTF_NUMBER_TABLE
1813 , p5_a43 JTF_NUMBER_TABLE
1814 , p5_a44 JTF_NUMBER_TABLE
1815 , p5_a45 JTF_VARCHAR2_TABLE_100
1816 , p5_a46 JTF_VARCHAR2_TABLE_200
1817 , p5_a47 JTF_NUMBER_TABLE
1818 , p5_a48 JTF_VARCHAR2_TABLE_200
1819 , p5_a49 JTF_NUMBER_TABLE
1820 , p5_a50 JTF_VARCHAR2_TABLE_200
1821 , p5_a51 JTF_NUMBER_TABLE
1822 , p5_a52 JTF_DATE_TABLE
1823 , p5_a53 JTF_NUMBER_TABLE
1824 , p5_a54 JTF_VARCHAR2_TABLE_200
1825 , p5_a55 JTF_VARCHAR2_TABLE_300
1826 , p5_a56 JTF_VARCHAR2_TABLE_100
1827 , p5_a57 JTF_VARCHAR2_TABLE_100
1828 , p6_a0 out nocopy JTF_NUMBER_TABLE
1829 , p6_a1 out nocopy JTF_NUMBER_TABLE
1830 , p6_a2 out nocopy JTF_NUMBER_TABLE
1831 , p6_a3 out nocopy JTF_NUMBER_TABLE
1832 , p6_a4 out nocopy JTF_NUMBER_TABLE
1833 , p6_a5 out nocopy JTF_NUMBER_TABLE
1834 , p6_a6 out nocopy JTF_NUMBER_TABLE
1835 , p6_a7 out nocopy JTF_NUMBER_TABLE
1836 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1837 , p6_a9 out nocopy JTF_NUMBER_TABLE
1838 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1839 , p6_a11 out nocopy JTF_NUMBER_TABLE
1840 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
1841 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1842 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1843 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1844 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1845 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1846 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1847 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1848 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1849 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1850 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1851 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1852 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1853 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1854 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1855 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1856 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1857 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1858 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1859 , p6_a31 out nocopy JTF_NUMBER_TABLE
1860 , p6_a32 out nocopy JTF_DATE_TABLE
1861 , p6_a33 out nocopy JTF_NUMBER_TABLE
1862 , p6_a34 out nocopy JTF_DATE_TABLE
1863 , p6_a35 out nocopy JTF_NUMBER_TABLE
1864 , p6_a36 out nocopy JTF_NUMBER_TABLE
1865 , p6_a37 out nocopy JTF_NUMBER_TABLE
1866 , p6_a38 out nocopy JTF_NUMBER_TABLE
1867 , p6_a39 out nocopy JTF_DATE_TABLE
1868 , p6_a40 out nocopy JTF_NUMBER_TABLE
1869 , p6_a41 out nocopy JTF_NUMBER_TABLE
1870 , p6_a42 out nocopy JTF_NUMBER_TABLE
1871 , p6_a43 out nocopy JTF_NUMBER_TABLE
1872 , p6_a44 out nocopy JTF_NUMBER_TABLE
1873 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1874 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_200
1875 , p6_a47 out nocopy JTF_NUMBER_TABLE
1876 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_200
1877 , p6_a49 out nocopy JTF_NUMBER_TABLE
1878 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_200
1879 , p6_a51 out nocopy JTF_NUMBER_TABLE
1880 , p6_a52 out nocopy JTF_DATE_TABLE
1881 , p6_a53 out nocopy JTF_NUMBER_TABLE
1882 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_200
1883 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_300
1884 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1885 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1886 );
1887 procedure delete_trx_contracts(p_api_version NUMBER
1888 , p_init_msg_list VARCHAR2
1889 , x_return_status out nocopy VARCHAR2
1890 , x_msg_count out nocopy NUMBER
1891 , x_msg_data out nocopy VARCHAR2
1892 , p5_a0 NUMBER := 0-1962.0724
1893 , p5_a1 NUMBER := 0-1962.0724
1894 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1896 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1897 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1898 , p5_a6 NUMBER := 0-1962.0724
1899 , p5_a7 NUMBER := 0-1962.0724
1900 , p5_a8 NUMBER := 0-1962.0724
1901 , p5_a9 NUMBER := 0-1962.0724
1902 , p5_a10 NUMBER := 0-1962.0724
1903 , p5_a11 NUMBER := 0-1962.0724
1904 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1905 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a14 DATE := fnd_api.g_miss_date
1907 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1908 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1909 , p5_a17 NUMBER := 0-1962.0724
1910 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1911 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1912 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1913 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1914 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1915 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1916 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1917 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1918 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1919 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1920 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1921 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1922 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1923 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1924 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1925 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1926 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1927 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1928 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1929 , p5_a37 NUMBER := 0-1962.0724
1930 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1931 , p5_a39 NUMBER := 0-1962.0724
1932 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1933 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1934 , p5_a42 NUMBER := 0-1962.0724
1935 , p5_a43 NUMBER := 0-1962.0724
1936 , p5_a44 NUMBER := 0-1962.0724
1937 , p5_a45 NUMBER := 0-1962.0724
1938 , p5_a46 NUMBER := 0-1962.0724
1939 , p5_a47 NUMBER := 0-1962.0724
1940 , p5_a48 DATE := fnd_api.g_miss_date
1941 , p5_a49 NUMBER := 0-1962.0724
1942 , p5_a50 DATE := fnd_api.g_miss_date
1943 , p5_a51 NUMBER := 0-1962.0724
1944 , p5_a52 DATE := fnd_api.g_miss_date
1945 , p5_a53 NUMBER := 0-1962.0724
1946 , p5_a54 NUMBER := 0-1962.0724
1947 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1948 , p5_a56 NUMBER := 0-1962.0724
1949 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1950 , p5_a58 DATE := fnd_api.g_miss_date
1951 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1952 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1953 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1954 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1955 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1956 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1957 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1958 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
1959 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
1960 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
1961 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
1964 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
1966 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
1967 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1968 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1969 , p5_a77 NUMBER := 0-1962.0724
1970 , p5_a78 DATE := fnd_api.g_miss_date
1971 , p5_a79 NUMBER := 0-1962.0724
1972 , p5_a80 NUMBER := 0-1962.0724
1973 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
1974 , p5_a82 DATE := fnd_api.g_miss_date
1975 , p5_a83 NUMBER := 0-1962.0724
1976 , p5_a84 DATE := fnd_api.g_miss_date
1977 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
1978 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
1979 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
1980 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
1981 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
1982 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
1983 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
1984 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
1985 , p5_a93 DATE := fnd_api.g_miss_date
1986 );
1987 procedure delete_trx_contracts(p_api_version NUMBER
1988 , p_init_msg_list VARCHAR2
1989 , x_return_status out nocopy VARCHAR2
1990 , x_msg_count out nocopy NUMBER
1991 , x_msg_data out nocopy VARCHAR2
1992 , p5_a0 JTF_NUMBER_TABLE
1993 , p5_a1 JTF_NUMBER_TABLE
1994 , p5_a2 JTF_VARCHAR2_TABLE_100
1995 , p5_a3 JTF_VARCHAR2_TABLE_100
1996 , p5_a4 JTF_VARCHAR2_TABLE_100
1997 , p5_a5 JTF_VARCHAR2_TABLE_100
1998 , p5_a6 JTF_NUMBER_TABLE
1999 , p5_a7 JTF_NUMBER_TABLE
2000 , p5_a8 JTF_NUMBER_TABLE
2001 , p5_a9 JTF_NUMBER_TABLE
2002 , p5_a10 JTF_NUMBER_TABLE
2003 , p5_a11 JTF_NUMBER_TABLE
2004 , p5_a12 JTF_VARCHAR2_TABLE_100
2005 , p5_a13 JTF_VARCHAR2_TABLE_100
2006 , p5_a14 JTF_DATE_TABLE
2007 , p5_a15 JTF_VARCHAR2_TABLE_100
2008 , p5_a16 JTF_VARCHAR2_TABLE_100
2009 , p5_a17 JTF_NUMBER_TABLE
2010 , p5_a18 JTF_VARCHAR2_TABLE_200
2011 , p5_a19 JTF_VARCHAR2_TABLE_100
2012 , p5_a20 JTF_VARCHAR2_TABLE_500
2013 , p5_a21 JTF_VARCHAR2_TABLE_500
2014 , p5_a22 JTF_VARCHAR2_TABLE_500
2015 , p5_a23 JTF_VARCHAR2_TABLE_500
2016 , p5_a24 JTF_VARCHAR2_TABLE_500
2017 , p5_a25 JTF_VARCHAR2_TABLE_500
2018 , p5_a26 JTF_VARCHAR2_TABLE_500
2019 , p5_a27 JTF_VARCHAR2_TABLE_500
2020 , p5_a28 JTF_VARCHAR2_TABLE_500
2021 , p5_a29 JTF_VARCHAR2_TABLE_500
2022 , p5_a30 JTF_VARCHAR2_TABLE_500
2023 , p5_a31 JTF_VARCHAR2_TABLE_500
2024 , p5_a32 JTF_VARCHAR2_TABLE_500
2025 , p5_a33 JTF_VARCHAR2_TABLE_500
2026 , p5_a34 JTF_VARCHAR2_TABLE_500
2027 , p5_a35 JTF_VARCHAR2_TABLE_100
2028 , p5_a36 JTF_VARCHAR2_TABLE_100
2029 , p5_a37 JTF_NUMBER_TABLE
2030 , p5_a38 JTF_VARCHAR2_TABLE_100
2031 , p5_a39 JTF_NUMBER_TABLE
2032 , p5_a40 JTF_VARCHAR2_TABLE_100
2033 , p5_a41 JTF_VARCHAR2_TABLE_100
2034 , p5_a42 JTF_NUMBER_TABLE
2035 , p5_a43 JTF_NUMBER_TABLE
2036 , p5_a44 JTF_NUMBER_TABLE
2037 , p5_a45 JTF_NUMBER_TABLE
2038 , p5_a46 JTF_NUMBER_TABLE
2039 , p5_a47 JTF_NUMBER_TABLE
2040 , p5_a48 JTF_DATE_TABLE
2041 , p5_a49 JTF_NUMBER_TABLE
2042 , p5_a50 JTF_DATE_TABLE
2043 , p5_a51 JTF_NUMBER_TABLE
2044 , p5_a52 JTF_DATE_TABLE
2045 , p5_a53 JTF_NUMBER_TABLE
2046 , p5_a54 JTF_NUMBER_TABLE
2047 , p5_a55 JTF_VARCHAR2_TABLE_100
2048 , p5_a56 JTF_NUMBER_TABLE
2049 , p5_a57 JTF_VARCHAR2_TABLE_2000
2050 , p5_a58 JTF_DATE_TABLE
2051 , p5_a59 JTF_VARCHAR2_TABLE_100
2052 , p5_a60 JTF_VARCHAR2_TABLE_100
2053 , p5_a61 JTF_VARCHAR2_TABLE_100
2054 , p5_a62 JTF_VARCHAR2_TABLE_100
2055 , p5_a63 JTF_VARCHAR2_TABLE_100
2056 , p5_a64 JTF_VARCHAR2_TABLE_100
2057 , p5_a65 JTF_VARCHAR2_TABLE_100
2058 , p5_a66 JTF_VARCHAR2_TABLE_100
2059 , p5_a67 JTF_VARCHAR2_TABLE_100
2060 , p5_a68 JTF_VARCHAR2_TABLE_100
2061 , p5_a69 JTF_VARCHAR2_TABLE_100
2062 , p5_a70 JTF_VARCHAR2_TABLE_100
2063 , p5_a71 JTF_VARCHAR2_TABLE_100
2064 , p5_a72 JTF_VARCHAR2_TABLE_100
2065 , p5_a73 JTF_VARCHAR2_TABLE_100
2066 , p5_a74 JTF_VARCHAR2_TABLE_100
2067 , p5_a75 JTF_VARCHAR2_TABLE_100
2068 , p5_a76 JTF_VARCHAR2_TABLE_100
2069 , p5_a77 JTF_NUMBER_TABLE
2070 , p5_a78 JTF_DATE_TABLE
2071 , p5_a79 JTF_NUMBER_TABLE
2072 , p5_a80 JTF_NUMBER_TABLE
2073 , p5_a81 JTF_VARCHAR2_TABLE_100
2074 , p5_a82 JTF_DATE_TABLE
2075 , p5_a83 JTF_NUMBER_TABLE
2076 , p5_a84 JTF_DATE_TABLE
2077 , p5_a85 JTF_VARCHAR2_TABLE_100
2078 , p5_a86 JTF_VARCHAR2_TABLE_200
2079 , p5_a87 JTF_VARCHAR2_TABLE_100
2080 , p5_a88 JTF_VARCHAR2_TABLE_200
2081 , p5_a89 JTF_VARCHAR2_TABLE_100
2082 , p5_a90 JTF_VARCHAR2_TABLE_100
2083 , p5_a91 JTF_VARCHAR2_TABLE_100
2084 , p5_a92 JTF_VARCHAR2_TABLE_100
2085 , p5_a93 JTF_DATE_TABLE
2086 );
2087 procedure delete_trx_cntrct_lines(p_api_version NUMBER
2088 , p_init_msg_list VARCHAR2
2089 , x_return_status out nocopy VARCHAR2
2090 , x_msg_count out nocopy NUMBER
2091 , x_msg_data out nocopy VARCHAR2
2092 , p5_a0 NUMBER := 0-1962.0724
2093 , p5_a1 NUMBER := 0-1962.0724
2094 , p5_a2 NUMBER := 0-1962.0724
2095 , p5_a3 NUMBER := 0-1962.0724
2096 , p5_a4 NUMBER := 0-1962.0724
2097 , p5_a5 NUMBER := 0-1962.0724
2098 , p5_a6 NUMBER := 0-1962.0724
2099 , p5_a7 NUMBER := 0-1962.0724
2100 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2101 , p5_a9 NUMBER := 0-1962.0724
2102 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2103 , p5_a11 NUMBER := 0-1962.0724
2104 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2105 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2106 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2107 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2108 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2109 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2110 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2111 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2112 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2113 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2114 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2115 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2116 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2117 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2118 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2119 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2120 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2121 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2122 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2123 , p5_a31 NUMBER := 0-1962.0724
2124 , p5_a32 DATE := fnd_api.g_miss_date
2125 , p5_a33 NUMBER := 0-1962.0724
2126 , p5_a34 DATE := fnd_api.g_miss_date
2127 , p5_a35 NUMBER := 0-1962.0724
2128 , p5_a36 NUMBER := 0-1962.0724
2129 , p5_a37 NUMBER := 0-1962.0724
2130 , p5_a38 NUMBER := 0-1962.0724
2131 , p5_a39 DATE := fnd_api.g_miss_date
2132 , p5_a40 NUMBER := 0-1962.0724
2133 , p5_a41 NUMBER := 0-1962.0724
2134 , p5_a42 NUMBER := 0-1962.0724
2135 , p5_a43 NUMBER := 0-1962.0724
2136 , p5_a44 NUMBER := 0-1962.0724
2137 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2138 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2139 , p5_a47 NUMBER := 0-1962.0724
2140 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2141 , p5_a49 NUMBER := 0-1962.0724
2142 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2143 , p5_a51 NUMBER := 0-1962.0724
2144 , p5_a52 DATE := fnd_api.g_miss_date
2145 , p5_a53 NUMBER := 0-1962.0724
2146 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2147 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2148 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2149 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2150 );
2151 procedure delete_trx_cntrct_lines(p_api_version NUMBER
2152 , p_init_msg_list VARCHAR2
2153 , x_return_status out nocopy VARCHAR2
2154 , x_msg_count out nocopy NUMBER
2155 , x_msg_data out nocopy VARCHAR2
2156 , p5_a0 JTF_NUMBER_TABLE
2157 , p5_a1 JTF_NUMBER_TABLE
2158 , p5_a2 JTF_NUMBER_TABLE
2159 , p5_a3 JTF_NUMBER_TABLE
2160 , p5_a4 JTF_NUMBER_TABLE
2161 , p5_a5 JTF_NUMBER_TABLE
2162 , p5_a6 JTF_NUMBER_TABLE
2163 , p5_a7 JTF_NUMBER_TABLE
2164 , p5_a8 JTF_VARCHAR2_TABLE_100
2165 , p5_a9 JTF_NUMBER_TABLE
2166 , p5_a10 JTF_VARCHAR2_TABLE_2000
2167 , p5_a11 JTF_NUMBER_TABLE
2168 , p5_a12 JTF_VARCHAR2_TABLE_200
2169 , p5_a13 JTF_VARCHAR2_TABLE_100
2170 , p5_a14 JTF_VARCHAR2_TABLE_100
2171 , p5_a15 JTF_VARCHAR2_TABLE_500
2172 , p5_a16 JTF_VARCHAR2_TABLE_500
2173 , p5_a17 JTF_VARCHAR2_TABLE_500
2174 , p5_a18 JTF_VARCHAR2_TABLE_500
2175 , p5_a19 JTF_VARCHAR2_TABLE_500
2176 , p5_a20 JTF_VARCHAR2_TABLE_500
2177 , p5_a21 JTF_VARCHAR2_TABLE_500
2178 , p5_a22 JTF_VARCHAR2_TABLE_500
2179 , p5_a23 JTF_VARCHAR2_TABLE_500
2180 , p5_a24 JTF_VARCHAR2_TABLE_500
2181 , p5_a25 JTF_VARCHAR2_TABLE_500
2182 , p5_a26 JTF_VARCHAR2_TABLE_500
2183 , p5_a27 JTF_VARCHAR2_TABLE_500
2184 , p5_a28 JTF_VARCHAR2_TABLE_500
2185 , p5_a29 JTF_VARCHAR2_TABLE_500
2186 , p5_a30 JTF_VARCHAR2_TABLE_100
2187 , p5_a31 JTF_NUMBER_TABLE
2188 , p5_a32 JTF_DATE_TABLE
2189 , p5_a33 JTF_NUMBER_TABLE
2190 , p5_a34 JTF_DATE_TABLE
2191 , p5_a35 JTF_NUMBER_TABLE
2192 , p5_a36 JTF_NUMBER_TABLE
2193 , p5_a37 JTF_NUMBER_TABLE
2194 , p5_a38 JTF_NUMBER_TABLE
2195 , p5_a39 JTF_DATE_TABLE
2196 , p5_a40 JTF_NUMBER_TABLE
2197 , p5_a41 JTF_NUMBER_TABLE
2198 , p5_a42 JTF_NUMBER_TABLE
2199 , p5_a43 JTF_NUMBER_TABLE
2200 , p5_a44 JTF_NUMBER_TABLE
2201 , p5_a45 JTF_VARCHAR2_TABLE_100
2202 , p5_a46 JTF_VARCHAR2_TABLE_200
2203 , p5_a47 JTF_NUMBER_TABLE
2204 , p5_a48 JTF_VARCHAR2_TABLE_200
2205 , p5_a49 JTF_NUMBER_TABLE
2206 , p5_a50 JTF_VARCHAR2_TABLE_200
2207 , p5_a51 JTF_NUMBER_TABLE
2208 , p5_a52 JTF_DATE_TABLE
2209 , p5_a53 JTF_NUMBER_TABLE
2210 , p5_a54 JTF_VARCHAR2_TABLE_200
2211 , p5_a55 JTF_VARCHAR2_TABLE_300
2212 , p5_a56 JTF_VARCHAR2_TABLE_100
2213 , p5_a57 JTF_VARCHAR2_TABLE_100
2214 );
2215 end okl_trans_contracts_pvt_w;