APPS.FII_GL_TOP_SPENDERS_PKG dependencies on FII_TOP_SPNDR_SUM_B

Line 52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';

48: ----------------------------------------------------------
49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);
54:
55: Exception
56:

Line 53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);

49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);
54:
55: Exception
56:
57: WHEN NO_DATA_FOUND THEN

Line 277: fii_util.write_log('Populating fii_top_spndr_sum_b table');

273:
274: BEGIN
275:
276: if g_debug_flag = 'Y' then
277: fii_util.write_log('Populating fii_top_spndr_sum_b table');
278: end if;
279:
280: g_phase := 'Insert rows into fii_top_spndr_sum_b table';
281:

Line 280: g_phase := 'Insert rows into fii_top_spndr_sum_b table';

276: if g_debug_flag = 'Y' then
277: fii_util.write_log('Populating fii_top_spndr_sum_b table');
278: end if;
279:
280: g_phase := 'Insert rows into fii_top_spndr_sum_b table';
281:
282: INSERT /*+ append parallel(b) */ INTO fii_top_spndr_sum_b (
283: person_id,
284: period_id,

Line 282: INSERT /*+ append parallel(b) */ INTO fii_top_spndr_sum_b (

278: end if;
279:
280: g_phase := 'Insert rows into fii_top_spndr_sum_b table';
281:
282: INSERT /*+ append parallel(b) */ INTO fii_top_spndr_sum_b (
283: person_id,
284: period_id,
285: slice_type_flag,
286: manager_id,

Line 329: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPNDR_SUM_B');

325: help.manager_id ) x
326: WHERE x.RANK_WITHIN_MANAGER_ptd <= 10;
327:
328: if g_debug_flag = 'Y' then
329: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPNDR_SUM_B');
330: end if;
331:
332: FND_STATS.gather_table_stats
333: (ownname => g_fii_schema,

Line 334: tabname => 'FII_TOP_SPNDR_SUM_B');

330: end if;
331:
332: FND_STATS.gather_table_stats
333: (ownname => g_fii_schema,
334: tabname => 'FII_TOP_SPNDR_SUM_B');
335: commit;
336:
337: EXCEPTION
338: WHEN OTHERS THEN