eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_LOB_MAINTAIN_PKG dependencies on FII_FULL_LOB_HIERS

Line 1196: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);

1192: END IF;
1193:
1194: g_phase := 'Truncate tables';
1195:
1196: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);
1197: FII_UTIL.truncate_table ('FII_LOB_HIERARCHIES', 'FII', g_retcode);
1198:
1199: g_phase := 'INSERT INTO FII_FULL_LOB_HIERS';
1200:

Line 1199: g_phase := 'INSERT INTO FII_FULL_LOB_HIERS';

1195:
1196: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);
1197: FII_UTIL.truncate_table ('FII_LOB_HIERARCHIES', 'FII', g_retcode);
1198:
1199: g_phase := 'INSERT INTO FII_FULL_LOB_HIERS';
1200:
1201: INSERT INTO FII_FULL_LOB_HIERS
1202: (parent_level,
1203: parent_lob_id,

Line 1201: INSERT INTO FII_FULL_LOB_HIERS

1197: FII_UTIL.truncate_table ('FII_LOB_HIERARCHIES', 'FII', g_retcode);
1198:
1199: g_phase := 'INSERT INTO FII_FULL_LOB_HIERS';
1200:
1201: INSERT INTO FII_FULL_LOB_HIERS
1202: (parent_level,
1203: parent_lob_id,
1204: next_level,
1205: next_level_lob_id,

Line 1235: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');

1231: FII_USER_ID,
1232: FII_LOGIN_ID);
1233:
1234: IF (FIIDIM_Debug) THEN
1235: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1236: END IF;
1237:
1238: g_phase := 'INSERT INTO FII_LOB_HIERARCHIES';
1239:

Line 1333: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);

1329:
1330: --Copy TMP hierarchy table to the final dimension table
1331: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1332:
1333: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);
1334:
1335: INSERT /*+ APPEND */ INTO FII_FULL_LOB_HIERS (
1336: parent_level,
1337: parent_lob_id,

Line 1335: INSERT /+ APPEND / INTO FII_FULL_LOB_HIERS (

1331: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1332:
1333: FII_UTIL.truncate_table ('FII_FULL_LOB_HIERS', 'FII', g_retcode);
1334:
1335: INSERT /*+ APPEND */ INTO FII_FULL_LOB_HIERS (
1336: parent_level,
1337: parent_lob_id,
1338: next_level,
1339: next_level_lob_id,

Line 1370: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');

1366: FII_LOGIN_ID
1367: FROM FII_LOB_HIER_GT;
1368:
1369: IF (FIIDIM_Debug) THEN
1370: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1371: END IF;
1372:
1373: --Call FND_STATS to collect statistics after re-populating the tables.
1374: --for the full dimension table since it will be used later

Line 1376: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';

1372:
1373: --Call FND_STATS to collect statistics after re-populating the tables.
1374: --for the full dimension table since it will be used later
1375:
1376: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1377:
1378: FND_STATS.gather_table_stats
1379: (ownname => g_schema_name,
1380: tabname => 'FII_FULL_LOB_HIERS');

Line 1380: tabname => 'FII_FULL_LOB_HIERS');

1376: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1377:
1378: FND_STATS.gather_table_stats
1379: (ownname => g_schema_name,
1380: tabname => 'FII_FULL_LOB_HIERS');
1381:
1382: --==============================================================--
1383:
1384: --Delete/Update FII_LOB_HIER_GT for pruned hierarchy table

Line 1546: -- we need to maintain the permanent table FII_FULL_LOB_HIERS

1542: Flatten_LOB_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1543:
1544: -- Incremental Dimension Maintence
1545: -- All data is now in the temporary table FII_LOB_HIER_GT,
1546: -- we need to maintain the permanent table FII_FULL_LOB_HIERS
1547: -- by diffing the 2 tables.
1548: -- The maintenance is done by 2 statements, one INSERT and one DELETE.
1549: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1550:

Line 1555: g_phase := 'DELETE FROM FII_FULL_LOB_HIERS';

1551: --IF (FIIDIM_Debug) THEN
1552: -- FII_UTIL.Write_Log ('Starting to delete from the final table by diffing');
1553: -- End If;
1554:
1555: g_phase := 'DELETE FROM FII_FULL_LOB_HIERS';
1556:
1557: DELETE FROM FII_FULL_LOB_HIERS
1558: WHERE
1559: (parent_level, parent_lob_id, next_level, next_level_lob_id,

Line 1557: DELETE FROM FII_FULL_LOB_HIERS

1553: -- End If;
1554:
1555: g_phase := 'DELETE FROM FII_FULL_LOB_HIERS';
1556:
1557: DELETE FROM FII_FULL_LOB_HIERS
1558: WHERE
1559: (parent_level, parent_lob_id, next_level, next_level_lob_id,
1560: next_level_is_leaf, is_leaf_flag, child_level, child_lob_id,
1561: parent_flex_value_set_id, child_flex_value_set_id) IN

Line 1565: FROM FII_FULL_LOB_HIERS

1561: parent_flex_value_set_id, child_flex_value_set_id) IN
1562: (SELECT parent_level, parent_lob_id, next_level, next_level_lob_id,
1563: next_level_is_leaf, is_leaf_flag, child_level, child_lob_id,
1564: parent_flex_value_set_id, child_flex_value_set_id
1565: FROM FII_FULL_LOB_HIERS
1566: MINUS
1567: SELECT parent_level, parent_lob_id, next_level, next_level_lob_id,
1568: next_level_is_leaf, is_leaf_flag, child_level, child_lob_id,
1569: parent_flex_value_set_id, child_flex_value_set_id

Line 1573: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FULL_LOB_HIERS');

1569: parent_flex_value_set_id, child_flex_value_set_id
1570: FROM FII_LOB_HIER_GT);
1571:
1572: IF (FIIDIM_Debug) THEN
1573: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_FULL_LOB_HIERS');
1574: END IF;
1575:
1576: --IF (FIIDIM_Debug) THEN
1577: -- FII_UTIL.Write_Log ('Starting to insert into the final table by diffing');

Line 1580: g_phase := 'Insert into FII_FULL_LOB_HIERS';

1576: --IF (FIIDIM_Debug) THEN
1577: -- FII_UTIL.Write_Log ('Starting to insert into the final table by diffing');
1578: --End If;
1579:
1580: g_phase := 'Insert into FII_FULL_LOB_HIERS';
1581:
1582: Insert into FII_FULL_LOB_HIERS (
1583: parent_level,
1584: parent_lob_id,

Line 1582: Insert into FII_FULL_LOB_HIERS (

1578: --End If;
1579:
1580: g_phase := 'Insert into FII_FULL_LOB_HIERS';
1581:
1582: Insert into FII_FULL_LOB_HIERS (
1583: parent_level,
1584: parent_lob_id,
1585: next_level,
1586: next_level_lob_id,

Line 1630: FROM FII_FULL_LOB_HIERS);

1626: FII_USER_ID,
1627: SYSDATE,
1628: FII_USER_ID,
1629: FII_LOGIN_ID
1630: FROM FII_FULL_LOB_HIERS);
1631:
1632: IF (FIIDIM_Debug) THEN
1633: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1634: END IF;

Line 1633: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');

1629: FII_LOGIN_ID
1630: FROM FII_FULL_LOB_HIERS);
1631:
1632: IF (FIIDIM_Debug) THEN
1633: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_LOB_HIERS');
1634: END IF;
1635:
1636: --Call FND_STATS to collect statistics after re-populating the tables.
1637: --for the full dimension table since it will be used later

Line 1639: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';

1635:
1636: --Call FND_STATS to collect statistics after re-populating the tables.
1637: --for the full dimension table since it will be used later
1638:
1639: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1640:
1641: FND_STATS.gather_table_stats
1642: (ownname => g_schema_name,
1643: tabname => 'FII_FULL_LOB_HIERS');

Line 1643: tabname => 'FII_FULL_LOB_HIERS');

1639: g_phase := 'gather_table_stats for FII_FULL_LOB_HIERS';
1640:
1641: FND_STATS.gather_table_stats
1642: (ownname => g_schema_name,
1643: tabname => 'FII_FULL_LOB_HIERS');
1644:
1645: --==============================================================--
1646:
1647: --Delete/Update FII_LOB_HIER_GT for pruned hierarchy table