APPS.FII_UDD1_MAINTAIN_PKG dependencies on FII_UDD1_MAPPING_GT

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 960: INSERT INTO FII_UDD1_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_UDD1_MAPPING_GT
961: (PARENT_USER_DIM1_ID,
962: CHILD_USER_DIM1_ID)
963: SELECT fh.parent_value_id,
964: fh.child_value_id

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

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

Line 981: INSERT INTO FII_UDD1_MAPPING_GT

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
982: (PARENT_USER_DIM1_ID,
983: CHILD_USER_DIM1_ID)
984: SELECT parent_value_id,
985: child_value_id

Line 992: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_MAPPING_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_UDD1_MAPPING_GT');
993: END IF;
994:
995: --------------------------------------------------------
996: -- Gather statistics for the use of cost-based optimizer

Line 1003: tabname => 'FII_UDD1_MAPPING_GT');

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');
1004:
1005: IF (FIIDIM_Debug) THEN
1006: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD1_MAINTAIN_PKG.Get_UD1_Mapping_GT');
1007: END IF;

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 1418: FROM FII_UDD1_MAPPING_GT;

1414: FII_USER_ID,
1415: SYSDATE,
1416: FII_USER_ID,
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;

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 1712: FROM FII_UDD1_MAPPING_GT);

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:
1714: IF (FIIDIM_Debug) THEN
1715: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_UDD1_MAPPINGS');
1716: END IF;

Line 1735: FROM FII_UDD1_MAPPING_GT

1731: FII_USER_ID,
1732: SYSDATE,
1733: FII_USER_ID,
1734: FII_LOGIN_ID
1735: FROM FII_UDD1_MAPPING_GT
1736: MINUS
1737: SELECT PARENT_USER_DIM1_ID,
1738: CHILD_USER_DIM1_ID,
1739: SYSDATE,