[Home] [Help]
1100: -- before also since truncation of the tables does not let
1101: -- incremental refresh of MV happen.
1102: -- If the dimension hierarchy table has 1 record then the dimension
1103: -- was disabled previously.
1104: select count(*) into l_count from fii_full_company_hiers;
1105:
1106: IF(l_count > 1 OR l_count = 0) THEN
1107: -- Incase the dimension hierarchy table had more than 1 record
1108: -- this means the dimension was enabled previously and it has been
1109: -- disabled now, in which case initial refresh of MV should happen
1110: -- so it is ok to truncate the tables
1111:
1112: g_phase := 'Truncate dimension hierarchy tables';
1113: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1114: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);
1115:
1116: INSERT INTO FII_FULL_COMPANY_HIERS
1117: (parent_level,
1112: g_phase := 'Truncate dimension hierarchy tables';
1113: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1114: FII_UTIL.truncate_table ('FII_COMPANY_HIERARCHIES', 'FII', g_retcode);
1115:
1116: INSERT INTO FII_FULL_COMPANY_HIERS
1117: (parent_level,
1118: parent_company_id,
1119: next_level,
1120: next_level_company_id,
1242:
1243: --Copy TMP hierarchy table to the final dimension table
1244: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1245:
1246: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1247:
1248: INSERT /*+ APPEND */ INTO FII_FULL_COMPANY_HIERS (
1249: parent_level,
1250: parent_company_id,
1244: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1245:
1246: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1247:
1248: INSERT /*+ APPEND */ INTO FII_FULL_COMPANY_HIERS (
1249: parent_level,
1250: parent_company_id,
1251: next_level,
1252: next_level_company_id,
1279: FII_LOGIN_ID
1280: FROM FII_COMPANY_HIER_GT;
1281:
1282: IF (FIIDIM_Debug) THEN
1283: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_COMPANY_HIERS');
1284: END IF;
1285:
1286: --Call FND_STATS to collect statistics after re-populating the tables.
1287: --for the full dimension table since it will be used later
1286: --Call FND_STATS to collect statistics after re-populating the tables.
1287: --for the full dimension table since it will be used later
1288: FND_STATS.gather_table_stats
1289: (ownname => g_schema_name,
1290: tabname => 'FII_FULL_COMPANY_HIERS');
1291:
1292: --==============================================================--
1293:
1294: --Delete/Update FII_company_HIER_GT for pruned hierarchy table
1448:
1449: Flatten_CO_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1450:
1451: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1452: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1453:
1454: Insert into FII_FULL_COMPANY_HIERS (
1455: parent_level,
1456: parent_company_id,
1450:
1451: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1452: FII_UTIL.truncate_table ('FII_FULL_COMPANY_HIERS', 'FII', g_retcode);
1453:
1454: Insert into FII_FULL_COMPANY_HIERS (
1455: parent_level,
1456: parent_company_id,
1457: next_level,
1458: next_level_company_id,
1484: FII_LOGIN_ID
1485: FROM FII_COMPANY_HIER_GT;
1486:
1487: IF (FIIDIM_Debug) THEN
1488: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COMPANY_HIERS');
1489: END IF;
1490:
1491: --Call FND_STATS to collect statistics after re-populating the tables.
1492: --for the full dimension table since it will be used later
1491: --Call FND_STATS to collect statistics after re-populating the tables.
1492: --for the full dimension table since it will be used later
1493: FND_STATS.gather_table_stats
1494: (ownname => g_schema_name,
1495: tabname => 'FII_FULL_COMPANY_HIERS');
1496:
1497: --==============================================================--
1498:
1499: --Delete/Update FII_company_HIER_GT for pruned hierarchy table