[Home] [Help]
PACKAGE BODY: APPS.OKL_INTERNAL_BILLING_PVT_W
Source
1 package body okl_internal_billing_pvt_w as
2 /* $Header: OKLEIARB.pls 120.0 2007/07/16 14:37:28 gkhuntet noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure create_billing_trx(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , x_return_status out nocopy VARCHAR2
28 , x_msg_count out nocopy NUMBER
29 , x_msg_data out nocopy VARCHAR2
30 , p6_a0 JTF_NUMBER_TABLE
31 , p6_a1 JTF_NUMBER_TABLE
32 , p6_a2 JTF_VARCHAR2_TABLE_3000
33 , p6_a3 JTF_VARCHAR2_TABLE_100
34 , p6_a4 JTF_NUMBER_TABLE
35 , p6_a5 JTF_NUMBER_TABLE
36 , p6_a6 JTF_NUMBER_TABLE
37 , p6_a7 JTF_VARCHAR2_TABLE_100
38 , p6_a8 JTF_NUMBER_TABLE
39 , p6_a9 JTF_NUMBER_TABLE
40 , p6_a10 JTF_NUMBER_TABLE
41 , p6_a11 JTF_NUMBER_TABLE
42 , p6_a12 JTF_NUMBER_TABLE
43 , p6_a13 JTF_NUMBER_TABLE
44 , p6_a14 JTF_VARCHAR2_TABLE_2000
45 , p6_a15 JTF_NUMBER_TABLE
46 , p6_a16 JTF_DATE_TABLE
47 , p6_a17 JTF_NUMBER_TABLE
48 , p6_a18 JTF_DATE_TABLE
49 , p6_a19 JTF_NUMBER_TABLE
50 , p6_a20 JTF_NUMBER_TABLE
51 , p6_a21 JTF_NUMBER_TABLE
52 , p6_a22 JTF_NUMBER_TABLE
53 , p6_a23 JTF_NUMBER_TABLE
54 , p6_a24 JTF_NUMBER_TABLE
55 , p6_a25 JTF_NUMBER_TABLE
56 , p6_a26 JTF_NUMBER_TABLE
57 , p6_a27 JTF_VARCHAR2_TABLE_100
58 , p6_a28 JTF_VARCHAR2_TABLE_500
59 , p6_a29 JTF_VARCHAR2_TABLE_500
60 , p6_a30 JTF_VARCHAR2_TABLE_500
61 , p6_a31 JTF_VARCHAR2_TABLE_500
62 , p6_a32 JTF_VARCHAR2_TABLE_500
63 , p6_a33 JTF_VARCHAR2_TABLE_500
64 , p6_a34 JTF_VARCHAR2_TABLE_500
65 , p6_a35 JTF_VARCHAR2_TABLE_500
66 , p6_a36 JTF_VARCHAR2_TABLE_500
67 , p6_a37 JTF_VARCHAR2_TABLE_500
68 , p6_a38 JTF_VARCHAR2_TABLE_500
69 , p6_a39 JTF_VARCHAR2_TABLE_500
70 , p6_a40 JTF_VARCHAR2_TABLE_500
71 , p6_a41 JTF_VARCHAR2_TABLE_500
72 , p6_a42 JTF_VARCHAR2_TABLE_500
73 , p6_a43 JTF_NUMBER_TABLE
74 , p6_a44 JTF_NUMBER_TABLE
75 , p6_a45 JTF_NUMBER_TABLE
76 , p6_a46 JTF_DATE_TABLE
77 , p6_a47 JTF_NUMBER_TABLE
78 , p6_a48 JTF_NUMBER_TABLE
79 , p6_a49 JTF_NUMBER_TABLE
80 , p6_a50 JTF_DATE_TABLE
81 , p6_a51 JTF_NUMBER_TABLE
82 , p6_a52 JTF_DATE_TABLE
83 , p6_a53 JTF_NUMBER_TABLE
84 , p6_a54 JTF_NUMBER_TABLE
85 , p6_a55 JTF_NUMBER_TABLE
86 , p7_a0 JTF_NUMBER_TABLE
87 , p7_a1 JTF_NUMBER_TABLE
88 , p7_a2 JTF_VARCHAR2_TABLE_3000
89 , p7_a3 JTF_VARCHAR2_TABLE_100
90 , p7_a4 JTF_NUMBER_TABLE
91 , p7_a5 JTF_NUMBER_TABLE
92 , p7_a6 JTF_NUMBER_TABLE
93 , p7_a7 JTF_NUMBER_TABLE
94 , p7_a8 JTF_NUMBER_TABLE
95 , p7_a9 JTF_NUMBER_TABLE
96 , p7_a10 JTF_NUMBER_TABLE
97 , p7_a11 JTF_NUMBER_TABLE
98 , p7_a12 JTF_NUMBER_TABLE
99 , p7_a13 JTF_NUMBER_TABLE
100 , p7_a14 JTF_NUMBER_TABLE
101 , p7_a15 JTF_NUMBER_TABLE
102 , p7_a16 JTF_VARCHAR2_TABLE_100
103 , p7_a17 JTF_VARCHAR2_TABLE_2000
104 , p7_a18 JTF_NUMBER_TABLE
105 , p7_a19 JTF_DATE_TABLE
106 , p7_a20 JTF_VARCHAR2_TABLE_100
107 , p7_a21 JTF_NUMBER_TABLE
108 , p7_a22 JTF_VARCHAR2_TABLE_100
109 , p7_a23 JTF_VARCHAR2_TABLE_500
110 , p7_a24 JTF_VARCHAR2_TABLE_500
111 , p7_a25 JTF_VARCHAR2_TABLE_500
112 , p7_a26 JTF_VARCHAR2_TABLE_500
113 , p7_a27 JTF_VARCHAR2_TABLE_500
114 , p7_a28 JTF_VARCHAR2_TABLE_500
115 , p7_a29 JTF_VARCHAR2_TABLE_500
116 , p7_a30 JTF_VARCHAR2_TABLE_500
117 , p7_a31 JTF_VARCHAR2_TABLE_500
118 , p7_a32 JTF_VARCHAR2_TABLE_500
119 , p7_a33 JTF_VARCHAR2_TABLE_500
120 , p7_a34 JTF_VARCHAR2_TABLE_500
121 , p7_a35 JTF_VARCHAR2_TABLE_500
122 , p7_a36 JTF_VARCHAR2_TABLE_500
123 , p7_a37 JTF_VARCHAR2_TABLE_500
124 , p7_a38 JTF_NUMBER_TABLE
125 , p7_a39 JTF_NUMBER_TABLE
126 , p7_a40 JTF_NUMBER_TABLE
127 , p7_a41 JTF_DATE_TABLE
128 , p7_a42 JTF_NUMBER_TABLE
129 , p7_a43 JTF_NUMBER_TABLE
130 , p7_a44 JTF_NUMBER_TABLE
131 , p7_a45 JTF_DATE_TABLE
132 , p7_a46 JTF_NUMBER_TABLE
133 , p7_a47 JTF_DATE_TABLE
134 , p7_a48 JTF_NUMBER_TABLE
135 , p7_a49 JTF_NUMBER_TABLE
136 , p7_a50 JTF_VARCHAR2_TABLE_200
137 , p7_a51 JTF_VARCHAR2_TABLE_200
138 , p7_a52 JTF_DATE_TABLE
139 , p7_a53 JTF_DATE_TABLE
140 , p7_a54 JTF_VARCHAR2_TABLE_100
141 , p7_a55 JTF_VARCHAR2_TABLE_100
142 , p7_a56 JTF_VARCHAR2_TABLE_100
143 , p7_a57 JTF_VARCHAR2_TABLE_3000
144 , p7_a58 JTF_DATE_TABLE
145 , p7_a59 JTF_VARCHAR2_TABLE_300
146 , p7_a60 JTF_VARCHAR2_TABLE_100
147 , p7_a61 JTF_VARCHAR2_TABLE_100
148 , p7_a62 JTF_DATE_TABLE
149 , p7_a63 JTF_NUMBER_TABLE
150 , p7_a64 JTF_NUMBER_TABLE
151 , p7_a65 JTF_NUMBER_TABLE
152 , p8_a0 out nocopy NUMBER
153 , p8_a1 out nocopy NUMBER
154 , p8_a2 out nocopy VARCHAR2
155 , p8_a3 out nocopy VARCHAR2
156 , p8_a4 out nocopy VARCHAR2
157 , p8_a5 out nocopy NUMBER
158 , p8_a6 out nocopy DATE
159 , p8_a7 out nocopy NUMBER
160 , p8_a8 out nocopy NUMBER
161 , p8_a9 out nocopy NUMBER
162 , p8_a10 out nocopy NUMBER
163 , p8_a11 out nocopy NUMBER
164 , p8_a12 out nocopy NUMBER
165 , p8_a13 out nocopy NUMBER
166 , p8_a14 out nocopy VARCHAR2
167 , p8_a15 out nocopy NUMBER
168 , p8_a16 out nocopy NUMBER
169 , p8_a17 out nocopy NUMBER
170 , p8_a18 out nocopy NUMBER
171 , p8_a19 out nocopy NUMBER
172 , p8_a20 out nocopy NUMBER
173 , p8_a21 out nocopy NUMBER
174 , p8_a22 out nocopy NUMBER
175 , p8_a23 out nocopy DATE
176 , p8_a24 out nocopy NUMBER
177 , p8_a25 out nocopy VARCHAR2
178 , p8_a26 out nocopy VARCHAR2
179 , p8_a27 out nocopy NUMBER
180 , p8_a28 out nocopy NUMBER
181 , p8_a29 out nocopy NUMBER
182 , p8_a30 out nocopy VARCHAR2
183 , p8_a31 out nocopy VARCHAR2
184 , p8_a32 out nocopy VARCHAR2
185 , p8_a33 out nocopy VARCHAR2
186 , p8_a34 out nocopy VARCHAR2
187 , p8_a35 out nocopy VARCHAR2
188 , p8_a36 out nocopy VARCHAR2
189 , p8_a37 out nocopy VARCHAR2
190 , p8_a38 out nocopy VARCHAR2
191 , p8_a39 out nocopy VARCHAR2
192 , p8_a40 out nocopy VARCHAR2
193 , p8_a41 out nocopy VARCHAR2
194 , p8_a42 out nocopy VARCHAR2
195 , p8_a43 out nocopy VARCHAR2
196 , p8_a44 out nocopy VARCHAR2
197 , p8_a45 out nocopy VARCHAR2
198 , p8_a46 out nocopy DATE
199 , p8_a47 out nocopy NUMBER
200 , p8_a48 out nocopy NUMBER
201 , p8_a49 out nocopy NUMBER
202 , p8_a50 out nocopy DATE
203 , p8_a51 out nocopy NUMBER
204 , p8_a52 out nocopy NUMBER
205 , p8_a53 out nocopy DATE
206 , p8_a54 out nocopy NUMBER
207 , p8_a55 out nocopy DATE
208 , p8_a56 out nocopy NUMBER
209 , p8_a57 out nocopy NUMBER
210 , p8_a58 out nocopy VARCHAR2
211 , p8_a59 out nocopy VARCHAR2
212 , p8_a60 out nocopy VARCHAR2
213 , p8_a61 out nocopy NUMBER
214 , p8_a62 out nocopy VARCHAR2
215 , p8_a63 out nocopy DATE
216 , p8_a64 out nocopy VARCHAR2
217 , p8_a65 out nocopy NUMBER
218 , p8_a66 out nocopy NUMBER
219 , p8_a67 out nocopy NUMBER
220 , p8_a68 out nocopy NUMBER
221 , p8_a69 out nocopy VARCHAR2
222 , p8_a70 out nocopy VARCHAR2
223 , p8_a71 out nocopy NUMBER
224 , p8_a72 out nocopy VARCHAR2
225 , p9_a0 out nocopy JTF_NUMBER_TABLE
226 , p9_a1 out nocopy JTF_NUMBER_TABLE
227 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_3000
228 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
229 , p9_a4 out nocopy JTF_NUMBER_TABLE
230 , p9_a5 out nocopy JTF_NUMBER_TABLE
231 , p9_a6 out nocopy JTF_NUMBER_TABLE
232 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
233 , p9_a8 out nocopy JTF_NUMBER_TABLE
234 , p9_a9 out nocopy JTF_NUMBER_TABLE
235 , p9_a10 out nocopy JTF_NUMBER_TABLE
236 , p9_a11 out nocopy JTF_NUMBER_TABLE
237 , p9_a12 out nocopy JTF_NUMBER_TABLE
238 , p9_a13 out nocopy JTF_NUMBER_TABLE
239 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
240 , p9_a15 out nocopy JTF_NUMBER_TABLE
241 , p9_a16 out nocopy JTF_DATE_TABLE
242 , p9_a17 out nocopy JTF_NUMBER_TABLE
243 , p9_a18 out nocopy JTF_DATE_TABLE
244 , p9_a19 out nocopy JTF_NUMBER_TABLE
245 , p9_a20 out nocopy JTF_NUMBER_TABLE
246 , p9_a21 out nocopy JTF_NUMBER_TABLE
247 , p9_a22 out nocopy JTF_NUMBER_TABLE
248 , p9_a23 out nocopy JTF_NUMBER_TABLE
249 , p9_a24 out nocopy JTF_NUMBER_TABLE
250 , p9_a25 out nocopy JTF_NUMBER_TABLE
251 , p9_a26 out nocopy JTF_NUMBER_TABLE
252 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
253 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
254 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
255 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
256 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
257 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
258 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
259 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
260 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
261 , p9_a36 out nocopy JTF_VARCHAR2_TABLE_500
262 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_500
263 , p9_a38 out nocopy JTF_VARCHAR2_TABLE_500
264 , p9_a39 out nocopy JTF_VARCHAR2_TABLE_500
265 , p9_a40 out nocopy JTF_VARCHAR2_TABLE_500
266 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_500
267 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_500
268 , p9_a43 out nocopy JTF_NUMBER_TABLE
269 , p9_a44 out nocopy JTF_NUMBER_TABLE
270 , p9_a45 out nocopy JTF_NUMBER_TABLE
271 , p9_a46 out nocopy JTF_DATE_TABLE
272 , p9_a47 out nocopy JTF_NUMBER_TABLE
273 , p9_a48 out nocopy JTF_NUMBER_TABLE
274 , p9_a49 out nocopy JTF_NUMBER_TABLE
275 , p9_a50 out nocopy JTF_DATE_TABLE
276 , p9_a51 out nocopy JTF_NUMBER_TABLE
277 , p9_a52 out nocopy JTF_DATE_TABLE
278 , p9_a53 out nocopy JTF_NUMBER_TABLE
279 , p9_a54 out nocopy JTF_NUMBER_TABLE
280 , p9_a55 out nocopy JTF_NUMBER_TABLE
281 , p10_a0 out nocopy JTF_NUMBER_TABLE
282 , p10_a1 out nocopy JTF_NUMBER_TABLE
283 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_3000
284 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
285 , p10_a4 out nocopy JTF_NUMBER_TABLE
286 , p10_a5 out nocopy JTF_NUMBER_TABLE
287 , p10_a6 out nocopy JTF_NUMBER_TABLE
288 , p10_a7 out nocopy JTF_NUMBER_TABLE
289 , p10_a8 out nocopy JTF_NUMBER_TABLE
290 , p10_a9 out nocopy JTF_NUMBER_TABLE
291 , p10_a10 out nocopy JTF_NUMBER_TABLE
292 , p10_a11 out nocopy JTF_NUMBER_TABLE
293 , p10_a12 out nocopy JTF_NUMBER_TABLE
294 , p10_a13 out nocopy JTF_NUMBER_TABLE
295 , p10_a14 out nocopy JTF_NUMBER_TABLE
296 , p10_a15 out nocopy JTF_NUMBER_TABLE
297 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
298 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_2000
299 , p10_a18 out nocopy JTF_NUMBER_TABLE
300 , p10_a19 out nocopy JTF_DATE_TABLE
301 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
302 , p10_a21 out nocopy JTF_NUMBER_TABLE
303 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
304 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
305 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
306 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
307 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_500
308 , p10_a27 out nocopy JTF_VARCHAR2_TABLE_500
309 , p10_a28 out nocopy JTF_VARCHAR2_TABLE_500
310 , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
311 , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
312 , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
313 , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
314 , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
315 , p10_a34 out nocopy JTF_VARCHAR2_TABLE_500
316 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_500
317 , p10_a36 out nocopy JTF_VARCHAR2_TABLE_500
318 , p10_a37 out nocopy JTF_VARCHAR2_TABLE_500
319 , p10_a38 out nocopy JTF_NUMBER_TABLE
320 , p10_a39 out nocopy JTF_NUMBER_TABLE
321 , p10_a40 out nocopy JTF_NUMBER_TABLE
322 , p10_a41 out nocopy JTF_DATE_TABLE
323 , p10_a42 out nocopy JTF_NUMBER_TABLE
324 , p10_a43 out nocopy JTF_NUMBER_TABLE
325 , p10_a44 out nocopy JTF_NUMBER_TABLE
326 , p10_a45 out nocopy JTF_DATE_TABLE
327 , p10_a46 out nocopy JTF_NUMBER_TABLE
328 , p10_a47 out nocopy JTF_DATE_TABLE
329 , p10_a48 out nocopy JTF_NUMBER_TABLE
330 , p10_a49 out nocopy JTF_NUMBER_TABLE
331 , p10_a50 out nocopy JTF_VARCHAR2_TABLE_200
332 , p10_a51 out nocopy JTF_VARCHAR2_TABLE_200
333 , p10_a52 out nocopy JTF_DATE_TABLE
334 , p10_a53 out nocopy JTF_DATE_TABLE
335 , p10_a54 out nocopy JTF_VARCHAR2_TABLE_100
336 , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
337 , p10_a56 out nocopy JTF_VARCHAR2_TABLE_100
338 , p10_a57 out nocopy JTF_VARCHAR2_TABLE_3000
339 , p10_a58 out nocopy JTF_DATE_TABLE
340 , p10_a59 out nocopy JTF_VARCHAR2_TABLE_300
341 , p10_a60 out nocopy JTF_VARCHAR2_TABLE_100
342 , p10_a61 out nocopy JTF_VARCHAR2_TABLE_100
343 , p10_a62 out nocopy JTF_DATE_TABLE
344 , p10_a63 out nocopy JTF_NUMBER_TABLE
345 , p10_a64 out nocopy JTF_NUMBER_TABLE
346 , p10_a65 out nocopy JTF_NUMBER_TABLE
347 , p5_a0 NUMBER := 0-1962.0724
348 , p5_a1 NUMBER := 0-1962.0724
349 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
350 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
351 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a5 NUMBER := 0-1962.0724
353 , p5_a6 DATE := fnd_api.g_miss_date
354 , p5_a7 NUMBER := 0-1962.0724
355 , p5_a8 NUMBER := 0-1962.0724
356 , p5_a9 NUMBER := 0-1962.0724
357 , p5_a10 NUMBER := 0-1962.0724
358 , p5_a11 NUMBER := 0-1962.0724
359 , p5_a12 NUMBER := 0-1962.0724
360 , p5_a13 NUMBER := 0-1962.0724
361 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
362 , p5_a15 NUMBER := 0-1962.0724
363 , p5_a16 NUMBER := 0-1962.0724
364 , p5_a17 NUMBER := 0-1962.0724
365 , p5_a18 NUMBER := 0-1962.0724
366 , p5_a19 NUMBER := 0-1962.0724
367 , p5_a20 NUMBER := 0-1962.0724
368 , p5_a21 NUMBER := 0-1962.0724
369 , p5_a22 NUMBER := 0-1962.0724
370 , p5_a23 DATE := fnd_api.g_miss_date
371 , p5_a24 NUMBER := 0-1962.0724
372 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
373 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
374 , p5_a27 NUMBER := 0-1962.0724
375 , p5_a28 NUMBER := 0-1962.0724
376 , p5_a29 NUMBER := 0-1962.0724
377 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
378 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
379 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
380 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
381 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
382 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
383 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
387 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
391 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a46 DATE := fnd_api.g_miss_date
394 , p5_a47 NUMBER := 0-1962.0724
395 , p5_a48 NUMBER := 0-1962.0724
396 , p5_a49 NUMBER := 0-1962.0724
397 , p5_a50 DATE := fnd_api.g_miss_date
398 , p5_a51 NUMBER := 0-1962.0724
399 , p5_a52 NUMBER := 0-1962.0724
400 , p5_a53 DATE := fnd_api.g_miss_date
401 , p5_a54 NUMBER := 0-1962.0724
402 , p5_a55 DATE := fnd_api.g_miss_date
403 , p5_a56 NUMBER := 0-1962.0724
404 , p5_a57 NUMBER := 0-1962.0724
405 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
406 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
407 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
408 , p5_a61 NUMBER := 0-1962.0724
409 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
410 , p5_a63 DATE := fnd_api.g_miss_date
411 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
412 , p5_a65 NUMBER := 0-1962.0724
413 , p5_a66 NUMBER := 0-1962.0724
414 , p5_a67 NUMBER := 0-1962.0724
415 , p5_a68 NUMBER := 0-1962.0724
416 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a71 NUMBER := 0-1962.0724
419 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
420 )
421
422 as
423 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
424 ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
425 ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
426 ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
427 ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
428 ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
429 ddindx binary_integer; indx binary_integer;
430 begin
431
432 -- copy data to the local IN or IN-OUT args, if any
433
434
435
436
437
438 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
439 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
440 ddp_taiv_rec.sfwt_flag := p5_a2;
441 ddp_taiv_rec.currency_code := p5_a3;
442 ddp_taiv_rec.currency_conversion_type := p5_a4;
443 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
444 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
445 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
446 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
447 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
448 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
449 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
450 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
451 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
452 ddp_taiv_rec.trx_status_code := p5_a14;
453 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
454 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
455 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
456 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
457 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
458 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
459 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
460 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
461 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
462 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
463 ddp_taiv_rec.description := p5_a25;
464 ddp_taiv_rec.trx_number := p5_a26;
465 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
466 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
467 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
468 ddp_taiv_rec.attribute_category := p5_a30;
469 ddp_taiv_rec.attribute1 := p5_a31;
470 ddp_taiv_rec.attribute2 := p5_a32;
471 ddp_taiv_rec.attribute3 := p5_a33;
472 ddp_taiv_rec.attribute4 := p5_a34;
473 ddp_taiv_rec.attribute5 := p5_a35;
474 ddp_taiv_rec.attribute6 := p5_a36;
475 ddp_taiv_rec.attribute7 := p5_a37;
476 ddp_taiv_rec.attribute8 := p5_a38;
477 ddp_taiv_rec.attribute9 := p5_a39;
478 ddp_taiv_rec.attribute10 := p5_a40;
479 ddp_taiv_rec.attribute11 := p5_a41;
480 ddp_taiv_rec.attribute12 := p5_a42;
481 ddp_taiv_rec.attribute13 := p5_a43;
482 ddp_taiv_rec.attribute14 := p5_a44;
483 ddp_taiv_rec.attribute15 := p5_a45;
484 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
485 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
486 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
487 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
488 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
489 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
490 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
491 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
492 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
493 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
494 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
495 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
496 ddp_taiv_rec.investor_agreement_number := p5_a58;
497 ddp_taiv_rec.investor_name := p5_a59;
498 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
499 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
500 ddp_taiv_rec.invoice_pull_yn := p5_a62;
501 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
502 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
503 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
504 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
505 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
506 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
507 ddp_taiv_rec.tax_exempt_flag := p5_a69;
508 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
509 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
510 ddp_taiv_rec.private_label := p5_a72;
511
512 okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p6_a0
513 , p6_a1
514 , p6_a2
515 , p6_a3
516 , p6_a4
517 , p6_a5
518 , p6_a6
519 , p6_a7
520 , p6_a8
521 , p6_a9
522 , p6_a10
523 , p6_a11
524 , p6_a12
525 , p6_a13
526 , p6_a14
527 , p6_a15
528 , p6_a16
529 , p6_a17
530 , p6_a18
531 , p6_a19
532 , p6_a20
533 , p6_a21
534 , p6_a22
535 , p6_a23
536 , p6_a24
537 , p6_a25
538 , p6_a26
539 , p6_a27
540 , p6_a28
541 , p6_a29
542 , p6_a30
543 , p6_a31
544 , p6_a32
545 , p6_a33
546 , p6_a34
547 , p6_a35
548 , p6_a36
549 , p6_a37
550 , p6_a38
551 , p6_a39
552 , p6_a40
553 , p6_a41
554 , p6_a42
555 , p6_a43
556 , p6_a44
557 , p6_a45
558 , p6_a46
559 , p6_a47
560 , p6_a48
561 , p6_a49
562 , p6_a50
563 , p6_a51
564 , p6_a52
565 , p6_a53
566 , p6_a54
567 , p6_a55
568 );
569
570 okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p7_a0
571 , p7_a1
572 , p7_a2
573 , p7_a3
574 , p7_a4
575 , p7_a5
576 , p7_a6
577 , p7_a7
578 , p7_a8
579 , p7_a9
580 , p7_a10
581 , p7_a11
582 , p7_a12
583 , p7_a13
584 , p7_a14
585 , p7_a15
586 , p7_a16
587 , p7_a17
588 , p7_a18
589 , p7_a19
590 , p7_a20
591 , p7_a21
592 , p7_a22
593 , p7_a23
594 , p7_a24
595 , p7_a25
596 , p7_a26
597 , p7_a27
598 , p7_a28
599 , p7_a29
600 , p7_a30
601 , p7_a31
602 , p7_a32
603 , p7_a33
604 , p7_a34
605 , p7_a35
606 , p7_a36
607 , p7_a37
608 , p7_a38
609 , p7_a39
610 , p7_a40
611 , p7_a41
612 , p7_a42
613 , p7_a43
614 , p7_a44
615 , p7_a45
616 , p7_a46
617 , p7_a47
618 , p7_a48
619 , p7_a49
620 , p7_a50
621 , p7_a51
622 , p7_a52
623 , p7_a53
624 , p7_a54
625 , p7_a55
626 , p7_a56
627 , p7_a57
628 , p7_a58
629 , p7_a59
630 , p7_a60
631 , p7_a61
632 , p7_a62
633 , p7_a63
634 , p7_a64
635 , p7_a65
636 );
637
638
639
640
641 -- here's the delegated call to the old PL/SQL routine
642 okl_internal_billing_pvt.create_billing_trx(p_api_version,
643 p_init_msg_list,
644 x_return_status,
645 x_msg_count,
646 x_msg_data,
647 ddp_taiv_rec,
648 ddp_tilv_tbl,
649 ddp_tldv_tbl,
650 ddx_taiv_rec,
651 ddx_tilv_tbl,
652 ddx_tldv_tbl);
653
654 -- copy data back from the local variables to OUT or IN-OUT args, if any
655
656
657
658
659
660
661
662
663 p8_a0 := rosetta_g_miss_num_map(ddx_taiv_rec.id);
664 p8_a1 := rosetta_g_miss_num_map(ddx_taiv_rec.object_version_number);
665 p8_a2 := ddx_taiv_rec.sfwt_flag;
666 p8_a3 := ddx_taiv_rec.currency_code;
667 p8_a4 := ddx_taiv_rec.currency_conversion_type;
668 p8_a5 := rosetta_g_miss_num_map(ddx_taiv_rec.currency_conversion_rate);
669 p8_a6 := ddx_taiv_rec.currency_conversion_date;
670 p8_a7 := rosetta_g_miss_num_map(ddx_taiv_rec.khr_id);
671 p8_a8 := rosetta_g_miss_num_map(ddx_taiv_rec.cra_id);
672 p8_a9 := rosetta_g_miss_num_map(ddx_taiv_rec.tap_id);
673 p8_a10 := rosetta_g_miss_num_map(ddx_taiv_rec.qte_id);
674 p8_a11 := rosetta_g_miss_num_map(ddx_taiv_rec.tcn_id);
675 p8_a12 := rosetta_g_miss_num_map(ddx_taiv_rec.tai_id_reverses);
676 p8_a13 := rosetta_g_miss_num_map(ddx_taiv_rec.ipy_id);
677 p8_a14 := ddx_taiv_rec.trx_status_code;
678 p8_a15 := rosetta_g_miss_num_map(ddx_taiv_rec.set_of_books_id);
679 p8_a16 := rosetta_g_miss_num_map(ddx_taiv_rec.try_id);
680 p8_a17 := rosetta_g_miss_num_map(ddx_taiv_rec.ibt_id);
681 p8_a18 := rosetta_g_miss_num_map(ddx_taiv_rec.ixx_id);
682 p8_a19 := rosetta_g_miss_num_map(ddx_taiv_rec.irm_id);
683 p8_a20 := rosetta_g_miss_num_map(ddx_taiv_rec.irt_id);
684 p8_a21 := rosetta_g_miss_num_map(ddx_taiv_rec.svf_id);
685 p8_a22 := rosetta_g_miss_num_map(ddx_taiv_rec.amount);
686 p8_a23 := ddx_taiv_rec.date_invoiced;
687 p8_a24 := rosetta_g_miss_num_map(ddx_taiv_rec.amount_applied);
688 p8_a25 := ddx_taiv_rec.description;
689 p8_a26 := ddx_taiv_rec.trx_number;
690 p8_a27 := rosetta_g_miss_num_map(ddx_taiv_rec.clg_id);
691 p8_a28 := rosetta_g_miss_num_map(ddx_taiv_rec.pox_id);
692 p8_a29 := rosetta_g_miss_num_map(ddx_taiv_rec.cpy_id);
693 p8_a30 := ddx_taiv_rec.attribute_category;
694 p8_a31 := ddx_taiv_rec.attribute1;
695 p8_a32 := ddx_taiv_rec.attribute2;
696 p8_a33 := ddx_taiv_rec.attribute3;
697 p8_a34 := ddx_taiv_rec.attribute4;
698 p8_a35 := ddx_taiv_rec.attribute5;
699 p8_a36 := ddx_taiv_rec.attribute6;
700 p8_a37 := ddx_taiv_rec.attribute7;
701 p8_a38 := ddx_taiv_rec.attribute8;
702 p8_a39 := ddx_taiv_rec.attribute9;
703 p8_a40 := ddx_taiv_rec.attribute10;
704 p8_a41 := ddx_taiv_rec.attribute11;
705 p8_a42 := ddx_taiv_rec.attribute12;
706 p8_a43 := ddx_taiv_rec.attribute13;
707 p8_a44 := ddx_taiv_rec.attribute14;
708 p8_a45 := ddx_taiv_rec.attribute15;
709 p8_a46 := ddx_taiv_rec.date_entered;
710 p8_a47 := rosetta_g_miss_num_map(ddx_taiv_rec.request_id);
711 p8_a48 := rosetta_g_miss_num_map(ddx_taiv_rec.program_application_id);
712 p8_a49 := rosetta_g_miss_num_map(ddx_taiv_rec.program_id);
713 p8_a50 := ddx_taiv_rec.program_update_date;
714 p8_a51 := rosetta_g_miss_num_map(ddx_taiv_rec.org_id);
715 p8_a52 := rosetta_g_miss_num_map(ddx_taiv_rec.created_by);
716 p8_a53 := ddx_taiv_rec.creation_date;
717 p8_a54 := rosetta_g_miss_num_map(ddx_taiv_rec.last_updated_by);
718 p8_a55 := ddx_taiv_rec.last_update_date;
719 p8_a56 := rosetta_g_miss_num_map(ddx_taiv_rec.last_update_login);
720 p8_a57 := rosetta_g_miss_num_map(ddx_taiv_rec.legal_entity_id);
721 p8_a58 := ddx_taiv_rec.investor_agreement_number;
722 p8_a59 := ddx_taiv_rec.investor_name;
723 p8_a60 := ddx_taiv_rec.okl_source_billing_trx;
724 p8_a61 := rosetta_g_miss_num_map(ddx_taiv_rec.inf_id);
725 p8_a62 := ddx_taiv_rec.invoice_pull_yn;
726 p8_a63 := ddx_taiv_rec.due_date;
727 p8_a64 := ddx_taiv_rec.consolidated_invoice_number;
728 p8_a65 := rosetta_g_miss_num_map(ddx_taiv_rec.isi_id);
729 p8_a66 := rosetta_g_miss_num_map(ddx_taiv_rec.receivables_invoice_id);
730 p8_a67 := rosetta_g_miss_num_map(ddx_taiv_rec.cust_trx_type_id);
731 p8_a68 := rosetta_g_miss_num_map(ddx_taiv_rec.customer_bank_account_id);
732 p8_a69 := ddx_taiv_rec.tax_exempt_flag;
733 p8_a70 := ddx_taiv_rec.tax_exempt_reason_code;
734 p8_a71 := rosetta_g_miss_num_map(ddx_taiv_rec.reference_line_id);
735 p8_a72 := ddx_taiv_rec.private_label;
736
737 okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p9_a0
738 , p9_a1
739 , p9_a2
740 , p9_a3
741 , p9_a4
742 , p9_a5
743 , p9_a6
744 , p9_a7
745 , p9_a8
746 , p9_a9
747 , p9_a10
748 , p9_a11
749 , p9_a12
750 , p9_a13
751 , p9_a14
752 , p9_a15
753 , p9_a16
754 , p9_a17
755 , p9_a18
756 , p9_a19
757 , p9_a20
758 , p9_a21
759 , p9_a22
760 , p9_a23
761 , p9_a24
762 , p9_a25
763 , p9_a26
764 , p9_a27
765 , p9_a28
766 , p9_a29
767 , p9_a30
768 , p9_a31
769 , p9_a32
770 , p9_a33
771 , p9_a34
772 , p9_a35
773 , p9_a36
774 , p9_a37
775 , p9_a38
776 , p9_a39
777 , p9_a40
778 , p9_a41
779 , p9_a42
780 , p9_a43
781 , p9_a44
782 , p9_a45
783 , p9_a46
784 , p9_a47
785 , p9_a48
786 , p9_a49
787 , p9_a50
788 , p9_a51
789 , p9_a52
790 , p9_a53
791 , p9_a54
792 , p9_a55
793 );
794
795 okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p10_a0
796 , p10_a1
797 , p10_a2
798 , p10_a3
799 , p10_a4
800 , p10_a5
801 , p10_a6
802 , p10_a7
803 , p10_a8
804 , p10_a9
805 , p10_a10
806 , p10_a11
807 , p10_a12
808 , p10_a13
809 , p10_a14
810 , p10_a15
811 , p10_a16
812 , p10_a17
813 , p10_a18
814 , p10_a19
815 , p10_a20
816 , p10_a21
817 , p10_a22
818 , p10_a23
819 , p10_a24
820 , p10_a25
821 , p10_a26
822 , p10_a27
823 , p10_a28
824 , p10_a29
825 , p10_a30
826 , p10_a31
827 , p10_a32
828 , p10_a33
829 , p10_a34
830 , p10_a35
831 , p10_a36
832 , p10_a37
833 , p10_a38
834 , p10_a39
835 , p10_a40
836 , p10_a41
837 , p10_a42
838 , p10_a43
839 , p10_a44
840 , p10_a45
841 , p10_a46
842 , p10_a47
843 , p10_a48
844 , p10_a49
845 , p10_a50
846 , p10_a51
847 , p10_a52
848 , p10_a53
849 , p10_a54
850 , p10_a55
851 , p10_a56
852 , p10_a57
853 , p10_a58
854 , p10_a59
855 , p10_a60
856 , p10_a61
857 , p10_a62
858 , p10_a63
859 , p10_a64
860 , p10_a65
861 );
862 end;
863
864 procedure update_manual_invoice(p_api_version NUMBER
865 , p_init_msg_list VARCHAR2
866 , x_return_status out nocopy VARCHAR2
867 , x_msg_count out nocopy NUMBER
868 , x_msg_data out nocopy VARCHAR2
869 , p6_a0 JTF_NUMBER_TABLE
870 , p6_a1 JTF_NUMBER_TABLE
871 , p6_a2 JTF_VARCHAR2_TABLE_3000
872 , p6_a3 JTF_VARCHAR2_TABLE_100
873 , p6_a4 JTF_NUMBER_TABLE
874 , p6_a5 JTF_NUMBER_TABLE
875 , p6_a6 JTF_NUMBER_TABLE
876 , p6_a7 JTF_VARCHAR2_TABLE_100
877 , p6_a8 JTF_NUMBER_TABLE
878 , p6_a9 JTF_NUMBER_TABLE
879 , p6_a10 JTF_NUMBER_TABLE
880 , p6_a11 JTF_NUMBER_TABLE
881 , p6_a12 JTF_NUMBER_TABLE
882 , p6_a13 JTF_NUMBER_TABLE
883 , p6_a14 JTF_VARCHAR2_TABLE_2000
884 , p6_a15 JTF_NUMBER_TABLE
885 , p6_a16 JTF_DATE_TABLE
886 , p6_a17 JTF_NUMBER_TABLE
887 , p6_a18 JTF_DATE_TABLE
888 , p6_a19 JTF_NUMBER_TABLE
889 , p6_a20 JTF_NUMBER_TABLE
890 , p6_a21 JTF_NUMBER_TABLE
891 , p6_a22 JTF_NUMBER_TABLE
892 , p6_a23 JTF_NUMBER_TABLE
893 , p6_a24 JTF_NUMBER_TABLE
894 , p6_a25 JTF_NUMBER_TABLE
895 , p6_a26 JTF_NUMBER_TABLE
896 , p6_a27 JTF_VARCHAR2_TABLE_100
897 , p6_a28 JTF_VARCHAR2_TABLE_500
898 , p6_a29 JTF_VARCHAR2_TABLE_500
899 , p6_a30 JTF_VARCHAR2_TABLE_500
900 , p6_a31 JTF_VARCHAR2_TABLE_500
901 , p6_a32 JTF_VARCHAR2_TABLE_500
902 , p6_a33 JTF_VARCHAR2_TABLE_500
903 , p6_a34 JTF_VARCHAR2_TABLE_500
904 , p6_a35 JTF_VARCHAR2_TABLE_500
905 , p6_a36 JTF_VARCHAR2_TABLE_500
906 , p6_a37 JTF_VARCHAR2_TABLE_500
907 , p6_a38 JTF_VARCHAR2_TABLE_500
908 , p6_a39 JTF_VARCHAR2_TABLE_500
909 , p6_a40 JTF_VARCHAR2_TABLE_500
910 , p6_a41 JTF_VARCHAR2_TABLE_500
911 , p6_a42 JTF_VARCHAR2_TABLE_500
912 , p6_a43 JTF_NUMBER_TABLE
913 , p6_a44 JTF_NUMBER_TABLE
914 , p6_a45 JTF_NUMBER_TABLE
915 , p6_a46 JTF_DATE_TABLE
916 , p6_a47 JTF_NUMBER_TABLE
917 , p6_a48 JTF_NUMBER_TABLE
918 , p6_a49 JTF_NUMBER_TABLE
919 , p6_a50 JTF_DATE_TABLE
920 , p6_a51 JTF_NUMBER_TABLE
921 , p6_a52 JTF_DATE_TABLE
922 , p6_a53 JTF_NUMBER_TABLE
923 , p6_a54 JTF_NUMBER_TABLE
924 , p6_a55 JTF_NUMBER_TABLE
925 , p7_a0 out nocopy NUMBER
926 , p7_a1 out nocopy NUMBER
927 , p7_a2 out nocopy VARCHAR2
928 , p7_a3 out nocopy VARCHAR2
929 , p7_a4 out nocopy VARCHAR2
930 , p7_a5 out nocopy NUMBER
931 , p7_a6 out nocopy DATE
932 , p7_a7 out nocopy NUMBER
933 , p7_a8 out nocopy NUMBER
934 , p7_a9 out nocopy NUMBER
935 , p7_a10 out nocopy NUMBER
936 , p7_a11 out nocopy NUMBER
937 , p7_a12 out nocopy NUMBER
938 , p7_a13 out nocopy NUMBER
939 , p7_a14 out nocopy VARCHAR2
940 , p7_a15 out nocopy NUMBER
941 , p7_a16 out nocopy NUMBER
942 , p7_a17 out nocopy NUMBER
943 , p7_a18 out nocopy NUMBER
944 , p7_a19 out nocopy NUMBER
945 , p7_a20 out nocopy NUMBER
946 , p7_a21 out nocopy NUMBER
947 , p7_a22 out nocopy NUMBER
948 , p7_a23 out nocopy DATE
949 , p7_a24 out nocopy NUMBER
950 , p7_a25 out nocopy VARCHAR2
951 , p7_a26 out nocopy VARCHAR2
952 , p7_a27 out nocopy NUMBER
953 , p7_a28 out nocopy NUMBER
954 , p7_a29 out nocopy NUMBER
955 , p7_a30 out nocopy VARCHAR2
956 , p7_a31 out nocopy VARCHAR2
957 , p7_a32 out nocopy VARCHAR2
958 , p7_a33 out nocopy VARCHAR2
959 , p7_a34 out nocopy VARCHAR2
960 , p7_a35 out nocopy VARCHAR2
961 , p7_a36 out nocopy VARCHAR2
962 , p7_a37 out nocopy VARCHAR2
963 , p7_a38 out nocopy VARCHAR2
964 , p7_a39 out nocopy VARCHAR2
965 , p7_a40 out nocopy VARCHAR2
966 , p7_a41 out nocopy VARCHAR2
967 , p7_a42 out nocopy VARCHAR2
968 , p7_a43 out nocopy VARCHAR2
969 , p7_a44 out nocopy VARCHAR2
970 , p7_a45 out nocopy VARCHAR2
971 , p7_a46 out nocopy DATE
972 , p7_a47 out nocopy NUMBER
973 , p7_a48 out nocopy NUMBER
974 , p7_a49 out nocopy NUMBER
975 , p7_a50 out nocopy DATE
976 , p7_a51 out nocopy NUMBER
977 , p7_a52 out nocopy NUMBER
978 , p7_a53 out nocopy DATE
979 , p7_a54 out nocopy NUMBER
980 , p7_a55 out nocopy DATE
981 , p7_a56 out nocopy NUMBER
982 , p7_a57 out nocopy NUMBER
983 , p7_a58 out nocopy VARCHAR2
984 , p7_a59 out nocopy VARCHAR2
985 , p7_a60 out nocopy VARCHAR2
986 , p7_a61 out nocopy NUMBER
987 , p7_a62 out nocopy VARCHAR2
988 , p7_a63 out nocopy DATE
989 , p7_a64 out nocopy VARCHAR2
990 , p7_a65 out nocopy NUMBER
991 , p7_a66 out nocopy NUMBER
992 , p7_a67 out nocopy NUMBER
993 , p7_a68 out nocopy NUMBER
994 , p7_a69 out nocopy VARCHAR2
995 , p7_a70 out nocopy VARCHAR2
996 , p7_a71 out nocopy NUMBER
997 , p7_a72 out nocopy VARCHAR2
998 , p8_a0 out nocopy JTF_NUMBER_TABLE
999 , p8_a1 out nocopy JTF_NUMBER_TABLE
1000 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_3000
1001 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1002 , p8_a4 out nocopy JTF_NUMBER_TABLE
1003 , p8_a5 out nocopy JTF_NUMBER_TABLE
1004 , p8_a6 out nocopy JTF_NUMBER_TABLE
1005 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
1006 , p8_a8 out nocopy JTF_NUMBER_TABLE
1007 , p8_a9 out nocopy JTF_NUMBER_TABLE
1008 , p8_a10 out nocopy JTF_NUMBER_TABLE
1009 , p8_a11 out nocopy JTF_NUMBER_TABLE
1010 , p8_a12 out nocopy JTF_NUMBER_TABLE
1011 , p8_a13 out nocopy JTF_NUMBER_TABLE
1012 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1013 , p8_a15 out nocopy JTF_NUMBER_TABLE
1014 , p8_a16 out nocopy JTF_DATE_TABLE
1015 , p8_a17 out nocopy JTF_NUMBER_TABLE
1016 , p8_a18 out nocopy JTF_DATE_TABLE
1017 , p8_a19 out nocopy JTF_NUMBER_TABLE
1018 , p8_a20 out nocopy JTF_NUMBER_TABLE
1019 , p8_a21 out nocopy JTF_NUMBER_TABLE
1020 , p8_a22 out nocopy JTF_NUMBER_TABLE
1021 , p8_a23 out nocopy JTF_NUMBER_TABLE
1022 , p8_a24 out nocopy JTF_NUMBER_TABLE
1023 , p8_a25 out nocopy JTF_NUMBER_TABLE
1024 , p8_a26 out nocopy JTF_NUMBER_TABLE
1025 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_100
1026 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_500
1027 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
1028 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_500
1029 , p8_a31 out nocopy JTF_VARCHAR2_TABLE_500
1030 , p8_a32 out nocopy JTF_VARCHAR2_TABLE_500
1031 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_500
1032 , p8_a34 out nocopy JTF_VARCHAR2_TABLE_500
1033 , p8_a35 out nocopy JTF_VARCHAR2_TABLE_500
1034 , p8_a36 out nocopy JTF_VARCHAR2_TABLE_500
1035 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_500
1036 , p8_a38 out nocopy JTF_VARCHAR2_TABLE_500
1037 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_500
1038 , p8_a40 out nocopy JTF_VARCHAR2_TABLE_500
1039 , p8_a41 out nocopy JTF_VARCHAR2_TABLE_500
1040 , p8_a42 out nocopy JTF_VARCHAR2_TABLE_500
1041 , p8_a43 out nocopy JTF_NUMBER_TABLE
1042 , p8_a44 out nocopy JTF_NUMBER_TABLE
1043 , p8_a45 out nocopy JTF_NUMBER_TABLE
1044 , p8_a46 out nocopy JTF_DATE_TABLE
1045 , p8_a47 out nocopy JTF_NUMBER_TABLE
1046 , p8_a48 out nocopy JTF_NUMBER_TABLE
1047 , p8_a49 out nocopy JTF_NUMBER_TABLE
1048 , p8_a50 out nocopy JTF_DATE_TABLE
1049 , p8_a51 out nocopy JTF_NUMBER_TABLE
1050 , p8_a52 out nocopy JTF_DATE_TABLE
1051 , p8_a53 out nocopy JTF_NUMBER_TABLE
1052 , p8_a54 out nocopy JTF_NUMBER_TABLE
1053 , p8_a55 out nocopy JTF_NUMBER_TABLE
1054 , p9_a0 out nocopy JTF_NUMBER_TABLE
1055 , p9_a1 out nocopy JTF_NUMBER_TABLE
1056 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_3000
1057 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
1058 , p9_a4 out nocopy JTF_NUMBER_TABLE
1059 , p9_a5 out nocopy JTF_NUMBER_TABLE
1060 , p9_a6 out nocopy JTF_NUMBER_TABLE
1061 , p9_a7 out nocopy JTF_NUMBER_TABLE
1062 , p9_a8 out nocopy JTF_NUMBER_TABLE
1063 , p9_a9 out nocopy JTF_NUMBER_TABLE
1064 , p9_a10 out nocopy JTF_NUMBER_TABLE
1065 , p9_a11 out nocopy JTF_NUMBER_TABLE
1066 , p9_a12 out nocopy JTF_NUMBER_TABLE
1067 , p9_a13 out nocopy JTF_NUMBER_TABLE
1068 , p9_a14 out nocopy JTF_NUMBER_TABLE
1069 , p9_a15 out nocopy JTF_NUMBER_TABLE
1070 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
1071 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1072 , p9_a18 out nocopy JTF_NUMBER_TABLE
1073 , p9_a19 out nocopy JTF_DATE_TABLE
1074 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
1075 , p9_a21 out nocopy JTF_NUMBER_TABLE
1076 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
1077 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
1078 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
1079 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
1080 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
1081 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
1082 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
1083 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
1084 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
1085 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
1086 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
1087 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
1088 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
1089 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
1090 , p9_a36 out nocopy JTF_VARCHAR2_TABLE_500
1091 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_500
1092 , p9_a38 out nocopy JTF_NUMBER_TABLE
1093 , p9_a39 out nocopy JTF_NUMBER_TABLE
1094 , p9_a40 out nocopy JTF_NUMBER_TABLE
1095 , p9_a41 out nocopy JTF_DATE_TABLE
1096 , p9_a42 out nocopy JTF_NUMBER_TABLE
1097 , p9_a43 out nocopy JTF_NUMBER_TABLE
1098 , p9_a44 out nocopy JTF_NUMBER_TABLE
1099 , p9_a45 out nocopy JTF_DATE_TABLE
1100 , p9_a46 out nocopy JTF_NUMBER_TABLE
1101 , p9_a47 out nocopy JTF_DATE_TABLE
1102 , p9_a48 out nocopy JTF_NUMBER_TABLE
1103 , p9_a49 out nocopy JTF_NUMBER_TABLE
1104 , p9_a50 out nocopy JTF_VARCHAR2_TABLE_200
1105 , p9_a51 out nocopy JTF_VARCHAR2_TABLE_200
1106 , p9_a52 out nocopy JTF_DATE_TABLE
1107 , p9_a53 out nocopy JTF_DATE_TABLE
1108 , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
1109 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
1110 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
1111 , p9_a57 out nocopy JTF_VARCHAR2_TABLE_3000
1112 , p9_a58 out nocopy JTF_DATE_TABLE
1113 , p9_a59 out nocopy JTF_VARCHAR2_TABLE_300
1114 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
1115 , p9_a61 out nocopy JTF_VARCHAR2_TABLE_100
1116 , p9_a62 out nocopy JTF_DATE_TABLE
1117 , p9_a63 out nocopy JTF_NUMBER_TABLE
1118 , p9_a64 out nocopy JTF_NUMBER_TABLE
1119 , p9_a65 out nocopy JTF_NUMBER_TABLE
1120 , p5_a0 NUMBER := 0-1962.0724
1121 , p5_a1 NUMBER := 0-1962.0724
1122 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1123 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1124 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1125 , p5_a5 NUMBER := 0-1962.0724
1126 , p5_a6 DATE := fnd_api.g_miss_date
1127 , p5_a7 NUMBER := 0-1962.0724
1128 , p5_a8 NUMBER := 0-1962.0724
1129 , p5_a9 NUMBER := 0-1962.0724
1130 , p5_a10 NUMBER := 0-1962.0724
1131 , p5_a11 NUMBER := 0-1962.0724
1132 , p5_a12 NUMBER := 0-1962.0724
1133 , p5_a13 NUMBER := 0-1962.0724
1134 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1135 , p5_a15 NUMBER := 0-1962.0724
1136 , p5_a16 NUMBER := 0-1962.0724
1137 , p5_a17 NUMBER := 0-1962.0724
1138 , p5_a18 NUMBER := 0-1962.0724
1139 , p5_a19 NUMBER := 0-1962.0724
1140 , p5_a20 NUMBER := 0-1962.0724
1141 , p5_a21 NUMBER := 0-1962.0724
1142 , p5_a22 NUMBER := 0-1962.0724
1143 , p5_a23 DATE := fnd_api.g_miss_date
1144 , p5_a24 NUMBER := 0-1962.0724
1145 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1146 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1147 , p5_a27 NUMBER := 0-1962.0724
1148 , p5_a28 NUMBER := 0-1962.0724
1149 , p5_a29 NUMBER := 0-1962.0724
1150 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1151 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1152 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1153 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1154 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1155 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1156 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1157 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1158 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1159 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1160 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1161 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1162 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1163 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1164 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1165 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1166 , p5_a46 DATE := fnd_api.g_miss_date
1167 , p5_a47 NUMBER := 0-1962.0724
1168 , p5_a48 NUMBER := 0-1962.0724
1169 , p5_a49 NUMBER := 0-1962.0724
1170 , p5_a50 DATE := fnd_api.g_miss_date
1171 , p5_a51 NUMBER := 0-1962.0724
1172 , p5_a52 NUMBER := 0-1962.0724
1173 , p5_a53 DATE := fnd_api.g_miss_date
1174 , p5_a54 NUMBER := 0-1962.0724
1175 , p5_a55 DATE := fnd_api.g_miss_date
1176 , p5_a56 NUMBER := 0-1962.0724
1177 , p5_a57 NUMBER := 0-1962.0724
1178 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1179 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1180 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1181 , p5_a61 NUMBER := 0-1962.0724
1182 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1183 , p5_a63 DATE := fnd_api.g_miss_date
1184 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1185 , p5_a65 NUMBER := 0-1962.0724
1186 , p5_a66 NUMBER := 0-1962.0724
1187 , p5_a67 NUMBER := 0-1962.0724
1188 , p5_a68 NUMBER := 0-1962.0724
1189 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1190 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1191 , p5_a71 NUMBER := 0-1962.0724
1192 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1193 )
1194
1195 as
1196 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1197 ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
1198 ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
1199 ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1200 ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1201 ddindx binary_integer; indx binary_integer;
1202 begin
1203
1204 -- copy data to the local IN or IN-OUT args, if any
1205
1206
1207
1208
1209
1210 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
1211 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1212 ddp_taiv_rec.sfwt_flag := p5_a2;
1213 ddp_taiv_rec.currency_code := p5_a3;
1214 ddp_taiv_rec.currency_conversion_type := p5_a4;
1215 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
1216 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
1217 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
1218 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
1219 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
1220 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
1221 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
1222 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
1223 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
1224 ddp_taiv_rec.trx_status_code := p5_a14;
1225 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
1226 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
1227 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
1228 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
1229 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
1230 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
1231 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
1232 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
1233 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
1234 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
1235 ddp_taiv_rec.description := p5_a25;
1236 ddp_taiv_rec.trx_number := p5_a26;
1237 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
1238 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
1239 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
1240 ddp_taiv_rec.attribute_category := p5_a30;
1241 ddp_taiv_rec.attribute1 := p5_a31;
1242 ddp_taiv_rec.attribute2 := p5_a32;
1243 ddp_taiv_rec.attribute3 := p5_a33;
1244 ddp_taiv_rec.attribute4 := p5_a34;
1245 ddp_taiv_rec.attribute5 := p5_a35;
1246 ddp_taiv_rec.attribute6 := p5_a36;
1247 ddp_taiv_rec.attribute7 := p5_a37;
1248 ddp_taiv_rec.attribute8 := p5_a38;
1249 ddp_taiv_rec.attribute9 := p5_a39;
1250 ddp_taiv_rec.attribute10 := p5_a40;
1251 ddp_taiv_rec.attribute11 := p5_a41;
1252 ddp_taiv_rec.attribute12 := p5_a42;
1253 ddp_taiv_rec.attribute13 := p5_a43;
1254 ddp_taiv_rec.attribute14 := p5_a44;
1255 ddp_taiv_rec.attribute15 := p5_a45;
1256 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
1257 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
1258 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
1259 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
1260 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
1261 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
1262 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
1263 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
1264 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
1265 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
1266 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
1267 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
1268 ddp_taiv_rec.investor_agreement_number := p5_a58;
1269 ddp_taiv_rec.investor_name := p5_a59;
1270 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
1271 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
1272 ddp_taiv_rec.invoice_pull_yn := p5_a62;
1273 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
1274 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
1275 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
1276 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
1277 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
1278 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
1279 ddp_taiv_rec.tax_exempt_flag := p5_a69;
1280 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
1281 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
1282 ddp_taiv_rec.private_label := p5_a72;
1283
1284 okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p6_a0
1285 , p6_a1
1286 , p6_a2
1287 , p6_a3
1288 , p6_a4
1289 , p6_a5
1290 , p6_a6
1291 , p6_a7
1292 , p6_a8
1293 , p6_a9
1294 , p6_a10
1295 , p6_a11
1296 , p6_a12
1297 , p6_a13
1298 , p6_a14
1299 , p6_a15
1300 , p6_a16
1301 , p6_a17
1302 , p6_a18
1303 , p6_a19
1304 , p6_a20
1305 , p6_a21
1306 , p6_a22
1307 , p6_a23
1308 , p6_a24
1309 , p6_a25
1310 , p6_a26
1311 , p6_a27
1312 , p6_a28
1313 , p6_a29
1314 , p6_a30
1315 , p6_a31
1316 , p6_a32
1317 , p6_a33
1318 , p6_a34
1319 , p6_a35
1320 , p6_a36
1321 , p6_a37
1322 , p6_a38
1323 , p6_a39
1324 , p6_a40
1325 , p6_a41
1326 , p6_a42
1327 , p6_a43
1328 , p6_a44
1329 , p6_a45
1330 , p6_a46
1331 , p6_a47
1332 , p6_a48
1333 , p6_a49
1334 , p6_a50
1335 , p6_a51
1336 , p6_a52
1337 , p6_a53
1338 , p6_a54
1339 , p6_a55
1340 );
1341
1342
1343
1344
1345 -- here's the delegated call to the old PL/SQL routine
1346 okl_internal_billing_pvt.update_manual_invoice(p_api_version,
1347 p_init_msg_list,
1348 x_return_status,
1349 x_msg_count,
1350 x_msg_data,
1351 ddp_taiv_rec,
1352 ddp_tilv_tbl,
1353 ddx_taiv_rec,
1354 ddx_tilv_tbl,
1355 ddx_tldv_tbl);
1356
1357 -- copy data back from the local variables to OUT or IN-OUT args, if any
1358
1359
1360
1361
1362
1363
1364
1365 p7_a0 := rosetta_g_miss_num_map(ddx_taiv_rec.id);
1366 p7_a1 := rosetta_g_miss_num_map(ddx_taiv_rec.object_version_number);
1367 p7_a2 := ddx_taiv_rec.sfwt_flag;
1368 p7_a3 := ddx_taiv_rec.currency_code;
1369 p7_a4 := ddx_taiv_rec.currency_conversion_type;
1370 p7_a5 := rosetta_g_miss_num_map(ddx_taiv_rec.currency_conversion_rate);
1371 p7_a6 := ddx_taiv_rec.currency_conversion_date;
1372 p7_a7 := rosetta_g_miss_num_map(ddx_taiv_rec.khr_id);
1373 p7_a8 := rosetta_g_miss_num_map(ddx_taiv_rec.cra_id);
1374 p7_a9 := rosetta_g_miss_num_map(ddx_taiv_rec.tap_id);
1375 p7_a10 := rosetta_g_miss_num_map(ddx_taiv_rec.qte_id);
1376 p7_a11 := rosetta_g_miss_num_map(ddx_taiv_rec.tcn_id);
1377 p7_a12 := rosetta_g_miss_num_map(ddx_taiv_rec.tai_id_reverses);
1378 p7_a13 := rosetta_g_miss_num_map(ddx_taiv_rec.ipy_id);
1379 p7_a14 := ddx_taiv_rec.trx_status_code;
1380 p7_a15 := rosetta_g_miss_num_map(ddx_taiv_rec.set_of_books_id);
1381 p7_a16 := rosetta_g_miss_num_map(ddx_taiv_rec.try_id);
1382 p7_a17 := rosetta_g_miss_num_map(ddx_taiv_rec.ibt_id);
1383 p7_a18 := rosetta_g_miss_num_map(ddx_taiv_rec.ixx_id);
1384 p7_a19 := rosetta_g_miss_num_map(ddx_taiv_rec.irm_id);
1385 p7_a20 := rosetta_g_miss_num_map(ddx_taiv_rec.irt_id);
1386 p7_a21 := rosetta_g_miss_num_map(ddx_taiv_rec.svf_id);
1387 p7_a22 := rosetta_g_miss_num_map(ddx_taiv_rec.amount);
1388 p7_a23 := ddx_taiv_rec.date_invoiced;
1389 p7_a24 := rosetta_g_miss_num_map(ddx_taiv_rec.amount_applied);
1390 p7_a25 := ddx_taiv_rec.description;
1391 p7_a26 := ddx_taiv_rec.trx_number;
1392 p7_a27 := rosetta_g_miss_num_map(ddx_taiv_rec.clg_id);
1393 p7_a28 := rosetta_g_miss_num_map(ddx_taiv_rec.pox_id);
1394 p7_a29 := rosetta_g_miss_num_map(ddx_taiv_rec.cpy_id);
1395 p7_a30 := ddx_taiv_rec.attribute_category;
1396 p7_a31 := ddx_taiv_rec.attribute1;
1397 p7_a32 := ddx_taiv_rec.attribute2;
1398 p7_a33 := ddx_taiv_rec.attribute3;
1399 p7_a34 := ddx_taiv_rec.attribute4;
1400 p7_a35 := ddx_taiv_rec.attribute5;
1401 p7_a36 := ddx_taiv_rec.attribute6;
1402 p7_a37 := ddx_taiv_rec.attribute7;
1403 p7_a38 := ddx_taiv_rec.attribute8;
1404 p7_a39 := ddx_taiv_rec.attribute9;
1405 p7_a40 := ddx_taiv_rec.attribute10;
1406 p7_a41 := ddx_taiv_rec.attribute11;
1407 p7_a42 := ddx_taiv_rec.attribute12;
1408 p7_a43 := ddx_taiv_rec.attribute13;
1409 p7_a44 := ddx_taiv_rec.attribute14;
1410 p7_a45 := ddx_taiv_rec.attribute15;
1411 p7_a46 := ddx_taiv_rec.date_entered;
1412 p7_a47 := rosetta_g_miss_num_map(ddx_taiv_rec.request_id);
1413 p7_a48 := rosetta_g_miss_num_map(ddx_taiv_rec.program_application_id);
1414 p7_a49 := rosetta_g_miss_num_map(ddx_taiv_rec.program_id);
1415 p7_a50 := ddx_taiv_rec.program_update_date;
1416 p7_a51 := rosetta_g_miss_num_map(ddx_taiv_rec.org_id);
1417 p7_a52 := rosetta_g_miss_num_map(ddx_taiv_rec.created_by);
1418 p7_a53 := ddx_taiv_rec.creation_date;
1419 p7_a54 := rosetta_g_miss_num_map(ddx_taiv_rec.last_updated_by);
1420 p7_a55 := ddx_taiv_rec.last_update_date;
1421 p7_a56 := rosetta_g_miss_num_map(ddx_taiv_rec.last_update_login);
1422 p7_a57 := rosetta_g_miss_num_map(ddx_taiv_rec.legal_entity_id);
1423 p7_a58 := ddx_taiv_rec.investor_agreement_number;
1424 p7_a59 := ddx_taiv_rec.investor_name;
1425 p7_a60 := ddx_taiv_rec.okl_source_billing_trx;
1426 p7_a61 := rosetta_g_miss_num_map(ddx_taiv_rec.inf_id);
1427 p7_a62 := ddx_taiv_rec.invoice_pull_yn;
1428 p7_a63 := ddx_taiv_rec.due_date;
1429 p7_a64 := ddx_taiv_rec.consolidated_invoice_number;
1430 p7_a65 := rosetta_g_miss_num_map(ddx_taiv_rec.isi_id);
1431 p7_a66 := rosetta_g_miss_num_map(ddx_taiv_rec.receivables_invoice_id);
1432 p7_a67 := rosetta_g_miss_num_map(ddx_taiv_rec.cust_trx_type_id);
1433 p7_a68 := rosetta_g_miss_num_map(ddx_taiv_rec.customer_bank_account_id);
1434 p7_a69 := ddx_taiv_rec.tax_exempt_flag;
1435 p7_a70 := ddx_taiv_rec.tax_exempt_reason_code;
1436 p7_a71 := rosetta_g_miss_num_map(ddx_taiv_rec.reference_line_id);
1437 p7_a72 := ddx_taiv_rec.private_label;
1438
1439 okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p8_a0
1440 , p8_a1
1441 , p8_a2
1442 , p8_a3
1443 , p8_a4
1444 , p8_a5
1445 , p8_a6
1446 , p8_a7
1447 , p8_a8
1448 , p8_a9
1449 , p8_a10
1450 , p8_a11
1451 , p8_a12
1452 , p8_a13
1453 , p8_a14
1454 , p8_a15
1455 , p8_a16
1456 , p8_a17
1457 , p8_a18
1458 , p8_a19
1459 , p8_a20
1460 , p8_a21
1461 , p8_a22
1462 , p8_a23
1463 , p8_a24
1464 , p8_a25
1465 , p8_a26
1466 , p8_a27
1467 , p8_a28
1468 , p8_a29
1469 , p8_a30
1470 , p8_a31
1471 , p8_a32
1472 , p8_a33
1473 , p8_a34
1474 , p8_a35
1475 , p8_a36
1476 , p8_a37
1477 , p8_a38
1478 , p8_a39
1479 , p8_a40
1480 , p8_a41
1481 , p8_a42
1482 , p8_a43
1483 , p8_a44
1484 , p8_a45
1485 , p8_a46
1486 , p8_a47
1487 , p8_a48
1488 , p8_a49
1489 , p8_a50
1490 , p8_a51
1491 , p8_a52
1492 , p8_a53
1493 , p8_a54
1494 , p8_a55
1495 );
1496
1497 okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p9_a0
1498 , p9_a1
1499 , p9_a2
1500 , p9_a3
1501 , p9_a4
1502 , p9_a5
1503 , p9_a6
1504 , p9_a7
1505 , p9_a8
1506 , p9_a9
1507 , p9_a10
1508 , p9_a11
1509 , p9_a12
1510 , p9_a13
1511 , p9_a14
1512 , p9_a15
1513 , p9_a16
1514 , p9_a17
1515 , p9_a18
1516 , p9_a19
1517 , p9_a20
1518 , p9_a21
1519 , p9_a22
1520 , p9_a23
1521 , p9_a24
1522 , p9_a25
1523 , p9_a26
1524 , p9_a27
1525 , p9_a28
1526 , p9_a29
1527 , p9_a30
1528 , p9_a31
1529 , p9_a32
1530 , p9_a33
1531 , p9_a34
1532 , p9_a35
1533 , p9_a36
1534 , p9_a37
1535 , p9_a38
1536 , p9_a39
1537 , p9_a40
1538 , p9_a41
1539 , p9_a42
1540 , p9_a43
1541 , p9_a44
1542 , p9_a45
1543 , p9_a46
1544 , p9_a47
1545 , p9_a48
1546 , p9_a49
1547 , p9_a50
1548 , p9_a51
1549 , p9_a52
1550 , p9_a53
1551 , p9_a54
1552 , p9_a55
1553 , p9_a56
1554 , p9_a57
1555 , p9_a58
1556 , p9_a59
1557 , p9_a60
1558 , p9_a61
1559 , p9_a62
1560 , p9_a63
1561 , p9_a64
1562 , p9_a65
1563 );
1564 end;
1565
1566 end okl_internal_billing_pvt_w;