DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INIT dependencies on BIS_COLLECTION_UTILITIES

Line 915: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

911: --------------------------------------------------------
912:
913: IF (l_miss_rates_ps > 0 OR
914: l_miss_rates_func > 0) THEN
915: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
916:
917:
918: FOR rate_record in func_MissingRate
919: LOOP

Line 920: BIS_COLLECTION_UTILITIES.writeMissingRate(

916:
917:
918: FOR rate_record in func_MissingRate
919: LOOP
920: BIS_COLLECTION_UTILITIES.writeMissingRate(
921: rate_record.conversion_type,
922: rate_record.from_currency,
923: rate_record.to_currency,
924: rate_record.trx_date);

Line 930: BIS_COLLECTION_UTILITIES.writeMissingRate(

926:
927:
928: FOR rate_record in prim_MissingRate
929: LOOP
930: BIS_COLLECTION_UTILITIES.writeMissingRate(
931: g_prim_rate_type,
932: rate_record.from_currency,
933: g_prim_currency,
934: rate_record.trx_date);

Line 940: BIS_COLLECTION_UTILITIES.writeMissingRate(

936:
937:
938: FOR rate_record in sec_MissingRate
939: LOOP
940: BIS_COLLECTION_UTILITIES.writeMissingRate(
941: g_sec_rate_type,
942: rate_record.from_currency,
943: g_sec_currency,
944: rate_record.trx_date);

Line 6957: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';

6953: g_start_date := trunc(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'));
6954: g_end_date := trunc(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS')) + 1 - ONE_SECOND;
6955: g_no_worker := p_no_worker;
6956:
6957: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
6958: IF(NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_SUM_INIT')) THEN
6959: raise_application_error(-20000, errbuf);
6960: return;
6961: END IF;

Line 6958: IF(NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_SUM_INIT')) THEN

6954: g_end_date := trunc(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS')) + 1 - ONE_SECOND;
6955: g_no_worker := p_no_worker;
6956:
6957: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
6958: IF(NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_SUM_INIT')) THEN
6959: raise_application_error(-20000, errbuf);
6960: return;
6961: END IF;
6962:

Line 6977: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;

6973: FII_UTIL.put_line(g_state);
6974: fii_util.put_line('');
6975: END IF;
6976:
6977: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
6978:
6979: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
6980: l_start_date, l_end_date,
6981: l_period_from, l_period_to);

Line 6979: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',

6975: END IF;
6976:
6977: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
6978:
6979: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
6980: l_start_date, l_end_date,
6981: l_period_from, l_period_to);
6982:
6983: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',

Line 6983: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',

6979: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
6980: l_start_date, l_end_date,
6981: l_period_from, l_period_to);
6982:
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),

Line 6991: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',

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,
6993: l_period_from, l_period_to);
6994:
6995: l_start_date := GREATEST(l_start_date,

Line 6998: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',

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);
7001:
7002: l_start_date := GREATEST(l_start_date,

Line 7221: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';

7217: FII_UTIL.put_line('return code is ' || retcode);
7218: end if;
7219: Retcode := g_retcode;
7220:
7221: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
7222: BIS_COLLECTION_UTILITIES.wrapup(
7223: p_status => TRUE,
7224: p_period_from => g_start_date,
7225: p_period_to => g_end_date);

Line 7222: BIS_COLLECTION_UTILITIES.wrapup(

7218: end if;
7219: Retcode := g_retcode;
7220:
7221: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
7222: BIS_COLLECTION_UTILITIES.wrapup(
7223: p_status => TRUE,
7224: p_period_from => g_start_date,
7225: p_period_to => g_end_date);
7226:

Line 7227: BIS_COLLECTION_UTILITIES.deleteLogForObject('FII_AP_INV_SUM_INC');

7223: p_status => TRUE,
7224: p_period_from => g_start_date,
7225: p_period_to => g_end_date);
7226:
7227: BIS_COLLECTION_UTILITIES.deleteLogForObject('FII_AP_INV_SUM_INC');
7228:
7229:
7230: EXCEPTION
7231: WHEN OTHERS THEN