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_MAPPINGS

Line 943: -- Populate FII_UDD1_MAPPING_GT Table for FII_UDD1_MAPPINGS

939: END Flatten_UD1_Dim_Hier;
940:
941:
942: -- **************************************************************************
943: -- Populate FII_UDD1_MAPPING_GT Table for FII_UDD1_MAPPINGS
944:
945: PROCEDURE Get_UD1_Mapping_GT IS
946:
947: Begin

Line 999: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS_GT';

995: --------------------------------------------------------
996: -- Gather statistics for the use of cost-based optimizer
997: --------------------------------------------------------
998: --Call FND_STATS to collect statistics after populating the table
999: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS_GT';
1000:
1001: FND_STATS.gather_table_stats
1002: (ownname => g_schema_name,
1003: tabname => 'FII_UDD1_MAPPING_GT');

Line 1126: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);

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:
1130: INSERT INTO FII_FULL_UDD1_HIERS

Line 1202: INSERT INTO FII_UDD1_MAPPINGS(

1198: FII_LOGIN_ID);
1199:
1200: g_phase := 'Inserting UNASSIGNED record in Mappings table';
1201:
1202: INSERT INTO FII_UDD1_MAPPINGS(
1203: PARENT_USER_DIM1_ID ,
1204: CHILD_USER_DIM1_ID ,
1205: LAST_UPDATE_DATE ,
1206: LAST_UPDATED_BY ,

Line 1392: --Populate FII_UDD1_MAPPINGS table

1388: commit;
1389:
1390: --================================================================--
1391:
1392: --Populate FII_UDD1_MAPPINGS table
1393: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1394:
1395: Get_UD1_Mapping_GT;
1396:

Line 1393: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';

1389:
1390: --================================================================--
1391:
1392: --Populate FII_UDD1_MAPPINGS table
1393: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1394:
1395: Get_UD1_Mapping_GT;
1396:
1397: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS

Line 1397: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS

1393: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1394:
1395: Get_UD1_Mapping_GT;
1396:
1397: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS
1398: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1399:
1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1401:

Line 1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);

1396:
1397: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS
1398: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1399:
1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1401:
1402: INSERT /*+ APPEND */ INTO FII_UDD1_MAPPINGS (
1403: PARENT_USER_DIM1_ID,
1404: CHILD_USER_DIM1_ID,

Line 1402: INSERT /+ APPEND / INTO FII_UDD1_MAPPINGS (

1398: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1399:
1400: FII_UTIL.truncate_table ('FII_UDD1_MAPPINGS', 'FII', g_retcode);
1401:
1402: INSERT /*+ APPEND */ INTO FII_UDD1_MAPPINGS (
1403: PARENT_USER_DIM1_ID,
1404: CHILD_USER_DIM1_ID,
1405: creation_date,
1406: created_by,

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

1417: FII_LOGIN_ID
1418: FROM FII_UDD1_MAPPING_GT;
1419:
1420: IF (FIIDIM_Debug) THEN
1421: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPINGS');
1422: END IF;
1423:
1424: --------------------------------------------------------
1425: -- Gather statistics for the use of cost-based optimizer

Line 1429: g_phase := 'gather_table_stats FII_UDD1_MAPPINGS';

1425: -- Gather statistics for the use of cost-based optimizer
1426: --------------------------------------------------------
1427: --Call FND_STATS to collect statistics after re-populating the table.
1428:
1429: g_phase := 'gather_table_stats FII_UDD1_MAPPINGS';
1430:
1431: FND_STATS.gather_table_stats
1432: (ownname => g_schema_name,
1433: tabname => 'FII_UDD1_MAPPINGS');

Line 1433: tabname => 'FII_UDD1_MAPPINGS');

1429: g_phase := 'gather_table_stats FII_UDD1_MAPPINGS';
1430:
1431: FND_STATS.gather_table_stats
1432: (ownname => g_schema_name,
1433: tabname => 'FII_UDD1_MAPPINGS');
1434:
1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';
1436:
1437: FND_STATS.gather_table_stats

Line 1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';

1431: FND_STATS.gather_table_stats
1432: (ownname => g_schema_name,
1433: tabname => 'FII_UDD1_MAPPINGS');
1434:
1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';
1436:
1437: FND_STATS.gather_table_stats
1438: (ownname => g_schema_name,
1439: tabname => 'MLOG$_FII_UDD1_MAPPINGS');

Line 1439: tabname => 'MLOG$_FII_UDD1_MAPPINGS');

1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';
1436:
1437: FND_STATS.gather_table_stats
1438: (ownname => g_schema_name,
1439: tabname => 'MLOG$_FII_UDD1_MAPPINGS');
1440:
1441: --=====================================================================
1442:
1443: FND_CONCURRENT.Af_Commit;

Line 1695: --Populate FII_UDD1_MAPPINGS table

1691: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1692:
1693: --=============================================================--
1694:
1695: --Populate FII_UDD1_MAPPINGS table
1696: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1697:
1698: Get_UD1_Mapping_GT;
1699:

Line 1696: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';

1692:
1693: --=============================================================--
1694:
1695: --Populate FII_UDD1_MAPPINGS table
1696: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1697:
1698: Get_UD1_Mapping_GT;
1699:
1700: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS

Line 1700: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS

1696: g_phase := 'Populate FII_UDD1_MAPPINGS_GT table';
1697:
1698: Get_UD1_Mapping_GT;
1699:
1700: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS
1701: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1702:
1703: g_phase := 'DELETE FROM FII_UDD1_MAPPINGS';
1704:

Line 1703: g_phase := 'DELETE FROM FII_UDD1_MAPPINGS';

1699:
1700: --Copy FII_UDD1_MAPPING_GT to FII_UDD1_MAPPINGS
1701: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1702:
1703: g_phase := 'DELETE FROM FII_UDD1_MAPPINGS';
1704:
1705: DELETE FROM FII_UDD1_MAPPINGS
1706: WHERE
1707: (PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID) IN

Line 1705: DELETE FROM FII_UDD1_MAPPINGS

1701: g_phase := 'Copy TMP UD1 Mapping table to the UD1 Mapping Table';
1702:
1703: g_phase := 'DELETE FROM FII_UDD1_MAPPINGS';
1704:
1705: DELETE FROM FII_UDD1_MAPPINGS
1706: WHERE
1707: (PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID) IN
1708: (SELECT PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID
1709: FROM FII_UDD1_MAPPINGS

Line 1709: FROM FII_UDD1_MAPPINGS

1705: DELETE FROM FII_UDD1_MAPPINGS
1706: WHERE
1707: (PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID) IN
1708: (SELECT PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID
1709: FROM FII_UDD1_MAPPINGS
1710: MINUS
1711: SELECT PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID
1712: FROM FII_UDD1_MAPPING_GT);
1713:

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

1711: SELECT PARENT_USER_DIM1_ID, CHILD_USER_DIM1_ID
1712: FROM FII_UDD1_MAPPING_GT);
1713:
1714: IF (FIIDIM_Debug) THEN
1715: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_MAPPINGS');
1716: END IF;
1717:
1718: g_phase := 'Insert into FII_UDD1_MAPPINGS';
1719:

Line 1718: g_phase := 'Insert into FII_UDD1_MAPPINGS';

1714: IF (FIIDIM_Debug) THEN
1715: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_MAPPINGS');
1716: END IF;
1717:
1718: g_phase := 'Insert into FII_UDD1_MAPPINGS';
1719:
1720: Insert into FII_UDD1_MAPPINGS (
1721: PARENT_USER_DIM1_ID,
1722: CHILD_USER_DIM1_ID,

Line 1720: Insert into FII_UDD1_MAPPINGS (

1716: END IF;
1717:
1718: g_phase := 'Insert into FII_UDD1_MAPPINGS';
1719:
1720: Insert into FII_UDD1_MAPPINGS (
1721: PARENT_USER_DIM1_ID,
1722: CHILD_USER_DIM1_ID,
1723: creation_date,
1724: created_by,

Line 1744: FROM FII_UDD1_MAPPINGS);

1740: FII_USER_ID,
1741: SYSDATE,
1742: FII_USER_ID,
1743: FII_LOGIN_ID
1744: FROM FII_UDD1_MAPPINGS);
1745:
1746: IF (FIIDIM_Debug) THEN
1747: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPINGS');
1748: END IF;

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

1743: FII_LOGIN_ID
1744: FROM FII_UDD1_MAPPINGS);
1745:
1746: IF (FIIDIM_Debug) THEN
1747: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPINGS');
1748: END IF;
1749:
1750: --------------------------------------------------------
1751: -- Gather statistics for the use of cost-based optimizer

Line 1755: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS';

1751: -- Gather statistics for the use of cost-based optimizer
1752: --------------------------------------------------------
1753: --Call FND_STATS to collect statistics after re-populating the table.
1754:
1755: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS';
1756:
1757: FND_STATS.gather_table_stats
1758: (ownname => g_schema_name,
1759: tabname => 'FII_UDD1_MAPPINGS');

Line 1759: tabname => 'FII_UDD1_MAPPINGS');

1755: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS';
1756:
1757: FND_STATS.gather_table_stats
1758: (ownname => g_schema_name,
1759: tabname => 'FII_UDD1_MAPPINGS');
1760:
1761: -- Bug 4200473. Not to analyze MLOG in incremental run.
1762: -- As per performance teams suggestions.
1763:

Line 1764: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_MAPPINGS';

1760:
1761: -- Bug 4200473. Not to analyze MLOG in incremental run.
1762: -- As per performance teams suggestions.
1763:
1764: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_MAPPINGS';
1765:
1766: -- FND_STATS.gather_table_stats
1767: -- (ownname => g_schema_name,
1768: -- tabname => 'MLOG$_FII_UDD1_MAPPINGS');

Line 1768: -- tabname => 'MLOG$_FII_UDD1_MAPPINGS');

1764: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_MAPPINGS';
1765:
1766: -- FND_STATS.gather_table_stats
1767: -- (ownname => g_schema_name,
1768: -- tabname => 'MLOG$_FII_UDD1_MAPPINGS');
1769:
1770: --=====================================================================
1771:
1772: