DBA Data[Home] [Help]

APPS.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 2404: ' FROM FEM_OBJECT_CATALOG_VL@'||p_source_db_link||' A,'||

2400: l_folder_name VARCHAR2(150);
2401:
2402:
2403: l_hier_rule_sql VARCHAR2(1000):= 'SELECT A.OBJECT_ID, B.FOLDER_NAME'||
2404: ' FROM FEM_OBJECT_CATALOG_VL@'||p_source_db_link||' A,'||
2405: ' FEM_FOLDERS_VL@'||p_source_db_link||' B'||
2406: ' WHERE A.OBJECT_TYPE_CODE = ''HIERARCHY'''||
2407: ' AND A.FOLDER_ID = B.FOLDER_ID'||
2408: ' AND A.OBJECT_NAME = :hier_obj_name';

Line 2676: ' FROM FEM_OBJECT_CATALOG_VL@'||p_source_db_link||' A'||

2672: l_msg_count NUMBER;
2673: l_msg_data VARCHAR2(4000);
2674:
2675: l_hier_rule_sql VARCHAR2(1000):= 'SELECT A.OBJECT_ID'||
2676: ' FROM FEM_OBJECT_CATALOG_VL@'||p_source_db_link||' A'||
2677: ' WHERE A.OBJECT_TYPE_CODE = ''HIERARCHY'''||
2678: ' AND A.OBJECT_NAME = :hier_obj_name';
2679:
2680: l_hier_version_sql VARCHAR2(1000):= 'SELECT B.OBJECT_DEFINITION_ID,'||

Line 2697: FROM FEM_OBJECT_CATALOG_VL

2693: BEGIN
2694:
2695: SELECT OBJECT_ID
2696: INTO l_target_obj_id
2697: FROM FEM_OBJECT_CATALOG_VL
2698: WHERE OBJECT_NAME = p_hier_obj_name;
2699:
2700: EXCEPTION
2701: