1 PACKAGE FA_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: FAXUTILS.pls 120.4 2009/04/15 15:18:34 bridgway ship $ */
3
4 TYPE faxcurr_type IS RECORD(
5 set_of_books_id number,
6 currency_code varchar2(15),
7 precision number);
8
9 TYPE faxcurr_tab IS TABLE OF faxcurr_type
10 index by binary_integer;
11
12 TYPE faxlookups_tab IS TABLE OF VARCHAR2(80)
13 INDEX BY BINARY_INTEGER;
14
15 -- variables for cache
16 --
17 faxcurr_record faxcurr_type;
18 faxcurr_table faxcurr_tab;
19
20 faxlkpmg_table faxlookups_tab;
21 faxlkpcd_table faxlookups_tab;
22
23 /******************************************************************************
24 *
25 * Name : faxrnd
26 *
27 * Description: Round function to round off amount based on the precision
28 * of currency and book
29 *
30 * Parameters: X_amount - amount to be rounded off.
31 * X_book - book_type_code to get associated currency and
32 * precision
33 *
34 * Returns: True if successful, False otherwise
35 *
36 * *****************************************************************************/
37
38 FUNCTION faxrnd(X_amount IN OUT NOCOPY NUMBER,
39 X_book IN VARCHAR2,
40 X_set_of_books_id IN NUMBER,
41 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
42
43 RETURN BOOLEAN;
44
45
46 /*****************************************************************************
47 *
48 * Name : faxtru
49 *
50 * Description: Truncate function to truncate X_in_num based on the
51 * precision of currency and book
52 *
53 * Parameters: X_in_num - amount to be truncated
54 * X_book_type_code - book_type_code to get associated
55 * currency and precision
56 * X_out_num - truncated value (OUT)
57 *
58 * Returns: True if successful, False otherwise
59 *
60 ******************************************************************************/
61 FUNCTION faxtru (X_num IN OUT NOCOPY number,
62 X_book_type_code IN VARCHAR2,
63 X_set_of_books_id IN NUMBER,
64 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
65 RETURN BOOLEAN;
66
67
68 /******************************************************************************
69 *
70 * Name : faxceil
71 *
72 * Description: Round function to round up amount based on the precision
73 * of currency and book
74 *
75 * Parameters: X_amount - amount to be rounded up.
76 * X_book - book_type_code to get associated currency and
77 * precision
78 *
79 * Returns: True if successful, False otherwise
80 *
81 * *****************************************************************************/
82
83 FUNCTION faxceil(X_amount IN OUT NOCOPY NUMBER,
84 X_book IN VARCHAR2,
85 X_set_of_books_id IN NUMBER,
86 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
87
88 RETURN BOOLEAN;
89
90
91 /******************************************************************************
92 *
93 * Name : faxfloor
94 *
95 * Description: Round function to round off amount based on the precision
96 * of currency and book
97 *
98 * Parameters: X_amount - amount to be rounded off.
99 * X_book - book_type_code to get associated currency and
100 * precision
101 *
102 * Returns: True if successful, False otherwise
103 *
104 * *****************************************************************************/
105
106 FUNCTION faxfloor(X_amount IN OUT NOCOPY NUMBER,
107 X_book IN VARCHAR2,
108 X_set_of_books_id IN NUMBER,
109 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
110
111 RETURN BOOLEAN;
112
113 /******************************************************************************
114 *
115 * Name : faxlkp_meaning
116 *
117 * Description: Gets the meaning for given lookup_type and lookup_code
118 *
119 * Parameters: X_lookup_type - Lookup_type to get associated meaning.
120 * X_lookup_code - Lookup_code to get associated meaning.
121 *
122 * Returns: The Meaning for the given Lookup_type and Lookup_code
123 *
124 * *****************************************************************************/
125
126 FUNCTION faxlkp_meaning(X_lookup_type IN VARCHAR2,
127 X_lookup_code IN VARCHAR2,
128 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
129
130 RETURN VARCHAR2;
131
132 /******************************************************************************
133 *
134 * Name : faxlkp_code
135 *
136 * Description: Gets the lookup_code for given Lookup_type and meaning
137 *
138 *
139 * Parameters: X_lookup_type - Lookup_type to get associated Lookup_code.
140 * X_meaning - Meaning to get associated Lookup_code.
141 *
142 * Returns: The Lookup_code for the give Lookup_type and Meaning.
143 *
144 * *****************************************************************************/
145
146 FUNCTION faxlkp_code(X_lookup_type IN VARCHAR2,
147 X_meaning IN VARCHAR2,
148 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
149
150 RETURN VARCHAR2;
151
152 END FA_UTILS_PKG;
[Home] [Help]