APPS.FII_MV_REFRESH dependencies on FII_INDEX_UTIL

Line 66: fii_index_util.drop_index('FII_GL_MGMT_CCC_MV', g_apps_schema_name, Retcode);

62: ---------------------------------*****---
63:
64: -- Drop index for FII_GL_MGMT_CCC_MV in Initial Mode
65: IF (p_program_type = 'L') THEN
66: fii_index_util.drop_index('FII_GL_MGMT_CCC_MV', g_apps_schema_name, Retcode);
67: IF Retcode <> '0' THEN
68: RAISE index_exception;
69: END IF;
70: END IF;

Line 99: fii_index_util.create_index('FII_GL_MGMT_CCC_MV', g_apps_schema_name, Retcode );

95: END IF;
96:
97: -- Re-create index for FII_GL_MGMT_CCC_MV in Initial Mode
98: IF (p_program_type = 'L') THEN
99: fii_index_util.create_index('FII_GL_MGMT_CCC_MV', g_apps_schema_name, Retcode );
100: IF Retcode <> '0' THEN
101: RAISE index_exception;
102: END IF;
103: END IF;

Line 123: fii_index_util.drop_index('FII_GL_MGMT_SUM_MV', g_apps_schema_name, Retcode);

119: END IF;
120:
121: -- Drop index for FII_GL_MGMT_SUM_MV in Initial Mode
122: IF (p_program_type = 'L') THEN
123: fii_index_util.drop_index('FII_GL_MGMT_SUM_MV', g_apps_schema_name, Retcode);
124: IF Retcode <> '0' THEN
125: RAISE index_exception;
126: END IF;
127: END IF;

Line 156: fii_index_util.create_index('FII_GL_MGMT_SUM_MV', g_apps_schema_name, Retcode);

152: END IF;
153:
154: -- Re-create index for FII_GL_MGMT_SUM_MV in Initial Mode
155: IF (p_program_type = 'L') THEN
156: fii_index_util.create_index('FII_GL_MGMT_SUM_MV', g_apps_schema_name, Retcode);
157: IF Retcode <> '0' THEN
158: RAISE index_exception;
159: END IF;
160: END IF;

Line 380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);

376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');
378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);
380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);
381: IF l_retcode <> '0' THEN
382: RAISE l_index_exception;
383: END IF;
384: ELSE --AFTER Mode

Line 386: FII_INDEX_UTIL.Create_Index(l_obj_name, g_apps_schema_name, l_retcode);

382: RAISE l_index_exception;
383: END IF;
384: ELSE --AFTER Mode
385: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating indexes on object ' || l_obj_name);
386: FII_INDEX_UTIL.Create_Index(l_obj_name, g_apps_schema_name, l_retcode);
387: IF l_retcode <> '0' THEN
388: RAISE l_index_exception;
389: END IF;
390: END IF;