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_UDD2_MAPPINGS

Line 943: -- Populate FII_UDD2_MAPPINGS_GT Table for FII_UDD2_MAPPINGS

939: END Flatten_UD2_Dim_Hier;
940:
941:
942: -- **************************************************************************
943: -- Populate FII_UDD2_MAPPINGS_GT Table for FII_UDD2_MAPPINGS
944:
945: PROCEDURE Get_UD2_Mapping_GT IS
946:
947: Begin

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

968: FROM FII_UDD2_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_UDD2_MAPPINGS_GT');
973: END IF;
974:
975:
976: --Then, insert self-mapping records for all nodes in pruned hierarchy

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

988: AND parent_value_id = child_value_id
989: AND is_leaf_flag = 'N';
990:
991: IF (FIIDIM_Debug) THEN
992: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS_GT');
993: END IF;
994:
995: --Call FND_STATS to collect statistics after populating the table
996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';

Line 996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';

992: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS_GT');
993: END IF;
994:
995: --Call FND_STATS to collect statistics after populating the table
996: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS_GT';
997:
998: FND_STATS.gather_table_stats
999: (ownname => g_schema_name,
1000: tabname => 'FII_UDD2_MAPPING_GT');

Line 1124: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);

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';
1127:
1128: INSERT INTO FII_FULL_UDD2_HIERS

Line 1200: INSERT INTO FII_UDD2_MAPPINGS(

1196: FII_LOGIN_ID);
1197:
1198: g_phase := 'Inserting UNASSIGNED record in Mappings table';
1199:
1200: INSERT INTO FII_UDD2_MAPPINGS(
1201: PARENT_USER_DIM2_ID ,
1202: CHILD_USER_DIM2_ID ,
1203: LAST_UPDATE_DATE ,
1204: LAST_UPDATED_BY ,

Line 1386: --Populate FII_UDD2_MAPPINGS table

1382: commit;
1383:
1384: --================================================================--
1385:
1386: --Populate FII_UDD2_MAPPINGS table
1387: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1388:
1389: Get_UD2_Mapping_GT;
1390:

Line 1387: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';

1383:
1384: --================================================================--
1385:
1386: --Populate FII_UDD2_MAPPINGS table
1387: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1388:
1389: Get_UD2_Mapping_GT;
1390:
1391: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS

Line 1391: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS

1387: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1388:
1389: Get_UD2_Mapping_GT;
1390:
1391: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS
1392: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1393:
1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1395:

Line 1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);

1390:
1391: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS
1392: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1393:
1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1395:
1396: INSERT /*+ APPEND */ INTO FII_UDD2_MAPPINGS (
1397: PARENT_USER_DIM2_ID,
1398: CHILD_USER_DIM2_ID,

Line 1396: INSERT /+ APPEND / INTO FII_UDD2_MAPPINGS (

1392: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1393:
1394: FII_UTIL.truncate_table ('FII_UDD2_MAPPINGS', 'FII', g_retcode);
1395:
1396: INSERT /*+ APPEND */ INTO FII_UDD2_MAPPINGS (
1397: PARENT_USER_DIM2_ID,
1398: CHILD_USER_DIM2_ID,
1399: creation_date,
1400: created_by,

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

1411: FII_LOGIN_ID
1412: FROM FII_UDD2_MAPPING_GT;
1413:
1414: IF (FIIDIM_Debug) THEN
1415: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1416: END IF;
1417:
1418: --Call FND_STATS to collect statistics after re-populating the table.
1419:

Line 1420: g_phase := 'gather_table_stats FII_UDD2_MAPPINGS';

1416: END IF;
1417:
1418: --Call FND_STATS to collect statistics after re-populating the table.
1419:
1420: g_phase := 'gather_table_stats FII_UDD2_MAPPINGS';
1421:
1422: FND_STATS.gather_table_stats
1423: (ownname => g_schema_name,
1424: tabname => 'FII_UDD2_MAPPINGS');

Line 1424: tabname => 'FII_UDD2_MAPPINGS');

1420: g_phase := 'gather_table_stats FII_UDD2_MAPPINGS';
1421:
1422: FND_STATS.gather_table_stats
1423: (ownname => g_schema_name,
1424: tabname => 'FII_UDD2_MAPPINGS');
1425:
1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';
1427:
1428: FND_STATS.gather_table_stats

Line 1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';

1422: FND_STATS.gather_table_stats
1423: (ownname => g_schema_name,
1424: tabname => 'FII_UDD2_MAPPINGS');
1425:
1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';
1427:
1428: FND_STATS.gather_table_stats
1429: (ownname => g_schema_name,
1430: tabname => 'MLOG$_FII_UDD2_MAPPINGS');

Line 1430: tabname => 'MLOG$_FII_UDD2_MAPPINGS');

1426: g_phase := 'gather_table_stats MLOG$_FII_UDD2_MAPPINGS';
1427:
1428: FND_STATS.gather_table_stats
1429: (ownname => g_schema_name,
1430: tabname => 'MLOG$_FII_UDD2_MAPPINGS');
1431:
1432: --=====================================================================
1433:
1434: FND_CONCURRENT.Af_Commit;

Line 1682: --Populate FII_UDD2_MAPPINGS table

1678: -- (ownname => g_schema_name,
1679: -- tabname => 'MLOG$_FII_UDD2_HIERARCHIES');
1680: --=============================================================--
1681:
1682: --Populate FII_UDD2_MAPPINGS table
1683: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1684:
1685: Get_UD2_Mapping_GT;
1686:

Line 1683: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';

1679: -- tabname => 'MLOG$_FII_UDD2_HIERARCHIES');
1680: --=============================================================--
1681:
1682: --Populate FII_UDD2_MAPPINGS table
1683: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1684:
1685: Get_UD2_Mapping_GT;
1686:
1687: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS

Line 1687: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS

1683: g_phase := 'Populate FII_UDD2_MAPPINGS_GT table';
1684:
1685: Get_UD2_Mapping_GT;
1686:
1687: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS
1688: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1689:
1690: g_phase := 'DELETE FROM FII_UDD2_MAPPINGS';
1691:

Line 1690: g_phase := 'DELETE FROM FII_UDD2_MAPPINGS';

1686:
1687: --Copy FII_UDD2_MAPPING_GT to FII_UDD2_MAPPINGS
1688: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1689:
1690: g_phase := 'DELETE FROM FII_UDD2_MAPPINGS';
1691:
1692: DELETE FROM FII_UDD2_MAPPINGS
1693: WHERE
1694: (PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID) IN

Line 1692: DELETE FROM FII_UDD2_MAPPINGS

1688: g_phase := 'Copy TMP UD2 Mapping table to the UD2 Mapping Table';
1689:
1690: g_phase := 'DELETE FROM FII_UDD2_MAPPINGS';
1691:
1692: DELETE FROM FII_UDD2_MAPPINGS
1693: WHERE
1694: (PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID) IN
1695: (SELECT PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID
1696: FROM FII_UDD2_MAPPINGS

Line 1696: FROM FII_UDD2_MAPPINGS

1692: DELETE FROM FII_UDD2_MAPPINGS
1693: WHERE
1694: (PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID) IN
1695: (SELECT PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID
1696: FROM FII_UDD2_MAPPINGS
1697: MINUS
1698: SELECT PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID
1699: FROM FII_UDD2_MAPPING_GT);
1700:

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

1698: SELECT PARENT_USER_DIM2_ID, CHILD_USER_DIM2_ID
1699: FROM FII_UDD2_MAPPING_GT);
1700:
1701: IF (FIIDIM_Debug) THEN
1702: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD2_MAPPINGS');
1703: END IF;
1704:
1705: g_phase := 'Insert into FII_UDD2_MAPPINGS';
1706:

Line 1705: g_phase := 'Insert into FII_UDD2_MAPPINGS';

1701: IF (FIIDIM_Debug) THEN
1702: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD2_MAPPINGS');
1703: END IF;
1704:
1705: g_phase := 'Insert into FII_UDD2_MAPPINGS';
1706:
1707: Insert into FII_UDD2_MAPPINGS (
1708: PARENT_USER_DIM2_ID,
1709: CHILD_USER_DIM2_ID,

Line 1707: Insert into FII_UDD2_MAPPINGS (

1703: END IF;
1704:
1705: g_phase := 'Insert into FII_UDD2_MAPPINGS';
1706:
1707: Insert into FII_UDD2_MAPPINGS (
1708: PARENT_USER_DIM2_ID,
1709: CHILD_USER_DIM2_ID,
1710: creation_date,
1711: created_by,

Line 1731: FROM FII_UDD2_MAPPINGS);

1727: FII_USER_ID,
1728: SYSDATE,
1729: FII_USER_ID,
1730: FII_LOGIN_ID
1731: FROM FII_UDD2_MAPPINGS);
1732:
1733: IF (FIIDIM_Debug) THEN
1734: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1735: END IF;

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

1730: FII_LOGIN_ID
1731: FROM FII_UDD2_MAPPINGS);
1732:
1733: IF (FIIDIM_Debug) THEN
1734: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD2_MAPPINGS');
1735: END IF;
1736:
1737: --Call FND_STATS to collect statistics after re-populating the table.
1738:

Line 1739: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS';

1735: END IF;
1736:
1737: --Call FND_STATS to collect statistics after re-populating the table.
1738:
1739: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS';
1740:
1741: FND_STATS.gather_table_stats
1742: (ownname => g_schema_name,
1743: tabname => 'FII_UDD2_MAPPINGS');

Line 1743: tabname => 'FII_UDD2_MAPPINGS');

1739: g_phase := 'gather_table_stats for FII_UDD2_MAPPINGS';
1740:
1741: FND_STATS.gather_table_stats
1742: (ownname => g_schema_name,
1743: tabname => 'FII_UDD2_MAPPINGS');
1744:
1745: -- Bug 4200473. Not to analyze MLOG in incremental run.
1746: -- As per performance teams suggestions.
1747:

Line 1748: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD2_MAPPINGS';

1744:
1745: -- Bug 4200473. Not to analyze MLOG in incremental run.
1746: -- As per performance teams suggestions.
1747:
1748: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD2_MAPPINGS';
1749:
1750: -- FND_STATS.gather_table_stats
1751: -- (ownname => g_schema_name,
1752: -- tabname => 'MLOG$_FII_UDD2_MAPPINGS');

Line 1752: -- tabname => 'MLOG$_FII_UDD2_MAPPINGS');

1748: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD2_MAPPINGS';
1749:
1750: -- FND_STATS.gather_table_stats
1751: -- (ownname => g_schema_name,
1752: -- tabname => 'MLOG$_FII_UDD2_MAPPINGS');
1753:
1754: --=====================================================================
1755:
1756: