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_VAL dependencies on ZPB_FEM_UTILS_PKG

Line 1198: ZPB_FEM_UTILS_PKG.INIT_HIER_MEMBER_CACHE(l_ba_id, l_vers_type);

1194: REGISTER_ERROR('S', 'E', 'ZPB_BUSAREA_VAL_EXT_ACT_TYPE');
1195: end if;
1196:
1197:
1198: ZPB_FEM_UTILS_PKG.INIT_HIER_MEMBER_CACHE(l_ba_id, l_vers_type);
1199:
1200: for each in c_dimensions loop
1201: -- Check for dimension name length
1202: if length(each.dimension_name) > G_MAX_NAME_LENGTH then

Line 1213: from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS

1209: ---------------------------------------------------------------------
1210: -- See if there are any members in the dimension
1211: ---------------------------------------------------------------------
1212: l_command := 'select count(*)
1213: from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS
1214: ('||each.DIMENSION_ID||', '||each.LOGICAL_DIM_ID||','||l_ba_id||', '''||l_vers_type||'''))';
1215:
1216: open l_cursor for l_command;
1217: fetch l_cursor into l_count;

Line 1306: from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS

1302: end if;
1303: -- end check for attribute name length
1304:
1305: l_command := 'select count(*)
1306: from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS
1307: ('||each.DIMENSION_ID||','||each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||l_vers_type||
1308: ''')) A, '||l_attr_table||' B ';
1309: if (l_vset_required = 'Y') then
1310: l_command := l_command||'

Line 1360: from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS

1356: -------------------------------------------------------------------
1357: -- Check if any hierarchies have no members:
1358: -------------------------------------------------------------------
1359: l_command := 'select distinct HIERARCHY_ID, VERSION_ID, LOGICAL_DIM_ID
1360: from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS
1361: ('||each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||
1362: l_vers_type||'''))';
1363:
1364: l_buffer1 := null;

Line 1388: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES

1384: end loop;
1385: close l_cursor;
1386:
1387: l_command := 'select A.HIERARCHY_ID, A.VERSION_ID, A.CURRENT_VERSION
1388: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES
1389: ('||l_ba_id||','''||l_vers_type||''')) A,
1390: ZPB_BUSAREA_HIERARCHIES_VL B
1391: where A.HIERARCHY_ID = B.HIERARCHY_ID
1392: and A.LOGICAL_DIM_ID = B.LOGICAL_DIM_ID

Line 1448: from (table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS

1444: FEM_HIER_DIMENSION_GRPS X,
1445: (select distinct A.HIERARCHY_ID, A.VERSION_ID,
1446: B.RELATIVE_DIMENSION_GROUP_SEQ PARENT_SEQ,
1447: C.RELATIVE_DIMENSION_GROUP_SEQ CHILD_SEQ
1448: from (table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS
1449: ('||each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||
1450: l_vers_type||'''))) A,
1451: FEM_HIER_DIMENSION_GRPS B, FEM_HIER_DIMENSION_GRPS C,
1452: '||l_dim_table||' D, '||l_dim_table||' E

Line 1505: from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS

1501: end if;
1502: -- end check for atribute name length
1503:
1504: l_command := 'select count(*)
1505: from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS
1506: ('||each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||l_vers_type||
1507: ''')) A, '||l_attr_table||' B ';
1508: if (l_vset_required = 'Y') then
1509: l_command := l_command||'

Line 1560: 'from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS('||

1556: if ((each.DIMENSION_ID = l_org_dim_id) AND
1557: (each.LOGICAL_DIM_ID = l_org_logical_dim_id)) then
1558: l_command :=
1559: 'select count(*) '||
1560: 'from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS('||
1561: each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||l_vers_type||
1562: ''')) A, '||l_attr_table||' B, FEM_DIM_ATTR_VERSIONS_B C';
1563: if (l_vset_required = 'Y') then
1564: l_command := l_command||'

Line 1600: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1596:
1597: l_command := 'select decode(count(*), 0, 0, 1)';
1598: if (l_no_hierarchies = 'Y') then
1599: if (l_vset_required = 'Y') then
1600: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1601: else
1602: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1603: end if;
1604: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';

Line 1602: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1598: if (l_no_hierarchies = 'Y') then
1599: if (l_vset_required = 'Y') then
1600: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1601: else
1602: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1603: end if;
1604: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';
1605: else
1606: if (l_vset_required = 'Y') then

Line 1611: l_command := l_command || ' from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

1607: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.CHILD_ID, instr(A.CHILD_ID, ''_'')+1))) ';
1608: else
1609: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.CHILD_ID))';
1610: end if;
1611: l_command := l_command || ' from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';
1612: l_command := l_command || ' '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';
1613: end if;
1614: l_command := l_command ||
1615: ' FEM_DIM_ATTR_GRPS B,' ||

Line 1646: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1642: ' FEM_DIM_ATTR_GRPS D,' ||
1643: ' FEM_DIM_ATTR_VERSIONS_B E,';
1644: if (l_no_hierarchies = 'Y') then
1645: l_command := l_command ||
1646: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1647: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1648: else
1649: l_command := l_command ||
1650: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

Line 1650: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

1646: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1647: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1648: else
1649: l_command := l_command ||
1650: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';
1651: l_command := l_command || ' '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1652: l_command := l_command || ', FEM_HIERARCHIES G ';
1653: end if;
1654:

Line 1711: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1707: else
1708: l_command := 'select decode(count(*), 0, 0, 1)';
1709: if (l_no_hierarchies = 'Y') then
1710: if (l_vset_required = 'Y') then
1711: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1712: else
1713: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1714: end if;
1715: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';

Line 1713: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1709: if (l_no_hierarchies = 'Y') then
1710: if (l_vset_required = 'Y') then
1711: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.MEMBER_ID, instr(A.MEMBER_ID, ''_'')+1))) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1712: else
1713: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.MEMBER_ID)) from table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1714: end if;
1715: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';
1716: else
1717: if (l_vset_required = 'Y') then

Line 1722: l_command := l_command || ' from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

1718: l_command := l_command || ' from (SELECT DISTINCT(to_number(substr(A.CHILD_ID, instr(A.CHILD_ID, ''_'')+1)))';
1719: else
1720: l_command := l_command || ' from (SELECT DISTINCT(to_number(A.CHILD_ID))';
1721: end if;
1722: l_command := l_command || ' from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';
1723: l_command := l_command || ' '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) A,';
1724: end if;
1725: l_command := l_command ||
1726: ' '||l_dim_table||' C ';

Line 1748: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';

1744: ' '||l_attr_table||' C,' ||
1745: ' FEM_DIM_ATTR_VERSIONS_B E,';
1746: if (l_no_hierarchies = 'Y') then
1747: l_command := l_command ||
1748: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1749: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1750: else
1751: l_command := l_command ||
1752: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

Line 1752: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';

1748: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1749: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1750: else
1751: l_command := l_command ||
1752: ' table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS(';
1753: l_command := l_command || ' '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';
1754:
1755: l_command := l_command || ', FEM_HIERARCHIES G ';
1756: end if;

Line 2981: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,

2977: E.AW_DIM_PREFIX AS DIMENSION_ID,
2978: D.DIMENSION_ID FEM_DIMENSION_ID, E.DEFAULT_HIERARCHY_ID,
2979: E.LOGICAL_DIM_ID,
2980: nvl(E.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
2981: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,
2982: 'R')) A,
2983: FEM_HIERARCHIES D,
2984: FEM_OBJECT_CATALOG_VL C,
2985: ZPB_BUSAREA_DIMENSIONS E

Line 2995: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,

2991: and decode (A.CURRENT_VERSION, 'Y', to_char(A.HIERARCHY_ID),
2992: A.HIERARCHY_ID||'V'||A.VERSION_ID) not in
2993: (select decode (B.CURRENT_VERSION, 'Y', to_char(B.HIERARCHY_ID),
2994: B.HIERARCHY_ID||'V'||B.VERSION_ID) HIERARCHY_ID
2995: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,
2996: l_vers_type)) B);
2997: cursor l_levels is
2998: select B.LEVEL_ID,
2999: B.HIERARCHY_ID,