12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_code_conversion_pvt.code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_code_conversion_pvt.code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_code_conversion_pvt.code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_300
28: , a12 JTF_VARCHAR2_TABLE_300
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_300
28: , a12 JTF_VARCHAR2_TABLE_300
29: , a13 JTF_VARCHAR2_TABLE_300
44: , a28 JTF_VARCHAR2_TABLE_200
45: , a29 JTF_VARCHAR2_TABLE_200
46: , a30 JTF_VARCHAR2_TABLE_200
47: , a31 JTF_VARCHAR2_TABLE_200
48: , a32 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count=0 then
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_code_conversion_pvt.code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
100: end if;
101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_code_conversion_pvt.code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_code_conversion_pvt.code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_VARCHAR2_TABLE_300
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_VARCHAR2_TABLE_300
115: , a12 out nocopy JTF_VARCHAR2_TABLE_300
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_NUMBER_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_VARCHAR2_TABLE_300
115: , a12 out nocopy JTF_VARCHAR2_TABLE_300
116: , a13 out nocopy JTF_VARCHAR2_TABLE_300
131: , a28 out nocopy JTF_VARCHAR2_TABLE_200
132: , a29 out nocopy JTF_VARCHAR2_TABLE_200
133: , a30 out nocopy JTF_VARCHAR2_TABLE_200
134: , a31 out nocopy JTF_VARCHAR2_TABLE_200
135: , a32 out nocopy JTF_NUMBER_TABLE
136: ) as
137: ddindx binary_integer; indx binary_integer;
138: begin
139: if t is null then
170: a30 := null;
171: a31 := null;
172: a32 := null;
173: elsif t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_DATE_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
171: a31 := null;
172: a32 := null;
173: elsif t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_DATE_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
173: elsif t.count = 0 then
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_DATE_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_DATE_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
182: a8 := JTF_NUMBER_TABLE();
183: a9 := JTF_NUMBER_TABLE();
176: a2 := JTF_DATE_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
182: a8 := JTF_NUMBER_TABLE();
183: a9 := JTF_NUMBER_TABLE();
184: a10 := JTF_VARCHAR2_TABLE_100();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
182: a8 := JTF_NUMBER_TABLE();
183: a9 := JTF_NUMBER_TABLE();
184: a10 := JTF_VARCHAR2_TABLE_100();
185: a11 := JTF_VARCHAR2_TABLE_300();
178: a4 := JTF_DATE_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
182: a8 := JTF_NUMBER_TABLE();
183: a9 := JTF_NUMBER_TABLE();
184: a10 := JTF_VARCHAR2_TABLE_100();
185: a11 := JTF_VARCHAR2_TABLE_300();
186: a12 := JTF_VARCHAR2_TABLE_300();
179: a5 := JTF_NUMBER_TABLE();
180: a6 := JTF_NUMBER_TABLE();
181: a7 := JTF_NUMBER_TABLE();
182: a8 := JTF_NUMBER_TABLE();
183: a9 := JTF_NUMBER_TABLE();
184: a10 := JTF_VARCHAR2_TABLE_100();
185: a11 := JTF_VARCHAR2_TABLE_300();
186: a12 := JTF_VARCHAR2_TABLE_300();
187: a13 := JTF_VARCHAR2_TABLE_300();
202: a28 := JTF_VARCHAR2_TABLE_200();
203: a29 := JTF_VARCHAR2_TABLE_200();
204: a30 := JTF_VARCHAR2_TABLE_200();
205: a31 := JTF_VARCHAR2_TABLE_200();
206: a32 := JTF_NUMBER_TABLE();
207: else
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
204: a30 := JTF_VARCHAR2_TABLE_200();
205: a31 := JTF_VARCHAR2_TABLE_200();
206: a32 := JTF_NUMBER_TABLE();
207: else
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
205: a31 := JTF_VARCHAR2_TABLE_200();
206: a32 := JTF_NUMBER_TABLE();
207: else
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
207: else
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_300();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_300();
220: a12 := JTF_VARCHAR2_TABLE_300();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_NUMBER_TABLE();
218: a10 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_300();
220: a12 := JTF_VARCHAR2_TABLE_300();
221: a13 := JTF_VARCHAR2_TABLE_300();
236: a28 := JTF_VARCHAR2_TABLE_200();
237: a29 := JTF_VARCHAR2_TABLE_200();
238: a30 := JTF_VARCHAR2_TABLE_200();
239: a31 := JTF_VARCHAR2_TABLE_200();
240: a32 := JTF_NUMBER_TABLE();
241: if t.count > 0 then
242: a0.extend(t.count);
243: a1.extend(t.count);
244: a2.extend(t.count);
317: end if;
318: end if;
319: end rosetta_table_copy_out_p3;
320:
321: procedure rosetta_table_copy_in_p15(t out nocopy ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
322: , a1 JTF_NUMBER_TABLE
323: , a2 JTF_DATE_TABLE
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
318: end if;
319: end rosetta_table_copy_out_p3;
320:
321: procedure rosetta_table_copy_in_p15(t out nocopy ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
322: , a1 JTF_NUMBER_TABLE
323: , a2 JTF_DATE_TABLE
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
320:
321: procedure rosetta_table_copy_in_p15(t out nocopy ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 JTF_NUMBER_TABLE
322: , a1 JTF_NUMBER_TABLE
323: , a2 JTF_DATE_TABLE
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
327: , a6 JTF_NUMBER_TABLE
328: , a7 JTF_NUMBER_TABLE
322: , a1 JTF_NUMBER_TABLE
323: , a2 JTF_DATE_TABLE
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
327: , a6 JTF_NUMBER_TABLE
328: , a7 JTF_NUMBER_TABLE
329: , a8 JTF_NUMBER_TABLE
330: , a9 JTF_VARCHAR2_TABLE_100
323: , a2 JTF_DATE_TABLE
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
327: , a6 JTF_NUMBER_TABLE
328: , a7 JTF_NUMBER_TABLE
329: , a8 JTF_NUMBER_TABLE
330: , a9 JTF_VARCHAR2_TABLE_100
331: , a10 JTF_VARCHAR2_TABLE_300
324: , a3 JTF_NUMBER_TABLE
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
327: , a6 JTF_NUMBER_TABLE
328: , a7 JTF_NUMBER_TABLE
329: , a8 JTF_NUMBER_TABLE
330: , a9 JTF_VARCHAR2_TABLE_100
331: , a10 JTF_VARCHAR2_TABLE_300
332: , a11 JTF_VARCHAR2_TABLE_300
325: , a4 JTF_DATE_TABLE
326: , a5 JTF_NUMBER_TABLE
327: , a6 JTF_NUMBER_TABLE
328: , a7 JTF_NUMBER_TABLE
329: , a8 JTF_NUMBER_TABLE
330: , a9 JTF_VARCHAR2_TABLE_100
331: , a10 JTF_VARCHAR2_TABLE_300
332: , a11 JTF_VARCHAR2_TABLE_300
333: , a12 JTF_VARCHAR2_TABLE_300
348: , a27 JTF_VARCHAR2_TABLE_200
349: , a28 JTF_VARCHAR2_TABLE_200
350: , a29 JTF_VARCHAR2_TABLE_200
351: , a30 JTF_VARCHAR2_TABLE_200
352: , a31 JTF_NUMBER_TABLE
353: ) as
354: ddindx binary_integer; indx binary_integer;
355: begin
356: if a0 is not null and a0.count=0 then
402: end loop;
403: end if;
404: end if;
405: end rosetta_table_copy_in_p15;
406: procedure rosetta_table_copy_out_p15(t ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_DATE_TABLE
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
403: end if;
404: end if;
405: end rosetta_table_copy_in_p15;
406: procedure rosetta_table_copy_out_p15(t ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_DATE_TABLE
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
405: end rosetta_table_copy_in_p15;
406: procedure rosetta_table_copy_out_p15(t ozf_code_conversion_pvt.supp_code_conversion_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_DATE_TABLE
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
407: , a1 out nocopy JTF_NUMBER_TABLE
408: , a2 out nocopy JTF_DATE_TABLE
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
408: , a2 out nocopy JTF_DATE_TABLE
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_300
409: , a3 out nocopy JTF_NUMBER_TABLE
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , a11 out nocopy JTF_VARCHAR2_TABLE_300
410: , a4 out nocopy JTF_DATE_TABLE
411: , a5 out nocopy JTF_NUMBER_TABLE
412: , a6 out nocopy JTF_NUMBER_TABLE
413: , a7 out nocopy JTF_NUMBER_TABLE
414: , a8 out nocopy JTF_NUMBER_TABLE
415: , a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , a10 out nocopy JTF_VARCHAR2_TABLE_300
417: , a11 out nocopy JTF_VARCHAR2_TABLE_300
418: , a12 out nocopy JTF_VARCHAR2_TABLE_300
433: , a27 out nocopy JTF_VARCHAR2_TABLE_200
434: , a28 out nocopy JTF_VARCHAR2_TABLE_200
435: , a29 out nocopy JTF_VARCHAR2_TABLE_200
436: , a30 out nocopy JTF_VARCHAR2_TABLE_200
437: , a31 out nocopy JTF_NUMBER_TABLE
438: ) as
439: ddindx binary_integer; indx binary_integer;
440: begin
441: if t is null then
471: a29 := null;
472: a30 := null;
473: a31 := null;
474: elsif t.count = 0 then
475: a0 := JTF_NUMBER_TABLE();
476: a1 := JTF_NUMBER_TABLE();
477: a2 := JTF_DATE_TABLE();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
472: a30 := null;
473: a31 := null;
474: elsif t.count = 0 then
475: a0 := JTF_NUMBER_TABLE();
476: a1 := JTF_NUMBER_TABLE();
477: a2 := JTF_DATE_TABLE();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
474: elsif t.count = 0 then
475: a0 := JTF_NUMBER_TABLE();
476: a1 := JTF_NUMBER_TABLE();
477: a2 := JTF_DATE_TABLE();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
481: a6 := JTF_NUMBER_TABLE();
482: a7 := JTF_NUMBER_TABLE();
476: a1 := JTF_NUMBER_TABLE();
477: a2 := JTF_DATE_TABLE();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
481: a6 := JTF_NUMBER_TABLE();
482: a7 := JTF_NUMBER_TABLE();
483: a8 := JTF_NUMBER_TABLE();
484: a9 := JTF_VARCHAR2_TABLE_100();
477: a2 := JTF_DATE_TABLE();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
481: a6 := JTF_NUMBER_TABLE();
482: a7 := JTF_NUMBER_TABLE();
483: a8 := JTF_NUMBER_TABLE();
484: a9 := JTF_VARCHAR2_TABLE_100();
485: a10 := JTF_VARCHAR2_TABLE_300();
478: a3 := JTF_NUMBER_TABLE();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
481: a6 := JTF_NUMBER_TABLE();
482: a7 := JTF_NUMBER_TABLE();
483: a8 := JTF_NUMBER_TABLE();
484: a9 := JTF_VARCHAR2_TABLE_100();
485: a10 := JTF_VARCHAR2_TABLE_300();
486: a11 := JTF_VARCHAR2_TABLE_300();
479: a4 := JTF_DATE_TABLE();
480: a5 := JTF_NUMBER_TABLE();
481: a6 := JTF_NUMBER_TABLE();
482: a7 := JTF_NUMBER_TABLE();
483: a8 := JTF_NUMBER_TABLE();
484: a9 := JTF_VARCHAR2_TABLE_100();
485: a10 := JTF_VARCHAR2_TABLE_300();
486: a11 := JTF_VARCHAR2_TABLE_300();
487: a12 := JTF_VARCHAR2_TABLE_300();
502: a27 := JTF_VARCHAR2_TABLE_200();
503: a28 := JTF_VARCHAR2_TABLE_200();
504: a29 := JTF_VARCHAR2_TABLE_200();
505: a30 := JTF_VARCHAR2_TABLE_200();
506: a31 := JTF_NUMBER_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_DATE_TABLE();
504: a29 := JTF_VARCHAR2_TABLE_200();
505: a30 := JTF_VARCHAR2_TABLE_200();
506: a31 := JTF_NUMBER_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_DATE_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
505: a30 := JTF_VARCHAR2_TABLE_200();
506: a31 := JTF_NUMBER_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_DATE_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_DATE_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_DATE_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_VARCHAR2_TABLE_100();
510: a2 := JTF_DATE_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_VARCHAR2_TABLE_100();
518: a10 := JTF_VARCHAR2_TABLE_300();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_VARCHAR2_TABLE_100();
518: a10 := JTF_VARCHAR2_TABLE_300();
519: a11 := JTF_VARCHAR2_TABLE_300();
512: a4 := JTF_DATE_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_VARCHAR2_TABLE_100();
518: a10 := JTF_VARCHAR2_TABLE_300();
519: a11 := JTF_VARCHAR2_TABLE_300();
520: a12 := JTF_VARCHAR2_TABLE_300();
535: a27 := JTF_VARCHAR2_TABLE_200();
536: a28 := JTF_VARCHAR2_TABLE_200();
537: a29 := JTF_VARCHAR2_TABLE_200();
538: a30 := JTF_VARCHAR2_TABLE_200();
539: a31 := JTF_NUMBER_TABLE();
540: if t.count > 0 then
541: a0.extend(t.count);
542: a1.extend(t.count);
543: a2.extend(t.count);
621: , p_validation_level NUMBER
622: , x_return_status out nocopy VARCHAR2
623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p7_a0 JTF_NUMBER_TABLE
626: , p7_a1 JTF_NUMBER_TABLE
627: , p7_a2 JTF_DATE_TABLE
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
622: , x_return_status out nocopy VARCHAR2
623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p7_a0 JTF_NUMBER_TABLE
626: , p7_a1 JTF_NUMBER_TABLE
627: , p7_a2 JTF_DATE_TABLE
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
624: , x_msg_data out nocopy VARCHAR2
625: , p7_a0 JTF_NUMBER_TABLE
626: , p7_a1 JTF_NUMBER_TABLE
627: , p7_a2 JTF_DATE_TABLE
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
626: , p7_a1 JTF_NUMBER_TABLE
627: , p7_a2 JTF_DATE_TABLE
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
633: , p7_a8 JTF_NUMBER_TABLE
634: , p7_a9 JTF_NUMBER_TABLE
627: , p7_a2 JTF_DATE_TABLE
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
633: , p7_a8 JTF_NUMBER_TABLE
634: , p7_a9 JTF_NUMBER_TABLE
635: , p7_a10 JTF_VARCHAR2_TABLE_100
628: , p7_a3 JTF_NUMBER_TABLE
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
633: , p7_a8 JTF_NUMBER_TABLE
634: , p7_a9 JTF_NUMBER_TABLE
635: , p7_a10 JTF_VARCHAR2_TABLE_100
636: , p7_a11 JTF_VARCHAR2_TABLE_300
629: , p7_a4 JTF_DATE_TABLE
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
633: , p7_a8 JTF_NUMBER_TABLE
634: , p7_a9 JTF_NUMBER_TABLE
635: , p7_a10 JTF_VARCHAR2_TABLE_100
636: , p7_a11 JTF_VARCHAR2_TABLE_300
637: , p7_a12 JTF_VARCHAR2_TABLE_300
630: , p7_a5 JTF_NUMBER_TABLE
631: , p7_a6 JTF_NUMBER_TABLE
632: , p7_a7 JTF_NUMBER_TABLE
633: , p7_a8 JTF_NUMBER_TABLE
634: , p7_a9 JTF_NUMBER_TABLE
635: , p7_a10 JTF_VARCHAR2_TABLE_100
636: , p7_a11 JTF_VARCHAR2_TABLE_300
637: , p7_a12 JTF_VARCHAR2_TABLE_300
638: , p7_a13 JTF_VARCHAR2_TABLE_300
653: , p7_a28 JTF_VARCHAR2_TABLE_200
654: , p7_a29 JTF_VARCHAR2_TABLE_200
655: , p7_a30 JTF_VARCHAR2_TABLE_200
656: , p7_a31 JTF_VARCHAR2_TABLE_200
657: , p7_a32 JTF_NUMBER_TABLE
658: )
659:
660: as
661: ddp_code_conversion_tbl ozf_code_conversion_pvt.code_conversion_tbl_type;
731: , p_validation_level NUMBER
732: , x_return_status out nocopy VARCHAR2
733: , x_msg_count out nocopy NUMBER
734: , x_msg_data out nocopy VARCHAR2
735: , p7_a0 JTF_NUMBER_TABLE
736: , p7_a1 JTF_NUMBER_TABLE
737: , p7_a2 JTF_DATE_TABLE
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
732: , x_return_status out nocopy VARCHAR2
733: , x_msg_count out nocopy NUMBER
734: , x_msg_data out nocopy VARCHAR2
735: , p7_a0 JTF_NUMBER_TABLE
736: , p7_a1 JTF_NUMBER_TABLE
737: , p7_a2 JTF_DATE_TABLE
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
734: , x_msg_data out nocopy VARCHAR2
735: , p7_a0 JTF_NUMBER_TABLE
736: , p7_a1 JTF_NUMBER_TABLE
737: , p7_a2 JTF_DATE_TABLE
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
736: , p7_a1 JTF_NUMBER_TABLE
737: , p7_a2 JTF_DATE_TABLE
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
743: , p7_a8 JTF_NUMBER_TABLE
744: , p7_a9 JTF_NUMBER_TABLE
737: , p7_a2 JTF_DATE_TABLE
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
743: , p7_a8 JTF_NUMBER_TABLE
744: , p7_a9 JTF_NUMBER_TABLE
745: , p7_a10 JTF_VARCHAR2_TABLE_100
738: , p7_a3 JTF_NUMBER_TABLE
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
743: , p7_a8 JTF_NUMBER_TABLE
744: , p7_a9 JTF_NUMBER_TABLE
745: , p7_a10 JTF_VARCHAR2_TABLE_100
746: , p7_a11 JTF_VARCHAR2_TABLE_300
739: , p7_a4 JTF_DATE_TABLE
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
743: , p7_a8 JTF_NUMBER_TABLE
744: , p7_a9 JTF_NUMBER_TABLE
745: , p7_a10 JTF_VARCHAR2_TABLE_100
746: , p7_a11 JTF_VARCHAR2_TABLE_300
747: , p7_a12 JTF_VARCHAR2_TABLE_300
740: , p7_a5 JTF_NUMBER_TABLE
741: , p7_a6 JTF_NUMBER_TABLE
742: , p7_a7 JTF_NUMBER_TABLE
743: , p7_a8 JTF_NUMBER_TABLE
744: , p7_a9 JTF_NUMBER_TABLE
745: , p7_a10 JTF_VARCHAR2_TABLE_100
746: , p7_a11 JTF_VARCHAR2_TABLE_300
747: , p7_a12 JTF_VARCHAR2_TABLE_300
748: , p7_a13 JTF_VARCHAR2_TABLE_300
763: , p7_a28 JTF_VARCHAR2_TABLE_200
764: , p7_a29 JTF_VARCHAR2_TABLE_200
765: , p7_a30 JTF_VARCHAR2_TABLE_200
766: , p7_a31 JTF_VARCHAR2_TABLE_200
767: , p7_a32 JTF_NUMBER_TABLE
768: )
769:
770: as
771: ddp_code_conversion_tbl ozf_code_conversion_pvt.code_conversion_tbl_type;
927: procedure validate_code_conversion(p_api_version_number NUMBER
928: , p_init_msg_list VARCHAR2
929: , p_validation_level NUMBER
930: , p_validation_mode VARCHAR2
931: , p4_a0 JTF_NUMBER_TABLE
932: , p4_a1 JTF_NUMBER_TABLE
933: , p4_a2 JTF_DATE_TABLE
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
928: , p_init_msg_list VARCHAR2
929: , p_validation_level NUMBER
930: , p_validation_mode VARCHAR2
931: , p4_a0 JTF_NUMBER_TABLE
932: , p4_a1 JTF_NUMBER_TABLE
933: , p4_a2 JTF_DATE_TABLE
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
930: , p_validation_mode VARCHAR2
931: , p4_a0 JTF_NUMBER_TABLE
932: , p4_a1 JTF_NUMBER_TABLE
933: , p4_a2 JTF_DATE_TABLE
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
932: , p4_a1 JTF_NUMBER_TABLE
933: , p4_a2 JTF_DATE_TABLE
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
939: , p4_a8 JTF_NUMBER_TABLE
940: , p4_a9 JTF_NUMBER_TABLE
933: , p4_a2 JTF_DATE_TABLE
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
939: , p4_a8 JTF_NUMBER_TABLE
940: , p4_a9 JTF_NUMBER_TABLE
941: , p4_a10 JTF_VARCHAR2_TABLE_100
934: , p4_a3 JTF_NUMBER_TABLE
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
939: , p4_a8 JTF_NUMBER_TABLE
940: , p4_a9 JTF_NUMBER_TABLE
941: , p4_a10 JTF_VARCHAR2_TABLE_100
942: , p4_a11 JTF_VARCHAR2_TABLE_300
935: , p4_a4 JTF_DATE_TABLE
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
939: , p4_a8 JTF_NUMBER_TABLE
940: , p4_a9 JTF_NUMBER_TABLE
941: , p4_a10 JTF_VARCHAR2_TABLE_100
942: , p4_a11 JTF_VARCHAR2_TABLE_300
943: , p4_a12 JTF_VARCHAR2_TABLE_300
936: , p4_a5 JTF_NUMBER_TABLE
937: , p4_a6 JTF_NUMBER_TABLE
938: , p4_a7 JTF_NUMBER_TABLE
939: , p4_a8 JTF_NUMBER_TABLE
940: , p4_a9 JTF_NUMBER_TABLE
941: , p4_a10 JTF_VARCHAR2_TABLE_100
942: , p4_a11 JTF_VARCHAR2_TABLE_300
943: , p4_a12 JTF_VARCHAR2_TABLE_300
944: , p4_a13 JTF_VARCHAR2_TABLE_300
959: , p4_a28 JTF_VARCHAR2_TABLE_200
960: , p4_a29 JTF_VARCHAR2_TABLE_200
961: , p4_a30 JTF_VARCHAR2_TABLE_200
962: , p4_a31 JTF_VARCHAR2_TABLE_200
963: , p4_a32 JTF_NUMBER_TABLE
964: , x_return_status out nocopy VARCHAR2
965: , x_msg_count out nocopy NUMBER
966: , x_msg_data out nocopy VARCHAR2
967: )
1040: , p_validation_level NUMBER
1041: , x_return_status out nocopy VARCHAR2
1042: , x_msg_count out nocopy NUMBER
1043: , x_msg_data out nocopy VARCHAR2
1044: , p7_a0 JTF_NUMBER_TABLE
1045: , p7_a1 JTF_NUMBER_TABLE
1046: , p7_a2 JTF_DATE_TABLE
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1041: , x_return_status out nocopy VARCHAR2
1042: , x_msg_count out nocopy NUMBER
1043: , x_msg_data out nocopy VARCHAR2
1044: , p7_a0 JTF_NUMBER_TABLE
1045: , p7_a1 JTF_NUMBER_TABLE
1046: , p7_a2 JTF_DATE_TABLE
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1043: , x_msg_data out nocopy VARCHAR2
1044: , p7_a0 JTF_NUMBER_TABLE
1045: , p7_a1 JTF_NUMBER_TABLE
1046: , p7_a2 JTF_DATE_TABLE
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1050: , p7_a6 JTF_NUMBER_TABLE
1051: , p7_a7 JTF_NUMBER_TABLE
1045: , p7_a1 JTF_NUMBER_TABLE
1046: , p7_a2 JTF_DATE_TABLE
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1050: , p7_a6 JTF_NUMBER_TABLE
1051: , p7_a7 JTF_NUMBER_TABLE
1052: , p7_a8 JTF_NUMBER_TABLE
1053: , p7_a9 JTF_VARCHAR2_TABLE_100
1046: , p7_a2 JTF_DATE_TABLE
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1050: , p7_a6 JTF_NUMBER_TABLE
1051: , p7_a7 JTF_NUMBER_TABLE
1052: , p7_a8 JTF_NUMBER_TABLE
1053: , p7_a9 JTF_VARCHAR2_TABLE_100
1054: , p7_a10 JTF_VARCHAR2_TABLE_300
1047: , p7_a3 JTF_NUMBER_TABLE
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1050: , p7_a6 JTF_NUMBER_TABLE
1051: , p7_a7 JTF_NUMBER_TABLE
1052: , p7_a8 JTF_NUMBER_TABLE
1053: , p7_a9 JTF_VARCHAR2_TABLE_100
1054: , p7_a10 JTF_VARCHAR2_TABLE_300
1055: , p7_a11 JTF_VARCHAR2_TABLE_300
1048: , p7_a4 JTF_DATE_TABLE
1049: , p7_a5 JTF_NUMBER_TABLE
1050: , p7_a6 JTF_NUMBER_TABLE
1051: , p7_a7 JTF_NUMBER_TABLE
1052: , p7_a8 JTF_NUMBER_TABLE
1053: , p7_a9 JTF_VARCHAR2_TABLE_100
1054: , p7_a10 JTF_VARCHAR2_TABLE_300
1055: , p7_a11 JTF_VARCHAR2_TABLE_300
1056: , p7_a12 JTF_VARCHAR2_TABLE_300
1071: , p7_a27 JTF_VARCHAR2_TABLE_200
1072: , p7_a28 JTF_VARCHAR2_TABLE_200
1073: , p7_a29 JTF_VARCHAR2_TABLE_200
1074: , p7_a30 JTF_VARCHAR2_TABLE_200
1075: , p7_a31 JTF_NUMBER_TABLE
1076: )
1077:
1078: as
1079: ddp_supp_code_conversion_tbl ozf_code_conversion_pvt.supp_code_conversion_tbl_type;
1148: , p_validation_level NUMBER
1149: , x_return_status out nocopy VARCHAR2
1150: , x_msg_count out nocopy NUMBER
1151: , x_msg_data out nocopy VARCHAR2
1152: , p7_a0 JTF_NUMBER_TABLE
1153: , p7_a1 JTF_NUMBER_TABLE
1154: , p7_a2 JTF_DATE_TABLE
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1149: , x_return_status out nocopy VARCHAR2
1150: , x_msg_count out nocopy NUMBER
1151: , x_msg_data out nocopy VARCHAR2
1152: , p7_a0 JTF_NUMBER_TABLE
1153: , p7_a1 JTF_NUMBER_TABLE
1154: , p7_a2 JTF_DATE_TABLE
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1151: , x_msg_data out nocopy VARCHAR2
1152: , p7_a0 JTF_NUMBER_TABLE
1153: , p7_a1 JTF_NUMBER_TABLE
1154: , p7_a2 JTF_DATE_TABLE
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1158: , p7_a6 JTF_NUMBER_TABLE
1159: , p7_a7 JTF_NUMBER_TABLE
1153: , p7_a1 JTF_NUMBER_TABLE
1154: , p7_a2 JTF_DATE_TABLE
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1158: , p7_a6 JTF_NUMBER_TABLE
1159: , p7_a7 JTF_NUMBER_TABLE
1160: , p7_a8 JTF_NUMBER_TABLE
1161: , p7_a9 JTF_VARCHAR2_TABLE_100
1154: , p7_a2 JTF_DATE_TABLE
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1158: , p7_a6 JTF_NUMBER_TABLE
1159: , p7_a7 JTF_NUMBER_TABLE
1160: , p7_a8 JTF_NUMBER_TABLE
1161: , p7_a9 JTF_VARCHAR2_TABLE_100
1162: , p7_a10 JTF_VARCHAR2_TABLE_300
1155: , p7_a3 JTF_NUMBER_TABLE
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1158: , p7_a6 JTF_NUMBER_TABLE
1159: , p7_a7 JTF_NUMBER_TABLE
1160: , p7_a8 JTF_NUMBER_TABLE
1161: , p7_a9 JTF_VARCHAR2_TABLE_100
1162: , p7_a10 JTF_VARCHAR2_TABLE_300
1163: , p7_a11 JTF_VARCHAR2_TABLE_300
1156: , p7_a4 JTF_DATE_TABLE
1157: , p7_a5 JTF_NUMBER_TABLE
1158: , p7_a6 JTF_NUMBER_TABLE
1159: , p7_a7 JTF_NUMBER_TABLE
1160: , p7_a8 JTF_NUMBER_TABLE
1161: , p7_a9 JTF_VARCHAR2_TABLE_100
1162: , p7_a10 JTF_VARCHAR2_TABLE_300
1163: , p7_a11 JTF_VARCHAR2_TABLE_300
1164: , p7_a12 JTF_VARCHAR2_TABLE_300
1179: , p7_a27 JTF_VARCHAR2_TABLE_200
1180: , p7_a28 JTF_VARCHAR2_TABLE_200
1181: , p7_a29 JTF_VARCHAR2_TABLE_200
1182: , p7_a30 JTF_VARCHAR2_TABLE_200
1183: , p7_a31 JTF_NUMBER_TABLE
1184: )
1185:
1186: as
1187: ddp_supp_code_conversion_tbl ozf_code_conversion_pvt.supp_code_conversion_tbl_type;