APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_AP_INV_RATES_TEMP

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

147:
148: -- haritha
149: IF (g_truncate_rates = 'Y') THEN
150: if g_debug_flag = 'Y' then
151: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');
152: end if;
153: truncate_table('FII_AP_INV_RATES_TEMP');
154: END IF;
155:

Line 153: truncate_table('FII_AP_INV_RATES_TEMP');

149: IF (g_truncate_rates = 'Y') THEN
150: if g_debug_flag = 'Y' then
151: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');
152: end if;
153: truncate_table('FII_AP_INV_RATES_TEMP');
154: END IF;
155:
156:
157:

Line 555: FROM FII_AP_INV_RATES_TEMP rates

551:
552: CURSOR prim_MissingRate_L IS
553: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(prim_conversion_rate,-3,
554: to_date('01/01/1999','MM/DD/RRRR'), LEAST(TRX_DATE, sysdate)) actg_dt
555: FROM FII_AP_INV_RATES_TEMP rates
556: WHERE rates.prim_conversion_rate < 0 ;
557:
558: CURSOR sec_MissingRate_L IS
559: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(sec_conversion_rate,-3,

Line 561: FROM FII_AP_INV_RATES_TEMP rates

557:
558: CURSOR sec_MissingRate_L IS
559: SELECT DISTINCT FUNCTIONAL_CURRENCY from_currency, decode(sec_conversion_rate,-3,
560: to_date('01/01/1999','MM/DD/RRRR'), LEAST(TRX_DATE, sysdate)) actg_dt
561: FROM FII_AP_INV_RATES_TEMP rates
562: WHERE rates.sec_conversion_rate < 0 ;
563:
564: BEGIN
565: g_state := 'Checking to see which additional rates need to be defined, if any';

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

566:
567: IF p_program_type = 'L' THEN
568:
569: BEGIN
570: SELECT 1 INTO l_miss_rates_prim FROM FII_AP_INV_RATES_TEMP rates WHERE rates.prim_conversion_rate < 0;
571: EXCEPTION
572: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
573: END;
574:

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

572: WHEN NO_DATA_FOUND THEN l_miss_rates_prim := 0;
573: END;
574:
575: BEGIN
576: SELECT 1 INTO l_miss_rates_sec FROM FII_AP_INV_RATES_TEMP rates WHERE rates.sec_conversion_rate < 0;
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN l_miss_rates_sec := 0;
579: END;
580:

Line 1262: insert into fii_ap_inv_rates_temp

1258: fii_util.put_line('');
1259: end if;
1260:
1261: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
1262: insert into fii_ap_inv_rates_temp
1263: (FUNCTIONAL_CURRENCY,
1264: TRX_DATE,
1265: PRIM_CONVERSION_RATE,
1266: SEC_CONVERSION_RATE)

Line 1371: FROM FII_AP_INV_DIST_T stg, fii_ap_inv_rates_temp rates

1367: stg.LINE_TYPE_LOOKUP_CODE,
1368: stg.Inventory_Item_ID,
1369: stg.Purchasing_Category_ID,
1370: stg.Item_Description
1371: FROM FII_AP_INV_DIST_T stg, fii_ap_inv_rates_temp rates
1372: where stg.account_date = rates.trx_date
1373: and stg.inv_currency_code = rates.functional_currency;
1374:
1375: if g_debug_flag = 'Y' then