DBA Data[Home] [Help]

APPS.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 183: DIMENSION_ID FEM_XDIM_DIMENSIONS.DIMENSION_ID%TYPE,

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,

Line 186: USER_DEFINED_FLAG FEM_XDIM_DIMENSIONS.USER_DEFINED_FLAG%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,

Line 187: GROUP_USE_CODE FEM_XDIM_DIMENSIONS.GROUP_USE_CODE%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,

Line 188: SIMPLE_DIMENSION_FLAG FEM_XDIM_DIMENSIONS.SIMPLE_DIMENSION_FLAG%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,

Line 189: VALUE_SET_REQUIRED_FLAG FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%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,

Line 190: INTF_MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_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,

Line 191: INTF_MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_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,

Line 192: INTF_ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.INTF_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,

Line 193: MEMBER_B_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%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,

Line 194: MEMBER_TL_TABLE_NAME FEM_XDIM_DIMENSIONS.MEMBER_TL_TABLE_NAME %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,

Line 195: ATTRIBUTE_TABLE_NAME FEM_XDIM_DIMENSIONS.ATTRIBUTE_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,
199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%TYPE,

Line 196: MEMBER_COL FEM_XDIM_DIMENSIONS.MEMBER_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,

Line 197: MEMBER_DISPLAY_CODE_COL FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%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);

Line 198: MEMBER_NAME_COL FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%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:

Line 199: MEMBER_DESCRIPTION_COL FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%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:
203:

Line 200: HIERARCHY_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_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:
204: FUNCTION GET_ATTR_ASSIGN_VALUE(p_source_db_link IN VARCHAR2,

Line 201: HIERARCHY_INTF_TABLE_NAME FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%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,
205: p_dimension_id IN NUMBER,