APPS.FII_UDD2_MAINTAIN_PKG dependencies on FII_UDD2_MAPPING_GT

Line 960: INSERT INTO FII_UDD2_MAPPING_GT

956: --Note this already includes all self leaf records
957: g_phase := 'populate FII_FIN_CAT_MAPPING_GT with truncated portion';
958:
959:
960: INSERT INTO FII_UDD2_MAPPING_GT
961: (PARENT_USER_DIM2_ID,
962: CHILD_USER_DIM2_ID)
963: SELECT fh.parent_value_id,
964: fh.child_value_id

Line 981: INSERT INTO FII_UDD2_MAPPING_GT

977: --FII_UDD2_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_UDD2_MAPPING_GT
982: (PARENT_USER_DIM2_ID,
983: CHILD_USER_DIM2_ID)
984: SELECT parent_value_id,
985: child_value_id

Line 1000: tabname => 'FII_UDD2_MAPPING_GT');

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');
1001:
1002: IF (FIIDIM_Debug) THEN
1003: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD2_MAINTAIN_PKG.Get_UD2_Mapping_GT');
1004: END IF;

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 1412: FROM FII_UDD2_MAPPING_GT;

1408: FII_USER_ID,
1409: SYSDATE,
1410: FII_USER_ID,
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;

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 1699: FROM FII_UDD2_MAPPING_GT);

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:
1701: IF (FIIDIM_Debug) THEN
1702: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD2_MAPPINGS');
1703: END IF;

Line 1722: FROM FII_UDD2_MAPPING_GT

1718: FII_USER_ID,
1719: SYSDATE,
1720: FII_USER_ID,
1721: FII_LOGIN_ID
1722: FROM FII_UDD2_MAPPING_GT
1723: MINUS
1724: SELECT PARENT_USER_DIM2_ID,
1725: CHILD_USER_DIM2_ID,
1726: SYSDATE,