DBA Data[Home] [Help]

PACKAGE: APPS.FF_DBI_UTILS_PKG

Source


1 package ff_dbi_utils_pkg as
2 /* $Header: ffdbiutl.pkh 120.2 2007/03/29 09:57:17 alogue noship $ */
3 ------------------------------ str2dbiname -------------------------------
4 --
5 -- NAME
6 --   str2dbiname
7 --
8 -- DESCRIPTION
9 --   Function for converting a string to database item name format.
10 --
11 --   It is assumed that the string is complete and contains translated
12 --   parts that may not conform to database item name format.
13 --
14 -- NOTES
15 --   This is the HRDYNDBI code for handling the NAME_TRANSLATIONS lookup
16 --   meanings put into a function to avoid having to repeat code.
17 --
18 --   If stripping out of punctuation does not work, the remaining
19 --   database item name will be quoted in double quotes "".
20 --
21 function str2dbiname
22 (p_str in varchar2
23 ) return varchar2;
24 
25 ------------------------- translations_supported -------------------------
26 --
27 -- NAME
28 --   translations_supported
29 --
30 -- DESCRIPTION
31 --   Function that indicates whether or not translated database items
32 --   and the related behaviour changes (e.g. dynamic database generation
33 --   and formula translated) are supported for a particular legislation.
34 --
35 function translations_supported
36 (p_legislation_code in varchar2
37 ) return boolean;
38 
39 --
40 -- Same as above but returns Y or N instaed of a boolean
41 --
42 function translation_supported
43 (p_legislation_code in varchar2
44 ) return varchar2;
45 
46 end ff_dbi_utils_pkg;