[Home] [Help]
1092: -- before also since truncation of the tables does not let
1093: -- incremental refresh of MV happen.
1094: -- If the dimension hierarchy table has 1 record then the dimension
1095: -- was disabled previously.
1096: select count(*) into l_count from fii_full_cost_ctr_hiers;
1097:
1098: IF(l_count > 1 OR l_count = 0) THEN
1099: -- Incase the dimension hierarchy table had more than 1 record
1100: -- this means the dimension was enabled previously and it has been
1101: -- disabled now, in which case initial refresh of MV should happen
1102: -- so it is ok to truncate the tables
1103:
1104: g_phase := 'Truncate dimension hierarchy tables';
1105: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1106: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);
1107:
1108: INSERT INTO FII_FULL_COST_CTR_HIERS
1109: (parent_level,
1104: g_phase := 'Truncate dimension hierarchy tables';
1105: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1106: FII_UTIL.truncate_table ('FII_COST_CTR_HIERARCHIES', 'FII', g_retcode);
1107:
1108: INSERT INTO FII_FULL_COST_CTR_HIERS
1109: (parent_level,
1110: parent_cc_id,
1111: next_level,
1112: next_level_cc_id,
1230:
1231: --Copy TMP hierarchy table to the final dimension table
1232: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1233:
1234: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1235:
1236: INSERT /*+ APPEND */ INTO FII_FULL_COST_CTR_HIERS (
1237: parent_level,
1238: parent_cc_id,
1232: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1233:
1234: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1235:
1236: INSERT /*+ APPEND */ INTO FII_FULL_COST_CTR_HIERS (
1237: parent_level,
1238: parent_cc_id,
1239: next_level,
1240: next_level_cc_id,
1267: FII_LOGIN_ID
1268: FROM FII_COST_CTR_HIER_GT;
1269:
1270: IF (FIIDIM_Debug) THEN
1271: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1272: END IF;
1273:
1274:
1275: --Call FND_STATS to collect statistics after re-populating the tables.
1275: --Call FND_STATS to collect statistics after re-populating the tables.
1276: --for the full dimension table since it will be used later
1277: FND_STATS.gather_table_stats
1278: (ownname => g_schema_name,
1279: tabname => 'FII_FULL_COST_CTR_HIERS');
1280:
1281: --==============================================================--
1282:
1283: --Delete/Update FII_CC_HIER_GT for pruned hierarchy table
1437: Flatten_CC_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1438:
1439:
1440: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1441: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1442:
1443: Insert into FII_FULL_COST_CTR_HIERS (
1444: parent_level,
1445: parent_cc_id,
1439:
1440: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1441: FII_UTIL.truncate_table ('FII_FULL_COST_CTR_HIERS', 'FII', g_retcode);
1442:
1443: Insert into FII_FULL_COST_CTR_HIERS (
1444: parent_level,
1445: parent_cc_id,
1446: next_level,
1447: next_level_cc_id,
1473: FII_LOGIN_ID
1474: FROM FII_COST_CTR_HIER_GT;
1475:
1476: IF (FIIDIM_Debug) THEN
1477: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_COST_CTR_HIERS');
1478: END IF;
1479:
1480: --Call FND_STATS to collect statistics after re-populating the tables.
1481: --for the full dimension table since it will be used later
1480: --Call FND_STATS to collect statistics after re-populating the tables.
1481: --for the full dimension table since it will be used later
1482: FND_STATS.gather_table_stats
1483: (ownname => g_schema_name,
1484: tabname => 'FII_FULL_COST_CTR_HIERS');
1485:
1486: --==============================================================--
1487:
1488: --Delete/Update FII_CC_HIER_GT for pruned hierarchy table