1 PACKAGE hr_number AUTHID CURRENT_USER AS
2 /* $Header: hrutlnmw.pkh 115.0 99/07/17 18:20:18 porting ship $ */
3
4 -- ------------------------------------------------------------------------
5 -- number_to_canonical
6 -- convert number to US format number string
7 -- ------------------------------------------------------------------------
8 FUNCTION number_to_canonical
9 (p_number in number)
10 RETURN varchar2;
11
12 -- ------------------------------------------------------------------------
13 -- canonical_to_number
14 -- convert canonical number to Oracle number
15 -- ------------------------------------------------------------------------
16 FUNCTION canonical_to_number
17 (p_canonical in varchar2)
18 RETURN number;
19
20 -- ------------------------------------------------------------------------
21 -- charnumber_to_number
22 -- convert character number in display format to Oracle number
23 -- ------------------------------------------------------------------------
24 FUNCTION charnumber_to_number
25 (p_charnumber in varchar2)
26 RETURN number;
27
28 -- ------------------------------------------------------------------------
29 -- charnumber_to_canonical
30 -- convert character number in display format to canonical number string
31 -- ------------------------------------------------------------------------
32 FUNCTION charnumber_to_canonical
33 (p_charnumber in varchar2)
34 RETURN varchar2;
35
36 -- ------------------------------------------------------------------------
37 -- canonical_to_charnumber
38 -- convert canonical number string to character number string
39 -- ------------------------------------------------------------------------
40 FUNCTION canonical_to_charnumber
41 (p_canonical in varchar2)
42 RETURN varchar2;
43
44 -- ------------------------------------------------------------------------
45 -- canonical_to_charcurrency
46 -- convert canonical number string to character currency string
47 -- ------------------------------------------------------------------------
48 FUNCTION canonical_to_charcurrency
49 (p_canonical in varchar2)
50 RETURN varchar2;
51
52 -- ------------------------------------------------------------------------
53 -- charcurrency_to_canonical
54 -- convert character currency in display format to canonical number string
55 -- ------------------------------------------------------------------------
56 FUNCTION charcurrency_to_canonical
57 (p_charcurrency in varchar2)
58 RETURN varchar2;
59
60 END hr_number;