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_FEM_UTILS_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 24: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

20: function GET_MEMBER_NAME (p_dimension_id NUMBER,
21: p_member_id VARCHAR2,
22: p_valueset_id NUMBER)
23: return VARCHAR2 is
24: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
25: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
26: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
27: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
28: l_ret VARCHAR2(150);

Line 25: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;

21: p_member_id VARCHAR2,
22: p_valueset_id NUMBER)
23: return VARCHAR2 is
24: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
25: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
26: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
27: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
28: l_ret VARCHAR2(150);
29: l_command VARCHAR2(500);

Line 26: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

22: p_valueset_id NUMBER)
23: return VARCHAR2 is
24: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
25: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
26: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
27: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
28: l_ret VARCHAR2(150);
29: l_command VARCHAR2(500);
30:

Line 27: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

23: return VARCHAR2 is
24: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
25: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
26: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
27: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
28: l_ret VARCHAR2(150);
29: l_command VARCHAR2(500);
30:
31: l_curs EPB_CURS_TYPE;

Line 40: from FEM_XDIM_DIMENSIONS

36:
37: select MEMBER_VL_OBJECT_NAME, MEMBER_NAME_COL,
38: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
39: into l_dim_vl_table, l_dim_name_col, l_dim_col, l_vs_req
40: from FEM_XDIM_DIMENSIONS
41: where DIMENSION_ID = p_dimension_id;
42:
43: l_command := 'select '||l_dim_name_col||' from '||l_dim_vl_table||
44: ' where to_char('||l_dim_col||') = '''||p_member_id||'''';

Line 77: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

73: function GET_MEMBER_DESC (p_dimension_id NUMBER,
74: p_member_id VARCHAR2,
75: p_valueset_id NUMBER)
76: return VARCHAR2 is
77: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
78: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
79: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
80: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
81: l_ret VARCHAR2(255);

Line 78: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

74: p_member_id VARCHAR2,
75: p_valueset_id NUMBER)
76: return VARCHAR2 is
77: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
78: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
79: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
80: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
81: l_ret VARCHAR2(255);
82: l_command VARCHAR2(500);

Line 79: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

75: p_valueset_id NUMBER)
76: return VARCHAR2 is
77: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
78: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
79: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
80: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
81: l_ret VARCHAR2(255);
82: l_command VARCHAR2(500);
83:

Line 80: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

76: return VARCHAR2 is
77: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
78: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
79: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
80: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
81: l_ret VARCHAR2(255);
82: l_command VARCHAR2(500);
83:
84: l_curs EPB_CURS_TYPE;

Line 93: from FEM_XDIM_DIMENSIONS

89:
90: select MEMBER_VL_OBJECT_NAME, MEMBER_DESCRIPTION_COL,
91: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
92: into l_dim_vl_table, l_dim_desc_col, l_dim_col, l_vs_req
93: from FEM_XDIM_DIMENSIONS
94: where DIMENSION_ID = p_dimension_id;
95:
96: l_command := 'select '||l_dim_desc_col||' from '||l_dim_vl_table||
97: ' where to_char('||l_dim_col||') = '''||p_member_id||'''';

Line 126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

122: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
123: ----------------------------------------------------------------------------
124: function GET_MEMBERS (p_dimension_id NUMBER)
125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

Line 127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

123: ----------------------------------------------------------------------------
124: function GET_MEMBERS (p_dimension_id NUMBER)
125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
131: l_command VARCHAR2(500);

Line 128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;

124: function GET_MEMBERS (p_dimension_id NUMBER)
125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
131: l_command VARCHAR2(500);
132: l_ret ZPB_MEMBER_TABLE_OBJ;

Line 129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

125: return ZPB_MEMBER_TABLE_T PIPELINED is
126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
131: l_command VARCHAR2(500);
132: l_ret ZPB_MEMBER_TABLE_OBJ;
133:

Line 130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

126: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
127: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
128: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
129: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
130: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
131: l_command VARCHAR2(500);
132: l_ret ZPB_MEMBER_TABLE_OBJ;
133:
134: l_curs EPB_CURS_TYPE;

Line 145: from FEM_XDIM_DIMENSIONS

141:
142: select MEMBER_VL_OBJECT_NAME, MEMBER_NAME_COL, MEMBER_DESCRIPTION_COL,
143: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
144: into l_dim_vl_table, l_dim_name_col, l_dim_desc_col, l_dim_col, l_vs_req
145: from FEM_XDIM_DIMENSIONS
146: where DIMENSION_ID = p_dimension_id;
147:
148: l_command := 'select '||l_dim_col||', '||l_dim_name_col||', '||
149: l_dim_desc_col;

Line 182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

178: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
179: ----------------------------------------------------------------------------
180: function GET_VARCHAR_MEMBERS (p_dimension_id NUMBER)
181: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

Line 183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

179: ----------------------------------------------------------------------------
180: function GET_VARCHAR_MEMBERS (p_dimension_id NUMBER)
181: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
187: l_command VARCHAR2(500);

Line 184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;

180: function GET_VARCHAR_MEMBERS (p_dimension_id NUMBER)
181: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
187: l_command VARCHAR2(500);
188: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;

Line 185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

181: return ZPB_VAR_MEMBER_TABLE_T PIPELINED is
182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
187: l_command VARCHAR2(500);
188: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;
189:

Line 186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

182: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
183: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
184: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
185: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
186: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
187: l_command VARCHAR2(500);
188: l_ret ZPB_VAR_MEMBER_TABLE_OBJ;
189:
190: l_curs EPB_CURS_TYPE;

Line 201: from FEM_XDIM_DIMENSIONS

197:
198: select MEMBER_VL_OBJECT_NAME, MEMBER_NAME_COL, MEMBER_DESCRIPTION_COL,
199: MEMBER_COL, VALUE_SET_REQUIRED_FLAG
200: into l_dim_vl_table, l_dim_name_col, l_dim_desc_col, l_dim_col, l_vs_req
201: from FEM_XDIM_DIMENSIONS
202: where DIMENSION_ID = p_dimension_id;
203:
204: l_command := 'select to_char('||l_dim_col||'), '||l_dim_name_col||', '||
205: l_dim_desc_col;

Line 237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;

233: -- OUT: ZPB_MEMBER_TABLE_T - each dimension member, description pair
234: ----------------------------------------------------------------------------
235: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
236: return ZPB_MEMBER_TABLE_T PIPELINED is
237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
238: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
239: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
240: l_ret ZPB_MEMBER_TABLE_OBJ;
241: l_command VARCHAR2(2000);

Line 238: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;

234: ----------------------------------------------------------------------------
235: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
236: return ZPB_MEMBER_TABLE_T PIPELINED is
237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
238: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
239: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
240: l_ret ZPB_MEMBER_TABLE_OBJ;
241: l_command VARCHAR2(2000);
242:

Line 239: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

235: function GET_TOP_HIER_MEMBERS (p_hier_vers_id IN NUMBER)
236: return ZPB_MEMBER_TABLE_T PIPELINED is
237: l_dimension_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
238: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
239: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
240: l_ret ZPB_MEMBER_TABLE_OBJ;
241: l_command VARCHAR2(2000);
242:
243: l_curs EPB_CURS_TYPE;

Line 250: from FEM_XDIM_DIMENSIONS A, FEM_HIERARCHIES B, FEM_OBJECT_DEFINITION_B C

246: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);
247:
248: select A.DIMENSION_ID, A.VALUE_SET_REQUIRED_FLAG, A.HIERARCHY_TABLE_NAME
249: into l_dimension_id, l_vs_req, l_hier_table
250: from FEM_XDIM_DIMENSIONS A, FEM_HIERARCHIES B, FEM_OBJECT_DEFINITION_B C
251: where A.DIMENSION_ID = B.DIMENSION_ID
252: and B.HIERARCHY_OBJ_ID = C.OBJECT_ID
253: and C.OBJECT_DEFINITION_ID = p_hier_vers_id;
254:

Line 480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

476: l_vset_id NUMBER;
477: l_command VARCHAR2(16000);
478: l_sel_command VARCHAR2(1000);
479: l_from_command VARCHAR2(4000);
480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;

Line 481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;

477: l_command VARCHAR2(16000);
478: l_sel_command VARCHAR2(1000);
479: l_from_command VARCHAR2(4000);
480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

Line 482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;

478: l_sel_command VARCHAR2(1000);
479: l_from_command VARCHAR2(4000);
480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;

Line 483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

479: l_from_command VARCHAR2(4000);
480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
487: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;

Line 484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;

480: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
487: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
488: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

Line 485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;

481: l_dim_vl_table FEM_XDIM_DIMENSIONS.MEMBER_VL_OBJECT_NAME%type;
482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
487: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
488: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
489: l_operation ZPB_BUSAREA_CONDITIONS.OPERATION%type;

Line 486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;

482: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
483: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
484: l_dim_name_col FEM_XDIM_DIMENSIONS.MEMBER_NAME_COL%type;
485: l_dim_desc_col FEM_XDIM_DIMENSIONS.MEMBER_DESCRIPTION_COL%type;
486: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
487: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
488: l_business_area ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
489: l_operation ZPB_BUSAREA_CONDITIONS.OPERATION%type;
490:

Line 523: from FEM_XDIM_DIMENSIONS A

519: 'N', A.MEMBER_DESCRIPTION_COL, A.MEMBER_NAME_COL,
520: A.HIER_EDITOR_MANAGED_FLAG
521: into l_vs_req, l_dim_vl_table, l_dim_col, l_attr_table, l_use_cond,
522: l_dim_desc_col, l_dim_name_col, l_pers_flag
523: from FEM_XDIM_DIMENSIONS A
524: where A.DIMENSION_ID = p_dimension_id;
525: else
526: select A.VALUE_SET_REQUIRED_FLAG,
527: A.MEMBER_VL_OBJECT_NAME, A.MEMBER_COL, A.ATTRIBUTE_TABLE_NAME,

Line 532: from FEM_XDIM_DIMENSIONS A,

528: B.USE_MEMBER_CONDITIONS, A.MEMBER_DESCRIPTION_COL, A.MEMBER_NAME_COL,
529: A.HIER_EDITOR_MANAGED_FLAG
530: into l_vs_req, l_dim_vl_table, l_dim_col, l_attr_table, l_use_cond,
531: l_dim_desc_col, l_dim_name_col, l_pers_flag
532: from FEM_XDIM_DIMENSIONS A,
533: ZPB_BUSAREA_DIMENSIONS B,
534: ZPB_BUSAREA_VERSIONS C
535: where A.DIMENSION_ID = p_dimension_id
536: and A.DIMENSION_ID = B.DIMENSION_ID

Line 679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

675: l_count NUMBER;
676: l_cond_count NUMBER;
677: l_count2 NUMBER;
678: l_pipe BOOLEAN;
679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

Line 680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

676: l_cond_count NUMBER;
677: l_count2 NUMBER;
678: l_pipe BOOLEAN;
679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;

Line 681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;

677: l_count2 NUMBER;
678: l_pipe BOOLEAN;
679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
685: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;

Line 682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;

678: l_pipe BOOLEAN;
679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
685: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
686: l_cond_anc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_ANC%type;

Line 683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

679: l_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
685: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
686: l_cond_anc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_ANC%type;
687: l_cond_desc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_DESC%type;

Line 684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;

680: l_dim_b_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
681: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
682: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
683: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
685: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
686: l_cond_anc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_ANC%type;
687: l_cond_desc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_DESC%type;
688: l_top_mbrs ZPB_BUSAREA_HIERARCHIES.INCLUDE_ALL_TOP_MEMBERS%type;

Line 766: from FEM_XDIM_DIMENSIONS A,

762: B.USE_MEMBER_CONDITIONS, B.CONDITIONS_INCL_ANC, B.CONDITIONS_INCL_DESC,
763: A.HIER_EDITOR_MANAGED_FLAG
764: into l_hier_table, l_vs_req, l_dim_b_table, l_dim_col, l_attr_table,
765: l_use_cond, l_cond_anc, l_cond_desc, l_pers_flag
766: from FEM_XDIM_DIMENSIONS A,
767: ZPB_BUSAREA_DIMENSIONS B,
768: ZPB_BUSAREA_VERSIONS C
769: where A.DIMENSION_ID = p_dimension_id
770: and A.DIMENSION_ID = B.DIMENSION_ID