1 Package IBC_CITEM_ADMIN_GRP AUTHID CURRENT_USER AS
2 /* $Header: ibcgcias.pls 115.35 2003/10/17 23:55:11 svatsa ship $ */
3
4 /*******************************************************************/
5 /**************************** VARIABLES ****************************/
6 /*******************************************************************/
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_CITEM_ADMIN_GRP';
8
9 -- shared default value
10 G_OBJ_VERSION_DEFAULT CONSTANT NUMBER := 1.0;
11 -- shared default value
12 G_API_VERSION_DEFAULT CONSTANT NUMBER := 1.0;
13
14
15
16
17
18
19
20
21
22
23
24
25
26 /*******************************************************************/
27 /**************************** FUNCTIONS ****************************/
28 /*******************************************************************/
29 -- --------------------------------------------------------------
30 -- GET OBJECT VERSION NUMBER
31 -- (from content item id)
32 --
33 -- --------------------------------------------------------------
34 FUNCTION getObjVerNum(
35 f_citem_id IN NUMBER
36 )
37 RETURN NUMBER;
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58 /*******************************************************************/
59 /**************************** PROCEDURES ***************************/
60 /*******************************************************************/
61 -- --------------------------------------------------------------
62 -- APPROVE CONTENT ITEM VERSION (BASE)
63 --
64 -- --------------------------------------------------------------
65 PROCEDURE approve_item(
66 p_citem_ver_id IN NUMBER
67 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
68 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
69 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
70 ,px_object_version_number IN OUT NOCOPY NUMBER
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89 -- --------------------------------------------------------------
90 -- ARCHIVE ITEM
91 --
92 -- --------------------------------------------------------------
93 PROCEDURE archive_item(
94 p_content_item_id IN NUMBER
95 ,p_cascaded_flag IN VARCHAR2 DEFAULT FND_API.g_false
96 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
97 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
98 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
99 ,px_object_version_number IN OUT NOCOPY NUMBER
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105
106
107
108
109
110
111
112
113
114
115 -- --------------------------------------------------------------
116 -- CHANGE STATUS
117 --
118 -- --------------------------------------------------------------
119 PROCEDURE change_status(
120 p_citem_ver_id IN NUMBER
121 ,p_new_status IN VARCHAR2
122 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
123 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
124 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
125 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
126 ,px_object_version_number IN OUT NOCOPY NUMBER
127 ,x_return_status OUT NOCOPY VARCHAR2
128 ,x_msg_count OUT NOCOPY NUMBER
129 ,x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132
133
134
135
136 -- --------------------------------------------------------------
137 -- COPY ITEM
138 --
139 -- --------------------------------------------------------------
140 -- 11.5.10 Requirement Content Item Name must be unique with in a Folder
141 -- While Copying a Content Item accept the Name of the New Content Item as a
142 -- parameter.
143
144 PROCEDURE copy_item(
145 p_item_reference_code IN VARCHAR2 DEFAULT NULL
146 ,p_new_citem_name IN VARCHAR2
147 ,p_directory_node_id IN NUMBER
148 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
149 ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.g_false
150 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
151 ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
152 ,px_content_item_id IN OUT NOCOPY NUMBER
153 ,px_citem_ver_id IN OUT NOCOPY NUMBER
154 ,px_object_version_number IN OUT NOCOPY NUMBER
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY NUMBER
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE copy_item(
161 p_item_reference_code IN VARCHAR2 DEFAULT NULL
162 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
163 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
164 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
165 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
166 ,px_content_item_id IN OUT NOCOPY NUMBER
167 ,px_citem_ver_id IN OUT NOCOPY NUMBER
168 ,px_object_version_number IN OUT NOCOPY NUMBER
169 ,x_return_status OUT NOCOPY VARCHAR2
170 ,x_msg_count OUT NOCOPY NUMBER
171 ,x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174
175
176 -- --------------------------------------------------------------
177 -- COPY ITEM
178 --
179 -- --------------------------------------------------------------
180 PROCEDURE copy_item(
181 p_item_reference_code IN VARCHAR2 DEFAULT NULL
182 ,p_directory_node_id IN NUMBER
183 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
184 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
185 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
186 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
187 ,px_content_item_id IN OUT NOCOPY NUMBER
188 ,px_citem_ver_id IN OUT NOCOPY NUMBER
189 ,px_object_version_number IN OUT NOCOPY NUMBER
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_msg_count OUT NOCOPY NUMBER
192 ,x_msg_data OUT NOCOPY VARCHAR2
193 );
194
195
196
197
198 -- --------------------------------------------------------------
199 -- COPY VERSION
200 --
201 -- --------------------------------------------------------------
202 PROCEDURE copy_version(
203 p_language IN VARCHAR2 DEFAULT USERENV('LANG')
204 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
205 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
206 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
207 ,px_content_item_id IN OUT NOCOPY NUMBER
208 ,px_citem_ver_id IN OUT NOCOPY NUMBER
209 ,px_object_version_number IN OUT NOCOPY NUMBER
210 ,x_return_status OUT NOCOPY VARCHAR2
211 ,x_msg_count OUT NOCOPY NUMBER
212 ,x_msg_data OUT NOCOPY VARCHAR2
213 );
214
215
216
217
218
219 -- --------------------------------------------------------------
220 -- DELETE COMPONENT ITEM
221 --
222 -- --------------------------------------------------------------
223 PROCEDURE delete_component(
224 p_attribute_type_code IN VARCHAR2
225 ,p_citem_ver_id IN NUMBER
226 ,p_content_item_id IN NUMBER
227 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
228 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
229 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
230 ,x_return_status OUT NOCOPY VARCHAR2
231 ,x_msg_count OUT NOCOPY NUMBER
232 ,x_msg_data OUT NOCOPY VARCHAR2
233 );
234
235
236
237
238
239
240
241
242
243
244
245
246
247 -- --------------------------------------------------------------
248 -- DELETE CONTENT ITEM ASSOCIATION
249 --
250 -- --------------------------------------------------------------
251 PROCEDURE delete_association(
252 p_content_item_id IN NUMBER
253 ,p_association_type_code IN VARCHAR2
254 ,p_associated_object_val1 IN VARCHAR2
255 ,p_associated_object_val2 IN VARCHAR2 DEFAULT NULL
256 ,p_associated_object_val3 IN VARCHAR2 DEFAULT NULL
257 ,p_associated_object_val4 IN VARCHAR2 DEFAULT NULL
258 ,p_associated_object_val5 IN VARCHAR2 DEFAULT NULL
259 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
260 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
261 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
262 ,x_return_status OUT NOCOPY VARCHAR2
263 ,x_msg_count OUT NOCOPY NUMBER
264 ,x_msg_data OUT NOCOPY VARCHAR2
265 );
266
267
268
269
270
271
272
273
274
275
276
277
278
279 -- --------------------------------------------------------------
280 -- GET ATTRIBUTE BUNDLE
281 --
282 -- --------------------------------------------------------------
283 PROCEDURE get_attribute_bundle(
284 p_citem_ver_id IN NUMBER
285 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
286 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
287 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
288 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
289 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
290 ,x_object_version_number OUT NOCOPY NUMBER
291 ,x_return_status OUT NOCOPY VARCHAR2
292 ,x_msg_count OUT NOCOPY NUMBER
293 ,x_msg_data OUT NOCOPY VARCHAR2
294 );
295
296 -- Overloaded for 4K limit support on attr values
297 PROCEDURE get_attribute_bundle(
298 p_citem_ver_id IN NUMBER
299 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
300 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
301 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
302 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
303 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
304 ,x_object_version_number OUT NOCOPY NUMBER
305 ,x_return_status OUT NOCOPY VARCHAR2
306 ,x_msg_count OUT NOCOPY NUMBER
307 ,x_msg_data OUT NOCOPY VARCHAR2
308 );
309
310
311
312 -- --------------------------------------------------------------
313 -- GET CONTENT ITEM (FOR UPDATE)
314 --
315 -- --------------------------------------------------------------
316 PROCEDURE get_item(
317 p_citem_ver_id IN NUMBER
318 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
319 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
320 ,x_content_item_id OUT NOCOPY NUMBER
321 ,x_citem_name OUT NOCOPY VARCHAR2
322 ,x_citem_version OUT NOCOPY NUMBER
323 ,x_dir_node_id OUT NOCOPY NUMBER
324 ,x_dir_node_name OUT NOCOPY VARCHAR2
325 ,x_dir_node_code OUT NOCOPY VARCHAR2
326 ,x_item_status OUT NOCOPY VARCHAR2
327 ,x_version_status OUT NOCOPY VARCHAR2
328 ,x_citem_description OUT NOCOPY VARCHAR2
329 ,x_ctype_code OUT NOCOPY VARCHAR2
330 ,x_ctype_name OUT NOCOPY VARCHAR2
331 ,x_start_date OUT NOCOPY DATE
332 ,x_end_date OUT NOCOPY DATE
333 ,x_owner_resource_id OUT NOCOPY NUMBER
334 ,x_owner_resource_type OUT NOCOPY VARCHAR2
335 ,x_reference_code OUT NOCOPY VARCHAR2
336 ,x_trans_required OUT NOCOPY VARCHAR2
337 ,x_parent_item_id OUT NOCOPY NUMBER
338 ,x_locked_by OUT NOCOPY NUMBER
339 ,x_wd_restricted OUT NOCOPY VARCHAR2
340 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
341 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
342 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
343 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
344 ,x_default_rendition OUT NOCOPY NUMBER
345 ,x_object_version_number OUT NOCOPY NUMBER
346 ,x_created_by OUT NOCOPY NUMBER
347 ,x_creation_date OUT NOCOPY DATE
348 ,x_last_updated_by OUT NOCOPY NUMBER
349 ,x_last_update_date OUT NOCOPY DATE
350 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
351 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
352 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
353 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
354 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
355 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
356 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
357 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
358 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
359 ,x_return_status OUT NOCOPY VARCHAR2
360 ,x_msg_count OUT NOCOPY NUMBER
361 ,x_msg_data OUT NOCOPY VARCHAR2
362 );
363
364
365
366 -- --------------------------------------------------------------
367 -- GET CONTENT ITEM (FOR UPDATE)
368 --
369 -- --------------------------------------------------------------
370 PROCEDURE get_item(
371 p_citem_ver_id IN NUMBER
372 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
373 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
374 ,x_content_item_id OUT NOCOPY NUMBER
375 ,x_citem_name OUT NOCOPY VARCHAR2
376 ,x_citem_version OUT NOCOPY NUMBER
377 ,x_dir_node_id OUT NOCOPY NUMBER
378 ,x_dir_node_name OUT NOCOPY VARCHAR2
379 ,x_dir_node_code OUT NOCOPY VARCHAR2
380 ,x_item_status OUT NOCOPY VARCHAR2
381 ,x_version_status OUT NOCOPY VARCHAR2
382 ,x_citem_description OUT NOCOPY VARCHAR2
383 ,x_ctype_code OUT NOCOPY VARCHAR2
384 ,x_ctype_name OUT NOCOPY VARCHAR2
385 ,x_start_date OUT NOCOPY DATE
386 ,x_end_date OUT NOCOPY DATE
387 ,x_owner_resource_id OUT NOCOPY NUMBER
388 ,x_owner_resource_type OUT NOCOPY VARCHAR2
389 ,x_reference_code OUT NOCOPY VARCHAR2
390 ,x_trans_required OUT NOCOPY VARCHAR2
391 ,x_parent_item_id OUT NOCOPY NUMBER
392 ,x_locked_by OUT NOCOPY NUMBER
393 ,x_wd_restricted OUT NOCOPY VARCHAR2
394 ,x_attach_file_id OUT NOCOPY NUMBER
395 ,x_attach_file_name OUT NOCOPY VARCHAR2
396 ,x_object_version_number OUT NOCOPY NUMBER
397 ,x_created_by OUT NOCOPY NUMBER
398 ,x_creation_date OUT NOCOPY DATE
399 ,x_last_updated_by OUT NOCOPY NUMBER
400 ,x_last_update_date OUT NOCOPY DATE
401 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
402 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
403 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
404 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
405 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
406 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
407 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
408 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
409 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
410 ,x_return_status OUT NOCOPY VARCHAR2
411 ,x_msg_count OUT NOCOPY NUMBER
412 ,x_msg_data OUT NOCOPY VARCHAR2
413 );
414
415 --
416 --- get_item: Overloaded to include component item version id
417 PROCEDURE get_item(
418 p_citem_ver_id IN NUMBER
419 ,p_init_msg_list IN VARCHAR2
420 ,p_api_version_number IN NUMBER
421 ,x_content_item_id OUT NOCOPY NUMBER
422 ,x_citem_name OUT NOCOPY VARCHAR2
423 ,x_citem_version OUT NOCOPY NUMBER
424 ,x_dir_node_id OUT NOCOPY NUMBER
425 ,x_dir_node_name OUT NOCOPY VARCHAR2
426 ,x_dir_node_code OUT NOCOPY VARCHAR2
427 ,x_item_status OUT NOCOPY VARCHAR2
428 ,x_version_status OUT NOCOPY VARCHAR2
429 ,x_citem_description OUT NOCOPY VARCHAR2
430 ,x_ctype_code OUT NOCOPY VARCHAR2
431 ,x_ctype_name OUT NOCOPY VARCHAR2
432 ,x_start_date OUT NOCOPY DATE
433 ,x_end_date OUT NOCOPY DATE
434 ,x_owner_resource_id OUT NOCOPY NUMBER
435 ,x_owner_resource_type OUT NOCOPY VARCHAR2
436 ,x_reference_code OUT NOCOPY VARCHAR2
437 ,x_trans_required OUT NOCOPY VARCHAR2
438 ,x_parent_item_id OUT NOCOPY NUMBER
439 ,x_locked_by OUT NOCOPY NUMBER
440 ,x_wd_restricted OUT NOCOPY VARCHAR2
441 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
442 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
443 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
444 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
445 ,x_default_rendition OUT NOCOPY NUMBER
446 ,x_object_version_number OUT NOCOPY NUMBER
447 ,x_created_by OUT NOCOPY NUMBER
448 ,x_creation_date OUT NOCOPY DATE
449 ,x_last_updated_by OUT NOCOPY NUMBER
450 ,x_last_update_date OUT NOCOPY DATE
451 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
452 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
453 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
454 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
455 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
456 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
457 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
458 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
459 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
460 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
461 ,x_return_status OUT NOCOPY VARCHAR2
462 ,x_msg_count OUT NOCOPY NUMBER
463 ,x_msg_data OUT NOCOPY VARCHAR2
464 );
465
466
467 --
468 --- get_item: Overloaded to include keywords
469 PROCEDURE get_item(
470 p_citem_ver_id IN NUMBER
471 ,p_init_msg_list IN VARCHAR2
472 ,p_api_version_number IN NUMBER
473 ,x_content_item_id OUT NOCOPY NUMBER
474 ,x_citem_name OUT NOCOPY VARCHAR2
475 ,x_citem_version OUT NOCOPY NUMBER
476 ,x_dir_node_id OUT NOCOPY NUMBER
477 ,x_dir_node_name OUT NOCOPY VARCHAR2
478 ,x_dir_node_code OUT NOCOPY VARCHAR2
479 ,x_item_status OUT NOCOPY VARCHAR2
480 ,x_version_status OUT NOCOPY VARCHAR2
481 ,x_citem_description OUT NOCOPY VARCHAR2
482 ,x_ctype_code OUT NOCOPY VARCHAR2
483 ,x_ctype_name OUT NOCOPY VARCHAR2
484 ,x_start_date OUT NOCOPY DATE
485 ,x_end_date OUT NOCOPY DATE
486 ,x_owner_resource_id OUT NOCOPY NUMBER
487 ,x_owner_resource_type OUT NOCOPY VARCHAR2
488 ,x_reference_code OUT NOCOPY VARCHAR2
489 ,x_trans_required OUT NOCOPY VARCHAR2
490 ,x_parent_item_id OUT NOCOPY NUMBER
491 ,x_locked_by OUT NOCOPY NUMBER
492 ,x_wd_restricted OUT NOCOPY VARCHAR2
493 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
494 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
495 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
496 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
497 ,x_default_rendition OUT NOCOPY NUMBER
498 ,x_object_version_number OUT NOCOPY NUMBER
499 ,x_created_by OUT NOCOPY NUMBER
500 ,x_creation_date OUT NOCOPY DATE
501 ,x_last_updated_by OUT NOCOPY NUMBER
502 ,x_last_update_date OUT NOCOPY DATE
503 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
504 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
505 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
506 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
507 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
508 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
509 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
510 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
511 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
512 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
513 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
514 ,x_return_status OUT NOCOPY VARCHAR2
515 ,x_msg_count OUT NOCOPY NUMBER
516 ,x_msg_data OUT NOCOPY VARCHAR2
517 );
518
519
520 --
521 --- get_item: Overloaded for new renditions usage
522 PROCEDURE get_item(
523 p_citem_ver_id IN NUMBER
524 ,p_init_msg_list IN VARCHAR2
525 ,p_api_version_number IN NUMBER
526 ,x_content_item_id OUT NOCOPY NUMBER
527 ,x_citem_name OUT NOCOPY VARCHAR2
528 ,x_citem_version OUT NOCOPY NUMBER
529 ,x_dir_node_id OUT NOCOPY NUMBER
530 ,x_dir_node_name OUT NOCOPY VARCHAR2
531 ,x_dir_node_code OUT NOCOPY VARCHAR2
532 ,x_item_status OUT NOCOPY VARCHAR2
533 ,x_version_status OUT NOCOPY VARCHAR2
534 ,x_citem_description OUT NOCOPY VARCHAR2
535 ,x_ctype_code OUT NOCOPY VARCHAR2
536 ,x_ctype_name OUT NOCOPY VARCHAR2
537 ,x_start_date OUT NOCOPY DATE
538 ,x_end_date OUT NOCOPY DATE
539 ,x_owner_resource_id OUT NOCOPY NUMBER
540 ,x_owner_resource_type OUT NOCOPY VARCHAR2
541 ,x_reference_code OUT NOCOPY VARCHAR2
542 ,x_trans_required OUT NOCOPY VARCHAR2
543 ,x_parent_item_id OUT NOCOPY NUMBER
544 ,x_locked_by OUT NOCOPY NUMBER
545 ,x_wd_restricted OUT NOCOPY VARCHAR2
546 ,x_attach_file_id OUT NOCOPY NUMBER
547 ,x_attach_file_name OUT NOCOPY VARCHAR2
548 ,x_attach_mime_type OUT NOCOPY VARCHAR2
549 ,x_attach_mime_name OUT NOCOPY VARCHAR2
550 ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
551 ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
552 ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
553 ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
554 ,x_default_rendition OUT NOCOPY NUMBER
555 ,x_object_version_number OUT NOCOPY NUMBER
556 ,x_created_by OUT NOCOPY NUMBER
557 ,x_creation_date OUT NOCOPY DATE
558 ,x_last_updated_by OUT NOCOPY NUMBER
559 ,x_last_update_date OUT NOCOPY DATE
560 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
561 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
562 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
563 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
564 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
565 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
566 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
567 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
568 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
569 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
570 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
571 ,x_return_status OUT NOCOPY VARCHAR2
572 ,x_msg_count OUT NOCOPY NUMBER
573 ,x_msg_data OUT NOCOPY VARCHAR2
574 );
575
576 -- Overloaded to add support for 32K attr values
577
578 PROCEDURE get_item(
579 p_citem_ver_id IN NUMBER
580 ,p_init_msg_list IN VARCHAR2
581 ,p_api_version_number IN NUMBER
582 ,x_content_item_id OUT NOCOPY NUMBER
583 ,x_citem_name OUT NOCOPY VARCHAR2
584 ,x_citem_version OUT NOCOPY NUMBER
585 ,x_dir_node_id OUT NOCOPY NUMBER
586 ,x_dir_node_name OUT NOCOPY VARCHAR2
587 ,x_dir_node_code OUT NOCOPY VARCHAR2
588 ,x_item_status OUT NOCOPY VARCHAR2
589 ,x_version_status OUT NOCOPY VARCHAR2
590 ,x_citem_description OUT NOCOPY VARCHAR2
591 ,x_ctype_code OUT NOCOPY VARCHAR2
592 ,x_ctype_name OUT NOCOPY VARCHAR2
593 ,x_start_date OUT NOCOPY DATE
594 ,x_end_date OUT NOCOPY DATE
595 ,x_owner_resource_id OUT NOCOPY NUMBER
596 ,x_owner_resource_type OUT NOCOPY VARCHAR2
597 ,x_reference_code OUT NOCOPY VARCHAR2
598 ,x_trans_required OUT NOCOPY VARCHAR2
599 ,x_parent_item_id OUT NOCOPY NUMBER
600 ,x_locked_by OUT NOCOPY NUMBER
601 ,x_wd_restricted OUT NOCOPY VARCHAR2
602 ,x_attach_file_id OUT NOCOPY NUMBER
603 ,x_attach_file_name OUT NOCOPY VARCHAR2
604 ,x_attach_mime_type OUT NOCOPY VARCHAR2
605 ,x_attach_mime_name OUT NOCOPY VARCHAR2
606 ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
607 ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
608 ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
609 ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
610 ,x_default_rendition OUT NOCOPY NUMBER
611 ,x_object_version_number OUT NOCOPY NUMBER
612 ,x_created_by OUT NOCOPY NUMBER
613 ,x_creation_date OUT NOCOPY DATE
614 ,x_last_updated_by OUT NOCOPY NUMBER
615 ,x_last_update_date OUT NOCOPY DATE
616 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
617 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
618 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
619 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
620 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
621 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
622 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
623 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
624 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
625 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
626 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
627 ,x_return_status OUT NOCOPY VARCHAR2
628 ,x_msg_count OUT NOCOPY NUMBER
629 ,x_msg_data OUT NOCOPY VARCHAR2
630 );
631
632
633 -- --------------------------------------------------------------
634 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
635 --
636 -- --------------------------------------------------------------
637 PROCEDURE get_trans_item(
638 p_citem_ver_id IN NUMBER
639 ,p_language IN VARCHAR2
640 ,p_skip_security IN VARCHAR2
641 ,p_init_msg_list IN VARCHAR2
642 ,p_api_version_number IN NUMBER
643 ,x_content_item_id OUT NOCOPY NUMBER
644 ,x_citem_name OUT NOCOPY VARCHAR2
645 ,x_citem_version OUT NOCOPY NUMBER
646 ,x_dir_node_id OUT NOCOPY NUMBER
647 ,x_dir_node_name OUT NOCOPY VARCHAR2
648 ,x_dir_node_code OUT NOCOPY VARCHAR2
649 ,x_item_status OUT NOCOPY VARCHAR2
650 ,x_version_status OUT NOCOPY VARCHAR2
651 ,x_citem_description OUT NOCOPY VARCHAR2
652 ,x_ctype_code OUT NOCOPY VARCHAR2
653 ,x_ctype_name OUT NOCOPY VARCHAR2
654 ,x_start_date OUT NOCOPY DATE
655 ,x_end_date OUT NOCOPY DATE
656 ,x_owner_resource_id OUT NOCOPY NUMBER
657 ,x_owner_resource_type OUT NOCOPY VARCHAR2
658 ,x_reference_code OUT NOCOPY VARCHAR2
659 ,x_trans_required OUT NOCOPY VARCHAR2
660 ,x_parent_item_id OUT NOCOPY NUMBER
661 ,x_locked_by OUT NOCOPY NUMBER
662 ,x_wd_restricted OUT NOCOPY VARCHAR2
663 ,x_attach_file_id OUT NOCOPY NUMBER
664 ,x_attach_file_name OUT NOCOPY VARCHAR2
665 ,x_attach_mime_type OUT NOCOPY VARCHAR2
666 ,x_attach_mime_name OUT NOCOPY VARCHAR2
667 ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
668 ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
669 ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
670 ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
671 ,x_default_rendition OUT NOCOPY NUMBER
672 ,x_object_version_number OUT NOCOPY NUMBER
673 ,x_created_by OUT NOCOPY NUMBER
674 ,x_creation_date OUT NOCOPY DATE
675 ,x_last_updated_by OUT NOCOPY NUMBER
676 ,x_last_update_date OUT NOCOPY DATE
677 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
678 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
679 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
680 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
681 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
682 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
683 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
684 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
685 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
686 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
687 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
688 ,x_return_status OUT NOCOPY VARCHAR2
689 ,x_msg_count OUT NOCOPY NUMBER
690 ,x_msg_data OUT NOCOPY VARCHAR2
691 );
692
693 -- --------------------------------------------------------------
694 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
695 --
696 -- --------------------------------------------------------------
697 PROCEDURE get_trans_item(
698 p_citem_ver_id IN NUMBER
699 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
700 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
701 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
702 ,x_content_item_id OUT NOCOPY NUMBER
703 ,x_citem_name OUT NOCOPY VARCHAR2
704 ,x_citem_version OUT NOCOPY NUMBER
705 ,x_dir_node_id OUT NOCOPY NUMBER
706 ,x_dir_node_name OUT NOCOPY VARCHAR2
707 ,x_dir_node_code OUT NOCOPY VARCHAR2
708 ,x_item_status OUT NOCOPY VARCHAR2
709 ,x_version_status OUT NOCOPY VARCHAR2
710 ,x_citem_description OUT NOCOPY VARCHAR2
711 ,x_ctype_code OUT NOCOPY VARCHAR2
712 ,x_ctype_name OUT NOCOPY VARCHAR2
713 ,x_start_date OUT NOCOPY DATE
714 ,x_end_date OUT NOCOPY DATE
715 ,x_owner_resource_id OUT NOCOPY NUMBER
716 ,x_owner_resource_type OUT NOCOPY VARCHAR2
717 ,x_reference_code OUT NOCOPY VARCHAR2
718 ,x_trans_required OUT NOCOPY VARCHAR2
719 ,x_parent_item_id OUT NOCOPY NUMBER
720 ,x_locked_by OUT NOCOPY NUMBER
721 ,x_wd_restricted OUT NOCOPY VARCHAR2
722 ,x_attach_file_id OUT NOCOPY NUMBER
723 ,x_attach_file_name OUT NOCOPY VARCHAR2
724 ,x_object_version_number OUT NOCOPY NUMBER
725 ,x_created_by OUT NOCOPY NUMBER
726 ,x_creation_date OUT NOCOPY DATE
727 ,x_last_updated_by OUT NOCOPY NUMBER
728 ,x_last_update_date OUT NOCOPY DATE
729 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
730 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
731 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
732 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
733 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
734 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
735 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
736 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
737 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
738 ,x_return_status OUT NOCOPY VARCHAR2
739 ,x_msg_count OUT NOCOPY NUMBER
740 ,x_msg_data OUT NOCOPY VARCHAR2
741 );
742
743 -- --------------------------------------------------------------
744 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
745 --
746 -- Used to get info to display on update page
747 --
748 -- --------------------------------------------------------------
749 PROCEDURE get_trans_item(
750 p_citem_ver_id IN NUMBER
751 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
752 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
753 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
754 ,x_content_item_id OUT NOCOPY NUMBER
755 ,x_citem_name OUT NOCOPY VARCHAR2
756 ,x_citem_version OUT NOCOPY NUMBER
757 ,x_dir_node_id OUT NOCOPY NUMBER
758 ,x_dir_node_name OUT NOCOPY VARCHAR2
759 ,x_dir_node_code OUT NOCOPY VARCHAR2
760 ,x_item_status OUT NOCOPY VARCHAR2
761 ,x_version_status OUT NOCOPY VARCHAR2
762 ,x_citem_description OUT NOCOPY VARCHAR2
763 ,x_ctype_code OUT NOCOPY VARCHAR2
764 ,x_ctype_name OUT NOCOPY VARCHAR2
765 ,x_start_date OUT NOCOPY DATE
766 ,x_end_date OUT NOCOPY DATE
767 ,x_owner_resource_id OUT NOCOPY NUMBER
768 ,x_owner_resource_type OUT NOCOPY VARCHAR2
769 ,x_reference_code OUT NOCOPY VARCHAR2
770 ,x_trans_required OUT NOCOPY VARCHAR2
771 ,x_parent_item_id OUT NOCOPY NUMBER
772 ,x_locked_by OUT NOCOPY NUMBER
773 ,x_wd_restricted OUT NOCOPY VARCHAR2
774 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
775 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
776 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
777 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
778 ,x_default_rendition OUT NOCOPY NUMBER
779 ,x_object_version_number OUT NOCOPY NUMBER
780 ,x_created_by OUT NOCOPY NUMBER
781 ,x_creation_date OUT NOCOPY DATE
782 ,x_last_updated_by OUT NOCOPY NUMBER
783 ,x_last_update_date OUT NOCOPY DATE
784 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
785 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
786 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
787 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
788 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
789 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
790 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
791 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
792 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
793 ,x_return_status OUT NOCOPY VARCHAR2
794 ,x_msg_count OUT NOCOPY NUMBER
795 ,x_msg_data OUT NOCOPY VARCHAR2
796 );
797
798 -- --------------------------------------------------------------
799 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
800 --
801 -- Used to get info to display on update page
802 -- Overloaded to include component item version ids
803 --
804 -- --------------------------------------------------------------
805 PROCEDURE get_trans_item(
806 p_citem_ver_id IN NUMBER
807 ,p_language IN VARCHAR2
808 ,p_init_msg_list IN VARCHAR2
809 ,p_api_version_number IN NUMBER
810 ,x_content_item_id OUT NOCOPY NUMBER
811 ,x_citem_name OUT NOCOPY VARCHAR2
812 ,x_citem_version OUT NOCOPY NUMBER
813 ,x_dir_node_id OUT NOCOPY NUMBER
814 ,x_dir_node_name OUT NOCOPY VARCHAR2
815 ,x_dir_node_code OUT NOCOPY VARCHAR2
816 ,x_item_status OUT NOCOPY VARCHAR2
817 ,x_version_status OUT NOCOPY VARCHAR2
818 ,x_citem_description OUT NOCOPY VARCHAR2
819 ,x_ctype_code OUT NOCOPY VARCHAR2
820 ,x_ctype_name OUT NOCOPY VARCHAR2
821 ,x_start_date OUT NOCOPY DATE
822 ,x_end_date OUT NOCOPY DATE
823 ,x_owner_resource_id OUT NOCOPY NUMBER
824 ,x_owner_resource_type OUT NOCOPY VARCHAR2
825 ,x_reference_code OUT NOCOPY VARCHAR2
826 ,x_trans_required OUT NOCOPY VARCHAR2
827 ,x_parent_item_id OUT NOCOPY NUMBER
828 ,x_locked_by OUT NOCOPY NUMBER
829 ,x_wd_restricted OUT NOCOPY VARCHAR2
830 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
831 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
832 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
833 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
834 ,x_default_rendition OUT NOCOPY NUMBER
835 ,x_object_version_number OUT NOCOPY NUMBER
836 ,x_created_by OUT NOCOPY NUMBER
837 ,x_creation_date OUT NOCOPY DATE
838 ,x_last_updated_by OUT NOCOPY NUMBER
839 ,x_last_update_date OUT NOCOPY DATE
840 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
841 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
842 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
843 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
844 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
845 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
846 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
847 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
848 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
849 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
850 ,x_return_status OUT NOCOPY VARCHAR2
851 ,x_msg_count OUT NOCOPY NUMBER
852 ,x_msg_data OUT NOCOPY VARCHAR2
853 );
854
855 -- --------------------------------------------------------------
856 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
857 --
858 -- Used to get info to display on update page
859 -- Overloaded to include component item version ids
860 --
861 -- --------------------------------------------------------------
862 PROCEDURE get_trans_item(
863 p_citem_ver_id IN NUMBER
864 ,p_language IN VARCHAR2
865 ,p_init_msg_list IN VARCHAR2
866 ,p_api_version_number IN NUMBER
867 ,x_content_item_id OUT NOCOPY NUMBER
868 ,x_citem_name OUT NOCOPY VARCHAR2
869 ,x_citem_version OUT NOCOPY NUMBER
870 ,x_dir_node_id OUT NOCOPY NUMBER
871 ,x_dir_node_name OUT NOCOPY VARCHAR2
872 ,x_dir_node_code OUT NOCOPY VARCHAR2
873 ,x_item_status OUT NOCOPY VARCHAR2
874 ,x_version_status OUT NOCOPY VARCHAR2
875 ,x_citem_description OUT NOCOPY VARCHAR2
876 ,x_ctype_code OUT NOCOPY VARCHAR2
877 ,x_ctype_name OUT NOCOPY VARCHAR2
878 ,x_start_date OUT NOCOPY DATE
879 ,x_end_date OUT NOCOPY DATE
880 ,x_owner_resource_id OUT NOCOPY NUMBER
881 ,x_owner_resource_type OUT NOCOPY VARCHAR2
882 ,x_reference_code OUT NOCOPY VARCHAR2
883 ,x_trans_required OUT NOCOPY VARCHAR2
884 ,x_parent_item_id OUT NOCOPY NUMBER
885 ,x_locked_by OUT NOCOPY NUMBER
886 ,x_wd_restricted OUT NOCOPY VARCHAR2
887 ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
888 ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
889 ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
890 ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
891 ,x_default_rendition OUT NOCOPY NUMBER
892 ,x_object_version_number OUT NOCOPY NUMBER
893 ,x_created_by OUT NOCOPY NUMBER
894 ,x_creation_date OUT NOCOPY DATE
895 ,x_last_updated_by OUT NOCOPY NUMBER
896 ,x_last_update_date OUT NOCOPY DATE
897 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
898 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
899 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
900 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
901 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
902 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
903 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
904 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
905 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
906 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
907 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
908 ,x_return_status OUT NOCOPY VARCHAR2
909 ,x_msg_count OUT NOCOPY NUMBER
910 ,x_msg_data OUT NOCOPY VARCHAR2
911 );
912
913 -- --------------------------------------------------------------
914 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
915 --
916 -- --------------------------------------------------------------
917 PROCEDURE get_trans_item(
918 p_citem_ver_id IN NUMBER
919 ,p_language IN VARCHAR2
920 ,p_init_msg_list IN VARCHAR2
921 ,p_api_version_number IN NUMBER
922 ,x_content_item_id OUT NOCOPY NUMBER
923 ,x_citem_name OUT NOCOPY VARCHAR2
924 ,x_citem_version OUT NOCOPY NUMBER
925 ,x_dir_node_id OUT NOCOPY NUMBER
926 ,x_dir_node_name OUT NOCOPY VARCHAR2
927 ,x_dir_node_code OUT NOCOPY VARCHAR2
928 ,x_item_status OUT NOCOPY VARCHAR2
929 ,x_version_status OUT NOCOPY VARCHAR2
930 ,x_citem_description OUT NOCOPY VARCHAR2
931 ,x_ctype_code OUT NOCOPY VARCHAR2
932 ,x_ctype_name OUT NOCOPY VARCHAR2
933 ,x_start_date OUT NOCOPY DATE
934 ,x_end_date OUT NOCOPY DATE
935 ,x_owner_resource_id OUT NOCOPY NUMBER
936 ,x_owner_resource_type OUT NOCOPY VARCHAR2
937 ,x_reference_code OUT NOCOPY VARCHAR2
938 ,x_trans_required OUT NOCOPY VARCHAR2
939 ,x_parent_item_id OUT NOCOPY NUMBER
940 ,x_locked_by OUT NOCOPY NUMBER
941 ,x_wd_restricted OUT NOCOPY VARCHAR2
942 ,x_attach_file_id OUT NOCOPY NUMBER
943 ,x_attach_file_name OUT NOCOPY VARCHAR2
944 ,x_attach_mime_type OUT NOCOPY VARCHAR2
945 ,x_attach_mime_name OUT NOCOPY VARCHAR2
946 ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
947 ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
948 ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
949 ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
950 ,x_default_rendition OUT NOCOPY NUMBER
951 ,x_object_version_number OUT NOCOPY NUMBER
952 ,x_created_by OUT NOCOPY NUMBER
953 ,x_creation_date OUT NOCOPY DATE
954 ,x_last_updated_by OUT NOCOPY NUMBER
955 ,x_last_update_date OUT NOCOPY DATE
956 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
957 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
958 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
959 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
960 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
961 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
962 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
963 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
964 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
965 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
966 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
967 ,x_return_status OUT NOCOPY VARCHAR2
968 ,x_msg_count OUT NOCOPY NUMBER
969 ,x_msg_data OUT NOCOPY VARCHAR2
970 );
971
972 -- --------------------------------------------------------------
973 -- GET TRANSLATED CONTENT ITEM (FOR UPDATE)
974 -- Added support for attr values with upto 32K
975 -- --------------------------------------------------------------
976 PROCEDURE get_trans_item(
977 p_citem_ver_id IN NUMBER
978 ,p_language IN VARCHAR2
979 ,p_init_msg_list IN VARCHAR2
980 ,p_api_version_number IN NUMBER
981 ,x_content_item_id OUT NOCOPY NUMBER
982 ,x_citem_name OUT NOCOPY VARCHAR2
983 ,x_citem_version OUT NOCOPY NUMBER
984 ,x_dir_node_id OUT NOCOPY NUMBER
985 ,x_dir_node_name OUT NOCOPY VARCHAR2
986 ,x_dir_node_code OUT NOCOPY VARCHAR2
987 ,x_item_status OUT NOCOPY VARCHAR2
988 ,x_version_status OUT NOCOPY VARCHAR2
989 ,x_citem_description OUT NOCOPY VARCHAR2
990 ,x_ctype_code OUT NOCOPY VARCHAR2
991 ,x_ctype_name OUT NOCOPY VARCHAR2
992 ,x_start_date OUT NOCOPY DATE
993 ,x_end_date OUT NOCOPY DATE
994 ,x_owner_resource_id OUT NOCOPY NUMBER
995 ,x_owner_resource_type OUT NOCOPY VARCHAR2
996 ,x_reference_code OUT NOCOPY VARCHAR2
997 ,x_trans_required OUT NOCOPY VARCHAR2
998 ,x_parent_item_id OUT NOCOPY NUMBER
999 ,x_locked_by OUT NOCOPY NUMBER
1000 ,x_wd_restricted OUT NOCOPY VARCHAR2
1001 ,x_attach_file_id OUT NOCOPY NUMBER
1002 ,x_attach_file_name OUT NOCOPY VARCHAR2
1003 ,x_attach_mime_type OUT NOCOPY VARCHAR2
1004 ,x_attach_mime_name OUT NOCOPY VARCHAR2
1005 ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
1006 ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
1007 ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
1008 ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
1009 ,x_default_rendition OUT NOCOPY NUMBER
1010 ,x_object_version_number OUT NOCOPY NUMBER
1011 ,x_created_by OUT NOCOPY NUMBER
1012 ,x_creation_date OUT NOCOPY DATE
1013 ,x_last_updated_by OUT NOCOPY NUMBER
1014 ,x_last_update_date OUT NOCOPY DATE
1015 ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
1016 ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
1017 ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
1018 ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
1019 ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
1020 ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
1021 ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
1022 ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
1023 ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
1024 ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
1025 ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
1026 ,x_return_status OUT NOCOPY VARCHAR2
1027 ,x_msg_count OUT NOCOPY NUMBER
1028 ,x_msg_data OUT NOCOPY VARCHAR2
1029 );
1030
1031 -- --------------------------------------------------------------
1032 -- HARD DELETE ITEM VERSION
1033 --
1034 -- --------------------------------------------------------------
1035 PROCEDURE hard_delete_item_versions(
1036 p_api_version IN NUMBER,
1037 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1038 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1039 p_citem_version_ids IN JTF_NUMBER_TABLE,
1040 x_return_status OUT NOCOPY VARCHAR2,
1041 x_msg_count OUT NOCOPY NUMBER,
1042 x_msg_data OUT NOCOPY VARCHAR2
1043 );
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054 -- --------------------------------------------------------------
1055 -- HARD DELETE ITEMS
1056 --
1057 -- --------------------------------------------------------------
1058 PROCEDURE hard_delete_items (
1059 p_api_version IN NUMBER,
1060 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1061 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1062 p_content_item_ids IN JTF_NUMBER_TABLE,
1063 x_return_status OUT NOCOPY VARCHAR2,
1064 x_msg_count OUT NOCOPY NUMBER,
1065 x_msg_data OUT NOCOPY VARCHAR2
1066 );
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076 -- --------------------------------------------------------------
1077 -- INSERT COMPONENT ITEMS
1078 --
1079 -- --------------------------------------------------------------
1080 PROCEDURE insert_components(
1081 p_citem_ver_id IN NUMBER
1082 ,p_content_item_ids IN JTF_NUMBER_TABLE
1083 ,p_citem_ver_ids IN JTF_NUMBER_TABLE
1084 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1085 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1086 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1087 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1088 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1089 ,x_return_status OUT NOCOPY VARCHAR2
1090 ,x_msg_count OUT NOCOPY NUMBER
1091 ,x_msg_data OUT NOCOPY VARCHAR2
1092 );
1093
1094 -- --------------------------------------------------------------
1095 -- INSERT COMPONENT ITEMS
1096 -- Overloaded with no subitem ver_ids
1097 -- --------------------------------------------------------------
1098 PROCEDURE insert_components(
1099 p_citem_ver_id IN NUMBER
1100 ,p_content_item_ids IN JTF_NUMBER_TABLE
1101 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1102 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1103 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1104 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1105 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1106 ,x_return_status OUT NOCOPY VARCHAR2
1107 ,x_msg_count OUT NOCOPY NUMBER
1108 ,x_msg_data OUT NOCOPY VARCHAR2
1109 );
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120 -- --------------------------------------------------------------
1121 -- INSERT CONTENT ITEM (ASSOCIATIONS)
1122 --
1123 -- --------------------------------------------------------------
1124 PROCEDURE insert_associations(
1125 p_content_item_id IN NUMBER
1126 ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100
1127 ,p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300
1128 ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1129 ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1130 ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1131 ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1132 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1133 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1134 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1135 ,x_return_status OUT NOCOPY VARCHAR2
1136 ,x_msg_count OUT NOCOPY NUMBER
1137 ,x_msg_data OUT NOCOPY VARCHAR2
1138 );
1139
1140 PROCEDURE insert_associations(
1141 p_content_item_id IN NUMBER
1142 ,p_citem_version_id IN NUMBER
1143 ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100
1144 ,p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300
1145 ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1146 ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1147 ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1148 ,p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1149 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1150 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1151 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1152 ,x_return_status OUT NOCOPY VARCHAR2
1153 ,x_msg_count OUT NOCOPY NUMBER
1154 ,x_msg_data OUT NOCOPY VARCHAR2
1155 );
1156
1157
1158
1159
1160 -- --------------------------------------------------------------
1161 -- INSERT CONTENT ITEM (MINIMUM)
1162 --
1163 -- --------------------------------------------------------------
1164 PROCEDURE insert_minimum_item(
1165 p_ctype_code IN VARCHAR2
1166 ,p_citem_name IN VARCHAR2
1167 ,p_citem_description IN VARCHAR2 DEFAULT NULL
1168 ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1169 ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1170 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1171 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1172 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1173 ,px_content_item_id IN OUT NOCOPY NUMBER
1174 ,px_object_version_number IN OUT NOCOPY NUMBER
1175 ,x_citem_ver_id OUT NOCOPY NUMBER
1176 ,x_return_status OUT NOCOPY VARCHAR2
1177 ,x_msg_count OUT NOCOPY NUMBER
1178 ,x_msg_data OUT NOCOPY VARCHAR2
1179 );
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191 -- --------------------------------------------------------------
1192 -- LOCK CONTENT ITEM
1193 --
1194 -- --------------------------------------------------------------
1195
1196 PROCEDURE lock_item(
1197 p_content_item_id IN NUMBER
1198 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1199 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1200 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1201 ,x_citem_version_id OUT NOCOPY NUMBER
1202 ,x_object_version_number OUT NOCOPY NUMBER
1203 ,x_return_status OUT NOCOPY VARCHAR2
1204 ,x_msg_count OUT NOCOPY NUMBER
1205 ,x_msg_data OUT NOCOPY VARCHAR2
1206 );
1207
1208
1209
1210
1211
1212
1213
1214 -- --------------------------------------------------------------
1215 -- PRE VALIDATE ITEM
1216 --
1217 -- --------------------------------------------------------------
1218 PROCEDURE pre_validate_item(
1219 p_citem_ver_id IN NUMBER
1220 ,x_return_status OUT NOCOPY VARCHAR2
1221 ,x_msg_count OUT NOCOPY NUMBER
1222 ,x_msg_data OUT NOCOPY VARCHAR2
1223 );
1224
1225
1226
1227
1228
1229 -- --------------------------------------------------------------
1230 -- SET CONTENT ITEM (ATTRIBUTE BUNDLE)
1231 --
1232 -- --------------------------------------------------------------
1233
1234 PROCEDURE set_attribute_bundle(
1235 p_citem_ver_id IN NUMBER
1236 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1237 ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1238 ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1239 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1240 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1241 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1242 ,px_object_version_number IN OUT NOCOPY NUMBER
1243 ,x_return_status OUT NOCOPY VARCHAR2
1244 ,x_msg_count OUT NOCOPY NUMBER
1245 ,x_msg_data OUT NOCOPY VARCHAR2
1246 );
1247
1248 -- Overloaded: added support for 32K attr values
1249 PROCEDURE set_attribute_bundle(
1250 p_citem_ver_id IN NUMBER
1251 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1252 ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1253 ,p_remove_old IN VARCHAR2 DEFAULT FND_API.g_false
1254 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1255 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1256 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1257 ,px_object_version_number IN OUT NOCOPY NUMBER
1258 ,x_return_status OUT NOCOPY VARCHAR2
1259 ,x_msg_count OUT NOCOPY NUMBER
1260 ,x_msg_data OUT NOCOPY VARCHAR2
1261 );
1262
1263
1264
1265
1266
1267
1268
1269
1270 -- --------------------------------------------------------------
1271 -- SET CONTENT ITEM (ATTACHMENTS)
1272 --
1273 -- --------------------------------------------------------------
1274
1275 PROCEDURE set_attachment(
1276 p_citem_ver_id IN NUMBER
1277 ,p_attach_file_id IN NUMBER
1278 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1279 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1280 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1281 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1282 ,px_object_version_number IN OUT NOCOPY NUMBER
1283 ,x_return_status OUT NOCOPY VARCHAR2
1284 ,x_msg_count OUT NOCOPY NUMBER
1285 ,x_msg_data OUT NOCOPY VARCHAR2
1286 );
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301 -- --------------------------------------------------------------
1302 -- SET CONTENT ITEM (META)
1303 --
1304 -- --------------------------------------------------------------
1305 PROCEDURE set_citem_meta(
1306 p_content_item_id IN NUMBER
1307 ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1308 ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1309 ,p_owner_resource_id IN NUMBER DEFAULT NULL
1310 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1311 ,p_parent_item_id IN NUMBER DEFAULT NULL
1312 ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_false
1313 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1314 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1315 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1316 ,px_object_version_number IN OUT NOCOPY NUMBER
1317 ,x_return_status OUT NOCOPY VARCHAR2
1318 ,x_msg_count OUT NOCOPY NUMBER
1319 ,x_msg_data OUT NOCOPY VARCHAR2
1320 );
1321
1322
1323
1324
1325
1326
1327 -- --------------------------------------------------------------
1328 -- SET LIVE VERSION
1329 --
1330 -- Set Live Version
1331 --
1332 -- --------------------------------------------------------------
1333 PROCEDURE Set_Live_Version(
1334 p_content_item_id IN NUMBER
1335 ,p_citem_ver_id IN NUMBER
1336 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1337 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1338 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1339 ,px_object_version_number IN OUT NOCOPY NUMBER
1340 ,x_return_status OUT NOCOPY VARCHAR2
1341 ,x_msg_count OUT NOCOPY NUMBER
1342 ,x_msg_data OUT NOCOPY VARCHAR2
1343 );
1344
1345
1346
1347
1348
1349 -- --------------------------------------------------------------
1350 -- SET CONTENT ITEM VERSION(META)
1351 --
1352 -- --------------------------------------------------------------
1353 PROCEDURE set_version_meta(
1354 p_citem_ver_id IN NUMBER
1355 ,p_citem_name IN VARCHAR2 DEFAULT NULL
1356 ,p_citem_description IN VARCHAR2 DEFAULT NULL
1357 ,p_start_date IN DATE DEFAULT NULL
1358 ,p_end_date IN DATE DEFAULT NULL
1359 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1360 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1361 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1362 ,px_object_version_number IN OUT NOCOPY NUMBER
1363 ,x_return_status OUT NOCOPY VARCHAR2
1364 ,x_msg_count OUT NOCOPY NUMBER
1365 ,x_msg_data OUT NOCOPY VARCHAR2
1366 );
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378 -- --------------------------------------------------------------
1379 -- UNARCHIVE ITEM
1380 --
1381 -- --------------------------------------------------------------
1382 PROCEDURE unarchive_item(
1383 p_content_item_id IN NUMBER
1384 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1385 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1386 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1387 ,px_object_version_number IN OUT NOCOPY NUMBER
1388 ,x_return_status OUT NOCOPY VARCHAR2
1389 ,x_msg_count OUT NOCOPY NUMBER
1390 ,x_msg_data OUT NOCOPY VARCHAR2
1391 );
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403 -- --------------------------------------------------------------
1404 -- UNLOCK CONTENT ITEM
1405 --
1406 -- --------------------------------------------------------------
1407
1408 PROCEDURE unlock_item(
1409 p_content_item_id IN NUMBER
1410 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1411 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1412 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1413 ,x_return_status OUT NOCOPY VARCHAR2
1414 ,x_msg_count OUT NOCOPY NUMBER
1415 ,x_msg_data OUT NOCOPY VARCHAR2
1416 );
1417
1418
1419
1420
1421
1422
1423 -- --------------------------------------------------------------
1424 -- UPSERT ITEM
1425 -- no renditions
1426 -- --------------------------------------------------------------
1427 PROCEDURE upsert_item(
1428 p_ctype_code IN VARCHAR2
1429 ,p_citem_name IN VARCHAR2
1430 ,p_citem_description IN VARCHAR2
1431 ,p_dir_node_id IN NUMBER DEFAULT IBC_UTILITIES_PUB.G_COMMON_DIR_NODE
1432 ,p_owner_resource_id IN NUMBER DEFAULT NULL
1433 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1434 ,p_reference_code IN VARCHAR2 DEFAULT NULL
1435 ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1436 ,p_parent_item_id IN NUMBER DEFAULT NULL
1437 ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1438 ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1439 ,p_start_date IN DATE DEFAULT NULL
1440 ,p_end_date IN DATE DEFAULT NULL
1441 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1442 ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL
1443 ,p_attach_file_id IN NUMBER DEFAULT NULL
1444 ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1445 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1446 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1447 ,p_status IN VARCHAR2 DEFAULT IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS
1448 ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1449 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1450 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1451 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1452 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1453 ,px_content_item_id IN OUT NOCOPY NUMBER
1454 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1455 ,px_object_version_number IN OUT NOCOPY NUMBER
1456 ,x_return_status OUT NOCOPY VARCHAR2
1457 ,x_msg_count OUT NOCOPY NUMBER
1458 ,x_msg_data OUT NOCOPY VARCHAR2
1459 );
1460
1461 -- --------------------------------------------------------------
1462 -- UPSERT ITEM
1463 --
1464 -- --------------------------------------------------------------
1465 PROCEDURE upsert_item(
1466 p_ctype_code IN VARCHAR2
1467 ,p_citem_name IN VARCHAR2
1468 ,p_citem_description IN VARCHAR2
1469 ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1470 ,p_owner_resource_id IN NUMBER DEFAULT NULL
1471 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1472 ,p_reference_code IN VARCHAR2 DEFAULT NULL
1473 ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1474 ,p_parent_item_id IN NUMBER DEFAULT NULL
1475 ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1476 ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1477 ,p_start_date IN DATE DEFAULT NULL
1478 ,p_end_date IN DATE DEFAULT NULL
1479 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1480 ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL
1481 ,p_attach_file_ids IN JTF_NUMBER_TABLE
1482 ,p_default_rendition IN NUMBER DEFAULT NULL
1483 ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1484 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1485 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1486 ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1487 ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1488 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1489 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1490 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1491 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1492 ,px_content_item_id IN OUT NOCOPY NUMBER
1493 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1494 ,px_object_version_number IN OUT NOCOPY NUMBER
1495 ,x_return_status OUT NOCOPY VARCHAR2
1496 ,x_msg_count OUT NOCOPY NUMBER
1497 ,x_msg_data OUT NOCOPY VARCHAR2
1498 );
1499
1500 -- --------------------------------------------------------------
1501 -- UPSERT ITEM FULL
1502 --
1503 -- Overloaded - Added support for 32K attr values
1504 -- --------------------------------------------------------------
1505 PROCEDURE upsert_item_full(
1506 p_ctype_code IN VARCHAR2
1507 ,p_citem_name IN VARCHAR2
1508 ,p_citem_description IN VARCHAR2
1509 ,p_dir_node_id IN NUMBER
1510 ,p_owner_resource_id IN NUMBER
1511 ,p_owner_resource_type IN VARCHAR2
1512 ,p_reference_code IN VARCHAR2
1513 ,p_trans_required IN VARCHAR2
1514 ,p_parent_item_id IN NUMBER
1515 ,p_lock_flag IN VARCHAR2
1516 ,p_wd_restricted IN VARCHAR2
1517 ,p_start_date IN DATE
1518 ,p_end_date IN DATE
1519 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1520 ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1521 ,p_attach_file_id IN NUMBER
1522 ,p_item_renditions IN JTF_NUMBER_TABLE
1523 ,p_default_rendition IN NUMBER
1524 ,p_component_citems IN JTF_NUMBER_TABLE
1525 ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
1526 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
1527 ,p_sort_order IN JTF_NUMBER_TABLE
1528 ,p_keywords IN JTF_VARCHAR2_TABLE_100
1529 ,p_status IN VARCHAR2
1530 ,p_log_action IN VARCHAR2
1531 ,p_language IN VARCHAR2
1532 ,p_update IN VARCHAR2
1533 ,p_commit IN VARCHAR2
1534 ,p_api_version_number IN NUMBER
1535 ,p_init_msg_list IN VARCHAR2
1536 ,px_content_item_id IN OUT NOCOPY NUMBER
1537 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1538 ,px_object_version_number IN OUT NOCOPY NUMBER
1539 ,x_return_status OUT NOCOPY VARCHAR2
1540 ,x_msg_count OUT NOCOPY NUMBER
1541 ,x_msg_data OUT NOCOPY VARCHAR2
1542 );
1543
1544 -- --------------------------------------------------------------
1545 -- UPSERT ITEM FULL
1546 --
1547 -- Overloaded - For "old" attachment renditions
1548 -- --------------------------------------------------------------
1549 PROCEDURE upsert_item_full(
1550 p_ctype_code IN VARCHAR2
1551 ,p_citem_name IN VARCHAR2
1552 ,p_citem_description IN VARCHAR2
1553 ,p_dir_node_id IN NUMBER
1554 ,p_owner_resource_id IN NUMBER
1555 ,p_owner_resource_type IN VARCHAR2
1556 ,p_reference_code IN VARCHAR2
1557 ,p_trans_required IN VARCHAR2
1558 ,p_parent_item_id IN NUMBER
1559 ,p_lock_flag IN VARCHAR2
1560 ,p_wd_restricted IN VARCHAR2
1561 ,p_start_date IN DATE
1562 ,p_end_date IN DATE
1563 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1564 ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1565 ,p_attach_file_id IN NUMBER
1566 ,p_item_renditions IN JTF_NUMBER_TABLE
1567 ,p_default_rendition IN NUMBER
1568 ,p_component_citems IN JTF_NUMBER_TABLE
1569 ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
1570 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
1571 ,p_sort_order IN JTF_NUMBER_TABLE
1572 ,p_keywords IN JTF_VARCHAR2_TABLE_100
1573 ,p_status IN VARCHAR2
1574 ,p_log_action IN VARCHAR2
1575 ,p_language IN VARCHAR2
1576 ,p_update IN VARCHAR2
1577 ,p_commit IN VARCHAR2
1578 ,p_api_version_number IN NUMBER
1579 ,p_init_msg_list IN VARCHAR2
1580 ,px_content_item_id IN OUT NOCOPY NUMBER
1581 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1582 ,px_object_version_number IN OUT NOCOPY NUMBER
1583 ,x_return_status OUT NOCOPY VARCHAR2
1584 ,x_msg_count OUT NOCOPY NUMBER
1585 ,x_msg_data OUT NOCOPY VARCHAR2
1586 );
1587
1588 -- --------------------------------------------------------------
1589 -- UPSERT ITEM FULL
1590 --
1591 -- Overloaded - For "old" attachment renditions
1592 -- --------------------------------------------------------------
1593 PROCEDURE upsert_item_full(
1594 p_ctype_code IN VARCHAR2
1595 ,p_citem_name IN VARCHAR2
1596 ,p_citem_description IN VARCHAR2
1597 ,p_dir_node_id IN NUMBER
1598 ,p_owner_resource_id IN NUMBER
1599 ,p_owner_resource_type IN VARCHAR2
1600 ,p_reference_code IN VARCHAR2
1601 ,p_trans_required IN VARCHAR2
1602 ,p_parent_item_id IN NUMBER
1603 ,p_lock_flag IN VARCHAR2
1604 ,p_wd_restricted IN VARCHAR2
1605 ,p_start_date IN DATE
1606 ,p_end_date IN DATE
1607 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1608 ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1609 ,p_attach_file_ids IN JTF_NUMBER_TABLE
1610 ,p_default_rendition IN NUMBER
1611 ,p_component_citems IN JTF_NUMBER_TABLE
1612 ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
1613 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
1614 ,p_sort_order IN JTF_NUMBER_TABLE
1615 ,p_keywords IN JTF_VARCHAR2_TABLE_100
1616 ,p_status IN VARCHAR2
1617 ,p_log_action IN VARCHAR2
1618 ,p_language IN VARCHAR2
1619 ,p_update IN VARCHAR2
1620 ,p_commit IN VARCHAR2
1621 ,p_api_version_number IN NUMBER
1622 ,p_init_msg_list IN VARCHAR2
1623 ,px_content_item_id IN OUT NOCOPY NUMBER
1624 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1625 ,px_object_version_number IN OUT NOCOPY NUMBER
1626 ,x_return_status OUT NOCOPY VARCHAR2
1627 ,x_msg_count OUT NOCOPY NUMBER
1628 ,x_msg_data OUT NOCOPY VARCHAR2
1629 );
1630
1631 -- --------------------------------------------------------------
1632 -- UPSERT ITEM FULL
1633 -- Overloaded - No Keywords
1634 --
1635 -- --------------------------------------------------------------
1636 PROCEDURE upsert_item_full(
1637 p_ctype_code IN VARCHAR2
1638 ,p_citem_name IN VARCHAR2
1639 ,p_citem_description IN VARCHAR2
1640 ,p_dir_node_id IN NUMBER
1641 ,p_owner_resource_id IN NUMBER
1642 ,p_owner_resource_type IN VARCHAR2
1643 ,p_reference_code IN VARCHAR2
1644 ,p_trans_required IN VARCHAR2
1645 ,p_parent_item_id IN NUMBER
1646 ,p_lock_flag IN VARCHAR2
1647 ,p_wd_restricted IN VARCHAR2
1648 ,p_start_date IN DATE
1649 ,p_end_date IN DATE
1650 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1651 ,p_attributes IN JTF_VARCHAR2_TABLE_4000
1652 ,p_attach_file_ids IN JTF_NUMBER_TABLE
1653 ,p_default_rendition IN NUMBER
1654 ,p_component_citems IN JTF_NUMBER_TABLE
1655 ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
1656 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
1657 ,p_sort_order IN JTF_NUMBER_TABLE
1658 ,p_status IN VARCHAR2
1659 ,p_log_action IN VARCHAR2
1660 ,p_language IN VARCHAR2
1661 ,p_update IN VARCHAR2
1662 ,p_commit IN VARCHAR2
1663 ,p_api_version_number IN NUMBER
1664 ,p_init_msg_list IN VARCHAR2
1665 ,px_content_item_id IN OUT NOCOPY NUMBER
1666 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1667 ,px_object_version_number IN OUT NOCOPY NUMBER
1668 ,x_return_status OUT NOCOPY VARCHAR2
1669 ,x_msg_count OUT NOCOPY NUMBER
1670 ,x_msg_data OUT NOCOPY VARCHAR2
1671 );
1672
1673
1674 -- --------------------------------------------------------------
1675 -- UPSERT ITEM FULL
1676 -- Overloaded no access to sub component item version ids.
1677 --
1678 -- --------------------------------------------------------------
1679 PROCEDURE upsert_item_full(
1680 p_ctype_code IN VARCHAR2
1681 ,p_citem_name IN VARCHAR2
1682 ,p_citem_description IN VARCHAR2
1683 ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1684 ,p_owner_resource_id IN NUMBER DEFAULT NULL
1685 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1686 ,p_reference_code IN VARCHAR2 DEFAULT NULL
1687 ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1688 ,p_parent_item_id IN NUMBER DEFAULT NULL
1689 ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1690 ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1691 ,p_start_date IN DATE DEFAULT NULL
1692 ,p_end_date IN DATE DEFAULT NULL
1693 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1694 ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL
1695 ,p_attach_file_ids IN JTF_NUMBER_TABLE DEFAULT NULL
1696 ,p_default_rendition IN NUMBER DEFAULT NULL
1697 ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1698 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1699 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1700 ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1701 ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1702 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1703 ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1704 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1705 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1706 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1707 ,px_content_item_id IN OUT NOCOPY NUMBER
1708 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1709 ,px_object_version_number IN OUT NOCOPY NUMBER
1710 ,x_return_status OUT NOCOPY VARCHAR2
1711 ,x_msg_count OUT NOCOPY NUMBER
1712 ,x_msg_data OUT NOCOPY VARCHAR2
1713 );
1714
1715
1716 -- --------------------------------------------------------------
1717 -- UPSERT ITEM FULL
1718 -- Wrapper - no renditions
1719 -- --------------------------------------------------------------
1720 PROCEDURE upsert_item_full(
1721 p_ctype_code IN VARCHAR2
1722 ,p_citem_name IN VARCHAR2
1723 ,p_citem_description IN VARCHAR2
1724 ,p_dir_node_id IN NUMBER DEFAULT Ibc_Utilities_Pub.G_COMMON_DIR_NODE
1725 ,p_owner_resource_id IN NUMBER DEFAULT NULL
1726 ,p_owner_resource_type IN VARCHAR2 DEFAULT NULL
1727 ,p_reference_code IN VARCHAR2 DEFAULT NULL
1728 ,p_trans_required IN VARCHAR2 DEFAULT FND_API.g_false
1729 ,p_parent_item_id IN NUMBER DEFAULT NULL
1730 ,p_lock_flag IN VARCHAR2 DEFAULT FND_API.g_true
1731 ,p_wd_restricted IN VARCHAR2 DEFAULT FND_API.g_true
1732 ,p_start_date IN DATE DEFAULT NULL
1733 ,p_end_date IN DATE DEFAULT NULL
1734 ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1735 ,p_attributes IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL
1736 ,p_attach_file_id IN NUMBER DEFAULT NULL
1737 ,p_component_citems IN JTF_NUMBER_TABLE DEFAULT NULL
1738 ,p_component_atypes IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
1739 ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
1740 ,p_status IN VARCHAR2 DEFAULT Ibc_Utilities_Pub.G_STV_WORK_IN_PROGRESS
1741 ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
1742 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1743 ,p_update IN VARCHAR2 DEFAULT FND_API.g_false
1744 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_true
1745 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1746 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1747 ,px_content_item_id IN OUT NOCOPY NUMBER
1748 ,px_citem_ver_id IN OUT NOCOPY NUMBER
1749 ,px_object_version_number IN OUT NOCOPY NUMBER
1750 ,x_return_status OUT NOCOPY VARCHAR2
1751 ,x_msg_count OUT NOCOPY NUMBER
1752 ,x_msg_data OUT NOCOPY VARCHAR2
1753 );
1754
1755
1756 -- --------------------------------------------------------------
1757 -- IBC_CITEM_ADMIN_GRP.CHANGE_TRANSLATION_STATUS
1758 -- It changes status of a particular version. It will not allow
1759 -- changes to approved versions. NOTE: archiving of versions is
1760 -- not currently supported even though status CODE exists.
1761 -- --------------------------------------------------------------
1762
1763 PROCEDURE Change_Translation_Status(
1764 p_citem_ver_id IN NUMBER
1765 ,p_new_status IN VARCHAR2
1766 ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1767 ,p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1768 ,p_api_version_number IN NUMBER DEFAULT G_API_VERSION_DEFAULT
1769 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1770 ,px_object_version_number IN OUT NOCOPY NUMBER
1771 ,x_return_status OUT NOCOPY VARCHAR2
1772 ,x_msg_count OUT NOCOPY NUMBER
1773 ,x_msg_data OUT NOCOPY VARCHAR2
1774 );
1775
1776 -- --------------------------------------------------------------
1777 -- isCitemVerInPassedStatus
1778 --
1779 -- Used to see if any item version exists for the passed
1780 -- item version status
1781 --
1782 -- --------------------------------------------------------------
1783 FUNCTION isCitemVerInPassedStatus(
1784 p_content_item_id IN NUMBER
1785 ,p_citem_version_status IN VARCHAR2
1786 ) RETURN BOOLEAN;
1787
1788 -- --------------------------------------------------------------
1789 -- isItemLockedByCurrentUser
1790 --
1791 -- Used to see if the item is locked by the current user
1792 --
1793 -- --------------------------------------------------------------
1794 FUNCTION isItemLockedByCurrentUser(p_content_item_id IN NUMBER) RETURN BOOLEAN;
1795
1796 END;