20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibe_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_2000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t ibe_deliverable_grp.deliverable_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_300
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_300
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_300();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_2000();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_300();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_2000();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_300();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_300();
86: a6 := JTF_VARCHAR2_TABLE_2000();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_300();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_300();
86: a6 := JTF_VARCHAR2_TABLE_2000();
87: a7 := JTF_NUMBER_TABLE();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out nocopy ibe_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE
122: , a1 JTF_VARCHAR2_TABLE_100
123: , a2 JTF_VARCHAR2_TABLE_300
124: , a3 JTF_VARCHAR2_TABLE_100
125: , a4 JTF_VARCHAR2_TABLE_100
126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000
122: , a1 JTF_VARCHAR2_TABLE_100
123: , a2 JTF_VARCHAR2_TABLE_300
124: , a3 JTF_VARCHAR2_TABLE_100
125: , a4 JTF_VARCHAR2_TABLE_100
126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000
128: , a7 JTF_NUMBER_TABLE
129: , a8 JTF_VARCHAR2_TABLE_100
130: , a9 JTF_VARCHAR2_TABLE_300
126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000
128: , a7 JTF_NUMBER_TABLE
129: , a8 JTF_VARCHAR2_TABLE_100
130: , a9 JTF_VARCHAR2_TABLE_300
131: , a10 JTF_NUMBER_TABLE
132: , a11 JTF_VARCHAR2_TABLE_100
133: ) as
134: ddindx binary_integer; indx binary_integer;
160: end if;
161: end rosetta_table_copy_in_p3;
162: procedure rosetta_table_copy_out_p3(t ibe_deliverable_grp.dlv_ath_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
163: , a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , a2 out nocopy JTF_VARCHAR2_TABLE_300
165: , a3 out nocopy JTF_VARCHAR2_TABLE_100
166: , a4 out nocopy JTF_VARCHAR2_TABLE_100
167: , a5 out nocopy JTF_VARCHAR2_TABLE_300
168: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
163: , a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , a2 out nocopy JTF_VARCHAR2_TABLE_300
165: , a3 out nocopy JTF_VARCHAR2_TABLE_100
166: , a4 out nocopy JTF_VARCHAR2_TABLE_100
167: , a5 out nocopy JTF_VARCHAR2_TABLE_300
168: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
169: , a7 out nocopy JTF_NUMBER_TABLE
170: , a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , a9 out nocopy JTF_VARCHAR2_TABLE_300
167: , a5 out nocopy JTF_VARCHAR2_TABLE_300
168: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
169: , a7 out nocopy JTF_NUMBER_TABLE
170: , a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , a10 out nocopy JTF_NUMBER_TABLE
173: , a11 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_VARCHAR2_TABLE_100();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_300();
184: a6 := JTF_VARCHAR2_TABLE_2000();
179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_VARCHAR2_TABLE_100();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_300();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_300();
183: a5 := JTF_VARCHAR2_TABLE_300();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_300();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: else
191: a0 := JTF_NUMBER_TABLE();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: else
191: a0 := JTF_NUMBER_TABLE();
192: a1 := JTF_VARCHAR2_TABLE_100();
193: a2 := JTF_VARCHAR2_TABLE_300();
194: a3 := JTF_VARCHAR2_TABLE_100();
195: a4 := JTF_VARCHAR2_TABLE_100();
196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();
192: a1 := JTF_VARCHAR2_TABLE_100();
193: a2 := JTF_VARCHAR2_TABLE_300();
194: a3 := JTF_VARCHAR2_TABLE_100();
195: a4 := JTF_VARCHAR2_TABLE_100();
196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();
198: a7 := JTF_NUMBER_TABLE();
199: a8 := JTF_VARCHAR2_TABLE_100();
200: a9 := JTF_VARCHAR2_TABLE_300();
196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();
198: a7 := JTF_NUMBER_TABLE();
199: a8 := JTF_VARCHAR2_TABLE_100();
200: a9 := JTF_VARCHAR2_TABLE_300();
201: a10 := JTF_NUMBER_TABLE();
202: a11 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);
238: end if;
239: end rosetta_table_copy_out_p3;
240:
241: procedure rosetta_table_copy_in_p5(t out nocopy ibe_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_VARCHAR2_TABLE_300
243: , a2 JTF_NUMBER_TABLE
244: , a3 JTF_VARCHAR2_TABLE_100
245: ) as
246: ddindx binary_integer; indx binary_integer;
263: end if;
264: end if;
265: end rosetta_table_copy_in_p5;
266: procedure rosetta_table_copy_out_p5(t ibe_deliverable_grp.dlv_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
267: , a1 out nocopy JTF_VARCHAR2_TABLE_300
268: , a2 out nocopy JTF_NUMBER_TABLE
269: , a3 out nocopy JTF_VARCHAR2_TABLE_100
270: ) as
271: ddindx binary_integer; indx binary_integer;
271: ddindx binary_integer; indx binary_integer;
272: begin
273: if t is null or t.count = 0 then
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_VARCHAR2_TABLE_300();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_VARCHAR2_TABLE_100();
278: else
279: a0 := JTF_NUMBER_TABLE();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_VARCHAR2_TABLE_100();
278: else
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_VARCHAR2_TABLE_300();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_VARCHAR2_TABLE_100();
283: if t.count > 0 then
284: a0.extend(t.count);
399: end if;
400: end if;
401: end rosetta_table_copy_out_p7;
402:
403: procedure rosetta_table_copy_in_p8(t out nocopy ibe_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
404: ddindx binary_integer; indx binary_integer;
405: begin
406: if a0 is null then
407: t := null;
423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ibe_deliverable_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
428: ddindx binary_integer; indx binary_integer;
429: begin
430: if t is null then
431: a0 := null;
429: begin
430: if t is null then
431: a0 := null;
432: elsif t.count = 0 then
433: a0 := JTF_VARCHAR2_TABLE_300();
434: else
435: a0 := JTF_VARCHAR2_TABLE_300();
436: if t.count > 0 then
437: a0.extend(t.count);
431: a0 := null;
432: elsif t.count = 0 then
433: a0 := JTF_VARCHAR2_TABLE_300();
434: else
435: a0 := JTF_VARCHAR2_TABLE_300();
436: if t.count > 0 then
437: a0.extend(t.count);
438: ddindx := t.first;
439: indx := 1;
511: , p_batch_size NUMBER
512: , x_row_count out nocopy NUMBER
513: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
514: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
514: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out nocopy JTF_NUMBER_TABLE
521: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
522: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
517: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out nocopy JTF_NUMBER_TABLE
521: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
522: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
523: )
524:
525: as
631: , p_batch_size NUMBER
632: , x_row_count out nocopy NUMBER
633: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
634: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
635: , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
636: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
637: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
638: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
639: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
634: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100
635: , x_dsp_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
636: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
637: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
638: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
639: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
640: , x_version_tbl out nocopy JTF_NUMBER_TABLE
641: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
642: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
637: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100
638: , x_keyword_tbl out nocopy JTF_VARCHAR2_TABLE_300
639: , x_desc_tbl out nocopy JTF_VARCHAR2_TABLE_2000
640: , x_version_tbl out nocopy JTF_NUMBER_TABLE
641: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
642: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
643: )
644:
645: as
813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p6_a0 in out nocopy JTF_NUMBER_TABLE
816: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
818: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
819: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
816: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
818: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
819: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
822: , p6_a7 in out nocopy JTF_NUMBER_TABLE
823: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
824: )
956: , x_msg_count out nocopy NUMBER
957: , x_msg_data out nocopy VARCHAR2
958: , p6_a0 in out nocopy JTF_NUMBER_TABLE
959: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
961: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
964: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
961: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
964: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
965: , p6_a7 in out nocopy JTF_NUMBER_TABLE
966: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
967: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_300
963: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
964: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
965: , p6_a7 in out nocopy JTF_NUMBER_TABLE
966: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
967: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_300
968: , p6_a10 in out nocopy JTF_NUMBER_TABLE
969: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
970: )
971:
1032: , x_return_status out nocopy VARCHAR2
1033: , x_msg_count out nocopy NUMBER
1034: , x_msg_data out nocopy VARCHAR2
1035: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1036: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1038: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1039: )
1040: