283: IF (l_trx_func_rate IS NULL) THEN
284: -- Transactional to functional rate does not exist in the contract
285: -- Get the transactional rate using the date and conversion type if they are in
286: -- the contract, otherwise use the default values
287: -- added new FII_CURRENCY pkg fix for trx - > functional euro issues
288: l_trx_func_rate := fii_currency.get_rate(p_curr_code,p_func_curr_code,l_conv_date,l_conv_type);
289:
290: IF (l_trx_func_rate IS NULL OR l_trx_func_rate < 0) THEN
291: -- No rate exists in the contract or no rate exists for the given
284: -- Transactional to functional rate does not exist in the contract
285: -- Get the transactional rate using the date and conversion type if they are in
286: -- the contract, otherwise use the default values
287: -- added new FII_CURRENCY pkg fix for trx - > functional euro issues
288: l_trx_func_rate := fii_currency.get_rate(p_curr_code,p_func_curr_code,l_conv_date,l_conv_type);
289:
290: IF (l_trx_func_rate IS NULL OR l_trx_func_rate < 0) THEN
291: -- No rate exists in the contract or no rate exists for the given
292: -- conversion date and type
318: -- Get the functional to global conversion rate
319: --Find the rates only when the functional and global currencies are different
320: --If condition added by Arun
321: IF(NOT l_isFuncGlobalEqual_flag) THEN
322: l_func_global_rate := fii_currency.get_global_rate_primary(
323: p_func_curr_code
324: , l_conv_date) ;
325: END IF;
326:
334: --Get the functional to secondary global conversion rate
335: --Find the rates only when the functional and global currencies are different
336: --If condition added by Arun
337: IF(NOT l_isFuncSGlobalEqual_flag) THEN
338: l_func_sglobal_rate := fii_currency.get_global_rate_secondary(
339: p_func_curr_code
340: , l_conv_date) ;
341: END IF;
342: