APPS.FII_AP_INV_B_C dependencies on FII_AP_INV_RATES_TEMP

Line 201: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');

197:
198: -- haritha
199: IF (g_truncate_rates = 'Y') THEN
200: if g_debug_flag = 'Y' then
201: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');
202: end if;
203: truncate_table('FII_AP_INV_RATES_TEMP');
204: END IF;
205:

Line 203: truncate_table('FII_AP_INV_RATES_TEMP');

199: IF (g_truncate_rates = 'Y') THEN
200: if g_debug_flag = 'Y' then
201: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');
202: end if;
203: truncate_table('FII_AP_INV_RATES_TEMP');
204: END IF;
205:
206:
207:

Line 806: FROM FII_AP_INV_RATES_TEMP rates

802:
803: CURSOR prim_MissingRate_L IS
804: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(prim_conversion_rate,-3,
805: to_date('01/01/1999','MM/DD/RRRR'), LEAST(TRX_DATE, sysdate)) actg_dt
806: FROM FII_AP_INV_RATES_TEMP rates
807: WHERE rates.prim_conversion_rate < 0 ;
808:
809: CURSOR sec_MissingRate_L IS
810: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(sec_conversion_rate,-3,

Line 812: FROM FII_AP_INV_RATES_TEMP rates

808:
809: CURSOR sec_MissingRate_L IS
810: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(sec_conversion_rate,-3,
811: to_date('01/01/1999','MM/DD/RRRR'), LEAST(TRX_DATE, sysdate)) actg_dt
812: FROM FII_AP_INV_RATES_TEMP rates
813: WHERE rates.sec_conversion_rate < 0 ;
814:
815: BEGIN
816: g_state := 'Checking to see which additional rates need to be defined, if any';

Line 821: SELECT 1 INTO l_miss_rates_prim FROM FII_AP_INV_RATES_TEMP rates WHERE rates.prim_conversion_rate < 0;

817:
818: IF p_program_type = 'L' THEN
819:
820: BEGIN
821: SELECT 1 INTO l_miss_rates_prim FROM FII_AP_INV_RATES_TEMP rates WHERE rates.prim_conversion_rate < 0;
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
824: END;
825:

Line 827: SELECT 1 INTO l_miss_rates_sec FROM FII_AP_INV_RATES_TEMP rates WHERE rates.sec_conversion_rate < 0;

823: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
824: END;
825:
826: BEGIN
827: SELECT 1 INTO l_miss_rates_sec FROM FII_AP_INV_RATES_TEMP rates WHERE rates.sec_conversion_rate < 0;
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN l_miss_rates_sec := 0;
830: END;
831:

Line 1590: insert into fii_ap_inv_rates_temp

1586: fii_util.put_line('');
1587: end if;
1588:
1589: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
1590: insert into fii_ap_inv_rates_temp
1591: (FUNCTIONAL_CURRENCY,
1592: TRX_DATE,
1593: PRIM_CONVERSION_RATE,
1594: SEC_CONVERSION_RATE)

Line 1753: FROM FII_AP_INV_STG stg, fii_ap_inv_rates_temp rates

1749: STG.GL_SL_Link_Table,
1750: STG.Inventory_Item_ID,
1751: STG.Purchasing_Category_ID,
1752: STG.Item_Description
1753: FROM FII_AP_INV_STG stg, fii_ap_inv_rates_temp rates
1754: where stg.account_date = rates.trx_date
1755: and stg.inv_currency_code = rates.functional_currency;
1756:
1757: if g_debug_flag = 'Y' then