DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB_W dependencies on JTF_NUMBER_TABLE

Line 71: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

67: end if;
68: end if;
69: end rosetta_table_copy_out_p0;
70:
71: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is null then
75: t := null;

Line 95: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p1;
95: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null then
99: a0 := null;

Line 101: a0 := JTF_NUMBER_TABLE();

97: begin
98: if t is null then
99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);

Line 103: a0 := JTF_NUMBER_TABLE();

99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);
106: ddindx := t.first;
107: indx := 1;

Line 120: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_out_p1;
119:
120: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_DATE_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE

Line 121: , a1 JTF_NUMBER_TABLE

117: end if;
118: end rosetta_table_copy_out_p1;
119:
120: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_DATE_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE
125: , a5 JTF_NUMBER_TABLE

Line 123: , a3 JTF_NUMBER_TABLE

119:
120: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_DATE_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE
125: , a5 JTF_NUMBER_TABLE
126: , a6 JTF_NUMBER_TABLE
127: , a7 JTF_NUMBER_TABLE

Line 125: , a5 JTF_NUMBER_TABLE

121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_DATE_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE
125: , a5 JTF_NUMBER_TABLE
126: , a6 JTF_NUMBER_TABLE
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_300

Line 126: , a6 JTF_NUMBER_TABLE

122: , a2 JTF_DATE_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE
125: , a5 JTF_NUMBER_TABLE
126: , a6 JTF_NUMBER_TABLE
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_300
130: , a10 JTF_VARCHAR2_TABLE_2000

Line 127: , a7 JTF_NUMBER_TABLE

123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_DATE_TABLE
125: , a5 JTF_NUMBER_TABLE
126: , a6 JTF_NUMBER_TABLE
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_300
130: , a10 JTF_VARCHAR2_TABLE_2000
131: , a11 JTF_VARCHAR2_TABLE_2000

Line 140: , a20 JTF_NUMBER_TABLE

136: , a16 JTF_VARCHAR2_TABLE_300
137: , a17 JTF_VARCHAR2_TABLE_2000
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_VARCHAR2_TABLE_100
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_NUMBER_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_VARCHAR2_TABLE_300
144: , a24 JTF_VARCHAR2_TABLE_2000

Line 141: , a21 JTF_NUMBER_TABLE

137: , a17 JTF_VARCHAR2_TABLE_2000
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_VARCHAR2_TABLE_100
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_NUMBER_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_VARCHAR2_TABLE_300
144: , a24 JTF_VARCHAR2_TABLE_2000
145: , a25 JTF_VARCHAR2_TABLE_2000

Line 142: , a22 JTF_NUMBER_TABLE

138: , a18 JTF_DATE_TABLE
139: , a19 JTF_VARCHAR2_TABLE_100
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_NUMBER_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_VARCHAR2_TABLE_300
144: , a24 JTF_VARCHAR2_TABLE_2000
145: , a25 JTF_VARCHAR2_TABLE_2000
146: , a26 JTF_VARCHAR2_TABLE_2000

Line 199: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

195: end loop;
196: end if;
197: end if;
198: end rosetta_table_copy_in_p6;
199: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_DATE_TABLE
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE

Line 200: , a1 out nocopy JTF_NUMBER_TABLE

196: end if;
197: end if;
198: end rosetta_table_copy_in_p6;
199: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_DATE_TABLE
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE

Line 202: , a3 out nocopy JTF_NUMBER_TABLE

198: end rosetta_table_copy_in_p6;
199: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_DATE_TABLE
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE
206: , a7 out nocopy JTF_NUMBER_TABLE

Line 204: , a5 out nocopy JTF_NUMBER_TABLE

200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_DATE_TABLE
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE
206: , a7 out nocopy JTF_NUMBER_TABLE
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 205: , a6 out nocopy JTF_NUMBER_TABLE

201: , a2 out nocopy JTF_DATE_TABLE
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE
206: , a7 out nocopy JTF_NUMBER_TABLE
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_300
209: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 206: , a7 out nocopy JTF_NUMBER_TABLE

202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_DATE_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE
206: , a7 out nocopy JTF_NUMBER_TABLE
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_300
209: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
210: , a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 219: , a20 out nocopy JTF_NUMBER_TABLE

215: , a16 out nocopy JTF_VARCHAR2_TABLE_300
216: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
217: , a18 out nocopy JTF_DATE_TABLE
218: , a19 out nocopy JTF_VARCHAR2_TABLE_100
219: , a20 out nocopy JTF_NUMBER_TABLE
220: , a21 out nocopy JTF_NUMBER_TABLE
221: , a22 out nocopy JTF_NUMBER_TABLE
222: , a23 out nocopy JTF_VARCHAR2_TABLE_300
223: , a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 220: , a21 out nocopy JTF_NUMBER_TABLE

216: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
217: , a18 out nocopy JTF_DATE_TABLE
218: , a19 out nocopy JTF_VARCHAR2_TABLE_100
219: , a20 out nocopy JTF_NUMBER_TABLE
220: , a21 out nocopy JTF_NUMBER_TABLE
221: , a22 out nocopy JTF_NUMBER_TABLE
222: , a23 out nocopy JTF_VARCHAR2_TABLE_300
223: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
224: , a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 221: , a22 out nocopy JTF_NUMBER_TABLE

217: , a18 out nocopy JTF_DATE_TABLE
218: , a19 out nocopy JTF_VARCHAR2_TABLE_100
219: , a20 out nocopy JTF_NUMBER_TABLE
220: , a21 out nocopy JTF_NUMBER_TABLE
221: , a22 out nocopy JTF_NUMBER_TABLE
222: , a23 out nocopy JTF_VARCHAR2_TABLE_300
223: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
224: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
225: , a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 262: a0 := JTF_NUMBER_TABLE();

258: a26 := null;
259: a27 := null;
260: a28 := null;
261: elsif t.count = 0 then
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_DATE_TABLE();
265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();

Line 263: a1 := JTF_NUMBER_TABLE();

259: a27 := null;
260: a28 := null;
261: elsif t.count = 0 then
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_DATE_TABLE();
265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();
267: a5 := JTF_NUMBER_TABLE();

Line 265: a3 := JTF_NUMBER_TABLE();

261: elsif t.count = 0 then
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_DATE_TABLE();
265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();
267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_NUMBER_TABLE();
269: a7 := JTF_NUMBER_TABLE();

Line 267: a5 := JTF_NUMBER_TABLE();

263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_DATE_TABLE();
265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();
267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_NUMBER_TABLE();
269: a7 := JTF_NUMBER_TABLE();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_300();

Line 268: a6 := JTF_NUMBER_TABLE();

264: a2 := JTF_DATE_TABLE();
265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();
267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_NUMBER_TABLE();
269: a7 := JTF_NUMBER_TABLE();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_300();
272: a10 := JTF_VARCHAR2_TABLE_2000();

Line 269: a7 := JTF_NUMBER_TABLE();

265: a3 := JTF_NUMBER_TABLE();
266: a4 := JTF_DATE_TABLE();
267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_NUMBER_TABLE();
269: a7 := JTF_NUMBER_TABLE();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_300();
272: a10 := JTF_VARCHAR2_TABLE_2000();
273: a11 := JTF_VARCHAR2_TABLE_2000();

Line 282: a20 := JTF_NUMBER_TABLE();

278: a16 := JTF_VARCHAR2_TABLE_300();
279: a17 := JTF_VARCHAR2_TABLE_2000();
280: a18 := JTF_DATE_TABLE();
281: a19 := JTF_VARCHAR2_TABLE_100();
282: a20 := JTF_NUMBER_TABLE();
283: a21 := JTF_NUMBER_TABLE();
284: a22 := JTF_NUMBER_TABLE();
285: a23 := JTF_VARCHAR2_TABLE_300();
286: a24 := JTF_VARCHAR2_TABLE_2000();

Line 283: a21 := JTF_NUMBER_TABLE();

279: a17 := JTF_VARCHAR2_TABLE_2000();
280: a18 := JTF_DATE_TABLE();
281: a19 := JTF_VARCHAR2_TABLE_100();
282: a20 := JTF_NUMBER_TABLE();
283: a21 := JTF_NUMBER_TABLE();
284: a22 := JTF_NUMBER_TABLE();
285: a23 := JTF_VARCHAR2_TABLE_300();
286: a24 := JTF_VARCHAR2_TABLE_2000();
287: a25 := JTF_VARCHAR2_TABLE_2000();

Line 284: a22 := JTF_NUMBER_TABLE();

280: a18 := JTF_DATE_TABLE();
281: a19 := JTF_VARCHAR2_TABLE_100();
282: a20 := JTF_NUMBER_TABLE();
283: a21 := JTF_NUMBER_TABLE();
284: a22 := JTF_NUMBER_TABLE();
285: a23 := JTF_VARCHAR2_TABLE_300();
286: a24 := JTF_VARCHAR2_TABLE_2000();
287: a25 := JTF_VARCHAR2_TABLE_2000();
288: a26 := JTF_VARCHAR2_TABLE_2000();

Line 292: a0 := JTF_NUMBER_TABLE();

288: a26 := JTF_VARCHAR2_TABLE_2000();
289: a27 := JTF_VARCHAR2_TABLE_2000();
290: a28 := JTF_VARCHAR2_TABLE_2000();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_DATE_TABLE();
295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();

Line 293: a1 := JTF_NUMBER_TABLE();

289: a27 := JTF_VARCHAR2_TABLE_2000();
290: a28 := JTF_VARCHAR2_TABLE_2000();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_DATE_TABLE();
295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_NUMBER_TABLE();

Line 295: a3 := JTF_NUMBER_TABLE();

291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_DATE_TABLE();
295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_NUMBER_TABLE();
298: a6 := JTF_NUMBER_TABLE();
299: a7 := JTF_NUMBER_TABLE();

Line 297: a5 := JTF_NUMBER_TABLE();

293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_DATE_TABLE();
295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_NUMBER_TABLE();
298: a6 := JTF_NUMBER_TABLE();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: a9 := JTF_VARCHAR2_TABLE_300();

Line 298: a6 := JTF_NUMBER_TABLE();

294: a2 := JTF_DATE_TABLE();
295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_NUMBER_TABLE();
298: a6 := JTF_NUMBER_TABLE();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: a9 := JTF_VARCHAR2_TABLE_300();
302: a10 := JTF_VARCHAR2_TABLE_2000();

Line 299: a7 := JTF_NUMBER_TABLE();

295: a3 := JTF_NUMBER_TABLE();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_NUMBER_TABLE();
298: a6 := JTF_NUMBER_TABLE();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: a9 := JTF_VARCHAR2_TABLE_300();
302: a10 := JTF_VARCHAR2_TABLE_2000();
303: a11 := JTF_VARCHAR2_TABLE_2000();

Line 312: a20 := JTF_NUMBER_TABLE();

308: a16 := JTF_VARCHAR2_TABLE_300();
309: a17 := JTF_VARCHAR2_TABLE_2000();
310: a18 := JTF_DATE_TABLE();
311: a19 := JTF_VARCHAR2_TABLE_100();
312: a20 := JTF_NUMBER_TABLE();
313: a21 := JTF_NUMBER_TABLE();
314: a22 := JTF_NUMBER_TABLE();
315: a23 := JTF_VARCHAR2_TABLE_300();
316: a24 := JTF_VARCHAR2_TABLE_2000();

Line 313: a21 := JTF_NUMBER_TABLE();

309: a17 := JTF_VARCHAR2_TABLE_2000();
310: a18 := JTF_DATE_TABLE();
311: a19 := JTF_VARCHAR2_TABLE_100();
312: a20 := JTF_NUMBER_TABLE();
313: a21 := JTF_NUMBER_TABLE();
314: a22 := JTF_NUMBER_TABLE();
315: a23 := JTF_VARCHAR2_TABLE_300();
316: a24 := JTF_VARCHAR2_TABLE_2000();
317: a25 := JTF_VARCHAR2_TABLE_2000();

Line 314: a22 := JTF_NUMBER_TABLE();

310: a18 := JTF_DATE_TABLE();
311: a19 := JTF_VARCHAR2_TABLE_100();
312: a20 := JTF_NUMBER_TABLE();
313: a21 := JTF_NUMBER_TABLE();
314: a22 := JTF_NUMBER_TABLE();
315: a23 := JTF_VARCHAR2_TABLE_300();
316: a24 := JTF_VARCHAR2_TABLE_2000();
317: a25 := JTF_VARCHAR2_TABLE_2000();
318: a26 := JTF_VARCHAR2_TABLE_2000();

Line 393: procedure rosetta_table_copy_in_p8(t out nocopy amv_item_pub.amv_nameid_varray_type, a0 JTF_NUMBER_TABLE

389: end if;
390: end if;
391: end rosetta_table_copy_out_p6;
392:
393: procedure rosetta_table_copy_in_p8(t out nocopy amv_item_pub.amv_nameid_varray_type, a0 JTF_NUMBER_TABLE
394: , a1 JTF_VARCHAR2_TABLE_300
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin

Line 418: procedure rosetta_table_copy_out_p8(t amv_item_pub.amv_nameid_varray_type, a0 out nocopy JTF_NUMBER_TABLE

414: end loop;
415: end if;
416: end if;
417: end rosetta_table_copy_in_p8;
418: procedure rosetta_table_copy_out_p8(t amv_item_pub.amv_nameid_varray_type, a0 out nocopy JTF_NUMBER_TABLE
419: , a1 out nocopy JTF_VARCHAR2_TABLE_300
420: ) as
421: ddindx binary_integer; indx binary_integer;
422: begin

Line 427: a0 := JTF_NUMBER_TABLE();

423: if t is null then
424: a0 := null;
425: a1 := null;
426: elsif t.count = 0 then
427: a0 := JTF_NUMBER_TABLE();
428: a1 := JTF_VARCHAR2_TABLE_300();
429: else
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_300();

Line 430: a0 := JTF_NUMBER_TABLE();

426: elsif t.count = 0 then
427: a0 := JTF_NUMBER_TABLE();
428: a1 := JTF_VARCHAR2_TABLE_300();
429: else
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_300();
432: if t.count > 0 then
433: a0.extend(t.count);
434: a1.extend(t.count);

Line 457: , p_channel_id_array JTF_NUMBER_TABLE

453: , x_return_status out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: , p_check_login_user VARCHAR2
457: , p_channel_id_array JTF_NUMBER_TABLE
458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000

Line 458: , p_file_array JTF_NUMBER_TABLE

454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: , p_check_login_user VARCHAR2
457: , p_channel_id_array JTF_NUMBER_TABLE
458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000
462: , p_keyword_array JTF_VARCHAR2_TABLE_4000

Line 459: , p10_a0 JTF_NUMBER_TABLE

455: , x_msg_data out nocopy VARCHAR2
456: , p_check_login_user VARCHAR2
457: , p_channel_id_array JTF_NUMBER_TABLE
458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000
462: , p_keyword_array JTF_VARCHAR2_TABLE_4000
463: , x_item_id out nocopy NUMBER

Line 585: , p_channel_id_array JTF_NUMBER_TABLE

581: , x_return_status out nocopy VARCHAR2
582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
584: , p_check_login_user VARCHAR2
585: , p_channel_id_array JTF_NUMBER_TABLE
586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000

Line 586: , p_file_array JTF_NUMBER_TABLE

582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
584: , p_check_login_user VARCHAR2
585: , p_channel_id_array JTF_NUMBER_TABLE
586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000
590: , p_keyword_array JTF_VARCHAR2_TABLE_4000

Line 587: , p10_a0 JTF_NUMBER_TABLE

583: , x_msg_data out nocopy VARCHAR2
584: , p_check_login_user VARCHAR2
585: , p_channel_id_array JTF_NUMBER_TABLE
586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000
590: , p_keyword_array JTF_VARCHAR2_TABLE_4000
591: , p8_a0 NUMBER := 0-1962.0724

Line 733: , x_file_array out nocopy JTF_NUMBER_TABLE

729: , p7_a20 out nocopy NUMBER
730: , p7_a21 out nocopy NUMBER
731: , p7_a22 out nocopy NUMBER
732: , p7_a23 out nocopy VARCHAR2
733: , x_file_array out nocopy JTF_NUMBER_TABLE
734: , p9_a0 out nocopy JTF_NUMBER_TABLE
735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000

Line 734: , p9_a0 out nocopy JTF_NUMBER_TABLE

730: , p7_a21 out nocopy NUMBER
731: , p7_a22 out nocopy NUMBER
732: , p7_a23 out nocopy VARCHAR2
733: , x_file_array out nocopy JTF_NUMBER_TABLE
734: , p9_a0 out nocopy JTF_NUMBER_TABLE
735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000
738: )

Line 832: , p11_a0 out nocopy JTF_NUMBER_TABLE

828: , p_item_type VARCHAR2
829: , p10_a0 out nocopy NUMBER
830: , p10_a1 out nocopy NUMBER
831: , p10_a2 out nocopy NUMBER
832: , p11_a0 out nocopy JTF_NUMBER_TABLE
833: , p11_a1 out nocopy JTF_NUMBER_TABLE
834: , p11_a2 out nocopy JTF_DATE_TABLE
835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE

Line 833: , p11_a1 out nocopy JTF_NUMBER_TABLE

829: , p10_a0 out nocopy NUMBER
830: , p10_a1 out nocopy NUMBER
831: , p10_a2 out nocopy NUMBER
832: , p11_a0 out nocopy JTF_NUMBER_TABLE
833: , p11_a1 out nocopy JTF_NUMBER_TABLE
834: , p11_a2 out nocopy JTF_DATE_TABLE
835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE
837: , p11_a5 out nocopy JTF_NUMBER_TABLE

Line 835: , p11_a3 out nocopy JTF_NUMBER_TABLE

831: , p10_a2 out nocopy NUMBER
832: , p11_a0 out nocopy JTF_NUMBER_TABLE
833: , p11_a1 out nocopy JTF_NUMBER_TABLE
834: , p11_a2 out nocopy JTF_DATE_TABLE
835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE
837: , p11_a5 out nocopy JTF_NUMBER_TABLE
838: , p11_a6 out nocopy JTF_NUMBER_TABLE
839: , p11_a7 out nocopy JTF_NUMBER_TABLE

Line 837: , p11_a5 out nocopy JTF_NUMBER_TABLE

833: , p11_a1 out nocopy JTF_NUMBER_TABLE
834: , p11_a2 out nocopy JTF_DATE_TABLE
835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE
837: , p11_a5 out nocopy JTF_NUMBER_TABLE
838: , p11_a6 out nocopy JTF_NUMBER_TABLE
839: , p11_a7 out nocopy JTF_NUMBER_TABLE
840: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
841: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 838: , p11_a6 out nocopy JTF_NUMBER_TABLE

834: , p11_a2 out nocopy JTF_DATE_TABLE
835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE
837: , p11_a5 out nocopy JTF_NUMBER_TABLE
838: , p11_a6 out nocopy JTF_NUMBER_TABLE
839: , p11_a7 out nocopy JTF_NUMBER_TABLE
840: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
841: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300
842: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 839: , p11_a7 out nocopy JTF_NUMBER_TABLE

835: , p11_a3 out nocopy JTF_NUMBER_TABLE
836: , p11_a4 out nocopy JTF_DATE_TABLE
837: , p11_a5 out nocopy JTF_NUMBER_TABLE
838: , p11_a6 out nocopy JTF_NUMBER_TABLE
839: , p11_a7 out nocopy JTF_NUMBER_TABLE
840: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
841: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300
842: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_2000
843: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 852: , p11_a20 out nocopy JTF_NUMBER_TABLE

848: , p11_a16 out nocopy JTF_VARCHAR2_TABLE_300
849: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_2000
850: , p11_a18 out nocopy JTF_DATE_TABLE
851: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
852: , p11_a20 out nocopy JTF_NUMBER_TABLE
853: , p11_a21 out nocopy JTF_NUMBER_TABLE
854: , p11_a22 out nocopy JTF_NUMBER_TABLE
855: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
856: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 853: , p11_a21 out nocopy JTF_NUMBER_TABLE

849: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_2000
850: , p11_a18 out nocopy JTF_DATE_TABLE
851: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
852: , p11_a20 out nocopy JTF_NUMBER_TABLE
853: , p11_a21 out nocopy JTF_NUMBER_TABLE
854: , p11_a22 out nocopy JTF_NUMBER_TABLE
855: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
856: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000
857: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 854: , p11_a22 out nocopy JTF_NUMBER_TABLE

850: , p11_a18 out nocopy JTF_DATE_TABLE
851: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
852: , p11_a20 out nocopy JTF_NUMBER_TABLE
853: , p11_a21 out nocopy JTF_NUMBER_TABLE
854: , p11_a22 out nocopy JTF_NUMBER_TABLE
855: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
856: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000
857: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000
858: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1343: , p_file_id_varray JTF_NUMBER_TABLE

1339: , x_msg_data out nocopy VARCHAR2
1340: , p_check_login_user VARCHAR2
1341: , p_application_id NUMBER
1342: , p_item_id NUMBER
1343: , p_file_id_varray JTF_NUMBER_TABLE
1344: )
1345:
1346: as
1347: ddp_file_id_varray amv_item_pub.amv_number_varray_type;

Line 1395: , p_file_id_varray JTF_NUMBER_TABLE

1391: , x_msg_count out nocopy NUMBER
1392: , x_msg_data out nocopy VARCHAR2
1393: , p_check_login_user VARCHAR2
1394: , p_item_id NUMBER
1395: , p_file_id_varray JTF_NUMBER_TABLE
1396: )
1397:
1398: as
1399: ddp_file_id_varray amv_item_pub.amv_number_varray_type;

Line 1444: , p_file_id_varray JTF_NUMBER_TABLE

1440: , x_msg_count out nocopy NUMBER
1441: , x_msg_data out nocopy VARCHAR2
1442: , p_check_login_user VARCHAR2
1443: , p_item_id NUMBER
1444: , p_file_id_varray JTF_NUMBER_TABLE
1445: )
1446:
1447: as
1448: ddp_file_id_varray amv_item_pub.amv_number_varray_type;

Line 1492: , x_file_id_varray out nocopy JTF_NUMBER_TABLE

1488: , x_msg_count out nocopy NUMBER
1489: , x_msg_data out nocopy VARCHAR2
1490: , p_check_login_user VARCHAR2
1491: , p_item_id NUMBER
1492: , x_file_id_varray out nocopy JTF_NUMBER_TABLE
1493: )
1494:
1495: as
1496: ddx_file_id_varray amv_item_pub.amv_number_varray_type;

Line 1537: , x_item_id_varray out nocopy JTF_NUMBER_TABLE

1533: , x_msg_count out nocopy NUMBER
1534: , x_msg_data out nocopy VARCHAR2
1535: , p_check_login_user VARCHAR2
1536: , p_user_id NUMBER
1537: , x_item_id_varray out nocopy JTF_NUMBER_TABLE
1538: , x_message_varray out nocopy JTF_VARCHAR2_TABLE_4000
1539: )
1540:
1541: as

Line 1588: , p7_a0 out nocopy JTF_NUMBER_TABLE

1584: , x_msg_count out nocopy NUMBER
1585: , x_msg_data out nocopy VARCHAR2
1586: , p_check_login_user VARCHAR2
1587: , p_user_id NUMBER
1588: , p7_a0 out nocopy JTF_NUMBER_TABLE
1589: , p7_a1 out nocopy JTF_NUMBER_TABLE
1590: , p7_a2 out nocopy JTF_DATE_TABLE
1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE

Line 1589: , p7_a1 out nocopy JTF_NUMBER_TABLE

1585: , x_msg_data out nocopy VARCHAR2
1586: , p_check_login_user VARCHAR2
1587: , p_user_id NUMBER
1588: , p7_a0 out nocopy JTF_NUMBER_TABLE
1589: , p7_a1 out nocopy JTF_NUMBER_TABLE
1590: , p7_a2 out nocopy JTF_DATE_TABLE
1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE
1593: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 1591: , p7_a3 out nocopy JTF_NUMBER_TABLE

1587: , p_user_id NUMBER
1588: , p7_a0 out nocopy JTF_NUMBER_TABLE
1589: , p7_a1 out nocopy JTF_NUMBER_TABLE
1590: , p7_a2 out nocopy JTF_DATE_TABLE
1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE
1593: , p7_a5 out nocopy JTF_NUMBER_TABLE
1594: , p7_a6 out nocopy JTF_NUMBER_TABLE
1595: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 1593: , p7_a5 out nocopy JTF_NUMBER_TABLE

1589: , p7_a1 out nocopy JTF_NUMBER_TABLE
1590: , p7_a2 out nocopy JTF_DATE_TABLE
1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE
1593: , p7_a5 out nocopy JTF_NUMBER_TABLE
1594: , p7_a6 out nocopy JTF_NUMBER_TABLE
1595: , p7_a7 out nocopy JTF_NUMBER_TABLE
1596: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1597: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 1594: , p7_a6 out nocopy JTF_NUMBER_TABLE

1590: , p7_a2 out nocopy JTF_DATE_TABLE
1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE
1593: , p7_a5 out nocopy JTF_NUMBER_TABLE
1594: , p7_a6 out nocopy JTF_NUMBER_TABLE
1595: , p7_a7 out nocopy JTF_NUMBER_TABLE
1596: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1597: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
1598: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1595: , p7_a7 out nocopy JTF_NUMBER_TABLE

1591: , p7_a3 out nocopy JTF_NUMBER_TABLE
1592: , p7_a4 out nocopy JTF_DATE_TABLE
1593: , p7_a5 out nocopy JTF_NUMBER_TABLE
1594: , p7_a6 out nocopy JTF_NUMBER_TABLE
1595: , p7_a7 out nocopy JTF_NUMBER_TABLE
1596: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1597: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
1598: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1599: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1608: , p7_a20 out nocopy JTF_NUMBER_TABLE

1604: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
1605: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1606: , p7_a18 out nocopy JTF_DATE_TABLE
1607: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p7_a20 out nocopy JTF_NUMBER_TABLE
1609: , p7_a21 out nocopy JTF_NUMBER_TABLE
1610: , p7_a22 out nocopy JTF_NUMBER_TABLE
1611: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
1612: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1609: , p7_a21 out nocopy JTF_NUMBER_TABLE

1605: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1606: , p7_a18 out nocopy JTF_DATE_TABLE
1607: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p7_a20 out nocopy JTF_NUMBER_TABLE
1609: , p7_a21 out nocopy JTF_NUMBER_TABLE
1610: , p7_a22 out nocopy JTF_NUMBER_TABLE
1611: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
1612: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1610: , p7_a22 out nocopy JTF_NUMBER_TABLE

1606: , p7_a18 out nocopy JTF_DATE_TABLE
1607: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p7_a20 out nocopy JTF_NUMBER_TABLE
1609: , p7_a21 out nocopy JTF_NUMBER_TABLE
1610: , p7_a22 out nocopy JTF_NUMBER_TABLE
1611: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
1612: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1614: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1691: , p8_a0 out nocopy JTF_NUMBER_TABLE

1687: , x_msg_data out nocopy VARCHAR2
1688: , p_check_login_user VARCHAR2
1689: , p_item_id NUMBER
1690: , p_match_type VARCHAR2
1691: , p8_a0 out nocopy JTF_NUMBER_TABLE
1692: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1693: )
1694:
1695: as