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_METADATA_PKG dependencies on ZPB_HIER_SCOPE

Line 1259: -- zpb_md_records.hier_scope_entry into zpb_hier_scope and

1255:
1256:
1257: -------------------------------------------------------------------------------
1258: -- insertHierScopeRecord - Private function that inserts a
1259: -- zpb_md_records.hier_scope_entry into zpb_hier_scope and
1260: -- returns the primary key of the newly created entry
1261: -------------------------------------------------------------------------------
1262: function insertHierScopeRecord(p_hier_scope_rec zpb_md_records.hier_scope_entry)
1263: return number is

Line 1274: from zpb_hier_scope

1270:
1271: begin
1272:
1273: select scope_id into l_hier_scope_rec.ScopeId
1274: from zpb_hier_scope
1275: where hierarchy_id = l_hier_scope_rec.HierarchyId and
1276: user_id = l_hier_scope_rec.UserId and
1277: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1278:

Line 1279: update zpb_hier_scope

1275: where hierarchy_id = l_hier_scope_rec.HierarchyId and
1276: user_id = l_hier_scope_rec.UserId and
1277: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1278:
1279: update zpb_hier_scope
1280: set
1281:
1282: PERS_TABLE_ID = l_hier_scope_rec.PersTableId,
1283: CREATED_BY = FND_GLOBAL.USER_ID,

Line 1292: SELECT zpb_hier_scope_seq.NEXTVAL INTO l_hier_scope_rec.ScopeId FROM DUAL;

1288: where scope_id = l_hier_scope_rec.ScopeId;
1289:
1290: exception
1291: when NO_DATA_FOUND then
1292: SELECT zpb_hier_scope_seq.NEXTVAL INTO l_hier_scope_rec.ScopeId FROM DUAL;
1293:
1294: insert into zpb_hier_scope
1295: (
1296: END_DATE,

Line 1294: insert into zpb_hier_scope

1290: exception
1291: when NO_DATA_FOUND then
1292: SELECT zpb_hier_scope_seq.NEXTVAL INTO l_hier_scope_rec.ScopeId FROM DUAL;
1293:
1294: insert into zpb_hier_scope
1295: (
1296: END_DATE,
1297: HIERARCHY_ID,
1298: SCOPE_ID,

Line 1529: delete zpb_hier_scope

1525: from zpb_hierarchies
1526: where dimension_id = p_dimension_id);
1527:
1528: -- delete hier_scope
1529: delete zpb_hier_scope
1530: where hierarchy_id in (select hierarchy_id
1531: from zpb_hierarchies
1532: where dimension_id = p_dimension_id);
1533:

Line 1644: delete zpb_hier_scope

1640: delete zpb_hier_level_scope
1641: where hier_id = p_hierarchy_id;
1642:
1643: -- delete hier_scope
1644: delete zpb_hier_scope
1645: where hierarchy_id = p_hierarchy_id;
1646:
1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

Line 5314: delete zpb_hier_scope

5310: deleteCubeRecord(cube.cube_id);
5311: end loop;
5312:
5313: -- clean user scope tables
5314: delete zpb_hier_scope
5315: where user_id = to_number(p_user) and
5316: hierarchy_id in (select hierarchy_id
5317: from zpb_hierarchies hier,
5318: zpb_dimensions dims

Line 5507: update zpb_hier_scope hscope

5503:
5504: -- Reset all of the personal personal hierarchy table id's to the personal
5505: -- hierarchy tables. In the case that the user still has personal levels
5506: -- they will be set appropriately back to the personal personal hierarchy tables below.
5507: update zpb_hier_scope hscope
5508: set hscope.pers_table_id = (select pers_table_id
5509: from zpb_hierarchies hier
5510: where hscope.hierarchy_id = hier.hierarchy_id)
5511: where hscope.user_id = l_user_id and

Line 5639: -- update the zpb_hier_scope entry for this hierarchy to use pesonal personal hierarchy table

5635: -- dbms_output.put_line('Pers Level');
5636: -- personal level, need to create MD for the level itself and for the personal personal hierarchy table
5637: l_persLvl :=true;
5638:
5639: -- update the zpb_hier_scope entry for this hierarchy to use pesonal personal hierarchy table
5640: update zpb_hier_scope
5641: set pers_table_id = l_pers_column_en.TableId
5642: where user_id = l_user_id and
5643: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

Line 5640: update zpb_hier_scope

5636: -- personal level, need to create MD for the level itself and for the personal personal hierarchy table
5637: l_persLvl :=true;
5638:
5639: -- update the zpb_hier_scope entry for this hierarchy to use pesonal personal hierarchy table
5640: update zpb_hier_scope
5641: set pers_table_id = l_pers_column_en.TableId
5642: where user_id = l_user_id and
5643: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5644: hierarchy_id = l_hier_scope_en.HierarchyId;

Line 5802: delete zpb_hier_scope

5798: end loop;
5799:
5800: -- delete all scoping entries for this user that have not been updated during the above looping
5801: -- they must have been created previously and are no longer valid
5802: delete zpb_hier_scope
5803: where user_id = l_user_id and
5804: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5805: last_update_date < l_start_time and
5806: hierarchy_id in (select hierarchy_id

Line 5925: delete zpb_hier_scope

5921: from zpb_hierarchies
5922: where dimension_id = v_dim.dimension_id);
5923:
5924: -- delete hier_scope
5925: delete zpb_hier_scope
5926: where hierarchy_id in (select hierarchy_id
5927: from zpb_hierarchies
5928: where dimension_id = v_dim.dimension_id);
5929: