APPS.BIL_BI_FST_DTL_F_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 260: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

256: END IF;
257:
258:
259:
260: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
261: g_obj_name,
262: l_start_date,
263: l_end_date,
264: l_period_from,

Line 384: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

380:
381: errbuf := NULL;
382: retcode := 0;
383:
384: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
385: g_obj_name,
386: l_start_date,
387: l_end_date,
388: l_period_from,

Line 416: BIS_COLLECTION_UTILITIES.deleteLogForObject (g_obj_name);

412: bil_bi_util_collection_pkg.Truncate_table('BIL_BI_FST_DTL_F');
413: bil_bi_util_collection_pkg.Truncate_table('BIL_BI_FST_DTL_STG');
414: bil_bi_util_collection_pkg.Truncate_table('BIL_BI_PROCESSED_FST_ID');
415: bil_bi_util_collection_pkg.Truncate_table('BIL_BI_NEW_FST_ID');
416: BIS_COLLECTION_UTILITIES.deleteLogForObject (g_obj_name);
417: g_truncate_flag := TRUE;
418: COMMIT;
419: END IF;
420:

Line 814: BIS_COLLECTION_UTILITIES.wrapup(TRUE, 0, NULL, g_start_date, g_end_date);

810: p_msg => 'No new forecasts to process, exiting.'
811: );
812: END IF;
813: COMMIT;
814: BIS_COLLECTION_UTILITIES.wrapup(TRUE, 0, NULL, g_start_date, g_end_date);
815: RETURN;
816: END IF;
817:
818: COMMIT;

Line 1242: IF (NOT BIS_COLLECTION_UTILITIES.setup(p_obj_name)) THEN

1238: p_msg => ' Start of Procedure ' || l_proc);
1239: END IF;
1240:
1241:
1242: IF (NOT BIS_COLLECTION_UTILITIES.setup(p_obj_name)) THEN
1243:
1244: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1245: bil_bi_util_collection_pkg.writeLog(
1246: p_log_level => fnd_log.LEVEL_EVENT,

Line 1254: g_debug := BIS_COLLECTION_UTILITIES.g_debug;

1250: RAISE G_INIT_FAILED;
1251: END IF;
1252:
1253:
1254: g_debug := BIS_COLLECTION_UTILITIES.g_debug;
1255:
1256:
1257: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1258: bil_bi_util_collection_pkg.writeLog(

Line 1884: BIS_COLLECTION_UTILITIES.wrapup(TRUE,g_fact_row_proc,NULL,g_start_date,g_end_date);

1880: p_msg => 'Calling wrap up');
1881: END IF;
1882:
1883: COMMIT;
1884: BIS_COLLECTION_UTILITIES.wrapup(TRUE,g_fact_row_proc,NULL,g_start_date,g_end_date);
1885: ELSE
1886: COMMIT;
1887: BIS_COLLECTION_UTILITIES.wrapup(FALSE,0,ErrorMsg,g_start_date,g_end_date);
1888: END IF;

Line 1887: BIS_COLLECTION_UTILITIES.wrapup(FALSE,0,ErrorMsg,g_start_date,g_end_date);

1883: COMMIT;
1884: BIS_COLLECTION_UTILITIES.wrapup(TRUE,g_fact_row_proc,NULL,g_start_date,g_end_date);
1885: ELSE
1886: COMMIT;
1887: BIS_COLLECTION_UTILITIES.wrapup(FALSE,0,ErrorMsg,g_start_date,g_end_date);
1888: END IF;
1889:
1890: /* Always truncate staging table */
1891: bil_bi_util_collection_pkg.truncate_table('BIL_BI_FST_DTL_STG');

Line 3290: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;

3286: -- there are missing exchange rate information
3287: -------------------------------------------------
3288: FII_MESSAGE.write_log(msg_name => 'BIS_DBI_CURR_PARTIAL_LOAD',token_num => 0);
3289:
3290: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
3291:
3292: FOR rate_record in MissingRate_p LOOP
3293:
3294: IF (rate_record.prim_curr_type = 'P') THEN

Line 3295: BIS_COLLECTION_UTILITIES.writemissingrate(

3291:
3292: FOR rate_record in MissingRate_p LOOP
3293:
3294: IF (rate_record.prim_curr_type = 'P') THEN
3295: BIS_COLLECTION_UTILITIES.writemissingrate(
3296: g_prim_rate_type,
3297: rate_record.currency_code,
3298: g_prim_currency,
3299: rate_record.report_date);

Line 3303: BIS_COLLECTION_UTILITIES.writemissingrate(

3299: rate_record.report_date);
3300: END IF;
3301:
3302: IF (rate_record.sec_curr_type='S') THEN
3303: BIS_COLLECTION_UTILITIES.writemissingrate(
3304: g_sec_rate_type,
3305: rate_record.currency_code,
3306: g_sec_currency,
3307: rate_record.report_date);