DBA Data[Home] [Help]

APPS.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_XDIM_DIMENSIONS_VL

Line 244: 'FROM FEM_XDIM_DIMENSIONS_VL '||'@'||p_source_db_link||' '||

240: 'MEMBER_COL, '||
241: 'DECODE(LOADER_OBJECT_DEF_ID, NULL, NULL, LOADER_OBJECT_DEF_ID+ 700), '||
242: 'HIERARCHY_TABLE_NAME, '||
243: 'DECODE(HIERARCHY_TABLE_NAME, NULL, NULL, HIERARCHY_TABLE_NAME||''_T'')'||
244: 'FROM FEM_XDIM_DIMENSIONS_VL '||'@'||p_source_db_link||' '||
245: 'WHERE DIMENSION_NAME = :p_source_user_dim_name';
246:
247: BEGIN
248:

Line 285: FROM FEM_XDIM_DIMENSIONS_VL

281: gv_dim_props_rec.MEMBER_TL_TABLE_NAME,
282: gv_dim_props_rec.MEMBER_COL,
283: gv_dim_props_rec.HIERARCHY_TABLE_NAME,
284: gv_dim_props_rec.HIERARCHY_INTF_TABLE_NAME
285: FROM FEM_XDIM_DIMENSIONS_VL
286: WHERE DIMENSION_VARCHAR_LABEL = UPPER(p_dim_name);
287:
288:
289: IF (gv_dim_props_rec.MIGRATION_OBJ_DEF_ID IS NULL) THEN