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_UDD1_MAINTAIN_PKG dependencies on FII_UDD1_HIERARCHIES

Line 968: FROM FII_UDD1_HIERARCHIES ph

964: fh.child_value_id
965: FROM FII_FULL_UDD1_HIERS fh
966: WHERE fh.parent_value_id IN
967: (SELECT ph.parent_value_id
968: FROM FII_UDD1_HIERARCHIES ph
969: WHERE ph.is_leaf_flag = 'Y');
970:
971: IF (FIIDIM_Debug) THEN
972: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPING_GT');

Line 977: --FII_UDD1_HIERARCHIES. Note we should exclude all self leaf

973: END IF;
974:
975:
976: --Then, insert self-mapping records for all nodes in pruned hierarchy
977: --FII_UDD1_HIERARCHIES. Note we should exclude all self leaf
978: --records since they are inserted in the previous step.
979: g_phase := 'insert self-mapping records for all nodes in pruned hierarchy';
980:
981: INSERT INTO FII_UDD1_MAPPING_GT

Line 986: FROM FII_UDD1_HIERARCHIES

982: (PARENT_USER_DIM1_ID,
983: CHILD_USER_DIM1_ID)
984: SELECT parent_value_id,
985: child_value_id
986: FROM FII_UDD1_HIERARCHIES
987: WHERE child_flex_value_set_id = G_MASTER_VALUE_SET_ID
988: AND parent_value_id = child_value_id
989: AND is_leaf_flag = 'N';
990:

Line 1021: -- Populate the pruned User Defined Dimension1 hierarchy FII_UDD1_HIERARCHIES by deleting from

1017:
1018: END Get_UD1_Mapping_GT;
1019:
1020: -- **************************************************************************
1021: -- Populate the pruned User Defined Dimension1 hierarchy FII_UDD1_HIERARCHIES by deleting from
1022: -- FII_UDD1_HIER_GT (full version) the LVS records
1023:
1024: PROCEDURE Get_Pruned_UD1_GT IS
1025:

Line 1125: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);

1121: -- so it is ok to truncate the tables
1122:
1123: g_phase := 'Truncate dimension hierarchy tables';
1124: FII_UTIL.truncate_table ('FII_FULL_UDD1_HIERS', 'FII', g_retcode);
1125: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1126: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1127:
1128: g_phase := 'Inserting UNASSIGNED record in Full hierarchy';
1129:

Line 1165: INSERT INTO FII_UDD1_HIERARCHIES

1161: FII_LOGIN_ID);
1162:
1163: g_phase := 'Inserting UNASSIGNED record in Pruned hierarchy';
1164:
1165: INSERT INTO FII_UDD1_HIERARCHIES
1166: (parent_level,
1167: parent_value_id,
1168: next_level,
1169: next_level_value_id,

Line 1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);

1326:
1327: --Copy FII_UDD1_HIER_GT to the final (pruned) dimension table
1328: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1329:
1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1331:
1332: INSERT /*+ APPEND */ INTO FII_UDD1_HIERARCHIES (
1333: parent_level,
1334: parent_value_id,

Line 1332: INSERT /+ APPEND / INTO FII_UDD1_HIERARCHIES (

1328: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1329:
1330: FII_UTIL.truncate_table ('FII_UDD1_HIERARCHIES', 'FII', g_retcode);
1331:
1332: INSERT /*+ APPEND */ INTO FII_UDD1_HIERARCHIES (
1333: parent_level,
1334: parent_value_id,
1335: next_level,
1336: next_level_value_id,

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

1367: FII_LOGIN_ID
1368: FROM FII_UDD1_HIER_GT;
1369:
1370: IF (FIIDIM_Debug) THEN
1371: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1372: END IF;
1373:
1374:
1375: -- This will be in RSG data

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

1372: END IF;
1373:
1374:
1375: -- This will be in RSG data
1376: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1377: FND_STATS.gather_table_stats
1378: (ownname => g_schema_name,
1379: tabname => 'FII_UDD1_HIERARCHIES');
1380:

Line 1379: tabname => 'FII_UDD1_HIERARCHIES');

1375: -- This will be in RSG data
1376: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1377: FND_STATS.gather_table_stats
1378: (ownname => g_schema_name,
1379: tabname => 'FII_UDD1_HIERARCHIES');
1380:
1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1382: FND_STATS.gather_table_stats
1383: (ownname => g_schema_name,

Line 1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';

1377: FND_STATS.gather_table_stats
1378: (ownname => g_schema_name,
1379: tabname => 'FII_UDD1_HIERARCHIES');
1380:
1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1382: FND_STATS.gather_table_stats
1383: (ownname => g_schema_name,
1384: tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1385:

Line 1384: tabname => 'MLOG$_FII_UDD1_HIERARCHIES');

1380:
1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1382: FND_STATS.gather_table_stats
1383: (ownname => g_schema_name,
1384: tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1385:
1386: --to avoid ORA-12838: cannot read/modify an object after modifying
1387: --it in parallel (due to the hint APPEND)
1388: commit;

Line 1586: -- we need to maintain the permanent table FII_UDD1_HIERARCHIES

1582: g_phase := 'Copy TMP hierarchy table to the final pruned dimension table';
1583:
1584: -- Incremental Dimension Maintence
1585: -- All data is now in the temporary table FII_UDD1_HIER_GT,
1586: -- we need to maintain the permanent table FII_UDD1_HIERARCHIES
1587: -- by diffing the 2 tables.
1588: -- The maintenance is done by 2 statements, one INSERT and one DELETE.
1589:
1590: DELETE FROM FII_UDD1_HIERARCHIES

Line 1590: DELETE FROM FII_UDD1_HIERARCHIES

1586: -- we need to maintain the permanent table FII_UDD1_HIERARCHIES
1587: -- by diffing the 2 tables.
1588: -- The maintenance is done by 2 statements, one INSERT and one DELETE.
1589:
1590: DELETE FROM FII_UDD1_HIERARCHIES
1591: WHERE
1592: (parent_level, parent_value_id, next_level,
1593: next_level_value_id,
1594: next_level_is_leaf_flag, is_leaf_flag, child_level,

Line 1604: FROM FII_UDD1_HIERARCHIES

1600: next_level, next_level_value_id,
1601: next_level_is_leaf_flag, is_leaf_flag, child_level,
1602: child_value_id,parent_flex_value_set_id,
1603: child_flex_value_set_id, NVL(next_level_value_sort_order, -92883)
1604: FROM FII_UDD1_HIERARCHIES
1605: MINUS
1606: SELECT parent_level, parent_value_id,
1607: next_level, next_level_value_id,
1608: next_level_is_leaf_flag, is_leaf_flag,

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

1612: FROM FII_UDD1_HIER_GT);
1613:
1614:
1615: IF (FIIDIM_Debug) THEN
1616: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_HIERARCHIES');
1617: END IF;
1618:
1619: Insert into FII_UDD1_HIERARCHIES (
1620: parent_level,

Line 1619: Insert into FII_UDD1_HIERARCHIES (

1615: IF (FIIDIM_Debug) THEN
1616: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_HIERARCHIES');
1617: END IF;
1618:
1619: Insert into FII_UDD1_HIERARCHIES (
1620: parent_level,
1621: parent_value_id,
1622: next_level,
1623: next_level_value_id,

Line 1673: FROM FII_UDD1_HIERARCHIES);

1669: FII_USER_ID,
1670: SYSDATE,
1671: FII_USER_ID,
1672: FII_LOGIN_ID
1673: FROM FII_UDD1_HIERARCHIES);
1674:
1675: IF (FIIDIM_Debug) THEN
1676: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1677: END IF;

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

1672: FII_LOGIN_ID
1673: FROM FII_UDD1_HIERARCHIES);
1674:
1675: IF (FIIDIM_Debug) THEN
1676: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1677: END IF;
1678:
1679: -- This will be in RSG data
1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';

Line 1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';

1676: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
1677: END IF;
1678:
1679: -- This will be in RSG data
1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1681: FND_STATS.gather_table_stats
1682: (ownname => g_schema_name,
1683: tabname => 'FII_UDD1_HIERARCHIES');
1684:

Line 1683: tabname => 'FII_UDD1_HIERARCHIES');

1679: -- This will be in RSG data
1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1681: FND_STATS.gather_table_stats
1682: (ownname => g_schema_name,
1683: tabname => 'FII_UDD1_HIERARCHIES');
1684:
1685: -- Bug 4200473. Not to analyze MLOG in incremental run.
1686: -- As per performance teams suggestions.
1687:

Line 1688: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';

1684:
1685: -- Bug 4200473. Not to analyze MLOG in incremental run.
1686: -- As per performance teams suggestions.
1687:
1688: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1689: -- FND_STATS.gather_table_stats
1690: -- (ownname => g_schema_name,
1691: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1692:

Line 1691: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');

1687:
1688: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1689: -- FND_STATS.gather_table_stats
1690: -- (ownname => g_schema_name,
1691: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1692:
1693: --=============================================================--
1694:
1695: --Populate FII_UDD1_MAPPINGS table