1238: p_to_currency,
1239: trunc(p_exchange_rate_date),
1240: NULL);
1241: ELSE
1242: RAISE gl_euro_user_rate_api.INVALID_RELATION;
1243: END IF;
1244: l_cross_rate :=
1245: gl_euro_user_rate_api.get_cross_rate(p_from_currency,
1246: p_to_currency,
1241: ELSE
1242: RAISE gl_euro_user_rate_api.INVALID_RELATION;
1243: END IF;
1244: l_cross_rate :=
1245: gl_euro_user_rate_api.get_cross_rate(p_from_currency,
1246: p_to_currency,
1247: p_exchange_rate_date,
1248: p_exchange_rate,
1249: l_euro_to_emu_rate);
1249: l_euro_to_emu_rate);
1250: return(l_cross_rate);
1251: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() -' );
1252: EXCEPTION
1253: WHEN gl_euro_user_rate_api.INVALID_RELATION THEN
1254: null;
1255: WHEN gl_euro_user_rate_api.INVALID_CURRENCY THEN
1256: null;
1257: WHEN others THEN
1251: arp_util.debug('ar_deposit_lib_pvt.Get_cross_rate() -' );
1252: EXCEPTION
1253: WHEN gl_euro_user_rate_api.INVALID_RELATION THEN
1254: null;
1255: WHEN gl_euro_user_rate_api.INVALID_CURRENCY THEN
1256: null;
1257: WHEN others THEN
1258: raise;
1259: END Get_cross_rate;
1325: -- they are not allowed to enter EMU -> OTHER and
1326: -- OTHER -> EMU rates directly
1327: -- Returns 'N' Otherwise
1328:
1329: IF (gl_euro_user_rate_api.is_cross_rate(p_currency_code,
1330: arp_global.functional_currency,
1331: p_exchange_rate_date,
1332: p_exchange_rate_type) = 'Y')
1333: THEN
1331: p_exchange_rate_date,
1332: p_exchange_rate_type) = 'Y')
1333: THEN
1334:
1335: gl_euro_user_rate_api.get_prompts_and_rate(
1336: p_currency_code,
1337: arp_global.functional_currency,
1338: p_exchange_rate_date,
1339: l_euro_to_other_prompt,
1341: l_emu_to_other_prompt,
1342: l_euro_to_emu_rate);
1343:
1344: l_cross_rate :=
1345: gl_euro_user_rate_api.get_cross_rate(
1346: p_currency_code,
1347: p_currency_code,
1348: p_exchange_rate_date,
1349: p_exchange_rate,
1350: l_euro_to_emu_rate);
1351:
1352: p_exchange_rate := l_cross_rate;
1353: ELSE
1354: -- case where gl_euro_user_rate_api.is_cross_rate = 'N'
1355: -- here the exchange_rate is directly between the EMU and the non-EMU currency.
1356:
1357: p_exchange_rate := round(p_exchange_rate,38);
1358: