APPS.JTF_DELIVERABLE_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out jtf_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 jtf_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 jtf_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 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 jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300

Line 60: , a3 out JTF_VARCHAR2_TABLE_100

56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300
63: , a6 out JTF_VARCHAR2_TABLE_2000
64: , a7 out JTF_NUMBER_TABLE

Line 61: , a4 out JTF_VARCHAR2_TABLE_100

57: procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300
63: , a6 out JTF_VARCHAR2_TABLE_2000
64: , a7 out JTF_NUMBER_TABLE
65: , a8 out JTF_VARCHAR2_TABLE_100

Line 65: , a8 out JTF_VARCHAR2_TABLE_100

61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300
63: , a6 out JTF_VARCHAR2_TABLE_2000
64: , a7 out JTF_NUMBER_TABLE
65: , a8 out 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 jtf_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 jtf_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 jtf_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 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 jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300

Line 165: , a3 out JTF_VARCHAR2_TABLE_100

161: end rosetta_table_copy_in_p3;
162: procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000
169: , a7 out JTF_NUMBER_TABLE

Line 166: , a4 out JTF_VARCHAR2_TABLE_100

162: procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000
169: , a7 out JTF_NUMBER_TABLE
170: , a8 out JTF_VARCHAR2_TABLE_100

Line 170: , a8 out JTF_VARCHAR2_TABLE_100

166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000
169: , a7 out JTF_NUMBER_TABLE
170: , a8 out JTF_VARCHAR2_TABLE_100
171: , a9 out JTF_VARCHAR2_TABLE_300
172: , a10 out JTF_NUMBER_TABLE
173: , a11 out JTF_VARCHAR2_TABLE_100
174: ) as

Line 173: , a11 out JTF_VARCHAR2_TABLE_100

169: , a7 out JTF_NUMBER_TABLE
170: , a8 out JTF_VARCHAR2_TABLE_100
171: , a9 out JTF_VARCHAR2_TABLE_300
172: , a10 out JTF_NUMBER_TABLE
173: , a11 out 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 jtf_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 JTF_VARCHAR2_TABLE_100

265: end rosetta_table_copy_in_p5;
266: procedure rosetta_table_copy_out_p5(t jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
267: , a1 out JTF_VARCHAR2_TABLE_300
268: , a2 out JTF_NUMBER_TABLE
269: , a3 out 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 jtf_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 jtf_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 jtf_deliverable_grp.varchar2_table_100, a0 out 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 jtf_deliverable_grp.varchar2_table_100, a0 out 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 JTF_VARCHAR2_TABLE_100

510: , p_start_id NUMBER
511: , p_batch_size NUMBER
512: , x_row_count out NUMBER
513: , x_dlv_id_tbl out JTF_NUMBER_TABLE
514: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300

Line 516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100

512: , x_row_count out NUMBER
513: , x_dlv_id_tbl out JTF_NUMBER_TABLE
514: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out JTF_NUMBER_TABLE

Line 517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100

513: , x_dlv_id_tbl out JTF_NUMBER_TABLE
514: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out JTF_NUMBER_TABLE
521: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

Line 633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100

629: , p_start_id NUMBER
630: , p_batch_size NUMBER
631: , x_row_count out NUMBER
632: , x_dlv_id_tbl out JTF_NUMBER_TABLE
633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300

Line 635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100

631: , x_row_count out NUMBER
632: , x_dlv_id_tbl out JTF_NUMBER_TABLE
633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
638: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
639: , x_version_tbl out JTF_NUMBER_TABLE

Line 636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100

632: , x_dlv_id_tbl out JTF_NUMBER_TABLE
633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
638: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
639: , x_version_tbl out JTF_NUMBER_TABLE
640: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

Line 813: , p6_a1 in out JTF_VARCHAR2_TABLE_100

809: , x_return_status out VARCHAR2
810: , x_msg_count out NUMBER
811: , x_msg_data out VARCHAR2
812: , p6_a0 in out JTF_NUMBER_TABLE
813: , p6_a1 in out JTF_VARCHAR2_TABLE_100
814: , p6_a2 in out JTF_VARCHAR2_TABLE_300
815: , p6_a3 in out JTF_VARCHAR2_TABLE_100
816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300

Line 815: , p6_a3 in out JTF_VARCHAR2_TABLE_100

811: , x_msg_data out VARCHAR2
812: , p6_a0 in out JTF_NUMBER_TABLE
813: , p6_a1 in out JTF_VARCHAR2_TABLE_100
814: , p6_a2 in out JTF_VARCHAR2_TABLE_300
815: , p6_a3 in out JTF_VARCHAR2_TABLE_100
816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300
818: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
819: , p6_a7 in out JTF_NUMBER_TABLE

Line 816: , p6_a4 in out JTF_VARCHAR2_TABLE_100

812: , p6_a0 in out JTF_NUMBER_TABLE
813: , p6_a1 in out JTF_VARCHAR2_TABLE_100
814: , p6_a2 in out JTF_VARCHAR2_TABLE_300
815: , p6_a3 in out JTF_VARCHAR2_TABLE_100
816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300
818: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
819: , p6_a7 in out JTF_NUMBER_TABLE
820: , p6_a8 in out JTF_VARCHAR2_TABLE_100

Line 820: , p6_a8 in out JTF_VARCHAR2_TABLE_100

816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300
818: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
819: , p6_a7 in out JTF_NUMBER_TABLE
820: , p6_a8 in out JTF_VARCHAR2_TABLE_100
821: )
822: as
823: ddp_deliverable_tbl jtf_deliverable_grp.deliverable_tbl_type;
824: ddindx binary_integer; indx binary_integer;

Line 954: , p6_a1 in out JTF_VARCHAR2_TABLE_100

950: , x_return_status out VARCHAR2
951: , x_msg_count out NUMBER
952: , x_msg_data out VARCHAR2
953: , p6_a0 in out JTF_NUMBER_TABLE
954: , p6_a1 in out JTF_VARCHAR2_TABLE_100
955: , p6_a2 in out JTF_VARCHAR2_TABLE_300
956: , p6_a3 in out JTF_VARCHAR2_TABLE_100
957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300

Line 956: , p6_a3 in out JTF_VARCHAR2_TABLE_100

952: , x_msg_data out VARCHAR2
953: , p6_a0 in out JTF_NUMBER_TABLE
954: , p6_a1 in out JTF_VARCHAR2_TABLE_100
955: , p6_a2 in out JTF_VARCHAR2_TABLE_300
956: , p6_a3 in out JTF_VARCHAR2_TABLE_100
957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
960: , p6_a7 in out JTF_NUMBER_TABLE

Line 957: , p6_a4 in out JTF_VARCHAR2_TABLE_100

953: , p6_a0 in out JTF_NUMBER_TABLE
954: , p6_a1 in out JTF_VARCHAR2_TABLE_100
955: , p6_a2 in out JTF_VARCHAR2_TABLE_300
956: , p6_a3 in out JTF_VARCHAR2_TABLE_100
957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
960: , p6_a7 in out JTF_NUMBER_TABLE
961: , p6_a8 in out JTF_VARCHAR2_TABLE_100

Line 961: , p6_a8 in out JTF_VARCHAR2_TABLE_100

957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
960: , p6_a7 in out JTF_NUMBER_TABLE
961: , p6_a8 in out JTF_VARCHAR2_TABLE_100
962: , p6_a9 in out JTF_VARCHAR2_TABLE_300
963: , p6_a10 in out JTF_NUMBER_TABLE
964: , p6_a11 in out JTF_VARCHAR2_TABLE_100
965: )

Line 964: , p6_a11 in out JTF_VARCHAR2_TABLE_100

960: , p6_a7 in out JTF_NUMBER_TABLE
961: , p6_a8 in out JTF_VARCHAR2_TABLE_100
962: , p6_a9 in out JTF_VARCHAR2_TABLE_300
963: , p6_a10 in out JTF_NUMBER_TABLE
964: , p6_a11 in out JTF_VARCHAR2_TABLE_100
965: )
966: as
967: ddp_dlv_ath_tbl jtf_deliverable_grp.dlv_ath_tbl_type;
968: ddindx binary_integer; indx binary_integer;

Line 1032: , p6_a3 in out JTF_VARCHAR2_TABLE_100

1028: , x_msg_data out VARCHAR2
1029: , p6_a0 in out JTF_NUMBER_TABLE
1030: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1031: , p6_a2 in out JTF_NUMBER_TABLE
1032: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1033: )
1034: as
1035: ddp_dlv_id_ver_tbl jtf_deliverable_grp.dlv_id_ver_tbl_type;
1036: ddindx binary_integer; indx binary_integer;