[Home] [Help]
PACKAGE: APPS.AMV_ITEM_PUB_W
Source
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
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
17 , a8 JTF_VARCHAR2_TABLE_100
18 , a9 JTF_VARCHAR2_TABLE_300
19 , a10 JTF_VARCHAR2_TABLE_2000
20 , a11 JTF_VARCHAR2_TABLE_2000
21 , a12 JTF_VARCHAR2_TABLE_100
22 , a13 JTF_VARCHAR2_TABLE_100
23 , a14 JTF_DATE_TABLE
24 , a15 JTF_DATE_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
34 , a25 JTF_VARCHAR2_TABLE_2000
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
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
51 , a12 out nocopy JTF_VARCHAR2_TABLE_100
52 , a13 out nocopy JTF_VARCHAR2_TABLE_100
53 , a14 out nocopy JTF_DATE_TABLE
54 , a15 out nocopy JTF_DATE_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
64 , a25 out nocopy JTF_VARCHAR2_TABLE_2000
65 , a26 out nocopy JTF_VARCHAR2_TABLE_2000
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
75 );
76
77 procedure create_item(p_api_version NUMBER
78 , p_init_msg_list VARCHAR2
79 , p_commit VARCHAR2
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
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
94 , p8_a3 NUMBER := 0-1962.0724
95 , p8_a4 DATE := fnd_api.g_miss_date
96 , p8_a5 NUMBER := 0-1962.0724
97 , p8_a6 NUMBER := 0-1962.0724
98 , p8_a7 NUMBER := 0-1962.0724
99 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
100 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
101 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
102 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
103 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
104 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
105 , p8_a14 DATE := fnd_api.g_miss_date
106 , p8_a15 DATE := fnd_api.g_miss_date
107 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
108 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
109 , p8_a18 DATE := fnd_api.g_miss_date
110 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
111 , p8_a20 NUMBER := 0-1962.0724
112 , p8_a21 NUMBER := 0-1962.0724
113 , p8_a22 NUMBER := 0-1962.0724
114 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
115 );
116 procedure update_item(p_api_version NUMBER
117 , p_init_msg_list VARCHAR2
118 , p_commit VARCHAR2
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
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
133 , p8_a4 DATE := fnd_api.g_miss_date
134 , p8_a5 NUMBER := 0-1962.0724
135 , p8_a6 NUMBER := 0-1962.0724
136 , p8_a7 NUMBER := 0-1962.0724
137 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
138 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
139 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
140 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
141 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
142 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
143 , p8_a14 DATE := fnd_api.g_miss_date
144 , p8_a15 DATE := fnd_api.g_miss_date
145 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
146 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
147 , p8_a18 DATE := fnd_api.g_miss_date
148 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
149 , p8_a20 NUMBER := 0-1962.0724
150 , p8_a21 NUMBER := 0-1962.0724
151 , p8_a22 NUMBER := 0-1962.0724
152 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
153 );
154 procedure get_item(p_api_version NUMBER
155 , p_init_msg_list VARCHAR2
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 , p_check_login_user VARCHAR2
160 , p_item_id NUMBER
161 , p7_a0 out nocopy NUMBER
162 , p7_a1 out nocopy NUMBER
163 , p7_a2 out nocopy DATE
164 , p7_a3 out nocopy NUMBER
165 , p7_a4 out nocopy DATE
166 , p7_a5 out nocopy NUMBER
167 , p7_a6 out nocopy NUMBER
168 , p7_a7 out nocopy NUMBER
169 , p7_a8 out nocopy VARCHAR2
170 , p7_a9 out nocopy VARCHAR2
171 , p7_a10 out nocopy VARCHAR2
172 , p7_a11 out nocopy VARCHAR2
173 , p7_a12 out nocopy VARCHAR2
174 , p7_a13 out nocopy VARCHAR2
175 , p7_a14 out nocopy DATE
176 , p7_a15 out nocopy DATE
177 , p7_a16 out nocopy VARCHAR2
178 , p7_a17 out nocopy VARCHAR2
179 , p7_a18 out nocopy DATE
180 , p7_a19 out nocopy VARCHAR2
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
190 );
191 procedure find_item(p_api_version NUMBER
192 , p_init_msg_list VARCHAR2
193 , x_return_status out nocopy VARCHAR2
194 , x_msg_count out nocopy NUMBER
195 , x_msg_data out nocopy VARCHAR2
196 , p_check_login_user VARCHAR2
197 , p_item_name VARCHAR2
198 , p_description VARCHAR2
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
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
215 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
216 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
217 , p11_a14 out nocopy JTF_DATE_TABLE
218 , p11_a15 out nocopy JTF_DATE_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
228 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000
229 , p11_a26 out nocopy JTF_VARCHAR2_TABLE_2000
230 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_2000
231 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_2000
232 , p9_a0 NUMBER := 0-1962.0724
233 , p9_a1 NUMBER := 0-1962.0724
234 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
235 );
236 procedure add_itemkeyword(p_api_version NUMBER
237 , p_init_msg_list VARCHAR2
238 , p_commit VARCHAR2
239 , x_return_status out nocopy VARCHAR2
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
249 , x_return_status out nocopy VARCHAR2
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
259 , x_return_status out nocopy VARCHAR2
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
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
278 , x_return_status out nocopy VARCHAR2
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
288 , x_return_status out nocopy VARCHAR2
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
298 , x_return_status out nocopy VARCHAR2
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
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
317 , x_return_status out nocopy VARCHAR2
318 , x_msg_count out nocopy NUMBER
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
328 , x_return_status out nocopy VARCHAR2
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
338 , x_return_status out nocopy VARCHAR2
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
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
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
366 , x_return_status out nocopy VARCHAR2
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
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
383 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
384 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
385 , p7_a14 out nocopy JTF_DATE_TABLE
386 , p7_a15 out nocopy JTF_DATE_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
396 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
397 , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
398 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_2000
399 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_2000
400 );
401 procedure get_channelsperitem(p_api_version NUMBER
402 , p_init_msg_list VARCHAR2
403 , x_return_status out nocopy VARCHAR2
404 , x_msg_count out nocopy NUMBER
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;