DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_DAILY_RATES

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

431: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
432: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
433: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
434:
435: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
436: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
437: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
438:
439: BEGIN

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

432: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
433: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
434:
435: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
436: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
437: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
438:
439: BEGIN
440: --log for debug

Line 471: FROM GL_DAILY_RATES cur

467: */
468:
469: -- get the covertion rate between different currency codes
470: SELECT cur.conversion_rate INTO P_AGIS_CURR_RATE
471: FROM GL_DAILY_RATES cur
472: WHERE cur.from_currency =P_AGIS_CURR_CODE
473: AND cur.to_currency=l_gl_curr_code
474: AND cur.conversion_type=P_AGIS_CURR_COV_TYPE
475: AND cur.conversion_date=P_GL_DATE;

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

717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
718: l_distl_id NUMBER;
719:
720: -- AGIS: CURRENCY RATE
721: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
722:
723: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;

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

1203: ,l_distl_cash_rel_item
1204: ;
1205: EXIT WHEN c_trx_line%NOTFOUND;
1206:
1207: -- get current currency rate from the gl_ledger and gl_daily_rates tables.
1208: IF l_distl_party_type_flg='I' THEN
1209: -- sender convertion rate
1210: l_get_trx_cov_rate_flg := FALSE;
1211: l_get_trx_cov_rate_flg := AGIS_Get_Curr_Rate_Type(

Line 1327: ,l_trxh_curr_cov_rate -- GL_DAILY_RATES.CONVERSION_RATE

1323: ,l_je_func_curr_code -- function currency of current Ledger to FUNC_CURR_CODE
1324: ,l_tr_func_amount -- lines: acounted_dr-accounted_cr --?? not sure
1325: ,l_trxb_curr_code -- batches: currency code
1326: ,l_current_amount_dr-l_current_amount_cr -- lines: entered_dr-entered_cr --?? not sure
1327: ,l_trxh_curr_cov_rate -- GL_DAILY_RATES.CONVERSION_RATE
1328: ,l_trxb_curr_cov_type -- conversion_type of line's subsidary(s/r)
1329: ,l_trxb_gl_date -- batches: gl_date
1330: ,l_trxh_desc -- header: description
1331: ,l_distl_cash_rel_item -- the attribute* name