APPS.BIL_BI_FST_DTL_F_PKG dependencies on BIL_BI_FST_DTL_F

Line 1: PACKAGE BODY BIL_BI_FST_DTL_F_PKG AS

1: PACKAGE BODY BIL_BI_FST_DTL_F_PKG AS
2: /*$Header: bilfstb.pls 120.2 2005/10/06 03:45:04 asolaiy noship $*/
3:
4: -- Global variables for WHO variables and Concurrent program
5:

Line 143: g_obj_name := 'BIL_BI_FST_DTL_F';

139: g_conv_rate_cnt := 0;
140: g_degree :=1;
141: g_num_row_proc :=0;
142: g_fact_row_proc :=0;
143: g_obj_name := 'BIL_BI_FST_DTL_F';
144: g_missing_rates := 0;
145: g_missing_time := 0;
146: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';
147:

Line 146: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';

142: g_fact_row_proc :=0;
143: g_obj_name := 'BIL_BI_FST_DTL_F';
144: g_missing_rates := 0;
145: g_missing_time := 0;
146: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';
147:
148: l_proc := 'INIT_LOAD.';
149: /* end initialization of variable */
150:

Line 238: g_obj_name := 'BIL_BI_FST_DTL_F';

234: g_conv_rate_cnt := 0;
235: g_degree :=1;
236: g_num_row_proc :=0;
237: g_fact_row_proc :=0;
238: g_obj_name := 'BIL_BI_FST_DTL_F';
239: g_missing_rates := 0;
240: g_missing_time := 0;
241: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';
242:

Line 241: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';

237: g_fact_row_proc :=0;
238: g_obj_name := 'BIL_BI_FST_DTL_F';
239: g_missing_rates := 0;
240: g_missing_time := 0;
241: g_pkg := 'bil.patch.115.sql.BIL_BI_FST_DTL_F_PKG.';
242:
243: l_start_date :=NULL;
244: l_end_date :=NULL;
245: l_period_from :=NULL;

Line 401: g_obj_name := 'BIL_BI_FST_DTL_F';

397:
398: ------------------------------------------------
399: -- Initialize Global Variables
400: ------------------------------------------------
401: g_obj_name := 'BIL_BI_FST_DTL_F';
402: init(g_obj_name);
403:
404: -- only set these for main parent and for initial run
405: IF(g_mode='INITIAL') THEN

Line 412: bil_bi_util_collection_pkg.Truncate_table('BIL_BI_FST_DTL_F');

408: END IF;
409:
410: -- chech for mode of operation, if full refresh, truncate tables
411: IF (g_mode='INITIAL') THEN
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);

Line 975: bil_bi_util_collection_pkg.analyze_table('BIL_BI_FST_DTL_F', TRUE, 10, 'GLOBAL');

971: p_msg => g_phase);
972: END IF;
973: Clean_up(NULL);
974: IF (g_truncate_flag or g_first_run) THEN
975: bil_bi_util_collection_pkg.analyze_table('BIL_BI_FST_DTL_F', TRUE, 10, 'GLOBAL');
976: END IF;
977: retcode := 0;
978: ELSE
979: -- don't move a record to base summary table in case of error but still commit

Line 2319: INSERT /*+ PARALLEL(fact) */ into BIL_BI_FST_DTL_F fact

2315: -----------------------------------------------------------------------
2316:
2317: IF (g_mode='INITIAL' and g_first_run) THEN
2318:
2319: INSERT /*+ PARALLEL(fact) */ into BIL_BI_FST_DTL_F fact
2320: (TXN_TIME_ID,
2321: TXN_PERIOD_TYPE_ID,
2322: FORECAST_TIME_ID,
2323: FORECAST_PERIOD_TYPE_ID,

Line 2419: MERGE /*+ index(bsum) */ INTO BIL_BI_FST_DTL_F bsum

2415:
2416: l_number_of_rows := SQL%ROWCOUNT;
2417: ELSE
2418: -- added the index hint per jais suggestions
2419: MERGE /*+ index(bsum) */ INTO BIL_BI_FST_DTL_F bsum
2420: USING (select
2421: SUM(forecast_amt) AMOUNT,
2422: SUM(forecast_amt_s) SEC_AMOUNT,
2423: SUM(opp_forecast_amt) opp_amount,

Line 3854: END BIL_BI_FST_DTL_F_PKG;

3850:
3851: END Check_Profiles;
3852:
3853:
3854: END BIL_BI_FST_DTL_F_PKG;