179: TYPE lang_type IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER;
180: TYPE varchar2_1000_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
181:
182: TYPE DIMENSION_PROPS_REC IS RECORD(
183: DIMENSION_ID FEM_XDIM_DIMENSIONS.DIMENSION_ID%TYPE,
184: MIGRATION_OBJ_ID NUMBER,
185: MIGRATION_OBJ_DEF_ID NUMBER,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
182: TYPE DIMENSION_PROPS_REC IS RECORD(
183: DIMENSION_ID FEM_XDIM_DIMENSIONS.DIMENSION_ID%TYPE,
184: MIGRATION_OBJ_ID NUMBER,
185: MIGRATION_OBJ_DEF_ID NUMBER,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
183: DIMENSION_ID FEM_XDIM_DIMENSIONS.DIMENSION_ID%TYPE,
184: MIGRATION_OBJ_ID NUMBER,
185: MIGRATION_OBJ_DEF_ID NUMBER,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
184: MIGRATION_OBJ_ID NUMBER,
185: MIGRATION_OBJ_DEF_ID NUMBER,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
185: MIGRATION_OBJ_DEF_ID NUMBER,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_B_TABLE_NAME%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_MEMBER_TL_TABLE_NAME%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_ATTRIBUTE_TABLE_NAME %TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE,
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE);
194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %TYPE,
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE);
202:
195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%TYPE,
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE);
202:
203:
196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE);
202:
203:
204: FUNCTION GET_ATTR_ASSIGN_VALUE(p_source_db_link IN VARCHAR2,
197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE,
198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%TYPE,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,
200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE,
201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%TYPE);
202:
203:
204: FUNCTION GET_ATTR_ASSIGN_VALUE(p_source_db_link IN VARCHAR2,
205: p_dimension_id IN NUMBER,