APPS.IBE_DELIVERABLE_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

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

Line 25: , a3 JTF_VARCHAR2_TABLE_100

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

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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

Line 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

Line 58: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 60: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 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

Line 71: a1 := JTF_VARCHAR2_TABLE_100();

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();

Line 73: a3 := JTF_VARCHAR2_TABLE_100();

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();

Line 74: a4 := JTF_VARCHAR2_TABLE_100();

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();

Line 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();

Line 81: a1 := JTF_VARCHAR2_TABLE_100();

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();

Line 83: a3 := 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();
87: a7 := JTF_NUMBER_TABLE();

Line 84: a4 := JTF_VARCHAR2_TABLE_100();

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();

Line 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);

Line 122: , a1 JTF_VARCHAR2_TABLE_100

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

Line 124: , a3 JTF_VARCHAR2_TABLE_100

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

Line 125: , a4 JTF_VARCHAR2_TABLE_100

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

Line 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

Line 132: , a11 JTF_VARCHAR2_TABLE_100

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

Line 163: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 165: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 166: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 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

Line 173: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 179: a1 := JTF_VARCHAR2_TABLE_100();

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();

Line 181: a3 := JTF_VARCHAR2_TABLE_100();

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();

Line 182: a4 := JTF_VARCHAR2_TABLE_100();

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();

Line 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

Line 189: a11 := JTF_VARCHAR2_TABLE_100();

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();

Line 192: a1 := JTF_VARCHAR2_TABLE_100();

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();

Line 194: a3 := 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();
198: a7 := JTF_NUMBER_TABLE();

Line 195: a4 := JTF_VARCHAR2_TABLE_100();

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();

Line 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

Line 202: a11 := JTF_VARCHAR2_TABLE_100();

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);

Line 244: , a3 JTF_VARCHAR2_TABLE_100

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

Line 269: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 277: a3 := JTF_VARCHAR2_TABLE_100();

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();

Line 282: 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);
285: a1.extend(t.count);
286: a2.extend(t.count);

Line 354: procedure rosetta_table_copy_in_p7(t out nocopy ibe_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as

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;

Line 378: procedure rosetta_table_copy_out_p7(t ibe_deliverable_grp.varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

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;

Line 384: a0 := JTF_VARCHAR2_TABLE_100();

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);

Line 386: a0 := JTF_VARCHAR2_TABLE_100();

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;

Line 514: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 516: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 517: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 634: , x_acc_name_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 636: , x_item_type_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 637: , x_appl_to_tbl out nocopy JTF_VARCHAR2_TABLE_100

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

Line 816: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 818: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 819: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 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;

Line 959: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 961: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 962: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 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: )

Line 969: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100

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;

Line 1038: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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;