6954: BEGIN
6955:
6956: x_ret_stat := 'S';
6957:
6958: l_euro_conversion := okc_currency_api.IS_EURO_CONVERSION_NEEDED
6959: (p_currency_code);
6960:
6961: IF (l_euro_conversion = 'Y') Then
6962: OPEN l_get_conversion_rule(p_dnz_chr_id);
6965: RAISE cvn_not_found;
6966: END IF;
6967: CLOSE l_get_conversion_rule;
6968:
6969: l_euro_currency_code :=okc_currency_api.GET_EURO_CURRENCY_CODE
6970: (p_currency_code);
6971: END IF;
6972:
6973: round_amount := 0;
6974:
6975: IF (l_euro_conversion = 'Y') THEN
6976:
6977: l_cur_holder := l_euro_currency_code;
6978: okc_currency_api.CONVERT_AMOUNT
6979: (P_FROM_CURRENCY => p_currency_code,
6980: P_TO_CURRENCY => l_euro_currency_code,
6981: P_CONVERSION_DATE => l_con_date,
6982: P_CONVERSION_TYPE => l_con_type,
7430: BEGIN
7431: x_return_stat := l_ret_stat;
7432: l_cntr := 0;
7433:
7434: l_euro_conversion := okc_currency_api.IS_EURO_CONVERSION_NEEDED
7435: (p_currency_code);
7436:
7437:
7438: IF (l_euro_conversion = 'Y') THEN
7442: RAISE cvn_not_found;
7443: END IF;
7444: CLOSE l_get_conversion_rule;
7445:
7446: l_euro_currency_code :=okc_currency_api.GET_EURO_CURRENCY_CODE
7447: (p_currency_code);
7448: END IF;
7449:
7450: FOR l_cntr IN 1..p_covered_tbl.count
7457:
7458: IF (l_euro_conversion = 'Y') Then
7459:
7460: l_cur_holder := l_euro_currency_code;
7461: okc_currency_api.CONVERT_AMOUNT
7462: (P_FROM_CURRENCY => p_currency_code,
7463: P_TO_CURRENCY => l_euro_currency_code,
7464: P_CONVERSION_DATE => l_con_date,
7465: P_CONVERSION_TYPE => l_con_type,