[Home] [Help]
11: end;
12:
13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
12:
13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
20: , a7 JTF_VARCHAR2_TABLE_2000
13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_DATE_TABLE
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_DATE_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then
54: end if;
55: end rosetta_table_copy_in_p19;
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
55: end rosetta_table_copy_in_p19;
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a8 out nocopy JTF_DATE_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_DATE_TABLE
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_DATE_TABLE
66: , a10 out nocopy JTF_DATE_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_200();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_200();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
80: a7 := JTF_VARCHAR2_TABLE_2000();
73: a0 := JTF_VARCHAR2_TABLE_200();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_DATE_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_DATE_TABLE();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_DATE_TABLE();
83: a10 := JTF_DATE_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
86: else
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
94: a7 := JTF_VARCHAR2_TABLE_2000();
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
94: a7 := JTF_VARCHAR2_TABLE_2000();
95: a8 := JTF_DATE_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
94: a7 := JTF_VARCHAR2_TABLE_2000();
95: a8 := JTF_DATE_TABLE();
96: a9 := JTF_DATE_TABLE();
95: a8 := JTF_DATE_TABLE();
96: a9 := JTF_DATE_TABLE();
97: a10 := JTF_DATE_TABLE();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then
101: a0.extend(t.count);
102: a1.extend(t.count);
103: a2.extend(t.count);
180: end if;
181: end rosetta_table_copy_out_p21;
182:
183: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
184: , a1 JTF_VARCHAR2_TABLE_100
185: , a2 JTF_VARCHAR2_TABLE_300
186: , a3 JTF_VARCHAR2_TABLE_300
187: ) as
188: ddindx binary_integer; indx binary_integer;
205: end if;
206: end if;
207: end rosetta_table_copy_in_p23;
208: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_300
211: , a3 out nocopy JTF_VARCHAR2_TABLE_300
212: ) as
213: ddindx binary_integer; indx binary_integer;
213: ddindx binary_integer; indx binary_integer;
214: begin
215: if t is null or t.count = 0 then
216: a0 := JTF_NUMBER_TABLE();
217: a1 := JTF_VARCHAR2_TABLE_100();
218: a2 := JTF_VARCHAR2_TABLE_300();
219: a3 := JTF_VARCHAR2_TABLE_300();
220: else
221: a0 := JTF_NUMBER_TABLE();
218: a2 := JTF_VARCHAR2_TABLE_300();
219: a3 := JTF_VARCHAR2_TABLE_300();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_300();
224: a3 := JTF_VARCHAR2_TABLE_300();
225: if t.count > 0 then
226: a0.extend(t.count);
308: end if;
309: end rosetta_table_copy_out_p25;
310:
311: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
312: , a1 JTF_VARCHAR2_TABLE_100
313: , a2 JTF_VARCHAR2_TABLE_300
314: , a3 JTF_VARCHAR2_TABLE_300
315: ) as
316: ddindx binary_integer; indx binary_integer;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p27;
336: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_300
339: , a3 out nocopy JTF_VARCHAR2_TABLE_300
340: ) as
341: ddindx binary_integer; indx binary_integer;
341: ddindx binary_integer; indx binary_integer;
342: begin
343: if t is null or t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_300();
347: a3 := JTF_VARCHAR2_TABLE_300();
348: else
349: a0 := JTF_NUMBER_TABLE();
346: a2 := JTF_VARCHAR2_TABLE_300();
347: a3 := JTF_VARCHAR2_TABLE_300();
348: else
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_VARCHAR2_TABLE_100();
351: a2 := JTF_VARCHAR2_TABLE_300();
352: a3 := JTF_VARCHAR2_TABLE_300();
353: if t.count > 0 then
354: a0.extend(t.count);
372: end if;
373: end rosetta_table_copy_out_p27;
374:
375: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_VARCHAR2_TABLE_100
377: , a2 JTF_VARCHAR2_TABLE_300
378: , a3 JTF_VARCHAR2_TABLE_300
379: ) as
380: ddindx binary_integer; indx binary_integer;
397: end if;
398: end if;
399: end rosetta_table_copy_in_p29;
400: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
401: , a1 out nocopy JTF_VARCHAR2_TABLE_100
402: , a2 out nocopy JTF_VARCHAR2_TABLE_300
403: , a3 out nocopy JTF_VARCHAR2_TABLE_300
404: ) as
405: ddindx binary_integer; indx binary_integer;
405: ddindx binary_integer; indx binary_integer;
406: begin
407: if t is null or t.count = 0 then
408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_VARCHAR2_TABLE_100();
410: a2 := JTF_VARCHAR2_TABLE_300();
411: a3 := JTF_VARCHAR2_TABLE_300();
412: else
413: a0 := JTF_NUMBER_TABLE();
410: a2 := JTF_VARCHAR2_TABLE_300();
411: a3 := JTF_VARCHAR2_TABLE_300();
412: else
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_100();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then
418: a0.extend(t.count);
435: end if;
436: end if;
437: end rosetta_table_copy_out_p29;
438:
439: procedure rosetta_table_copy_in_p31(t out nocopy oks_entitlements_web.contract_cat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
440: , a1 JTF_VARCHAR2_TABLE_100
441: ) as
442: ddindx binary_integer; indx binary_integer;
443: begin
436: end if;
437: end rosetta_table_copy_out_p29;
438:
439: procedure rosetta_table_copy_in_p31(t out nocopy oks_entitlements_web.contract_cat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
440: , a1 JTF_VARCHAR2_TABLE_100
441: ) as
442: ddindx binary_integer; indx binary_integer;
443: begin
444: if a0 is not null and a0.count > 0 then
456: end loop;
457: end if;
458: end if;
459: end rosetta_table_copy_in_p31;
460: procedure rosetta_table_copy_out_p31(t oks_entitlements_web.contract_cat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
461: , a1 out nocopy JTF_VARCHAR2_TABLE_100
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
457: end if;
458: end if;
459: end rosetta_table_copy_in_p31;
460: procedure rosetta_table_copy_out_p31(t oks_entitlements_web.contract_cat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
461: , a1 out nocopy JTF_VARCHAR2_TABLE_100
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null or t.count = 0 then
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null or t.count = 0 then
466: a0 := JTF_VARCHAR2_TABLE_100();
467: a1 := JTF_VARCHAR2_TABLE_100();
468: else
469: a0 := JTF_VARCHAR2_TABLE_100();
470: a1 := JTF_VARCHAR2_TABLE_100();
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null or t.count = 0 then
466: a0 := JTF_VARCHAR2_TABLE_100();
467: a1 := JTF_VARCHAR2_TABLE_100();
468: else
469: a0 := JTF_VARCHAR2_TABLE_100();
470: a1 := JTF_VARCHAR2_TABLE_100();
471: if t.count > 0 then
465: if t is null or t.count = 0 then
466: a0 := JTF_VARCHAR2_TABLE_100();
467: a1 := JTF_VARCHAR2_TABLE_100();
468: else
469: a0 := JTF_VARCHAR2_TABLE_100();
470: a1 := JTF_VARCHAR2_TABLE_100();
471: if t.count > 0 then
472: a0.extend(t.count);
473: a1.extend(t.count);
466: a0 := JTF_VARCHAR2_TABLE_100();
467: a1 := JTF_VARCHAR2_TABLE_100();
468: else
469: a0 := JTF_VARCHAR2_TABLE_100();
470: a1 := JTF_VARCHAR2_TABLE_100();
471: if t.count > 0 then
472: a0.extend(t.count);
473: a1.extend(t.count);
474: ddindx := t.first;
485: end if;
486: end if;
487: end rosetta_table_copy_out_p31;
488:
489: procedure rosetta_table_copy_in_p33(t out nocopy oks_entitlements_web.contract_status_tbl_type, a0 JTF_VARCHAR2_TABLE_100
490: , a1 JTF_VARCHAR2_TABLE_100
491: ) as
492: ddindx binary_integer; indx binary_integer;
493: begin
486: end if;
487: end rosetta_table_copy_out_p31;
488:
489: procedure rosetta_table_copy_in_p33(t out nocopy oks_entitlements_web.contract_status_tbl_type, a0 JTF_VARCHAR2_TABLE_100
490: , a1 JTF_VARCHAR2_TABLE_100
491: ) as
492: ddindx binary_integer; indx binary_integer;
493: begin
494: if a0 is not null and a0.count > 0 then
506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p33;
510: procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin
507: end if;
508: end if;
509: end rosetta_table_copy_in_p33;
510: procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin
515: if t is null or t.count = 0 then
512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin
515: if t is null or t.count = 0 then
516: a0 := JTF_VARCHAR2_TABLE_100();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: else
519: a0 := JTF_VARCHAR2_TABLE_100();
520: a1 := JTF_VARCHAR2_TABLE_100();
513: ddindx binary_integer; indx binary_integer;
514: begin
515: if t is null or t.count = 0 then
516: a0 := JTF_VARCHAR2_TABLE_100();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: else
519: a0 := JTF_VARCHAR2_TABLE_100();
520: a1 := JTF_VARCHAR2_TABLE_100();
521: if t.count > 0 then
515: if t is null or t.count = 0 then
516: a0 := JTF_VARCHAR2_TABLE_100();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: else
519: a0 := JTF_VARCHAR2_TABLE_100();
520: a1 := JTF_VARCHAR2_TABLE_100();
521: if t.count > 0 then
522: a0.extend(t.count);
523: a1.extend(t.count);
516: a0 := JTF_VARCHAR2_TABLE_100();
517: a1 := JTF_VARCHAR2_TABLE_100();
518: else
519: a0 := JTF_VARCHAR2_TABLE_100();
520: a1 := JTF_VARCHAR2_TABLE_100();
521: if t.count > 0 then
522: a0.extend(t.count);
523: a1.extend(t.count);
524: ddindx := t.first;
536: end if;
537: end rosetta_table_copy_out_p33;
538:
539: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
540: , a1 JTF_VARCHAR2_TABLE_100
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100
544: , a5 JTF_VARCHAR2_TABLE_100
537: end rosetta_table_copy_out_p33;
538:
539: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
540: , a1 JTF_VARCHAR2_TABLE_100
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100
544: , a5 JTF_VARCHAR2_TABLE_100
545: , a6 JTF_VARCHAR2_TABLE_100
539: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
540: , a1 JTF_VARCHAR2_TABLE_100
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100
544: , a5 JTF_VARCHAR2_TABLE_100
545: , a6 JTF_VARCHAR2_TABLE_100
546: ) as
547: ddindx binary_integer; indx binary_integer;
540: , a1 JTF_VARCHAR2_TABLE_100
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100
544: , a5 JTF_VARCHAR2_TABLE_100
545: , a6 JTF_VARCHAR2_TABLE_100
546: ) as
547: ddindx binary_integer; indx binary_integer;
548: begin
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100
544: , a5 JTF_VARCHAR2_TABLE_100
545: , a6 JTF_VARCHAR2_TABLE_100
546: ) as
547: ddindx binary_integer; indx binary_integer;
548: begin
549: if a0 is not null and a0.count > 0 then
567: end if;
568: end if;
569: end rosetta_table_copy_in_p37;
570: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
568: end if;
569: end rosetta_table_copy_in_p37;
570: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
570: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: ) as
578: ddindx binary_integer; indx binary_integer;
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: ) as
578: ddindx binary_integer; indx binary_integer;
579: begin
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100
575: , a5 out nocopy JTF_VARCHAR2_TABLE_100
576: , a6 out nocopy JTF_VARCHAR2_TABLE_100
577: ) as
578: ddindx binary_integer; indx binary_integer;
579: begin
580: if t is null or t.count = 0 then
578: ddindx binary_integer; indx binary_integer;
579: begin
580: if t is null or t.count = 0 then
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_VARCHAR2_TABLE_100();
583: a2 := JTF_VARCHAR2_TABLE_100();
584: a3 := JTF_VARCHAR2_TABLE_400();
585: a4 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
579: begin
580: if t is null or t.count = 0 then
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_VARCHAR2_TABLE_100();
583: a2 := JTF_VARCHAR2_TABLE_100();
584: a3 := JTF_VARCHAR2_TABLE_400();
585: a4 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
581: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_VARCHAR2_TABLE_100();
583: a2 := JTF_VARCHAR2_TABLE_100();
584: a3 := JTF_VARCHAR2_TABLE_400();
585: a4 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
588: else
589: a0 := JTF_NUMBER_TABLE();
582: a1 := JTF_VARCHAR2_TABLE_100();
583: a2 := JTF_VARCHAR2_TABLE_100();
584: a3 := JTF_VARCHAR2_TABLE_400();
585: a4 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_VARCHAR2_TABLE_100();
583: a2 := JTF_VARCHAR2_TABLE_100();
584: a3 := JTF_VARCHAR2_TABLE_400();
585: a4 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_VARCHAR2_TABLE_100();
586: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_VARCHAR2_TABLE_100();
592: a3 := JTF_VARCHAR2_TABLE_400();
593: a4 := JTF_VARCHAR2_TABLE_100();
594: a5 := JTF_VARCHAR2_TABLE_100();
587: a6 := JTF_VARCHAR2_TABLE_100();
588: else
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_VARCHAR2_TABLE_100();
592: a3 := JTF_VARCHAR2_TABLE_400();
593: a4 := JTF_VARCHAR2_TABLE_100();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_VARCHAR2_TABLE_100();
589: a0 := JTF_NUMBER_TABLE();
590: a1 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_VARCHAR2_TABLE_100();
592: a3 := JTF_VARCHAR2_TABLE_400();
593: a4 := JTF_VARCHAR2_TABLE_100();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_VARCHAR2_TABLE_100();
596: if t.count > 0 then
597: a0.extend(t.count);
590: a1 := JTF_VARCHAR2_TABLE_100();
591: a2 := JTF_VARCHAR2_TABLE_100();
592: a3 := JTF_VARCHAR2_TABLE_400();
593: a4 := JTF_VARCHAR2_TABLE_100();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_VARCHAR2_TABLE_100();
596: if t.count > 0 then
597: a0.extend(t.count);
598: a1.extend(t.count);
591: a2 := JTF_VARCHAR2_TABLE_100();
592: a3 := JTF_VARCHAR2_TABLE_400();
593: a4 := JTF_VARCHAR2_TABLE_100();
594: a5 := JTF_VARCHAR2_TABLE_100();
595: a6 := JTF_VARCHAR2_TABLE_100();
596: if t.count > 0 then
597: a0.extend(t.count);
598: a1.extend(t.count);
599: a2.extend(t.count);
624: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE
625: , a1 JTF_NUMBER_TABLE
626: , a2 JTF_DATE_TABLE
627: , a3 JTF_DATE_TABLE
628: , a4 JTF_VARCHAR2_TABLE_100
629: , a5 JTF_VARCHAR2_TABLE_100
630: , a6 JTF_VARCHAR2_TABLE_200
631: , a7 JTF_VARCHAR2_TABLE_300
632: , a8 JTF_VARCHAR2_TABLE_500
625: , a1 JTF_NUMBER_TABLE
626: , a2 JTF_DATE_TABLE
627: , a3 JTF_DATE_TABLE
628: , a4 JTF_VARCHAR2_TABLE_100
629: , a5 JTF_VARCHAR2_TABLE_100
630: , a6 JTF_VARCHAR2_TABLE_200
631: , a7 JTF_VARCHAR2_TABLE_300
632: , a8 JTF_VARCHAR2_TABLE_500
633: , a9 JTF_VARCHAR2_TABLE_500
636: , a12 JTF_VARCHAR2_TABLE_400
637: , a13 JTF_NUMBER_TABLE
638: , a14 JTF_NUMBER_TABLE
639: , a15 JTF_VARCHAR2_TABLE_200
640: , a16 JTF_VARCHAR2_TABLE_100
641: , a17 JTF_VARCHAR2_TABLE_400
642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
639: , a15 JTF_VARCHAR2_TABLE_200
640: , a16 JTF_VARCHAR2_TABLE_100
641: , a17 JTF_VARCHAR2_TABLE_400
642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
645: , a21 JTF_VARCHAR2_TABLE_400
646: , a22 JTF_VARCHAR2_TABLE_300
647: , a23 JTF_VARCHAR2_TABLE_100
640: , a16 JTF_VARCHAR2_TABLE_100
641: , a17 JTF_VARCHAR2_TABLE_400
642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
645: , a21 JTF_VARCHAR2_TABLE_400
646: , a22 JTF_VARCHAR2_TABLE_300
647: , a23 JTF_VARCHAR2_TABLE_100
648: ) as
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
645: , a21 JTF_VARCHAR2_TABLE_400
646: , a22 JTF_VARCHAR2_TABLE_300
647: , a23 JTF_VARCHAR2_TABLE_100
648: ) as
649: ddindx binary_integer; indx binary_integer;
650: begin
651: if a0 is not null and a0.count > 0 then
689: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_DATE_TABLE
692: , a3 out nocopy JTF_DATE_TABLE
693: , a4 out nocopy JTF_VARCHAR2_TABLE_100
694: , a5 out nocopy JTF_VARCHAR2_TABLE_100
695: , a6 out nocopy JTF_VARCHAR2_TABLE_200
696: , a7 out nocopy JTF_VARCHAR2_TABLE_300
697: , a8 out nocopy JTF_VARCHAR2_TABLE_500
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_DATE_TABLE
692: , a3 out nocopy JTF_DATE_TABLE
693: , a4 out nocopy JTF_VARCHAR2_TABLE_100
694: , a5 out nocopy JTF_VARCHAR2_TABLE_100
695: , a6 out nocopy JTF_VARCHAR2_TABLE_200
696: , a7 out nocopy JTF_VARCHAR2_TABLE_300
697: , a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , a9 out nocopy JTF_VARCHAR2_TABLE_500
701: , a12 out nocopy JTF_VARCHAR2_TABLE_400
702: , a13 out nocopy JTF_NUMBER_TABLE
703: , a14 out nocopy JTF_NUMBER_TABLE
704: , a15 out nocopy JTF_VARCHAR2_TABLE_200
705: , a16 out nocopy JTF_VARCHAR2_TABLE_100
706: , a17 out nocopy JTF_VARCHAR2_TABLE_400
707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
704: , a15 out nocopy JTF_VARCHAR2_TABLE_200
705: , a16 out nocopy JTF_VARCHAR2_TABLE_100
706: , a17 out nocopy JTF_VARCHAR2_TABLE_400
707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
710: , a21 out nocopy JTF_VARCHAR2_TABLE_400
711: , a22 out nocopy JTF_VARCHAR2_TABLE_300
712: , a23 out nocopy JTF_VARCHAR2_TABLE_100
705: , a16 out nocopy JTF_VARCHAR2_TABLE_100
706: , a17 out nocopy JTF_VARCHAR2_TABLE_400
707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
710: , a21 out nocopy JTF_VARCHAR2_TABLE_400
711: , a22 out nocopy JTF_VARCHAR2_TABLE_300
712: , a23 out nocopy JTF_VARCHAR2_TABLE_100
713: ) as
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
710: , a21 out nocopy JTF_VARCHAR2_TABLE_400
711: , a22 out nocopy JTF_VARCHAR2_TABLE_300
712: , a23 out nocopy JTF_VARCHAR2_TABLE_100
713: ) as
714: ddindx binary_integer; indx binary_integer;
715: begin
716: if t is null or t.count = 0 then
717: a0 := JTF_NUMBER_TABLE();
718: a1 := JTF_NUMBER_TABLE();
719: a2 := JTF_DATE_TABLE();
720: a3 := JTF_DATE_TABLE();
721: a4 := JTF_VARCHAR2_TABLE_100();
722: a5 := JTF_VARCHAR2_TABLE_100();
723: a6 := JTF_VARCHAR2_TABLE_200();
724: a7 := JTF_VARCHAR2_TABLE_300();
725: a8 := JTF_VARCHAR2_TABLE_500();
718: a1 := JTF_NUMBER_TABLE();
719: a2 := JTF_DATE_TABLE();
720: a3 := JTF_DATE_TABLE();
721: a4 := JTF_VARCHAR2_TABLE_100();
722: a5 := JTF_VARCHAR2_TABLE_100();
723: a6 := JTF_VARCHAR2_TABLE_200();
724: a7 := JTF_VARCHAR2_TABLE_300();
725: a8 := JTF_VARCHAR2_TABLE_500();
726: a9 := JTF_VARCHAR2_TABLE_500();
729: a12 := JTF_VARCHAR2_TABLE_400();
730: a13 := JTF_NUMBER_TABLE();
731: a14 := JTF_NUMBER_TABLE();
732: a15 := JTF_VARCHAR2_TABLE_200();
733: a16 := JTF_VARCHAR2_TABLE_100();
734: a17 := JTF_VARCHAR2_TABLE_400();
735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
732: a15 := JTF_VARCHAR2_TABLE_200();
733: a16 := JTF_VARCHAR2_TABLE_100();
734: a17 := JTF_VARCHAR2_TABLE_400();
735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
738: a21 := JTF_VARCHAR2_TABLE_400();
739: a22 := JTF_VARCHAR2_TABLE_300();
740: a23 := JTF_VARCHAR2_TABLE_100();
733: a16 := JTF_VARCHAR2_TABLE_100();
734: a17 := JTF_VARCHAR2_TABLE_400();
735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
738: a21 := JTF_VARCHAR2_TABLE_400();
739: a22 := JTF_VARCHAR2_TABLE_300();
740: a23 := JTF_VARCHAR2_TABLE_100();
741: else
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
738: a21 := JTF_VARCHAR2_TABLE_400();
739: a22 := JTF_VARCHAR2_TABLE_300();
740: a23 := JTF_VARCHAR2_TABLE_100();
741: else
742: a0 := JTF_NUMBER_TABLE();
743: a1 := JTF_NUMBER_TABLE();
744: a2 := JTF_DATE_TABLE();
742: a0 := JTF_NUMBER_TABLE();
743: a1 := JTF_NUMBER_TABLE();
744: a2 := JTF_DATE_TABLE();
745: a3 := JTF_DATE_TABLE();
746: a4 := JTF_VARCHAR2_TABLE_100();
747: a5 := JTF_VARCHAR2_TABLE_100();
748: a6 := JTF_VARCHAR2_TABLE_200();
749: a7 := JTF_VARCHAR2_TABLE_300();
750: a8 := JTF_VARCHAR2_TABLE_500();
743: a1 := JTF_NUMBER_TABLE();
744: a2 := JTF_DATE_TABLE();
745: a3 := JTF_DATE_TABLE();
746: a4 := JTF_VARCHAR2_TABLE_100();
747: a5 := JTF_VARCHAR2_TABLE_100();
748: a6 := JTF_VARCHAR2_TABLE_200();
749: a7 := JTF_VARCHAR2_TABLE_300();
750: a8 := JTF_VARCHAR2_TABLE_500();
751: a9 := JTF_VARCHAR2_TABLE_500();
754: a12 := JTF_VARCHAR2_TABLE_400();
755: a13 := JTF_NUMBER_TABLE();
756: a14 := JTF_NUMBER_TABLE();
757: a15 := JTF_VARCHAR2_TABLE_200();
758: a16 := JTF_VARCHAR2_TABLE_100();
759: a17 := JTF_VARCHAR2_TABLE_400();
760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
757: a15 := JTF_VARCHAR2_TABLE_200();
758: a16 := JTF_VARCHAR2_TABLE_100();
759: a17 := JTF_VARCHAR2_TABLE_400();
760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
763: a21 := JTF_VARCHAR2_TABLE_400();
764: a22 := JTF_VARCHAR2_TABLE_300();
765: a23 := JTF_VARCHAR2_TABLE_100();
758: a16 := JTF_VARCHAR2_TABLE_100();
759: a17 := JTF_VARCHAR2_TABLE_400();
760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
763: a21 := JTF_VARCHAR2_TABLE_400();
764: a22 := JTF_VARCHAR2_TABLE_300();
765: a23 := JTF_VARCHAR2_TABLE_100();
766: if t.count > 0 then
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
763: a21 := JTF_VARCHAR2_TABLE_400();
764: a22 := JTF_VARCHAR2_TABLE_300();
765: a23 := JTF_VARCHAR2_TABLE_100();
766: if t.count > 0 then
767: a0.extend(t.count);
768: a1.extend(t.count);
769: a2.extend(t.count);
825: end if;
826: end rosetta_table_copy_out_p39;
827:
828: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
829: , a1 JTF_VARCHAR2_TABLE_100
830: , a2 JTF_VARCHAR2_TABLE_100
831: , a3 JTF_VARCHAR2_TABLE_100
832: , a4 JTF_DATE_TABLE
833: , a5 JTF_DATE_TABLE
826: end rosetta_table_copy_out_p39;
827:
828: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
829: , a1 JTF_VARCHAR2_TABLE_100
830: , a2 JTF_VARCHAR2_TABLE_100
831: , a3 JTF_VARCHAR2_TABLE_100
832: , a4 JTF_DATE_TABLE
833: , a5 JTF_DATE_TABLE
834: , a6 JTF_VARCHAR2_TABLE_400
827:
828: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
829: , a1 JTF_VARCHAR2_TABLE_100
830: , a2 JTF_VARCHAR2_TABLE_100
831: , a3 JTF_VARCHAR2_TABLE_100
832: , a4 JTF_DATE_TABLE
833: , a5 JTF_DATE_TABLE
834: , a6 JTF_VARCHAR2_TABLE_400
835: , a7 JTF_VARCHAR2_TABLE_100
831: , a3 JTF_VARCHAR2_TABLE_100
832: , a4 JTF_DATE_TABLE
833: , a5 JTF_DATE_TABLE
834: , a6 JTF_VARCHAR2_TABLE_400
835: , a7 JTF_VARCHAR2_TABLE_100
836: , a8 JTF_VARCHAR2_TABLE_100
837: ) as
838: ddindx binary_integer; indx binary_integer;
839: begin
832: , a4 JTF_DATE_TABLE
833: , a5 JTF_DATE_TABLE
834: , a6 JTF_VARCHAR2_TABLE_400
835: , a7 JTF_VARCHAR2_TABLE_100
836: , a8 JTF_VARCHAR2_TABLE_100
837: ) as
838: ddindx binary_integer; indx binary_integer;
839: begin
840: if a0 is not null and a0.count > 0 then
860: end if;
861: end if;
862: end rosetta_table_copy_in_p41;
863: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
864: , a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , a4 out nocopy JTF_DATE_TABLE
868: , a5 out nocopy JTF_DATE_TABLE
861: end if;
862: end rosetta_table_copy_in_p41;
863: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
864: , a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , a4 out nocopy JTF_DATE_TABLE
868: , a5 out nocopy JTF_DATE_TABLE
869: , a6 out nocopy JTF_VARCHAR2_TABLE_400
862: end rosetta_table_copy_in_p41;
863: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
864: , a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , a4 out nocopy JTF_DATE_TABLE
868: , a5 out nocopy JTF_DATE_TABLE
869: , a6 out nocopy JTF_VARCHAR2_TABLE_400
870: , a7 out nocopy JTF_VARCHAR2_TABLE_100
866: , a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , a4 out nocopy JTF_DATE_TABLE
868: , a5 out nocopy JTF_DATE_TABLE
869: , a6 out nocopy JTF_VARCHAR2_TABLE_400
870: , a7 out nocopy JTF_VARCHAR2_TABLE_100
871: , a8 out nocopy JTF_VARCHAR2_TABLE_100
872: ) as
873: ddindx binary_integer; indx binary_integer;
874: begin
867: , a4 out nocopy JTF_DATE_TABLE
868: , a5 out nocopy JTF_DATE_TABLE
869: , a6 out nocopy JTF_VARCHAR2_TABLE_400
870: , a7 out nocopy JTF_VARCHAR2_TABLE_100
871: , a8 out nocopy JTF_VARCHAR2_TABLE_100
872: ) as
873: ddindx binary_integer; indx binary_integer;
874: begin
875: if t is null or t.count = 0 then
873: ddindx binary_integer; indx binary_integer;
874: begin
875: if t is null or t.count = 0 then
876: a0 := JTF_NUMBER_TABLE();
877: a1 := JTF_VARCHAR2_TABLE_100();
878: a2 := JTF_VARCHAR2_TABLE_100();
879: a3 := JTF_VARCHAR2_TABLE_100();
880: a4 := JTF_DATE_TABLE();
881: a5 := JTF_DATE_TABLE();
874: begin
875: if t is null or t.count = 0 then
876: a0 := JTF_NUMBER_TABLE();
877: a1 := JTF_VARCHAR2_TABLE_100();
878: a2 := JTF_VARCHAR2_TABLE_100();
879: a3 := JTF_VARCHAR2_TABLE_100();
880: a4 := JTF_DATE_TABLE();
881: a5 := JTF_DATE_TABLE();
882: a6 := JTF_VARCHAR2_TABLE_400();
875: if t is null or t.count = 0 then
876: a0 := JTF_NUMBER_TABLE();
877: a1 := JTF_VARCHAR2_TABLE_100();
878: a2 := JTF_VARCHAR2_TABLE_100();
879: a3 := JTF_VARCHAR2_TABLE_100();
880: a4 := JTF_DATE_TABLE();
881: a5 := JTF_DATE_TABLE();
882: a6 := JTF_VARCHAR2_TABLE_400();
883: a7 := JTF_VARCHAR2_TABLE_100();
879: a3 := JTF_VARCHAR2_TABLE_100();
880: a4 := JTF_DATE_TABLE();
881: a5 := JTF_DATE_TABLE();
882: a6 := JTF_VARCHAR2_TABLE_400();
883: a7 := JTF_VARCHAR2_TABLE_100();
884: a8 := JTF_VARCHAR2_TABLE_100();
885: else
886: a0 := JTF_NUMBER_TABLE();
887: a1 := JTF_VARCHAR2_TABLE_100();
880: a4 := JTF_DATE_TABLE();
881: a5 := JTF_DATE_TABLE();
882: a6 := JTF_VARCHAR2_TABLE_400();
883: a7 := JTF_VARCHAR2_TABLE_100();
884: a8 := JTF_VARCHAR2_TABLE_100();
885: else
886: a0 := JTF_NUMBER_TABLE();
887: a1 := JTF_VARCHAR2_TABLE_100();
888: a2 := JTF_VARCHAR2_TABLE_100();
883: a7 := JTF_VARCHAR2_TABLE_100();
884: a8 := JTF_VARCHAR2_TABLE_100();
885: else
886: a0 := JTF_NUMBER_TABLE();
887: a1 := JTF_VARCHAR2_TABLE_100();
888: a2 := JTF_VARCHAR2_TABLE_100();
889: a3 := JTF_VARCHAR2_TABLE_100();
890: a4 := JTF_DATE_TABLE();
891: a5 := JTF_DATE_TABLE();
884: a8 := JTF_VARCHAR2_TABLE_100();
885: else
886: a0 := JTF_NUMBER_TABLE();
887: a1 := JTF_VARCHAR2_TABLE_100();
888: a2 := JTF_VARCHAR2_TABLE_100();
889: a3 := JTF_VARCHAR2_TABLE_100();
890: a4 := JTF_DATE_TABLE();
891: a5 := JTF_DATE_TABLE();
892: a6 := JTF_VARCHAR2_TABLE_400();
885: else
886: a0 := JTF_NUMBER_TABLE();
887: a1 := JTF_VARCHAR2_TABLE_100();
888: a2 := JTF_VARCHAR2_TABLE_100();
889: a3 := JTF_VARCHAR2_TABLE_100();
890: a4 := JTF_DATE_TABLE();
891: a5 := JTF_DATE_TABLE();
892: a6 := JTF_VARCHAR2_TABLE_400();
893: a7 := JTF_VARCHAR2_TABLE_100();
889: a3 := JTF_VARCHAR2_TABLE_100();
890: a4 := JTF_DATE_TABLE();
891: a5 := JTF_DATE_TABLE();
892: a6 := JTF_VARCHAR2_TABLE_400();
893: a7 := JTF_VARCHAR2_TABLE_100();
894: a8 := JTF_VARCHAR2_TABLE_100();
895: if t.count > 0 then
896: a0.extend(t.count);
897: a1.extend(t.count);
890: a4 := JTF_DATE_TABLE();
891: a5 := JTF_DATE_TABLE();
892: a6 := JTF_VARCHAR2_TABLE_400();
893: a7 := JTF_VARCHAR2_TABLE_100();
894: a8 := JTF_VARCHAR2_TABLE_100();
895: if t.count > 0 then
896: a0.extend(t.count);
897: a1.extend(t.count);
898: a2.extend(t.count);
923: end if;
924: end if;
925: end rosetta_table_copy_out_p41;
926:
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
924: end if;
925: end rosetta_table_copy_out_p41;
926:
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
926:
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100
934: , a7 JTF_VARCHAR2_TABLE_100
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100
934: , a7 JTF_VARCHAR2_TABLE_100
935: ) as
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100
934: , a7 JTF_VARCHAR2_TABLE_100
935: ) as
936: ddindx binary_integer; indx binary_integer;
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100
934: , a7 JTF_VARCHAR2_TABLE_100
935: ) as
936: ddindx binary_integer; indx binary_integer;
937: begin
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100
934: , a7 JTF_VARCHAR2_TABLE_100
935: ) as
936: ddindx binary_integer; indx binary_integer;
937: begin
938: if a0 is not null and a0.count > 0 then
956: end loop;
957: end if;
958: end if;
959: end rosetta_table_copy_in_p43;
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
957: end if;
958: end if;
959: end rosetta_table_copy_in_p43;
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
959: end rosetta_table_copy_in_p43;
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100
967: , a7 out nocopy JTF_VARCHAR2_TABLE_100
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100
967: , a7 out nocopy JTF_VARCHAR2_TABLE_100
968: ) as
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100
967: , a7 out nocopy JTF_VARCHAR2_TABLE_100
968: ) as
969: ddindx binary_integer; indx binary_integer;
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100
967: , a7 out nocopy JTF_VARCHAR2_TABLE_100
968: ) as
969: ddindx binary_integer; indx binary_integer;
970: begin
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100
967: , a7 out nocopy JTF_VARCHAR2_TABLE_100
968: ) as
969: ddindx binary_integer; indx binary_integer;
970: begin
971: if t is null or t.count = 0 then
968: ) as
969: ddindx binary_integer; indx binary_integer;
970: begin
971: if t is null or t.count = 0 then
972: a0 := JTF_VARCHAR2_TABLE_100();
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
969: ddindx binary_integer; indx binary_integer;
970: begin
971: if t is null or t.count = 0 then
972: a0 := JTF_VARCHAR2_TABLE_100();
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
971: if t is null or t.count = 0 then
972: a0 := JTF_VARCHAR2_TABLE_100();
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
972: a0 := JTF_VARCHAR2_TABLE_100();
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();
979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();
988: a7 := JTF_VARCHAR2_TABLE_100();
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();
988: a7 := JTF_VARCHAR2_TABLE_100();
989: if t.count > 0 then
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();
988: a7 := JTF_VARCHAR2_TABLE_100();
989: if t.count > 0 then
990: a0.extend(t.count);
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();
988: a7 := JTF_VARCHAR2_TABLE_100();
989: if t.count > 0 then
990: a0.extend(t.count);
991: a1.extend(t.count);
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();
988: a7 := JTF_VARCHAR2_TABLE_100();
989: if t.count > 0 then
990: a0.extend(t.count);
991: a1.extend(t.count);
992: a2.extend(t.count);
1263: end if;
1264: end if;
1265: end rosetta_table_copy_out_p51;
1266:
1267: procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1268: , a1 JTF_VARCHAR2_TABLE_100
1269: , a2 JTF_VARCHAR2_TABLE_100
1270: ) as
1271: ddindx binary_integer; indx binary_integer;
1264: end if;
1265: end rosetta_table_copy_out_p51;
1266:
1267: procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1268: , a1 JTF_VARCHAR2_TABLE_100
1269: , a2 JTF_VARCHAR2_TABLE_100
1270: ) as
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1265: end rosetta_table_copy_out_p51;
1266:
1267: procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1268: , a1 JTF_VARCHAR2_TABLE_100
1269: , a2 JTF_VARCHAR2_TABLE_100
1270: ) as
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1273: if a0 is not null and a0.count > 0 then
1286: end loop;
1287: end if;
1288: end if;
1289: end rosetta_table_copy_in_p54;
1290: procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1291: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1292: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1293: ) as
1294: ddindx binary_integer; indx binary_integer;
1287: end if;
1288: end if;
1289: end rosetta_table_copy_in_p54;
1290: procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1291: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1292: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1293: ) as
1294: ddindx binary_integer; indx binary_integer;
1295: begin
1288: end if;
1289: end rosetta_table_copy_in_p54;
1290: procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1291: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1292: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1293: ) as
1294: ddindx binary_integer; indx binary_integer;
1295: begin
1296: if t is null or t.count = 0 then
1293: ) as
1294: ddindx binary_integer; indx binary_integer;
1295: begin
1296: if t is null or t.count = 0 then
1297: a0 := JTF_VARCHAR2_TABLE_100();
1298: a1 := JTF_VARCHAR2_TABLE_100();
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1294: ddindx binary_integer; indx binary_integer;
1295: begin
1296: if t is null or t.count = 0 then
1297: a0 := JTF_VARCHAR2_TABLE_100();
1298: a1 := JTF_VARCHAR2_TABLE_100();
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1302: a1 := JTF_VARCHAR2_TABLE_100();
1295: begin
1296: if t is null or t.count = 0 then
1297: a0 := JTF_VARCHAR2_TABLE_100();
1298: a1 := JTF_VARCHAR2_TABLE_100();
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1302: a1 := JTF_VARCHAR2_TABLE_100();
1303: a2 := JTF_VARCHAR2_TABLE_100();
1297: a0 := JTF_VARCHAR2_TABLE_100();
1298: a1 := JTF_VARCHAR2_TABLE_100();
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1302: a1 := JTF_VARCHAR2_TABLE_100();
1303: a2 := JTF_VARCHAR2_TABLE_100();
1304: if t.count > 0 then
1305: a0.extend(t.count);
1298: a1 := JTF_VARCHAR2_TABLE_100();
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1302: a1 := JTF_VARCHAR2_TABLE_100();
1303: a2 := JTF_VARCHAR2_TABLE_100();
1304: if t.count > 0 then
1305: a0.extend(t.count);
1306: a1.extend(t.count);
1299: a2 := JTF_VARCHAR2_TABLE_100();
1300: else
1301: a0 := JTF_VARCHAR2_TABLE_100();
1302: a1 := JTF_VARCHAR2_TABLE_100();
1303: a2 := JTF_VARCHAR2_TABLE_100();
1304: if t.count > 0 then
1305: a0.extend(t.count);
1306: a1.extend(t.count);
1307: a2.extend(t.count);
1322: end rosetta_table_copy_out_p54;
1323:
1324: procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1325: , a1 JTF_VARCHAR2_TABLE_500
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1323:
1324: procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1325: , a1 JTF_VARCHAR2_TABLE_500
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1324: procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1325: , a1 JTF_VARCHAR2_TABLE_500
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1325: , a1 JTF_VARCHAR2_TABLE_500
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1334: , a10 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1334: , a10 JTF_VARCHAR2_TABLE_100
1335: ) as
1328: , a4 JTF_VARCHAR2_TABLE_100
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1334: , a10 JTF_VARCHAR2_TABLE_100
1335: ) as
1336: ddindx binary_integer; indx binary_integer;
1329: , a5 JTF_VARCHAR2_TABLE_100
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1334: , a10 JTF_VARCHAR2_TABLE_100
1335: ) as
1336: ddindx binary_integer; indx binary_integer;
1337: begin
1330: , a6 JTF_VARCHAR2_TABLE_100
1331: , a7 JTF_VARCHAR2_TABLE_100
1332: , a8 JTF_VARCHAR2_TABLE_100
1333: , a9 JTF_VARCHAR2_TABLE_100
1334: , a10 JTF_VARCHAR2_TABLE_100
1335: ) as
1336: ddindx binary_integer; indx binary_integer;
1337: begin
1338: if a0 is not null and a0.count > 0 then
1361: end if;
1362: end rosetta_table_copy_in_p56;
1363: procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1362: end rosetta_table_copy_in_p56;
1363: procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1363: procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1374: ) as
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1374: ) as
1375: ddindx binary_integer; indx binary_integer;
1368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1374: ) as
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1369: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1370: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1372: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1374: ) as
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1377: if t is null or t.count = 0 then
1376: begin
1377: if t is null or t.count = 0 then
1378: a0 := JTF_VARCHAR2_TABLE_500();
1379: a1 := JTF_VARCHAR2_TABLE_500();
1380: a2 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1377: if t is null or t.count = 0 then
1378: a0 := JTF_VARCHAR2_TABLE_500();
1379: a1 := JTF_VARCHAR2_TABLE_500();
1380: a2 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1378: a0 := JTF_VARCHAR2_TABLE_500();
1379: a1 := JTF_VARCHAR2_TABLE_500();
1380: a2 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1379: a1 := JTF_VARCHAR2_TABLE_500();
1380: a2 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1380: a2 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1381: a3 := JTF_VARCHAR2_TABLE_100();
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1389: else
1382: a4 := JTF_VARCHAR2_TABLE_100();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1389: else
1390: a0 := JTF_VARCHAR2_TABLE_500();
1383: a5 := JTF_VARCHAR2_TABLE_100();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1389: else
1390: a0 := JTF_VARCHAR2_TABLE_500();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1384: a6 := JTF_VARCHAR2_TABLE_100();
1385: a7 := JTF_VARCHAR2_TABLE_100();
1386: a8 := JTF_VARCHAR2_TABLE_100();
1387: a9 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1389: else
1390: a0 := JTF_VARCHAR2_TABLE_500();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1388: a10 := JTF_VARCHAR2_TABLE_100();
1389: else
1390: a0 := JTF_VARCHAR2_TABLE_500();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1389: else
1390: a0 := JTF_VARCHAR2_TABLE_500();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1390: a0 := JTF_VARCHAR2_TABLE_500();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1391: a1 := JTF_VARCHAR2_TABLE_500();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1392: a2 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1400: a10 := JTF_VARCHAR2_TABLE_100();
1393: a3 := JTF_VARCHAR2_TABLE_100();
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1400: a10 := JTF_VARCHAR2_TABLE_100();
1401: if t.count > 0 then
1394: a4 := JTF_VARCHAR2_TABLE_100();
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1400: a10 := JTF_VARCHAR2_TABLE_100();
1401: if t.count > 0 then
1402: a0.extend(t.count);
1395: a5 := JTF_VARCHAR2_TABLE_100();
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1400: a10 := JTF_VARCHAR2_TABLE_100();
1401: if t.count > 0 then
1402: a0.extend(t.count);
1403: a1.extend(t.count);
1396: a6 := JTF_VARCHAR2_TABLE_100();
1397: a7 := JTF_VARCHAR2_TABLE_100();
1398: a8 := JTF_VARCHAR2_TABLE_100();
1399: a9 := JTF_VARCHAR2_TABLE_100();
1400: a10 := JTF_VARCHAR2_TABLE_100();
1401: if t.count > 0 then
1402: a0.extend(t.count);
1403: a1.extend(t.count);
1404: a2.extend(t.count);
1435: end rosetta_table_copy_out_p56;
1436:
1437: procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1438: , a1 JTF_VARCHAR2_TABLE_500
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1436:
1437: procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1438: , a1 JTF_VARCHAR2_TABLE_500
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1437: procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1438: , a1 JTF_VARCHAR2_TABLE_500
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1438: , a1 JTF_VARCHAR2_TABLE_500
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1447: , a10 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1447: , a10 JTF_VARCHAR2_TABLE_100
1448: ) as
1441: , a4 JTF_VARCHAR2_TABLE_100
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1447: , a10 JTF_VARCHAR2_TABLE_100
1448: ) as
1449: ddindx binary_integer; indx binary_integer;
1442: , a5 JTF_VARCHAR2_TABLE_100
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1447: , a10 JTF_VARCHAR2_TABLE_100
1448: ) as
1449: ddindx binary_integer; indx binary_integer;
1450: begin
1443: , a6 JTF_VARCHAR2_TABLE_100
1444: , a7 JTF_VARCHAR2_TABLE_100
1445: , a8 JTF_VARCHAR2_TABLE_100
1446: , a9 JTF_VARCHAR2_TABLE_100
1447: , a10 JTF_VARCHAR2_TABLE_100
1448: ) as
1449: ddindx binary_integer; indx binary_integer;
1450: begin
1451: if a0 is not null and a0.count > 0 then
1474: end if;
1475: end rosetta_table_copy_in_p58;
1476: procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1477: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1475: end rosetta_table_copy_in_p58;
1476: procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1477: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1476: procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1477: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1477: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1486: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1486: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1487: ) as
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1486: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1487: ) as
1488: ddindx binary_integer; indx binary_integer;
1481: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1486: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1487: ) as
1488: ddindx binary_integer; indx binary_integer;
1489: begin
1482: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1483: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1484: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1485: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1486: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1487: ) as
1488: ddindx binary_integer; indx binary_integer;
1489: begin
1490: if t is null or t.count = 0 then
1489: begin
1490: if t is null or t.count = 0 then
1491: a0 := JTF_VARCHAR2_TABLE_500();
1492: a1 := JTF_VARCHAR2_TABLE_500();
1493: a2 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1490: if t is null or t.count = 0 then
1491: a0 := JTF_VARCHAR2_TABLE_500();
1492: a1 := JTF_VARCHAR2_TABLE_500();
1493: a2 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1491: a0 := JTF_VARCHAR2_TABLE_500();
1492: a1 := JTF_VARCHAR2_TABLE_500();
1493: a2 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1492: a1 := JTF_VARCHAR2_TABLE_500();
1493: a2 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1493: a2 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1494: a3 := JTF_VARCHAR2_TABLE_100();
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1502: else
1495: a4 := JTF_VARCHAR2_TABLE_100();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1502: else
1503: a0 := JTF_VARCHAR2_TABLE_500();
1496: a5 := JTF_VARCHAR2_TABLE_100();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1502: else
1503: a0 := JTF_VARCHAR2_TABLE_500();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1497: a6 := JTF_VARCHAR2_TABLE_100();
1498: a7 := JTF_VARCHAR2_TABLE_100();
1499: a8 := JTF_VARCHAR2_TABLE_100();
1500: a9 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1502: else
1503: a0 := JTF_VARCHAR2_TABLE_500();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1501: a10 := JTF_VARCHAR2_TABLE_100();
1502: else
1503: a0 := JTF_VARCHAR2_TABLE_500();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1502: else
1503: a0 := JTF_VARCHAR2_TABLE_500();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1503: a0 := JTF_VARCHAR2_TABLE_500();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1504: a1 := JTF_VARCHAR2_TABLE_500();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1505: a2 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1513: a10 := JTF_VARCHAR2_TABLE_100();
1506: a3 := JTF_VARCHAR2_TABLE_100();
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1513: a10 := JTF_VARCHAR2_TABLE_100();
1514: if t.count > 0 then
1507: a4 := JTF_VARCHAR2_TABLE_100();
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1513: a10 := JTF_VARCHAR2_TABLE_100();
1514: if t.count > 0 then
1515: a0.extend(t.count);
1508: a5 := JTF_VARCHAR2_TABLE_100();
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1513: a10 := JTF_VARCHAR2_TABLE_100();
1514: if t.count > 0 then
1515: a0.extend(t.count);
1516: a1.extend(t.count);
1509: a6 := JTF_VARCHAR2_TABLE_100();
1510: a7 := JTF_VARCHAR2_TABLE_100();
1511: a8 := JTF_VARCHAR2_TABLE_100();
1512: a9 := JTF_VARCHAR2_TABLE_100();
1513: a10 := JTF_VARCHAR2_TABLE_100();
1514: if t.count > 0 then
1515: a0.extend(t.count);
1516: a1.extend(t.count);
1517: a2.extend(t.count);
1546: end if;
1547: end if;
1548: end rosetta_table_copy_out_p58;
1549:
1550: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1551: , a1 JTF_VARCHAR2_TABLE_400
1552: ) as
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1567: end loop;
1568: end if;
1569: end if;
1570: end rosetta_table_copy_in_p60;
1571: procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1572: , a1 out nocopy JTF_VARCHAR2_TABLE_400
1573: ) as
1574: ddindx binary_integer; indx binary_integer;
1575: begin
1573: ) as
1574: ddindx binary_integer; indx binary_integer;
1575: begin
1576: if t is null or t.count = 0 then
1577: a0 := JTF_VARCHAR2_TABLE_100();
1578: a1 := JTF_VARCHAR2_TABLE_400();
1579: else
1580: a0 := JTF_VARCHAR2_TABLE_100();
1581: a1 := JTF_VARCHAR2_TABLE_400();
1576: if t is null or t.count = 0 then
1577: a0 := JTF_VARCHAR2_TABLE_100();
1578: a1 := JTF_VARCHAR2_TABLE_400();
1579: else
1580: a0 := JTF_VARCHAR2_TABLE_100();
1581: a1 := JTF_VARCHAR2_TABLE_400();
1582: if t.count > 0 then
1583: a0.extend(t.count);
1584: a1.extend(t.count);
1600: procedure rosetta_table_copy_in_p62(t out nocopy oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1601: , a1 JTF_VARCHAR2_TABLE_500
1602: , a2 JTF_VARCHAR2_TABLE_500
1603: , a3 JTF_VARCHAR2_TABLE_500
1604: , a4 JTF_VARCHAR2_TABLE_100
1605: , a5 JTF_VARCHAR2_TABLE_500
1606: , a6 JTF_VARCHAR2_TABLE_500
1607: ) as
1608: ddindx binary_integer; indx binary_integer;
1631: procedure rosetta_table_copy_out_p62(t oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1632: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1633: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1634: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1635: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1636: , a5 out nocopy JTF_VARCHAR2_TABLE_500
1637: , a6 out nocopy JTF_VARCHAR2_TABLE_500
1638: ) as
1639: ddindx binary_integer; indx binary_integer;
1642: a0 := JTF_VARCHAR2_TABLE_500();
1643: a1 := JTF_VARCHAR2_TABLE_500();
1644: a2 := JTF_VARCHAR2_TABLE_500();
1645: a3 := JTF_VARCHAR2_TABLE_500();
1646: a4 := JTF_VARCHAR2_TABLE_100();
1647: a5 := JTF_VARCHAR2_TABLE_500();
1648: a6 := JTF_VARCHAR2_TABLE_500();
1649: else
1650: a0 := JTF_VARCHAR2_TABLE_500();
1650: a0 := JTF_VARCHAR2_TABLE_500();
1651: a1 := JTF_VARCHAR2_TABLE_500();
1652: a2 := JTF_VARCHAR2_TABLE_500();
1653: a3 := JTF_VARCHAR2_TABLE_500();
1654: a4 := JTF_VARCHAR2_TABLE_100();
1655: a5 := JTF_VARCHAR2_TABLE_500();
1656: a6 := JTF_VARCHAR2_TABLE_500();
1657: if t.count > 0 then
1658: a0.extend(t.count);
1914: , x_msg_count out nocopy NUMBER
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1924: , p5_a8 out nocopy JTF_DATE_TABLE
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1924: , p5_a8 out nocopy JTF_DATE_TABLE
1925: , p5_a9 out nocopy JTF_DATE_TABLE
1924: , p5_a8 out nocopy JTF_DATE_TABLE
1925: , p5_a9 out nocopy JTF_DATE_TABLE
1926: , p5_a10 out nocopy JTF_DATE_TABLE
1927: , p5_a11 out nocopy JTF_NUMBER_TABLE
1928: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1929: )
1930:
1931: as
1932: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;
1996: , x_msg_count out nocopy NUMBER
1997: , x_msg_data out nocopy VARCHAR2
1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
1997: , x_msg_data out nocopy VARCHAR2
1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p25_a8 out nocopy JTF_DATE_TABLE
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p25_a8 out nocopy JTF_DATE_TABLE
2007: , p25_a9 out nocopy JTF_DATE_TABLE
2006: , p25_a8 out nocopy JTF_DATE_TABLE
2007: , p25_a9 out nocopy JTF_DATE_TABLE
2008: , p25_a10 out nocopy JTF_DATE_TABLE
2009: , p25_a11 out nocopy JTF_NUMBER_TABLE
2010: , p25_a12 out nocopy JTF_VARCHAR2_TABLE_100
2011: )
2012:
2013: as
2014: ddp_start_date_from date;
2130: procedure party_sites(p_party_id_arg VARCHAR2
2131: , p_site_name_arg VARCHAR2
2132: , x_return_status out nocopy VARCHAR2
2133: , p3_a0 out nocopy JTF_NUMBER_TABLE
2134: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2135: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
2136: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2137: )
2138:
2255: , p1_a0 JTF_NUMBER_TABLE
2256: , p_system_name_arg VARCHAR2
2257: , x_return_status out nocopy VARCHAR2
2258: , p4_a0 out nocopy JTF_NUMBER_TABLE
2259: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2261: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2262: )
2263:
2298: , p1_a0 JTF_NUMBER_TABLE
2299: , p_product_name_arg VARCHAR2
2300: , x_return_status out nocopy VARCHAR2
2301: , p4_a0 out nocopy JTF_NUMBER_TABLE
2302: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2303: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2304: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2305: )
2306:
2339:
2340: procedure adv_search_overview(p_party_id_arg VARCHAR2
2341: , x_return_status out nocopy VARCHAR2
2342: , x_party_name out nocopy VARCHAR2
2343: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2347: )
2340: procedure adv_search_overview(p_party_id_arg VARCHAR2
2341: , x_return_status out nocopy VARCHAR2
2342: , x_party_name out nocopy VARCHAR2
2343: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2347: )
2348:
2341: , x_return_status out nocopy VARCHAR2
2342: , x_party_name out nocopy VARCHAR2
2343: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2347: )
2348:
2349: as
2342: , x_party_name out nocopy VARCHAR2
2343: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2347: )
2348:
2349: as
2350: ddx_contract_cat_tbl_type oks_entitlements_web.contract_cat_tbl_type;
2409: , p4_a8 out nocopy VARCHAR2
2410: , p4_a9 out nocopy VARCHAR2
2411: , p4_a10 out nocopy VARCHAR2
2412: , p5_a0 out nocopy JTF_NUMBER_TABLE
2413: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
2414: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2415: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
2416: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2417: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2410: , p4_a9 out nocopy VARCHAR2
2411: , p4_a10 out nocopy VARCHAR2
2412: , p5_a0 out nocopy JTF_NUMBER_TABLE
2413: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
2414: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2415: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
2416: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2417: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2418: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2412: , p5_a0 out nocopy JTF_NUMBER_TABLE
2413: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
2414: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2415: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
2416: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2417: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2418: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2419: , p6_a0 out nocopy JTF_NUMBER_TABLE
2420: , p6_a1 out nocopy JTF_NUMBER_TABLE
2413: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
2414: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2415: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
2416: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2417: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2418: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2419: , p6_a0 out nocopy JTF_NUMBER_TABLE
2420: , p6_a1 out nocopy JTF_NUMBER_TABLE
2421: , p6_a2 out nocopy JTF_DATE_TABLE
2414: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2415: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
2416: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2417: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2418: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2419: , p6_a0 out nocopy JTF_NUMBER_TABLE
2420: , p6_a1 out nocopy JTF_NUMBER_TABLE
2421: , p6_a2 out nocopy JTF_DATE_TABLE
2422: , p6_a3 out nocopy JTF_DATE_TABLE
2419: , p6_a0 out nocopy JTF_NUMBER_TABLE
2420: , p6_a1 out nocopy JTF_NUMBER_TABLE
2421: , p6_a2 out nocopy JTF_DATE_TABLE
2422: , p6_a3 out nocopy JTF_DATE_TABLE
2423: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2425: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
2426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
2427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
2420: , p6_a1 out nocopy JTF_NUMBER_TABLE
2421: , p6_a2 out nocopy JTF_DATE_TABLE
2422: , p6_a3 out nocopy JTF_DATE_TABLE
2423: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2425: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
2426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
2427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
2428: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
2431: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
2432: , p6_a13 out nocopy JTF_NUMBER_TABLE
2433: , p6_a14 out nocopy JTF_NUMBER_TABLE
2434: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2435: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2436: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2434: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2435: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2436: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
2442: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2435: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2436: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
2442: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2443: )
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
2442: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2443: )
2444:
2445: as
2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2567: , p3_a8 out nocopy VARCHAR2
2568: , p3_a9 out nocopy VARCHAR2
2569: , p3_a10 out nocopy VARCHAR2
2570: , p4_a0 out nocopy JTF_NUMBER_TABLE
2571: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
2574: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
2575: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
2568: , p3_a9 out nocopy VARCHAR2
2569: , p3_a10 out nocopy VARCHAR2
2570: , p4_a0 out nocopy JTF_NUMBER_TABLE
2571: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
2574: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
2575: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
2576: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2570: , p4_a0 out nocopy JTF_NUMBER_TABLE
2571: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
2574: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
2575: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
2576: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2577: , p5_a0 out nocopy JTF_NUMBER_TABLE
2578: , p5_a1 out nocopy JTF_NUMBER_TABLE
2571: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
2574: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
2575: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
2576: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2577: , p5_a0 out nocopy JTF_NUMBER_TABLE
2578: , p5_a1 out nocopy JTF_NUMBER_TABLE
2579: , p5_a2 out nocopy JTF_DATE_TABLE
2572: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
2574: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
2575: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
2576: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2577: , p5_a0 out nocopy JTF_NUMBER_TABLE
2578: , p5_a1 out nocopy JTF_NUMBER_TABLE
2579: , p5_a2 out nocopy JTF_DATE_TABLE
2580: , p5_a3 out nocopy JTF_DATE_TABLE
2577: , p5_a0 out nocopy JTF_NUMBER_TABLE
2578: , p5_a1 out nocopy JTF_NUMBER_TABLE
2579: , p5_a2 out nocopy JTF_DATE_TABLE
2580: , p5_a3 out nocopy JTF_DATE_TABLE
2581: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2582: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2583: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200
2584: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
2585: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
2578: , p5_a1 out nocopy JTF_NUMBER_TABLE
2579: , p5_a2 out nocopy JTF_DATE_TABLE
2580: , p5_a3 out nocopy JTF_DATE_TABLE
2581: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2582: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2583: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200
2584: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
2585: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
2586: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
2589: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
2590: , p5_a13 out nocopy JTF_NUMBER_TABLE
2591: , p5_a14 out nocopy JTF_NUMBER_TABLE
2592: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
2593: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2594: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2592: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
2593: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2594: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2598: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
2600: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2593: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2594: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2598: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
2600: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2601: )
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2598: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
2600: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2601: )
2602:
2603: as
2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2695: procedure party_overview(p_contract_id_arg VARCHAR2
2696: , p_party_rle_code_arg VARCHAR2
2697: , x_return_status out nocopy VARCHAR2
2698: , p3_a0 out nocopy JTF_NUMBER_TABLE
2699: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2700: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
2701: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
2702: , p3_a4 out nocopy JTF_DATE_TABLE
2703: , p3_a5 out nocopy JTF_DATE_TABLE
2696: , p_party_rle_code_arg VARCHAR2
2697: , x_return_status out nocopy VARCHAR2
2698: , p3_a0 out nocopy JTF_NUMBER_TABLE
2699: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2700: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
2701: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
2702: , p3_a4 out nocopy JTF_DATE_TABLE
2703: , p3_a5 out nocopy JTF_DATE_TABLE
2704: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
2697: , x_return_status out nocopy VARCHAR2
2698: , p3_a0 out nocopy JTF_NUMBER_TABLE
2699: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2700: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
2701: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
2702: , p3_a4 out nocopy JTF_DATE_TABLE
2703: , p3_a5 out nocopy JTF_DATE_TABLE
2704: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
2705: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
2701: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
2702: , p3_a4 out nocopy JTF_DATE_TABLE
2703: , p3_a5 out nocopy JTF_DATE_TABLE
2704: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
2705: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
2706: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
2707: )
2708:
2709: as
2702: , p3_a4 out nocopy JTF_DATE_TABLE
2703: , p3_a5 out nocopy JTF_DATE_TABLE
2704: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
2705: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
2706: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
2707: )
2708:
2709: as
2710: ddx_party_contact_tbl_type oks_entitlements_web.party_contact_tbl_type;
2739: end;
2740:
2741: procedure party_contacts_overview(p_contact_id_arg VARCHAR2
2742: , x_return_status out nocopy VARCHAR2
2743: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2740:
2741: procedure party_contacts_overview(p_contact_id_arg VARCHAR2
2742: , x_return_status out nocopy VARCHAR2
2743: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2742: , x_return_status out nocopy VARCHAR2
2743: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2743: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2751: )
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2751: )
2752:
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2751: )
2752:
2753: as
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2751: )
2752:
2753: as
2754: ddx_pty_cntct_dtls_tbl_type oks_entitlements_web.pty_cntct_dtls_tbl_type;
2942: procedure bus_proc_overview(p_bus_proc_id_arg VARCHAR2
2943: , p_contract_id_arg VARCHAR2
2944: , x_return_status out nocopy VARCHAR2
2945: , p3_a0 out nocopy VARCHAR2
2946: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2943: , p_contract_id_arg VARCHAR2
2944: , x_return_status out nocopy VARCHAR2
2945: , p3_a0 out nocopy VARCHAR2
2946: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2944: , x_return_status out nocopy VARCHAR2
2945: , p3_a0 out nocopy VARCHAR2
2946: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2949: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2950: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2951: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2953: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2954: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2955: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
2957: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2958: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2959: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2960: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2961: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2962: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2963: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2971: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
2964: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2971: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
2972: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
2965: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2971: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
2972: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
2973: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
2966: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2971: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
2972: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
2973: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
2974: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_500
2967: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2968: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2969: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2970: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2971: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
2972: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
2973: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
2974: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_500
2975: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_500
2973: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
2974: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_500
2975: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_500
2976: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
2977: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
2978: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
2979: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500
2980: )
2981: