APPS.AMV_ITEM_PUB_W dependencies on JTF_NUMBER_TABLE

Line 6: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

2: /* $Header: amvwitms.pls 120.2 2005/06/30 08:03 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_item_pub.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_item_pub.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE

Line 7: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p0(t out nocopy amv_item_pub.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_item_pub.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_DATE_TABLE

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

5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_DATE_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE

Line 10: , a1 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_in_p1(t out nocopy amv_item_pub.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_item_pub.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_DATE_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE
14: , a5 JTF_NUMBER_TABLE

Line 12: , a3 JTF_NUMBER_TABLE

8:
9: procedure rosetta_table_copy_in_p6(t out nocopy amv_item_pub.amv_simple_item_obj_varray, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_DATE_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_NUMBER_TABLE
16: , a7 JTF_NUMBER_TABLE

Line 14: , a5 JTF_NUMBER_TABLE

10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_DATE_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_NUMBER_TABLE
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_VARCHAR2_TABLE_100
18: , a9 JTF_VARCHAR2_TABLE_300

Line 15: , a6 JTF_NUMBER_TABLE

11: , a2 JTF_DATE_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_NUMBER_TABLE
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_VARCHAR2_TABLE_100
18: , a9 JTF_VARCHAR2_TABLE_300
19: , a10 JTF_VARCHAR2_TABLE_2000

Line 16: , a7 JTF_NUMBER_TABLE

12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_DATE_TABLE
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_NUMBER_TABLE
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_VARCHAR2_TABLE_100
18: , a9 JTF_VARCHAR2_TABLE_300
19: , a10 JTF_VARCHAR2_TABLE_2000
20: , a11 JTF_VARCHAR2_TABLE_2000

Line 29: , a20 JTF_NUMBER_TABLE

25: , a16 JTF_VARCHAR2_TABLE_300
26: , a17 JTF_VARCHAR2_TABLE_2000
27: , a18 JTF_DATE_TABLE
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_NUMBER_TABLE
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_NUMBER_TABLE
32: , a23 JTF_VARCHAR2_TABLE_300
33: , a24 JTF_VARCHAR2_TABLE_2000

Line 30: , a21 JTF_NUMBER_TABLE

26: , a17 JTF_VARCHAR2_TABLE_2000
27: , a18 JTF_DATE_TABLE
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_NUMBER_TABLE
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_NUMBER_TABLE
32: , a23 JTF_VARCHAR2_TABLE_300
33: , a24 JTF_VARCHAR2_TABLE_2000
34: , a25 JTF_VARCHAR2_TABLE_2000

Line 31: , a22 JTF_NUMBER_TABLE

27: , a18 JTF_DATE_TABLE
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_NUMBER_TABLE
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_NUMBER_TABLE
32: , a23 JTF_VARCHAR2_TABLE_300
33: , a24 JTF_VARCHAR2_TABLE_2000
34: , a25 JTF_VARCHAR2_TABLE_2000
35: , a26 JTF_VARCHAR2_TABLE_2000

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

35: , a26 JTF_VARCHAR2_TABLE_2000
36: , a27 JTF_VARCHAR2_TABLE_2000
37: , a28 JTF_VARCHAR2_TABLE_2000
38: );
39: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE

Line 40: , a1 out nocopy JTF_NUMBER_TABLE

36: , a27 JTF_VARCHAR2_TABLE_2000
37: , a28 JTF_VARCHAR2_TABLE_2000
38: );
39: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE
44: , a5 out nocopy JTF_NUMBER_TABLE

Line 42: , a3 out nocopy JTF_NUMBER_TABLE

38: );
39: procedure rosetta_table_copy_out_p6(t amv_item_pub.amv_simple_item_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE

Line 44: , a5 out nocopy JTF_NUMBER_TABLE

40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_VARCHAR2_TABLE_100
48: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 45: , a6 out nocopy JTF_NUMBER_TABLE

41: , a2 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_VARCHAR2_TABLE_100
48: , a9 out nocopy JTF_VARCHAR2_TABLE_300
49: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 46: , a7 out nocopy JTF_NUMBER_TABLE

42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_DATE_TABLE
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_VARCHAR2_TABLE_100
48: , a9 out nocopy JTF_VARCHAR2_TABLE_300
49: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
50: , a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 59: , a20 out nocopy JTF_NUMBER_TABLE

55: , a16 out nocopy JTF_VARCHAR2_TABLE_300
56: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a18 out nocopy JTF_DATE_TABLE
58: , a19 out nocopy JTF_VARCHAR2_TABLE_100
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_NUMBER_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_VARCHAR2_TABLE_300
63: , a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 60: , a21 out nocopy JTF_NUMBER_TABLE

56: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a18 out nocopy JTF_DATE_TABLE
58: , a19 out nocopy JTF_VARCHAR2_TABLE_100
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_NUMBER_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_VARCHAR2_TABLE_300
63: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 61: , a22 out nocopy JTF_NUMBER_TABLE

57: , a18 out nocopy JTF_DATE_TABLE
58: , a19 out nocopy JTF_VARCHAR2_TABLE_100
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_NUMBER_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_VARCHAR2_TABLE_300
63: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
65: , a26 out nocopy JTF_VARCHAR2_TABLE_2000

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

66: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
68: );
69:
70: procedure rosetta_table_copy_in_p8(t out nocopy amv_item_pub.amv_nameid_varray_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p8(t amv_item_pub.amv_nameid_varray_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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

69:
70: procedure rosetta_table_copy_in_p8(t out nocopy amv_item_pub.amv_nameid_varray_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p8(t amv_item_pub.amv_nameid_varray_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_300
75: );
76:
77: procedure create_item(p_api_version NUMBER

Line 84: , p_channel_id_array JTF_NUMBER_TABLE

80: , x_return_status out nocopy VARCHAR2
81: , x_msg_count out nocopy NUMBER
82: , x_msg_data out nocopy VARCHAR2
83: , p_check_login_user VARCHAR2
84: , p_channel_id_array JTF_NUMBER_TABLE
85: , p_file_array JTF_NUMBER_TABLE
86: , p10_a0 JTF_NUMBER_TABLE
87: , p10_a1 JTF_VARCHAR2_TABLE_300
88: , p_author_array JTF_VARCHAR2_TABLE_4000

Line 85: , p_file_array JTF_NUMBER_TABLE

81: , x_msg_count out nocopy NUMBER
82: , x_msg_data out nocopy VARCHAR2
83: , p_check_login_user VARCHAR2
84: , p_channel_id_array JTF_NUMBER_TABLE
85: , p_file_array JTF_NUMBER_TABLE
86: , p10_a0 JTF_NUMBER_TABLE
87: , p10_a1 JTF_VARCHAR2_TABLE_300
88: , p_author_array JTF_VARCHAR2_TABLE_4000
89: , p_keyword_array JTF_VARCHAR2_TABLE_4000

Line 86: , p10_a0 JTF_NUMBER_TABLE

82: , x_msg_data out nocopy VARCHAR2
83: , p_check_login_user VARCHAR2
84: , p_channel_id_array JTF_NUMBER_TABLE
85: , p_file_array JTF_NUMBER_TABLE
86: , p10_a0 JTF_NUMBER_TABLE
87: , p10_a1 JTF_VARCHAR2_TABLE_300
88: , p_author_array JTF_VARCHAR2_TABLE_4000
89: , p_keyword_array JTF_VARCHAR2_TABLE_4000
90: , x_item_id out nocopy NUMBER

Line 123: , p_channel_id_array JTF_NUMBER_TABLE

119: , x_return_status out nocopy VARCHAR2
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p_check_login_user VARCHAR2
123: , p_channel_id_array JTF_NUMBER_TABLE
124: , p_file_array JTF_NUMBER_TABLE
125: , p10_a0 JTF_NUMBER_TABLE
126: , p10_a1 JTF_VARCHAR2_TABLE_300
127: , p_author_array JTF_VARCHAR2_TABLE_4000

Line 124: , p_file_array JTF_NUMBER_TABLE

120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p_check_login_user VARCHAR2
123: , p_channel_id_array JTF_NUMBER_TABLE
124: , p_file_array JTF_NUMBER_TABLE
125: , p10_a0 JTF_NUMBER_TABLE
126: , p10_a1 JTF_VARCHAR2_TABLE_300
127: , p_author_array JTF_VARCHAR2_TABLE_4000
128: , p_keyword_array JTF_VARCHAR2_TABLE_4000

Line 125: , p10_a0 JTF_NUMBER_TABLE

121: , x_msg_data out nocopy VARCHAR2
122: , p_check_login_user VARCHAR2
123: , p_channel_id_array JTF_NUMBER_TABLE
124: , p_file_array JTF_NUMBER_TABLE
125: , p10_a0 JTF_NUMBER_TABLE
126: , p10_a1 JTF_VARCHAR2_TABLE_300
127: , p_author_array JTF_VARCHAR2_TABLE_4000
128: , p_keyword_array JTF_VARCHAR2_TABLE_4000
129: , p8_a0 NUMBER := 0-1962.0724

Line 185: , x_file_array out nocopy JTF_NUMBER_TABLE

181: , p7_a20 out nocopy NUMBER
182: , p7_a21 out nocopy NUMBER
183: , p7_a22 out nocopy NUMBER
184: , p7_a23 out nocopy VARCHAR2
185: , x_file_array out nocopy JTF_NUMBER_TABLE
186: , p9_a0 out nocopy JTF_NUMBER_TABLE
187: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
188: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
189: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000

Line 186: , p9_a0 out nocopy JTF_NUMBER_TABLE

182: , p7_a21 out nocopy NUMBER
183: , p7_a22 out nocopy NUMBER
184: , p7_a23 out nocopy VARCHAR2
185: , x_file_array out nocopy JTF_NUMBER_TABLE
186: , p9_a0 out nocopy JTF_NUMBER_TABLE
187: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
188: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
189: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000
190: );

Line 203: , p11_a0 out nocopy JTF_NUMBER_TABLE

199: , p_item_type VARCHAR2
200: , p10_a0 out nocopy NUMBER
201: , p10_a1 out nocopy NUMBER
202: , p10_a2 out nocopy NUMBER
203: , p11_a0 out nocopy JTF_NUMBER_TABLE
204: , p11_a1 out nocopy JTF_NUMBER_TABLE
205: , p11_a2 out nocopy JTF_DATE_TABLE
206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE

Line 204: , p11_a1 out nocopy JTF_NUMBER_TABLE

200: , p10_a0 out nocopy NUMBER
201: , p10_a1 out nocopy NUMBER
202: , p10_a2 out nocopy NUMBER
203: , p11_a0 out nocopy JTF_NUMBER_TABLE
204: , p11_a1 out nocopy JTF_NUMBER_TABLE
205: , p11_a2 out nocopy JTF_DATE_TABLE
206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE
208: , p11_a5 out nocopy JTF_NUMBER_TABLE

Line 206: , p11_a3 out nocopy JTF_NUMBER_TABLE

202: , p10_a2 out nocopy NUMBER
203: , p11_a0 out nocopy JTF_NUMBER_TABLE
204: , p11_a1 out nocopy JTF_NUMBER_TABLE
205: , p11_a2 out nocopy JTF_DATE_TABLE
206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE
208: , p11_a5 out nocopy JTF_NUMBER_TABLE
209: , p11_a6 out nocopy JTF_NUMBER_TABLE
210: , p11_a7 out nocopy JTF_NUMBER_TABLE

Line 208: , p11_a5 out nocopy JTF_NUMBER_TABLE

204: , p11_a1 out nocopy JTF_NUMBER_TABLE
205: , p11_a2 out nocopy JTF_DATE_TABLE
206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE
208: , p11_a5 out nocopy JTF_NUMBER_TABLE
209: , p11_a6 out nocopy JTF_NUMBER_TABLE
210: , p11_a7 out nocopy JTF_NUMBER_TABLE
211: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
212: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 209: , p11_a6 out nocopy JTF_NUMBER_TABLE

205: , p11_a2 out nocopy JTF_DATE_TABLE
206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE
208: , p11_a5 out nocopy JTF_NUMBER_TABLE
209: , p11_a6 out nocopy JTF_NUMBER_TABLE
210: , p11_a7 out nocopy JTF_NUMBER_TABLE
211: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
212: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300
213: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 210: , p11_a7 out nocopy JTF_NUMBER_TABLE

206: , p11_a3 out nocopy JTF_NUMBER_TABLE
207: , p11_a4 out nocopy JTF_DATE_TABLE
208: , p11_a5 out nocopy JTF_NUMBER_TABLE
209: , p11_a6 out nocopy JTF_NUMBER_TABLE
210: , p11_a7 out nocopy JTF_NUMBER_TABLE
211: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
212: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300
213: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_2000
214: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 223: , p11_a20 out nocopy JTF_NUMBER_TABLE

219: , p11_a16 out nocopy JTF_VARCHAR2_TABLE_300
220: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_2000
221: , p11_a18 out nocopy JTF_DATE_TABLE
222: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
223: , p11_a20 out nocopy JTF_NUMBER_TABLE
224: , p11_a21 out nocopy JTF_NUMBER_TABLE
225: , p11_a22 out nocopy JTF_NUMBER_TABLE
226: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
227: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 224: , p11_a21 out nocopy JTF_NUMBER_TABLE

220: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_2000
221: , p11_a18 out nocopy JTF_DATE_TABLE
222: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
223: , p11_a20 out nocopy JTF_NUMBER_TABLE
224: , p11_a21 out nocopy JTF_NUMBER_TABLE
225: , p11_a22 out nocopy JTF_NUMBER_TABLE
226: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
227: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000
228: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 225: , p11_a22 out nocopy JTF_NUMBER_TABLE

221: , p11_a18 out nocopy JTF_DATE_TABLE
222: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
223: , p11_a20 out nocopy JTF_NUMBER_TABLE
224: , p11_a21 out nocopy JTF_NUMBER_TABLE
225: , p11_a22 out nocopy JTF_NUMBER_TABLE
226: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
227: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000
228: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000
229: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 323: , p_file_id_varray JTF_NUMBER_TABLE

319: , x_msg_data out nocopy VARCHAR2
320: , p_check_login_user VARCHAR2
321: , p_application_id NUMBER
322: , p_item_id NUMBER
323: , p_file_id_varray JTF_NUMBER_TABLE
324: );
325: procedure delete_itemfile(p_api_version NUMBER
326: , p_init_msg_list VARCHAR2
327: , p_commit VARCHAR2

Line 333: , p_file_id_varray JTF_NUMBER_TABLE

329: , x_msg_count out nocopy NUMBER
330: , x_msg_data out nocopy VARCHAR2
331: , p_check_login_user VARCHAR2
332: , p_item_id NUMBER
333: , p_file_id_varray JTF_NUMBER_TABLE
334: );
335: procedure replace_itemfile(p_api_version NUMBER
336: , p_init_msg_list VARCHAR2
337: , p_commit VARCHAR2

Line 343: , p_file_id_varray JTF_NUMBER_TABLE

339: , x_msg_count out nocopy NUMBER
340: , x_msg_data out nocopy VARCHAR2
341: , p_check_login_user VARCHAR2
342: , p_item_id NUMBER
343: , p_file_id_varray JTF_NUMBER_TABLE
344: );
345: procedure get_itemfile(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , x_return_status out nocopy VARCHAR2

Line 352: , x_file_id_varray out nocopy JTF_NUMBER_TABLE

348: , x_msg_count out nocopy NUMBER
349: , x_msg_data out nocopy VARCHAR2
350: , p_check_login_user VARCHAR2
351: , p_item_id NUMBER
352: , x_file_id_varray out nocopy JTF_NUMBER_TABLE
353: );
354: procedure get_usermessage(p_api_version NUMBER
355: , p_init_msg_list VARCHAR2
356: , x_return_status out nocopy VARCHAR2

Line 361: , x_item_id_varray out nocopy JTF_NUMBER_TABLE

357: , x_msg_count out nocopy NUMBER
358: , x_msg_data out nocopy VARCHAR2
359: , p_check_login_user VARCHAR2
360: , p_user_id NUMBER
361: , x_item_id_varray out nocopy JTF_NUMBER_TABLE
362: , x_message_varray out nocopy JTF_VARCHAR2_TABLE_4000
363: );
364: procedure get_usermessage2(p_api_version NUMBER
365: , p_init_msg_list VARCHAR2

Line 371: , p7_a0 out nocopy JTF_NUMBER_TABLE

367: , x_msg_count out nocopy NUMBER
368: , x_msg_data out nocopy VARCHAR2
369: , p_check_login_user VARCHAR2
370: , p_user_id NUMBER
371: , p7_a0 out nocopy JTF_NUMBER_TABLE
372: , p7_a1 out nocopy JTF_NUMBER_TABLE
373: , p7_a2 out nocopy JTF_DATE_TABLE
374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE

Line 372: , p7_a1 out nocopy JTF_NUMBER_TABLE

368: , x_msg_data out nocopy VARCHAR2
369: , p_check_login_user VARCHAR2
370: , p_user_id NUMBER
371: , p7_a0 out nocopy JTF_NUMBER_TABLE
372: , p7_a1 out nocopy JTF_NUMBER_TABLE
373: , p7_a2 out nocopy JTF_DATE_TABLE
374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE
376: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 374: , p7_a3 out nocopy JTF_NUMBER_TABLE

370: , p_user_id NUMBER
371: , p7_a0 out nocopy JTF_NUMBER_TABLE
372: , p7_a1 out nocopy JTF_NUMBER_TABLE
373: , p7_a2 out nocopy JTF_DATE_TABLE
374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE
376: , p7_a5 out nocopy JTF_NUMBER_TABLE
377: , p7_a6 out nocopy JTF_NUMBER_TABLE
378: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 376: , p7_a5 out nocopy JTF_NUMBER_TABLE

372: , p7_a1 out nocopy JTF_NUMBER_TABLE
373: , p7_a2 out nocopy JTF_DATE_TABLE
374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE
376: , p7_a5 out nocopy JTF_NUMBER_TABLE
377: , p7_a6 out nocopy JTF_NUMBER_TABLE
378: , p7_a7 out nocopy JTF_NUMBER_TABLE
379: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
380: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 377: , p7_a6 out nocopy JTF_NUMBER_TABLE

373: , p7_a2 out nocopy JTF_DATE_TABLE
374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE
376: , p7_a5 out nocopy JTF_NUMBER_TABLE
377: , p7_a6 out nocopy JTF_NUMBER_TABLE
378: , p7_a7 out nocopy JTF_NUMBER_TABLE
379: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
380: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
381: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_2000

Line 378: , p7_a7 out nocopy JTF_NUMBER_TABLE

374: , p7_a3 out nocopy JTF_NUMBER_TABLE
375: , p7_a4 out nocopy JTF_DATE_TABLE
376: , p7_a5 out nocopy JTF_NUMBER_TABLE
377: , p7_a6 out nocopy JTF_NUMBER_TABLE
378: , p7_a7 out nocopy JTF_NUMBER_TABLE
379: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
380: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
381: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_2000
382: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_2000

Line 391: , p7_a20 out nocopy JTF_NUMBER_TABLE

387: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
388: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
389: , p7_a18 out nocopy JTF_DATE_TABLE
390: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
391: , p7_a20 out nocopy JTF_NUMBER_TABLE
392: , p7_a21 out nocopy JTF_NUMBER_TABLE
393: , p7_a22 out nocopy JTF_NUMBER_TABLE
394: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
395: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000

Line 392: , p7_a21 out nocopy JTF_NUMBER_TABLE

388: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
389: , p7_a18 out nocopy JTF_DATE_TABLE
390: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
391: , p7_a20 out nocopy JTF_NUMBER_TABLE
392: , p7_a21 out nocopy JTF_NUMBER_TABLE
393: , p7_a22 out nocopy JTF_NUMBER_TABLE
394: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
395: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000

Line 393: , p7_a22 out nocopy JTF_NUMBER_TABLE

389: , p7_a18 out nocopy JTF_DATE_TABLE
390: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
391: , p7_a20 out nocopy JTF_NUMBER_TABLE
392: , p7_a21 out nocopy JTF_NUMBER_TABLE
393: , p7_a22 out nocopy JTF_NUMBER_TABLE
394: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
395: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
397: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 409: , p8_a0 out nocopy JTF_NUMBER_TABLE

405: , x_msg_data out nocopy VARCHAR2
406: , p_check_login_user VARCHAR2
407: , p_item_id NUMBER
408: , p_match_type VARCHAR2
409: , p8_a0 out nocopy JTF_NUMBER_TABLE
410: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
411: );
412: end amv_item_pub_w;