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_UDD2_MAINTAIN_PKG dependencies on FII_FULL_UDD2_HIERS

Line 965: FROM FII_FULL_UDD2_HIERS fh

961: (PARENT_USER_DIM2_ID,
962: CHILD_USER_DIM2_ID)
963: SELECT fh.parent_value_id,
964: fh.child_value_id
965: FROM FII_FULL_UDD2_HIERS fh
966: WHERE fh.parent_value_id IN
967: (SELECT ph.parent_value_id
968: FROM FII_UDD2_HIERARCHIES ph
969: WHERE ph.is_leaf_flag = 'Y');

Line 1113: select count(*) into l_count from fii_full_udd2_hiers;

1109: -- before also since truncation of the tables does not let
1110: -- incremental refresh of MV happen.
1111: -- If the dimension hierarchy table has 1 record then the dimension
1112: -- was disabled previously.
1113: select count(*) into l_count from fii_full_udd2_hiers;
1114:
1115: IF(l_count > 1 OR l_count = 0) THEN
1116: -- Incase the dimension hierarchy table had more than 1 record
1117: -- this means the dimension was enabled previously and it has been

Line 1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1118: -- disabled now, in which case initial refresh of MV should happen
1119: -- so it is ok to truncate the tables
1120:
1121: g_phase := 'Truncate dimension hierarchy tables';
1122: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1123: FII_UTIL.truncate_table ('FII_UDD2_HIERARCHIES', 'FII', g_retcode);
1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1125:
1126: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';

Line 1128: INSERT INTO FII_FULL_UDD2_HIERS

1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1125:
1126: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1127:
1128: INSERT INTO FII_FULL_UDD2_HIERS
1129: (parent_level,
1130: parent_value_id,
1131: next_level,
1132: next_level_value_id,

Line 1269: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1265:
1266: --Copy TMP hierarchy table to the final dimension table
1267: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1268:
1269: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1270:
1271: INSERT /*+ APPEND */ INTO FII_FULL_UDD2_HIERS (
1272: parent_level,
1273: parent_value_id,

Line 1271: INSERT /+ APPEND / INTO FII_FULL_UDD2_HIERS (

1267: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1268:
1269: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1270:
1271: INSERT /*+ APPEND */ INTO FII_FULL_UDD2_HIERS (
1272: parent_level,
1273: parent_value_id,
1274: next_level,
1275: next_level_value_id,

Line 1306: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD2_HIERS');

1302: FII_LOGIN_ID
1303: FROM FII_UDD2_HIER_GT;
1304:
1305: IF (FIIDIM_Debug) THEN
1306: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows in FII_FULL_UDD2_HIERS');
1307: END IF;
1308:
1309: --Call FND_STATS to collect statistics after re-populating the tables.
1310: --for the full dimension table since it will be used later

Line 1313: tabname => 'FII_FULL_UDD2_HIERS');

1309: --Call FND_STATS to collect statistics after re-populating the tables.
1310: --for the full dimension table since it will be used later
1311: FND_STATS.gather_table_stats
1312: (ownname => g_schema_name,
1313: tabname => 'FII_FULL_UDD2_HIERS');
1314:
1315: --==============================================================--
1316:
1317: --Delete/Update FII_UDD2_HIER_GT for pruned hierarchy table

Line 1517: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);

1513:
1514: Flatten_UD2_Dim_Hier (G_MASTER_VALUE_SET_ID, G_TOP_NODE_VALUE);
1515:
1516: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1517: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1518:
1519: Insert into FII_FULL_UDD2_HIERS (
1520: parent_level,
1521: parent_value_id,

Line 1519: Insert into FII_FULL_UDD2_HIERS (

1515:
1516: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1517: FII_UTIL.truncate_table ('FII_FULL_UDD2_HIERS', 'FII', g_retcode);
1518:
1519: Insert into FII_FULL_UDD2_HIERS (
1520: parent_level,
1521: parent_value_id,
1522: next_level,
1523: next_level_value_id,

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

1549: FII_LOGIN_ID
1550: FROM FII_UDD2_HIER_GT;
1551:
1552: IF (FIIDIM_Debug) THEN
1553: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_UDD2_HIERS');
1554: END IF;
1555:
1556: --Call FND_STATS to collect statistics after re-populating the tables.
1557: --for the full dimension table since it will be used later

Line 1560: tabname => 'FII_FULL_UDD2_HIERS');

1556: --Call FND_STATS to collect statistics after re-populating the tables.
1557: --for the full dimension table since it will be used later
1558: FND_STATS.gather_table_stats
1559: (ownname => g_schema_name,
1560: tabname => 'FII_FULL_UDD2_HIERS');
1561:
1562: --==============================================================--
1563:
1564: --Delete/Update FII_UDD2_HIER_GT for pruned hierarchy table