449:
450: IF (l_miss_rates_prim > 0 OR
451: l_miss_rates_sec > 0 OR
452: l_miss_rates_func > 0) THEN
453: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
454:
455: FOR rate_record in func_MissingRate
456: LOOP
457: BIS_COLLECTION_UTILITIES.writeMissingRate(
453: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
454:
455: FOR rate_record in func_MissingRate
456: LOOP
457: BIS_COLLECTION_UTILITIES.writeMissingRate(
458: rate_record.conversion_type,
459: rate_record.from_currency,
460: rate_record.to_currency,
461: rate_record.trx_date);
463:
464:
465: FOR rate_record in prim_MissingRate
466: LOOP
467: BIS_COLLECTION_UTILITIES.writeMissingRate(
468: g_prim_rate_type,
469: rate_record.from_currency,
470: g_prim_currency,
471: rate_record.trx_date);
473:
474:
475: FOR rate_record in sec_MissingRate
476: LOOP
477: BIS_COLLECTION_UTILITIES.writeMissingRate(
478: g_sec_rate_type,
479: rate_record.from_currency,
480: g_sec_currency,
481: rate_record.trx_date);
4254: RAISE G_IMP_NOT_SET;
4255: END IF;
4256:
4257:
4258: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
4259: IF(NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_SUM_INC')) THEN
4260: raise_application_error(-20000, errbuf);
4261: return;
4262: END IF;
4255: END IF;
4256:
4257:
4258: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
4259: IF(NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_SUM_INC')) THEN
4260: raise_application_error(-20000, errbuf);
4261: return;
4262: END IF;
4263:
4274: FII_UTIL.put_line(g_state);
4275: fii_util.put_line('');
4276: END IF;
4277:
4278: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
4279:
4280: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
4281: l_start_date, l_end_date,
4282: l_period_from, l_period_to);
4276: END IF;
4277:
4278: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
4279:
4280: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
4281: l_start_date, l_end_date,
4282: l_period_from, l_period_to);
4283:
4284: g_start_date := NVL(l_period_from, BIS_COMMON_PARAMETERS.Get_Global_Start_Date);
4282: l_period_from, l_period_to);
4283:
4284: g_start_date := NVL(l_period_from, BIS_COMMON_PARAMETERS.Get_Global_Start_Date);
4285:
4286: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',
4287: l_start_date_temp, l_end_date,
4288: l_period_from, l_period_to);
4289:
4290: l_start_date := GREATEST(NVL(l_start_date, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),
4294: g_timestamp4 := l_start_date;
4295:
4296: IF g_exp_imp_prof_flag = 'Y' THEN
4297:
4298: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
4299: l_start_date, l_end_date,
4300: l_period_from, l_period_to);
4301:
4302: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',
4298: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
4299: l_start_date, l_end_date,
4300: l_period_from, l_period_to);
4301:
4302: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',
4303: l_start_date_temp, l_end_date,
4304: l_period_from, l_period_to);
4305:
4306: l_start_date := GREATEST(NVL(l_start_date, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),
4624: FII_UTIL.put_line('return code is ' || retcode);
4625: end if;
4626: Retcode := g_retcode;
4627:
4628: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
4629: BIS_COLLECTION_UTILITIES.wrapup(
4630: p_status => TRUE,
4631: p_period_from => l_period_from,
4632: p_period_to => g_timestamp1);
4625: end if;
4626: Retcode := g_retcode;
4627:
4628: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
4629: BIS_COLLECTION_UTILITIES.wrapup(
4630: p_status => TRUE,
4631: p_period_from => l_period_from,
4632: p_period_to => g_timestamp1);
4633: