DBA Data[Home] [Help]

APPS.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_VALUE_SETS_VL

Line 1412: ' FROM FEM_VALUE_SETS_VL@'||p_source_db_link||' A'||

1408: ' VALUE_SET_NAME, DESCRIPTION, null,'||
1409: ' VALUE_SET_DISPLAY_CODE,'||
1410: ' null,'||
1411: ' READ_ONLY_FLAG'||
1412: ' FROM FEM_VALUE_SETS_VL@'||p_source_db_link||' A'||
1413: ' WHERE A.DIMENSION_ID = '||gv_src_dim_props_rec.DIMENSION_ID||
1414: ' AND NOT EXISTS (SELECT 1'||
1415: ' FROM FEM_VALUE_SETS_VL'||
1416: ' WHERE VALUE_SET_DISPLAY_CODE = A.VALUE_SET_DISPLAY_CODE)';

Line 1415: ' FROM FEM_VALUE_SETS_VL'||

1411: ' READ_ONLY_FLAG'||
1412: ' FROM FEM_VALUE_SETS_VL@'||p_source_db_link||' A'||
1413: ' WHERE A.DIMENSION_ID = '||gv_src_dim_props_rec.DIMENSION_ID||
1414: ' AND NOT EXISTS (SELECT 1'||
1415: ' FROM FEM_VALUE_SETS_VL'||
1416: ' WHERE VALUE_SET_DISPLAY_CODE = A.VALUE_SET_DISPLAY_CODE)';
1417:
1418: TYPE INSERT_VS_CURSOR_TYPE IS REF CURSOR;
1419:

Line 1459: FROM FEM_VALUE_SETS_VL

1455: BEGIN
1456:
1457: SELECT VALUE_SET_NAME
1458: INTO l_dup_vs_name
1459: FROM FEM_VALUE_SETS_VL
1460: WHERE VALUE_SET_NAME = l_vs_name(i);
1461:
1462: IF (SQL%FOUND) THEN
1463: FEM_ENGINES_PKG.TECH_MESSAGE