APPS.BIL_BI_OPDTL_F_PKG dependencies on BIL_BI_CURRENCY_RATE

Line 1083: from BIL_BI_CURRENCY_RATE

1079: IF (g_refresh_flag = 'Y') THEN
1080: UPDATE /*+ PARALLEL(stg)*/ BIL_BI_OPDTL_STG stg
1081: SET (stg.prim_conversion_rate,stg.CONVERSION_RATE_S)
1082: = (select exchange_rate, exchange_rate_s
1083: from BIL_BI_CURRENCY_RATE
1084: where currency_code = stg.txn_currency
1085: and exchange_date = stg.effective_date)
1086: WHERE ((prim_conversion_rate < 0) OR prim_conversion_rate IS NULL)
1087: OR ((CONVERSION_RATE_S < 0) OR CONVERSION_RATE_S IS NULL);

Line 1092: from BIL_BI_CURRENCY_RATE

1088: ELSE
1089: UPDATE BIL_BI_OPDTL_STG stg
1090: SET (stg.prim_conversion_rate,stg.CONVERSION_RATE_S)
1091: = (select exchange_rate, exchange_rate_s
1092: from BIL_BI_CURRENCY_RATE
1093: where currency_code = stg.txn_currency
1094: and exchange_date = stg.effective_date)
1095: WHERE ((prim_conversion_rate < 0) OR prim_conversion_rate IS NULL )
1096: OR ((CONVERSION_RATE_S < 0) OR CONVERSION_RATE_S IS NULL);

Line 1101: SET stg.prim_conversion_rate =(select exchange_rate from BIL_BI_CURRENCY_RATE

1097: END IF;
1098: ELSE --g_sec_currency is null
1099: IF (g_refresh_flag = 'Y') THEN
1100: UPDATE /*+ PARALLEL(stg)*/ BIL_BI_OPDTL_STG stg
1101: SET stg.prim_conversion_rate =(select exchange_rate from BIL_BI_CURRENCY_RATE
1102: where currency_code = stg.txn_currency
1103: and exchange_date = stg.effective_date)
1104: WHERE ((prim_conversion_rate < 0) OR prim_conversion_rate IS NULL) ;
1105: ELSE

Line 1108: (select exchange_rate from BIL_BI_CURRENCY_RATE

1104: WHERE ((prim_conversion_rate < 0) OR prim_conversion_rate IS NULL) ;
1105: ELSE
1106: UPDATE BIL_BI_OPDTL_STG stg
1107: SET stg.prim_conversion_rate =
1108: (select exchange_rate from BIL_BI_CURRENCY_RATE
1109: where currency_code = stg.txn_currency
1110: and exchange_date = stg.effective_date)
1111: WHERE ((prim_conversion_rate < 0) OR prim_conversion_rate IS NULL);
1112: END IF;

Line 2445: MERGE INTO BIL_BI_CURRENCY_RATE sumry

2441: p_msg => 'Start of Procedure '|| l_proc);
2442: END IF;
2443: IF g_sec_currency is not null THEN
2444: IF (g_refresh_flag = 'Y') THEN
2445: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2446: USING ( SELECT
2447: txn_currency,
2448: effective_date,
2449: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

Line 2477: MERGE INTO BIL_BI_CURRENCY_RATE sumry

2473: rates.effective_date,
2474: rates.rate,
2475: rates.rate_s);
2476: ELSE
2477: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2478: USING ( SELECT
2479: txn_currency,
2480: effective_date,
2481: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

Line 2512: MERGE INTO BIL_BI_CURRENCY_RATE sumry

2508:
2509: END IF;
2510: ELSE --if g_sec_currency is null
2511: IF (g_refresh_flag = 'Y') THEN
2512: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2513: USING ( SELECT
2514: txn_currency,
2515: effective_date,
2516: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

Line 2539: MERGE INTO BIL_BI_CURRENCY_RATE sumry

2535: rates.txn_currency,
2536: rates.effective_date,
2537: rates.rate);
2538: ELSE
2539: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2540: USING ( SELECT
2541: txn_currency,
2542: effective_date,
2543: decode(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

Line 2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');

2567: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2568: bil_bi_util_collection_pkg.writeLog(
2569: p_log_level => fnd_log.LEVEL_EVENT,
2570: p_module => g_pkg || l_proc ,
2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');
2572: END IF;
2573: commit;
2574: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2575: bil_bi_util_collection_pkg.writeLog(