[Home] [Help]
873: 'FII_RECONV_CACHE_RATE_STEP', NULL
874: , 'PROD_NAME', p_ap_name));
875:
876: -- Insert rates to FII_RECONV_RATES based on the transactions of
877: -- FII_AP_INV_B within the passed date range and they are not yet cached
878: INSERT INTO FII_RECONV_RATES
879: ( REQUEST_ID, RATE_DATE_ID, RATE_DATE, FROM_CURRENCY
880: , PRIMARY_RATE, SECONDARY_RATE)
881: (SELECT DISTINCT
888: , t.report_date, p_secondary_rate_type))
889: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
890: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
891: AND EXISTS (SELECT /*+ parallel(ap) */ 'This date has AP transaction'
892: FROM FII_AP_INV_B ap
893: WHERE ap.account_date_id = t.report_date_julian
894: AND ap.ledger_id = sob.ledger_id)
895: AND NOT EXISTS (SELECT 'This rate has been cached'
896: FROM FII_RECONV_RATES r
1845: -- PROCEDURE
1846: -- reconvert_ap()
1847: --
1848: -- DESCRIPTION:
1849: -- It will reconvert global amounts for the AP base table FII_AP_INV_B.
1850: PROCEDURE reconvert_ap( errbuf IN OUT NOCOPY VARCHAR2
1851: , retcode IN OUT NOCOPY VARCHAR2
1852: , p_request_id IN NUMBER
1853: , p_user_id IN NUMBER
1888: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
1889: , 'PROD_NAME', p_product_name));
1890:
1891: --
1892: -- 4.2 Update FII_AP_INV_B for the newly different reconverted global amounts
1893: --
1894: l_process_step := 'UPDATE_AP_B';
1895: UPDATE /*+ parallel(ap) */ FII_AP_INV_B ap
1896: SET ( PRIM_AMOUNT_G, SEC_AMOUNT_G, LAST_UPDATE_DATE
1891: --
1892: -- 4.2 Update FII_AP_INV_B for the newly different reconverted global amounts
1893: --
1894: l_process_step := 'UPDATE_AP_B';
1895: UPDATE /*+ parallel(ap) */ FII_AP_INV_B ap
1896: SET ( PRIM_AMOUNT_G, SEC_AMOUNT_G, LAST_UPDATE_DATE
1897: , LAST_UPDATED_BY, LAST_UPDATE_LOGIN) =
1898: (SELECT DECODE(p_primary_currency, NULL, ap.prim_amount_g
1899: , ROUND((ap.amount_b*r.primary_rate)