eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_BUSAREA_MAINT dependencies on FEM_XDIM_DIMENSIONS

Line 170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;

166: p_dimension_id IN NUMBER)
167: is
168: l_def_hier ZPB_BUSAREA_DIMENSIONS.DEFAULT_HIERARCHY_ID%type;
169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;
170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;

Line 171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

167: is
168: l_def_hier ZPB_BUSAREA_DIMENSIONS.DEFAULT_HIERARCHY_ID%type;
169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;
170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

Line 172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;

168: l_def_hier ZPB_BUSAREA_DIMENSIONS.DEFAULT_HIERARCHY_ID%type;
169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;
170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;

Line 173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;
170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;

Line 174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;

170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
178: l_is_line ZPB_BUSAREA_DIMENSIONS.EPB_LINE_DIMENSION%type;

Line 175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
178: l_is_line ZPB_BUSAREA_DIMENSIONS.EPB_LINE_DIMENSION%type;
179: l_hier NUMBER;

Line 176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;

172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
178: l_is_line ZPB_BUSAREA_DIMENSIONS.EPB_LINE_DIMENSION%type;
179: l_hier NUMBER;
180: l_count NUMBER;

Line 185: l_member_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

181: l_command VARCHAR2(2000);
182: l_logical_dim_id ZPB_BUSAREA_DIMENSIONS.LOGICAL_DIM_ID%type;
183: l_aw_dim_name ZPB_BUSAREA_DIMENSIONS.AW_DIM_NAME%type;
184: l_aw_dim_prefix ZPB_BUSAREA_DIMENSIONS.AW_DIM_PREFIX%type;
185: l_member_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
186: l_dim_type_code FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
187: l_len number;
188: l_suffix varchar2(1);
189: l_start_ascii_value number;

Line 186: l_dim_type_code FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;

182: l_logical_dim_id ZPB_BUSAREA_DIMENSIONS.LOGICAL_DIM_ID%type;
183: l_aw_dim_name ZPB_BUSAREA_DIMENSIONS.AW_DIM_NAME%type;
184: l_aw_dim_prefix ZPB_BUSAREA_DIMENSIONS.AW_DIM_PREFIX%type;
185: l_member_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
186: l_dim_type_code FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
187: l_len number;
188: l_suffix varchar2(1);
189: l_start_ascii_value number;
190: l_ascii_dim_count number;

Line 221: from FEM_XDIM_DIMENSIONS

217:
218: select VALUE_SET_REQUIRED_FLAG,
219: decode(DIMENSION_TYPE_CODE, 'LINE', 'Y', 'N')
220: into l_vs_req, l_is_line
221: from FEM_XDIM_DIMENSIONS
222: where DIMENSION_ID = p_dimension_id;
223:
224: if (l_vs_req = 'Y') then
225: begin

Line 258: from FEM_XDIM_DIMENSIONS A,

254: A.DEFAULT_MEMBER_DISPLAY_CODE,
255: A.ATTRIBUTE_TABLE_NAME
256: into l_cal_dim_id, l_cal_dim_col, l_cal_dim_code,
257: l_dim_table, l_def_mbr_code, l_attr_table
258: from FEM_XDIM_DIMENSIONS A,
259: FEM_DIMENSIONS_B B
260: where A.DIMENSION_ID = B.DIMENSION_ID
261: and B.DIMENSION_VARCHAR_LABEL = 'CALENDAR';
262:

Line 307: from fem_xdim_dimensions

303: end;
304:
305: select member_b_table_name, dimension_type_code
306: into l_member_b_table, l_dim_type_code
307: from fem_xdim_dimensions
308: where dimension_id = p_dimension_id;
309:
310: if(l_dim_type_code = 'LINE') then
311: l_aw_dim_prefix := 'DL';

Line 403: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;

399: p_hierarchy_id IN NUMBER)
400: is
401: l_multi_top FEM_HIERARCHIES.MULTI_TOP_FLAG%type;
402: l_dimension_id FEM_HIERARCHIES.DIMENSION_ID%type;
403: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
404: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
405: l_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
406: l_has_pers FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
407: l_command VARCHAR2(1000);

Line 404: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

400: is
401: l_multi_top FEM_HIERARCHIES.MULTI_TOP_FLAG%type;
402: l_dimension_id FEM_HIERARCHIES.DIMENSION_ID%type;
403: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
404: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
405: l_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
406: l_has_pers FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
407: l_command VARCHAR2(1000);
408: begin

Line 405: l_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

401: l_multi_top FEM_HIERARCHIES.MULTI_TOP_FLAG%type;
402: l_dimension_id FEM_HIERARCHIES.DIMENSION_ID%type;
403: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
404: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
405: l_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
406: l_has_pers FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
407: l_command VARCHAR2(1000);
408: begin
409:

Line 406: l_has_pers FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;

402: l_dimension_id FEM_HIERARCHIES.DIMENSION_ID%type;
403: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
404: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
405: l_member_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
406: l_has_pers FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
407: l_command VARCHAR2(1000);
408: begin
409:
410: insert into ZPB_BUSAREA_HIERARCHIES

Line 449: from FEM_XDIM_DIMENSIONS

445: if (l_multi_top = FND_API.G_TRUE) then
446:
447: select HIERARCHY_TABLE_NAME, HIER_EDITOR_MANAGED_FLAG
448: into l_dim_table, l_has_pers
449: from FEM_XDIM_DIMENSIONS
450: where DIMENSION_ID = l_dimension_id;
451:
452: l_command := '
453: insert into ZPB_BUSAREA_HIER_MEMBERS

Line 2026: from FEM_FUNC_DIM_SETS_VL A, FEM_XDIM_DIMENSIONS_VL B

2022: where FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id;
2023:
2024: CURSOR c_get_invalid_dims IS
2025: select A.FUNC_DIM_SET_ID, A.DIMENSION_ID, A.FUNC_DIM_SET_NAME, B.DESCRIPTION
2026: from FEM_FUNC_DIM_SETS_VL A, FEM_XDIM_DIMENSIONS_VL B
2027: where A.FUNC_DIM_SET_OBJ_DEF_ID = p_fdr_obj_def_id
2028: and A.DIMENSION_ID in (2, 5, 6, 112, 113)
2029: and A.DIMENSION_ID = B.DIMENSION_ID;
2030: