DBA Data[Home] [Help]

APPS.FII_MV_REFRESH dependencies on BIS_MV_REFRESH

Line 52: -- bug 4115002 - changed from dbms_mview.refresh to bis_mv_refresh

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,

Line 53: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', 'C',l_parallel_degree );

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');

Line 59: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', '?',l_parallel_degree );

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:

Line 85: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', 'C', l_parallel_degree);

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: ------------------------------------------------------------------------------

Line 87: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_CCC_MV', '?', 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: ------------------------------------------------------------------------------
90:
91: IF g_debug_flag = 'Y' THEN

Line 142: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', 'C', l_parallel_degree);

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: ------------------------------------------------------------------------------

Line 144: BIS_MV_REFRESH.refresh_wrapper ('FII_GL_MGMT_SUM_MV', '?', 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: ------------------------------------------------------------------------------
147:
148: IF g_debug_flag = 'Y' THEN