APPS.FII_AP_MV_REFRESH dependencies on FII_UTIL

Line 30: -- fii_util.initialize will get profile options FII_DEBUG_MODE

26: ------------------------------------------------------
27: l_dir:='/sqlcom/log';
28:
29: ----------------------------------------------------------------
30: -- fii_util.initialize will get profile options FII_DEBUG_MODE
31: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
32: -- the log files and output files are written to
33: ----------------------------------------------------------------
34: FII_UTIL.initialize('FII_AP_MV_REFRESH.log', 'FII_AP_MV_REFRESH.out',l_dir);

Line 34: FII_UTIL.initialize('FII_AP_MV_REFRESH.log', 'FII_AP_MV_REFRESH.out',l_dir);

30: -- fii_util.initialize will get profile options FII_DEBUG_MODE
31: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
32: -- the log files and output files are written to
33: ----------------------------------------------------------------
34: FII_UTIL.initialize('FII_AP_MV_REFRESH.log', 'FII_AP_MV_REFRESH.out',l_dir);
35:
36:
37: g_phase := 'Refreshing AP MV tables - 1';
38: if g_debug_flag = 'Y' then

Line 39: FII_UTIL.put_line(g_phase);

35:
36:
37: g_phase := 'Refreshing AP MV tables - 1';
38: if g_debug_flag = 'Y' then
39: FII_UTIL.put_line(g_phase);
40: FII_UTIL.put_line('');
41: end if;
42:
43: l_parallel_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

Line 40: FII_UTIL.put_line('');

36:
37: g_phase := 'Refreshing AP MV tables - 1';
38: if g_debug_flag = 'Y' then
39: FII_UTIL.put_line(g_phase);
40: FII_UTIL.put_line('');
41: end if;
42:
43: l_parallel_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
44: IF (l_parallel_degree =1) THEN

Line 57: FII_UTIL.put_line(g_phase);

53: );
54:
55: g_phase := 'Refreshing AP MV tables - 2';
56: if g_debug_flag = 'Y' then
57: FII_UTIL.put_line(g_phase);
58: FII_UTIL.put_line('');
59: end if;
60:
61: dbms_mview.refresh(

Line 58: FII_UTIL.put_line('');

54:
55: g_phase := 'Refreshing AP MV tables - 2';
56: if g_debug_flag = 'Y' then
57: FII_UTIL.put_line(g_phase);
58: FII_UTIL.put_line('');
59: end if;
60:
61: dbms_mview.refresh(
62: list => 'FII_AP_HHIST_I_MV,FII_AP_LIA_I_MV,FII_AP_HCAT_I_MV,FII_AP_IVATY_XB_MV',

Line 69: FII_UTIL.put_line(g_phase);

65: );
66:
67: g_phase := 'Refreshing AP MV tables - 3';
68: if g_debug_flag = 'Y' then
69: FII_UTIL.put_line(g_phase);
70: FII_UTIL.put_line('');
71: end if;
72:
73: dbms_mview.refresh(

Line 70: FII_UTIL.put_line('');

66:
67: g_phase := 'Refreshing AP MV tables - 3';
68: if g_debug_flag = 'Y' then
69: FII_UTIL.put_line(g_phase);
70: FII_UTIL.put_line('');
71: end if;
72:
73: dbms_mview.refresh(
74: list => 'FII_AP_HHIST_IB_MV,FII_AP_LIA_IB_MV,FII_AP_HCAT_IB_MV',

Line 81: FII_UTIL.put_line(g_phase);

77: );
78:
79: g_phase := 'Refreshing AP MV tables - 4';
80: if g_debug_flag = 'Y' then
81: FII_UTIL.put_line(g_phase);
82: FII_UTIL.put_line('');
83: end if;
84:
85: dbms_mview.refresh(

Line 82: FII_UTIL.put_line('');

78:
79: g_phase := 'Refreshing AP MV tables - 4';
80: if g_debug_flag = 'Y' then
81: FII_UTIL.put_line(g_phase);
82: FII_UTIL.put_line('');
83: end if;
84:
85: dbms_mview.refresh(
86: list => 'FII_AP_HATY_XB_MV,FII_AP_HLIA_IB_MV',

Line 93: FII_UTIL.put_line(g_phase);

89: );
90:
91: g_phase := 'Refreshing AP MV tables - 5';
92: if g_debug_flag = 'Y' then
93: FII_UTIL.put_line(g_phase);
94: FII_UTIL.put_line('');
95: end if;
96:
97: dbms_mview.refresh(

Line 94: FII_UTIL.put_line('');

90:
91: g_phase := 'Refreshing AP MV tables - 5';
92: if g_debug_flag = 'Y' then
93: FII_UTIL.put_line(g_phase);
94: FII_UTIL.put_line('');
95: end if;
96:
97: dbms_mview.refresh(
98: list => 'FII_AP_HLIA_I_MV,FII_AP_HLWAG_IB_MV',

Line 108: FII_UTIL.DEBUG_LINE(Retcode||':'||Errbuf);

104: WHEN OTHERS THEN
105: Errbuf:= sqlerrm;
106: Retcode:=sqlcode;
107: if g_debug_flag = 'Y' then
108: FII_UTIL.DEBUG_LINE(Retcode||':'||Errbuf);
109: end if;
110:
111: END AP_REFRESH;
112: