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_DHMINTERFACE_GRP dependencies on ZPB_ECM

Line 135: l_global_ecm ZPB_ECM.GLOBAL_ECM;

131: l_period_type FEM_HIERARCHIES.PERIOD_TYPE%TYPE;
132: l_multi_top FEM_HIERARCHIES.MULTI_TOP_FLAG%TYPE;
133: l_multi_vs FEM_HIERARCHIES.MULTI_VALUE_SET_FLAG%TYPE;
134:
135: l_global_ecm ZPB_ECM.GLOBAL_ECM;
136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;

Line 136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;

132: l_multi_top FEM_HIERARCHIES.MULTI_TOP_FLAG%TYPE;
133: l_multi_vs FEM_HIERARCHIES.MULTI_VALUE_SET_FLAG%TYPE;
134:
135: l_global_ecm ZPB_ECM.GLOBAL_ECM;
136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;

Line 137: l_dim_data ZPB_ECM.DIMENSION_DATA;

133: l_multi_vs FEM_HIERARCHIES.MULTI_VALUE_SET_FLAG%TYPE;
134:
135: l_global_ecm ZPB_ECM.GLOBAL_ECM;
136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
141:

Line 138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;

134:
135: l_global_ecm ZPB_ECM.GLOBAL_ECM;
136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
141:
142: l_exp_dim_curs epb_cur_type;

Line 139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;

135: l_global_ecm ZPB_ECM.GLOBAL_ECM;
136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
141:
142: l_exp_dim_curs epb_cur_type;
143:

Line 140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;

136: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
137: l_dim_data ZPB_ECM.DIMENSION_DATA;
138: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
139: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
140: l_global_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
141:
142: l_exp_dim_curs epb_cur_type;
143:
144: l_time_dim_grp_key FEM_DIMENSION_GRPS_B.TIME_DIMENSION_GROUP_KEY%type;

Line 252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);

248:
249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
250: l_shrdAw := zpb_aw.get_shared_aw;
251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
254:
255: if (p_dimension_id >= 100 and p_attr_id is null) then
256: for each in l_epb_dim_attrs loop

Line 253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);

249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
250: l_shrdAw := zpb_aw.get_shared_aw;
251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
254:
255: if (p_dimension_id >= 100 and p_attr_id is null) then
256: for each in l_epb_dim_attrs loop
257: if (zpb_aw.interpbool ('shw isValue('||l_awQual||l_global_ecm.DimDim||

Line 298: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);

294: l_global_attr_ecm.RangeDimRel||' eq '''||
295: p_attr_id||''')');
296: end if;
297:
298: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);
299: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);
300: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,
301: 'PERSONAL',
302: l_epb_dim_id);

Line 299: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);

295: p_attr_id||''')');
296: end if;
297:
298: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);
299: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);
300: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,
301: 'PERSONAL',
302: l_epb_dim_id);
303:

Line 307: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);

303:
304: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim_id);
305:
306: if (l_dim_data.Type = 'TIME') then
307: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);
308: elsif (l_dim_data.Type = 'LINE') then
309: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
310: end if;
311:

Line 309: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);

305:
306: if (l_dim_data.Type = 'TIME') then
307: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);
308: elsif (l_dim_data.Type = 'LINE') then
309: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
310: end if;
311:
312: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
313: l_awQual||l_global_ecm.LangDim||' commas');

Line 1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;

1527: hj NUMBER;
1528: i NUMBER;
1529: j NUMBER;
1530:
1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;
1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;

Line 1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;

1528: i NUMBER;
1529: j NUMBER;
1530:
1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;
1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;

Line 1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;

1529: j NUMBER;
1530:
1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;
1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;

Line 1534: l_dim_data ZPB_ECM.DIMENSION_DATA;

1530:
1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;
1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;
1538:

Line 1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;

1531: l_global_ecm ZPB_ECM.GLOBAL_ECM;
1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;
1538:
1539: l_imp_dim_curs epb_cur_type;

Line 1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;

1532: l_attr_ecm ZPB_ECM.GLOBAL_ATTR_ECM;
1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;
1538:
1539: l_imp_dim_curs epb_cur_type;
1540:

Line 1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;

1533: l_dim_ecm ZPB_ECM.DIMENSION_ECM;
1534: l_dim_data ZPB_ECM.DIMENSION_DATA;
1535: l_dim_time_ecm ZPB_ECM.DIMENSION_TIME_ECM;
1536: l_dim_line_ecm ZPB_ECM.DIMENSION_LINE_ECM;
1537: l_dim_attr_ecm ZPB_ECM.ATTR_ECM;
1538:
1539: l_imp_dim_curs epb_cur_type;
1540:
1541:

Line 1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);

1617:
1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
1619: l_shrdAw := zpb_aw.get_shared_aw;
1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
1623:
1624: if (p_attr_id is null) then
1625: if (l_dim_type = 'LINE') then

Line 1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);

1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
1619: l_shrdAw := zpb_aw.get_shared_aw;
1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
1623:
1624: if (p_attr_id is null) then
1625: if (l_dim_type = 'LINE') then
1626: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim

Line 1645: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);

1641: l_epb_dim := p_attr_id;
1642: end if;
1643:
1644: l_view_changed := false;
1645: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);
1646: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);
1647: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,
1648: 'PERSONAL',
1649: l_epb_dim);

Line 1646: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);

1642: end if;
1643:
1644: l_view_changed := false;
1645: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_epb_dim, l_aw);
1646: l_dim_data := zpb_ecm.get_dimension_data(l_epb_dim, l_aw);
1647: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,
1648: 'PERSONAL',
1649: l_epb_dim);
1650: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim);

Line 1653: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);

1649: l_epb_dim);
1650: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim);
1651:
1652: if (l_dim_data.Type = 'TIME') then
1653: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);
1654: elsif (l_dim_data.Type = 'LINE') then
1655: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
1656: end if;
1657:

Line 1655: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);

1651:
1652: if (l_dim_data.Type = 'TIME') then
1653: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_epb_dim, l_aw);
1654: elsif (l_dim_data.Type = 'LINE') then
1655: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
1656: end if;
1657:
1658: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
1659: l_awQual||l_global_ecm.LangDim||' '||l_awQual||

Line 2306: l_dim_attr_ecm := ZPB_ECM.GET_ATTR_ECM(l_epb_dim||'A'||l_attr_id,

2302: 'else '''||l_attr_var_mbr||'''');
2303: end if;
2304: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||
2305: l_epb_dim||'A'||l_attr_id||'''');
2306: l_dim_attr_ecm := ZPB_ECM.GET_ATTR_ECM(l_epb_dim||'A'||l_attr_id,
2307: l_attr_ecm, l_aw);
2308:
2309: l_attr_abbrev := zpb_aw.interp
2310: ('shw '||l_awQual||l_attr_ecm.NameFragVar);