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: --
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
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: );
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
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
429: , x_count OUT NOCOPY NUMBER
430: , x_return_code OUT NOCOPY VARCHAR2
431: );
432:
433: END JTF_IH_PUB_CUHK;