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 ZPB_BUSAREA_HIER_MEMBERS

Line 453: insert into ZPB_BUSAREA_HIER_MEMBERS

449: from FEM_XDIM_DIMENSIONS
450: where DIMENSION_ID = l_dimension_id;
451:
452: l_command := '
453: insert into ZPB_BUSAREA_HIER_MEMBERS
454: (VERSION_ID,
455: LOGICAL_DIM_ID, -- "Consistent Dimension"
456: HIERARCHY_ID,
457: MEMBER_ID,

Line 504: insert into ZPB_BUSAREA_HIER_MEMBERS

500: p_member_vset IN NUMBER,
501: p_hier_version IN NUMBER)
502: is
503: begin
504: insert into ZPB_BUSAREA_HIER_MEMBERS
505: (VERSION_ID,
506: LOGICAL_DIM_ID, -- "Consistent Dimension"
507: HIERARCHY_ID,
508: MEMBER_ID,

Line 716: delete from ZPB_BUSAREA_HIER_MEMBERS

712:
713: delete from ZPB_BUSAREA_HIERARCHIES
714: where VERSION_ID = p_version_id;
715:
716: delete from ZPB_BUSAREA_HIER_MEMBERS
717: where VERSION_ID = p_version_id;
718:
719: delete from ZPB_BUSAREA_HIER_VERSIONS
720: where VERSION_ID = p_version_id;

Line 1081: insert into ZPB_BUSAREA_HIER_MEMBERS

1077: FND_GLOBAL.USER_ID
1078: from ZPB_BUSAREA_HIERARCHIES
1079: where VERSION_ID = l_from_version_id;
1080:
1081: insert into ZPB_BUSAREA_HIER_MEMBERS
1082: (VERSION_ID,
1083: LOGICAL_DIM_ID, -- "Consistent Dimension"
1084: HIERARCHY_ID,
1085: MEMBER_ID,

Line 1104: from ZPB_BUSAREA_HIER_MEMBERS

1100: FND_GLOBAL.USER_ID,
1101: FND_GLOBAL.LOGIN_ID,
1102: sysdate,
1103: FND_GLOBAL.USER_ID
1104: from ZPB_BUSAREA_HIER_MEMBERS
1105: where VERSION_ID = l_from_version_id;
1106:
1107: insert into ZPB_BUSAREA_HIER_VERSIONS
1108: (VERSION_ID,

Line 1751: delete from ZPB_BUSAREA_HIER_MEMBERS

1747: where VERSION_ID = p_version_id
1748: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1749: and HIERARCHY_ID = p_hierarchy_id;
1750:
1751: delete from ZPB_BUSAREA_HIER_MEMBERS
1752: where VERSION_ID = p_version_id
1753: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1754: and HIERARCHY_ID = p_hierarchy_id;
1755:

Line 1805: delete from ZPB_BUSAREA_HIER_MEMBERS

1801: is
1802: begin
1803: if (p_member_vset is not null) then
1804: if (p_hier_version is not null) then
1805: delete from ZPB_BUSAREA_HIER_MEMBERS
1806: where VERSION_ID = p_version_id
1807: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1808: and HIERARCHY_ID = p_hierarchy_id
1809: and MEMBER_ID = p_member_id

Line 1813: delete from ZPB_BUSAREA_HIER_MEMBERS

1809: and MEMBER_ID = p_member_id
1810: and VALUE_SET_ID = p_member_vset
1811: and HIER_VERSION_ID = p_hier_version;
1812: else
1813: delete from ZPB_BUSAREA_HIER_MEMBERS
1814: where VERSION_ID = p_version_id
1815: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1816: and HIERARCHY_ID = p_hierarchy_id
1817: and MEMBER_ID = p_member_id

Line 1821: delete from ZPB_BUSAREA_HIER_MEMBERS

1817: and MEMBER_ID = p_member_id
1818: and VALUE_SET_ID = p_member_vset;
1819: end if;
1820: elsif (p_hier_version is not null) then
1821: delete from ZPB_BUSAREA_HIER_MEMBERS
1822: where VERSION_ID = p_version_id
1823: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1824: and HIERARCHY_ID = p_hierarchy_id
1825: and MEMBER_ID = p_member_id

Line 1828: delete from ZPB_BUSAREA_HIER_MEMBERS

1824: and HIERARCHY_ID = p_hierarchy_id
1825: and MEMBER_ID = p_member_id
1826: and HIER_VERSION_ID = p_hier_version;
1827: else
1828: delete from ZPB_BUSAREA_HIER_MEMBERS
1829: where VERSION_ID = p_version_id
1830: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1831: and HIERARCHY_ID = p_hierarchy_id
1832: and MEMBER_ID = p_member_id;