APPS.FII_RECONVERSION_PKG dependencies on FII_CURRENCY

Line 295: l_primary_mau := FII_CURRENCY.get_mau_primary;

291: ELSE
292: -- Set l_primary_currency and l_primary_mau
293: l_primary_currency := BIS_COMMON_PARAMETERS.get_currency_code;
294: FII_UTIL.debug_line(' l_primary_currency = ' || l_primary_currency);
295: l_primary_mau := FII_CURRENCY.get_mau_primary;
296: FII_UTIL.debug_line(' l_primary_mau = ' || l_primary_mau);
297:
298: -- Validate primary currency and its MAU
299: IF (l_primary_currency IS NULL AND p_currency_type = 'PRIMARY')

Line 337: l_secondary_mau := FII_CURRENCY.get_mau_secondary;

333:
334: ELSE
335: l_secondary_currency := BIS_COMMON_PARAMETERS.get_secondary_currency_code;
336: FII_UTIL.debug_line(' l_secondary_currency = ' || l_secondary_currency);
337: l_secondary_mau := FII_CURRENCY.get_mau_secondary;
338: FII_UTIL.debug_line(' l_secondary_mau = ' || l_secondary_mau);
339:
340: IF (l_secondary_currency IS NULL AND p_currency_type = 'SECONDARY')
341: THEN

Line 837: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency

833: , PRIMARY_RATE, SECONDARY_RATE)
834: (SELECT DISTINCT
835: p_request_id, t.report_date_julian, t.report_date, sob.currency_code
836: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
837: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
838: , t.report_date, p_primary_rate_type))
839: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
840: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
841: , t.report_date, p_secondary_rate_type))

Line 840: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency

836: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
837: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
838: , t.report_date, p_primary_rate_type))
839: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
840: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
841: , t.report_date, p_secondary_rate_type))
842: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
843: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
844: AND EXISTS (SELECT 'This date has GL transaction'

Line 884: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency

880: , PRIMARY_RATE, SECONDARY_RATE)
881: (SELECT DISTINCT
882: p_request_id, t.report_date_julian, t.report_date, sob.currency_code
883: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
884: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
885: , t.report_date, p_primary_rate_type))
886: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
887: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
888: , t.report_date, p_secondary_rate_type))

Line 887: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency

883: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
884: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
885: , t.report_date, p_primary_rate_type))
886: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
887: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
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'

Line 933: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency

929: , PRIMARY_RATE, SECONDARY_RATE)
930: (SELECT DISTINCT
931: p_request_id, t.report_date_julian, t.report_date, sob.currency_code
932: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
933: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
934: , t.report_date, p_primary_rate_type))
935: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
936: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
937: , t.report_date, p_secondary_rate_type))

Line 936: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency

932: , DECODE( p_primary_currency, sob.currency_code, 1, NULL, NULL
933: , FII_CURRENCY.GET_RATE( sob.currency_code, p_primary_currency
934: , t.report_date, p_primary_rate_type))
935: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
936: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
937: , t.report_date, p_secondary_rate_type))
938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
939: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
940: AND EXISTS (SELECT /*+ parallel(ar) */ 'This date has AR transaction'