162:
163: RETURN : Rate The conversion rate between
164: the two currencies
165:
166: NOTES : We need this cover on top of gl_currency_api.get_rate
167: so that we can handle the gl_currency_api.no_rate and
168: no_data_found exception properly
169:
170: =========================================================================== */
163: RETURN : Rate The conversion rate between
164: the two currencies
165:
166: NOTES : We need this cover on top of gl_currency_api.get_rate
167: so that we can handle the gl_currency_api.no_rate and
168: no_data_found exception properly
169:
170: =========================================================================== */
171: FUNCTION get_conversion_rate (
180: x_progress VARCHAR2(3) := '000';
181:
182: BEGIN
183:
184: x_conversion_rate := gl_currency_api.get_rate (
185: x_set_of_books_id,
186: x_from_currency ,
187: x_conversion_date,
188: x_conversion_type);
192:
193: return (x_conversion_rate);
194:
195: EXCEPTION
196: WHEN gl_currency_api.no_rate THEN
197: return(NULL);
198: WHEN no_data_found THEN
199: return(NULL);
200: WHEN OTHERS THEN