136: if g_debug_flag = 'Y' then
137: FII_UTIL.put_line('Initializing the Global Currencies');
138: end if;
139:
140: g_prim_currency := bis_common_parameters.get_currency_code;
141: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
142:
143: if g_debug_flag = 'Y' then
144: FII_UTIL.put_line('Initializing Global Currency Rate Types');
137: FII_UTIL.put_line('Initializing the Global Currencies');
138: end if;
139:
140: g_prim_currency := bis_common_parameters.get_currency_code;
141: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
142:
143: if g_debug_flag = 'Y' then
144: FII_UTIL.put_line('Initializing Global Currency Rate Types');
145: end if;
143: if g_debug_flag = 'Y' then
144: FII_UTIL.put_line('Initializing Global Currency Rate Types');
145: end if;
146:
147: g_prim_rate_type := bis_common_parameters.get_rate_type;
148: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
149:
150: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
151: l_global_param_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
144: FII_UTIL.put_line('Initializing Global Currency Rate Types');
145: end if;
146:
147: g_prim_rate_type := bis_common_parameters.get_rate_type;
148: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
149:
150: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
151: l_global_param_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
152: l_global_param_list(3) := 'BIS_PRIMARY_RATE_TYPE';
149:
150: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
151: l_global_param_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
152: l_global_param_list(3) := 'BIS_PRIMARY_RATE_TYPE';
153: IF (NOT bis_common_parameters.check_global_parameters(l_global_param_list)) THEN
154: RAISE G_MISS_GLOBAL_PARAMS;
155: END IF;
156:
157: if ((g_sec_currency IS NULL and g_sec_rate_type IS NOT NULL) OR
6983: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',
6984: l_start_date_temp, l_end_date,
6985: l_period_from, l_period_to);
6986:
6987: l_start_date := GREATEST(NVL(l_start_date, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),
6988: NVL(l_start_date_temp, BIS_COMMON_PARAMETERS.Get_Global_Start_Date));
6989: g_timestamp3 := l_start_date;
6990:
6991: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
6984: l_start_date_temp, l_end_date,
6985: l_period_from, l_period_to);
6986:
6987: l_start_date := GREATEST(NVL(l_start_date, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),
6988: NVL(l_start_date_temp, BIS_COMMON_PARAMETERS.Get_Global_Start_Date));
6989: g_timestamp3 := l_start_date;
6990:
6991: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
6992: l_start_date_temp, l_end_date,
6992: l_start_date_temp, l_end_date,
6993: l_period_from, l_period_to);
6994:
6995: l_start_date := GREATEST(l_start_date,
6996: NVL(l_start_date_temp, BIS_COMMON_PARAMETERS.Get_Global_Start_Date));
6997:
6998: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',
6999: l_start_date_temp, l_end_date,
7000: l_period_from, l_period_to);
6999: l_start_date_temp, l_end_date,
7000: l_period_from, l_period_to);
7001:
7002: l_start_date := GREATEST(l_start_date,
7003: NVL(l_start_date_temp, BIS_COMMON_PARAMETERS.Get_Global_Start_Date));
7004:
7005: g_timestamp2 := l_start_date;
7006:
7007: g_act_part1 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp1), 'J')), 32);