[Home] [Help]
PACKAGE: APPS.JTF_IH_PUB_VUHK
Source
1 PACKAGE JTF_IH_PUB_VUHK AUTHID CURRENT_USER AS
2 /* $Header: JTFIHPKS.pls 115.6 2002/11/08 18:46:19 ialeshin ship $ */
3
4 --
5 -- AUTHOR DATE MODIFICATION DESCRIPTION
6 -- ------ ---- ------------------------
7 -- JAMES BALDO JR. 11-JAN-2000 INITIAL IMPLEMENATION
8 --
9 PROCEDURE create_interaction_pre (
10 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
11 , p_activities IN JTF_IH_PUB.ACTIVITY_TBL_TYPE
12 , x_data OUT NOCOPY VARCHAR2
13 , x_count OUT NOCOPY NUMBER
14 , x_return_code OUT NOCOPY VARCHAR2
15 );
16
17 --
18 -- AUTHOR DATE MODIFICATION DESCRIPTION
19 -- ------ ---- ------------------------
20 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
21 --
22 PROCEDURE create_interaction_post (
23 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
24 , p_activities IN JTF_IH_PUB.ACTIVITY_TBL_TYPE
25 , x_data OUT NOCOPY VARCHAR2
26 , x_count OUT NOCOPY NUMBER
27 , x_return_code OUT NOCOPY VARCHAR2
28 );
29
30 --
31 -- AUTHOR DATE MODIFICATION DESCRIPTION
32 -- ------ ---- ------------------------
33 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
34 --
35 PROCEDURE create_mediaitem_pre (
36 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
37 , x_data OUT NOCOPY VARCHAR2
38 , x_count OUT NOCOPY NUMBER
39 , x_return_code OUT NOCOPY VARCHAR2
40 );
41
42 --
43 -- AUTHOR DATE MODIFICATION DESCRIPTION
44 -- ------ ---- ------------------------
45 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
46 --
47 PROCEDURE create_mediaitem_post (
48 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
49 , x_data OUT NOCOPY VARCHAR2
50 , x_count OUT NOCOPY NUMBER
51 , x_return_code OUT NOCOPY VARCHAR2
52 );
53
54 --
55 -- AUTHOR DATE MODIFICATION DESCRIPTION
56 -- ------ ---- ------------------------
57 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
58 --
59 PROCEDURE create_medialifecycle_pre (
60 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
61 , x_data OUT NOCOPY VARCHAR2
62 , x_count OUT NOCOPY NUMBER
63 , x_return_code OUT NOCOPY VARCHAR2
64 );
65
66 --
67 -- AUTHOR DATE MODIFICATION DESCRIPTION
68 -- ------ ---- ------------------------
69 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
70 --
71 PROCEDURE create_medialifecycle_post (
72 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
73 , x_data OUT NOCOPY VARCHAR2
74 , x_count OUT NOCOPY NUMBER
75 , x_return_code OUT NOCOPY VARCHAR2
76 );
77
78 --
79 -- AUTHOR DATE MODIFICATION DESCRIPTION
80 -- ------ ---- ------------------------
81 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
82 --
83 PROCEDURE open_interaction_pre (
84 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
85 , x_data OUT NOCOPY VARCHAR2
86 , x_count OUT NOCOPY NUMBER
87 , x_return_code OUT NOCOPY VARCHAR2
88 );
89
90 --
91 -- AUTHOR DATE MODIFICATION DESCRIPTION
92 -- ------ ---- ------------------------
93 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
94 --
95 PROCEDURE open_interaction_post (
96 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
97 , x_data OUT NOCOPY VARCHAR2
98 , x_count OUT NOCOPY NUMBER
99 , x_return_code OUT NOCOPY VARCHAR2
100 );
101
102 --
103 -- AUTHOR DATE MODIFICATION DESCRIPTION
104 -- ------ ---- ------------------------
105 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
106 --
107 PROCEDURE update_interaction_pre (
108 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
109 , x_data OUT NOCOPY VARCHAR2
110 , x_count OUT NOCOPY NUMBER
111 , x_return_code OUT NOCOPY VARCHAR2
112 );
113
114 --
115 -- AUTHOR DATE MODIFICATION DESCRIPTION
116 -- ------ ---- ------------------------
117 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
118 --
119 PROCEDURE update_interaction_post (
120 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
121 , x_data OUT NOCOPY VARCHAR2
122 , x_count OUT NOCOPY NUMBER
123 , x_return_code OUT NOCOPY VARCHAR2
124 );
125
126 --
127 -- AUTHOR DATE MODIFICATION DESCRIPTION
128 -- ------ ---- ------------------------
129 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
130 --
131 PROCEDURE close_interaction_pre (
132 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
133 , x_data OUT NOCOPY VARCHAR2
134 , x_count OUT NOCOPY NUMBER
135 , x_return_code OUT NOCOPY VARCHAR2
136 );
137
138 --
139 -- AUTHOR DATE MODIFICATION DESCRIPTION
140 -- ------ ---- ------------------------
141 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
142 --
143 PROCEDURE close_interaction_post (
144 p_interaction_rec IN JTF_IH_PUB.INTERACTION_REC_TYPE
145 , x_data OUT NOCOPY VARCHAR2
146 , x_count OUT NOCOPY NUMBER
147 , x_return_code OUT NOCOPY VARCHAR2
148 );
149
150
151 --
152 -- AUTHOR DATE MODIFICATION DESCRIPTION
153 -- ------ ---- ------------------------
154 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
155 --
156 PROCEDURE close_interaction_pre (
157 p_interaction_id IN NUMBER
158 , x_data OUT NOCOPY VARCHAR2
159 , x_count OUT NOCOPY NUMBER
160 , x_return_code OUT NOCOPY VARCHAR2
161 );
162
163 --
164 -- AUTHOR DATE MODIFICATION DESCRIPTION
165 -- ------ ---- ------------------------
166 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
167 --
168 PROCEDURE close_interaction_post (
169 p_interaction_id IN NUMBER
170 , x_data OUT NOCOPY VARCHAR2
171 , x_count OUT NOCOPY NUMBER
172 , x_return_code OUT NOCOPY VARCHAR2
173 );
174
175 --
176 -- AUTHOR DATE MODIFICATION DESCRIPTION
177 -- ------ ---- ------------------------
178 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
179 --
180 PROCEDURE add_activity_pre (
181 p_activity_rec IN JTF_IH_PUB.ACTIVITY_REC_TYPE
182 , x_data OUT NOCOPY VARCHAR2
183 , x_count OUT NOCOPY NUMBER
184 , x_return_code OUT NOCOPY VARCHAR2
185 );
186
187 --
188 -- AUTHOR DATE MODIFICATION DESCRIPTION
189 -- ------ ---- ------------------------
190 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
191 --
192 PROCEDURE add_activity_post (
193 p_activity_rec IN JTF_IH_PUB.ACTIVITY_REC_TYPE
194 , x_data OUT NOCOPY VARCHAR2
195 , x_count OUT NOCOPY NUMBER
196 , x_return_code OUT NOCOPY VARCHAR2
197 );
198
199 --
200 -- AUTHOR DATE MODIFICATION DESCRIPTION
201 -- ------ ---- ------------------------
202 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
203 --
204 PROCEDURE update_activity_pre (
205 p_activity_rec IN JTF_IH_PUB.ACTIVITY_REC_TYPE
206 , x_data OUT NOCOPY VARCHAR2
207 , x_count OUT NOCOPY NUMBER
208 , x_return_code OUT NOCOPY VARCHAR2
209 );
210
211 --
212 -- AUTHOR DATE MODIFICATION DESCRIPTION
213 -- ------ ---- ------------------------
214 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
215 --
216 PROCEDURE update_activity_post (
217 p_activity_rec IN JTF_IH_PUB.ACTIVITY_REC_TYPE
218 , x_data OUT NOCOPY VARCHAR2
219 , x_count OUT NOCOPY NUMBER
220 , x_return_code OUT NOCOPY VARCHAR2
221 );
222
223 --
224 -- AUTHOR DATE MODIFICATION DESCRIPTION
225 -- ------ ---- ------------------------
226 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
227 --
228 PROCEDURE open_mediaitem_pre (
229 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
230 , x_data OUT NOCOPY VARCHAR2
231 , x_count OUT NOCOPY NUMBER
232 , x_return_code OUT NOCOPY VARCHAR2
233 );
234
235 --
236 -- AUTHOR DATE MODIFICATION DESCRIPTION
237 -- ------ ---- ------------------------
238 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
239 --
240 PROCEDURE open_mediaitem_post (
241 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
242 , x_data OUT NOCOPY VARCHAR2
243 , x_count OUT NOCOPY NUMBER
244 , x_return_code OUT NOCOPY VARCHAR2
245 );
246
247 --
248 -- AUTHOR DATE MODIFICATION DESCRIPTION
249 -- ------ ---- ------------------------
250 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
251 --
252 PROCEDURE update_mediaitem_pre (
253 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
254 , x_data OUT NOCOPY VARCHAR2
255 , x_count OUT NOCOPY NUMBER
256 , x_return_code OUT NOCOPY VARCHAR2
257 );
258
259 --
260 -- AUTHOR DATE MODIFICATION DESCRIPTION
261 -- ------ ---- ------------------------
262 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
263 --
264 PROCEDURE update_mediaitem_post (
265 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
266 , x_data OUT NOCOPY VARCHAR2
267 , x_count OUT NOCOPY NUMBER
268 , x_return_code OUT NOCOPY VARCHAR2
269 );
270
271
272 --
273 -- AUTHOR DATE MODIFICATION DESCRIPTION
274 -- ------ ---- ------------------------
275 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
276 --
277 PROCEDURE close_mediaitem_pre (
278 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
279 , x_data OUT NOCOPY VARCHAR2
280 , x_count OUT NOCOPY NUMBER
281 , x_return_code OUT NOCOPY VARCHAR2
282 );
283
284 --
285 -- AUTHOR DATE MODIFICATION DESCRIPTION
286 -- ------ ---- ------------------------
287 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
288 --
289 PROCEDURE close_mediaitem_post (
290 p_media_rec IN JTF_IH_PUB.MEDIA_REC_TYPE
291 , x_data OUT NOCOPY VARCHAR2
292 , x_count OUT NOCOPY NUMBER
293 , x_return_code OUT NOCOPY VARCHAR2
294 );
295
296 --
297 -- AUTHOR DATE MODIFICATION DESCRIPTION
298 -- ------ ---- ------------------------
299 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
300 --
301 PROCEDURE add_medialifecycle_pre (
302 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
303 , x_data OUT NOCOPY VARCHAR2
304 , x_count OUT NOCOPY NUMBER
305 , x_return_code OUT NOCOPY VARCHAR2
306 );
307
308 --
309 -- AUTHOR DATE MODIFICATION DESCRIPTION
310 -- ------ ---- ------------------------
311 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
312 --
313 PROCEDURE add_medialifecycle_post (
314 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
315 , x_data OUT NOCOPY VARCHAR2
316 , x_count OUT NOCOPY NUMBER
317 , x_return_code OUT NOCOPY VARCHAR2
318 );
319
320 --
321 -- AUTHOR DATE MODIFICATION DESCRIPTION
322 -- ------ ---- ------------------------
323 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
324 --
325 PROCEDURE update_medialifecycle_pre (
326 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
327 , x_data OUT NOCOPY VARCHAR2
328 , x_count OUT NOCOPY NUMBER
329 , x_return_code OUT NOCOPY VARCHAR2
330 );
331
332 --
333 -- AUTHOR DATE MODIFICATION DESCRIPTION
334 -- ------ ---- ------------------------
335 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
336 --
337 PROCEDURE update_medialifecycle_post (
338 p_media_lc_rec IN JTF_IH_PUB.MEDIA_LC_REC_TYPE
339 , x_data OUT NOCOPY VARCHAR2
340 , x_count OUT NOCOPY NUMBER
341 , x_return_code OUT NOCOPY VARCHAR2
342 );
343
344 --
345 -- AUTHOR DATE MODIFICATION DESCRIPTION
346 -- ------ ---- ------------------------
347 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
348 --
349 PROCEDURE get_interactionactcnt_pre (
350 p_outcome_id IN NUMBER
351 , p_result_id IN NUMBER
352 , p_reason_id IN NUMBER
353 , p_script_id IN NUMBER
354 , p_media_id IN NUMBER
355 , x_data OUT NOCOPY VARCHAR2
356 , x_count OUT NOCOPY NUMBER
357 , x_return_code OUT NOCOPY VARCHAR2
358 );
359
360 --
361 -- AUTHOR DATE MODIFICATION DESCRIPTION
362 -- ------ ---- ------------------------
363 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
364 --
365 PROCEDURE get_interactionactcnt_post (
366 p_outcome_id IN NUMBER
367 , p_result_id IN NUMBER
368 , p_reason_id IN NUMBER
369 , p_script_id IN NUMBER
370 , p_media_id IN NUMBER
371 , x_data OUT NOCOPY VARCHAR2
372 , x_count OUT NOCOPY NUMBER
373 , x_return_code OUT NOCOPY VARCHAR2
374 );
375
376 --
377 -- AUTHOR DATE MODIFICATION DESCRIPTION
378 -- ------ ---- ------------------------
379 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
380 --
381 PROCEDURE get_interactioncount_pre (
382 p_outcome_id IN NUMBER
383 , p_result_id IN NUMBER
384 , p_reason_id IN NUMBER
385 , x_data OUT NOCOPY VARCHAR2
386 , x_count OUT NOCOPY NUMBER
387 , x_return_code OUT NOCOPY VARCHAR2
388 );
389
390 --
391 -- AUTHOR DATE MODIFICATION DESCRIPTION
392 -- ------ ---- ------------------------
393 -- JAMES BALDO JR. 25-APR-2000 INITIAL IMPLEMENATION
394 --
395 PROCEDURE get_interactioncount_post (
396 p_outcome_id IN NUMBER
397 , p_result_id IN NUMBER
398 , p_reason_id IN NUMBER
399 , x_data OUT NOCOPY VARCHAR2
400 , x_count OUT NOCOPY NUMBER
401 , x_return_code OUT NOCOPY VARCHAR2
402 );
403
404 --
405 -- AUTHOR DATE MODIFICATION DESCRIPTION
406 -- ------ ---- ------------------------
407 -- JAMES BALDO JR. 26-APR-2000 INITIAL IMPLEMENATION
408 --
409 PROCEDURE update_actduration_pre (
410 p_activity_id IN NUMBER
411 , p_end_date_time IN DATE
412 , p_duration IN NUMBER
413 , x_data OUT NOCOPY VARCHAR2
414 , x_count OUT NOCOPY NUMBER
415 , x_return_code OUT NOCOPY VARCHAR2
416 );
417
418 --
419 -- AUTHOR DATE MODIFICATION DESCRIPTION
420 -- ------ ---- ------------------------
421 -- JAMES BALDO JR. 26-APR-2000 INITIAL IMPLEMENATION
422 --
423 PROCEDURE update_actduration_post (
424 p_activity_id IN NUMBER
425 , p_end_date_time IN DATE
426 , p_duration IN NUMBER
427 , x_data OUT NOCOPY VARCHAR2
428 , x_count OUT NOCOPY NUMBER
429 , x_return_code OUT NOCOPY VARCHAR2
430 );
431
432 END JTF_IH_PUB_VUHK;