DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on GL_CURRENCY_API

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

5710:
5711: if (l_rcv_curr <> l_snd_curr) then
5712: l_stmt_num := 60;
5713:
5714: /* --- replacing gl table hit by gl currency api
5715:
5716: select conversion_rate, conversion_date
5717: into l_conv_rate, l_conv_date
5718: from gl_daily_conversion_rates

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

5727: and conversion_type = l_curr_type
5728: and conversion_date <= l_txn_date);
5729: -------------------------------------------------------------*/
5730:
5731: l_conv_rate := gl_currency_api.get_rate(l_rcv_sob_id,l_snd_curr,l_txn_date,
5732: l_curr_type);
5733: else
5734: l_conv_rate := 1;
5735: end if;

Line 5750: when gl_currency_api.NO_RATE then

5746: fnd_file.put_line(fnd_file.log, 'Get_Snd_Rcv_Rate >>>');
5747: END IF; */
5748: EXCEPTION
5749:
5750: when gl_currency_api.NO_RATE then
5751: rollback;
5752: O_err_num := 9999;
5753: O_err_code := 'CST_NO_GL_RATE';
5754: FND_MESSAGE.set_name('BOM', 'CST_NO_GL_RATE');

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

8336: IF g_debug = 'Y' THEN
8337: fnd_file.put_line(fnd_file.log, 'Currency Conversion Type: '|| l_conversion_type);
8338: END IF;
8339:
8340: l_conversion_rate := GL_Currency_Api.Get_Rate(l_set_of_books_id,
8341: l_sending_curr,
8342: l_txn_date,
8343: l_conversion_type);
8344: