1: package body okc_terms_multirec_grp_w as
2: /* $Header: OKCWMULB.pls 120.3 2005/09/14 02:34:52 vnanjang noship $ */
3:
4: procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_100
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_100
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_100
9: , a5 JTF_VARCHAR2_TABLE_2000
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_NUMBER_TABLE
12: ) as
13: ddindx binary_integer; indx binary_integer;
14: begin
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_100
9: , a5 JTF_VARCHAR2_TABLE_2000
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_NUMBER_TABLE
12: ) as
13: ddindx binary_integer; indx binary_integer;
14: begin
15: if a0 is not null and a0.count > 0 then
33: end loop;
34: end if;
35: end if;
36: end rosetta_table_copy_in_p5;
37: procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_100
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a6 out nocopy JTF_NUMBER_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a6 out nocopy JTF_NUMBER_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_VARCHAR2_TABLE_100();
54: a5 := JTF_VARCHAR2_TABLE_2000();
55: a6 := JTF_NUMBER_TABLE();
56: a7 := JTF_NUMBER_TABLE();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_VARCHAR2_TABLE_100();
54: a5 := JTF_VARCHAR2_TABLE_2000();
55: a6 := JTF_NUMBER_TABLE();
56: a7 := JTF_NUMBER_TABLE();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
54: a5 := JTF_VARCHAR2_TABLE_2000();
55: a6 := JTF_NUMBER_TABLE();
56: a7 := JTF_NUMBER_TABLE();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: a5 := JTF_VARCHAR2_TABLE_2000();
64: a6 := JTF_NUMBER_TABLE();
65: a7 := JTF_NUMBER_TABLE();
66: if t.count > 0 then
67: a0.extend(t.count);
68: a1.extend(t.count);
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: a5 := JTF_VARCHAR2_TABLE_2000();
64: a6 := JTF_NUMBER_TABLE();
65: a7 := JTF_NUMBER_TABLE();
66: if t.count > 0 then
67: a0.extend(t.count);
68: a1.extend(t.count);
69: a2.extend(t.count);
92: end if;
93: end if;
94: end rosetta_table_copy_out_p5;
95:
96: procedure rosetta_table_copy_in_p6(t out nocopy okc_terms_multirec_grp.kart_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_2000
100: , a4 JTF_VARCHAR2_TABLE_100
93: end if;
94: end rosetta_table_copy_out_p5;
95:
96: procedure rosetta_table_copy_in_p6(t out nocopy okc_terms_multirec_grp.kart_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_2000
100: , a4 JTF_VARCHAR2_TABLE_100
101: , a5 JTF_NUMBER_TABLE
94: end rosetta_table_copy_out_p5;
95:
96: procedure rosetta_table_copy_in_p6(t out nocopy okc_terms_multirec_grp.kart_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_2000
100: , a4 JTF_VARCHAR2_TABLE_100
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_2000
100: , a4 JTF_VARCHAR2_TABLE_100
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_2000
100: , a4 JTF_VARCHAR2_TABLE_100
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: ) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if a0 is not null and a0.count > 0 then
123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p6;
127: procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: end if;
125: end if;
126: end rosetta_table_copy_in_p6;
127: procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_NUMBER_TABLE
125: end if;
126: end rosetta_table_copy_in_p6;
127: procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_NUMBER_TABLE
133: , a6 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_NUMBER_TABLE
133: , a6 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100
132: , a5 out nocopy JTF_NUMBER_TABLE
133: , a6 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_VARCHAR2_TABLE_2000();
142: a4 := JTF_VARCHAR2_TABLE_100();
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_VARCHAR2_TABLE_2000();
142: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_VARCHAR2_TABLE_2000();
142: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_VARCHAR2_TABLE_2000();
142: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_VARCHAR2_TABLE_2000();
142: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
142: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_2000();
150: a4 := JTF_VARCHAR2_TABLE_100();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_2000();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_2000();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_2000();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_NUMBER_TABLE();
153: if t.count > 0 then
154: a0.extend(t.count);
155: a1.extend(t.count);
148: a2 := JTF_NUMBER_TABLE();
149: a3 := JTF_VARCHAR2_TABLE_2000();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_NUMBER_TABLE();
153: if t.count > 0 then
154: a0.extend(t.count);
155: a1.extend(t.count);
156: a2.extend(t.count);
178: end if;
179: end rosetta_table_copy_out_p6;
180:
181: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
182: , a1 JTF_NUMBER_TABLE
183: , a2 JTF_NUMBER_TABLE
184: , a3 JTF_NUMBER_TABLE
185: , a4 JTF_VARCHAR2_TABLE_100
186: , a5 JTF_VARCHAR2_TABLE_100
179: end rosetta_table_copy_out_p6;
180:
181: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
182: , a1 JTF_NUMBER_TABLE
183: , a2 JTF_NUMBER_TABLE
184: , a3 JTF_NUMBER_TABLE
185: , a4 JTF_VARCHAR2_TABLE_100
186: , a5 JTF_VARCHAR2_TABLE_100
187: , a6 JTF_NUMBER_TABLE
180:
181: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
182: , a1 JTF_NUMBER_TABLE
183: , a2 JTF_NUMBER_TABLE
184: , a3 JTF_NUMBER_TABLE
185: , a4 JTF_VARCHAR2_TABLE_100
186: , a5 JTF_VARCHAR2_TABLE_100
187: , a6 JTF_NUMBER_TABLE
188: ) as
183: , a2 JTF_NUMBER_TABLE
184: , a3 JTF_NUMBER_TABLE
185: , a4 JTF_VARCHAR2_TABLE_100
186: , a5 JTF_VARCHAR2_TABLE_100
187: , a6 JTF_NUMBER_TABLE
188: ) as
189: ddindx binary_integer; indx binary_integer;
190: begin
191: if a0 is not null and a0.count > 0 then
209: end if;
210: end if;
211: end rosetta_table_copy_in_p7;
212: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
213: , a1 out nocopy JTF_NUMBER_TABLE
214: , a2 out nocopy JTF_NUMBER_TABLE
215: , a3 out nocopy JTF_NUMBER_TABLE
216: , a4 out nocopy JTF_VARCHAR2_TABLE_100
217: , a5 out nocopy JTF_VARCHAR2_TABLE_100
210: end if;
211: end rosetta_table_copy_in_p7;
212: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
213: , a1 out nocopy JTF_NUMBER_TABLE
214: , a2 out nocopy JTF_NUMBER_TABLE
215: , a3 out nocopy JTF_NUMBER_TABLE
216: , a4 out nocopy JTF_VARCHAR2_TABLE_100
217: , a5 out nocopy JTF_VARCHAR2_TABLE_100
218: , a6 out nocopy JTF_NUMBER_TABLE
211: end rosetta_table_copy_in_p7;
212: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
213: , a1 out nocopy JTF_NUMBER_TABLE
214: , a2 out nocopy JTF_NUMBER_TABLE
215: , a3 out nocopy JTF_NUMBER_TABLE
216: , a4 out nocopy JTF_VARCHAR2_TABLE_100
217: , a5 out nocopy JTF_VARCHAR2_TABLE_100
218: , a6 out nocopy JTF_NUMBER_TABLE
219: ) as
214: , a2 out nocopy JTF_NUMBER_TABLE
215: , a3 out nocopy JTF_NUMBER_TABLE
216: , a4 out nocopy JTF_VARCHAR2_TABLE_100
217: , a5 out nocopy JTF_VARCHAR2_TABLE_100
218: , a6 out nocopy JTF_NUMBER_TABLE
219: ) as
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if t is null or t.count = 0 then
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
224: a1 := JTF_NUMBER_TABLE();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_VARCHAR2_TABLE_100();
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
224: a1 := JTF_NUMBER_TABLE();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_NUMBER_TABLE();
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
224: a1 := JTF_NUMBER_TABLE();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_NUMBER_TABLE();
230: else
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_VARCHAR2_TABLE_100();
232: a1 := JTF_NUMBER_TABLE();
233: a2 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_VARCHAR2_TABLE_100();
232: a1 := JTF_NUMBER_TABLE();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_NUMBER_TABLE();
235: a4 := JTF_VARCHAR2_TABLE_100();
236: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_VARCHAR2_TABLE_100();
232: a1 := JTF_NUMBER_TABLE();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_NUMBER_TABLE();
235: a4 := JTF_VARCHAR2_TABLE_100();
236: a5 := JTF_VARCHAR2_TABLE_100();
237: a6 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_VARCHAR2_TABLE_100();
232: a1 := JTF_NUMBER_TABLE();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_NUMBER_TABLE();
235: a4 := JTF_VARCHAR2_TABLE_100();
236: a5 := JTF_VARCHAR2_TABLE_100();
237: a6 := JTF_NUMBER_TABLE();
238: if t.count > 0 then
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_NUMBER_TABLE();
235: a4 := JTF_VARCHAR2_TABLE_100();
236: a5 := JTF_VARCHAR2_TABLE_100();
237: a6 := JTF_NUMBER_TABLE();
238: if t.count > 0 then
239: a0.extend(t.count);
240: a1.extend(t.count);
241: a2.extend(t.count);
262: end if;
263: end if;
264: end rosetta_table_copy_out_p7;
265:
266: procedure rosetta_table_copy_in_p8(t out nocopy okc_terms_multirec_grp.article_id_tbl_type, a0 JTF_NUMBER_TABLE) as
267: ddindx binary_integer; indx binary_integer;
268: begin
269: if a0 is not null and a0.count > 0 then
270: if a0.count > 0 then
280: end loop;
281: end if;
282: end if;
283: end rosetta_table_copy_in_p8;
284: procedure rosetta_table_copy_out_p8(t okc_terms_multirec_grp.article_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
285: ddindx binary_integer; indx binary_integer;
286: begin
287: if t is null or t.count = 0 then
288: a0 := JTF_NUMBER_TABLE();
284: procedure rosetta_table_copy_out_p8(t okc_terms_multirec_grp.article_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
285: ddindx binary_integer; indx binary_integer;
286: begin
287: if t is null or t.count = 0 then
288: a0 := JTF_NUMBER_TABLE();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: if t.count > 0 then
292: a0.extend(t.count);
286: begin
287: if t is null or t.count = 0 then
288: a0 := JTF_NUMBER_TABLE();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: if t.count > 0 then
292: a0.extend(t.count);
293: ddindx := t.first;
294: indx := 1;
303: end if;
304: end if;
305: end rosetta_table_copy_out_p8;
306:
307: procedure rosetta_table_copy_in_p9(t out nocopy okc_terms_multirec_grp.article_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_NUMBER_TABLE
309: , a2 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
304: end if;
305: end rosetta_table_copy_out_p8;
306:
307: procedure rosetta_table_copy_in_p9(t out nocopy okc_terms_multirec_grp.article_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_NUMBER_TABLE
309: , a2 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
312: begin
305: end rosetta_table_copy_out_p8;
306:
307: procedure rosetta_table_copy_in_p9(t out nocopy okc_terms_multirec_grp.article_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_NUMBER_TABLE
309: , a2 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
312: begin
313: if a0 is not null and a0.count > 0 then
326: end loop;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p9;
330: procedure rosetta_table_copy_out_p9(t okc_terms_multirec_grp.article_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: ) as
334: ddindx binary_integer; indx binary_integer;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p9;
330: procedure rosetta_table_copy_out_p9(t okc_terms_multirec_grp.article_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin
328: end if;
329: end rosetta_table_copy_in_p9;
330: procedure rosetta_table_copy_out_p9(t okc_terms_multirec_grp.article_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin
336: if t is null or t.count = 0 then
333: ) as
334: ddindx binary_integer; indx binary_integer;
335: begin
336: if t is null or t.count = 0 then
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
334: ddindx binary_integer; indx binary_integer;
335: begin
336: if t is null or t.count = 0 then
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: a1 := JTF_NUMBER_TABLE();
335: begin
336: if t is null or t.count = 0 then
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_NUMBER_TABLE();
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_NUMBER_TABLE();
344: if t.count > 0 then
345: a0.extend(t.count);
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_NUMBER_TABLE();
344: if t.count > 0 then
345: a0.extend(t.count);
346: a1.extend(t.count);
339: a2 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_NUMBER_TABLE();
344: if t.count > 0 then
345: a0.extend(t.count);
346: a1.extend(t.count);
347: a2.extend(t.count);
361: end if;
362: end rosetta_table_copy_out_p9;
363:
364: procedure rosetta_table_copy_in_p10(t out nocopy okc_terms_multirec_grp.organize_tbl_type, a0 JTF_VARCHAR2_TABLE_100
365: , a1 JTF_NUMBER_TABLE
366: ) as
367: ddindx binary_integer; indx binary_integer;
368: begin
369: if a0 is not null and a0.count > 0 then
382: end if;
383: end if;
384: end rosetta_table_copy_in_p10;
385: procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
386: , a1 out nocopy JTF_NUMBER_TABLE
387: ) as
388: ddindx binary_integer; indx binary_integer;
389: begin
390: if t is null or t.count = 0 then
388: ddindx binary_integer; indx binary_integer;
389: begin
390: if t is null or t.count = 0 then
391: a0 := JTF_VARCHAR2_TABLE_100();
392: a1 := JTF_NUMBER_TABLE();
393: else
394: a0 := JTF_VARCHAR2_TABLE_100();
395: a1 := JTF_NUMBER_TABLE();
396: if t.count > 0 then
391: a0 := JTF_VARCHAR2_TABLE_100();
392: a1 := JTF_NUMBER_TABLE();
393: else
394: a0 := JTF_VARCHAR2_TABLE_100();
395: a1 := JTF_NUMBER_TABLE();
396: if t.count > 0 then
397: a0.extend(t.count);
398: a1.extend(t.count);
399: ddindx := t.first;
421: , p_ref_type VARCHAR2
422: , p_ref_id NUMBER
423: , p_doc_type VARCHAR2
424: , p_doc_id NUMBER
425: , p11_a0 JTF_NUMBER_TABLE
426: , p11_a1 JTF_NUMBER_TABLE
427: , p11_a2 JTF_NUMBER_TABLE
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
422: , p_ref_id NUMBER
423: , p_doc_type VARCHAR2
424: , p_doc_id NUMBER
425: , p11_a0 JTF_NUMBER_TABLE
426: , p11_a1 JTF_NUMBER_TABLE
427: , p11_a2 JTF_NUMBER_TABLE
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
423: , p_doc_type VARCHAR2
424: , p_doc_id NUMBER
425: , p11_a0 JTF_NUMBER_TABLE
426: , p11_a1 JTF_NUMBER_TABLE
427: , p11_a2 JTF_NUMBER_TABLE
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
426: , p11_a1 JTF_NUMBER_TABLE
427: , p11_a2 JTF_NUMBER_TABLE
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
432: , p12_a0 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
427: , p11_a2 JTF_NUMBER_TABLE
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
432: , p12_a0 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
428: , p11_a3 JTF_VARCHAR2_TABLE_2000
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
432: , p12_a0 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
429: , p11_a4 JTF_VARCHAR2_TABLE_100
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
432: , p12_a0 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
437: , p12_a5 out nocopy JTF_NUMBER_TABLE
430: , p11_a5 JTF_NUMBER_TABLE
431: , p11_a6 JTF_NUMBER_TABLE
432: , p12_a0 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
437: , p12_a5 out nocopy JTF_NUMBER_TABLE
438: , p12_a6 out nocopy JTF_NUMBER_TABLE
433: , p12_a1 out nocopy JTF_NUMBER_TABLE
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
437: , p12_a5 out nocopy JTF_NUMBER_TABLE
438: , p12_a6 out nocopy JTF_NUMBER_TABLE
439: , x_return_status out nocopy VARCHAR2
440: , x_msg_count out nocopy NUMBER
441: , x_msg_data out nocopy VARCHAR2
434: , p12_a2 out nocopy JTF_NUMBER_TABLE
435: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
437: , p12_a5 out nocopy JTF_NUMBER_TABLE
438: , p12_a6 out nocopy JTF_NUMBER_TABLE
439: , x_return_status out nocopy VARCHAR2
440: , x_msg_count out nocopy NUMBER
441: , x_msg_data out nocopy VARCHAR2
442: )
521: , p_validation_level NUMBER
522: , p_validate_commit VARCHAR2
523: , p_validation_string VARCHAR2
524: , p_commit VARCHAR2
525: , p6_a0 JTF_NUMBER_TABLE
526: , p6_a1 JTF_VARCHAR2_TABLE_100
527: , p6_a2 JTF_VARCHAR2_TABLE_100
528: , p6_a3 JTF_VARCHAR2_TABLE_100
529: , p6_a4 JTF_VARCHAR2_TABLE_100
527: , p6_a2 JTF_VARCHAR2_TABLE_100
528: , p6_a3 JTF_VARCHAR2_TABLE_100
529: , p6_a4 JTF_VARCHAR2_TABLE_100
530: , p6_a5 JTF_VARCHAR2_TABLE_2000
531: , p6_a6 JTF_NUMBER_TABLE
532: , p6_a7 JTF_NUMBER_TABLE
533: , p_mode VARCHAR2
534: , x_return_status out nocopy VARCHAR2
535: , x_msg_count out nocopy NUMBER
528: , p6_a3 JTF_VARCHAR2_TABLE_100
529: , p6_a4 JTF_VARCHAR2_TABLE_100
530: , p6_a5 JTF_VARCHAR2_TABLE_2000
531: , p6_a6 JTF_NUMBER_TABLE
532: , p6_a7 JTF_NUMBER_TABLE
533: , p_mode VARCHAR2
534: , x_return_status out nocopy VARCHAR2
535: , x_msg_count out nocopy NUMBER
536: , x_msg_data out nocopy VARCHAR2
594: , p_validate_commit VARCHAR2
595: , p_validation_string VARCHAR2
596: , p_commit VARCHAR2
597: , p6_a0 JTF_VARCHAR2_TABLE_100
598: , p6_a1 JTF_NUMBER_TABLE
599: , p6_a2 JTF_NUMBER_TABLE
600: , p6_a3 JTF_NUMBER_TABLE
601: , p6_a4 JTF_VARCHAR2_TABLE_100
602: , p6_a5 JTF_VARCHAR2_TABLE_100
595: , p_validation_string VARCHAR2
596: , p_commit VARCHAR2
597: , p6_a0 JTF_VARCHAR2_TABLE_100
598: , p6_a1 JTF_NUMBER_TABLE
599: , p6_a2 JTF_NUMBER_TABLE
600: , p6_a3 JTF_NUMBER_TABLE
601: , p6_a4 JTF_VARCHAR2_TABLE_100
602: , p6_a5 JTF_VARCHAR2_TABLE_100
603: , p6_a6 JTF_NUMBER_TABLE
596: , p_commit VARCHAR2
597: , p6_a0 JTF_VARCHAR2_TABLE_100
598: , p6_a1 JTF_NUMBER_TABLE
599: , p6_a2 JTF_NUMBER_TABLE
600: , p6_a3 JTF_NUMBER_TABLE
601: , p6_a4 JTF_VARCHAR2_TABLE_100
602: , p6_a5 JTF_VARCHAR2_TABLE_100
603: , p6_a6 JTF_NUMBER_TABLE
604: , x_return_status out nocopy VARCHAR2
599: , p6_a2 JTF_NUMBER_TABLE
600: , p6_a3 JTF_NUMBER_TABLE
601: , p6_a4 JTF_VARCHAR2_TABLE_100
602: , p6_a5 JTF_VARCHAR2_TABLE_100
603: , p6_a6 JTF_NUMBER_TABLE
604: , x_return_status out nocopy VARCHAR2
605: , x_msg_count out nocopy NUMBER
606: , x_msg_data out nocopy VARCHAR2
607: )
660: , p_validation_string VARCHAR2
661: , p_commit VARCHAR2
662: , p_doc_type VARCHAR2
663: , p_doc_id NUMBER
664: , p_article_id_tbl JTF_NUMBER_TABLE
665: , p_mode VARCHAR2
666: , x_articles_dropped out nocopy NUMBER
667: , x_return_status out nocopy VARCHAR2
668: , x_msg_count out nocopy NUMBER
726: , p_commit VARCHAR2
727: , p_mode VARCHAR2
728: , p_doc_type VARCHAR2
729: , p_doc_id NUMBER
730: , p8_a0 JTF_NUMBER_TABLE
731: , p8_a1 JTF_NUMBER_TABLE
732: , p8_a2 JTF_NUMBER_TABLE
733: , x_return_status out nocopy VARCHAR2
734: , x_msg_count out nocopy NUMBER
727: , p_mode VARCHAR2
728: , p_doc_type VARCHAR2
729: , p_doc_id NUMBER
730: , p8_a0 JTF_NUMBER_TABLE
731: , p8_a1 JTF_NUMBER_TABLE
732: , p8_a2 JTF_NUMBER_TABLE
733: , x_return_status out nocopy VARCHAR2
734: , x_msg_count out nocopy NUMBER
735: , x_msg_data out nocopy VARCHAR2
728: , p_doc_type VARCHAR2
729: , p_doc_id NUMBER
730: , p8_a0 JTF_NUMBER_TABLE
731: , p8_a1 JTF_NUMBER_TABLE
732: , p8_a2 JTF_NUMBER_TABLE
733: , x_return_status out nocopy VARCHAR2
734: , x_msg_count out nocopy NUMBER
735: , x_msg_data out nocopy VARCHAR2
736: )
791: , p_validate_commit VARCHAR2
792: , p_validation_string VARCHAR2
793: , p_commit VARCHAR2
794: , p6_a0 JTF_VARCHAR2_TABLE_100
795: , p6_a1 JTF_NUMBER_TABLE
796: , p_ref_point VARCHAR2
797: , p_doc_type VARCHAR2
798: , p_doc_id NUMBER
799: , p_to_object_type VARCHAR2
862: end;
863:
864:
865: procedure rosetta_table_copy_in_p11(t out nocopy okc_terms_multirec_grp.merge_review_tbl_type, a0 JTF_VARCHAR2_TABLE_100
866: , a1 JTF_NUMBER_TABLE, a2 JTF_NUMBER_TABLE
867: ) as
868: ddindx binary_integer; indx binary_integer;
869: begin
870: if a0 is not null and a0.count > 0 then
891: , p_validate_commit VARCHAR2
892: , p_validation_string VARCHAR2
893: , p_commit VARCHAR2
894: , p6_a0 JTF_VARCHAR2_TABLE_100
895: , p6_a1 JTF_NUMBER_TABLE
896: , p6_a2 JTF_NUMBER_TABLE
897: , p_doc_type VARCHAR2
898: , p_doc_id NUMBER
899: , x_return_status out nocopy VARCHAR2
892: , p_validation_string VARCHAR2
893: , p_commit VARCHAR2
894: , p6_a0 JTF_VARCHAR2_TABLE_100
895: , p6_a1 JTF_NUMBER_TABLE
896: , p6_a2 JTF_NUMBER_TABLE
897: , p_doc_type VARCHAR2
898: , p_doc_id NUMBER
899: , x_return_status out nocopy VARCHAR2
900: , x_msg_count out nocopy NUMBER