1 PACKAGE BODY QP_MGD_EURO_UTILS AS
2 /* $Header: QPXUEURB.pls 120.0 2005/06/02 00:14:55 appldev noship $ */
3 ---+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| ONTUEURB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Utility Package Body |
13 --| |
14 --| HISTORY |
15 --| 01-May-2000 Created |
16 --| 01-sep-2000 Updated |
17 --| 03-APR-2002 tsimmond removed code |
18 --+======================================================================
19
20 --===================
21 -- CONSTANTS
22 --===================
23 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_MGD_EURO_UTILS';
24
25 --========================================================================
26 -- FUNCTION : EURO_Conversion_Api PUBLIC
27 -- PARAMETERS: p_from_currency
28 --- p_to_currency
29 --- p_conversion_type
30 --- p_conversion_date
31 --- p_amount
32 --
33 -- COMMENT : This procedure is used for the EURO conversion of amounts
34 -- The GL_API is invoked for the purpose
35 --
36 --========================================================================
37 FUNCTION EURO_Conversion_api
38 ( p_from_currency IN VARCHAR2
39 , p_to_currency IN VARCHAR2
40 , p_conversion_type IN VARCHAR2
41 , p_conversion_date IN DATE
42 , p_amount IN NUMBER := NULL
43 ) RETURN NUMBER
44 IS
45 BEGIN
46
47 RETURN(0);
48
49 ---code is removed, since Euro Customer Conversion program
50 ---is decomissioned
51
52 END EURO_Conversion_api;
53
54
55 --========================================================================
56 -- FUNCTION : EURO_Conversion_api_canonical PUBLIC
57 -- PARAMETERS: p_from_currency
58 --- p_to_currency
59 --- p_conversion_type
60 --- p_conversion_date
61 --- p_amount
62 --
63 -- COMMENT : This procedure is used for the EURO conversion of amounts
64 -- stored as VARCHAR2 Attribute values
65 --
66 --========================================================================
67 FUNCTION EURO_Conversion_api_canonical
68 ( p_from_currency IN VARCHAR2
69 , p_to_currency IN VARCHAR2
70 , p_conversion_type IN VARCHAR2
71 , p_conversion_date IN DATE
72 , p_amount IN VARCHAR2 := NULL
73 ) RETURN VARCHAR2
74 IS
75 BEGIN
76
77 RETURN(' ');
78
79 ---code is removed, since Euro Customer Conversion program
80 ---is decomissioned
81
82 END EURO_Conversion_api_canonical;
83
84
85 --========================================================================
86 -- FUNCTION : Encumbrance_Check PUBLIC
87 -- PARAMETERS: p_org_id
88 --
89 -- COMMENTS: This function is checking if Encumbrance Flag is ON.
90 -- It returns Y, if Encumbrance is ON and N if it's OFF
91 --
92 --========================================================================
93 FUNCTION Encumbrance_check
94 ( p_org_id IN NUMBER
95 )
96 RETURN VARCHAR2
97 IS
98 BEGIN
99
100 RETURN(' ');
101
102 ---code is removed, since Euro Customer Conversion program
103 ---is decomissioned
104
105 END Encumbrance_check;
106
107
108 --========================================================================
109 -- PROCEDURE : Print_Error_Messages PUBLIC
110 -- PARAMETERS:
111 --
112 -- COMMENT : Returns the messages in OE Stack
113 --
114 --=======================================================================
115 PROCEDURE Print_Error_Messages
116 ( p_application_short_name IN VARCHAR2
117 , p_msg_count IN NUMBER
118 )
119 IS
120 BEGIN
121
122 NULL;
123
124 ---code is removed, since Euro Customer Conversion program
125 ---is decomissioned
126
127 END Print_Error_Messages;
128
129
130
131 --========================================================================
132 -- PROCEDURE : GET_Euro_Formula_ID PUBLIC
133
134 -- COMMENT : Returns the corresponding Euro Formula ID from the
135 -- mirror table.
136 --
137 --=======================================================================
138 FUNCTION GET_Euro_Formula_ID
139 ( p_price_formula_id IN NUMBER )
140 RETURN NUMBER
141 IS
142 BEGIN
143
144 RETURN(0);
145
146 ---code is removed, since Euro Customer Conversion program
147 ---is decomissioned
148
149 END GET_Euro_Formula_ID;
150
151
152 --========================================================================
153 -- PROCEDURE : get_euro_list_header_id PUBLIC
154
155 -- COMMENT : Returns the corresponding Euro List header ID
156 -- from the mirror table
157 --
158 --=======================================================================
159 FUNCTION get_euro_list_header_id
160 ( p_list_header_id IN NUMBER )
161 RETURN NUMBER
162 IS
163 BEGIN
164
165 RETURN(0);
166
167 ---code is removed, since Euro Customer Conversion program
168 ---is decomissioned
169
170 END get_euro_list_header_id;
171
172
173 --========================================================================
174 -- PROCEDURE : get_name PUBLIC
175
176 -- COMMENT : Returns the name basd on the source language
177 --
178 --=======================================================================
179 FUNCTION get_name
180 ( p_list_header_id IN NUMBER
181 , p_price_formula_id IN NUMBER
182 , p_language IN VARCHAR2 )
183 RETURN VARCHAR2
184 IS
185 BEGIN
186
187 RETURN(' ');
188
189 ---code is removed, since Euro Customer Conversion program
190 ---is decomissioned
191
192 END get_name;
193
194
195 --========================================================================
196 -- PROCEDURE : get_euro_list_line_id PUBLIC
197
198 -- COMMENT : Returns the corresponding Euro List Line ID
199 -- from the mirror table
200 --
201 --=======================================================================
202 FUNCTION get_euro_list_line_id
203 (p_list_line_id IN NUMBER )
204 RETURN NUMBER
205 IS
206 BEGIN
207
208 RETURN(0);
209
210 ---code is removed, since Euro Customer Conversion program
211 ---is decomissioned
212
213 END get_euro_list_line_id;
214
215
216 END QP_MGD_EURO_UTILS;