1 PACKAGE IBC_UTILITIES_PVT as
2 /* $Header: ibcvutls.pls 120.5 2005/08/08 14:53:18 appldev ship $ */
3
4 -----------------------------------------
5 -- Global Variables
6 -----------------------------------------
7
8 -- Global variables for package type, used in Handle_Exceptions
9 G_PVT CONSTANT CHAR(4) := '_PVT';
10 G_INT CONSTANT CHAR(4) := '_INT';
11 G_PUB CONSTANT CHAR(4) := '_PUB';
12
13 -- Global variables for Content Item XML Attributes
14 G_XML_ID CONSTANT CHAR(2) := 'id';
15 G_XML_VERSION CONSTANT CHAR(7) := 'version';
16 G_XML_IRCODE CONSTANT CHAR(6) := 'ircode';
17 G_XML_REF CONSTANT CHAR(3) := 'ref';
18 G_XML_URL CONSTANT CHAR(3) := 'url';
19 G_XML_AVAIL CONSTANT CHAR(9) := 'available';
20 G_XML_EXPIRE CONSTANT CHAR(10) := 'expiration';
21 G_XML_FILE CONSTANT CHAR(4) := 'file';
22 G_XML_MIME CONSTANT CHAR(8) := 'mimeType';
23 G_XML_DEFAULT_MIME CONSTANT CHAR(15) := 'defaultMimeType';
24 G_XML_REND CONSTANT CHAR(13) := 'renditionName';
25 G_XML_ENC CONSTANT CHAR(7) := 'encrypt';
26
27 -- Global variables for Content Item XML URL parameters
28 G_XML_URL_FID CONSTANT CHAR(6) := 'fileId';
29 G_XML_URL_CID CONSTANT CHAR(7) := 'cItemId';
30 G_XML_URL_CVERID CONSTANT CHAR(10) := 'cItemVerId';
31 G_XML_URL_LB CONSTANT CHAR(5) := 'label';
32 G_XML_URL_ENC CONSTANT CHAR(7) := 'encrypt';
33 G_XML_URL_LANG CONSTANT CHAR(8) := 'language';
34 G_XML_URL_MIME CONSTANT CHAR(8) := 'mimeType';
35
36 -- Global variables for Renditions
37 G_REND_LOOKUP_TYPE CONSTANT CHAR(14) := 'IBC_RENDITIONS';
38 G_REND_UNKNOWN_MIME CONSTANT CHAR(17) := 'UNKNOWN_MIME_TYPE';
39
40 -- Global variable for others exception
41 G_EXC_OTHERS CONSTANT NUMBER := 100;
42
43 -- audit action constants
44 G_ALA_COPY CONSTANT CHAR(6) := 'COPY';
45 G_ALA_CREATE CONSTANT CHAR(6) := 'CREATE';
46 G_ALA_UPDATE CONSTANT CHAR(6) := 'UPDATE';
47 G_ALA_ARCHIVE CONSTANT CHAR(7) := 'ARCHIVE';
48 G_ALA_REMOVE CONSTANT CHAR(6) := 'REMOVE';
49 G_ALA_MOVE CONSTANT CHAR(4) := 'MOVE';
50 G_ALA_REJECT CONSTANT CHAR(6) := 'REJECT';
51 G_ALA_SUBMIT CONSTANT CHAR(6) := 'SUBMIT';
52 G_ALA_UNARCHIVE CONSTANT CHAR(9) := 'UNARCHIVE';
53 G_ALA_APPROVE CONSTANT CHAR(7) := 'APPROVE';
54 G_ALA_STOP CONSTANT CHAR(4) := 'STOP';
55
56 -- audit object constants
57 G_ALO_CONTENT_TYPE CONSTANT CHAR(5) := 'CTYPE';
58 G_ALO_CONTENT_ITEM CONSTANT CHAR(5) := 'CITEM';
59 G_ALO_CITEM_VERSION CONSTANT CHAR(9) := 'CIVERSION';
60 G_ALO_ATTRIBUTE_BUNDLE CONSTANT CHAR(7) := 'ABUNDLE';
61 G_ALO_ASSOCIATION CONSTANT CHAR(5) := 'ASSOC';
62 G_ALO_COMPONENT CONSTANT CHAR(4) := 'COMP';
63 G_ALO_LABEL CONSTANT CHAR(5) := 'LABEL';
64
65
66 /****************************************************
67 -------------FUNCTIONS--------------------------------------------------------------------------
68 ****************************************************/
69 -- --------------------------------------------------------------
70 -- GET ENCODING
71 --
72 -- Used to get the internet character set encoding based on DB
73 -- character set.
74 -- --------------------------------------------------------------
75 FUNCTION getEncoding
76 RETURN VARCHAR2;
77
78
79
80 FUNCTION IBC_DECODE(l_base_date DATE, comp1 DATE,
81 date1 DATE, date2 DATE)
82 RETURN DATE;
83
84
85 -- --------------------------------------------------------------
86 -- get_citem_name
87 --
88 -- Given content_item_id it returns content item name of
89 -- the last version for the current language
90 --
91 -- --------------------------------------------------------------
92 FUNCTION get_citem_name(p_content_item_id IN NUMBER)
93 RETURN VARCHAR2;
94
95 -- --------------------------------------------------------------
96 -- get_directory_name
97 --
98 -- Given directory_node_id it returns directory name
99 -- for the current language
100 --
101 -- --------------------------------------------------------------
102 FUNCTION get_directory_name(p_directory_node_id IN NUMBER)
103 RETURN VARCHAR2 ;
104
105 -- --------------------------------------------------------------
106 -- GET RESOURCE NAME
107 --
108 -- Used to get resource name by id
109 --
110 -- --------------------------------------------------------------
111 FUNCTION getResourceName(
112 f_resource_id IN NUMBER
113 ,f_resource_type IN VARCHAR2
114 )
115 RETURN VARCHAR2;
116
117 -- --------------------------------------------------------------
118 -- GET DIRECTORY ID
119 --
120 -- Get Directory ID given a Directory Path and node type
121 --
122 -- --------------------------------------------------------------
123 FUNCTION get_directory_node_id(p_directory_path IN VARCHAR2,
124 p_node_type IN VARCHAR2)
125 RETURN VARCHAR2;
126
127 -- --------------------------------------------------------------
128 -- GET Content Item Keywords
129 --
130 -- Used to get content item keywords by content_item_id
131 --
132 -- --------------------------------------------------------------
133
134 FUNCTION getCItemKeyWords(
135 pcItemId IN NUMBER
136 )
137 RETURN VARCHAR2;
138
139 /****************************************************
140 -------------PROCEDURES--------------------------------------------------------------------------
141 ****************************************************/
142
143
144
145 --------------------------------------------------------------------------------
146 -- Start of comments
147 -- API name : get_Language_Description
148 -- Type : Private
149 -- Pre-reqs : None
150 -- Description : This procedure takes in the language code and returns the
151 -- corresponding language description
152 -- Parameters :
153 -- p_language_code IN VARCHAR2
154 -- p_language_description OUT NOCOPY VARCHAR2
155 --------------------------------------------------------------------------------
156 PROCEDURE Get_Language_Description (
157 p_language_code IN VARCHAR2
158 ,p_language_description OUT NOCOPY VARCHAR2
159 );
160
161
162
163
164 --------------------------------------------------------------------------------
165 -- Start of comments
166 -- API name : Build_Attribute_Bundle
167 -- Type : Private
168 -- Pre-reqs : None
169 -- Function : Concatenate the user-defined attributes of IBC output xml to the
170 -- incoming CLOB.
171 -- Parameters :
172 -- IN : p_file_id IN NUMBER
173 -- p_xml_clob_loc IN OUT NOCOPY CLOB
174 --------------------------------------------------------------------------------
175 PROCEDURE Build_Attribute_Bundle (
176 p_file_id IN NUMBER,
177 p_xml_clob_loc IN OUT NOCOPY CLOB
178 );
179
180
181
182
183 --------------------------------------------------------------------------------
184 -- Start of comments
185 -- API name : Build_Citem_Open_Tag
186 -- Type : Private
187 -- Pre-reqs : None
188 -- Function : Concatenate the open tags of IBC output xml to the
189 -- incoming CLOB. Information includes: version number,
190 -- reference code. (Not including name, description,
191 -- renditions).
192 -- Parameters :
193 -- IN : p_content_type_code IN VARCHAR2
194 -- p_content_item_id IN NUMBER
195 -- p_version_number IN NUMBER
196 -- DEFAULT 0
197 -- p_item_reference_code IN VARCHAR2
198 -- p_item_label IN VARCHAR2
199 -- DEFAULT NULL
200 -- p_xml_clob_loc IN OUT NOCOPY CLOB
201 --------------------------------------------------------------------------------
202 PROCEDURE Build_Citem_Open_Tag (
203 p_content_type_code IN VARCHAR2,
204 p_content_item_id IN NUMBER,
205 p_version_number IN NUMBER DEFAULT 0,
206 p_item_reference_code IN VARCHAR2,
207 p_item_label IN VARCHAR2 DEFAULT NULL,
208 p_xml_clob_loc IN OUT NOCOPY CLOB
209 );
210
211
212
213
214 --------------------------------------------------------------------------------
215 ---------------------------------- NEW PROC ------------------------------------
216 --------------------------------------------------------------------------------
217 --------------------------------------------------------------------------------
218 -- Start of comments
219 -- API name : Build_Citem_Open_Tags
220 -- Type : Private
221 -- Pre-reqs : None
222 -- Function : Concatenate the open tags of IBC output xml to the
223 -- incoming CLOB.
224 -- Parameters :
225 -- IN : p_content_type_code IN VARCHAR2
226 -- p_content_item_id IN NUMBER
227 -- p_citem_version_id IN NUMBER
228 -- p_item_label IN VARCHAR2
229 -- DEFAULT NULL
230 -- p_lang_code IN VARCHAR2
231 -- DEFAULT NULL
232 -- p_version_number IN NUMBER
233 -- DEFAULT 0
234 -- p_start_date IN DATE
235 -- p_end_date IN DATE
236 -- p_item_reference_code IN VARCHAR2
237 -- p_encrypt_flag IN VARCHAR2
238 -- p_content_item_name IN VARCHAR2
239 -- p_description IN VARCHAR2
240 -- p_attachment_attribute_code IN VARCHAR2
241 -- DEFAULT NULL
242 -- p_attachment_file_id IN NUMBER
243 -- DEFAULT NULL
244 -- p_attachment_file_name IN VARCHAR2
245 -- DEFAULT NULL
246 -- p_default_mime_type IN VARCHAR2
247 -- DEFAULT NULL
248 -- p_is_preview IN VARCHAR2
249 -- DEFAULT FND_API.G_FALSE
250 -- p_xml_clob_loc IN OUT NOCOPY CLOB
251 --------------------------------------------------------------------------------
252 PROCEDURE Build_Citem_Open_Tags (
253 p_content_type_code IN VARCHAR2,
254 p_content_item_id IN NUMBER,
255 p_citem_version_id IN NUMBER,
256 p_item_label IN VARCHAR2 DEFAULT NULL,
257 p_lang_code IN VARCHAR2 DEFAULT NULL,
258 p_version_number IN NUMBER DEFAULT 0,
259 p_start_date IN DATE,
260 p_end_date IN DATE,
261 p_item_reference_code IN VARCHAR2,
262 p_encrypt_flag IN VARCHAR2,
263 p_content_item_name IN VARCHAR2,
264 p_description IN VARCHAR2,
265 p_attachment_attribute_code IN VARCHAR2 DEFAULT NULL,
266 p_attachment_file_id IN NUMBER DEFAULT NULL,
267 p_attachment_file_name IN VARCHAR2 DEFAULT NULL,
268 p_default_mime_type IN VARCHAR2 DEFAULT NULL,
269 p_is_preview IN VARCHAR2 DEFAULT FND_API.G_FALSE,
270 p_xml_clob_loc IN OUT NOCOPY CLOB
271 );
272
273
274 --------------------------------------------------------------------------------
275 -- Start of comments
276 -- API name : Build_Citem_Open_Tags
277 -- Function : This is for BACKWARD COMPATIBILITY for Admin Usage (Similar to above).
278 --------------------------------------------------------------------------------
279 PROCEDURE Build_Citem_Open_Tags (
280 p_content_type_code IN VARCHAR2,
281 p_content_item_id IN NUMBER,
282 p_version_number IN NUMBER DEFAULT 0,
283 p_item_reference_code IN VARCHAR2,
284 p_content_item_name IN VARCHAR2 DEFAULT NULL,
285 p_description IN VARCHAR2 DEFAULT NULL,
286 p_root_tag_only_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,
287 p_xml_clob_loc IN OUT NOCOPY CLOB
288 );
289
290
291
292
293 --------------------------------------------------------------------------------
294 -- Start of comments
295 -- API name : Build_Close_Tag
296 -- Type : Private
297 -- Pre-reqs : None
298 -- Function : Concatenate the closing tags of IBC output xml to the
299 -- incoming CLOB.
300 -- Parameters :
301 -- IN : p_close_tag IN VARCHAR2
302 -- p_xml_clob_loc IN OUT NOCOPY CLOB
303 --------------------------------------------------------------------------------
304 PROCEDURE Build_Close_Tag (
305 p_close_tag IN VARCHAR2,
306 p_xml_clob_loc IN OUT NOCOPY CLOB
307 );
308
309 --------------------------------------------------------------------------------
310 -- Start of comments
314 -- Function : Concatenate open attribute tag for a commpounded
311 -- API name : Build_Compound_Item_Open_Tag
312 -- Type : Private
313 -- Pre-reqs : None
315 -- to the incoming CLOB.
316 -- Parameters :
317 -- IN : p_attribute_type_code IN VARCHAR2
318 -- p_content_item_id IN NUMBER
319 -- p_item_label IN VARCHAR2
320 -- DEFAULT NULL
321 -- p_encrypt_flag IN VARCHAR2
322 -- p_xml_clob_loc IN OUT NOCOPY CLOB
323 --------------------------------------------------------------------------------
324 PROCEDURE Build_Compound_Item_Open_Tag (
325 p_attribute_type_code IN VARCHAR2,
326 p_content_item_id IN NUMBER,
327 p_item_label IN VARCHAR2 DEFAULT NULL,
328 p_encrypt_flag IN VARCHAR2,
329 p_xml_clob_loc IN OUT NOCOPY CLOB
330 );
331
332 --------------------------------------------------------------------------------
333 -- Start of comments
334 -- API name : Build_Preview_Cpnt_Open_Tag
335 -- Type : Private
336 -- Pre-reqs : None
337 -- Function : Concatenate open attribute tag for a component item
338 -- to the incoming CLOB. The Url attribute of the open tag
339 -- refers to the Preview Jsp (IBC_UTILITIES_PUB.G_PCITEM_SERVLET_URL)
340 -- with both content item id and content item version id as parameters.
341 -- Parameters :
342 -- IN : p_attribute_type_code IN VARCHAR2
343 -- p_content_item_id IN NUMBER
344 -- p_content_item_version_id IN NUMBER
345 -- p_encrypt_flag IN VARCHAR2
346 -- p_xml_clob_loc IN OUT NOCOPY CLOB
347 --------------------------------------------------------------------------------
348 PROCEDURE Build_Preview_Cpnt_Open_Tag (
349 p_attribute_type_code IN VARCHAR2,
350 p_content_item_id IN NUMBER,
351 p_content_item_version_id IN NUMBER,
352 p_encrypt_flag IN VARCHAR2,
353 p_xml_clob_loc IN OUT NOCOPY CLOB
354 );
355
356 --------------------------------------------------------------------------------
357 -- Start of comments
358 -- API name : Build_Compound_Item_References
359 -- Type : Private
360 -- Pre-reqs : None
361 -- Function : Concatenate all the compounded item references of
362 -- the content item to the incoming CLOB.
363 -- Parameters :
364 -- IN : p_citem_version_id IN NUMBER
365 -- p_item_label IN VARCHAR2
366 -- DEFAULT NULL
367 -- p_xml_clob_loc IN OUT NOCOPY CLOB
368 --------------------------------------------------------------------------------
369 PROCEDURE Build_Compound_Item_References (
370 p_citem_version_id IN NUMBER,
371 p_item_label IN VARCHAR2 DEFAULT NULL,
372 p_xml_clob_loc IN OUT NOCOPY CLOB
373 );
374
375 --------------------------------------------------------------------------------
376 -- Start of comments
377 -- API name : Build_Preview_Cpnt_References
378 -- Type : Private
379 -- Pre-reqs : None
380 -- Function : Concatenate all the compounded item references of
381 -- the content item to the incoming CLOB. All the Urls of
382 -- the references will refer to the Preview Jsp (IBC_UTILITIES_PUB.G_PCITEM_SERVLET_URL)
383 -- with both content item id and content item version id as parameters.
384 -- Parameters :
385 -- IN : p_citem_version_id IN NUMBER
386 -- p_xml_clob_loc IN OUT NOCOPY CLOB
387 --------------------------------------------------------------------------------
388 PROCEDURE Build_Preview_Cpnt_References (
389 p_citem_version_id IN NUMBER,
390 p_xml_clob_loc IN OUT NOCOPY CLOB
391 );
392
393
394 PROCEDURE Get_Messages (p_message_count IN NUMBER,
395 x_msgs OUT NOCOPY VARCHAR2);
396
397 PROCEDURE Handle_Exceptions(
398 P_API_NAME IN VARCHAR2,
399 P_PKG_NAME IN VARCHAR2,
400 P_EXCEPTION_LEVEL IN NUMBER DEFAULT NULL,
401 P_SQLCODE IN NUMBER DEFAULT NULL,
402 P_SQLERRM IN VARCHAR2 DEFAULT NULL,
403 P_PACKAGE_TYPE IN VARCHAR2,
404 X_MSG_COUNT OUT NOCOPY NUMBER,
405 X_MSG_DATA OUT NOCOPY VARCHAR2,
406 X_RETURN_STATUS OUT NOCOPY VARCHAR2
407 );
408
409 PROCEDURE Handle_Ret_Status(p_return_Status VARCHAR2);
410
411 PROCEDURE insert_attachment(
412 x_file_id OUT NOCOPY NUMBER
413 ,p_file_data IN BLOB
414 ,p_file_name IN VARCHAR2
415 ,p_mime_type IN VARCHAR2
416 ,p_file_format IN VARCHAR2
417 ,p_program_tag IN VARCHAR2 DEFAULT NULL
421 PROCEDURE insert_attribute_bundle(
418 ,x_return_status OUT NOCOPY VARCHAR2
419 );
420
422 x_lob_file_id OUT NOCOPY NUMBER
423 ,p_new_bundle IN CLOB
424 ,x_return_status OUT NOCOPY VARCHAR2
425 );
426
427
428
429 PROCEDURE log_action(
430 p_activity IN VARCHAR2
431 ,p_parent_value IN VARCHAR2
432 ,p_object_type IN VARCHAR2
433 ,p_object_value1 IN VARCHAR2
434 ,p_object_value2 IN VARCHAR2 DEFAULT NULL
435 ,p_object_value3 IN VARCHAR2 DEFAULT NULL
436 ,p_object_value4 IN VARCHAR2 DEFAULT NULL
437 ,p_object_value5 IN VARCHAR2 DEFAULT NULL
438 ,p_description IN VARCHAR2 DEFAULT NULL
439 );
440
441
442
443 PROCEDURE touch_attribute_bundle(
444 x_lob_file_id OUT NOCOPY NUMBER
445 ,p_exp_date IN DATE DEFAULT NULL
446 ,p_program_tag IN VARCHAR2 DEFAULT NULL
447 ,x_return_status OUT NOCOPY VARCHAR2
448 );
449
450
451 --------------------------------------------------------------------------------
452 -- Start of comments
453 -- API name : Post Insert Attach
454 -- Type : Private
455 -- Pre-reqs : None
456 -- Function : Is called from FNDGFU as Call Back pkg. for
457 -- Attachment file type.
458 -- the content item to the incoming CLOB.
459 -- Parameters :
460 -- IN : p_file_id IN NUMBER
461 --------------------------------------------------------------------------------
462 PROCEDURE post_insert_attach(p_file_id IN NUMBER);
463
464 --------------------------------------------------------------------------------
465 -- Start of comments
466 -- API name : Post Insert Attrib
467 -- Type : Private
468 -- Pre-reqs : None
469 -- Function : Is called from FNDGFU as Call Back pkg. for
470 -- Attachment file type.
471 -- the content item to the incoming CLOB.
472 -- Parameters :
473 -- IN : p_file_id IN NUMBER
474 -------------------------------------------------------------------------------
475 PROCEDURE post_insert_attrib(p_file_id IN NUMBER);
476
477
478 -- ----------------------------------------------------
479 -- FUNCTION: Check_Current_User
480 -- DESCRIPTION:
481 -- Given either user_id or (srch) resource id and type
482 -- (mutually exclusive) returns 'TRUE' if it's current user
483 -- (in case p_user_id was passed) or current resource exists
484 -- in a resource id and type (usally a group).
485 -- It's useful to know if a resource is
486 -- included in a resource group.
487 -- ----------------------------------------------------
488 FUNCTION Check_Current_User(
489 p_user_id IN NUMBER
490 ,p_resource_id IN NUMBER
491 ,p_resource_type IN VARCHAR2
492 ,p_current_user_id IN NUMBER DEFAULT NULL
493 ) RETURN VARCHAR2;
494
495 PRAGMA RESTRICT_REFERENCES(Check_Current_User, WNDS, WNPS);
496
497 ---------------------------------------------------------
498 -- FUNCTION: g_true
499 -- DESCRIPTION: Returns FND_API.g_true, it's useful
500 -- to access the value from SQL stmts
501 ---------------------------------------------------------
502 FUNCTION g_true RETURN VARCHAR2;
503 PRAGMA RESTRICT_REFERENCES(g_true, WNDS, WNPS, TRUST);
504
505 ---------------------------------------------------------
506 -- FUNCTION: g_false
507 -- DESCRIPTION: Returns FND_API.g_false, it's useful
508 -- to access the value from SQL stmts
509 ---------------------------------------------------------
510 FUNCTION g_false RETURN VARCHAR2;
511 PRAGMA RESTRICT_REFERENCES(g_false, WNDS, WNPS, TRUST);
512
513 ---------------------------------------------------------
514 -- FUNCTION: Is_Name_Already_Used
515 -- DESCRIPTION: Returns TRUE/FALSE, if the name
516 -- is already used by a different item or
517 -- directory.
518 ---------------------------------------------------------
519 FUNCTION Is_Name_Already_Used(p_dir_node_id IN NUMBER,
520 p_name IN VARCHAR2,
521 p_language IN VARCHAR2,
522 p_chk_content_item_id IN NUMBER DEFAULT NULL,
523 p_chk_dir_node_id IN NUMBER DEFAULT NULL,
524 x_object_type OUT NOCOPY VARCHAR2,
525 x_object_id OUT NOCOPY NUMBER
526 )
527 RETURN BOOLEAN;
528
529 --------------------------------------------------------------------------------
530 -- Start of comments
531 -- API name : Create_Autonomous_renditions
532 -- Type : Private
533 -- Pre-reqs : None
534 -- Function : Called from Content Item Screens/AM to create an autonomous
535 -- Transaction for FND LOBS
536 -------------------------------------------------------------------------------
537 PROCEDURE Create_Autonomous_Upload(p_file_name IN VARCHAR2,
538 p_mime_type IN VARCHAR2,
539 p_file_format IN VARCHAR2,
540 p_program_tag IN VARCHAR2,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_file_id OUT NOCOPY NUMBER
543 );
544
545 --PRAGMA AUTONOMOUS_TRANSACTION;
546
547
548 --------------------------------------------------------------------------------
549 -- Start of comments
550 -- API name : get_object_name
551 -- Type : Private
552 -- Pre-reqs : None
553 -- Function : called from associations package to get name and code for
554 -- product_associations
555 -------------------------------------------------------------------------------
556 PROCEDURE Get_Object_Name(p_assoc_type_code IN VARCHAR2,
557 p_assoc_object_val1 IN VARCHAR2,
558 p_assoc_object_val2 IN VARCHAR2,
559 p_assoc_object_val3 IN VARCHAR2,
560 p_assoc_object_val4 IN VARCHAR2,
561 p_assoc_object_val5 IN VARCHAR2,
562 x_assoc_name OUT NOCOPY VARCHAR2,
563 x_assoc_code OUT NOCOPY VARCHAR2,
564 x_return_status OUT NOCOPY VARCHAR2,
565 x_msg_count OUT NOCOPY NUMBER,
566 x_msg_data OUT NOCOPY VARCHAR2
567 );
568
569
570 --------------------------------------------------------------------------------
571 -- Start of comments
572 -- API name : getAttachclob
573 -- Type : Private
574 -- Pre-reqs : None
575 -- Function : returns the CLOB from FND_LOBS for the attachment files
576 --
577 -------------------------------------------------------------------------------
578 FUNCTION getAttachclob (p_file_id NUMBER) RETURN CLOB;
579
580 --------------------------------------------------------------------------------
581 -- Start of comments
582 -- API name : Replace_Special_Chars
583 -- Type : Private
584 -- Pre-reqs : None
585 -- Function : returns the VARCHAR2
586 --
587 -------------------------------------------------------------------------------
588 FUNCTION Replace_Special_Chars (p_string IN VARCHAR2) RETURN VARCHAR2;
589
590 END Ibc_Utilities_Pvt;