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