1 PACKAGE JTF_IH_PUB_PS AUTHID CURRENT_USER AS
2 /* $Header: JTFIHPSS.pls 115.10 2000/02/29 17:58:37 pkm ship $ */
3 -- Start of comments
4 -- Procedure : Create_Interaction
5 -- Type : Public API
6 -- Usage : Creates a customer interaction record in the table
7 -- JTF_IH_INTERACTIONS and related activity(ies)
8 -- Pre-reqs : None
9 --
10 -- Standard IN Parameters:
11 -- p_api_version IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2(1) Optional
13 -- Default = FND_API.G_FALSE
14 -- p_commit IN VARCHAR2(1) Optional
15 -- Default = FND_API.G_FALSE
16 --
17 -- Standard OUT Parameters:
18 -- x_return_status OUT VARCHAR2(1)
19 -- x_msg_count OUT NUMBER
20 -- x_msg_data OUT VARCHAR2(2000)
21 --
22 -- Interaction IN Parameters:
23 -- p_resp_appl_id IN NUMBER Optional(1)
24 -- Application identifier
25 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
26 -- p_resp_id IN NUMBER Optional(1)
27 -- Responsibility identifier
28 -- Default = FND_GLOBAL.RESP_ID or NULL
29 -- p_user_id IN NUMBER Optional
30 -- Corresponds to the column USER_ID in the table
31 -- FND_USER, and identifies the Oracle
32 -- Applications user
33 -- Default = FND_GLOBAL.USER_ID
34 -- p_login_id IN NUMBER Optional
35 -- Corresponds to the column LOGIN_ID in the
36 -- table FND_LOGINS, and identifies the login session
37 -- Default = FND_GLOBAL.LOGIN_ID or NULL
38 -- p_interaction_rec IN interaction_rec_type
39 -- p_activities IN activity_tbl_type
40 --
41 -- interaction_rec_type is the structure that captures the interaction and has the following
42 -- attributes:
43 -- reference_form VARCHAR2 Optional
44 -- follow_up_action VARCHAR2 Optional
45 -- duration NUMBER Optional
46 -- end_date_time DATE Optional
47 -- inter_interaction_duration NUMBER Optional
48 -- interaction_id NUMBER
49 -- non_productive_time_amount NUMBER Optional
50 -- preview_time_amount NUMBER Optional
51 -- productive_time_amount NUMBER Optiona
52 -- start_date_time DATE Optional
53 -- wrapUp_time_amount NUMBER Optional
54 -- handler_id NUMBER Optional
55 -- script_id NUMBER Optional
56 -- outcome_id NUMBER Optional
57 -- result_id NUMBER Optional
58 -- reason_id NUMBER Optional
59 -- resource_subtype_id NUMBER Optional
60 -- resource_type_id NUMBER Optional
61 -- resource_id NUMBER Optional
62 -- party_id NUMBER Optional
63 -- parent_id NUMBER Optional
64 -- object_id NUMBER Optional
65 -- object_type VARCHAR2 Optional
66 -- source_code_id NUMBER Optional
67 -- source_code VARCHAR2 Optional
68 -- attribute1 VARCHAR2 Optional(2)
69 -- attribute2 VARCHAR2 Optional(2)
70 -- attribute3 VARCHAR2 Optional(2)
71 -- attribute4 VARCHAR2 Optional(2)
72 -- attribute5 VARCHAR2 Optional(2)
73 -- attribute6 VARCHAR2 Optional(2)
74 -- attribute7 VARCHAR2 Optional(2)
75 -- attribute8 VARCHAR2 Optional(2)
76 -- attribute9 VARCHAR2 Optional(2)
77 -- attribute10 VARCHAR2 Optional(2)
78 -- attribute11 VARCHAR2 Optional(2)
79 -- attribute12 VARCHAR2 Optional(2)
80 -- attribute13 VARCHAR2 Optional(2)
81 -- attribute14 VARCHAR2 Optional(2)
82 -- attribute15 VARCHAR2 Optional(2)
83 -- attribute_category VARCHAR2 Optional(2)
84 --
85 -- activity_rec_type is the structure that captures the activity and has the following attributes:
86 --
87 -- duration NUMBER
88 -- end_date_time DATE
89 -- start_date_time DATE
90 -- task_id NUMBER
91 -- doc_id NUMBER
92 -- doc_ref VARCHAR2
93 -- media_id NUMBER
94 -- action_item_id VARCHAR2
95 -- interaction_id NUMBER
96 -- activity_id NUMBER
97 -- outcome_id NUMBER
98 -- result_id NUMBER
99 -- reason_id NUMBER
100 -- description VARCHAR2
101 -- action_id VARCHAR2
102 -- arole VARCHAR2
103 -- interaction_action_type VARCHAR2
104 -- object_id NUMBER Optional
105 -- object_type VARCHAR2 Optional
106 -- source_code_id NUMBER Optional
107 -- source_code VARCHAR2 Optional
108 --
109 -- activity_tbl_type is the pl/sql table that used to bundle the set of activities
110 --
111 -- Version : Initial version 1.0
112 --
113 -- Notes :
114 -- (1) The application ID, responsibility ID, and user ID determine which
115 -- profile values are used as default.
116 -- (2) You must pass in segment IDs for none or all descriptive flexfield
117 -- columns that might be used in the descriptive flexfield.
118 --
119 -- End of comments
120
121 TYPE interaction_rec_type IS RECORD
122 (
123 interaction_id NUMBER :=fnd_api.g_miss_num,
124 reference_form VARCHAR2(1000) :=fnd_api.g_miss_char,
125 follow_up_action VARCHAR2(80) :=fnd_api.g_miss_char,
126 duration NUMBER := fnd_api.g_miss_num,
127 end_date_time DATE :=fnd_api.g_miss_date,
128 inter_interaction_duration NUMBER :=fnd_api.g_miss_num,
129 non_productive_time_amount NUMBER :=fnd_api.g_miss_num,
130 preview_time_amount NUMBER :=fnd_api.g_miss_num,
131 productive_time_amount NUMBER :=fnd_api.g_miss_num,
132 start_date_time DATE :=fnd_api.g_miss_date,
133 wrapUp_time_amount NUMBER :=fnd_api.g_miss_num,
134 handler_id NUMBER :=fnd_api.g_miss_num,
135 script_id NUMBER :=fnd_api.g_miss_num,
136 outcome_id NUMBER :=fnd_api.g_miss_num,
137 result_id NUMBER :=fnd_api.g_miss_num,
138 reason_id NUMBER :=fnd_api.g_miss_num,
139 resource_id NUMBER :=fnd_api.g_miss_num,
140 party_id NUMBER :=fnd_api.g_miss_num,
141 parent_id NUMBER :=fnd_api.g_miss_num,
142 object_id NUMBER :=fnd_api.g_miss_num,
143 object_type VARCHAR2(30) :=fnd_api.g_miss_char,
144 source_code_id NUMBER :=fnd_api.g_miss_num,
145 source_code VARCHAR2(30) :=fnd_api.g_miss_char,
146 attribute1 VARCHAR2(150) :=fnd_api.g_miss_char,
147 attribute2 VARCHAR2(150) :=fnd_api.g_miss_char,
148 attribute3 VARCHAR2(150) :=fnd_api.g_miss_char,
149 attribute4 VARCHAR2(150) :=fnd_api.g_miss_char,
150 attribute5 VARCHAR2(150) :=fnd_api.g_miss_char,
151 attribute6 VARCHAR2(150) :=fnd_api.g_miss_char,
152 attribute7 VARCHAR2(150) :=fnd_api.g_miss_char,
153 attribute8 VARCHAR2(150) :=fnd_api.g_miss_char,
154 attribute9 VARCHAR2(150) :=fnd_api.g_miss_char,
155 attribute10 VARCHAR2(150) :=fnd_api.g_miss_char,
156 attribute11 VARCHAR2(150) :=fnd_api.g_miss_char,
157 attribute12 VARCHAR2(150) :=fnd_api.g_miss_char,
158 attribute13 VARCHAR2(150) :=fnd_api.g_miss_char,
159 attribute14 VARCHAR2(150) :=fnd_api.g_miss_char,
160 attribute15 VARCHAR2(150) :=fnd_api.g_miss_char,
161 attribute_category VARCHAR2(30) :=fnd_api.g_miss_char
162 );
163
164 FUNCTION INIT_INTERACTION_REC RETURN interaction_rec_type;
165
166 TYPE activity_rec_type IS RECORD
167 (
168 activity_id NUMBER := fnd_api.g_miss_num,
169 duration NUMBER :=fnd_api.g_miss_num,
170 cust_account_id NUMBER := fnd_api.g_miss_num,
171 cust_org_id NUMBER := fnd_api.g_miss_num,
172 role VARCHAR2(240) := fnd_api.g_miss_char,
173 end_date_time DATE :=fnd_api.g_miss_date,
174 start_date_time DATE :=fnd_api.g_miss_date,
175 task_id NUMBER :=fnd_api.g_miss_num,
176 doc_id NUMBER :=fnd_api.g_miss_num,
177 doc_ref VARCHAR2(80) :=fnd_api.g_miss_char,
178 media_id NUMBER :=fnd_api.g_miss_num,
179 action_item_id NUMBER :=fnd_api.g_miss_num,
180 interaction_id NUMBER :=fnd_api.g_miss_num,
181 outcome_id NUMBER :=fnd_api.g_miss_num,
182 result_id NUMBER :=fnd_api.g_miss_num,
183 reason_id NUMBER :=fnd_api.g_miss_num,
184 description VARCHAR2(1000) :=fnd_api.g_miss_char,
185 action_id NUMBER :=fnd_api.g_miss_num,
186 interaction_action_type VARCHAR2(240) :=fnd_api.g_miss_char,
187 object_id NUMBER :=fnd_api.g_miss_num,
188 object_type VARCHAR2(30) :=fnd_api.g_miss_char,
189 source_code_id NUMBER :=fnd_api.g_miss_num,
190 source_code VARCHAR2(30) :=fnd_api.g_miss_char
191 );
192 TYPE activity_tbl_type IS TABLE OF activity_rec_type INDEX BY BINARY_INTEGER;
193
194 FUNCTION INIT_ACTIVITY_REC RETURN activity_rec_type;
195
196 PROCEDURE Create_Interaction
197 (
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201 p_resp_appl_id IN NUMBER DEFAULT NULL,
202 p_resp_id IN NUMBER DEFAULT NULL,
203 p_user_id IN NUMBER,
204 p_login_id IN NUMBER DEFAULT NULL,
205 x_return_status OUT VARCHAR2,
206 x_msg_count OUT NUMBER,
207 x_msg_data OUT VARCHAR2,
208 p_interaction_rec IN interaction_rec_type,
209 p_activities IN activity_tbl_type
210 );
211
212 -- Start of comments
213 -- Procedure : Create_MediaItem
214 -- Type : Public API
215 -- Usage : Creates a media item record in the table
216 -- JTF_IH_MEDIAITEM
217 -- Pre-reqs : None
218 --
219 -- Standard IN Parameters:
220 -- p_api_version IN NUMBER Required
221 -- p_init_msg_list IN VARCHAR2(1) Optional
222 -- Default = FND_API.G_FALSE
223 -- p_commit IN VARCHAR2(1) Optional
224 -- Default = FND_API.G_FALSE
225 --
226 -- Standard OUT Parameters:
227 -- x_return_status OUT VARCHAR2(1)
228 -- x_msg_count OUT NUMBER
229 -- x_msg_data OUT VARCHAR2(2000)
230 --
231 -- MediaItem IN Parameters:
232 -- p_resp_appl_id IN NUMBER Optional(1)
233 -- Application identifier
234 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
235 -- p_resp_id IN NUMBER Optional(1)
236 -- Responsibility identifier
237 -- Default = FND_GLOBAL.RESP_ID or NULL
238 -- p_user_id IN NUMBER Optional
239 -- Corresponds to the column USER_ID in the table
240 -- FND_USER, and identifies the Oracle
241 -- Applications user
242 -- Default = FND_GLOBAL.USER_ID
243 -- p_login_id IN NUMBER Optional
244 -- Corresponds to the column LOGIN_ID in the
245 -- table FND_LOGINS, and identifies the
246 -- login session
247 -- Default = FND_GLOBAL.LOGIN_ID or NULL
248 --
249 -- p_media IN media_rec_type
250 --
251 -- media_rec_type is the structure that captures a media item and has the following attributes:
252 -- media_id NUMBER
253 -- source_id NUMBER Optional
254 -- direction VARCHAR2 Optional
255 -- duration NUMBER Optional
256 -- end_date_time DATE Optional
257 -- interaction_performed VARCHAR2 Optional
258 -- start_date_time DATE Optional
259 -- media_data VARCHAR2 Optional
260 -- source_item_create_date_time NUMBER Optional
261 -- source_item_id NUMBER Optional
262 -- media_item_type VARCHAR2
263 -- media_item_ref VARCHAR2 Optional
264 --
265 -- Version : Initial version 1.0
266 --
267 -- Notes :
268 -- (1) The application ID, responsibility ID, and user ID determine which
269 -- profile values are used as default.
270 --
271 -- End of comments
272 TYPE media_rec_type IS RECORD
273 (
274 media_id NUMBER :=fnd_api.g_miss_num,
275 source_id NUMBER :=fnd_api.g_miss_num,
276 direction VARCHAR2(240) :=fnd_api.g_miss_char,
277 duration NUMBER :=fnd_api.g_miss_num,
278 end_date_time DATE :=fnd_api.g_miss_date,
279 interaction_performed VARCHAR2(240) :=fnd_api.g_miss_char,
280 start_date_time DATE :=fnd_api.g_miss_date,
281 media_data VARCHAR2(80) :=fnd_api.g_miss_char,
282 source_item_create_date_time DATE :=fnd_api.g_miss_date,
283 source_item_id NUMBER :=fnd_api.g_miss_num,
284 media_item_type VARCHAR2(80) :=fnd_api.g_miss_char,
285 media_item_ref VARCHAR2(240) :=fnd_api.g_miss_char
286 );
287 TYPE media_lc_rec_type IS RECORD
288 (
289 start_date_time DATE :=fnd_api.g_miss_date,
290 type_type VARCHAR2(80) :=fnd_api.g_miss_char,
291 type_id NUMBER :=fnd_api.g_miss_num,
292 duration NUMBER :=fnd_api.g_miss_num,
296 media_id NUMBER :=fnd_api.g_miss_num,
293 end_date_time DATE :=fnd_api.g_miss_date,
294 milcs_id NUMBER :=fnd_api.g_miss_num,
295 milcs_type_id NUMBER :=fnd_api.g_miss_num,
297 handler_id NUMBER :=fnd_api.g_miss_num,
298 resource_id NUMBER :=fnd_api.g_miss_num
299 );
300
301 TYPE mlcs_tbl_type IS TABLE OF media_lc_rec_type INDEX BY BINARY_INTEGER;
302
303 PROCEDURE Create_MediaItem
304 (
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
307 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
308 p_resp_appl_id IN NUMBER DEFAULT NULL,
309 p_resp_id IN NUMBER DEFAULT NULL,
310 p_user_id IN NUMBER,
311 p_login_id IN NUMBER DEFAULT NULL,
312 x_return_status OUT VARCHAR2,
313 x_msg_count OUT NUMBER,
314 x_msg_data OUT VARCHAR2,
315 p_media IN media_rec_type,
316 p_mlcs IN mlcs_tbl_type
317 );
318
319 PROCEDURE Create_MediaItem
320 (
321 p_api_version IN NUMBER,
322 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
323 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
324 p_resp_appl_id IN NUMBER DEFAULT NULL,
325 p_resp_id IN NUMBER DEFAULT NULL,
326 p_user_id IN NUMBER,
327 p_login_id IN NUMBER DEFAULT NULL,
328 x_return_status OUT VARCHAR2,
329 x_msg_count OUT NUMBER,
330 x_msg_data OUT VARCHAR2,
331 p_media_rec IN media_rec_type,
332 x_media_id OUT NUMBER
333 );
334
335 -- Start of comments
336 -- Procedure : Create_MediaLifecycle
337 -- Type : Public API
338 -- Usage : Creates a media lifecycle record in the table
339 -- JTF_IH_MEDIA_ITEM_LC_SEGS
340 -- Pre-reqs : None
341 --
342 -- Standard IN Parameters:
343 -- p_api_version IN NUMBER Required
344 -- p_init_msg_list IN VARCHAR2(1) Optional
345 -- Default = FND_API.G_FALSE
346 -- p_commit IN VARCHAR2(1) Optional
347 -- Default = FND_API.G_FALSE
348 --
349 -- Standard OUT Parameters:
350 -- x_return_status OUT VARCHAR2(1)
351 -- x_msg_count OUT NUMBER
352 -- x_msg_data OUT VARCHAR2(2000)
353 --
354 -- MediaItem IN Parameters:
355 -- p_resp_appl_id IN NUMBER Optional(1)
356 -- Application identifier
357 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
358 -- p_resp_id IN NUMBER Optional(1)
359 -- Responsibility identifier
360 -- Default = FND_GLOBAL.RESP_ID or NULL
361 -- p_user_id IN NUMBER Optional
362 -- Corresponds to the column USER_ID in the table
363 -- FND_USER, and identifies the Oracle
364 -- Applications user
365 -- Default = FND_GLOBAL.USER_ID
366 -- p_login_id IN NUMBER Optional
367 -- Corresponds to the column LOGIN_ID in the
368 -- table FND_LOGINS, and identifies the
369 -- login session
370 -- Default = FND_GLOBAL.LOGIN_ID or NULL
371 --
372 -- p_media_lc_rec IN media_lc_rec_type
373 --
374 -- media_lc_rec_type is the structure that captures a media lifecycle and has the following attributes:
375 -- start_date_time DATE
376 -- type_type VARCHAR2(80)
377 -- type_id NUMBER
378 -- duration NUMBER
379 -- end_date_time DATE
380 -- milcs_id NUMBER
381 -- milcs_type_id NUMBER REQUIRED
382 -- media_id NUMBER REQUIRED
383 -- handler_id NUMBER
384 -- resource_id NUMBER
385 --
386 -- Version : Initial version 1.0
387 --
388 -- Notes :
389 -- (1) The application ID, responsibility ID, and user ID determine which
390 -- profile values are used as default.
391 --
392 -- End of comments
393
394
395 PROCEDURE Create_MediaLifecycle
396 (
397 p_api_version IN NUMBER,
398 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
399 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
400 p_resp_appl_id IN NUMBER DEFAULT NULL,
401 p_resp_id IN NUMBER DEFAULT NULL,
402 p_user_id IN NUMBER,
403 p_login_id IN NUMBER DEFAULT NULL,
404 x_return_status OUT VARCHAR2,
405 x_msg_count OUT NUMBER,
406 x_msg_data OUT VARCHAR2,
407 p_media_lc_rec IN media_lc_rec_type
408 );
409
410 -- Start of comments
411 -- Procedure : Get_InteractionActivityCount
412 -- Type : Public API
413 -- Usage : Get the interaction activity count from JTF_IH_ACTIVITY based on the input parameters
414 -- Pre-reqs : None
415 --
416 -- Standard IN Parameters:
417 -- p_api_version IN NUMBER Required
418 -- p_init_msg_list IN VARCHAR2(1) Optional
419 -- Default = FND_API.G_FALSE
420 --
421 -- Standard OUT Parameters:
422 -- x_return_status OUT VARCHAR2(1)
423 -- x_msg_count OUT NUMBER
424 -- x_msg_data OUT VARCHAR2(2000)
425 --
426 -- Customer Interaction IN Parameters:
427 -- p_resp_appl_id IN NUMBER Optional(1)
428 -- Application identifier
429 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
430 -- p_resp_id IN NUMBER Optional(1)
431 -- Responsibility identifier
435 -- table FND_USER, and identifies the Oracle
432 -- Default = FND_GLOBAL.RESP_ID or NULL
433 -- p_user_id IN NUMBER Optional
434 -- Corresponds to the column USER_ID in the
436 -- Applications user
437 -- Default = FND_GLOBAL.USER_ID
438 -- p_login_id IN NUMBER Optional
439 -- Corresponds to the column LOGIN_ID in the
440 -- table FND_LOGINS, and identifies
441 -- the login session
442 -- Default = FND_GLOBAL.LOGIN_ID or NULL
443 -- p_outcome_id IN NUMBER Optional
444 -- p_result_id IN NUMBER Optional
445 -- p_reason_id IN NUMBER Optional
446 -- p_script_id IN NUMBER Optional
447 -- p_media_id IN NUMBER Optional
448 -- Activity Count OUT Parameters
449 -- x_activity_count OUT NUMBER
450 -- the number of the activity record that
451 -- match the search criteria
452 --
453 -- Version : Initial version 1.0
454 --
455 -- Notes :
456 -- (1) The application ID, responsibility ID, and user ID determine which
457 -- profile values are used as default.
458 --
459 -- End of comments
460
461 PROCEDURE Get_InteractionActivityCount
462 (
463 p_api_version IN NUMBER,
464 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
465 p_resp_appl_id IN NUMBER DEFAULT NULL,
466 p_resp_id IN NUMBER DEFAULT NULL,
467 p_user_id IN NUMBER,
468 p_login_id IN NUMBER DEFAULT NULL,
469 x_return_status OUT VARCHAR2,
470 x_msg_count OUT NUMBER,
471 x_msg_data OUT VARCHAR2,
472 p_outcome_id IN NUMBER,
473 p_result_id IN NUMBER,
474 p_reason_id IN NUMBER,
475 p_script_id IN NUMBER,
476 p_media_id IN NUMBER,
477 x_activity_count OUT NUMBER
478 );
479
480 -- Start of comments
481 -- Procedure : Get_InteractionCount
482 -- Type : Public API
483 -- Usage : Get the interaction count from JTF_IH_INTERACTIONS based on the input parameters
484 -- Pre-reqs : None
485 --
486 -- Standard IN Parameters:
487 -- p_api_version IN NUMBER Required
488 -- p_init_msg_list IN VARCHAR2(1) Optional
489 -- Default = FND_API.G_FALSE
490 --
491 -- Standard OUT Parameters:
492 -- x_return_status OUT VARCHAR2(1)
493 -- x_msg_count OUT NUMBER
494 -- x_msg_data OUT VARCHAR2(2000)
495 --
496 -- Interaction count IN Parameters:
497 -- p_resp_appl_id IN NUMBER Optional(1)
498 -- Application identifier
499 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
500 -- p_resp_id IN NUMBER Optional(1)
501 -- Responsibility identifier
502 -- Default = FND_GLOBAL.RESP_ID or NULL
503 -- p_user_id IN NUMBER Optional
504 -- Corresponds to the column USER_ID in
505 -- the table FND_USER, and identifies the
506 -- Oracle Applications user
507 -- Default = FND_GLOBAL.USER_ID
508 -- p_login_id IN NUMBER Optional
509 -- Corresponds to the column LOGIN_ID in the
510 -- table FND_LOGINS, and identifies the login session
511 -- Default = FND_GLOBAL.LOGIN_ID or NULL
512 -- p_outcome_id IN NUMBER Optional
513 -- p_result_id IN NUMBER Optional
514 -- p_reason_id IN NUMBER Optional
515 -- p_attribute1 IN VARCHAR2(150) Optional(2)
516 -- Customer interaction descriptive flexfield segments 1-15
517 -- p_attribute2 IN VARCHAR2(150) Optional(2)
518 -- p_attribute3 IN VARCHAR2(150) Optional(2)
519 -- p_attribute4 IN VARCHAR2(150) Optional(2)
520 -- p_attribute5 IN VARCHAR2(150) Optional(2)
521 -- p_attribute6 IN VARCHAR2(150) Optional(2)
522 -- p_attribute7 IN VARCHAR2(150) Optional(2)
523 -- p_attribute8 IN VARCHAR2(150) Optional(2)
524 -- p_attribute9 IN VARCHAR2(150) Optional(2)
525 -- p_attribute10 IN VARCHAR2(150) Optional(2)
526 -- p_attribute11 IN VARCHAR2(150) Optional(2)
527 -- p_attribute12 IN VARCHAR2(150) Optional(2)
528 -- p_attribute13 IN VARCHAR2(150) Optional(2)
529 -- p_attribute14 IN VARCHAR2(150) Optional(2)
530 -- p_attribute15 IN VARCHAR2(150) Optional(2)
531 -- p_attribute_category IN VARCHAR2(30) Optional(2)
532 -- Descriptive flexfield structure defining column
533 --
534 -- Interaction Count OUT Parameters
535 -- x_interaction_count OUT NUMBER
536 -- the number of the interaction record that match the search criteria
537 --
538 -- Version : Initial version 1.0
539 --
540 -- Notes :
541 -- (1) The application ID, responsibility ID, and user ID determine which
542 -- profile values are used as default.
543 -- (2) You must pass in segment IDs for none or all descriptive flexfield
544 -- columns that might be used in the descriptive flexfield.
545 --
546 -- End of comments
547
548 PROCEDURE Get_InteractionCount
549 (
550 p_api_version IN NUMBER,
551 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
552 p_resp_appl_id IN NUMBER DEFAULT NULL,
553 p_resp_id IN NUMBER DEFAULT NULL,
554 p_user_id IN NUMBER,
555 p_login_id IN NUMBER DEFAULT NULL,
556 x_return_status OUT VARCHAR2,
557 x_msg_count OUT NUMBER,
558 x_msg_data OUT VARCHAR2,
559 p_outcome_id IN NUMBER,
560 p_result_id IN NUMBER,
561 p_reason_id IN NUMBER,
562 p_attribute1 IN VARCHAR2 DEFAULT NULL,
566 p_attribute5 IN VARCHAR2 DEFAULT NULL,
563 p_attribute2 IN VARCHAR2 DEFAULT NULL,
564 p_attribute3 IN VARCHAR2 DEFAULT NULL,
565 p_attribute4 IN VARCHAR2 DEFAULT NULL,
567 p_attribute6 IN VARCHAR2 DEFAULT NULL,
568 p_attribute7 IN VARCHAR2 DEFAULT NULL,
569 p_attribute8 IN VARCHAR2 DEFAULT NULL,
570 p_attribute9 IN VARCHAR2 DEFAULT NULL,
571 p_attribute10 IN VARCHAR2 DEFAULT NULL,
572 p_attribute11 IN VARCHAR2 DEFAULT NULL,
573 p_attribute12 IN VARCHAR2 DEFAULT NULL,
574 p_attribute13 IN VARCHAR2 DEFAULT NULL,
575 p_attribute14 IN VARCHAR2 DEFAULT NULL,
576 p_attribute15 IN VARCHAR2 DEFAULT NULL,
577 p_attribute_category IN VARCHAR2 DEFAULT NULL,
578 x_interaction_count OUT NUMBER
579 );
580
581 -- Start of comments
582 -- Procedure : Open_Interaction -- created by Jean Zhu 01/11/2000
583 -- Type : Public API
584 -- Usage : This API servers as the basis for providing a caching mechanism during the creation of
585 -- an Interaction.
586 -- Pre-reqs : None
587 --
588 -- Standard IN Parameters:
589 -- p_api_version IN NUMBER Required
590 -- p_init_msg_list IN VARCHAR2(1) Optional
591 -- Default = FND_API.G_FALSE
592 --
593 -- Standard OUT Parameters:
594 -- x_return_status OUT VARCHAR2(1)
595 -- x_msg_count OUT NUMBER
596 -- x_msg_data OUT VARCHAR2(2000)
597 --
598 -- Interaction count IN Parameters:
599 -- p_resp_appl_id IN NUMBER Optional(1)
600 --
601 -- Application identifier
602 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
603 -- p_resp_id IN NUMBER Optional(1)
604 -- Responsibility identifier
605 -- Default = FND_GLOBAL.RESP_ID or NULL
606 -- p_user_id IN NUMBER Optional
607 -- Corresponds to the column USER_ID in
608 -- the table FND_USER, and identifies the
609 -- Oracle Applications user
610 -- Default = FND_GLOBAL.USER_ID
611 -- p_login_id IN NUMBER Optional
612 -- Corresponds to the column LOGIN_ID in the
613 -- table FND_LOGINS, and identifies the login session
614 --
615 -- Default = FND_GLOBAL.LOGIN_ID or NULL
616 -- p_interaction_rec IN interaction_rec_type
617 --
618 -- Interaction_Id OUT Parameters
619 -- x_interaction_id OUT NUMBER
620 -- the id of the new interaction record
621 --
622 -- Version : Initial version 1.0
623 --
624 -- Notes :
625 -- (1) The application ID, responsibility ID, and user ID determine which
626 -- profile values are used as default.
627 -- (2) You must pass in segment IDs for none or all descriptive flexfield
628 -- columns that might be used in the descriptive flexfield.
629 --
630 -- End of comments
631
632 PROCEDURE Open_Interaction
633 (
634 p_api_version IN NUMBER,
635 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
636 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
637 p_resp_appl_id IN NUMBER DEFAULT NULL,
638 p_resp_id IN NUMBER DEFAULT NULL,
639 p_user_id IN NUMBER,
640 p_login_id IN NUMBER DEFAULT NULL,
641 x_return_status OUT VARCHAR2,
642 x_msg_count OUT NUMBER,
643 x_msg_data OUT VARCHAR2,
644 p_interaction_rec IN interaction_rec_type,
645 x_interaction_id OUT NUMBER
646 );
647
648 -- Start of comments
649 -- Procedure : Update_Interaction -- created by Jean Zhu 01/11/2000
650 -- Type : Public API
651 -- Usage : This API servers as the basis for providing a caching mechanism during the active of
652 -- an Interaction.
653 -- Pre-reqs : None
654 --
655 -- Standard IN Parameters:
656 -- p_api_version IN NUMBER Required
657 -- p_init_msg_list IN VARCHAR2(1) Optional
658 -- Default = FND_API.G_FALSE
659 --
660 -- Standard OUT Parameters:
661 -- x_return_status OUT VARCHAR2(1)
662 -- x_msg_count OUT NUMBER
663 -- x_msg_data OUT VARCHAR2(2000)
664 --
665 -- Interaction count IN Parameters:
666 -- p_resp_appl_id IN NUMBER Optional(1)
667 --
668 -- Application identifier
669 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
670 -- p_resp_id IN NUMBER Optional(1)
671 -- Responsibility identifier
672 -- Default = FND_GLOBAL.RESP_ID or NULL
673 -- p_user_id IN NUMBER Optional
674 -- Corresponds to the column USER_ID in
675 -- the table FND_USER, and identifies the
676 -- Oracle Applications user
677 -- Default = FND_GLOBAL.USER_ID
678 -- p_login_id IN NUMBER Optional
679 -- Corresponds to the column LOGIN_ID in the
680 -- table FND_LOGINS, and identifies the login session
681 --
682 -- Default = FND_GLOBAL.LOGIN_ID or NULL
683 -- p_interaction_rec IN interaction_rec_type
684 --
685 --
686 -- Version : Initial version 1.0
687 --
688 -- Notes :
689 -- (1) The application ID, responsibility ID, and user ID determine which
690 -- profile values are used as default.
691 -- (2) You must pass in segment IDs for none or all descriptive flexfield
695
692 -- columns that might be used in the descriptive flexfield.
693 --
694 -- End of comments
696 PROCEDURE Update_Interaction
697 (
698 p_api_version IN NUMBER,
699 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
700 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
701 p_resp_appl_id IN NUMBER DEFAULT NULL,
702 p_resp_id IN NUMBER DEFAULT NULL,
703 p_user_id IN NUMBER,
704 p_login_id IN NUMBER DEFAULT NULL,
705 x_return_status OUT VARCHAR2,
706 x_msg_count OUT NUMBER,
707 x_msg_data OUT VARCHAR2,
708 p_interaction_rec IN interaction_rec_type
709 );
710
711 -- Start of comments
712 -- Procedure : Close_Interaction -- created by Jean Zhu 01/11/2000
713 -- Type : Public API
714 -- Usage : This API servers as the basis for providing a caching mechanism during the final of
715 -- an Interaction.
716 -- Pre-reqs : None
717 --
718 -- Standard IN Parameters:
719 -- p_api_version IN NUMBER Required
720 -- p_init_msg_list IN VARCHAR2(1) Optional
721 -- Default = FND_API.G_FALSE
722 --
723 -- Standard OUT Parameters:
724 -- x_return_status OUT VARCHAR2(1)
725 -- x_msg_count OUT NUMBER
726 -- x_msg_data OUT VARCHAR2(2000)
727 --
728 -- Interaction count IN Parameters:
729 -- p_resp_appl_id IN NUMBER Optional(1)
730 --
731 -- Application identifier
732 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
733 -- p_resp_id IN NUMBER Optional(1)
734 -- Responsibility identifier
735 -- Default = FND_GLOBAL.RESP_ID or NULL
736 -- p_user_id IN NUMBER Optional
737 -- Corresponds to the column USER_ID in
738 -- the table FND_USER, and identifies the
739 -- Oracle Applications user
740 -- Default = FND_GLOBAL.USER_ID
741 -- p_login_id IN NUMBER Optional
742 -- Corresponds to the column LOGIN_ID in the
743 -- table FND_LOGINS, and identifies the login session
744 --
745 -- Default = FND_GLOBAL.LOGIN_ID or NULL
746 -- p_interaction_rec IN interaction_rec_type
747 -- used in update interaction record
748 --
749 -- Version : Initial version 1.0
750 --
751 -- Notes :
752 -- (1) The application ID, responsibility ID, and user ID determine which
753 -- profile values are used as default.
754 -- (2) You must pass in segment IDs for none or all descriptive flexfield
755 -- columns that might be used in the descriptive flexfield.
756 --
757 -- End of comments
758
759 PROCEDURE Close_Interaction
760 (
761 p_api_version IN NUMBER,
762 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
764 p_resp_appl_id IN NUMBER DEFAULT NULL,
765 p_resp_id IN NUMBER DEFAULT NULL,
766 p_user_id IN NUMBER,
767 p_login_id IN NUMBER DEFAULT NULL,
768 x_return_status OUT VARCHAR2,
769 x_msg_count OUT NUMBER,
770 x_msg_data OUT VARCHAR2,
771 p_interaction_rec IN interaction_rec_type
772 );
773
774 -- Start of comments
775 -- Procedure : Add_Activity -- created by Jean Zhu 01/11/2000
776 -- Type : Public API
777 -- Usage : This API servers as the basis for providing a caching mechanism
778 -- during the creation of an activity after some interaction happen.
779 -- Pre-reqs : None
780 --
781 -- Standard IN Parameters:
782 -- p_api_version IN NUMBER Required
783 -- p_init_msg_list IN VARCHAR2(1) Optional
784 -- Default = FND_API.G_FALSE
785 --
786 -- Standard OUT Parameters:
787 -- x_return_status OUT VARCHAR2(1)
788 -- x_msg_count OUT NUMBER
789 -- x_msg_data OUT VARCHAR2(2000)
790 --
791 -- Interaction count IN Parameters:
792 -- p_resp_appl_id IN NUMBER Optional(1)
793 --
794 -- Application identifier
795 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
796 -- p_resp_id IN NUMBER Optional(1)
797 -- Responsibility identifier
798 -- Default = FND_GLOBAL.RESP_ID or NULL
799 -- p_user_id IN NUMBER Optional
800 -- Corresponds to the column USER_ID in
801 -- the table FND_USER, and identifies the
802 -- Oracle Applications user
803 -- Default = FND_GLOBAL.USER_ID
804 -- p_login_id IN NUMBER Optional
805 -- Corresponds to the column LOGIN_ID in the
806 -- table FND_LOGINS, and identifies the login session
807 --
808 -- Default = FND_GLOBAL.LOGIN_ID or NULL
809 -- p_activity_rec IN activity_rec_type
810 --
811 -- Activity_Id OUT Parameters
812 -- x_activity_id OUT NUMBER
813 -- the id of the new activity record
814 --
815 -- Version : Initial version 1.0
816 --
817 -- Notes :
818 -- (1) The application ID, responsibility ID, and user ID determine which
819 -- profile values are used as default.
820 -- (2) You must pass in segment IDs for none or all descriptive flexfield
821 -- columns that might be used in the descriptive flexfield.
822 --
823 -- End of comments
824
825 PROCEDURE Add_Activity
829 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
826 (
827 p_api_version IN NUMBER,
828 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
830 p_resp_appl_id IN NUMBER DEFAULT NULL,
831 p_resp_id IN NUMBER DEFAULT NULL,
832 p_user_id IN NUMBER,
833 p_login_id IN NUMBER DEFAULT NULL,
834 x_return_status OUT VARCHAR2,
835 x_msg_count OUT NUMBER,
836 x_msg_data OUT VARCHAR2,
837 p_activity_rec IN activity_rec_type,
838 x_activity_id OUT NUMBER
839 );
840
841 -- Start of comments
842 -- Procedure : Update_Activity -- created by Jean Zhu 01/11/2000
843 -- Type : Public API
844 -- Usage : This API servers as the basis for providing a caching mechanism
845 -- during the active of an activity
846 -- Pre-reqs : None
847 --
848 -- Standard IN Parameters:
849 -- p_api_version IN NUMBER Required
850 -- p_init_msg_list IN VARCHAR2(1) Optional
851 -- Default = FND_API.G_FALSE
852 --
853 -- Standard OUT Parameters:
854 -- x_return_status OUT VARCHAR2(1)
855 -- x_msg_count OUT NUMBER
856 -- x_msg_data OUT VARCHAR2(2000)
857 --
858 -- Interaction count IN Parameters:
859 -- p_resp_appl_id IN NUMBER Optional(1)
860 --
861 -- Application identifier
862 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
863 -- p_resp_id IN NUMBER Optional(1)
864 -- Responsibility identifier
865 -- Default = FND_GLOBAL.RESP_ID or NULL
866 -- p_user_id IN NUMBER Optional
867 -- Corresponds to the column USER_ID in
868 -- the table FND_USER, and identifies the
869 -- Oracle Applications user
870 -- Default = FND_GLOBAL.USER_ID
871 -- p_login_id IN NUMBER Optional
872 -- Corresponds to the column LOGIN_ID in the
873 -- table FND_LOGINS, and identifies the login session
874 --
875 -- Default = FND_GLOBAL.LOGIN_ID or NULL
876 -- p_activity_rec IN activity_rec_type
877 --
878 --
879 -- Version : Initial version 1.0
880 --
881 -- Notes :
882 -- (1) The application ID, responsibility ID, and user ID determine which
883 -- profile values are used as default.
884 -- (2) You must pass in segment IDs for none or all descriptive flexfield
885 -- columns that might be used in the descriptive flexfield.
886 --
887 -- End of comments
888
889 PROCEDURE Update_Activity
890 (
891 p_api_version IN NUMBER,
892 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
893 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
894 p_resp_appl_id IN NUMBER DEFAULT NULL,
895 p_resp_id IN NUMBER DEFAULT NULL,
896 p_user_id IN NUMBER,
897 p_login_id IN NUMBER DEFAULT NULL,
898 x_return_status OUT VARCHAR2,
899 x_msg_count OUT NUMBER,
900 x_msg_data OUT VARCHAR2,
901 p_activity_rec IN activity_rec_type
902 );
903
904 -- Start of comments
905 -- Procedure : Close_Interaction -- created by Jean Zhu 01/11/2000
906 -- Type : Public API
907 -- Usage : This API servers as the basis for providing a caching mechanism during the final of
908 -- an Interaction.
909 -- Pre-reqs : None
910 --
911 -- Standard IN Parameters:
912 -- p_api_version IN NUMBER Required
913 -- p_init_msg_list IN VARCHAR2(1) Optional
914 -- Default = FND_API.G_FALSE
915 --
916 -- Standard OUT Parameters:
917 -- x_return_status OUT VARCHAR2(1)
918 -- x_msg_count OUT NUMBER
919 -- x_msg_data OUT VARCHAR2(2000)
920 --
921 -- Interaction count IN Parameters:
922 -- p_resp_appl_id IN NUMBER Optional(1)
923 --
924 -- Application identifier
925 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
926 -- p_resp_id IN NUMBER Optional(1)
927 -- Responsibility identifier
928 -- Default = FND_GLOBAL.RESP_ID or NULL
929 -- p_user_id IN NUMBER Optional
930 -- Corresponds to the column USER_ID in
931 -- the table FND_USER, and identifies the
932 -- Oracle Applications user
933 -- Default = FND_GLOBAL.USER_ID
934 -- p_login_id IN NUMBER Optional
935 -- Corresponds to the column LOGIN_ID in the
936 -- table FND_LOGINS, and identifies the login session
937 --
938 -- Default = FND_GLOBAL.LOGIN_ID or NULL
939 -- p_interaction_id IN NUMBER
940 --
941 --
942 -- Version : Initial version 1.0
943 --
944 -- Notes :
945 -- (1) The application ID, responsibility ID, and user ID determine which
946 -- profile values are used as default.
947 -- (2) You must pass in segment IDs for none or all descriptive flexfield
948 -- columns that might be used in the descriptive flexfield.
949 --
950 -- End of comments
951
952 PROCEDURE Close_Interaction
953 (
954 p_api_version IN NUMBER,
955 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
956 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
957 p_resp_appl_id IN NUMBER DEFAULT NULL,
958 p_resp_id IN NUMBER DEFAULT NULL,
959 p_user_id IN NUMBER,
960 p_login_id IN NUMBER DEFAULT NULL,
964 p_interaction_id IN NUMBER
961 x_return_status OUT VARCHAR2,
962 x_msg_count OUT NUMBER,
963 x_msg_data OUT VARCHAR2,
965 );
966
967 -- Start of comments
968 -- Procedure : Update_ActivityDuration -- created by Jean Zhu 01/11/2000
969 -- Type : Public API
970 -- Usage : This API servers as the basis for providing a updating mechanism
971 -- for the duration and start/end date of an activity
972 -- Pre-reqs : None
973 --
974 -- Standard IN Parameters:
975 -- p_api_version IN NUMBER Required
976 -- p_init_msg_list IN VARCHAR2(1) Optional
977 -- Default = FND_API.G_FALSE
978 --
979 -- Standard OUT Parameters:
980 -- x_return_status OUT VARCHAR2(1)
981 -- x_msg_count OUT NUMBER
982 -- x_msg_data OUT VARCHAR2(2000)
983 --
984 -- Interaction count IN Parameters:
985 -- p_resp_appl_id IN NUMBER Optional(1)
986 --
987 -- Application identifier
988 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
989 -- p_resp_id IN NUMBER Optional(1)
990 -- Responsibility identifier
991 -- Default = FND_GLOBAL.RESP_ID or NULL
992 -- p_user_id IN NUMBER Optional
993 -- Corresponds to the column USER_ID in
994 -- the table FND_USER, and identifies the
995 -- Oracle Applications user
996 -- Default = FND_GLOBAL.USER_ID
997 -- p_login_id IN NUMBER Optional
998 -- Corresponds to the column LOGIN_ID in the
999 -- table FND_LOGINS, and identifies the login session
1000 --
1001 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1002 -- p_activity_id IN NUMBER
1003 -- p_start_date_time IN DATE
1004 -- p_end_date_time IN DATE
1005 -- p_duration IN NUMBER
1006 -- Version : Initial version 1.0
1007 --
1008 -- Notes :
1009 -- (1) The application ID, responsibility ID, and user ID determine which
1010 -- profile values are used as default.
1011 -- (2) You must pass in segment IDs for none or all descriptive flexfield
1012 -- columns that might be used in the descriptive flexfield.
1013 --
1014 -- End of comments
1015
1016 PROCEDURE Update_ActivityDuration
1017 (
1018 p_api_version IN NUMBER,
1019 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1020 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1021 p_resp_appl_id IN NUMBER DEFAULT NULL,
1022 p_resp_id IN NUMBER DEFAULT NULL,
1023 p_user_id IN NUMBER,
1024 p_login_id IN NUMBER DEFAULT NULL,
1025 x_return_status OUT VARCHAR2,
1026 x_msg_count OUT NUMBER,
1027 x_msg_data OUT VARCHAR2,
1028 p_activity_id IN NUMBER,
1029 p_end_date_time IN DATE,
1030 p_duration IN NUMBER
1031 );
1032
1033 -- Start of comments
1034 -- Author : James Baldo Jr.
1035 -- History :
1036 -- 29 February 2000 Created
1037 -- Procedure : Open_MediaItem
1038 -- Type : Public API
1039 -- Usage : Creates a media item record in the table JTF_IH_MEDIA_ITEMS. The record created
1040 -- resulting from a successful call to this API will have its Active column marked
1041 -- 'Y'. This state indicates that the record can be updated via the Update_MediaItem
1042 -- procedure. The procedure call returns the media_id value for the record created.
1043 --
1044 -- Pre-reqs : None
1045 --
1046 -- Standard IN Parameters:
1047 -- p_api_version IN NUMBER Required
1048 -- p_init_msg_list IN VARCHAR2(1) Optional
1049 -- Default = FND_API.G_FALSE
1050 -- p_commit IN VARCHAR2(1) Optional
1051 -- Default = FND_API.G_FALSE
1052 --
1053 -- Standard OUT Parameters:
1054 -- x_return_status OUT VARCHAR2(1)
1055 -- x_msg_count OUT NUMBER
1056 -- x_msg_data OUT VARCHAR2(2000)
1057 --
1058 -- MediaItem IN Parameters:
1059 -- p_resp_appl_id IN NUMBER Optional(1)
1060 -- Application identifier
1061 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
1062 -- p_resp_id IN NUMBER Optional(1)
1063 -- Responsibility identifier
1064 -- Default = FND_GLOBAL.RESP_ID or NULL
1065 -- p_user_id IN NUMBER Optional
1066 -- Corresponds to the column USER_ID in the table
1067 -- FND_USER, and identifies the Oracle
1068 -- Applications user
1069 -- Default = FND_GLOBAL.USER_ID
1070 -- p_login_id IN NUMBER Optional
1071 -- Corresponds to the column LOGIN_ID in the
1072 -- table FND_LOGINS, and identifies the
1073 -- login session
1074 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1075 --
1076 -- p_media IN media_rec_type
1077 --
1078 -- x_media_id OUT NUMBER
1079 --
1080 -- Version : Initial version 1.0
1081 --
1082 -- Notes :
1083 -- (1) The application ID, responsibility ID, and user ID determine which
1084 -- profile values are used as default.
1085 --
1086 -- End of comments
1087
1088 PROCEDURE Open_MediaItem
1089 (
1090 p_api_version IN NUMBER,
1094 p_resp_id IN NUMBER DEFAULT NULL,
1091 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1092 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1093 p_resp_appl_id IN NUMBER DEFAULT NULL,
1095 p_user_id IN NUMBER,
1096 p_login_id IN NUMBER DEFAULT NULL,
1097 x_return_status OUT VARCHAR2,
1098 x_msg_count OUT NUMBER,
1099 x_msg_data OUT VARCHAR2,
1100 p_media_rec IN media_rec_type,
1101 x_media_id OUT NUMBER
1102 );
1103
1104 -- Start of comments
1105 -- Author : James Baldo Jr.
1106 -- History :
1107 -- 29 February 2000 Created
1108 -- Procedure : Update_MediaItem
1109 -- Type : Public API
1110 -- Usage : Updates an existing media item record in the table JTF_IH_MEDIA_ITEMS.
1111 -- Procedure will only update columns with valid values. All input values must
1112 -- be valid. Procedure will not perform a partial update.
1113 --
1114 -- Pre-conditions : Media_ID update state Active = 'Y'
1115 --
1116 -- Post-conditions : Media_ID update state Active = 'Y'
1117 -- : Updated columns changed to valid values
1118 --
1119 -- Standard IN Parameters:
1120 -- p_api_version IN NUMBER Required
1121 -- p_init_msg_list IN VARCHAR2(1) Optional
1122 -- Default = FND_API.G_FALSE
1123 -- p_commit IN VARCHAR2(1) Optional
1124 -- Default = FND_API.G_FALSE
1125 --
1126 -- Standard OUT Parameters:
1127 -- x_return_status OUT VARCHAR2(1)
1128 -- x_msg_count OUT NUMBER
1129 -- x_msg_data OUT VARCHAR2(2000)
1130 --
1131 -- MediaItem IN Parameters:
1132 -- p_resp_appl_id IN NUMBER Optional(1)
1133 -- Application identifier
1134 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
1135 -- p_resp_id IN NUMBER Optional(1)
1136 -- Responsibility identifier
1137 -- Default = FND_GLOBAL.RESP_ID or NULL
1138 -- p_user_id IN NUMBER Optional
1139 -- Corresponds to the column USER_ID in the table
1140 -- FND_USER, and identifies the Oracle
1141 -- Applications user
1142 -- Default = FND_GLOBAL.USER_ID
1143 -- p_login_id IN NUMBER Optional
1144 -- Corresponds to the column LOGIN_ID in the
1145 -- table FND_LOGINS, and identifies the
1146 -- login session
1147 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1148 --
1149 -- p_media IN media_rec_type
1150 --
1151 -- Version : Initial version 1.0
1152 --
1153 -- Notes :
1154 -- (1) The application ID, responsibility ID, and user ID determine which
1155 -- profile values are used as default.
1156 --
1157 -- End of comments
1158
1159 PROCEDURE Update_MediaItem
1160 (
1161 p_api_version IN NUMBER,
1162 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1163 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1164 p_resp_appl_id IN NUMBER DEFAULT NULL,
1165 p_resp_id IN NUMBER DEFAULT NULL,
1166 p_user_id IN NUMBER,
1167 p_login_id IN NUMBER DEFAULT NULL,
1168 x_return_status OUT VARCHAR2,
1169 x_msg_count OUT NUMBER,
1170 x_msg_data OUT VARCHAR2,
1171 p_media_rec IN media_rec_type
1172 );
1173
1174
1175 -- Start of comments
1176 -- Author : James Baldo Jr.
1177 -- History :
1178 -- 29 February 2000 Created
1179 -- Procedure : Close_MediaItem
1180 -- Type : Public API
1181 -- Usage : Updates an existing media item record in the table JTF_IH_MEDIA_ITEMS.
1182 -- Procedure will only update columns with valid values. All input values must
1183 -- be valid. Procedure will not perform a partial update. Will mark the state of the
1184 -- Media_ID and associated Milcs_ID Active = 'N'. The record set, media item and associated
1185 -- milcs_id(s) are now considered historical records and immutable.
1186 --
1187 -- Pre-conditions : Media_ID state Active = 'Y'
1188 -- : Milcs_ID (i.e., all media_item_lifecycle_segments associated with Media_ID)
1189 -- state Active = 'Y'
1190 --
1191 -- Post-conditions : Media_ID update state Active = 'N'
1192 -- : Updated columns changed to valid values
1193 -- : Milcs_ID(s) update state Active = 'N'
1194 --
1195 -- Standard IN Parameters:
1196 -- p_api_version IN NUMBER Required
1197 -- p_init_msg_list IN VARCHAR2(1) Optional
1198 -- Default = FND_API.G_FALSE
1199 -- p_commit IN VARCHAR2(1) Optional
1200 -- Default = FND_API.G_FALSE
1201 --
1202 -- Standard OUT Parameters:
1203 -- x_return_status OUT VARCHAR2(1)
1204 -- x_msg_count OUT NUMBER
1205 -- x_msg_data OUT VARCHAR2(2000)
1206 --
1207 -- MediaItem IN Parameters:
1208 -- p_resp_appl_id IN NUMBER Optional(1)
1209 -- Application identifier
1210 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
1211 -- p_resp_id IN NUMBER Optional(1)
1212 -- Responsibility identifier
1213 -- Default = FND_GLOBAL.RESP_ID or NULL
1214 -- p_user_id IN NUMBER Optional
1215 -- Corresponds to the column USER_ID in the table
1219 -- p_login_id IN NUMBER Optional
1216 -- FND_USER, and identifies the Oracle
1217 -- Applications user
1218 -- Default = FND_GLOBAL.USER_ID
1220 -- Corresponds to the column LOGIN_ID in the
1221 -- table FND_LOGINS, and identifies the
1222 -- login session
1223 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1224 --
1225 -- p_media IN media_rec_type
1226 --
1227 -- Version : Initial version 1.0
1228 --
1229 -- Notes :
1230 -- (1) The application ID, responsibility ID, and user ID determine which
1231 -- profile values are used as default.
1232 --
1233 -- End of comments
1234
1235 PROCEDURE Close_MediaItem
1236 (
1237 p_api_version IN NUMBER,
1238 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1239 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1240 p_resp_appl_id IN NUMBER DEFAULT NULL,
1241 p_resp_id IN NUMBER DEFAULT NULL,
1242 p_user_id IN NUMBER,
1243 p_login_id IN NUMBER DEFAULT NULL,
1244 x_return_status OUT VARCHAR2,
1245 x_msg_count OUT NUMBER,
1246 x_msg_data OUT VARCHAR2,
1247 p_media_rec IN media_rec_type
1248 );
1249
1250 -- Start of comments
1251 -- Procedure : Add_MediaLifecycle
1252 -- Type : Public API
1253 -- Author : James Baldo Jr.
1254 -- History :
1255 -- 29 February 2000 Created
1256 -- Usage : Creates a media lifecycle record in the table JTF_IH_MEDIA_ITEM_LC_SEGS,
1257 -- returns a Milcs_ID, and sets the state of the record Active = 'Y'.
1258 -- All parameter values passed-in must be valid. The procedure will not create
1259 -- a record with a partial set of valid values.
1260 --
1261 --
1262 -- Pre-reqs : None
1263 --
1264 -- Standard IN Parameters:
1265 -- p_api_version IN NUMBER Required
1266 -- p_init_msg_list IN VARCHAR2(1) Optional
1267 -- Default = FND_API.G_FALSE
1268 -- p_commit IN VARCHAR2(1) Optional
1269 -- Default = FND_API.G_FALSE
1270 --
1271 -- Standard OUT Parameters:
1272 -- x_return_status OUT VARCHAR2(1)
1273 -- x_msg_count OUT NUMBER
1274 -- x_msg_data OUT VARCHAR2(2000)
1275 --
1276 -- MediaItem IN Parameters:
1277 -- p_resp_appl_id IN NUMBER Optional(1)
1278 -- Application identifier
1279 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
1280 -- p_resp_id IN NUMBER Optional(1)
1281 -- Responsibility identifier
1282 -- Default = FND_GLOBAL.RESP_ID or NULL
1283 -- p_user_id IN NUMBER Optional
1284 -- Corresponds to the column USER_ID in the table
1285 -- FND_USER, and identifies the Oracle
1286 -- Applications user
1287 -- Default = FND_GLOBAL.USER_ID
1288 -- p_login_id IN NUMBER Optional
1289 -- Corresponds to the column LOGIN_ID in the
1290 -- table FND_LOGINS, and identifies the
1291 -- login session
1292 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1293 --
1294 -- p_media_lc_rec IN media_lc_rec_type
1295 --
1296 -- x_milcs_id OUT NUMBER
1297 --
1298 --
1299 -- Version : Initial version 1.0
1300 --
1301 -- Notes :
1302 -- (1) The application ID, responsibility ID, and user ID determine which
1303 -- profile values are used as default.
1304 --
1305 -- End of comments
1306
1307
1308 PROCEDURE Add_MediaLifecycle
1309 (
1310 p_api_version IN NUMBER,
1311 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1312 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1313 p_resp_appl_id IN NUMBER DEFAULT NULL,
1314 p_resp_id IN NUMBER DEFAULT NULL,
1315 p_user_id IN NUMBER,
1316 p_login_id IN NUMBER DEFAULT NULL,
1317 x_return_status OUT VARCHAR2,
1318 x_msg_count OUT NUMBER,
1319 x_msg_data OUT VARCHAR2,
1320 p_media_lc_rec IN media_lc_rec_type
1321 );
1322
1323 -- Start of comments
1324 -- Procedure : Update_MediaLifecycle
1325 -- Type : Public API
1326 -- Author : James Baldo Jr.
1327 -- History :
1328 -- 29 February 2000 Created
1329 -- Usage : Update a media lifecycle record in the table JTF_IH_MEDIA_ITEM_LC_SEGS.
1330 -- All parameter values passed-in must be valid. The procedure will not update
1331 -- a record with a partial set of valid values.
1332 --
1333 --
1334 -- Pre-reqs : None
1335 --
1336 -- Standard IN Parameters:
1337 -- p_api_version IN NUMBER Required
1338 -- p_init_msg_list IN VARCHAR2(1) Optional
1339 -- Default = FND_API.G_FALSE
1340 -- p_commit IN VARCHAR2(1) Optional
1341 -- Default = FND_API.G_FALSE
1342 --
1343 -- Standard OUT Parameters:
1344 -- x_return_status OUT VARCHAR2(1)
1345 -- x_msg_count OUT NUMBER
1346 -- x_msg_data OUT VARCHAR2(2000)
1347 --
1348 -- MediaItem IN Parameters:
1349 -- p_resp_appl_id IN NUMBER Optional(1)
1353 -- Responsibility identifier
1350 -- Application identifier
1351 -- Default = FND_GLOBAL.RESP_APPL_ID or NULL
1352 -- p_resp_id IN NUMBER Optional(1)
1354 -- Default = FND_GLOBAL.RESP_ID or NULL
1355 -- p_user_id IN NUMBER Optional
1356 -- Corresponds to the column USER_ID in the table
1357 -- FND_USER, and identifies the Oracle
1358 -- Applications user
1359 -- Default = FND_GLOBAL.USER_ID
1360 -- p_login_id IN NUMBER Optional
1361 -- Corresponds to the column LOGIN_ID in the
1362 -- table FND_LOGINS, and identifies the
1363 -- login session
1364 -- Default = FND_GLOBAL.LOGIN_ID or NULL
1365 --
1366 -- p_media_lc_rec IN media_lc_rec_type
1367 --
1368 --
1369 --
1370 -- Version : Initial version 1.0
1371 --
1372 -- Notes :
1373 -- (1) The application ID, responsibility ID, and user ID determine which
1374 -- profile values are used as default.
1375 --
1376 -- End of comments
1377
1378
1379 PROCEDURE Update_MediaLifecycle
1380 (
1381 p_api_version IN NUMBER,
1382 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1383 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1384 p_resp_appl_id IN NUMBER DEFAULT NULL,
1385 p_resp_id IN NUMBER DEFAULT NULL,
1386 p_user_id IN NUMBER,
1387 p_login_id IN NUMBER DEFAULT NULL,
1388 x_return_status OUT VARCHAR2,
1389 x_msg_count OUT NUMBER,
1390 x_msg_data OUT VARCHAR2,
1391 p_media_lc_rec IN media_lc_rec_type
1392 );
1393
1394
1395 END JTF_IH_PUB_PS;