48: ---------------------------------*****---
49: --bug 3242732: refresh FII_GL_BASE_MV, this is a temporary fix
50: IF (p_program_type = 'L')
51: THEN
52: -- bug 4115002 - changed from dbms_mview.refresh to bis_mv_refresh
53: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', 'C',l_parallel_degree );
54:
55: --(only) Analyze the MV LOG after full refresh
56: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
49: --bug 3242732: refresh FII_GL_BASE_MV, this is a temporary fix
50: IF (p_program_type = 'L')
51: THEN
52: -- bug 4115002 - changed from dbms_mview.refresh to bis_mv_refresh
53: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', 'C',l_parallel_degree );
54:
55: --(only) Analyze the MV LOG after full refresh
56: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
57: tabname=>'MLOG$_FII_GL_BASE_MV');
55: --(only) Analyze the MV LOG after full refresh
56: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
57: tabname=>'MLOG$_FII_GL_BASE_MV');
58: ELSE
59: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', '?',l_parallel_degree );
60: END IF;
61:
62: ---------------------------------*****---
63:
81: ----- method => '?',
82: ----- parallelism => l_parallel_degree );
83:
84: IF (p_program_type = 'L') THEN
85: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', 'C', l_parallel_degree);
86: ELSE
87: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', '?', l_parallel_degree);
88: END IF;
89: ------------------------------------------------------------------------------
83:
84: IF (p_program_type = 'L') THEN
85: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', 'C', l_parallel_degree);
86: ELSE
87: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', '?', l_parallel_degree);
88: END IF;
89: ------------------------------------------------------------------------------
90:
91: IF g_debug_flag = 'Y' THEN
138: ----- method => '?',
139: ----- parallelism => l_parallel_degree );
140:
141: IF (p_program_type = 'L') THEN
142: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', 'C', l_parallel_degree);
143: ELSE
144: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', '?', l_parallel_degree);
145: END IF;
146: ------------------------------------------------------------------------------
140:
141: IF (p_program_type = 'L') THEN
142: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', 'C', l_parallel_degree);
143: ELSE
144: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', '?', l_parallel_degree);
145: END IF;
146: ------------------------------------------------------------------------------
147:
148: IF g_debug_flag = 'Y' THEN