[Home] [Help]
PACKAGE BODY: APPS.OKL_SYP_PVT_W
Source
1 package body okl_syp_pvt_w as
2 /* $Header: OKLISYPB.pls 120.15.12010000.2 2008/11/13 16:18:16 kkorrapo ship $ */
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 rosetta_table_copy_in_p2(t out nocopy okl_syp_pvt.sypv_tbl_type, a0 JTF_NUMBER_TABLE
26 , a1 JTF_VARCHAR2_TABLE_100
27 , a2 JTF_VARCHAR2_TABLE_100
28 , a3 JTF_NUMBER_TABLE
29 , a4 JTF_NUMBER_TABLE
30 , a5 JTF_VARCHAR2_TABLE_100
31 , a6 JTF_NUMBER_TABLE
32 , a7 JTF_VARCHAR2_TABLE_100
33 , a8 JTF_VARCHAR2_TABLE_100
34 , a9 JTF_VARCHAR2_TABLE_100
35 , a10 JTF_VARCHAR2_TABLE_100
36 , a11 JTF_VARCHAR2_TABLE_100
37 , a12 JTF_NUMBER_TABLE
38 , a13 JTF_NUMBER_TABLE
39 , a14 JTF_NUMBER_TABLE
40 , a15 JTF_VARCHAR2_TABLE_100
41 , a16 JTF_VARCHAR2_TABLE_100
42 , a17 JTF_NUMBER_TABLE
43 , a18 JTF_VARCHAR2_TABLE_100
44 , a19 JTF_NUMBER_TABLE
45 , a20 JTF_NUMBER_TABLE
46 , a21 JTF_VARCHAR2_TABLE_100
47 , a22 JTF_VARCHAR2_TABLE_100
48 , a23 JTF_NUMBER_TABLE
49 , a24 JTF_VARCHAR2_TABLE_100
50 , a25 JTF_VARCHAR2_TABLE_100
51 , a26 JTF_VARCHAR2_TABLE_100
52 , a27 JTF_VARCHAR2_TABLE_100
53 , a28 JTF_NUMBER_TABLE
54 , a29 JTF_NUMBER_TABLE
55 , a30 JTF_NUMBER_TABLE
56 , a31 JTF_VARCHAR2_TABLE_100
57 , a32 JTF_NUMBER_TABLE
58 , a33 JTF_NUMBER_TABLE
59 , a34 JTF_NUMBER_TABLE
60 , a35 JTF_NUMBER_TABLE
61 , a36 JTF_NUMBER_TABLE
62 , a37 JTF_DATE_TABLE
63 , a38 JTF_VARCHAR2_TABLE_100
64 , a39 JTF_VARCHAR2_TABLE_500
65 , a40 JTF_VARCHAR2_TABLE_500
66 , a41 JTF_VARCHAR2_TABLE_500
67 , a42 JTF_VARCHAR2_TABLE_500
68 , a43 JTF_VARCHAR2_TABLE_500
69 , a44 JTF_VARCHAR2_TABLE_500
70 , a45 JTF_VARCHAR2_TABLE_500
71 , a46 JTF_VARCHAR2_TABLE_500
72 , a47 JTF_VARCHAR2_TABLE_500
73 , a48 JTF_VARCHAR2_TABLE_500
74 , a49 JTF_VARCHAR2_TABLE_500
75 , a50 JTF_VARCHAR2_TABLE_500
76 , a51 JTF_VARCHAR2_TABLE_500
77 , a52 JTF_VARCHAR2_TABLE_500
78 , a53 JTF_VARCHAR2_TABLE_500
79 , a54 JTF_NUMBER_TABLE
80 , a55 JTF_DATE_TABLE
81 , a56 JTF_NUMBER_TABLE
82 , a57 JTF_DATE_TABLE
83 , a58 JTF_NUMBER_TABLE
84 , a59 JTF_VARCHAR2_TABLE_200
85 , a60 JTF_VARCHAR2_TABLE_200
86 , a61 JTF_VARCHAR2_TABLE_200
87 , a62 JTF_VARCHAR2_TABLE_200
88 ) as
89 ddindx binary_integer; indx binary_integer;
90 begin
91 if a0 is not null and a0.count > 0 then
92 if a0.count > 0 then
93 indx := a0.first;
94 ddindx := 1;
95 while true loop
96 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
97 t(ddindx).delink_yn := a1(indx);
98 t(ddindx).remk_subinventory := a2(indx);
99 t(ddindx).remk_organization_id := rosetta_g_miss_num_map(a3(indx));
100 t(ddindx).remk_price_list_id := rosetta_g_miss_num_map(a4(indx));
101 t(ddindx).remk_process_code := a5(indx);
102 t(ddindx).remk_item_template_id := rosetta_g_miss_num_map(a6(indx));
103 t(ddindx).remk_item_invoiced_code := a7(indx);
104 t(ddindx).lease_inv_org_yn := a8(indx);
105 t(ddindx).tax_upfront_yn := a9(indx);
106 t(ddindx).tax_invoice_yn := a10(indx);
107 t(ddindx).tax_schedule_yn := a11(indx);
108 t(ddindx).tax_upfront_sty_id := rosetta_g_miss_num_map(a12(indx));
109 t(ddindx).category_set_id := rosetta_g_miss_num_map(a13(indx));
110 t(ddindx).validation_set_id := rosetta_g_miss_num_map(a14(indx));
111 t(ddindx).cancel_quotes_yn := a15(indx);
112 t(ddindx).chk_accrual_previous_mnth_yn := a16(indx);
113 t(ddindx).task_template_group_id := rosetta_g_miss_num_map(a17(indx));
114 t(ddindx).owner_type_code := a18(indx);
115 t(ddindx).owner_id := rosetta_g_miss_num_map(a19(indx));
116 t(ddindx).item_inv_org_id := rosetta_g_miss_num_map(a20(indx));
117 t(ddindx).rpt_prod_book_type_code := a21(indx);
118 t(ddindx).asst_add_book_type_code := a22(indx);
119 t(ddindx).ccard_remittance_id := rosetta_g_miss_num_map(a23(indx));
120 t(ddindx).corporate_book := a24(indx);
121 t(ddindx).tax_book_1 := a25(indx);
122 t(ddindx).tax_book_2 := a26(indx);
123 t(ddindx).depreciate_yn := a27(indx);
124 t(ddindx).fa_location_id := rosetta_g_miss_num_map(a28(indx));
125 t(ddindx).formula_id := rosetta_g_miss_num_map(a29(indx));
126 t(ddindx).asset_key_id := rosetta_g_miss_num_map(a30(indx));
127 t(ddindx).part_trmnt_apply_round_diff := a31(indx);
128 t(ddindx).object_version_number := rosetta_g_miss_num_map(a32(indx));
129 t(ddindx).org_id := rosetta_g_miss_num_map(a33(indx));
130 t(ddindx).request_id := rosetta_g_miss_num_map(a34(indx));
131 t(ddindx).program_application_id := rosetta_g_miss_num_map(a35(indx));
132 t(ddindx).program_id := rosetta_g_miss_num_map(a36(indx));
133 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a37(indx));
134 t(ddindx).attribute_category := a38(indx);
135 t(ddindx).attribute1 := a39(indx);
136 t(ddindx).attribute2 := a40(indx);
137 t(ddindx).attribute3 := a41(indx);
138 t(ddindx).attribute4 := a42(indx);
139 t(ddindx).attribute5 := a43(indx);
140 t(ddindx).attribute6 := a44(indx);
141 t(ddindx).attribute7 := a45(indx);
142 t(ddindx).attribute8 := a46(indx);
143 t(ddindx).attribute9 := a47(indx);
144 t(ddindx).attribute10 := a48(indx);
145 t(ddindx).attribute11 := a49(indx);
146 t(ddindx).attribute12 := a50(indx);
147 t(ddindx).attribute13 := a51(indx);
148 t(ddindx).attribute14 := a52(indx);
149 t(ddindx).attribute15 := a53(indx);
150 t(ddindx).created_by := rosetta_g_miss_num_map(a54(indx));
151 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a55(indx));
152 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a56(indx));
153 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a57(indx));
154 t(ddindx).last_update_login := rosetta_g_miss_num_map(a58(indx));
155 t(ddindx).lseapp_seq_prefix_txt := a59(indx);
156 t(ddindx).lseopp_seq_prefix_txt := a60(indx);
157 t(ddindx).qckqte_seq_prefix_txt := a61(indx);
158 t(ddindx).lseqte_seq_prefix_txt := a62(indx);
159 ddindx := ddindx+1;
160 if a0.last =indx
161 then exit;
162 end if;
163 indx := a0.next(indx);
164 end loop;
165 end if;
166 end if;
167 end rosetta_table_copy_in_p2;
168 procedure rosetta_table_copy_out_p2(t okl_syp_pvt.sypv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
169 , a1 out nocopy JTF_VARCHAR2_TABLE_100
170 , a2 out nocopy JTF_VARCHAR2_TABLE_100
171 , a3 out nocopy JTF_NUMBER_TABLE
172 , a4 out nocopy JTF_NUMBER_TABLE
173 , a5 out nocopy JTF_VARCHAR2_TABLE_100
174 , a6 out nocopy JTF_NUMBER_TABLE
175 , a7 out nocopy JTF_VARCHAR2_TABLE_100
176 , a8 out nocopy JTF_VARCHAR2_TABLE_100
177 , a9 out nocopy JTF_VARCHAR2_TABLE_100
178 , a10 out nocopy JTF_VARCHAR2_TABLE_100
179 , a11 out nocopy JTF_VARCHAR2_TABLE_100
180 , a12 out nocopy JTF_NUMBER_TABLE
181 , a13 out nocopy JTF_NUMBER_TABLE
182 , a14 out nocopy JTF_NUMBER_TABLE
183 , a15 out nocopy JTF_VARCHAR2_TABLE_100
184 , a16 out nocopy JTF_VARCHAR2_TABLE_100
185 , a17 out nocopy JTF_NUMBER_TABLE
186 , a18 out nocopy JTF_VARCHAR2_TABLE_100
187 , a19 out nocopy JTF_NUMBER_TABLE
188 , a20 out nocopy JTF_NUMBER_TABLE
189 , a21 out nocopy JTF_VARCHAR2_TABLE_100
190 , a22 out nocopy JTF_VARCHAR2_TABLE_100
191 , a23 out nocopy JTF_NUMBER_TABLE
192 , a24 out nocopy JTF_VARCHAR2_TABLE_100
193 , a25 out nocopy JTF_VARCHAR2_TABLE_100
194 , a26 out nocopy JTF_VARCHAR2_TABLE_100
195 , a27 out nocopy JTF_VARCHAR2_TABLE_100
196 , a28 out nocopy JTF_NUMBER_TABLE
197 , a29 out nocopy JTF_NUMBER_TABLE
198 , a30 out nocopy JTF_NUMBER_TABLE
199 , a31 out nocopy JTF_VARCHAR2_TABLE_100
200 , a32 out nocopy JTF_NUMBER_TABLE
201 , a33 out nocopy JTF_NUMBER_TABLE
202 , a34 out nocopy JTF_NUMBER_TABLE
203 , a35 out nocopy JTF_NUMBER_TABLE
204 , a36 out nocopy JTF_NUMBER_TABLE
205 , a37 out nocopy JTF_DATE_TABLE
206 , a38 out nocopy JTF_VARCHAR2_TABLE_100
207 , a39 out nocopy JTF_VARCHAR2_TABLE_500
208 , a40 out nocopy JTF_VARCHAR2_TABLE_500
209 , a41 out nocopy JTF_VARCHAR2_TABLE_500
210 , a42 out nocopy JTF_VARCHAR2_TABLE_500
211 , a43 out nocopy JTF_VARCHAR2_TABLE_500
212 , a44 out nocopy JTF_VARCHAR2_TABLE_500
213 , a45 out nocopy JTF_VARCHAR2_TABLE_500
214 , a46 out nocopy JTF_VARCHAR2_TABLE_500
215 , a47 out nocopy JTF_VARCHAR2_TABLE_500
216 , a48 out nocopy JTF_VARCHAR2_TABLE_500
217 , a49 out nocopy JTF_VARCHAR2_TABLE_500
218 , a50 out nocopy JTF_VARCHAR2_TABLE_500
219 , a51 out nocopy JTF_VARCHAR2_TABLE_500
220 , a52 out nocopy JTF_VARCHAR2_TABLE_500
221 , a53 out nocopy JTF_VARCHAR2_TABLE_500
222 , a54 out nocopy JTF_NUMBER_TABLE
223 , a55 out nocopy JTF_DATE_TABLE
224 , a56 out nocopy JTF_NUMBER_TABLE
225 , a57 out nocopy JTF_DATE_TABLE
226 , a58 out nocopy JTF_NUMBER_TABLE
227 , a59 out nocopy JTF_VARCHAR2_TABLE_200
228 , a60 out nocopy JTF_VARCHAR2_TABLE_200
229 , a61 out nocopy JTF_VARCHAR2_TABLE_200
230 , a62 out nocopy JTF_VARCHAR2_TABLE_200
231 ) as
232 ddindx binary_integer; indx binary_integer;
233 begin
234 if t is null or t.count = 0 then
235 a0 := JTF_NUMBER_TABLE();
236 a1 := JTF_VARCHAR2_TABLE_100();
237 a2 := JTF_VARCHAR2_TABLE_100();
238 a3 := JTF_NUMBER_TABLE();
239 a4 := JTF_NUMBER_TABLE();
240 a5 := JTF_VARCHAR2_TABLE_100();
241 a6 := JTF_NUMBER_TABLE();
242 a7 := JTF_VARCHAR2_TABLE_100();
243 a8 := JTF_VARCHAR2_TABLE_100();
244 a9 := JTF_VARCHAR2_TABLE_100();
245 a10 := JTF_VARCHAR2_TABLE_100();
246 a11 := JTF_VARCHAR2_TABLE_100();
247 a12 := JTF_NUMBER_TABLE();
248 a13 := JTF_NUMBER_TABLE();
249 a14 := JTF_NUMBER_TABLE();
250 a15 := JTF_VARCHAR2_TABLE_100();
251 a16 := JTF_VARCHAR2_TABLE_100();
252 a17 := JTF_NUMBER_TABLE();
253 a18 := JTF_VARCHAR2_TABLE_100();
254 a19 := JTF_NUMBER_TABLE();
255 a20 := JTF_NUMBER_TABLE();
256 a21 := JTF_VARCHAR2_TABLE_100();
257 a22 := JTF_VARCHAR2_TABLE_100();
258 a23 := JTF_NUMBER_TABLE();
259 a24 := JTF_VARCHAR2_TABLE_100();
260 a25 := JTF_VARCHAR2_TABLE_100();
261 a26 := JTF_VARCHAR2_TABLE_100();
262 a27 := JTF_VARCHAR2_TABLE_100();
263 a28 := JTF_NUMBER_TABLE();
264 a29 := JTF_NUMBER_TABLE();
265 a30 := JTF_NUMBER_TABLE();
266 a31 := JTF_VARCHAR2_TABLE_100();
267 a32 := JTF_NUMBER_TABLE();
268 a33 := JTF_NUMBER_TABLE();
269 a34 := JTF_NUMBER_TABLE();
270 a35 := JTF_NUMBER_TABLE();
271 a36 := JTF_NUMBER_TABLE();
272 a37 := JTF_DATE_TABLE();
273 a38 := JTF_VARCHAR2_TABLE_100();
274 a39 := JTF_VARCHAR2_TABLE_500();
275 a40 := JTF_VARCHAR2_TABLE_500();
276 a41 := JTF_VARCHAR2_TABLE_500();
277 a42 := JTF_VARCHAR2_TABLE_500();
278 a43 := JTF_VARCHAR2_TABLE_500();
279 a44 := JTF_VARCHAR2_TABLE_500();
280 a45 := JTF_VARCHAR2_TABLE_500();
281 a46 := JTF_VARCHAR2_TABLE_500();
282 a47 := JTF_VARCHAR2_TABLE_500();
283 a48 := JTF_VARCHAR2_TABLE_500();
284 a49 := JTF_VARCHAR2_TABLE_500();
285 a50 := JTF_VARCHAR2_TABLE_500();
286 a51 := JTF_VARCHAR2_TABLE_500();
287 a52 := JTF_VARCHAR2_TABLE_500();
288 a53 := JTF_VARCHAR2_TABLE_500();
289 a54 := JTF_NUMBER_TABLE();
290 a55 := JTF_DATE_TABLE();
291 a56 := JTF_NUMBER_TABLE();
292 a57 := JTF_DATE_TABLE();
293 a58 := JTF_NUMBER_TABLE();
294 a59 := JTF_VARCHAR2_TABLE_200();
295 a60 := JTF_VARCHAR2_TABLE_200();
296 a61 := JTF_VARCHAR2_TABLE_200();
297 a62 := JTF_VARCHAR2_TABLE_200();
298 else
299 a0 := JTF_NUMBER_TABLE();
300 a1 := JTF_VARCHAR2_TABLE_100();
301 a2 := JTF_VARCHAR2_TABLE_100();
302 a3 := JTF_NUMBER_TABLE();
303 a4 := JTF_NUMBER_TABLE();
304 a5 := JTF_VARCHAR2_TABLE_100();
305 a6 := JTF_NUMBER_TABLE();
306 a7 := JTF_VARCHAR2_TABLE_100();
307 a8 := JTF_VARCHAR2_TABLE_100();
308 a9 := JTF_VARCHAR2_TABLE_100();
309 a10 := JTF_VARCHAR2_TABLE_100();
310 a11 := JTF_VARCHAR2_TABLE_100();
311 a12 := JTF_NUMBER_TABLE();
312 a13 := JTF_NUMBER_TABLE();
313 a14 := JTF_NUMBER_TABLE();
314 a15 := JTF_VARCHAR2_TABLE_100();
315 a16 := JTF_VARCHAR2_TABLE_100();
316 a17 := JTF_NUMBER_TABLE();
317 a18 := JTF_VARCHAR2_TABLE_100();
318 a19 := JTF_NUMBER_TABLE();
319 a20 := JTF_NUMBER_TABLE();
320 a21 := JTF_VARCHAR2_TABLE_100();
321 a22 := JTF_VARCHAR2_TABLE_100();
322 a23 := JTF_NUMBER_TABLE();
323 a24 := JTF_VARCHAR2_TABLE_100();
324 a25 := JTF_VARCHAR2_TABLE_100();
325 a26 := JTF_VARCHAR2_TABLE_100();
326 a27 := JTF_VARCHAR2_TABLE_100();
327 a28 := JTF_NUMBER_TABLE();
328 a29 := JTF_NUMBER_TABLE();
329 a30 := JTF_NUMBER_TABLE();
330 a31 := JTF_VARCHAR2_TABLE_100();
331 a32 := JTF_NUMBER_TABLE();
332 a33 := JTF_NUMBER_TABLE();
333 a34 := JTF_NUMBER_TABLE();
334 a35 := JTF_NUMBER_TABLE();
335 a36 := JTF_NUMBER_TABLE();
336 a37 := JTF_DATE_TABLE();
337 a38 := JTF_VARCHAR2_TABLE_100();
338 a39 := JTF_VARCHAR2_TABLE_500();
339 a40 := JTF_VARCHAR2_TABLE_500();
340 a41 := JTF_VARCHAR2_TABLE_500();
341 a42 := JTF_VARCHAR2_TABLE_500();
342 a43 := JTF_VARCHAR2_TABLE_500();
343 a44 := JTF_VARCHAR2_TABLE_500();
344 a45 := JTF_VARCHAR2_TABLE_500();
345 a46 := JTF_VARCHAR2_TABLE_500();
346 a47 := JTF_VARCHAR2_TABLE_500();
347 a48 := JTF_VARCHAR2_TABLE_500();
348 a49 := JTF_VARCHAR2_TABLE_500();
349 a50 := JTF_VARCHAR2_TABLE_500();
350 a51 := JTF_VARCHAR2_TABLE_500();
351 a52 := JTF_VARCHAR2_TABLE_500();
352 a53 := JTF_VARCHAR2_TABLE_500();
353 a54 := JTF_NUMBER_TABLE();
354 a55 := JTF_DATE_TABLE();
355 a56 := JTF_NUMBER_TABLE();
356 a57 := JTF_DATE_TABLE();
357 a58 := JTF_NUMBER_TABLE();
358 a59 := JTF_VARCHAR2_TABLE_200();
359 a60 := JTF_VARCHAR2_TABLE_200();
360 a61 := JTF_VARCHAR2_TABLE_200();
361 a62 := JTF_VARCHAR2_TABLE_200();
362 if t.count > 0 then
363 a0.extend(t.count);
364 a1.extend(t.count);
365 a2.extend(t.count);
366 a3.extend(t.count);
367 a4.extend(t.count);
368 a5.extend(t.count);
369 a6.extend(t.count);
370 a7.extend(t.count);
371 a8.extend(t.count);
372 a9.extend(t.count);
373 a10.extend(t.count);
374 a11.extend(t.count);
375 a12.extend(t.count);
376 a13.extend(t.count);
377 a14.extend(t.count);
378 a15.extend(t.count);
379 a16.extend(t.count);
380 a17.extend(t.count);
381 a18.extend(t.count);
382 a19.extend(t.count);
383 a20.extend(t.count);
384 a21.extend(t.count);
385 a22.extend(t.count);
386 a23.extend(t.count);
387 a24.extend(t.count);
388 a25.extend(t.count);
389 a26.extend(t.count);
390 a27.extend(t.count);
391 a28.extend(t.count);
392 a29.extend(t.count);
393 a30.extend(t.count);
394 a31.extend(t.count);
395 a32.extend(t.count);
396 a33.extend(t.count);
397 a34.extend(t.count);
398 a35.extend(t.count);
399 a36.extend(t.count);
400 a37.extend(t.count);
401 a38.extend(t.count);
402 a39.extend(t.count);
403 a40.extend(t.count);
404 a41.extend(t.count);
405 a42.extend(t.count);
406 a43.extend(t.count);
407 a44.extend(t.count);
408 a45.extend(t.count);
409 a46.extend(t.count);
410 a47.extend(t.count);
411 a48.extend(t.count);
412 a49.extend(t.count);
413 a50.extend(t.count);
414 a51.extend(t.count);
415 a52.extend(t.count);
416 a53.extend(t.count);
417 a54.extend(t.count);
418 a55.extend(t.count);
419 a56.extend(t.count);
420 a57.extend(t.count);
421 a58.extend(t.count);
422 a59.extend(t.count);
423 a60.extend(t.count);
424 a61.extend(t.count);
425 a62.extend(t.count);
426 ddindx := t.first;
427 indx := 1;
428 while true loop
429 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
430 a1(indx) := t(ddindx).delink_yn;
431 a2(indx) := t(ddindx).remk_subinventory;
432 a3(indx) := rosetta_g_miss_num_map(t(ddindx).remk_organization_id);
433 a4(indx) := rosetta_g_miss_num_map(t(ddindx).remk_price_list_id);
434 a5(indx) := t(ddindx).remk_process_code;
435 a6(indx) := rosetta_g_miss_num_map(t(ddindx).remk_item_template_id);
436 a7(indx) := t(ddindx).remk_item_invoiced_code;
437 a8(indx) := t(ddindx).lease_inv_org_yn;
438 a9(indx) := t(ddindx).tax_upfront_yn;
439 a10(indx) := t(ddindx).tax_invoice_yn;
440 a11(indx) := t(ddindx).tax_schedule_yn;
441 a12(indx) := rosetta_g_miss_num_map(t(ddindx).tax_upfront_sty_id);
442 a13(indx) := rosetta_g_miss_num_map(t(ddindx).category_set_id);
443 a14(indx) := rosetta_g_miss_num_map(t(ddindx).validation_set_id);
444 a15(indx) := t(ddindx).cancel_quotes_yn;
445 a16(indx) := t(ddindx).chk_accrual_previous_mnth_yn;
446 a17(indx) := rosetta_g_miss_num_map(t(ddindx).task_template_group_id);
447 a18(indx) := t(ddindx).owner_type_code;
448 a19(indx) := rosetta_g_miss_num_map(t(ddindx).owner_id);
449 a20(indx) := rosetta_g_miss_num_map(t(ddindx).item_inv_org_id);
450 a21(indx) := t(ddindx).rpt_prod_book_type_code;
451 a22(indx) := t(ddindx).asst_add_book_type_code;
452 a23(indx) := rosetta_g_miss_num_map(t(ddindx).ccard_remittance_id);
453 a24(indx) := t(ddindx).corporate_book;
454 a25(indx) := t(ddindx).tax_book_1;
455 a26(indx) := t(ddindx).tax_book_2;
456 a27(indx) := t(ddindx).depreciate_yn;
457 a28(indx) := rosetta_g_miss_num_map(t(ddindx).fa_location_id);
458 a29(indx) := rosetta_g_miss_num_map(t(ddindx).formula_id);
459 a30(indx) := rosetta_g_miss_num_map(t(ddindx).asset_key_id);
460 a31(indx) := t(ddindx).part_trmnt_apply_round_diff;
461 a32(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
462 a33(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
463 a34(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
464 a35(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
465 a36(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
466 a37(indx) := t(ddindx).program_update_date;
467 a38(indx) := t(ddindx).attribute_category;
468 a39(indx) := t(ddindx).attribute1;
469 a40(indx) := t(ddindx).attribute2;
470 a41(indx) := t(ddindx).attribute3;
471 a42(indx) := t(ddindx).attribute4;
472 a43(indx) := t(ddindx).attribute5;
473 a44(indx) := t(ddindx).attribute6;
474 a45(indx) := t(ddindx).attribute7;
475 a46(indx) := t(ddindx).attribute8;
476 a47(indx) := t(ddindx).attribute9;
477 a48(indx) := t(ddindx).attribute10;
478 a49(indx) := t(ddindx).attribute11;
479 a50(indx) := t(ddindx).attribute12;
480 a51(indx) := t(ddindx).attribute13;
481 a52(indx) := t(ddindx).attribute14;
482 a53(indx) := t(ddindx).attribute15;
483 a54(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
484 a55(indx) := t(ddindx).creation_date;
485 a56(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
486 a57(indx) := t(ddindx).last_update_date;
487 a58(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
488 a59(indx) := t(ddindx).lseapp_seq_prefix_txt;
489 a60(indx) := t(ddindx).lseopp_seq_prefix_txt;
490 a61(indx) := t(ddindx).qckqte_seq_prefix_txt;
491 a62(indx) := t(ddindx).lseqte_seq_prefix_txt;
492 indx := indx+1;
493 if t.last =ddindx
494 then exit;
495 end if;
496 ddindx := t.next(ddindx);
497 end loop;
498 end if;
499 end if;
500 end rosetta_table_copy_out_p2;
501
502 procedure rosetta_table_copy_in_p5(t out nocopy okl_syp_pvt.syp_tbl_type, a0 JTF_NUMBER_TABLE
503 , a1 JTF_VARCHAR2_TABLE_100
504 , a2 JTF_VARCHAR2_TABLE_100
505 , a3 JTF_NUMBER_TABLE
506 , a4 JTF_NUMBER_TABLE
507 , a5 JTF_VARCHAR2_TABLE_100
508 , a6 JTF_NUMBER_TABLE
509 , a7 JTF_VARCHAR2_TABLE_100
510 , a8 JTF_VARCHAR2_TABLE_100
511 , a9 JTF_VARCHAR2_TABLE_100
512 , a10 JTF_VARCHAR2_TABLE_100
513 , a11 JTF_VARCHAR2_TABLE_100
514 , a12 JTF_NUMBER_TABLE
515 , a13 JTF_NUMBER_TABLE
516 , a14 JTF_NUMBER_TABLE
517 , a15 JTF_VARCHAR2_TABLE_100
518 , a16 JTF_VARCHAR2_TABLE_100
519 , a17 JTF_NUMBER_TABLE
520 , a18 JTF_VARCHAR2_TABLE_100
521 , a19 JTF_NUMBER_TABLE
522 , a20 JTF_VARCHAR2_TABLE_100
523 , a21 JTF_VARCHAR2_TABLE_100
524 , a22 JTF_VARCHAR2_TABLE_100
525 , a23 JTF_VARCHAR2_TABLE_100
526 , a24 JTF_NUMBER_TABLE
527 , a25 JTF_NUMBER_TABLE
528 , a26 JTF_NUMBER_TABLE
529 , a27 JTF_VARCHAR2_TABLE_100
530 , a28 JTF_NUMBER_TABLE
531 , a29 JTF_NUMBER_TABLE
532 , a30 JTF_NUMBER_TABLE
533 , a31 JTF_NUMBER_TABLE
534 , a32 JTF_NUMBER_TABLE
535 , a33 JTF_DATE_TABLE
536 , a34 JTF_VARCHAR2_TABLE_100
537 , a35 JTF_VARCHAR2_TABLE_500
538 , a36 JTF_VARCHAR2_TABLE_500
539 , a37 JTF_VARCHAR2_TABLE_500
540 , a38 JTF_VARCHAR2_TABLE_500
541 , a39 JTF_VARCHAR2_TABLE_500
542 , a40 JTF_VARCHAR2_TABLE_500
543 , a41 JTF_VARCHAR2_TABLE_500
544 , a42 JTF_VARCHAR2_TABLE_500
545 , a43 JTF_VARCHAR2_TABLE_500
546 , a44 JTF_VARCHAR2_TABLE_500
547 , a45 JTF_VARCHAR2_TABLE_500
548 , a46 JTF_VARCHAR2_TABLE_500
549 , a47 JTF_VARCHAR2_TABLE_500
550 , a48 JTF_VARCHAR2_TABLE_500
551 , a49 JTF_VARCHAR2_TABLE_500
552 , a50 JTF_NUMBER_TABLE
553 , a51 JTF_DATE_TABLE
554 , a52 JTF_NUMBER_TABLE
555 , a53 JTF_DATE_TABLE
556 , a54 JTF_NUMBER_TABLE
557 , a55 JTF_NUMBER_TABLE
558 , a56 JTF_VARCHAR2_TABLE_100
559 , a57 JTF_VARCHAR2_TABLE_100
560 , a58 JTF_NUMBER_TABLE
561 , a59 JTF_VARCHAR2_TABLE_200
562 , a60 JTF_VARCHAR2_TABLE_200
563 , a61 JTF_VARCHAR2_TABLE_200
564 , a62 JTF_VARCHAR2_TABLE_200
565 ) as
566 ddindx binary_integer; indx binary_integer;
567 begin
568 if a0 is not null and a0.count > 0 then
569 if a0.count > 0 then
570 indx := a0.first;
571 ddindx := 1;
572 while true loop
573 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
574 t(ddindx).delink_yn := a1(indx);
575 t(ddindx).remk_subinventory := a2(indx);
576 t(ddindx).remk_organization_id := rosetta_g_miss_num_map(a3(indx));
577 t(ddindx).remk_price_list_id := rosetta_g_miss_num_map(a4(indx));
578 t(ddindx).remk_process_code := a5(indx);
579 t(ddindx).remk_item_template_id := rosetta_g_miss_num_map(a6(indx));
580 t(ddindx).remk_item_invoiced_code := a7(indx);
581 t(ddindx).lease_inv_org_yn := a8(indx);
582 t(ddindx).tax_upfront_yn := a9(indx);
583 t(ddindx).tax_invoice_yn := a10(indx);
584 t(ddindx).tax_schedule_yn := a11(indx);
585 t(ddindx).tax_upfront_sty_id := rosetta_g_miss_num_map(a12(indx));
586 t(ddindx).category_set_id := rosetta_g_miss_num_map(a13(indx));
587 t(ddindx).validation_set_id := rosetta_g_miss_num_map(a14(indx));
588 t(ddindx).cancel_quotes_yn := a15(indx);
589 t(ddindx).chk_accrual_previous_mnth_yn := a16(indx);
590 t(ddindx).task_template_group_id := rosetta_g_miss_num_map(a17(indx));
591 t(ddindx).owner_type_code := a18(indx);
592 t(ddindx).owner_id := rosetta_g_miss_num_map(a19(indx));
593 t(ddindx).corporate_book := a20(indx);
594 t(ddindx).tax_book_1 := a21(indx);
595 t(ddindx).tax_book_2 := a22(indx);
596 t(ddindx).depreciate_yn := a23(indx);
597 t(ddindx).fa_location_id := rosetta_g_miss_num_map(a24(indx));
598 t(ddindx).formula_id := rosetta_g_miss_num_map(a25(indx));
599 t(ddindx).asset_key_id := rosetta_g_miss_num_map(a26(indx));
600 t(ddindx).part_trmnt_apply_round_diff := a27(indx);
601 t(ddindx).object_version_number := rosetta_g_miss_num_map(a28(indx));
602 t(ddindx).org_id := rosetta_g_miss_num_map(a29(indx));
603 t(ddindx).request_id := rosetta_g_miss_num_map(a30(indx));
604 t(ddindx).program_application_id := rosetta_g_miss_num_map(a31(indx));
605 t(ddindx).program_id := rosetta_g_miss_num_map(a32(indx));
606 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a33(indx));
607 t(ddindx).attribute_category := a34(indx);
608 t(ddindx).attribute1 := a35(indx);
609 t(ddindx).attribute2 := a36(indx);
610 t(ddindx).attribute3 := a37(indx);
611 t(ddindx).attribute4 := a38(indx);
612 t(ddindx).attribute5 := a39(indx);
613 t(ddindx).attribute6 := a40(indx);
614 t(ddindx).attribute7 := a41(indx);
615 t(ddindx).attribute8 := a42(indx);
616 t(ddindx).attribute9 := a43(indx);
617 t(ddindx).attribute10 := a44(indx);
618 t(ddindx).attribute11 := a45(indx);
619 t(ddindx).attribute12 := a46(indx);
620 t(ddindx).attribute13 := a47(indx);
621 t(ddindx).attribute14 := a48(indx);
622 t(ddindx).attribute15 := a49(indx);
623 t(ddindx).created_by := rosetta_g_miss_num_map(a50(indx));
624 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a51(indx));
625 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a52(indx));
626 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a53(indx));
627 t(ddindx).last_update_login := rosetta_g_miss_num_map(a54(indx));
628 t(ddindx).item_inv_org_id := rosetta_g_miss_num_map(a55(indx));
629 t(ddindx).rpt_prod_book_type_code := a56(indx);
630 t(ddindx).asst_add_book_type_code := a57(indx);
631 t(ddindx).ccard_remittance_id := rosetta_g_miss_num_map(a58(indx));
632 t(ddindx).lseapp_seq_prefix_txt := a59(indx);
633 t(ddindx).lseopp_seq_prefix_txt := a60(indx);
634 t(ddindx).qckqte_seq_prefix_txt := a61(indx);
635 t(ddindx).lseqte_seq_prefix_txt := a62(indx);
636 ddindx := ddindx+1;
637 if a0.last =indx
638 then exit;
639 end if;
640 indx := a0.next(indx);
641 end loop;
642 end if;
643 end if;
644 end rosetta_table_copy_in_p5;
645 procedure rosetta_table_copy_out_p5(t okl_syp_pvt.syp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
646 , a1 out nocopy JTF_VARCHAR2_TABLE_100
647 , a2 out nocopy JTF_VARCHAR2_TABLE_100
648 , a3 out nocopy JTF_NUMBER_TABLE
649 , a4 out nocopy JTF_NUMBER_TABLE
650 , a5 out nocopy JTF_VARCHAR2_TABLE_100
651 , a6 out nocopy JTF_NUMBER_TABLE
652 , a7 out nocopy JTF_VARCHAR2_TABLE_100
653 , a8 out nocopy JTF_VARCHAR2_TABLE_100
654 , a9 out nocopy JTF_VARCHAR2_TABLE_100
655 , a10 out nocopy JTF_VARCHAR2_TABLE_100
656 , a11 out nocopy JTF_VARCHAR2_TABLE_100
657 , a12 out nocopy JTF_NUMBER_TABLE
658 , a13 out nocopy JTF_NUMBER_TABLE
659 , a14 out nocopy JTF_NUMBER_TABLE
660 , a15 out nocopy JTF_VARCHAR2_TABLE_100
661 , a16 out nocopy JTF_VARCHAR2_TABLE_100
662 , a17 out nocopy JTF_NUMBER_TABLE
663 , a18 out nocopy JTF_VARCHAR2_TABLE_100
664 , a19 out nocopy JTF_NUMBER_TABLE
665 , a20 out nocopy JTF_VARCHAR2_TABLE_100
666 , a21 out nocopy JTF_VARCHAR2_TABLE_100
667 , a22 out nocopy JTF_VARCHAR2_TABLE_100
668 , a23 out nocopy JTF_VARCHAR2_TABLE_100
669 , a24 out nocopy JTF_NUMBER_TABLE
670 , a25 out nocopy JTF_NUMBER_TABLE
671 , a26 out nocopy JTF_NUMBER_TABLE
672 , a27 out nocopy JTF_VARCHAR2_TABLE_100
673 , a28 out nocopy JTF_NUMBER_TABLE
674 , a29 out nocopy JTF_NUMBER_TABLE
675 , a30 out nocopy JTF_NUMBER_TABLE
676 , a31 out nocopy JTF_NUMBER_TABLE
677 , a32 out nocopy JTF_NUMBER_TABLE
678 , a33 out nocopy JTF_DATE_TABLE
679 , a34 out nocopy JTF_VARCHAR2_TABLE_100
680 , a35 out nocopy JTF_VARCHAR2_TABLE_500
681 , a36 out nocopy JTF_VARCHAR2_TABLE_500
682 , a37 out nocopy JTF_VARCHAR2_TABLE_500
683 , a38 out nocopy JTF_VARCHAR2_TABLE_500
684 , a39 out nocopy JTF_VARCHAR2_TABLE_500
685 , a40 out nocopy JTF_VARCHAR2_TABLE_500
686 , a41 out nocopy JTF_VARCHAR2_TABLE_500
687 , a42 out nocopy JTF_VARCHAR2_TABLE_500
688 , a43 out nocopy JTF_VARCHAR2_TABLE_500
689 , a44 out nocopy JTF_VARCHAR2_TABLE_500
690 , a45 out nocopy JTF_VARCHAR2_TABLE_500
691 , a46 out nocopy JTF_VARCHAR2_TABLE_500
692 , a47 out nocopy JTF_VARCHAR2_TABLE_500
693 , a48 out nocopy JTF_VARCHAR2_TABLE_500
694 , a49 out nocopy JTF_VARCHAR2_TABLE_500
695 , a50 out nocopy JTF_NUMBER_TABLE
696 , a51 out nocopy JTF_DATE_TABLE
697 , a52 out nocopy JTF_NUMBER_TABLE
698 , a53 out nocopy JTF_DATE_TABLE
699 , a54 out nocopy JTF_NUMBER_TABLE
700 , a55 out nocopy JTF_NUMBER_TABLE
701 , a56 out nocopy JTF_VARCHAR2_TABLE_100
702 , a57 out nocopy JTF_VARCHAR2_TABLE_100
703 , a58 out nocopy JTF_NUMBER_TABLE
704 , a59 out nocopy JTF_VARCHAR2_TABLE_200
705 , a60 out nocopy JTF_VARCHAR2_TABLE_200
706 , a61 out nocopy JTF_VARCHAR2_TABLE_200
707 , a62 out nocopy JTF_VARCHAR2_TABLE_200
708 ) as
709 ddindx binary_integer; indx binary_integer;
710 begin
711 if t is null or t.count = 0 then
712 a0 := JTF_NUMBER_TABLE();
713 a1 := JTF_VARCHAR2_TABLE_100();
714 a2 := JTF_VARCHAR2_TABLE_100();
715 a3 := JTF_NUMBER_TABLE();
716 a4 := JTF_NUMBER_TABLE();
717 a5 := JTF_VARCHAR2_TABLE_100();
718 a6 := JTF_NUMBER_TABLE();
719 a7 := JTF_VARCHAR2_TABLE_100();
720 a8 := JTF_VARCHAR2_TABLE_100();
721 a9 := JTF_VARCHAR2_TABLE_100();
722 a10 := JTF_VARCHAR2_TABLE_100();
723 a11 := JTF_VARCHAR2_TABLE_100();
724 a12 := JTF_NUMBER_TABLE();
725 a13 := JTF_NUMBER_TABLE();
726 a14 := JTF_NUMBER_TABLE();
727 a15 := JTF_VARCHAR2_TABLE_100();
728 a16 := JTF_VARCHAR2_TABLE_100();
729 a17 := JTF_NUMBER_TABLE();
730 a18 := JTF_VARCHAR2_TABLE_100();
731 a19 := JTF_NUMBER_TABLE();
732 a20 := JTF_VARCHAR2_TABLE_100();
733 a21 := JTF_VARCHAR2_TABLE_100();
734 a22 := JTF_VARCHAR2_TABLE_100();
735 a23 := JTF_VARCHAR2_TABLE_100();
736 a24 := JTF_NUMBER_TABLE();
737 a25 := JTF_NUMBER_TABLE();
738 a26 := JTF_NUMBER_TABLE();
739 a27 := JTF_VARCHAR2_TABLE_100();
740 a28 := JTF_NUMBER_TABLE();
741 a29 := JTF_NUMBER_TABLE();
742 a30 := JTF_NUMBER_TABLE();
743 a31 := JTF_NUMBER_TABLE();
744 a32 := JTF_NUMBER_TABLE();
745 a33 := JTF_DATE_TABLE();
746 a34 := JTF_VARCHAR2_TABLE_100();
747 a35 := JTF_VARCHAR2_TABLE_500();
748 a36 := JTF_VARCHAR2_TABLE_500();
749 a37 := JTF_VARCHAR2_TABLE_500();
750 a38 := JTF_VARCHAR2_TABLE_500();
751 a39 := JTF_VARCHAR2_TABLE_500();
752 a40 := JTF_VARCHAR2_TABLE_500();
753 a41 := JTF_VARCHAR2_TABLE_500();
754 a42 := JTF_VARCHAR2_TABLE_500();
755 a43 := JTF_VARCHAR2_TABLE_500();
756 a44 := JTF_VARCHAR2_TABLE_500();
757 a45 := JTF_VARCHAR2_TABLE_500();
758 a46 := JTF_VARCHAR2_TABLE_500();
759 a47 := JTF_VARCHAR2_TABLE_500();
760 a48 := JTF_VARCHAR2_TABLE_500();
761 a49 := JTF_VARCHAR2_TABLE_500();
762 a50 := JTF_NUMBER_TABLE();
763 a51 := JTF_DATE_TABLE();
764 a52 := JTF_NUMBER_TABLE();
765 a53 := JTF_DATE_TABLE();
766 a54 := JTF_NUMBER_TABLE();
767 a55 := JTF_NUMBER_TABLE();
768 a56 := JTF_VARCHAR2_TABLE_100();
769 a57 := JTF_VARCHAR2_TABLE_100();
770 a58 := JTF_NUMBER_TABLE();
771 a59 := JTF_VARCHAR2_TABLE_200();
772 a60 := JTF_VARCHAR2_TABLE_200();
773 a61 := JTF_VARCHAR2_TABLE_200();
774 a62 := JTF_VARCHAR2_TABLE_200();
775 else
776 a0 := JTF_NUMBER_TABLE();
777 a1 := JTF_VARCHAR2_TABLE_100();
778 a2 := JTF_VARCHAR2_TABLE_100();
779 a3 := JTF_NUMBER_TABLE();
780 a4 := JTF_NUMBER_TABLE();
781 a5 := JTF_VARCHAR2_TABLE_100();
782 a6 := JTF_NUMBER_TABLE();
783 a7 := JTF_VARCHAR2_TABLE_100();
784 a8 := JTF_VARCHAR2_TABLE_100();
785 a9 := JTF_VARCHAR2_TABLE_100();
786 a10 := JTF_VARCHAR2_TABLE_100();
787 a11 := JTF_VARCHAR2_TABLE_100();
788 a12 := JTF_NUMBER_TABLE();
789 a13 := JTF_NUMBER_TABLE();
790 a14 := JTF_NUMBER_TABLE();
791 a15 := JTF_VARCHAR2_TABLE_100();
792 a16 := JTF_VARCHAR2_TABLE_100();
793 a17 := JTF_NUMBER_TABLE();
794 a18 := JTF_VARCHAR2_TABLE_100();
795 a19 := JTF_NUMBER_TABLE();
796 a20 := JTF_VARCHAR2_TABLE_100();
797 a21 := JTF_VARCHAR2_TABLE_100();
798 a22 := JTF_VARCHAR2_TABLE_100();
799 a23 := JTF_VARCHAR2_TABLE_100();
800 a24 := JTF_NUMBER_TABLE();
801 a25 := JTF_NUMBER_TABLE();
802 a26 := JTF_NUMBER_TABLE();
803 a27 := JTF_VARCHAR2_TABLE_100();
804 a28 := JTF_NUMBER_TABLE();
805 a29 := JTF_NUMBER_TABLE();
806 a30 := JTF_NUMBER_TABLE();
807 a31 := JTF_NUMBER_TABLE();
808 a32 := JTF_NUMBER_TABLE();
809 a33 := JTF_DATE_TABLE();
810 a34 := JTF_VARCHAR2_TABLE_100();
811 a35 := JTF_VARCHAR2_TABLE_500();
812 a36 := JTF_VARCHAR2_TABLE_500();
813 a37 := JTF_VARCHAR2_TABLE_500();
814 a38 := JTF_VARCHAR2_TABLE_500();
815 a39 := JTF_VARCHAR2_TABLE_500();
816 a40 := JTF_VARCHAR2_TABLE_500();
817 a41 := JTF_VARCHAR2_TABLE_500();
818 a42 := JTF_VARCHAR2_TABLE_500();
819 a43 := JTF_VARCHAR2_TABLE_500();
820 a44 := JTF_VARCHAR2_TABLE_500();
821 a45 := JTF_VARCHAR2_TABLE_500();
822 a46 := JTF_VARCHAR2_TABLE_500();
823 a47 := JTF_VARCHAR2_TABLE_500();
824 a48 := JTF_VARCHAR2_TABLE_500();
825 a49 := JTF_VARCHAR2_TABLE_500();
826 a50 := JTF_NUMBER_TABLE();
827 a51 := JTF_DATE_TABLE();
828 a52 := JTF_NUMBER_TABLE();
829 a53 := JTF_DATE_TABLE();
830 a54 := JTF_NUMBER_TABLE();
831 a55 := JTF_NUMBER_TABLE();
832 a56 := JTF_VARCHAR2_TABLE_100();
833 a57 := JTF_VARCHAR2_TABLE_100();
834 a58 := JTF_NUMBER_TABLE();
835 a59 := JTF_VARCHAR2_TABLE_200();
836 a60 := JTF_VARCHAR2_TABLE_200();
837 a61 := JTF_VARCHAR2_TABLE_200();
838 a62 := JTF_VARCHAR2_TABLE_200();
839 if t.count > 0 then
840 a0.extend(t.count);
841 a1.extend(t.count);
842 a2.extend(t.count);
843 a3.extend(t.count);
844 a4.extend(t.count);
845 a5.extend(t.count);
846 a6.extend(t.count);
847 a7.extend(t.count);
848 a8.extend(t.count);
849 a9.extend(t.count);
850 a10.extend(t.count);
851 a11.extend(t.count);
852 a12.extend(t.count);
853 a13.extend(t.count);
854 a14.extend(t.count);
855 a15.extend(t.count);
856 a16.extend(t.count);
857 a17.extend(t.count);
858 a18.extend(t.count);
859 a19.extend(t.count);
860 a20.extend(t.count);
861 a21.extend(t.count);
862 a22.extend(t.count);
863 a23.extend(t.count);
864 a24.extend(t.count);
865 a25.extend(t.count);
866 a26.extend(t.count);
867 a27.extend(t.count);
868 a28.extend(t.count);
869 a29.extend(t.count);
870 a30.extend(t.count);
871 a31.extend(t.count);
872 a32.extend(t.count);
873 a33.extend(t.count);
874 a34.extend(t.count);
875 a35.extend(t.count);
876 a36.extend(t.count);
877 a37.extend(t.count);
878 a38.extend(t.count);
879 a39.extend(t.count);
880 a40.extend(t.count);
881 a41.extend(t.count);
882 a42.extend(t.count);
883 a43.extend(t.count);
884 a44.extend(t.count);
885 a45.extend(t.count);
886 a46.extend(t.count);
887 a47.extend(t.count);
888 a48.extend(t.count);
889 a49.extend(t.count);
890 a50.extend(t.count);
891 a51.extend(t.count);
892 a52.extend(t.count);
893 a53.extend(t.count);
894 a54.extend(t.count);
895 a55.extend(t.count);
896 a56.extend(t.count);
897 a57.extend(t.count);
898 a58.extend(t.count);
899 a59.extend(t.count);
900 a60.extend(t.count);
901 a61.extend(t.count);
902 a62.extend(t.count);
903 ddindx := t.first;
904 indx := 1;
905 while true loop
906 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
907 a1(indx) := t(ddindx).delink_yn;
908 a2(indx) := t(ddindx).remk_subinventory;
909 a3(indx) := rosetta_g_miss_num_map(t(ddindx).remk_organization_id);
910 a4(indx) := rosetta_g_miss_num_map(t(ddindx).remk_price_list_id);
911 a5(indx) := t(ddindx).remk_process_code;
912 a6(indx) := rosetta_g_miss_num_map(t(ddindx).remk_item_template_id);
913 a7(indx) := t(ddindx).remk_item_invoiced_code;
914 a8(indx) := t(ddindx).lease_inv_org_yn;
915 a9(indx) := t(ddindx).tax_upfront_yn;
916 a10(indx) := t(ddindx).tax_invoice_yn;
917 a11(indx) := t(ddindx).tax_schedule_yn;
918 a12(indx) := rosetta_g_miss_num_map(t(ddindx).tax_upfront_sty_id);
919 a13(indx) := rosetta_g_miss_num_map(t(ddindx).category_set_id);
920 a14(indx) := rosetta_g_miss_num_map(t(ddindx).validation_set_id);
921 a15(indx) := t(ddindx).cancel_quotes_yn;
922 a16(indx) := t(ddindx).chk_accrual_previous_mnth_yn;
923 a17(indx) := rosetta_g_miss_num_map(t(ddindx).task_template_group_id);
924 a18(indx) := t(ddindx).owner_type_code;
925 a19(indx) := rosetta_g_miss_num_map(t(ddindx).owner_id);
926 a20(indx) := t(ddindx).corporate_book;
927 a21(indx) := t(ddindx).tax_book_1;
928 a22(indx) := t(ddindx).tax_book_2;
929 a23(indx) := t(ddindx).depreciate_yn;
930 a24(indx) := rosetta_g_miss_num_map(t(ddindx).fa_location_id);
931 a25(indx) := rosetta_g_miss_num_map(t(ddindx).formula_id);
932 a26(indx) := rosetta_g_miss_num_map(t(ddindx).asset_key_id);
933 a27(indx) := t(ddindx).part_trmnt_apply_round_diff;
934 a28(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
935 a29(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
936 a30(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
937 a31(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
938 a32(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
939 a33(indx) := t(ddindx).program_update_date;
940 a34(indx) := t(ddindx).attribute_category;
941 a35(indx) := t(ddindx).attribute1;
942 a36(indx) := t(ddindx).attribute2;
943 a37(indx) := t(ddindx).attribute3;
944 a38(indx) := t(ddindx).attribute4;
945 a39(indx) := t(ddindx).attribute5;
946 a40(indx) := t(ddindx).attribute6;
947 a41(indx) := t(ddindx).attribute7;
948 a42(indx) := t(ddindx).attribute8;
949 a43(indx) := t(ddindx).attribute9;
950 a44(indx) := t(ddindx).attribute10;
951 a45(indx) := t(ddindx).attribute11;
952 a46(indx) := t(ddindx).attribute12;
953 a47(indx) := t(ddindx).attribute13;
954 a48(indx) := t(ddindx).attribute14;
955 a49(indx) := t(ddindx).attribute15;
956 a50(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
957 a51(indx) := t(ddindx).creation_date;
958 a52(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
959 a53(indx) := t(ddindx).last_update_date;
960 a54(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
961 a55(indx) := rosetta_g_miss_num_map(t(ddindx).item_inv_org_id);
962 a56(indx) := t(ddindx).rpt_prod_book_type_code;
963 a57(indx) := t(ddindx).asst_add_book_type_code;
964 a58(indx) := rosetta_g_miss_num_map(t(ddindx).ccard_remittance_id);
965 a59(indx) := t(ddindx).lseapp_seq_prefix_txt;
966 a60(indx) := t(ddindx).lseopp_seq_prefix_txt;
967 a61(indx) := t(ddindx).qckqte_seq_prefix_txt;
968 a62(indx) := t(ddindx).lseqte_seq_prefix_txt;
969 indx := indx+1;
970 if t.last =ddindx
971 then exit;
972 end if;
973 ddindx := t.next(ddindx);
974 end loop;
975 end if;
976 end if;
977 end rosetta_table_copy_out_p5;
978
979 procedure insert_row(p_api_version NUMBER
980 , p_init_msg_list VARCHAR2
981 , x_return_status out nocopy VARCHAR2
982 , x_msg_count out nocopy NUMBER
983 , x_msg_data out nocopy VARCHAR2
984 , p6_a0 out nocopy NUMBER
985 , p6_a1 out nocopy VARCHAR2
986 , p6_a2 out nocopy VARCHAR2
987 , p6_a3 out nocopy NUMBER
988 , p6_a4 out nocopy NUMBER
989 , p6_a5 out nocopy VARCHAR2
990 , p6_a6 out nocopy NUMBER
991 , p6_a7 out nocopy VARCHAR2
992 , p6_a8 out nocopy VARCHAR2
993 , p6_a9 out nocopy VARCHAR2
994 , p6_a10 out nocopy VARCHAR2
995 , p6_a11 out nocopy VARCHAR2
996 , p6_a12 out nocopy NUMBER
997 , p6_a13 out nocopy NUMBER
998 , p6_a14 out nocopy NUMBER
999 , p6_a15 out nocopy VARCHAR2
1000 , p6_a16 out nocopy VARCHAR2
1001 , p6_a17 out nocopy NUMBER
1002 , p6_a18 out nocopy VARCHAR2
1003 , p6_a19 out nocopy NUMBER
1004 , p6_a20 out nocopy NUMBER
1005 , p6_a21 out nocopy VARCHAR2
1006 , p6_a22 out nocopy VARCHAR2
1007 , p6_a23 out nocopy NUMBER
1008 , p6_a24 out nocopy VARCHAR2
1009 , p6_a25 out nocopy VARCHAR2
1010 , p6_a26 out nocopy VARCHAR2
1011 , p6_a27 out nocopy VARCHAR2
1012 , p6_a28 out nocopy NUMBER
1013 , p6_a29 out nocopy NUMBER
1014 , p6_a30 out nocopy NUMBER
1015 , p6_a31 out nocopy VARCHAR2
1016 , p6_a32 out nocopy NUMBER
1017 , p6_a33 out nocopy NUMBER
1018 , p6_a34 out nocopy NUMBER
1019 , p6_a35 out nocopy NUMBER
1020 , p6_a36 out nocopy NUMBER
1021 , p6_a37 out nocopy DATE
1022 , p6_a38 out nocopy VARCHAR2
1023 , p6_a39 out nocopy VARCHAR2
1024 , p6_a40 out nocopy VARCHAR2
1025 , p6_a41 out nocopy VARCHAR2
1026 , p6_a42 out nocopy VARCHAR2
1027 , p6_a43 out nocopy VARCHAR2
1028 , p6_a44 out nocopy VARCHAR2
1029 , p6_a45 out nocopy VARCHAR2
1030 , p6_a46 out nocopy VARCHAR2
1031 , p6_a47 out nocopy VARCHAR2
1032 , p6_a48 out nocopy VARCHAR2
1033 , p6_a49 out nocopy VARCHAR2
1034 , p6_a50 out nocopy VARCHAR2
1035 , p6_a51 out nocopy VARCHAR2
1036 , p6_a52 out nocopy VARCHAR2
1037 , p6_a53 out nocopy VARCHAR2
1038 , p6_a54 out nocopy NUMBER
1039 , p6_a55 out nocopy DATE
1040 , p6_a56 out nocopy NUMBER
1041 , p6_a57 out nocopy DATE
1042 , p6_a58 out nocopy NUMBER
1043 , p6_a59 out nocopy VARCHAR2
1044 , p6_a60 out nocopy VARCHAR2
1045 , p6_a61 out nocopy VARCHAR2
1046 , p6_a62 out nocopy VARCHAR2
1047 , p5_a0 NUMBER := 0-1962.0724
1048 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1049 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1050 , p5_a3 NUMBER := 0-1962.0724
1051 , p5_a4 NUMBER := 0-1962.0724
1052 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1053 , p5_a6 NUMBER := 0-1962.0724
1054 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1055 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1056 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1057 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1058 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1059 , p5_a12 NUMBER := 0-1962.0724
1060 , p5_a13 NUMBER := 0-1962.0724
1061 , p5_a14 NUMBER := 0-1962.0724
1062 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1063 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1064 , p5_a17 NUMBER := 0-1962.0724
1065 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1066 , p5_a19 NUMBER := 0-1962.0724
1067 , p5_a20 NUMBER := 0-1962.0724
1068 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1069 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1070 , p5_a23 NUMBER := 0-1962.0724
1071 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1072 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1073 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1074 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1075 , p5_a28 NUMBER := 0-1962.0724
1076 , p5_a29 NUMBER := 0-1962.0724
1077 , p5_a30 NUMBER := 0-1962.0724
1078 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1079 , p5_a32 NUMBER := 0-1962.0724
1080 , p5_a33 NUMBER := 0-1962.0724
1081 , p5_a34 NUMBER := 0-1962.0724
1082 , p5_a35 NUMBER := 0-1962.0724
1083 , p5_a36 NUMBER := 0-1962.0724
1084 , p5_a37 DATE := fnd_api.g_miss_date
1085 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1086 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1087 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1088 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1089 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1090 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1091 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1092 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1093 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1094 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1095 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1096 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1097 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1098 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1099 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1100 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1101 , p5_a54 NUMBER := 0-1962.0724
1102 , p5_a55 DATE := fnd_api.g_miss_date
1103 , p5_a56 NUMBER := 0-1962.0724
1104 , p5_a57 DATE := fnd_api.g_miss_date
1105 , p5_a58 NUMBER := 0-1962.0724
1106 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1107 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1108 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1109 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1110 )
1111
1112 as
1113 ddp_sypv_rec okl_syp_pvt.sypv_rec_type;
1114 ddx_sypv_rec okl_syp_pvt.sypv_rec_type;
1115 ddindx binary_integer; indx binary_integer;
1116 begin
1117
1118 -- copy data to the local IN or IN-OUT args, if any
1119
1120
1121
1122
1123
1124 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
1125 ddp_sypv_rec.delink_yn := p5_a1;
1126 ddp_sypv_rec.remk_subinventory := p5_a2;
1127 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
1128 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
1129 ddp_sypv_rec.remk_process_code := p5_a5;
1130 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
1131 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
1132 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
1133 ddp_sypv_rec.tax_upfront_yn := p5_a9;
1134 ddp_sypv_rec.tax_invoice_yn := p5_a10;
1135 ddp_sypv_rec.tax_schedule_yn := p5_a11;
1136 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
1137 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
1138 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
1139 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
1140 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
1141 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
1142 ddp_sypv_rec.owner_type_code := p5_a18;
1143 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
1144 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
1145 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
1146 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
1147 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
1148 ddp_sypv_rec.corporate_book := p5_a24;
1149 ddp_sypv_rec.tax_book_1 := p5_a25;
1150 ddp_sypv_rec.tax_book_2 := p5_a26;
1151 ddp_sypv_rec.depreciate_yn := p5_a27;
1152 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
1153 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
1154 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
1155 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
1156 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
1157 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
1158 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
1159 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
1160 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
1161 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
1162 ddp_sypv_rec.attribute_category := p5_a38;
1163 ddp_sypv_rec.attribute1 := p5_a39;
1164 ddp_sypv_rec.attribute2 := p5_a40;
1165 ddp_sypv_rec.attribute3 := p5_a41;
1166 ddp_sypv_rec.attribute4 := p5_a42;
1167 ddp_sypv_rec.attribute5 := p5_a43;
1168 ddp_sypv_rec.attribute6 := p5_a44;
1169 ddp_sypv_rec.attribute7 := p5_a45;
1170 ddp_sypv_rec.attribute8 := p5_a46;
1171 ddp_sypv_rec.attribute9 := p5_a47;
1172 ddp_sypv_rec.attribute10 := p5_a48;
1173 ddp_sypv_rec.attribute11 := p5_a49;
1174 ddp_sypv_rec.attribute12 := p5_a50;
1175 ddp_sypv_rec.attribute13 := p5_a51;
1176 ddp_sypv_rec.attribute14 := p5_a52;
1177 ddp_sypv_rec.attribute15 := p5_a53;
1178 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1179 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1180 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1181 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1182 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1183 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
1184 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
1185 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1186 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1187
1188
1189 -- here's the delegated call to the old PL/SQL routine
1190 okl_syp_pvt.insert_row(p_api_version,
1191 p_init_msg_list,
1192 x_return_status,
1193 x_msg_count,
1194 x_msg_data,
1195 ddp_sypv_rec,
1196 ddx_sypv_rec);
1197
1198 -- copy data back from the local variables to OUT or IN-OUT args, if any
1199
1200
1201
1202
1203
1204
1205 p6_a0 := rosetta_g_miss_num_map(ddx_sypv_rec.id);
1206 p6_a1 := ddx_sypv_rec.delink_yn;
1207 p6_a2 := ddx_sypv_rec.remk_subinventory;
1208 p6_a3 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_organization_id);
1209 p6_a4 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_price_list_id);
1210 p6_a5 := ddx_sypv_rec.remk_process_code;
1211 p6_a6 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_item_template_id);
1212 p6_a7 := ddx_sypv_rec.remk_item_invoiced_code;
1213 p6_a8 := ddx_sypv_rec.lease_inv_org_yn;
1214 p6_a9 := ddx_sypv_rec.tax_upfront_yn;
1215 p6_a10 := ddx_sypv_rec.tax_invoice_yn;
1216 p6_a11 := ddx_sypv_rec.tax_schedule_yn;
1217 p6_a12 := rosetta_g_miss_num_map(ddx_sypv_rec.tax_upfront_sty_id);
1218 p6_a13 := rosetta_g_miss_num_map(ddx_sypv_rec.category_set_id);
1219 p6_a14 := rosetta_g_miss_num_map(ddx_sypv_rec.validation_set_id);
1220 p6_a15 := ddx_sypv_rec.cancel_quotes_yn;
1221 p6_a16 := ddx_sypv_rec.chk_accrual_previous_mnth_yn;
1222 p6_a17 := rosetta_g_miss_num_map(ddx_sypv_rec.task_template_group_id);
1223 p6_a18 := ddx_sypv_rec.owner_type_code;
1224 p6_a19 := rosetta_g_miss_num_map(ddx_sypv_rec.owner_id);
1225 p6_a20 := rosetta_g_miss_num_map(ddx_sypv_rec.item_inv_org_id);
1226 p6_a21 := ddx_sypv_rec.rpt_prod_book_type_code;
1227 p6_a22 := ddx_sypv_rec.asst_add_book_type_code;
1228 p6_a23 := rosetta_g_miss_num_map(ddx_sypv_rec.ccard_remittance_id);
1229 p6_a24 := ddx_sypv_rec.corporate_book;
1230 p6_a25 := ddx_sypv_rec.tax_book_1;
1231 p6_a26 := ddx_sypv_rec.tax_book_2;
1232 p6_a27 := ddx_sypv_rec.depreciate_yn;
1233 p6_a28 := rosetta_g_miss_num_map(ddx_sypv_rec.fa_location_id);
1234 p6_a29 := rosetta_g_miss_num_map(ddx_sypv_rec.formula_id);
1235 p6_a30 := rosetta_g_miss_num_map(ddx_sypv_rec.asset_key_id);
1236 p6_a31 := ddx_sypv_rec.part_trmnt_apply_round_diff;
1237 p6_a32 := rosetta_g_miss_num_map(ddx_sypv_rec.object_version_number);
1238 p6_a33 := rosetta_g_miss_num_map(ddx_sypv_rec.org_id);
1239 p6_a34 := rosetta_g_miss_num_map(ddx_sypv_rec.request_id);
1240 p6_a35 := rosetta_g_miss_num_map(ddx_sypv_rec.program_application_id);
1241 p6_a36 := rosetta_g_miss_num_map(ddx_sypv_rec.program_id);
1242 p6_a37 := ddx_sypv_rec.program_update_date;
1243 p6_a38 := ddx_sypv_rec.attribute_category;
1244 p6_a39 := ddx_sypv_rec.attribute1;
1245 p6_a40 := ddx_sypv_rec.attribute2;
1246 p6_a41 := ddx_sypv_rec.attribute3;
1247 p6_a42 := ddx_sypv_rec.attribute4;
1248 p6_a43 := ddx_sypv_rec.attribute5;
1249 p6_a44 := ddx_sypv_rec.attribute6;
1250 p6_a45 := ddx_sypv_rec.attribute7;
1251 p6_a46 := ddx_sypv_rec.attribute8;
1252 p6_a47 := ddx_sypv_rec.attribute9;
1253 p6_a48 := ddx_sypv_rec.attribute10;
1254 p6_a49 := ddx_sypv_rec.attribute11;
1255 p6_a50 := ddx_sypv_rec.attribute12;
1256 p6_a51 := ddx_sypv_rec.attribute13;
1257 p6_a52 := ddx_sypv_rec.attribute14;
1258 p6_a53 := ddx_sypv_rec.attribute15;
1259 p6_a54 := rosetta_g_miss_num_map(ddx_sypv_rec.created_by);
1260 p6_a55 := ddx_sypv_rec.creation_date;
1261 p6_a56 := rosetta_g_miss_num_map(ddx_sypv_rec.last_updated_by);
1262 p6_a57 := ddx_sypv_rec.last_update_date;
1263 p6_a58 := rosetta_g_miss_num_map(ddx_sypv_rec.last_update_login);
1264 p6_a59 := ddx_sypv_rec.lseapp_seq_prefix_txt;
1265 p6_a60 := ddx_sypv_rec.lseopp_seq_prefix_txt;
1266 p6_a61 := ddx_sypv_rec.qckqte_seq_prefix_txt;
1267 p6_a62 := ddx_sypv_rec.lseqte_seq_prefix_txt;
1268 end;
1269
1270 procedure insert_row(p_api_version NUMBER
1271 , p_init_msg_list VARCHAR2
1272 , x_return_status out nocopy VARCHAR2
1273 , x_msg_count out nocopy NUMBER
1274 , x_msg_data out nocopy VARCHAR2
1275 , p5_a0 JTF_NUMBER_TABLE
1276 , p5_a1 JTF_VARCHAR2_TABLE_100
1277 , p5_a2 JTF_VARCHAR2_TABLE_100
1278 , p5_a3 JTF_NUMBER_TABLE
1279 , p5_a4 JTF_NUMBER_TABLE
1280 , p5_a5 JTF_VARCHAR2_TABLE_100
1281 , p5_a6 JTF_NUMBER_TABLE
1282 , p5_a7 JTF_VARCHAR2_TABLE_100
1283 , p5_a8 JTF_VARCHAR2_TABLE_100
1284 , p5_a9 JTF_VARCHAR2_TABLE_100
1285 , p5_a10 JTF_VARCHAR2_TABLE_100
1286 , p5_a11 JTF_VARCHAR2_TABLE_100
1287 , p5_a12 JTF_NUMBER_TABLE
1288 , p5_a13 JTF_NUMBER_TABLE
1289 , p5_a14 JTF_NUMBER_TABLE
1290 , p5_a15 JTF_VARCHAR2_TABLE_100
1291 , p5_a16 JTF_VARCHAR2_TABLE_100
1292 , p5_a17 JTF_NUMBER_TABLE
1293 , p5_a18 JTF_VARCHAR2_TABLE_100
1294 , p5_a19 JTF_NUMBER_TABLE
1295 , p5_a20 JTF_NUMBER_TABLE
1296 , p5_a21 JTF_VARCHAR2_TABLE_100
1297 , p5_a22 JTF_VARCHAR2_TABLE_100
1298 , p5_a23 JTF_NUMBER_TABLE
1299 , p5_a24 JTF_VARCHAR2_TABLE_100
1300 , p5_a25 JTF_VARCHAR2_TABLE_100
1301 , p5_a26 JTF_VARCHAR2_TABLE_100
1302 , p5_a27 JTF_VARCHAR2_TABLE_100
1303 , p5_a28 JTF_NUMBER_TABLE
1304 , p5_a29 JTF_NUMBER_TABLE
1305 , p5_a30 JTF_NUMBER_TABLE
1306 , p5_a31 JTF_VARCHAR2_TABLE_100
1307 , p5_a32 JTF_NUMBER_TABLE
1308 , p5_a33 JTF_NUMBER_TABLE
1309 , p5_a34 JTF_NUMBER_TABLE
1310 , p5_a35 JTF_NUMBER_TABLE
1311 , p5_a36 JTF_NUMBER_TABLE
1312 , p5_a37 JTF_DATE_TABLE
1313 , p5_a38 JTF_VARCHAR2_TABLE_100
1314 , p5_a39 JTF_VARCHAR2_TABLE_500
1315 , p5_a40 JTF_VARCHAR2_TABLE_500
1316 , p5_a41 JTF_VARCHAR2_TABLE_500
1317 , p5_a42 JTF_VARCHAR2_TABLE_500
1318 , p5_a43 JTF_VARCHAR2_TABLE_500
1319 , p5_a44 JTF_VARCHAR2_TABLE_500
1320 , p5_a45 JTF_VARCHAR2_TABLE_500
1321 , p5_a46 JTF_VARCHAR2_TABLE_500
1322 , p5_a47 JTF_VARCHAR2_TABLE_500
1323 , p5_a48 JTF_VARCHAR2_TABLE_500
1324 , p5_a49 JTF_VARCHAR2_TABLE_500
1325 , p5_a50 JTF_VARCHAR2_TABLE_500
1326 , p5_a51 JTF_VARCHAR2_TABLE_500
1327 , p5_a52 JTF_VARCHAR2_TABLE_500
1328 , p5_a53 JTF_VARCHAR2_TABLE_500
1329 , p5_a54 JTF_NUMBER_TABLE
1330 , p5_a55 JTF_DATE_TABLE
1331 , p5_a56 JTF_NUMBER_TABLE
1332 , p5_a57 JTF_DATE_TABLE
1333 , p5_a58 JTF_NUMBER_TABLE
1334 , p5_a59 JTF_VARCHAR2_TABLE_200
1335 , p5_a60 JTF_VARCHAR2_TABLE_200
1336 , p5_a61 JTF_VARCHAR2_TABLE_200
1337 , p5_a62 JTF_VARCHAR2_TABLE_200
1338 , p6_a0 out nocopy JTF_NUMBER_TABLE
1339 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1340 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1341 , p6_a3 out nocopy JTF_NUMBER_TABLE
1342 , p6_a4 out nocopy JTF_NUMBER_TABLE
1343 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1344 , p6_a6 out nocopy JTF_NUMBER_TABLE
1345 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1346 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1347 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1348 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1349 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1350 , p6_a12 out nocopy JTF_NUMBER_TABLE
1351 , p6_a13 out nocopy JTF_NUMBER_TABLE
1352 , p6_a14 out nocopy JTF_NUMBER_TABLE
1353 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1354 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1355 , p6_a17 out nocopy JTF_NUMBER_TABLE
1356 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1357 , p6_a19 out nocopy JTF_NUMBER_TABLE
1358 , p6_a20 out nocopy JTF_NUMBER_TABLE
1359 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1360 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1361 , p6_a23 out nocopy JTF_NUMBER_TABLE
1362 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1363 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1364 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1365 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
1366 , p6_a28 out nocopy JTF_NUMBER_TABLE
1367 , p6_a29 out nocopy JTF_NUMBER_TABLE
1368 , p6_a30 out nocopy JTF_NUMBER_TABLE
1369 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1370 , p6_a32 out nocopy JTF_NUMBER_TABLE
1371 , p6_a33 out nocopy JTF_NUMBER_TABLE
1372 , p6_a34 out nocopy JTF_NUMBER_TABLE
1373 , p6_a35 out nocopy JTF_NUMBER_TABLE
1374 , p6_a36 out nocopy JTF_NUMBER_TABLE
1375 , p6_a37 out nocopy JTF_DATE_TABLE
1376 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1377 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1378 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1379 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1380 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1381 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1382 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1383 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1384 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1385 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1386 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1387 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
1388 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
1389 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
1390 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
1391 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
1392 , p6_a54 out nocopy JTF_NUMBER_TABLE
1393 , p6_a55 out nocopy JTF_DATE_TABLE
1394 , p6_a56 out nocopy JTF_NUMBER_TABLE
1395 , p6_a57 out nocopy JTF_DATE_TABLE
1396 , p6_a58 out nocopy JTF_NUMBER_TABLE
1397 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
1398 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_200
1399 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_200
1400 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
1401 )
1402
1403 as
1404 ddp_sypv_tbl okl_syp_pvt.sypv_tbl_type;
1405 ddx_sypv_tbl okl_syp_pvt.sypv_tbl_type;
1406 ddindx binary_integer; indx binary_integer;
1407 begin
1408
1409 -- copy data to the local IN or IN-OUT args, if any
1410
1411
1412
1413
1414
1415 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
1416 , p5_a1
1417 , p5_a2
1418 , p5_a3
1419 , p5_a4
1420 , p5_a5
1421 , p5_a6
1422 , p5_a7
1423 , p5_a8
1424 , p5_a9
1425 , p5_a10
1426 , p5_a11
1427 , p5_a12
1428 , p5_a13
1429 , p5_a14
1430 , p5_a15
1431 , p5_a16
1432 , p5_a17
1433 , p5_a18
1434 , p5_a19
1435 , p5_a20
1436 , p5_a21
1437 , p5_a22
1438 , p5_a23
1439 , p5_a24
1440 , p5_a25
1441 , p5_a26
1442 , p5_a27
1443 , p5_a28
1444 , p5_a29
1445 , p5_a30
1446 , p5_a31
1447 , p5_a32
1448 , p5_a33
1449 , p5_a34
1450 , p5_a35
1451 , p5_a36
1452 , p5_a37
1453 , p5_a38
1454 , p5_a39
1455 , p5_a40
1456 , p5_a41
1457 , p5_a42
1458 , p5_a43
1459 , p5_a44
1460 , p5_a45
1461 , p5_a46
1462 , p5_a47
1463 , p5_a48
1464 , p5_a49
1465 , p5_a50
1466 , p5_a51
1467 , p5_a52
1468 , p5_a53
1469 , p5_a54
1470 , p5_a55
1471 , p5_a56
1472 , p5_a57
1473 , p5_a58
1474 , p5_a59
1475 , p5_a60
1476 , p5_a61
1477 , p5_a62
1478 );
1479
1480
1481 -- here's the delegated call to the old PL/SQL routine
1482 okl_syp_pvt.insert_row(p_api_version,
1483 p_init_msg_list,
1484 x_return_status,
1485 x_msg_count,
1486 x_msg_data,
1487 ddp_sypv_tbl,
1488 ddx_sypv_tbl);
1489
1490 -- copy data back from the local variables to OUT or IN-OUT args, if any
1491
1492
1493
1494
1495
1496
1497 okl_syp_pvt_w.rosetta_table_copy_out_p2(ddx_sypv_tbl, p6_a0
1498 , p6_a1
1499 , p6_a2
1500 , p6_a3
1501 , p6_a4
1502 , p6_a5
1503 , p6_a6
1504 , p6_a7
1505 , p6_a8
1506 , p6_a9
1507 , p6_a10
1508 , p6_a11
1509 , p6_a12
1510 , p6_a13
1511 , p6_a14
1512 , p6_a15
1513 , p6_a16
1514 , p6_a17
1515 , p6_a18
1516 , p6_a19
1517 , p6_a20
1518 , p6_a21
1519 , p6_a22
1520 , p6_a23
1521 , p6_a24
1522 , p6_a25
1523 , p6_a26
1524 , p6_a27
1525 , p6_a28
1526 , p6_a29
1527 , p6_a30
1528 , p6_a31
1529 , p6_a32
1530 , p6_a33
1531 , p6_a34
1532 , p6_a35
1533 , p6_a36
1534 , p6_a37
1535 , p6_a38
1536 , p6_a39
1537 , p6_a40
1538 , p6_a41
1539 , p6_a42
1540 , p6_a43
1541 , p6_a44
1542 , p6_a45
1543 , p6_a46
1544 , p6_a47
1545 , p6_a48
1546 , p6_a49
1547 , p6_a50
1548 , p6_a51
1549 , p6_a52
1550 , p6_a53
1551 , p6_a54
1552 , p6_a55
1553 , p6_a56
1554 , p6_a57
1555 , p6_a58
1556 , p6_a59
1557 , p6_a60
1558 , p6_a61
1559 , p6_a62
1560 );
1561 end;
1562
1563 procedure lock_row(p_api_version NUMBER
1564 , p_init_msg_list VARCHAR2
1565 , x_return_status out nocopy VARCHAR2
1566 , x_msg_count out nocopy NUMBER
1567 , x_msg_data out nocopy VARCHAR2
1568 , p5_a0 NUMBER := 0-1962.0724
1569 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1570 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1571 , p5_a3 NUMBER := 0-1962.0724
1572 , p5_a4 NUMBER := 0-1962.0724
1573 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1574 , p5_a6 NUMBER := 0-1962.0724
1575 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1576 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1577 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1578 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1579 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1580 , p5_a12 NUMBER := 0-1962.0724
1581 , p5_a13 NUMBER := 0-1962.0724
1582 , p5_a14 NUMBER := 0-1962.0724
1583 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1584 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1585 , p5_a17 NUMBER := 0-1962.0724
1586 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1587 , p5_a19 NUMBER := 0-1962.0724
1588 , p5_a20 NUMBER := 0-1962.0724
1589 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1590 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a23 NUMBER := 0-1962.0724
1592 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1593 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1594 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1595 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1596 , p5_a28 NUMBER := 0-1962.0724
1597 , p5_a29 NUMBER := 0-1962.0724
1598 , p5_a30 NUMBER := 0-1962.0724
1599 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1600 , p5_a32 NUMBER := 0-1962.0724
1601 , p5_a33 NUMBER := 0-1962.0724
1602 , p5_a34 NUMBER := 0-1962.0724
1603 , p5_a35 NUMBER := 0-1962.0724
1604 , p5_a36 NUMBER := 0-1962.0724
1605 , p5_a37 DATE := fnd_api.g_miss_date
1606 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1607 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1608 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1609 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1610 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1611 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1612 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1613 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1614 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1615 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1616 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1617 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1618 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1619 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1620 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1621 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1622 , p5_a54 NUMBER := 0-1962.0724
1623 , p5_a55 DATE := fnd_api.g_miss_date
1624 , p5_a56 NUMBER := 0-1962.0724
1625 , p5_a57 DATE := fnd_api.g_miss_date
1626 , p5_a58 NUMBER := 0-1962.0724
1627 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1628 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1629 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1630 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1631 )
1632
1633 as
1634 ddp_sypv_rec okl_syp_pvt.sypv_rec_type;
1635 ddindx binary_integer; indx binary_integer;
1636 begin
1637
1638 -- copy data to the local IN or IN-OUT args, if any
1639
1640
1641
1642
1643
1644 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
1645 ddp_sypv_rec.delink_yn := p5_a1;
1646 ddp_sypv_rec.remk_subinventory := p5_a2;
1647 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
1648 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
1649 ddp_sypv_rec.remk_process_code := p5_a5;
1650 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
1651 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
1652 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
1653 ddp_sypv_rec.tax_upfront_yn := p5_a9;
1654 ddp_sypv_rec.tax_invoice_yn := p5_a10;
1655 ddp_sypv_rec.tax_schedule_yn := p5_a11;
1656 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
1657 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
1658 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
1659 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
1660 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
1661 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
1662 ddp_sypv_rec.owner_type_code := p5_a18;
1663 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
1664 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
1665 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
1666 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
1667 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
1668 ddp_sypv_rec.corporate_book := p5_a24;
1669 ddp_sypv_rec.tax_book_1 := p5_a25;
1670 ddp_sypv_rec.tax_book_2 := p5_a26;
1671 ddp_sypv_rec.depreciate_yn := p5_a27;
1672 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
1673 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
1674 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
1675 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
1676 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
1677 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
1678 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
1679 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
1680 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
1681 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
1682 ddp_sypv_rec.attribute_category := p5_a38;
1683 ddp_sypv_rec.attribute1 := p5_a39;
1684 ddp_sypv_rec.attribute2 := p5_a40;
1685 ddp_sypv_rec.attribute3 := p5_a41;
1686 ddp_sypv_rec.attribute4 := p5_a42;
1687 ddp_sypv_rec.attribute5 := p5_a43;
1688 ddp_sypv_rec.attribute6 := p5_a44;
1689 ddp_sypv_rec.attribute7 := p5_a45;
1690 ddp_sypv_rec.attribute8 := p5_a46;
1691 ddp_sypv_rec.attribute9 := p5_a47;
1692 ddp_sypv_rec.attribute10 := p5_a48;
1693 ddp_sypv_rec.attribute11 := p5_a49;
1694 ddp_sypv_rec.attribute12 := p5_a50;
1695 ddp_sypv_rec.attribute13 := p5_a51;
1696 ddp_sypv_rec.attribute14 := p5_a52;
1697 ddp_sypv_rec.attribute15 := p5_a53;
1698 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1699 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1700 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1701 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1702 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1703 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
1704 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
1705 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1706 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1707
1708 -- here's the delegated call to the old PL/SQL routine
1709 okl_syp_pvt.lock_row(p_api_version,
1710 p_init_msg_list,
1711 x_return_status,
1712 x_msg_count,
1713 x_msg_data,
1714 ddp_sypv_rec);
1715
1716 -- copy data back from the local variables to OUT or IN-OUT args, if any
1717
1718
1719
1720
1721
1722 end;
1723
1724 procedure lock_row(p_api_version NUMBER
1725 , p_init_msg_list VARCHAR2
1726 , x_return_status out nocopy VARCHAR2
1727 , x_msg_count out nocopy NUMBER
1728 , x_msg_data out nocopy VARCHAR2
1729 , p5_a0 JTF_NUMBER_TABLE
1730 , p5_a1 JTF_VARCHAR2_TABLE_100
1731 , p5_a2 JTF_VARCHAR2_TABLE_100
1732 , p5_a3 JTF_NUMBER_TABLE
1733 , p5_a4 JTF_NUMBER_TABLE
1734 , p5_a5 JTF_VARCHAR2_TABLE_100
1735 , p5_a6 JTF_NUMBER_TABLE
1736 , p5_a7 JTF_VARCHAR2_TABLE_100
1737 , p5_a8 JTF_VARCHAR2_TABLE_100
1738 , p5_a9 JTF_VARCHAR2_TABLE_100
1739 , p5_a10 JTF_VARCHAR2_TABLE_100
1740 , p5_a11 JTF_VARCHAR2_TABLE_100
1741 , p5_a12 JTF_NUMBER_TABLE
1742 , p5_a13 JTF_NUMBER_TABLE
1743 , p5_a14 JTF_NUMBER_TABLE
1744 , p5_a15 JTF_VARCHAR2_TABLE_100
1745 , p5_a16 JTF_VARCHAR2_TABLE_100
1746 , p5_a17 JTF_NUMBER_TABLE
1747 , p5_a18 JTF_VARCHAR2_TABLE_100
1748 , p5_a19 JTF_NUMBER_TABLE
1749 , p5_a20 JTF_NUMBER_TABLE
1750 , p5_a21 JTF_VARCHAR2_TABLE_100
1751 , p5_a22 JTF_VARCHAR2_TABLE_100
1752 , p5_a23 JTF_NUMBER_TABLE
1753 , p5_a24 JTF_VARCHAR2_TABLE_100
1754 , p5_a25 JTF_VARCHAR2_TABLE_100
1755 , p5_a26 JTF_VARCHAR2_TABLE_100
1756 , p5_a27 JTF_VARCHAR2_TABLE_100
1757 , p5_a28 JTF_NUMBER_TABLE
1758 , p5_a29 JTF_NUMBER_TABLE
1759 , p5_a30 JTF_NUMBER_TABLE
1760 , p5_a31 JTF_VARCHAR2_TABLE_100
1761 , p5_a32 JTF_NUMBER_TABLE
1762 , p5_a33 JTF_NUMBER_TABLE
1763 , p5_a34 JTF_NUMBER_TABLE
1764 , p5_a35 JTF_NUMBER_TABLE
1765 , p5_a36 JTF_NUMBER_TABLE
1766 , p5_a37 JTF_DATE_TABLE
1767 , p5_a38 JTF_VARCHAR2_TABLE_100
1768 , p5_a39 JTF_VARCHAR2_TABLE_500
1769 , p5_a40 JTF_VARCHAR2_TABLE_500
1770 , p5_a41 JTF_VARCHAR2_TABLE_500
1771 , p5_a42 JTF_VARCHAR2_TABLE_500
1772 , p5_a43 JTF_VARCHAR2_TABLE_500
1773 , p5_a44 JTF_VARCHAR2_TABLE_500
1774 , p5_a45 JTF_VARCHAR2_TABLE_500
1775 , p5_a46 JTF_VARCHAR2_TABLE_500
1776 , p5_a47 JTF_VARCHAR2_TABLE_500
1777 , p5_a48 JTF_VARCHAR2_TABLE_500
1778 , p5_a49 JTF_VARCHAR2_TABLE_500
1779 , p5_a50 JTF_VARCHAR2_TABLE_500
1780 , p5_a51 JTF_VARCHAR2_TABLE_500
1781 , p5_a52 JTF_VARCHAR2_TABLE_500
1782 , p5_a53 JTF_VARCHAR2_TABLE_500
1783 , p5_a54 JTF_NUMBER_TABLE
1784 , p5_a55 JTF_DATE_TABLE
1785 , p5_a56 JTF_NUMBER_TABLE
1786 , p5_a57 JTF_DATE_TABLE
1787 , p5_a58 JTF_NUMBER_TABLE
1788 , p5_a59 JTF_VARCHAR2_TABLE_200
1789 , p5_a60 JTF_VARCHAR2_TABLE_200
1790 , p5_a61 JTF_VARCHAR2_TABLE_200
1791 , p5_a62 JTF_VARCHAR2_TABLE_200
1792 )
1793
1794 as
1795 ddp_sypv_tbl okl_syp_pvt.sypv_tbl_type;
1796 ddindx binary_integer; indx binary_integer;
1797 begin
1798
1799 -- copy data to the local IN or IN-OUT args, if any
1800
1801
1802
1803
1804
1805 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
1806 , p5_a1
1807 , p5_a2
1808 , p5_a3
1809 , p5_a4
1810 , p5_a5
1811 , p5_a6
1812 , p5_a7
1813 , p5_a8
1814 , p5_a9
1815 , p5_a10
1816 , p5_a11
1817 , p5_a12
1818 , p5_a13
1819 , p5_a14
1820 , p5_a15
1821 , p5_a16
1822 , p5_a17
1823 , p5_a18
1824 , p5_a19
1825 , p5_a20
1826 , p5_a21
1827 , p5_a22
1828 , p5_a23
1829 , p5_a24
1830 , p5_a25
1831 , p5_a26
1832 , p5_a27
1833 , p5_a28
1834 , p5_a29
1835 , p5_a30
1836 , p5_a31
1837 , p5_a32
1838 , p5_a33
1839 , p5_a34
1840 , p5_a35
1841 , p5_a36
1842 , p5_a37
1843 , p5_a38
1844 , p5_a39
1845 , p5_a40
1846 , p5_a41
1847 , p5_a42
1848 , p5_a43
1849 , p5_a44
1850 , p5_a45
1851 , p5_a46
1852 , p5_a47
1853 , p5_a48
1854 , p5_a49
1855 , p5_a50
1856 , p5_a51
1857 , p5_a52
1858 , p5_a53
1859 , p5_a54
1860 , p5_a55
1861 , p5_a56
1862 , p5_a57
1863 , p5_a58
1864 , p5_a59
1865 , p5_a60
1866 , p5_a61
1867 , p5_a62
1868 );
1869
1870 -- here's the delegated call to the old PL/SQL routine
1871 okl_syp_pvt.lock_row(p_api_version,
1872 p_init_msg_list,
1873 x_return_status,
1874 x_msg_count,
1875 x_msg_data,
1876 ddp_sypv_tbl);
1877
1878 -- copy data back from the local variables to OUT or IN-OUT args, if any
1879
1880
1881
1882
1883
1884 end;
1885
1886 procedure update_row(p_api_version NUMBER
1887 , p_init_msg_list VARCHAR2
1888 , x_return_status out nocopy VARCHAR2
1889 , x_msg_count out nocopy NUMBER
1890 , x_msg_data out nocopy VARCHAR2
1891 , p6_a0 out nocopy NUMBER
1892 , p6_a1 out nocopy VARCHAR2
1893 , p6_a2 out nocopy VARCHAR2
1894 , p6_a3 out nocopy NUMBER
1895 , p6_a4 out nocopy NUMBER
1896 , p6_a5 out nocopy VARCHAR2
1897 , p6_a6 out nocopy NUMBER
1898 , p6_a7 out nocopy VARCHAR2
1899 , p6_a8 out nocopy VARCHAR2
1900 , p6_a9 out nocopy VARCHAR2
1901 , p6_a10 out nocopy VARCHAR2
1902 , p6_a11 out nocopy VARCHAR2
1903 , p6_a12 out nocopy NUMBER
1904 , p6_a13 out nocopy NUMBER
1905 , p6_a14 out nocopy NUMBER
1906 , p6_a15 out nocopy VARCHAR2
1907 , p6_a16 out nocopy VARCHAR2
1908 , p6_a17 out nocopy NUMBER
1909 , p6_a18 out nocopy VARCHAR2
1910 , p6_a19 out nocopy NUMBER
1911 , p6_a20 out nocopy NUMBER
1912 , p6_a21 out nocopy VARCHAR2
1913 , p6_a22 out nocopy VARCHAR2
1914 , p6_a23 out nocopy NUMBER
1915 , p6_a24 out nocopy VARCHAR2
1916 , p6_a25 out nocopy VARCHAR2
1917 , p6_a26 out nocopy VARCHAR2
1918 , p6_a27 out nocopy VARCHAR2
1919 , p6_a28 out nocopy NUMBER
1920 , p6_a29 out nocopy NUMBER
1921 , p6_a30 out nocopy NUMBER
1922 , p6_a31 out nocopy VARCHAR2
1923 , p6_a32 out nocopy NUMBER
1924 , p6_a33 out nocopy NUMBER
1925 , p6_a34 out nocopy NUMBER
1926 , p6_a35 out nocopy NUMBER
1927 , p6_a36 out nocopy NUMBER
1928 , p6_a37 out nocopy DATE
1929 , p6_a38 out nocopy VARCHAR2
1930 , p6_a39 out nocopy VARCHAR2
1931 , p6_a40 out nocopy VARCHAR2
1932 , p6_a41 out nocopy VARCHAR2
1933 , p6_a42 out nocopy VARCHAR2
1934 , p6_a43 out nocopy VARCHAR2
1935 , p6_a44 out nocopy VARCHAR2
1936 , p6_a45 out nocopy VARCHAR2
1937 , p6_a46 out nocopy VARCHAR2
1938 , p6_a47 out nocopy VARCHAR2
1939 , p6_a48 out nocopy VARCHAR2
1940 , p6_a49 out nocopy VARCHAR2
1941 , p6_a50 out nocopy VARCHAR2
1942 , p6_a51 out nocopy VARCHAR2
1943 , p6_a52 out nocopy VARCHAR2
1944 , p6_a53 out nocopy VARCHAR2
1945 , p6_a54 out nocopy NUMBER
1946 , p6_a55 out nocopy DATE
1947 , p6_a56 out nocopy NUMBER
1948 , p6_a57 out nocopy DATE
1949 , p6_a58 out nocopy NUMBER
1950 , p6_a59 out nocopy VARCHAR2
1951 , p6_a60 out nocopy VARCHAR2
1952 , p6_a61 out nocopy VARCHAR2
1953 , p6_a62 out nocopy VARCHAR2
1954 , p5_a0 NUMBER := 0-1962.0724
1955 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1956 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1957 , p5_a3 NUMBER := 0-1962.0724
1958 , p5_a4 NUMBER := 0-1962.0724
1959 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1960 , p5_a6 NUMBER := 0-1962.0724
1961 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1964 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1966 , p5_a12 NUMBER := 0-1962.0724
1967 , p5_a13 NUMBER := 0-1962.0724
1968 , p5_a14 NUMBER := 0-1962.0724
1969 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1970 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1971 , p5_a17 NUMBER := 0-1962.0724
1972 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1973 , p5_a19 NUMBER := 0-1962.0724
1974 , p5_a20 NUMBER := 0-1962.0724
1975 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1976 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1977 , p5_a23 NUMBER := 0-1962.0724
1978 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1979 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1980 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1981 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1982 , p5_a28 NUMBER := 0-1962.0724
1983 , p5_a29 NUMBER := 0-1962.0724
1984 , p5_a30 NUMBER := 0-1962.0724
1985 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1986 , p5_a32 NUMBER := 0-1962.0724
1987 , p5_a33 NUMBER := 0-1962.0724
1988 , p5_a34 NUMBER := 0-1962.0724
1989 , p5_a35 NUMBER := 0-1962.0724
1990 , p5_a36 NUMBER := 0-1962.0724
1991 , p5_a37 DATE := fnd_api.g_miss_date
1992 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1993 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1994 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1995 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1996 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1997 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1998 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1999 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2000 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2001 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2002 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2003 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2004 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2005 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2006 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2007 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2008 , p5_a54 NUMBER := 0-1962.0724
2009 , p5_a55 DATE := fnd_api.g_miss_date
2010 , p5_a56 NUMBER := 0-1962.0724
2011 , p5_a57 DATE := fnd_api.g_miss_date
2012 , p5_a58 NUMBER := 0-1962.0724
2013 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2014 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2015 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2016 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2017 )
2018
2019 as
2020 ddp_sypv_rec okl_syp_pvt.sypv_rec_type;
2021 ddx_sypv_rec okl_syp_pvt.sypv_rec_type;
2022 ddindx binary_integer; indx binary_integer;
2023 begin
2024
2025 -- copy data to the local IN or IN-OUT args, if any
2026
2027
2028
2029
2030
2031 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
2032 ddp_sypv_rec.delink_yn := p5_a1;
2033 ddp_sypv_rec.remk_subinventory := p5_a2;
2034 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
2035 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
2036 ddp_sypv_rec.remk_process_code := p5_a5;
2037 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
2038 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
2039 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
2040 ddp_sypv_rec.tax_upfront_yn := p5_a9;
2041 ddp_sypv_rec.tax_invoice_yn := p5_a10;
2042 ddp_sypv_rec.tax_schedule_yn := p5_a11;
2043 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
2044 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
2045 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
2046 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
2047 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
2048 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
2049 ddp_sypv_rec.owner_type_code := p5_a18;
2050 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
2051 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
2052 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
2053 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
2054 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
2055 ddp_sypv_rec.corporate_book := p5_a24;
2056 ddp_sypv_rec.tax_book_1 := p5_a25;
2057 ddp_sypv_rec.tax_book_2 := p5_a26;
2058 ddp_sypv_rec.depreciate_yn := p5_a27;
2059 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
2060 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
2061 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
2062 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
2063 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
2064 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
2065 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
2066 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
2067 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
2068 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
2069 ddp_sypv_rec.attribute_category := p5_a38;
2070 ddp_sypv_rec.attribute1 := p5_a39;
2071 ddp_sypv_rec.attribute2 := p5_a40;
2072 ddp_sypv_rec.attribute3 := p5_a41;
2073 ddp_sypv_rec.attribute4 := p5_a42;
2074 ddp_sypv_rec.attribute5 := p5_a43;
2075 ddp_sypv_rec.attribute6 := p5_a44;
2076 ddp_sypv_rec.attribute7 := p5_a45;
2077 ddp_sypv_rec.attribute8 := p5_a46;
2078 ddp_sypv_rec.attribute9 := p5_a47;
2079 ddp_sypv_rec.attribute10 := p5_a48;
2080 ddp_sypv_rec.attribute11 := p5_a49;
2081 ddp_sypv_rec.attribute12 := p5_a50;
2082 ddp_sypv_rec.attribute13 := p5_a51;
2083 ddp_sypv_rec.attribute14 := p5_a52;
2084 ddp_sypv_rec.attribute15 := p5_a53;
2085 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2086 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
2087 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
2088 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2089 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2090 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
2091 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
2092 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
2093 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
2094
2095
2096 -- here's the delegated call to the old PL/SQL routine
2097 okl_syp_pvt.update_row(p_api_version,
2098 p_init_msg_list,
2099 x_return_status,
2100 x_msg_count,
2101 x_msg_data,
2102 ddp_sypv_rec,
2103 ddx_sypv_rec);
2104
2105 -- copy data back from the local variables to OUT or IN-OUT args, if any
2106
2107
2108
2109
2110
2111
2112 p6_a0 := rosetta_g_miss_num_map(ddx_sypv_rec.id);
2113 p6_a1 := ddx_sypv_rec.delink_yn;
2114 p6_a2 := ddx_sypv_rec.remk_subinventory;
2115 p6_a3 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_organization_id);
2116 p6_a4 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_price_list_id);
2117 p6_a5 := ddx_sypv_rec.remk_process_code;
2118 p6_a6 := rosetta_g_miss_num_map(ddx_sypv_rec.remk_item_template_id);
2119 p6_a7 := ddx_sypv_rec.remk_item_invoiced_code;
2120 p6_a8 := ddx_sypv_rec.lease_inv_org_yn;
2121 p6_a9 := ddx_sypv_rec.tax_upfront_yn;
2122 p6_a10 := ddx_sypv_rec.tax_invoice_yn;
2123 p6_a11 := ddx_sypv_rec.tax_schedule_yn;
2124 p6_a12 := rosetta_g_miss_num_map(ddx_sypv_rec.tax_upfront_sty_id);
2125 p6_a13 := rosetta_g_miss_num_map(ddx_sypv_rec.category_set_id);
2126 p6_a14 := rosetta_g_miss_num_map(ddx_sypv_rec.validation_set_id);
2127 p6_a15 := ddx_sypv_rec.cancel_quotes_yn;
2128 p6_a16 := ddx_sypv_rec.chk_accrual_previous_mnth_yn;
2129 p6_a17 := rosetta_g_miss_num_map(ddx_sypv_rec.task_template_group_id);
2130 p6_a18 := ddx_sypv_rec.owner_type_code;
2131 p6_a19 := rosetta_g_miss_num_map(ddx_sypv_rec.owner_id);
2132 p6_a20 := rosetta_g_miss_num_map(ddx_sypv_rec.item_inv_org_id);
2133 p6_a21 := ddx_sypv_rec.rpt_prod_book_type_code;
2134 p6_a22 := ddx_sypv_rec.asst_add_book_type_code;
2135 p6_a23 := rosetta_g_miss_num_map(ddx_sypv_rec.ccard_remittance_id);
2136 p6_a24 := ddx_sypv_rec.corporate_book;
2137 p6_a25 := ddx_sypv_rec.tax_book_1;
2138 p6_a26 := ddx_sypv_rec.tax_book_2;
2139 p6_a27 := ddx_sypv_rec.depreciate_yn;
2140 p6_a28 := rosetta_g_miss_num_map(ddx_sypv_rec.fa_location_id);
2141 p6_a29 := rosetta_g_miss_num_map(ddx_sypv_rec.formula_id);
2142 p6_a30 := rosetta_g_miss_num_map(ddx_sypv_rec.asset_key_id);
2143 p6_a31 := ddx_sypv_rec.part_trmnt_apply_round_diff;
2144 p6_a32 := rosetta_g_miss_num_map(ddx_sypv_rec.object_version_number);
2145 p6_a33 := rosetta_g_miss_num_map(ddx_sypv_rec.org_id);
2146 p6_a34 := rosetta_g_miss_num_map(ddx_sypv_rec.request_id);
2147 p6_a35 := rosetta_g_miss_num_map(ddx_sypv_rec.program_application_id);
2148 p6_a36 := rosetta_g_miss_num_map(ddx_sypv_rec.program_id);
2149 p6_a37 := ddx_sypv_rec.program_update_date;
2150 p6_a38 := ddx_sypv_rec.attribute_category;
2151 p6_a39 := ddx_sypv_rec.attribute1;
2152 p6_a40 := ddx_sypv_rec.attribute2;
2153 p6_a41 := ddx_sypv_rec.attribute3;
2154 p6_a42 := ddx_sypv_rec.attribute4;
2155 p6_a43 := ddx_sypv_rec.attribute5;
2156 p6_a44 := ddx_sypv_rec.attribute6;
2157 p6_a45 := ddx_sypv_rec.attribute7;
2158 p6_a46 := ddx_sypv_rec.attribute8;
2159 p6_a47 := ddx_sypv_rec.attribute9;
2160 p6_a48 := ddx_sypv_rec.attribute10;
2161 p6_a49 := ddx_sypv_rec.attribute11;
2162 p6_a50 := ddx_sypv_rec.attribute12;
2163 p6_a51 := ddx_sypv_rec.attribute13;
2164 p6_a52 := ddx_sypv_rec.attribute14;
2165 p6_a53 := ddx_sypv_rec.attribute15;
2166 p6_a54 := rosetta_g_miss_num_map(ddx_sypv_rec.created_by);
2167 p6_a55 := ddx_sypv_rec.creation_date;
2168 p6_a56 := rosetta_g_miss_num_map(ddx_sypv_rec.last_updated_by);
2169 p6_a57 := ddx_sypv_rec.last_update_date;
2170 p6_a58 := rosetta_g_miss_num_map(ddx_sypv_rec.last_update_login);
2171 p6_a59 := ddx_sypv_rec.lseapp_seq_prefix_txt;
2172 p6_a60 := ddx_sypv_rec.lseopp_seq_prefix_txt;
2173 p6_a61 := ddx_sypv_rec.qckqte_seq_prefix_txt;
2174 p6_a62 := ddx_sypv_rec.lseqte_seq_prefix_txt;
2175 end;
2176
2177 procedure update_row(p_api_version NUMBER
2178 , p_init_msg_list VARCHAR2
2179 , x_return_status out nocopy VARCHAR2
2180 , x_msg_count out nocopy NUMBER
2181 , x_msg_data out nocopy VARCHAR2
2182 , p5_a0 JTF_NUMBER_TABLE
2183 , p5_a1 JTF_VARCHAR2_TABLE_100
2184 , p5_a2 JTF_VARCHAR2_TABLE_100
2185 , p5_a3 JTF_NUMBER_TABLE
2186 , p5_a4 JTF_NUMBER_TABLE
2187 , p5_a5 JTF_VARCHAR2_TABLE_100
2188 , p5_a6 JTF_NUMBER_TABLE
2189 , p5_a7 JTF_VARCHAR2_TABLE_100
2190 , p5_a8 JTF_VARCHAR2_TABLE_100
2191 , p5_a9 JTF_VARCHAR2_TABLE_100
2192 , p5_a10 JTF_VARCHAR2_TABLE_100
2193 , p5_a11 JTF_VARCHAR2_TABLE_100
2194 , p5_a12 JTF_NUMBER_TABLE
2195 , p5_a13 JTF_NUMBER_TABLE
2196 , p5_a14 JTF_NUMBER_TABLE
2197 , p5_a15 JTF_VARCHAR2_TABLE_100
2198 , p5_a16 JTF_VARCHAR2_TABLE_100
2199 , p5_a17 JTF_NUMBER_TABLE
2200 , p5_a18 JTF_VARCHAR2_TABLE_100
2201 , p5_a19 JTF_NUMBER_TABLE
2202 , p5_a20 JTF_NUMBER_TABLE
2203 , p5_a21 JTF_VARCHAR2_TABLE_100
2204 , p5_a22 JTF_VARCHAR2_TABLE_100
2205 , p5_a23 JTF_NUMBER_TABLE
2206 , p5_a24 JTF_VARCHAR2_TABLE_100
2207 , p5_a25 JTF_VARCHAR2_TABLE_100
2208 , p5_a26 JTF_VARCHAR2_TABLE_100
2209 , p5_a27 JTF_VARCHAR2_TABLE_100
2210 , p5_a28 JTF_NUMBER_TABLE
2211 , p5_a29 JTF_NUMBER_TABLE
2212 , p5_a30 JTF_NUMBER_TABLE
2213 , p5_a31 JTF_VARCHAR2_TABLE_100
2214 , p5_a32 JTF_NUMBER_TABLE
2215 , p5_a33 JTF_NUMBER_TABLE
2216 , p5_a34 JTF_NUMBER_TABLE
2217 , p5_a35 JTF_NUMBER_TABLE
2218 , p5_a36 JTF_NUMBER_TABLE
2219 , p5_a37 JTF_DATE_TABLE
2220 , p5_a38 JTF_VARCHAR2_TABLE_100
2221 , p5_a39 JTF_VARCHAR2_TABLE_500
2222 , p5_a40 JTF_VARCHAR2_TABLE_500
2223 , p5_a41 JTF_VARCHAR2_TABLE_500
2224 , p5_a42 JTF_VARCHAR2_TABLE_500
2225 , p5_a43 JTF_VARCHAR2_TABLE_500
2226 , p5_a44 JTF_VARCHAR2_TABLE_500
2227 , p5_a45 JTF_VARCHAR2_TABLE_500
2228 , p5_a46 JTF_VARCHAR2_TABLE_500
2229 , p5_a47 JTF_VARCHAR2_TABLE_500
2230 , p5_a48 JTF_VARCHAR2_TABLE_500
2231 , p5_a49 JTF_VARCHAR2_TABLE_500
2232 , p5_a50 JTF_VARCHAR2_TABLE_500
2233 , p5_a51 JTF_VARCHAR2_TABLE_500
2234 , p5_a52 JTF_VARCHAR2_TABLE_500
2235 , p5_a53 JTF_VARCHAR2_TABLE_500
2236 , p5_a54 JTF_NUMBER_TABLE
2237 , p5_a55 JTF_DATE_TABLE
2238 , p5_a56 JTF_NUMBER_TABLE
2239 , p5_a57 JTF_DATE_TABLE
2240 , p5_a58 JTF_NUMBER_TABLE
2241 , p5_a59 JTF_VARCHAR2_TABLE_200
2242 , p5_a60 JTF_VARCHAR2_TABLE_200
2243 , p5_a61 JTF_VARCHAR2_TABLE_200
2244 , p5_a62 JTF_VARCHAR2_TABLE_200
2245 , p6_a0 out nocopy JTF_NUMBER_TABLE
2246 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2247 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2248 , p6_a3 out nocopy JTF_NUMBER_TABLE
2249 , p6_a4 out nocopy JTF_NUMBER_TABLE
2250 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2251 , p6_a6 out nocopy JTF_NUMBER_TABLE
2252 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2253 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2254 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2255 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2256 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2257 , p6_a12 out nocopy JTF_NUMBER_TABLE
2258 , p6_a13 out nocopy JTF_NUMBER_TABLE
2259 , p6_a14 out nocopy JTF_NUMBER_TABLE
2260 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2261 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2262 , p6_a17 out nocopy JTF_NUMBER_TABLE
2263 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
2264 , p6_a19 out nocopy JTF_NUMBER_TABLE
2265 , p6_a20 out nocopy JTF_NUMBER_TABLE
2266 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2267 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2268 , p6_a23 out nocopy JTF_NUMBER_TABLE
2269 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
2270 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2271 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2272 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2273 , p6_a28 out nocopy JTF_NUMBER_TABLE
2274 , p6_a29 out nocopy JTF_NUMBER_TABLE
2275 , p6_a30 out nocopy JTF_NUMBER_TABLE
2276 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2277 , p6_a32 out nocopy JTF_NUMBER_TABLE
2278 , p6_a33 out nocopy JTF_NUMBER_TABLE
2279 , p6_a34 out nocopy JTF_NUMBER_TABLE
2280 , p6_a35 out nocopy JTF_NUMBER_TABLE
2281 , p6_a36 out nocopy JTF_NUMBER_TABLE
2282 , p6_a37 out nocopy JTF_DATE_TABLE
2283 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
2284 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
2285 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
2286 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
2287 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2288 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
2289 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2290 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2291 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
2292 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
2293 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
2294 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
2295 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
2296 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
2297 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
2298 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
2299 , p6_a54 out nocopy JTF_NUMBER_TABLE
2300 , p6_a55 out nocopy JTF_DATE_TABLE
2301 , p6_a56 out nocopy JTF_NUMBER_TABLE
2302 , p6_a57 out nocopy JTF_DATE_TABLE
2303 , p6_a58 out nocopy JTF_NUMBER_TABLE
2304 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
2305 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_200
2306 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_200
2307 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
2308 )
2309
2310 as
2311 ddp_sypv_tbl okl_syp_pvt.sypv_tbl_type;
2312 ddx_sypv_tbl okl_syp_pvt.sypv_tbl_type;
2313 ddindx binary_integer; indx binary_integer;
2314 begin
2315
2316 -- copy data to the local IN or IN-OUT args, if any
2317
2318
2319
2320
2321
2322 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
2323 , p5_a1
2324 , p5_a2
2325 , p5_a3
2326 , p5_a4
2327 , p5_a5
2328 , p5_a6
2329 , p5_a7
2330 , p5_a8
2331 , p5_a9
2332 , p5_a10
2333 , p5_a11
2334 , p5_a12
2335 , p5_a13
2336 , p5_a14
2337 , p5_a15
2338 , p5_a16
2339 , p5_a17
2340 , p5_a18
2341 , p5_a19
2342 , p5_a20
2343 , p5_a21
2344 , p5_a22
2345 , p5_a23
2346 , p5_a24
2347 , p5_a25
2348 , p5_a26
2349 , p5_a27
2350 , p5_a28
2351 , p5_a29
2352 , p5_a30
2353 , p5_a31
2354 , p5_a32
2355 , p5_a33
2356 , p5_a34
2357 , p5_a35
2358 , p5_a36
2359 , p5_a37
2360 , p5_a38
2361 , p5_a39
2362 , p5_a40
2363 , p5_a41
2364 , p5_a42
2365 , p5_a43
2366 , p5_a44
2367 , p5_a45
2368 , p5_a46
2369 , p5_a47
2370 , p5_a48
2371 , p5_a49
2372 , p5_a50
2373 , p5_a51
2374 , p5_a52
2375 , p5_a53
2376 , p5_a54
2377 , p5_a55
2378 , p5_a56
2379 , p5_a57
2380 , p5_a58
2381 , p5_a59
2382 , p5_a60
2383 , p5_a61
2384 , p5_a62
2385 );
2386
2387
2388 -- here's the delegated call to the old PL/SQL routine
2389 okl_syp_pvt.update_row(p_api_version,
2390 p_init_msg_list,
2391 x_return_status,
2392 x_msg_count,
2393 x_msg_data,
2394 ddp_sypv_tbl,
2395 ddx_sypv_tbl);
2396
2397 -- copy data back from the local variables to OUT or IN-OUT args, if any
2398
2399
2400
2401
2402
2403
2404 okl_syp_pvt_w.rosetta_table_copy_out_p2(ddx_sypv_tbl, p6_a0
2405 , p6_a1
2406 , p6_a2
2407 , p6_a3
2408 , p6_a4
2409 , p6_a5
2410 , p6_a6
2411 , p6_a7
2412 , p6_a8
2413 , p6_a9
2414 , p6_a10
2415 , p6_a11
2416 , p6_a12
2417 , p6_a13
2418 , p6_a14
2419 , p6_a15
2420 , p6_a16
2421 , p6_a17
2422 , p6_a18
2423 , p6_a19
2424 , p6_a20
2425 , p6_a21
2426 , p6_a22
2427 , p6_a23
2428 , p6_a24
2429 , p6_a25
2430 , p6_a26
2431 , p6_a27
2432 , p6_a28
2433 , p6_a29
2434 , p6_a30
2435 , p6_a31
2436 , p6_a32
2437 , p6_a33
2438 , p6_a34
2439 , p6_a35
2440 , p6_a36
2441 , p6_a37
2442 , p6_a38
2443 , p6_a39
2444 , p6_a40
2445 , p6_a41
2446 , p6_a42
2447 , p6_a43
2448 , p6_a44
2449 , p6_a45
2450 , p6_a46
2451 , p6_a47
2452 , p6_a48
2453 , p6_a49
2454 , p6_a50
2455 , p6_a51
2456 , p6_a52
2457 , p6_a53
2458 , p6_a54
2459 , p6_a55
2460 , p6_a56
2461 , p6_a57
2462 , p6_a58
2463 , p6_a59
2464 , p6_a60
2465 , p6_a61
2466 , p6_a62
2467 );
2468 end;
2469
2470 procedure delete_row(p_api_version NUMBER
2471 , p_init_msg_list VARCHAR2
2472 , x_return_status out nocopy VARCHAR2
2473 , x_msg_count out nocopy NUMBER
2474 , x_msg_data out nocopy VARCHAR2
2475 , p5_a0 NUMBER := 0-1962.0724
2476 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2477 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2478 , p5_a3 NUMBER := 0-1962.0724
2479 , p5_a4 NUMBER := 0-1962.0724
2480 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2481 , p5_a6 NUMBER := 0-1962.0724
2482 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2483 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2484 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2485 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2486 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2487 , p5_a12 NUMBER := 0-1962.0724
2488 , p5_a13 NUMBER := 0-1962.0724
2489 , p5_a14 NUMBER := 0-1962.0724
2490 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2491 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2492 , p5_a17 NUMBER := 0-1962.0724
2493 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2494 , p5_a19 NUMBER := 0-1962.0724
2495 , p5_a20 NUMBER := 0-1962.0724
2496 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2497 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2498 , p5_a23 NUMBER := 0-1962.0724
2499 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2500 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2501 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2502 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2503 , p5_a28 NUMBER := 0-1962.0724
2504 , p5_a29 NUMBER := 0-1962.0724
2505 , p5_a30 NUMBER := 0-1962.0724
2506 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2507 , p5_a32 NUMBER := 0-1962.0724
2508 , p5_a33 NUMBER := 0-1962.0724
2509 , p5_a34 NUMBER := 0-1962.0724
2510 , p5_a35 NUMBER := 0-1962.0724
2511 , p5_a36 NUMBER := 0-1962.0724
2512 , p5_a37 DATE := fnd_api.g_miss_date
2513 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2514 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2515 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2516 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2517 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2518 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2519 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2520 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2521 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2522 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2523 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2524 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2525 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2526 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2527 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2528 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2529 , p5_a54 NUMBER := 0-1962.0724
2530 , p5_a55 DATE := fnd_api.g_miss_date
2531 , p5_a56 NUMBER := 0-1962.0724
2532 , p5_a57 DATE := fnd_api.g_miss_date
2533 , p5_a58 NUMBER := 0-1962.0724
2534 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2535 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2536 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2537 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2538 )
2539
2540 as
2541 ddp_sypv_rec okl_syp_pvt.sypv_rec_type;
2542 ddindx binary_integer; indx binary_integer;
2543 begin
2544
2545 -- copy data to the local IN or IN-OUT args, if any
2546
2547
2548
2549
2550
2551 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
2552 ddp_sypv_rec.delink_yn := p5_a1;
2553 ddp_sypv_rec.remk_subinventory := p5_a2;
2554 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
2555 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
2556 ddp_sypv_rec.remk_process_code := p5_a5;
2557 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
2558 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
2559 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
2560 ddp_sypv_rec.tax_upfront_yn := p5_a9;
2561 ddp_sypv_rec.tax_invoice_yn := p5_a10;
2562 ddp_sypv_rec.tax_schedule_yn := p5_a11;
2563 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
2564 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
2565 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
2566 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
2567 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
2568 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
2569 ddp_sypv_rec.owner_type_code := p5_a18;
2570 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
2571 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
2572 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
2573 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
2574 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
2575 ddp_sypv_rec.corporate_book := p5_a24;
2576 ddp_sypv_rec.tax_book_1 := p5_a25;
2577 ddp_sypv_rec.tax_book_2 := p5_a26;
2578 ddp_sypv_rec.depreciate_yn := p5_a27;
2579 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
2580 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
2581 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
2582 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
2583 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
2584 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
2585 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
2586 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
2587 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
2588 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
2589 ddp_sypv_rec.attribute_category := p5_a38;
2590 ddp_sypv_rec.attribute1 := p5_a39;
2591 ddp_sypv_rec.attribute2 := p5_a40;
2592 ddp_sypv_rec.attribute3 := p5_a41;
2593 ddp_sypv_rec.attribute4 := p5_a42;
2594 ddp_sypv_rec.attribute5 := p5_a43;
2595 ddp_sypv_rec.attribute6 := p5_a44;
2596 ddp_sypv_rec.attribute7 := p5_a45;
2597 ddp_sypv_rec.attribute8 := p5_a46;
2598 ddp_sypv_rec.attribute9 := p5_a47;
2599 ddp_sypv_rec.attribute10 := p5_a48;
2600 ddp_sypv_rec.attribute11 := p5_a49;
2601 ddp_sypv_rec.attribute12 := p5_a50;
2602 ddp_sypv_rec.attribute13 := p5_a51;
2603 ddp_sypv_rec.attribute14 := p5_a52;
2604 ddp_sypv_rec.attribute15 := p5_a53;
2605 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2606 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
2607 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
2608 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2609 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2610 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
2611 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
2612 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
2613 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
2614
2615 -- here's the delegated call to the old PL/SQL routine
2616 okl_syp_pvt.delete_row(p_api_version,
2617 p_init_msg_list,
2618 x_return_status,
2619 x_msg_count,
2620 x_msg_data,
2621 ddp_sypv_rec);
2622
2623 -- copy data back from the local variables to OUT or IN-OUT args, if any
2624
2625
2626
2627
2628
2629 end;
2630
2631 procedure delete_row(p_api_version NUMBER
2632 , p_init_msg_list VARCHAR2
2633 , x_return_status out nocopy VARCHAR2
2634 , x_msg_count out nocopy NUMBER
2635 , x_msg_data out nocopy VARCHAR2
2636 , p5_a0 JTF_NUMBER_TABLE
2637 , p5_a1 JTF_VARCHAR2_TABLE_100
2638 , p5_a2 JTF_VARCHAR2_TABLE_100
2639 , p5_a3 JTF_NUMBER_TABLE
2640 , p5_a4 JTF_NUMBER_TABLE
2641 , p5_a5 JTF_VARCHAR2_TABLE_100
2642 , p5_a6 JTF_NUMBER_TABLE
2643 , p5_a7 JTF_VARCHAR2_TABLE_100
2644 , p5_a8 JTF_VARCHAR2_TABLE_100
2645 , p5_a9 JTF_VARCHAR2_TABLE_100
2646 , p5_a10 JTF_VARCHAR2_TABLE_100
2647 , p5_a11 JTF_VARCHAR2_TABLE_100
2648 , p5_a12 JTF_NUMBER_TABLE
2649 , p5_a13 JTF_NUMBER_TABLE
2650 , p5_a14 JTF_NUMBER_TABLE
2651 , p5_a15 JTF_VARCHAR2_TABLE_100
2652 , p5_a16 JTF_VARCHAR2_TABLE_100
2653 , p5_a17 JTF_NUMBER_TABLE
2654 , p5_a18 JTF_VARCHAR2_TABLE_100
2655 , p5_a19 JTF_NUMBER_TABLE
2656 , p5_a20 JTF_NUMBER_TABLE
2657 , p5_a21 JTF_VARCHAR2_TABLE_100
2658 , p5_a22 JTF_VARCHAR2_TABLE_100
2659 , p5_a23 JTF_NUMBER_TABLE
2660 , p5_a24 JTF_VARCHAR2_TABLE_100
2661 , p5_a25 JTF_VARCHAR2_TABLE_100
2662 , p5_a26 JTF_VARCHAR2_TABLE_100
2663 , p5_a27 JTF_VARCHAR2_TABLE_100
2664 , p5_a28 JTF_NUMBER_TABLE
2665 , p5_a29 JTF_NUMBER_TABLE
2666 , p5_a30 JTF_NUMBER_TABLE
2667 , p5_a31 JTF_VARCHAR2_TABLE_100
2668 , p5_a32 JTF_NUMBER_TABLE
2669 , p5_a33 JTF_NUMBER_TABLE
2670 , p5_a34 JTF_NUMBER_TABLE
2671 , p5_a35 JTF_NUMBER_TABLE
2672 , p5_a36 JTF_NUMBER_TABLE
2673 , p5_a37 JTF_DATE_TABLE
2674 , p5_a38 JTF_VARCHAR2_TABLE_100
2675 , p5_a39 JTF_VARCHAR2_TABLE_500
2676 , p5_a40 JTF_VARCHAR2_TABLE_500
2677 , p5_a41 JTF_VARCHAR2_TABLE_500
2678 , p5_a42 JTF_VARCHAR2_TABLE_500
2679 , p5_a43 JTF_VARCHAR2_TABLE_500
2680 , p5_a44 JTF_VARCHAR2_TABLE_500
2681 , p5_a45 JTF_VARCHAR2_TABLE_500
2682 , p5_a46 JTF_VARCHAR2_TABLE_500
2683 , p5_a47 JTF_VARCHAR2_TABLE_500
2684 , p5_a48 JTF_VARCHAR2_TABLE_500
2685 , p5_a49 JTF_VARCHAR2_TABLE_500
2686 , p5_a50 JTF_VARCHAR2_TABLE_500
2687 , p5_a51 JTF_VARCHAR2_TABLE_500
2688 , p5_a52 JTF_VARCHAR2_TABLE_500
2689 , p5_a53 JTF_VARCHAR2_TABLE_500
2690 , p5_a54 JTF_NUMBER_TABLE
2691 , p5_a55 JTF_DATE_TABLE
2692 , p5_a56 JTF_NUMBER_TABLE
2693 , p5_a57 JTF_DATE_TABLE
2694 , p5_a58 JTF_NUMBER_TABLE
2695 , p5_a59 JTF_VARCHAR2_TABLE_200
2696 , p5_a60 JTF_VARCHAR2_TABLE_200
2697 , p5_a61 JTF_VARCHAR2_TABLE_200
2698 , p5_a62 JTF_VARCHAR2_TABLE_200
2699 )
2700
2701 as
2702 ddp_sypv_tbl okl_syp_pvt.sypv_tbl_type;
2703 ddindx binary_integer; indx binary_integer;
2704 begin
2705
2706 -- copy data to the local IN or IN-OUT args, if any
2707
2708
2709
2710
2711
2712 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
2713 , p5_a1
2714 , p5_a2
2715 , p5_a3
2716 , p5_a4
2717 , p5_a5
2718 , p5_a6
2719 , p5_a7
2720 , p5_a8
2721 , p5_a9
2722 , p5_a10
2723 , p5_a11
2724 , p5_a12
2725 , p5_a13
2726 , p5_a14
2727 , p5_a15
2728 , p5_a16
2729 , p5_a17
2730 , p5_a18
2731 , p5_a19
2732 , p5_a20
2733 , p5_a21
2734 , p5_a22
2735 , p5_a23
2736 , p5_a24
2737 , p5_a25
2738 , p5_a26
2739 , p5_a27
2740 , p5_a28
2741 , p5_a29
2742 , p5_a30
2743 , p5_a31
2744 , p5_a32
2745 , p5_a33
2746 , p5_a34
2747 , p5_a35
2748 , p5_a36
2749 , p5_a37
2750 , p5_a38
2751 , p5_a39
2752 , p5_a40
2753 , p5_a41
2754 , p5_a42
2755 , p5_a43
2756 , p5_a44
2757 , p5_a45
2758 , p5_a46
2759 , p5_a47
2760 , p5_a48
2761 , p5_a49
2762 , p5_a50
2763 , p5_a51
2764 , p5_a52
2765 , p5_a53
2766 , p5_a54
2767 , p5_a55
2768 , p5_a56
2769 , p5_a57
2770 , p5_a58
2771 , p5_a59
2772 , p5_a60
2773 , p5_a61
2774 , p5_a62
2775 );
2776
2777 -- here's the delegated call to the old PL/SQL routine
2778 okl_syp_pvt.delete_row(p_api_version,
2779 p_init_msg_list,
2780 x_return_status,
2781 x_msg_count,
2782 x_msg_data,
2783 ddp_sypv_tbl);
2784
2785 -- copy data back from the local variables to OUT or IN-OUT args, if any
2786
2787
2788
2789
2790
2791 end;
2792
2793 procedure validate_row(p_api_version NUMBER
2794 , p_init_msg_list VARCHAR2
2795 , x_return_status out nocopy VARCHAR2
2796 , x_msg_count out nocopy NUMBER
2797 , x_msg_data out nocopy VARCHAR2
2798 , p5_a0 NUMBER := 0-1962.0724
2799 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2800 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2801 , p5_a3 NUMBER := 0-1962.0724
2802 , p5_a4 NUMBER := 0-1962.0724
2803 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2804 , p5_a6 NUMBER := 0-1962.0724
2805 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2806 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2807 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2808 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2809 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2810 , p5_a12 NUMBER := 0-1962.0724
2811 , p5_a13 NUMBER := 0-1962.0724
2812 , p5_a14 NUMBER := 0-1962.0724
2813 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2814 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2815 , p5_a17 NUMBER := 0-1962.0724
2816 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2817 , p5_a19 NUMBER := 0-1962.0724
2818 , p5_a20 NUMBER := 0-1962.0724
2819 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2820 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2821 , p5_a23 NUMBER := 0-1962.0724
2822 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2823 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2824 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2825 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2826 , p5_a28 NUMBER := 0-1962.0724
2827 , p5_a29 NUMBER := 0-1962.0724
2828 , p5_a30 NUMBER := 0-1962.0724
2829 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2830 , p5_a32 NUMBER := 0-1962.0724
2831 , p5_a33 NUMBER := 0-1962.0724
2832 , p5_a34 NUMBER := 0-1962.0724
2833 , p5_a35 NUMBER := 0-1962.0724
2834 , p5_a36 NUMBER := 0-1962.0724
2835 , p5_a37 DATE := fnd_api.g_miss_date
2836 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2837 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2838 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2839 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2840 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2841 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2842 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2843 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2844 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2845 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2846 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2847 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2848 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2849 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2850 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2851 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2852 , p5_a54 NUMBER := 0-1962.0724
2853 , p5_a55 DATE := fnd_api.g_miss_date
2854 , p5_a56 NUMBER := 0-1962.0724
2855 , p5_a57 DATE := fnd_api.g_miss_date
2856 , p5_a58 NUMBER := 0-1962.0724
2857 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2858 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2859 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2860 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2861 )
2862
2863 as
2864 ddp_sypv_rec okl_syp_pvt.sypv_rec_type;
2865 ddindx binary_integer; indx binary_integer;
2866 begin
2867
2868 -- copy data to the local IN or IN-OUT args, if any
2869
2870
2871
2872
2873
2874 ddp_sypv_rec.id := rosetta_g_miss_num_map(p5_a0);
2875 ddp_sypv_rec.delink_yn := p5_a1;
2876 ddp_sypv_rec.remk_subinventory := p5_a2;
2877 ddp_sypv_rec.remk_organization_id := rosetta_g_miss_num_map(p5_a3);
2878 ddp_sypv_rec.remk_price_list_id := rosetta_g_miss_num_map(p5_a4);
2879 ddp_sypv_rec.remk_process_code := p5_a5;
2880 ddp_sypv_rec.remk_item_template_id := rosetta_g_miss_num_map(p5_a6);
2881 ddp_sypv_rec.remk_item_invoiced_code := p5_a7;
2882 ddp_sypv_rec.lease_inv_org_yn := p5_a8;
2883 ddp_sypv_rec.tax_upfront_yn := p5_a9;
2884 ddp_sypv_rec.tax_invoice_yn := p5_a10;
2885 ddp_sypv_rec.tax_schedule_yn := p5_a11;
2886 ddp_sypv_rec.tax_upfront_sty_id := rosetta_g_miss_num_map(p5_a12);
2887 ddp_sypv_rec.category_set_id := rosetta_g_miss_num_map(p5_a13);
2888 ddp_sypv_rec.validation_set_id := rosetta_g_miss_num_map(p5_a14);
2889 ddp_sypv_rec.cancel_quotes_yn := p5_a15;
2890 ddp_sypv_rec.chk_accrual_previous_mnth_yn := p5_a16;
2891 ddp_sypv_rec.task_template_group_id := rosetta_g_miss_num_map(p5_a17);
2892 ddp_sypv_rec.owner_type_code := p5_a18;
2893 ddp_sypv_rec.owner_id := rosetta_g_miss_num_map(p5_a19);
2894 ddp_sypv_rec.item_inv_org_id := rosetta_g_miss_num_map(p5_a20);
2895 ddp_sypv_rec.rpt_prod_book_type_code := p5_a21;
2896 ddp_sypv_rec.asst_add_book_type_code := p5_a22;
2897 ddp_sypv_rec.ccard_remittance_id := rosetta_g_miss_num_map(p5_a23);
2898 ddp_sypv_rec.corporate_book := p5_a24;
2899 ddp_sypv_rec.tax_book_1 := p5_a25;
2900 ddp_sypv_rec.tax_book_2 := p5_a26;
2901 ddp_sypv_rec.depreciate_yn := p5_a27;
2902 ddp_sypv_rec.fa_location_id := rosetta_g_miss_num_map(p5_a28);
2903 ddp_sypv_rec.formula_id := rosetta_g_miss_num_map(p5_a29);
2904 ddp_sypv_rec.asset_key_id := rosetta_g_miss_num_map(p5_a30);
2905 ddp_sypv_rec.part_trmnt_apply_round_diff := p5_a31;
2906 ddp_sypv_rec.object_version_number := rosetta_g_miss_num_map(p5_a32);
2907 ddp_sypv_rec.org_id := rosetta_g_miss_num_map(p5_a33);
2908 ddp_sypv_rec.request_id := rosetta_g_miss_num_map(p5_a34);
2909 ddp_sypv_rec.program_application_id := rosetta_g_miss_num_map(p5_a35);
2910 ddp_sypv_rec.program_id := rosetta_g_miss_num_map(p5_a36);
2911 ddp_sypv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a37);
2912 ddp_sypv_rec.attribute_category := p5_a38;
2913 ddp_sypv_rec.attribute1 := p5_a39;
2914 ddp_sypv_rec.attribute2 := p5_a40;
2915 ddp_sypv_rec.attribute3 := p5_a41;
2916 ddp_sypv_rec.attribute4 := p5_a42;
2917 ddp_sypv_rec.attribute5 := p5_a43;
2918 ddp_sypv_rec.attribute6 := p5_a44;
2919 ddp_sypv_rec.attribute7 := p5_a45;
2920 ddp_sypv_rec.attribute8 := p5_a46;
2921 ddp_sypv_rec.attribute9 := p5_a47;
2922 ddp_sypv_rec.attribute10 := p5_a48;
2923 ddp_sypv_rec.attribute11 := p5_a49;
2924 ddp_sypv_rec.attribute12 := p5_a50;
2925 ddp_sypv_rec.attribute13 := p5_a51;
2926 ddp_sypv_rec.attribute14 := p5_a52;
2927 ddp_sypv_rec.attribute15 := p5_a53;
2928 ddp_sypv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2929 ddp_sypv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
2930 ddp_sypv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
2931 ddp_sypv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2932 ddp_sypv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2933 ddp_sypv_rec.lseapp_seq_prefix_txt := p5_a59;
2934 ddp_sypv_rec.lseopp_seq_prefix_txt := p5_a60;
2935 ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
2936 ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
2937
2938 -- here's the delegated call to the old PL/SQL routine
2939 okl_syp_pvt.validate_row(p_api_version,
2940 p_init_msg_list,
2941 x_return_status,
2942 x_msg_count,
2943 x_msg_data,
2944 ddp_sypv_rec);
2945
2946 -- copy data back from the local variables to OUT or IN-OUT args, if any
2947
2948
2949
2950
2951
2952 end;
2953
2954 procedure validate_row(p_api_version NUMBER
2955 , p_init_msg_list VARCHAR2
2956 , x_return_status out nocopy VARCHAR2
2957 , x_msg_count out nocopy NUMBER
2958 , x_msg_data out nocopy VARCHAR2
2959 , p5_a0 JTF_NUMBER_TABLE
2960 , p5_a1 JTF_VARCHAR2_TABLE_100
2961 , p5_a2 JTF_VARCHAR2_TABLE_100
2962 , p5_a3 JTF_NUMBER_TABLE
2963 , p5_a4 JTF_NUMBER_TABLE
2964 , p5_a5 JTF_VARCHAR2_TABLE_100
2965 , p5_a6 JTF_NUMBER_TABLE
2966 , p5_a7 JTF_VARCHAR2_TABLE_100
2967 , p5_a8 JTF_VARCHAR2_TABLE_100
2968 , p5_a9 JTF_VARCHAR2_TABLE_100
2969 , p5_a10 JTF_VARCHAR2_TABLE_100
2970 , p5_a11 JTF_VARCHAR2_TABLE_100
2971 , p5_a12 JTF_NUMBER_TABLE
2972 , p5_a13 JTF_NUMBER_TABLE
2973 , p5_a14 JTF_NUMBER_TABLE
2974 , p5_a15 JTF_VARCHAR2_TABLE_100
2975 , p5_a16 JTF_VARCHAR2_TABLE_100
2976 , p5_a17 JTF_NUMBER_TABLE
2977 , p5_a18 JTF_VARCHAR2_TABLE_100
2978 , p5_a19 JTF_NUMBER_TABLE
2979 , p5_a20 JTF_NUMBER_TABLE
2980 , p5_a21 JTF_VARCHAR2_TABLE_100
2981 , p5_a22 JTF_VARCHAR2_TABLE_100
2982 , p5_a23 JTF_NUMBER_TABLE
2983 , p5_a24 JTF_VARCHAR2_TABLE_100
2984 , p5_a25 JTF_VARCHAR2_TABLE_100
2985 , p5_a26 JTF_VARCHAR2_TABLE_100
2986 , p5_a27 JTF_VARCHAR2_TABLE_100
2987 , p5_a28 JTF_NUMBER_TABLE
2988 , p5_a29 JTF_NUMBER_TABLE
2989 , p5_a30 JTF_NUMBER_TABLE
2990 , p5_a31 JTF_VARCHAR2_TABLE_100
2991 , p5_a32 JTF_NUMBER_TABLE
2992 , p5_a33 JTF_NUMBER_TABLE
2993 , p5_a34 JTF_NUMBER_TABLE
2994 , p5_a35 JTF_NUMBER_TABLE
2995 , p5_a36 JTF_NUMBER_TABLE
2996 , p5_a37 JTF_DATE_TABLE
2997 , p5_a38 JTF_VARCHAR2_TABLE_100
2998 , p5_a39 JTF_VARCHAR2_TABLE_500
2999 , p5_a40 JTF_VARCHAR2_TABLE_500
3000 , p5_a41 JTF_VARCHAR2_TABLE_500
3001 , p5_a42 JTF_VARCHAR2_TABLE_500
3002 , p5_a43 JTF_VARCHAR2_TABLE_500
3003 , p5_a44 JTF_VARCHAR2_TABLE_500
3004 , p5_a45 JTF_VARCHAR2_TABLE_500
3005 , p5_a46 JTF_VARCHAR2_TABLE_500
3006 , p5_a47 JTF_VARCHAR2_TABLE_500
3007 , p5_a48 JTF_VARCHAR2_TABLE_500
3008 , p5_a49 JTF_VARCHAR2_TABLE_500
3009 , p5_a50 JTF_VARCHAR2_TABLE_500
3010 , p5_a51 JTF_VARCHAR2_TABLE_500
3011 , p5_a52 JTF_VARCHAR2_TABLE_500
3012 , p5_a53 JTF_VARCHAR2_TABLE_500
3013 , p5_a54 JTF_NUMBER_TABLE
3014 , p5_a55 JTF_DATE_TABLE
3015 , p5_a56 JTF_NUMBER_TABLE
3016 , p5_a57 JTF_DATE_TABLE
3017 , p5_a58 JTF_NUMBER_TABLE
3018 , p5_a59 JTF_VARCHAR2_TABLE_200
3019 , p5_a60 JTF_VARCHAR2_TABLE_200
3020 , p5_a61 JTF_VARCHAR2_TABLE_200
3021 , p5_a62 JTF_VARCHAR2_TABLE_200
3022 )
3023
3024 as
3025 ddp_sypv_tbl okl_syp_pvt.sypv_tbl_type;
3026 ddindx binary_integer; indx binary_integer;
3027 begin
3028
3029 -- copy data to the local IN or IN-OUT args, if any
3030
3031
3032
3033
3034
3035 okl_syp_pvt_w.rosetta_table_copy_in_p2(ddp_sypv_tbl, p5_a0
3036 , p5_a1
3037 , p5_a2
3038 , p5_a3
3039 , p5_a4
3040 , p5_a5
3041 , p5_a6
3042 , p5_a7
3043 , p5_a8
3044 , p5_a9
3045 , p5_a10
3046 , p5_a11
3047 , p5_a12
3048 , p5_a13
3049 , p5_a14
3050 , p5_a15
3051 , p5_a16
3052 , p5_a17
3053 , p5_a18
3054 , p5_a19
3055 , p5_a20
3056 , p5_a21
3057 , p5_a22
3058 , p5_a23
3059 , p5_a24
3060 , p5_a25
3061 , p5_a26
3062 , p5_a27
3063 , p5_a28
3064 , p5_a29
3065 , p5_a30
3066 , p5_a31
3067 , p5_a32
3068 , p5_a33
3069 , p5_a34
3070 , p5_a35
3071 , p5_a36
3072 , p5_a37
3073 , p5_a38
3074 , p5_a39
3075 , p5_a40
3076 , p5_a41
3077 , p5_a42
3078 , p5_a43
3079 , p5_a44
3080 , p5_a45
3081 , p5_a46
3082 , p5_a47
3083 , p5_a48
3084 , p5_a49
3085 , p5_a50
3086 , p5_a51
3087 , p5_a52
3088 , p5_a53
3089 , p5_a54
3090 , p5_a55
3091 , p5_a56
3092 , p5_a57
3093 , p5_a58
3094 , p5_a59
3095 , p5_a60
3096 , p5_a61
3097 , p5_a62
3098 );
3099
3100 -- here's the delegated call to the old PL/SQL routine
3101 okl_syp_pvt.validate_row(p_api_version,
3102 p_init_msg_list,
3103 x_return_status,
3104 x_msg_count,
3105 x_msg_data,
3106 ddp_sypv_tbl);
3107
3108 -- copy data back from the local variables to OUT or IN-OUT args, if any
3109
3110
3111
3112
3113
3114 end;
3115
3116 end okl_syp_pvt_w;