[Home] [Help]
PACKAGE: APPS.JTF_IH_PUB_W
Source
1 package jtf_ih_pub_w AUTHID CURRENT_USER as
2 /* $Header: JTFIHJWS.pls 115.32 2003/07/14 17:55:54 ialeshin ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_300
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_VARCHAR2_TABLE_1000
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_300
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_200
34 , a31 JTF_VARCHAR2_TABLE_200
35 , a32 JTF_VARCHAR2_TABLE_200
36 , a33 JTF_VARCHAR2_TABLE_200
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_200
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_VARCHAR2_TABLE_200
41 , a38 JTF_VARCHAR2_TABLE_200
42 , a39 JTF_VARCHAR2_TABLE_200
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_VARCHAR2_TABLE_300
45 , a42 JTF_VARCHAR2_TABLE_300
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_NUMBER_TABLE
48 );
49 procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_NUMBER_TABLE
51 , a2 out nocopy JTF_NUMBER_TABLE
52 , a3 out nocopy JTF_NUMBER_TABLE
53 , a4 out nocopy JTF_VARCHAR2_TABLE_300
54 , a5 out nocopy JTF_DATE_TABLE
55 , a6 out nocopy JTF_DATE_TABLE
56 , a7 out nocopy JTF_NUMBER_TABLE
57 , a8 out nocopy JTF_NUMBER_TABLE
58 , a9 out nocopy JTF_VARCHAR2_TABLE_100
59 , a10 out nocopy JTF_VARCHAR2_TABLE_100
60 , a11 out nocopy JTF_NUMBER_TABLE
61 , a12 out nocopy JTF_NUMBER_TABLE
62 , a13 out nocopy JTF_NUMBER_TABLE
63 , a14 out nocopy JTF_NUMBER_TABLE
64 , a15 out nocopy JTF_NUMBER_TABLE
65 , a16 out nocopy JTF_NUMBER_TABLE
66 , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67 , a18 out nocopy JTF_NUMBER_TABLE
68 , a19 out nocopy JTF_VARCHAR2_TABLE_300
69 , a20 out nocopy JTF_NUMBER_TABLE
70 , a21 out nocopy JTF_VARCHAR2_TABLE_100
71 , a22 out nocopy JTF_NUMBER_TABLE
72 , a23 out nocopy JTF_VARCHAR2_TABLE_100
73 , a24 out nocopy JTF_NUMBER_TABLE
74 , a25 out nocopy JTF_VARCHAR2_TABLE_200
75 , a26 out nocopy JTF_VARCHAR2_TABLE_200
76 , a27 out nocopy JTF_VARCHAR2_TABLE_200
77 , a28 out nocopy JTF_VARCHAR2_TABLE_200
78 , a29 out nocopy JTF_VARCHAR2_TABLE_200
79 , a30 out nocopy JTF_VARCHAR2_TABLE_200
80 , a31 out nocopy JTF_VARCHAR2_TABLE_200
81 , a32 out nocopy JTF_VARCHAR2_TABLE_200
82 , a33 out nocopy JTF_VARCHAR2_TABLE_200
83 , a34 out nocopy JTF_VARCHAR2_TABLE_200
84 , a35 out nocopy JTF_VARCHAR2_TABLE_200
85 , a36 out nocopy JTF_VARCHAR2_TABLE_200
86 , a37 out nocopy JTF_VARCHAR2_TABLE_200
87 , a38 out nocopy JTF_VARCHAR2_TABLE_200
88 , a39 out nocopy JTF_VARCHAR2_TABLE_200
89 , a40 out nocopy JTF_VARCHAR2_TABLE_100
90 , a41 out nocopy JTF_VARCHAR2_TABLE_300
91 , a42 out nocopy JTF_VARCHAR2_TABLE_300
92 , a43 out nocopy JTF_NUMBER_TABLE
93 , a44 out nocopy JTF_NUMBER_TABLE
94 );
95
96 procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
97 , a1 JTF_VARCHAR2_TABLE_100
98 , a2 JTF_NUMBER_TABLE
99 , a3 JTF_NUMBER_TABLE
100 , a4 JTF_DATE_TABLE
101 , a5 JTF_NUMBER_TABLE
102 , a6 JTF_NUMBER_TABLE
103 , a7 JTF_NUMBER_TABLE
104 , a8 JTF_NUMBER_TABLE
105 , a9 JTF_NUMBER_TABLE
106 , a10 JTF_VARCHAR2_TABLE_100
107 , a11 JTF_VARCHAR2_TABLE_300
108 , a12 JTF_VARCHAR2_TABLE_300
109 , a13 JTF_NUMBER_TABLE
110 , a14 JTF_NUMBER_TABLE
111 );
112 procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
113 , a1 out nocopy JTF_VARCHAR2_TABLE_100
114 , a2 out nocopy JTF_NUMBER_TABLE
115 , a3 out nocopy JTF_NUMBER_TABLE
116 , a4 out nocopy JTF_DATE_TABLE
117 , a5 out nocopy JTF_NUMBER_TABLE
118 , a6 out nocopy JTF_NUMBER_TABLE
119 , a7 out nocopy JTF_NUMBER_TABLE
120 , a8 out nocopy JTF_NUMBER_TABLE
121 , a9 out nocopy JTF_NUMBER_TABLE
122 , a10 out nocopy JTF_VARCHAR2_TABLE_100
123 , a11 out nocopy JTF_VARCHAR2_TABLE_300
124 , a12 out nocopy JTF_VARCHAR2_TABLE_300
125 , a13 out nocopy JTF_NUMBER_TABLE
126 , a14 out nocopy JTF_NUMBER_TABLE
127 );
128
129 procedure create_interaction(p_api_version NUMBER
130 , p_init_msg_list VARCHAR2
131 , p_commit VARCHAR2
132 , p_resp_appl_id NUMBER
133 , p_resp_id NUMBER
134 , p_user_id NUMBER
135 , p_login_id NUMBER
136 , x_return_status out nocopy VARCHAR2
137 , x_msg_count out nocopy NUMBER
138 , x_msg_data out nocopy VARCHAR2
139 , p11_a0 JTF_NUMBER_TABLE
140 , p11_a1 JTF_NUMBER_TABLE
141 , p11_a2 JTF_NUMBER_TABLE
142 , p11_a3 JTF_NUMBER_TABLE
143 , p11_a4 JTF_VARCHAR2_TABLE_300
144 , p11_a5 JTF_DATE_TABLE
145 , p11_a6 JTF_DATE_TABLE
146 , p11_a7 JTF_NUMBER_TABLE
147 , p11_a8 JTF_NUMBER_TABLE
148 , p11_a9 JTF_VARCHAR2_TABLE_100
149 , p11_a10 JTF_VARCHAR2_TABLE_100
150 , p11_a11 JTF_NUMBER_TABLE
151 , p11_a12 JTF_NUMBER_TABLE
152 , p11_a13 JTF_NUMBER_TABLE
153 , p11_a14 JTF_NUMBER_TABLE
154 , p11_a15 JTF_NUMBER_TABLE
155 , p11_a16 JTF_NUMBER_TABLE
156 , p11_a17 JTF_VARCHAR2_TABLE_1000
157 , p11_a18 JTF_NUMBER_TABLE
158 , p11_a19 JTF_VARCHAR2_TABLE_300
159 , p11_a20 JTF_NUMBER_TABLE
160 , p11_a21 JTF_VARCHAR2_TABLE_100
161 , p11_a22 JTF_NUMBER_TABLE
162 , p11_a23 JTF_VARCHAR2_TABLE_100
163 , p11_a24 JTF_NUMBER_TABLE
164 , p11_a25 JTF_VARCHAR2_TABLE_200
165 , p11_a26 JTF_VARCHAR2_TABLE_200
166 , p11_a27 JTF_VARCHAR2_TABLE_200
167 , p11_a28 JTF_VARCHAR2_TABLE_200
168 , p11_a29 JTF_VARCHAR2_TABLE_200
169 , p11_a30 JTF_VARCHAR2_TABLE_200
170 , p11_a31 JTF_VARCHAR2_TABLE_200
171 , p11_a32 JTF_VARCHAR2_TABLE_200
172 , p11_a33 JTF_VARCHAR2_TABLE_200
173 , p11_a34 JTF_VARCHAR2_TABLE_200
174 , p11_a35 JTF_VARCHAR2_TABLE_200
175 , p11_a36 JTF_VARCHAR2_TABLE_200
176 , p11_a37 JTF_VARCHAR2_TABLE_200
177 , p11_a38 JTF_VARCHAR2_TABLE_200
178 , p11_a39 JTF_VARCHAR2_TABLE_200
179 , p11_a40 JTF_VARCHAR2_TABLE_100
180 , p11_a41 JTF_VARCHAR2_TABLE_300
181 , p11_a42 JTF_VARCHAR2_TABLE_300
182 , p11_a43 JTF_NUMBER_TABLE
183 , p11_a44 JTF_NUMBER_TABLE
184 , p10_a0 NUMBER := 0-1962.0724
185 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
186 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
187 , p10_a3 NUMBER := 0-1962.0724
188 , p10_a4 DATE := fnd_api.g_miss_date
189 , p10_a5 NUMBER := 0-1962.0724
190 , p10_a6 NUMBER := 0-1962.0724
191 , p10_a7 NUMBER := 0-1962.0724
192 , p10_a8 NUMBER := 0-1962.0724
193 , p10_a9 DATE := fnd_api.g_miss_date
194 , p10_a10 NUMBER := 0-1962.0724
195 , p10_a11 NUMBER := 0-1962.0724
196 , p10_a12 NUMBER := 0-1962.0724
197 , p10_a13 NUMBER := 0-1962.0724
198 , p10_a14 NUMBER := 0-1962.0724
199 , p10_a15 NUMBER := 0-1962.0724
200 , p10_a16 NUMBER := 0-1962.0724
201 , p10_a17 NUMBER := 0-1962.0724
202 , p10_a18 NUMBER := 0-1962.0724
203 , p10_a19 NUMBER := 0-1962.0724
204 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
205 , p10_a21 NUMBER := 0-1962.0724
206 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
207 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
208 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
209 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
210 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
211 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
212 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
213 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
214 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
215 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
216 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
217 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
218 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
219 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
220 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
221 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
222 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
223 , p10_a39 VARCHAR2 := 'PARTY'
224 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
225 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
226 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
227 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
228 , p10_a44 NUMBER := 0-1962.0724
229 , p10_a45 NUMBER := 0-1962.0724
230 , p10_a46 NUMBER := 0-1962.0724
231 , p10_a47 NUMBER := 0-1962.0724
232 , p10_a48 NUMBER := 0-1962.0724
233 );
234 procedure create_mediaitem(p_api_version NUMBER
235 , p_init_msg_list VARCHAR2
236 , p_commit VARCHAR2
237 , p_resp_appl_id NUMBER
238 , p_resp_id NUMBER
239 , p_user_id NUMBER
240 , p_login_id NUMBER
241 , x_return_status out nocopy VARCHAR2
242 , x_msg_count out nocopy NUMBER
243 , x_msg_data out nocopy VARCHAR2
244 , p11_a0 JTF_DATE_TABLE
245 , p11_a1 JTF_VARCHAR2_TABLE_100
246 , p11_a2 JTF_NUMBER_TABLE
247 , p11_a3 JTF_NUMBER_TABLE
248 , p11_a4 JTF_DATE_TABLE
249 , p11_a5 JTF_NUMBER_TABLE
250 , p11_a6 JTF_NUMBER_TABLE
251 , p11_a7 JTF_NUMBER_TABLE
252 , p11_a8 JTF_NUMBER_TABLE
253 , p11_a9 JTF_NUMBER_TABLE
254 , p11_a10 JTF_VARCHAR2_TABLE_100
255 , p11_a11 JTF_VARCHAR2_TABLE_300
256 , p11_a12 JTF_VARCHAR2_TABLE_300
257 , p11_a13 JTF_NUMBER_TABLE
258 , p11_a14 JTF_NUMBER_TABLE
259 , p10_a0 NUMBER := 0-1962.0724
260 , p10_a1 NUMBER := 0-1962.0724
261 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
262 , p10_a3 NUMBER := 0-1962.0724
263 , p10_a4 DATE := fnd_api.g_miss_date
264 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
265 , p10_a6 DATE := fnd_api.g_miss_date
266 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
267 , p10_a8 DATE := fnd_api.g_miss_date
268 , p10_a9 NUMBER := 0-1962.0724
269 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
270 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
271 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
272 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
273 , p10_a14 NUMBER := 0-1962.0724
274 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
275 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
276 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
277 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
278 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
279 , p10_a20 NUMBER := 0-1962.0724
280 , p10_a21 NUMBER := 0-1962.0724
281 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
282 );
283 procedure create_mediaitem(p_api_version NUMBER
284 , p_init_msg_list VARCHAR2
285 , p_commit VARCHAR2
286 , p_resp_appl_id NUMBER
287 , p_resp_id NUMBER
288 , p_user_id NUMBER
289 , p_login_id NUMBER
290 , x_return_status out nocopy VARCHAR2
291 , x_msg_count out nocopy NUMBER
292 , x_msg_data out nocopy VARCHAR2
293 , x_media_id out nocopy NUMBER
294 , p10_a0 NUMBER := 0-1962.0724
295 , p10_a1 NUMBER := 0-1962.0724
296 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
297 , p10_a3 NUMBER := 0-1962.0724
298 , p10_a4 DATE := fnd_api.g_miss_date
299 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
300 , p10_a6 DATE := fnd_api.g_miss_date
301 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
302 , p10_a8 DATE := fnd_api.g_miss_date
303 , p10_a9 NUMBER := 0-1962.0724
304 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
305 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
306 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
307 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
308 , p10_a14 NUMBER := 0-1962.0724
309 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
310 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
311 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
312 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
313 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
314 , p10_a20 NUMBER := 0-1962.0724
315 , p10_a21 NUMBER := 0-1962.0724
316 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
317 );
318 procedure create_medialifecycle(p_api_version NUMBER
319 , p_init_msg_list VARCHAR2
320 , p_commit VARCHAR2
321 , p_resp_appl_id NUMBER
322 , p_resp_id NUMBER
323 , p_user_id NUMBER
324 , p_login_id NUMBER
325 , x_return_status out nocopy VARCHAR2
326 , x_msg_count out nocopy NUMBER
327 , x_msg_data out nocopy VARCHAR2
328 , p10_a0 DATE := fnd_api.g_miss_date
329 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
330 , p10_a2 NUMBER := 0-1962.0724
331 , p10_a3 NUMBER := 0-1962.0724
332 , p10_a4 DATE := fnd_api.g_miss_date
333 , p10_a5 NUMBER := 0-1962.0724
334 , p10_a6 NUMBER := 0-1962.0724
335 , p10_a7 NUMBER := 0-1962.0724
336 , p10_a8 NUMBER := 0-1962.0724
337 , p10_a9 NUMBER := 0-1962.0724
338 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
339 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
340 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
341 , p10_a13 NUMBER := 0-1962.0724
342 , p10_a14 NUMBER := 0-1962.0724
343 );
344 procedure open_interaction(p_api_version NUMBER
345 , p_init_msg_list VARCHAR2
346 , p_commit VARCHAR2
347 , p_resp_appl_id NUMBER
348 , p_resp_id NUMBER
349 , p_user_id NUMBER
350 , p_login_id NUMBER
351 , x_return_status out nocopy VARCHAR2
352 , x_msg_count out nocopy NUMBER
353 , x_msg_data out nocopy VARCHAR2
354 , x_interaction_id out nocopy NUMBER
355 , p10_a0 NUMBER := 0-1962.0724
356 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
357 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
358 , p10_a3 NUMBER := 0-1962.0724
359 , p10_a4 DATE := fnd_api.g_miss_date
360 , p10_a5 NUMBER := 0-1962.0724
361 , p10_a6 NUMBER := 0-1962.0724
362 , p10_a7 NUMBER := 0-1962.0724
363 , p10_a8 NUMBER := 0-1962.0724
364 , p10_a9 DATE := fnd_api.g_miss_date
365 , p10_a10 NUMBER := 0-1962.0724
366 , p10_a11 NUMBER := 0-1962.0724
367 , p10_a12 NUMBER := 0-1962.0724
368 , p10_a13 NUMBER := 0-1962.0724
369 , p10_a14 NUMBER := 0-1962.0724
370 , p10_a15 NUMBER := 0-1962.0724
371 , p10_a16 NUMBER := 0-1962.0724
372 , p10_a17 NUMBER := 0-1962.0724
373 , p10_a18 NUMBER := 0-1962.0724
374 , p10_a19 NUMBER := 0-1962.0724
375 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
376 , p10_a21 NUMBER := 0-1962.0724
377 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
378 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
379 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
380 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
381 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
382 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
383 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
384 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
385 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
386 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
387 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
388 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
389 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
390 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
391 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
392 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
393 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
394 , p10_a39 VARCHAR2 := 'PARTY'
395 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
396 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
397 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
398 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
399 , p10_a44 NUMBER := 0-1962.0724
400 , p10_a45 NUMBER := 0-1962.0724
401 , p10_a46 NUMBER := 0-1962.0724
402 , p10_a47 NUMBER := 0-1962.0724
403 , p10_a48 NUMBER := 0-1962.0724
404 );
405 procedure update_interaction(p_api_version NUMBER
406 , p_init_msg_list VARCHAR2
407 , p_commit VARCHAR2
408 , p_resp_appl_id NUMBER
409 , p_resp_id NUMBER
410 , p_user_id NUMBER
411 , p_login_id NUMBER
412 , x_return_status out nocopy VARCHAR2
413 , x_msg_count out nocopy NUMBER
414 , x_msg_data out nocopy VARCHAR2
415 , p_object_version NUMBER DEFAULT NULL
416 , p10_a0 NUMBER := 0-1962.0724
417 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
418 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
419 , p10_a3 NUMBER := 0-1962.0724
420 , p10_a4 DATE := fnd_api.g_miss_date
421 , p10_a5 NUMBER := 0-1962.0724
422 , p10_a6 NUMBER := 0-1962.0724
423 , p10_a7 NUMBER := 0-1962.0724
424 , p10_a8 NUMBER := 0-1962.0724
425 , p10_a9 DATE := fnd_api.g_miss_date
426 , p10_a10 NUMBER := 0-1962.0724
427 , p10_a11 NUMBER := 0-1962.0724
428 , p10_a12 NUMBER := 0-1962.0724
429 , p10_a13 NUMBER := 0-1962.0724
430 , p10_a14 NUMBER := 0-1962.0724
431 , p10_a15 NUMBER := 0-1962.0724
432 , p10_a16 NUMBER := 0-1962.0724
433 , p10_a17 NUMBER := 0-1962.0724
434 , p10_a18 NUMBER := 0-1962.0724
435 , p10_a19 NUMBER := 0-1962.0724
436 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
437 , p10_a21 NUMBER := 0-1962.0724
438 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
439 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
440 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
441 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
442 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
443 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
444 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
445 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
446 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
447 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
448 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
449 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
450 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
451 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
452 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
453 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
454 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
455 , p10_a39 VARCHAR2 := 'PARTY'
456 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
457 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
458 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
459 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
460 , p10_a44 NUMBER := 0-1962.0724
461 , p10_a45 NUMBER := 0-1962.0724
462 , p10_a46 NUMBER := 0-1962.0724
463 , p10_a47 NUMBER := 0-1962.0724
464 , p10_a48 NUMBER := 0-1962.0724
465 );
466 procedure close_interaction(p_api_version NUMBER
467 , p_init_msg_list VARCHAR2
468 , p_commit VARCHAR2
469 , p_resp_appl_id NUMBER
470 , p_resp_id NUMBER
471 , p_user_id NUMBER
472 , p_login_id NUMBER
473 , x_return_status out nocopy VARCHAR2
474 , x_msg_count out nocopy NUMBER
475 , x_msg_data out nocopy VARCHAR2
476 , p_object_version NUMBER DEFAULT NULL
477 , p10_a0 NUMBER := 0-1962.0724
478 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
479 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
480 , p10_a3 NUMBER := 0-1962.0724
481 , p10_a4 DATE := fnd_api.g_miss_date
482 , p10_a5 NUMBER := 0-1962.0724
483 , p10_a6 NUMBER := 0-1962.0724
484 , p10_a7 NUMBER := 0-1962.0724
485 , p10_a8 NUMBER := 0-1962.0724
486 , p10_a9 DATE := fnd_api.g_miss_date
487 , p10_a10 NUMBER := 0-1962.0724
488 , p10_a11 NUMBER := 0-1962.0724
489 , p10_a12 NUMBER := 0-1962.0724
490 , p10_a13 NUMBER := 0-1962.0724
491 , p10_a14 NUMBER := 0-1962.0724
492 , p10_a15 NUMBER := 0-1962.0724
493 , p10_a16 NUMBER := 0-1962.0724
494 , p10_a17 NUMBER := 0-1962.0724
495 , p10_a18 NUMBER := 0-1962.0724
496 , p10_a19 NUMBER := 0-1962.0724
497 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
498 , p10_a21 NUMBER := 0-1962.0724
499 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
500 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
501 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
502 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
503 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
504 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
505 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
506 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
507 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
508 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
509 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
510 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
511 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
512 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
513 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
514 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
515 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
516 , p10_a39 VARCHAR2 := 'PARTY'
517 , p10_a40 VARCHAR2 := 'RS_EMPLOYEE'
518 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
519 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
520 , p10_a43 VARCHAR2 := fnd_api.g_miss_char
521 , p10_a44 NUMBER := 0-1962.0724
522 , p10_a45 NUMBER := 0-1962.0724
523 , p10_a46 NUMBER := 0-1962.0724
524 , p10_a47 NUMBER := 0-1962.0724
525 , p10_a48 NUMBER := 0-1962.0724
526 );
527 procedure add_activity(p_api_version NUMBER
528 , p_init_msg_list VARCHAR2
529 , p_commit VARCHAR2
530 , p_resp_appl_id NUMBER
531 , p_resp_id NUMBER
532 , p_user_id NUMBER
533 , p_login_id NUMBER
534 , x_return_status out nocopy VARCHAR2
535 , x_msg_count out nocopy NUMBER
536 , x_msg_data out nocopy VARCHAR2
537 , x_activity_id out nocopy NUMBER
538 , p10_a0 NUMBER := 0-1962.0724
539 , p10_a1 NUMBER := 0-1962.0724
540 , p10_a2 NUMBER := 0-1962.0724
541 , p10_a3 NUMBER := 0-1962.0724
542 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
543 , p10_a5 DATE := fnd_api.g_miss_date
544 , p10_a6 DATE := fnd_api.g_miss_date
545 , p10_a7 NUMBER := 0-1962.0724
546 , p10_a8 NUMBER := 0-1962.0724
547 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
548 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
549 , p10_a11 NUMBER := 0-1962.0724
550 , p10_a12 NUMBER := 0-1962.0724
551 , p10_a13 NUMBER := 0-1962.0724
552 , p10_a14 NUMBER := 0-1962.0724
553 , p10_a15 NUMBER := 0-1962.0724
554 , p10_a16 NUMBER := 0-1962.0724
555 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
556 , p10_a18 NUMBER := 0-1962.0724
557 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
558 , p10_a20 NUMBER := 0-1962.0724
559 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
560 , p10_a22 NUMBER := 0-1962.0724
561 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
562 , p10_a24 NUMBER := 0-1962.0724
563 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
564 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
565 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
566 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
567 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
568 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
569 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
570 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
571 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
572 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
573 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
574 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
575 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
576 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
577 , p10_a39 VARCHAR2 := fnd_api.g_miss_char
578 , p10_a40 VARCHAR2 := fnd_api.g_miss_char
579 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
580 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
581 , p10_a43 NUMBER := 0-1962.0724
582 , p10_a44 NUMBER := 0-1962.0724
583 );
584 procedure update_activity(p_api_version NUMBER
585 , p_init_msg_list VARCHAR2
586 , p_commit VARCHAR2
587 , p_resp_appl_id NUMBER
588 , p_resp_id NUMBER
589 , p_user_id NUMBER
590 , p_login_id NUMBER
591 , x_return_status out nocopy VARCHAR2
592 , x_msg_count out nocopy NUMBER
593 , x_msg_data out nocopy VARCHAR2
594 , p_object_version NUMBER DEFAULT NULL
595 , p10_a0 NUMBER := 0-1962.0724
596 , p10_a1 NUMBER := 0-1962.0724
597 , p10_a2 NUMBER := 0-1962.0724
598 , p10_a3 NUMBER := 0-1962.0724
599 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
600 , p10_a5 DATE := fnd_api.g_miss_date
601 , p10_a6 DATE := fnd_api.g_miss_date
602 , p10_a7 NUMBER := 0-1962.0724
603 , p10_a8 NUMBER := 0-1962.0724
604 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
605 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
606 , p10_a11 NUMBER := 0-1962.0724
607 , p10_a12 NUMBER := 0-1962.0724
608 , p10_a13 NUMBER := 0-1962.0724
609 , p10_a14 NUMBER := 0-1962.0724
610 , p10_a15 NUMBER := 0-1962.0724
611 , p10_a16 NUMBER := 0-1962.0724
612 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
613 , p10_a18 NUMBER := 0-1962.0724
614 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
615 , p10_a20 NUMBER := 0-1962.0724
616 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
617 , p10_a22 NUMBER := 0-1962.0724
618 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
619 , p10_a24 NUMBER := 0-1962.0724
620 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
621 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
622 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
623 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
624 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
625 , p10_a30 VARCHAR2 := fnd_api.g_miss_char
626 , p10_a31 VARCHAR2 := fnd_api.g_miss_char
627 , p10_a32 VARCHAR2 := fnd_api.g_miss_char
628 , p10_a33 VARCHAR2 := fnd_api.g_miss_char
629 , p10_a34 VARCHAR2 := fnd_api.g_miss_char
630 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
631 , p10_a36 VARCHAR2 := fnd_api.g_miss_char
632 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
633 , p10_a38 VARCHAR2 := fnd_api.g_miss_char
634 , p10_a39 VARCHAR2 := fnd_api.g_miss_char
635 , p10_a40 VARCHAR2 := fnd_api.g_miss_char
636 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
637 , p10_a42 VARCHAR2 := fnd_api.g_miss_char
638 , p10_a43 NUMBER := 0-1962.0724
639 , p10_a44 NUMBER := 0-1962.0724
640 );
641 procedure update_activityduration(p_api_version NUMBER
642 , p_init_msg_list VARCHAR2
643 , p_commit VARCHAR2
644 , p_resp_appl_id NUMBER
645 , p_resp_id NUMBER
646 , p_user_id NUMBER
647 , p_login_id NUMBER
648 , x_return_status out nocopy VARCHAR2
649 , x_msg_count out nocopy NUMBER
650 , x_msg_data out nocopy VARCHAR2
651 , p_activity_id NUMBER
652 , p_end_date_time date
653 , p_duration NUMBER
654 , p_object_version NUMBER DEFAULT NULL
655 );
656 procedure open_mediaitem(p_api_version NUMBER
657 , p_init_msg_list VARCHAR2
658 , p_commit VARCHAR2
659 , p_resp_appl_id NUMBER
660 , p_resp_id NUMBER
661 , p_user_id NUMBER
662 , p_login_id NUMBER
663 , x_return_status out nocopy VARCHAR2
664 , x_msg_count out nocopy NUMBER
665 , x_msg_data out nocopy VARCHAR2
666 , x_media_id out nocopy NUMBER
667 , p10_a0 NUMBER := 0-1962.0724
668 , p10_a1 NUMBER := 0-1962.0724
669 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
670 , p10_a3 NUMBER := 0-1962.0724
671 , p10_a4 DATE := fnd_api.g_miss_date
672 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
673 , p10_a6 DATE := fnd_api.g_miss_date
674 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
675 , p10_a8 DATE := fnd_api.g_miss_date
676 , p10_a9 NUMBER := 0-1962.0724
677 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
678 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
679 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
680 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
681 , p10_a14 NUMBER := 0-1962.0724
682 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
683 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
684 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
685 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
686 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
687 , p10_a20 NUMBER := 0-1962.0724
688 , p10_a21 NUMBER := 0-1962.0724
689 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
690 );
691 procedure update_mediaitem(p_api_version NUMBER
692 , p_init_msg_list VARCHAR2
693 , p_commit VARCHAR2
694 , p_resp_appl_id NUMBER
695 , p_resp_id NUMBER
696 , p_user_id NUMBER
697 , p_login_id NUMBER
698 , x_return_status out nocopy VARCHAR2
699 , x_msg_count out nocopy NUMBER
700 , x_msg_data out nocopy VARCHAR2
701 , p_object_version NUMBER DEFAULT NULL
702 , p10_a0 NUMBER := 0-1962.0724
703 , p10_a1 NUMBER := 0-1962.0724
704 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
705 , p10_a3 NUMBER := 0-1962.0724
706 , p10_a4 DATE := fnd_api.g_miss_date
707 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
708 , p10_a6 DATE := fnd_api.g_miss_date
709 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
710 , p10_a8 DATE := fnd_api.g_miss_date
711 , p10_a9 NUMBER := 0-1962.0724
712 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
713 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
714 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
715 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
716 , p10_a14 NUMBER := 0-1962.0724
717 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
718 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
719 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
720 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
721 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
722 , p10_a20 NUMBER := 0-1962.0724
723 , p10_a21 NUMBER := 0-1962.0724
724 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
725 );
726 procedure close_mediaitem(p_api_version NUMBER
727 , p_init_msg_list VARCHAR2
728 , p_commit VARCHAR2
729 , p_resp_appl_id NUMBER
730 , p_resp_id NUMBER
731 , p_user_id NUMBER
732 , p_login_id NUMBER
733 , x_return_status out nocopy VARCHAR2
734 , x_msg_count out nocopy NUMBER
735 , x_msg_data out nocopy VARCHAR2
736 , p_object_version NUMBER DEFAULT NULL
737 , p10_a0 NUMBER := 0-1962.0724
738 , p10_a1 NUMBER := 0-1962.0724
739 , p10_a2 VARCHAR2 := fnd_api.g_miss_char
740 , p10_a3 NUMBER := 0-1962.0724
741 , p10_a4 DATE := fnd_api.g_miss_date
742 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
743 , p10_a6 DATE := fnd_api.g_miss_date
744 , p10_a7 VARCHAR2 := fnd_api.g_miss_char
745 , p10_a8 DATE := fnd_api.g_miss_date
746 , p10_a9 NUMBER := 0-1962.0724
747 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
748 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
749 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
750 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
751 , p10_a14 NUMBER := 0-1962.0724
752 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
753 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
754 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
755 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
756 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
757 , p10_a20 NUMBER := 0-1962.0724
758 , p10_a21 NUMBER := 0-1962.0724
759 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
760 );
761 procedure add_medialifecycle(p_api_version NUMBER
762 , p_init_msg_list VARCHAR2
763 , p_commit VARCHAR2
764 , p_resp_appl_id NUMBER
765 , p_resp_id NUMBER
766 , p_user_id NUMBER
767 , p_login_id NUMBER
768 , x_return_status out nocopy VARCHAR2
769 , x_msg_count out nocopy NUMBER
770 , x_msg_data out nocopy VARCHAR2
771 , x_milcs_id out nocopy NUMBER
772 , p10_a0 DATE := fnd_api.g_miss_date
773 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
774 , p10_a2 NUMBER := 0-1962.0724
775 , p10_a3 NUMBER := 0-1962.0724
776 , p10_a4 DATE := fnd_api.g_miss_date
777 , p10_a5 NUMBER := 0-1962.0724
778 , p10_a6 NUMBER := 0-1962.0724
779 , p10_a7 NUMBER := 0-1962.0724
780 , p10_a8 NUMBER := 0-1962.0724
781 , p10_a9 NUMBER := 0-1962.0724
782 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
783 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
784 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
785 , p10_a13 NUMBER := 0-1962.0724
786 , p10_a14 NUMBER := 0-1962.0724
787 );
788 procedure update_medialifecycle(p_api_version NUMBER
789 , p_init_msg_list VARCHAR2
790 , p_commit VARCHAR2
791 , p_resp_appl_id NUMBER
792 , p_resp_id NUMBER
793 , p_user_id NUMBER
794 , p_login_id NUMBER
795 , x_return_status out nocopy VARCHAR2
796 , x_msg_count out nocopy NUMBER
797 , x_msg_data out nocopy VARCHAR2
798 , p_object_version NUMBER DEFAULT NULL
799 , p10_a0 DATE := fnd_api.g_miss_date
800 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
801 , p10_a2 NUMBER := 0-1962.0724
802 , p10_a3 NUMBER := 0-1962.0724
803 , p10_a4 DATE := fnd_api.g_miss_date
804 , p10_a5 NUMBER := 0-1962.0724
805 , p10_a6 NUMBER := 0-1962.0724
806 , p10_a7 NUMBER := 0-1962.0724
807 , p10_a8 NUMBER := 0-1962.0724
808 , p10_a9 NUMBER := 0-1962.0724
809 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
810 , p10_a11 VARCHAR2 := fnd_api.g_miss_char
811 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
812 , p10_a13 NUMBER := 0-1962.0724
813 , p10_a14 NUMBER := 0-1962.0724
814 );
815 end jtf_ih_pub_w;