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_METADATA_NAMES

Line 300: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,

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:
304: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim_id);

Line 304: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim_id);

300: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,
301: 'PERSONAL',
302: l_epb_dim_id);
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

Line 552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);

548:
549:
550: if (l_dim_hier_table is not null and l_dim_ecm.HierDim <> 'NA') then
551:
552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);
553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);
554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);
555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);
556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);

Line 553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);

549:
550: if (l_dim_hier_table is not null and l_dim_ecm.HierDim <> 'NA') then
551:
552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);
553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);
554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);
555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);
556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);
557: --

Line 554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);

550: if (l_dim_hier_table is not null and l_dim_ecm.HierDim <> 'NA') then
551:
552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);
553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);
554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);
555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);
556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);
557: --
558: -- Update the Dimension Group table

Line 555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);

551:
552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);
553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);
554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);
555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);
556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);
557: --
558: -- Update the Dimension Group table
559: --

Line 556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);

552: l_dim_gid_col := zpb_metadata_names.get_dim_gid_column(l_epb_dim);
553: l_dim_pgid_col := zpb_metadata_names.get_dim_pgid_column(l_epb_dim);
554: l_dim_prnt_col := zpb_metadata_names.get_dim_parent_column(l_epb_dim);
555: l_dim_lvlRel_col := zpb_metadata_names.get_levelrel_column(l_epb_dim);
556: l_dim_order_col := zpb_metadata_names.get_dim_order_column(l_epb_dim);
557: --
558: -- Update the Dimension Group table
559: --
560: delete from FEM_DIMENSION_GRPS_PRIV where USER_ID = l_apps_id;

Line 927: l_dim_view := zpb_metadata_names.get_dimension_view (l_aw,

923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
924: l_awQual||l_dim_ecm.LevelRel);
925: if (zpb_aw.interp('shw convert(statlen('||l_awQual||l_dim_data.ExpObj
926: ||') TEXT 0 no no)') <> '0') then
927: l_dim_view := zpb_metadata_names.get_dimension_view (l_aw,
928: 'PERSONAL',
929: l_epb_dim_id,
930: l_hier);
931: else

Line 932: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,

928: 'PERSONAL',
929: l_epb_dim_id,
930: l_hier);
931: else
932: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,
933: 'PERSONAL',
934: l_epb_dim_id,
935: l_hier);
936: end if;

Line 1104: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,

1100: -- Populate the FEM data tables for Personal members:
1101: --
1102: -- First populate the MEMBER_B table
1103: --
1104: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,
1105: 'PERSONAL',
1106: l_epb_dim_id);
1107: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to all');
1108: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' remove '||

Line 1138: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1),

1134: OBJECT_VERSION_NUMBER)
1135: select '||l_dim_view_col||',
1136: '||l_dim_lvlRel_col||',
1137: nvl('||
1138: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1),
1139: ''Y'',
1140: ''Y'',
1141: sysdate, '||
1142: l_apps_id||', '||

Line 1181: '||zpb_metadata_names.get_dim_code_column(l_epb_dim)||',

1177: end if;
1178:
1179: l_command := l_command||'
1180: '||l_dim_lvlRel_col||',
1181: '||zpb_metadata_names.get_dim_code_column(l_epb_dim)||',
1182: ''Y'',
1183: ''Y'',';
1184: if (l_dim_data.Type = 'TIME') then
1185: l_command := l_command||'nvl('||

Line 1186: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1),';

1182: ''Y'',
1183: ''Y'',';
1184: if (l_dim_data.Type = 'TIME') then
1185: l_command := l_command||'nvl('||
1186: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1),';
1187: end if;
1188: l_command := l_command||'
1189: sysdate, '||
1190: l_apps_id||', '||

Line 1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||

1232: end if;
1233: l_command := l_command||
1234: ''''||FND_GLOBAL.CURRENT_LANGUAGE||''',
1235: '''||FND_GLOBAL.CURRENT_LANGUAGE||''', '||
1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||
1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';
1238: if (l_dim_data.Type = 'TIME') then
1239: l_command := l_command||'nvl('||
1240: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1), '||

Line 1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';

1233: l_command := l_command||
1234: ''''||FND_GLOBAL.CURRENT_LANGUAGE||''',
1235: '''||FND_GLOBAL.CURRENT_LANGUAGE||''', '||
1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||
1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';
1238: if (l_dim_data.Type = 'TIME') then
1239: l_command := l_command||'nvl('||
1240: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1), '||
1241: l_dim_lvlRel_col||', ';

Line 1240: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1), '||

1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||
1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';
1238: if (l_dim_data.Type = 'TIME') then
1239: l_command := l_command||'nvl('||
1240: zpb_metadata_names.get_dim_calendar_column(l_epb_dim_id)||',1), '||
1241: l_dim_lvlRel_col||', ';
1242: end if;
1243: l_command := l_command||'
1244: sysdate, '||

Line 1647: l_dim_view := zpb_metadata_names.get_dimension_view(l_shrdAw,

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);
1651:

Line 1650: l_dim_view_col := zpb_metadata_names.get_dimension_column(l_epb_dim);

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);
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