DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB_W dependencies on JTF_VARCHAR2_TABLE_4000

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy amv_item_pub.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);

1: package amv_item_pub_w as
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);

Line 4: procedure rosetta_table_copy_out_p0(t amv_item_pub.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);

1: package amv_item_pub_w as
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:

Line 88: , p_author_array JTF_VARCHAR2_TABLE_4000

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
91: , p8_a0 NUMBER := 0-1962.0724
92: , p8_a1 NUMBER := 0-1962.0724

Line 89: , p_keyword_array JTF_VARCHAR2_TABLE_4000

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
91: , p8_a0 NUMBER := 0-1962.0724
92: , p8_a1 NUMBER := 0-1962.0724
93: , p8_a2 DATE := fnd_api.g_miss_date

Line 127: , p_author_array JTF_VARCHAR2_TABLE_4000

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
130: , p8_a1 NUMBER := 0-1962.0724
131: , p8_a2 DATE := fnd_api.g_miss_date

Line 128: , p_keyword_array JTF_VARCHAR2_TABLE_4000

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
130: , p8_a1 NUMBER := 0-1962.0724
131: , p8_a2 DATE := fnd_api.g_miss_date
132: , p8_a3 NUMBER := 0-1962.0724

Line 188: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000

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: );
191: procedure find_item(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2

Line 189: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000

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: );
191: procedure find_item(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2
193: , x_return_status out nocopy VARCHAR2

Line 244: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

240: , x_msg_count out nocopy NUMBER
241: , x_msg_data out nocopy VARCHAR2
242: , p_check_login_user VARCHAR2
243: , p_item_id NUMBER
244: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
245: );
246: procedure delete_itemkeyword(p_api_version NUMBER
247: , p_init_msg_list VARCHAR2
248: , p_commit VARCHAR2

Line 254: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

250: , x_msg_count out nocopy NUMBER
251: , x_msg_data out nocopy VARCHAR2
252: , p_check_login_user VARCHAR2
253: , p_item_id NUMBER
254: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
255: );
256: procedure replace_itemkeyword(p_api_version NUMBER
257: , p_init_msg_list VARCHAR2
258: , p_commit VARCHAR2

Line 264: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

260: , x_msg_count out nocopy NUMBER
261: , x_msg_data out nocopy VARCHAR2
262: , p_check_login_user VARCHAR2
263: , p_item_id NUMBER
264: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
265: );
266: procedure get_itemkeyword(p_api_version NUMBER
267: , p_init_msg_list VARCHAR2
268: , x_return_status out nocopy VARCHAR2

Line 273: , x_keyword_varray out nocopy JTF_VARCHAR2_TABLE_4000

269: , x_msg_count out nocopy NUMBER
270: , x_msg_data out nocopy VARCHAR2
271: , p_check_login_user VARCHAR2
272: , p_item_id NUMBER
273: , x_keyword_varray out nocopy JTF_VARCHAR2_TABLE_4000
274: );
275: procedure add_itemauthor(p_api_version NUMBER
276: , p_init_msg_list VARCHAR2
277: , p_commit VARCHAR2

Line 283: , p_author_varray JTF_VARCHAR2_TABLE_4000

279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p_check_login_user VARCHAR2
282: , p_item_id NUMBER
283: , p_author_varray JTF_VARCHAR2_TABLE_4000
284: );
285: procedure delete_itemauthor(p_api_version NUMBER
286: , p_init_msg_list VARCHAR2
287: , p_commit VARCHAR2

Line 293: , p_author_varray JTF_VARCHAR2_TABLE_4000

289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p_check_login_user VARCHAR2
292: , p_item_id NUMBER
293: , p_author_varray JTF_VARCHAR2_TABLE_4000
294: );
295: procedure replace_itemauthor(p_api_version NUMBER
296: , p_init_msg_list VARCHAR2
297: , p_commit VARCHAR2

Line 303: , p_author_varray JTF_VARCHAR2_TABLE_4000

299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p_check_login_user VARCHAR2
302: , p_item_id NUMBER
303: , p_author_varray JTF_VARCHAR2_TABLE_4000
304: );
305: procedure get_itemauthor(p_api_version NUMBER
306: , p_init_msg_list VARCHAR2
307: , x_return_status out nocopy VARCHAR2

Line 312: , x_author_varray out nocopy JTF_VARCHAR2_TABLE_4000

308: , x_msg_count out nocopy NUMBER
309: , x_msg_data out nocopy VARCHAR2
310: , p_check_login_user VARCHAR2
311: , p_item_id NUMBER
312: , x_author_varray out nocopy JTF_VARCHAR2_TABLE_4000
313: );
314: procedure add_itemfile(p_api_version NUMBER
315: , p_init_msg_list VARCHAR2
316: , p_commit VARCHAR2

Line 362: , x_message_varray out nocopy JTF_VARCHAR2_TABLE_4000

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
366: , x_return_status out nocopy VARCHAR2