1213: l_converted_amount NUMBER;
1214:
1215: -- Since we do not use the amount or converted amount in TRX_Quotes table
1216: -- set a hardcoded value for the amount (and pass to to
1217: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
1218: -- conversion values )
1219: l_hard_coded_amount NUMBER := 100;
1220:
1221: -- RMUNJULU 03-APR-03 2880556
3203: -- currency conversion columns
3204: IF db_functional_currency_code <> db_contract_currency_code THEN
3205:
3206: IF (is_debug_statement_on) THEN
3207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
3208: END IF;
3209: -- Get the currency conversion details from ACCOUNTING_Util
3210: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
3211: p_khr_id => l_contract_id,
3206: IF (is_debug_statement_on) THEN
3207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
3208: END IF;
3209: -- Get the currency conversion details from ACCOUNTING_Util
3210: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
3211: p_khr_id => l_contract_id,
3212: p_to_currency => db_functional_currency_code,
3213: p_transaction_date => db_sysdate,
3214: p_amount => l_hard_coded_amount,
3218: x_currency_conversion_rate => l_currency_conversion_rate,
3219: x_currency_conversion_date => l_currency_conversion_date,
3220: x_converted_amount => l_converted_amount);
3221: IF (is_debug_statement_on) THEN
3222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_ACCOUNTING_UTIL.convert_to_functional_currency , return status: ' || l_return_status);
3223: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'db_contract_currency_code: ' || db_contract_currency_code);
3224: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_type: ' || l_currency_conversion_type);
3225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_rate: ' || l_currency_conversion_rate);
3226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_date: ' || l_currency_conversion_date);
5051: l_khr_id NUMBER;
5052:
5053: -- Since we do not use the amount or converted amount in TRX_Quotes table
5054: -- set a hardcoded value for the amount (and pass to to
5055: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
5056: -- conversion values )
5057: l_hard_coded_amount NUMBER := 100;
5058: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_line_currency_defaults';
5059: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
5115: CLOSE get_khr_id_csr;
5116:
5117:
5118: IF (is_debug_statement_on) THEN
5119: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
5120: END IF;
5121: -- Get the contract currency details from ACCOUNTING_Util
5122: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
5123: p_khr_id => l_khr_id,
5118: IF (is_debug_statement_on) THEN
5119: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
5120: END IF;
5121: -- Get the contract currency details from ACCOUNTING_Util
5122: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
5123: p_khr_id => l_khr_id,
5124: p_to_currency => l_functional_currency_code,
5125: p_transaction_date => p_sys_date,
5126: p_amount => l_hard_coded_amount,
5130: x_currency_conversion_rate => l_currency_conversion_rate,
5131: x_currency_conversion_date => l_currency_conversion_date,
5132: x_converted_amount => l_converted_amount);
5133: IF (is_debug_statement_on) THEN
5134: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_ACCOUNTING_UTIL.convert_to_functional_currency , return status: ' || l_return_status);
5135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_contract_currency_code: ' || l_contract_currency_code);
5136: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_type: ' || l_currency_conversion_type);
5137: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_rate: ' || l_currency_conversion_rate);
5138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_currency_conversion_date: ' || l_currency_conversion_date);