APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_DAILY_RATES

Line 447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;

443: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
444: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
445: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
446:
447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
448: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
449: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
450:
451: BEGIN

Line 448: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;

444: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
445: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
446:
447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
448: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
449: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
450:
451: BEGIN
452: --log for debug

Line 483: FROM GL_DAILY_RATES cur

479: */
480:
481: -- get the covertion rate between different currency codes
482: SELECT cur.conversion_rate INTO P_AGIS_CURR_RATE
483: FROM GL_DAILY_RATES cur
484: WHERE cur.from_currency =P_AGIS_CURR_CODE
485: AND cur.to_currency=l_gl_curr_code
486: AND cur.conversion_type=P_AGIS_CURR_COV_TYPE
487: AND cur.conversion_date=P_GL_DATE;

Line 739: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;

735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
736: l_distl_id NUMBER;
737:
738: -- AGIS: CURRENCY RATE
739: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
740:
741: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;

Line 1236: -- get current currency rate from the gl_ledger and gl_daily_rates tables.

1232: ,l_distl_cash_rel_item
1233: ;
1234: EXIT WHEN c_trx_line%NOTFOUND;
1235:
1236: -- get current currency rate from the gl_ledger and gl_daily_rates tables.
1237: IF l_distl_party_type_flg='I' THEN
1238: -- sender convertion rate
1239: l_get_trx_cov_rate_flg := FALSE;
1240: l_get_trx_cov_rate_flg := AGIS_Get_Curr_Rate_Type(

Line 1377: ,l_trxh_curr_cov_rate -- GL_DAILY_RATES.CONVERSION_RATE

1373: ,l_je_func_curr_code -- function currency of current Ledger to FUNC_CURR_CODE
1374: ,l_tr_func_amount -- lines: acounted_dr-accounted_cr --?? not sure
1375: ,l_trxb_curr_code -- batches: currency code
1376: ,l_current_amount_dr-l_current_amount_cr -- lines: entered_dr-entered_cr --?? not sure
1377: ,l_trxh_curr_cov_rate -- GL_DAILY_RATES.CONVERSION_RATE
1378: ,l_trxb_curr_cov_type -- conversion_type of line's subsidary(s/r)
1379: ,l_trxb_gl_date -- batches: gl_date
1380: ,l_trxh_desc -- header: description
1381: ,l_distl_cash_rel_item -- the attribute* name