DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on GL_CURRENCY_API

Line 5907: /* --- replacing gl table hit by gl currency api

5903:
5904: if (l_rcv_curr <> l_snd_curr) then
5905: l_stmt_num := 60;
5906:
5907: /* --- replacing gl table hit by gl currency api
5908:
5909: select conversion_rate, conversion_date
5910: into l_conv_rate, l_conv_date
5911: from gl_daily_conversion_rates

Line 5924: l_conv_rate := gl_currency_api.get_rate(l_rcv_sob_id,l_snd_curr,l_txn_date,

5920: and conversion_type = l_curr_type
5921: and conversion_date <= l_txn_date);
5922: -------------------------------------------------------------*/
5923:
5924: l_conv_rate := gl_currency_api.get_rate(l_rcv_sob_id,l_snd_curr,l_txn_date,
5925: l_curr_type);
5926: else
5927: l_conv_rate := 1;
5928: end if;

Line 5943: when gl_currency_api.NO_RATE then

5939: fnd_file.put_line(fnd_file.log, 'Get_Snd_Rcv_Rate >>>');
5940: END IF; */
5941: EXCEPTION
5942:
5943: when gl_currency_api.NO_RATE then
5944: rollback;
5945: O_err_num := 9999;
5946: O_err_code := 'CST_NO_GL_RATE';
5947: FND_MESSAGE.set_name('BOM', 'CST_NO_GL_RATE');

Line 8537: l_conversion_rate := GL_Currency_Api.Get_Rate(l_set_of_books_id,

8533: IF g_debug = 'Y' THEN
8534: fnd_file.put_line(fnd_file.log, 'Currency Conversion Type: '|| l_conversion_type);
8535: END IF;
8536:
8537: l_conversion_rate := GL_Currency_Api.Get_Rate(l_set_of_books_id,
8538: l_sending_curr,
8539: l_txn_date,
8540: l_conversion_type);
8541: