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_VERSIONS

Line 545: insert into ZPB_BUSAREA_HIER_VERSIONS

541: p_hierarchy_id IN NUMBER,
542: p_hier_vers_id IN NUMBER)
543: is
544: begin
545: insert into ZPB_BUSAREA_HIER_VERSIONS
546: (VERSION_ID,
547: LOGICAL_DIM_ID, -- "Consistent Dimension"
548: HIERARCHY_ID,
549: HIER_VERSION_ID,

Line 666: delete from ZPB_BUSAREA_HIER_VERSIONS

662: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
663: and HIERARCHY_ID = p_hierarchy_id;
664:
665: if (l_incl_type= 'N' or l_incl_type = 'L') then
666: delete from ZPB_BUSAREA_HIER_VERSIONS
667: where VERSION_ID = p_version_id
668: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
669: and HIERARCHY_ID = p_hierarchy_id;
670:

Line 674: insert into ZPB_BUSAREA_HIER_VERSIONS

670:
671: elsif (l_incl_type = 'S' and l_number is not null and l_number > 0) then
672: l_count := 1;
673: for each_vers in hier_last_vers loop
674: insert into ZPB_BUSAREA_HIER_VERSIONS
675: (VERSION_ID,
676: LOGICAL_DIM_ID, -- "Consistent Dimension"
677: HIERARCHY_ID,
678: HIER_VERSION_ID,

Line 719: delete from ZPB_BUSAREA_HIER_VERSIONS

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;
721:
722: delete from ZPB_BUSAREA_LEVELS
723: where VERSION_ID = p_version_id;

Line 1107: insert into ZPB_BUSAREA_HIER_VERSIONS

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,
1109: LOGICAL_DIM_ID, -- "Consistent Dimension"
1110: HIERARCHY_ID,
1111: HIER_VERSION_ID,

Line 1128: from ZPB_BUSAREA_HIER_VERSIONS

1124: FND_GLOBAL.USER_ID,
1125: FND_GLOBAL.LOGIN_ID,
1126: sysdate,
1127: FND_GLOBAL.USER_ID
1128: from ZPB_BUSAREA_HIER_VERSIONS
1129: where VERSION_ID = l_from_version_id;
1130:
1131: insert into ZPB_BUSAREA_LEVELS
1132: (VERSION_ID,

Line 1851: delete from ZPB_BUSAREA_HIER_VERSIONS

1847: p_hierarchy_id IN NUMBER,
1848: p_hier_vers_id IN NUMBER)
1849: is
1850: begin
1851: delete from ZPB_BUSAREA_HIER_VERSIONS
1852: where VERSION_ID = p_version_id
1853: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1854: and HIERARCHY_ID = p_hierarchy_id
1855: and nvl(HIER_VERSION_ID,-1) = nvl(p_hier_vers_id, -1);