19: return n;
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
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
29: , a7 JTF_NUMBER_TABLE
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
29: , a7 JTF_NUMBER_TABLE
30: , a8 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
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then
54: end if;
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
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
64: , a7 out nocopy JTF_NUMBER_TABLE
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
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 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
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
67: ddindx binary_integer; indx binary_integer;
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();
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();
77: a7 := JTF_NUMBER_TABLE();
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();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := 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
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_300();
77: a7 := JTF_NUMBER_TABLE();
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();
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();
87: a7 := JTF_NUMBER_TABLE();
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();
87: a7 := JTF_NUMBER_TABLE();
88: a8 := 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
90: a0.extend(t.count);
91: a1.extend(t.count);
92: a2.extend(t.count);
118: end if;
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
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
128: , a7 JTF_NUMBER_TABLE
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
128: , a7 JTF_NUMBER_TABLE
129: , a8 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
131: , a10 JTF_NUMBER_TABLE
132: , a11 JTF_VARCHAR2_TABLE_100
133: ) as
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;
135: begin
136: if a0 is not null and a0.count > 0 then
159: end if;
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
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
169: , a7 out nocopy JTF_NUMBER_TABLE
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
169: , a7 out nocopy JTF_NUMBER_TABLE
170: , a8 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
172: , a10 out nocopy JTF_NUMBER_TABLE
173: , a11 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
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
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();
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();
185: a7 := JTF_NUMBER_TABLE();
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();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := 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();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: else
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();
192: a1 := JTF_VARCHAR2_TABLE_100();
193: a2 := JTF_VARCHAR2_TABLE_300();
188: a10 := 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();
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();
198: a7 := JTF_NUMBER_TABLE();
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();
198: a7 := JTF_NUMBER_TABLE();
199: a8 := 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();
201: a10 := JTF_NUMBER_TABLE();
202: a11 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
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);
205: a1.extend(t.count);
206: a2.extend(t.count);
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;
247: begin
248: if a0 is not null and a0.count > 0 then
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;
272: begin
273: if t is null or t.count = 0 then
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();
280: a1 := JTF_VARCHAR2_TABLE_300();
281: a2 := JTF_NUMBER_TABLE();
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);
285: a1.extend(t.count);
286: a2.extend(t.count);
350: end if;
351: end if;
352: end rosetta_table_copy_out_p6;
353:
354: procedure rosetta_table_copy_in_p7(t out nocopy ibe_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as
355: ddindx binary_integer; indx binary_integer;
356: begin
357: if a0 is null then
358: t := null;
374: end loop;
375: end if;
376: end if;
377: end rosetta_table_copy_in_p7;
378: procedure rosetta_table_copy_out_p7(t ibe_deliverable_grp.varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
379: ddindx binary_integer; indx binary_integer;
380: begin
381: if t is null then
382: a0 := null;
380: begin
381: if t is null then
382: a0 := null;
383: elsif t.count = 0 then
384: a0 := JTF_VARCHAR2_TABLE_100();
385: else
386: a0 := JTF_VARCHAR2_TABLE_100();
387: if t.count > 0 then
388: a0.extend(t.count);
382: a0 := null;
383: elsif t.count = 0 then
384: a0 := JTF_VARCHAR2_TABLE_100();
385: else
386: a0 := JTF_VARCHAR2_TABLE_100();
387: if t.count > 0 then
388: a0.extend(t.count);
389: ddindx := t.first;
390: indx := 1;
510: , p_start_id NUMBER
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
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
520: , x_version_tbl out nocopy JTF_NUMBER_TABLE
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
520: , x_version_tbl out nocopy JTF_NUMBER_TABLE
521: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
630: , p_start_id NUMBER
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
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
640: , x_version_tbl out nocopy JTF_NUMBER_TABLE
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
640: , x_version_tbl out nocopy JTF_NUMBER_TABLE
641: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
812: , x_return_status out nocopy VARCHAR2
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
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
822: , p6_a7 in out nocopy JTF_NUMBER_TABLE
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
822: , p6_a7 in out nocopy JTF_NUMBER_TABLE
823: , p6_a8 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: )
825:
826: as
827: ddp_deliverable_tbl ibe_deliverable_grp.deliverable_tbl_type;
955: , x_return_status out nocopy VARCHAR2
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
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
965: , p6_a7 in out nocopy JTF_NUMBER_TABLE
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
965: , p6_a7 in out nocopy JTF_NUMBER_TABLE
966: , p6_a8 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
968: , p6_a10 in out nocopy JTF_NUMBER_TABLE
969: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
970: )
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:
972: as
973: ddp_dlv_ath_tbl ibe_deliverable_grp.dlv_ath_tbl_type;
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:
1041: as
1042: ddp_dlv_id_ver_tbl ibe_deliverable_grp.dlv_id_ver_tbl_type;