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_LEVEL

Line 352: -- zpb_md_records.hier_level_entry into zpb_hier_levels and

348: end insertLevelRecord;
349:
350: -------------------------------------------------------------------------------
351: -- insertHierLevelRecord - Private function that inserts a
352: -- zpb_md_records.hier_level_entry into zpb_hier_levels and
353: -- returns the primary key of the newly created entry
354: -------------------------------------------------------------------------------
355: function insertHierLevelRecord(p_hier_level_rec zpb_md_records.hier_level_entry)
356: return number is

Line 367: from zpb_hier_level

363:
364: begin
365:
366: select relation_id into l_hier_level_rec.RelationId
367: from zpb_hier_level
368: where level_id = l_hier_level_rec.LevelId and
369: hier_id = l_hier_level_rec.HierId;
370:
371: update zpb_hier_level

Line 371: update zpb_hier_level

367: from zpb_hier_level
368: where level_id = l_hier_level_rec.LevelId and
369: hier_id = l_hier_level_rec.HierId;
370:
371: update zpb_hier_level
372: set
373:
374: LEVEL_ORDER = l_hier_level_rec.LevelOrder,
375: PERS_COL_ID = l_hier_level_rec.PersColId,

Line 386: SELECT zpb_hier_level_seq.NEXTVAL INTO l_hier_level_rec.RelationId FROM DUAL;

382: where relation_id = l_hier_level_rec.RelationId;
383:
384: exception
385: when NO_DATA_FOUND then
386: SELECT zpb_hier_level_seq.NEXTVAL INTO l_hier_level_rec.RelationId FROM DUAL;
387:
388: insert into zpb_hier_level
389: (
390: HIER_ID,

Line 388: insert into zpb_hier_level

384: exception
385: when NO_DATA_FOUND then
386: SELECT zpb_hier_level_seq.NEXTVAL INTO l_hier_level_rec.RelationId FROM DUAL;
387:
388: insert into zpb_hier_level
389: (
390: HIER_ID,
391: LEVEL_ID,
392: LEVEL_ORDER,

Line 1333: -- zpb_md_records.hier_level_scope_entry into zpb_hier_level_scope and

1329: end insertHierScopeRecord;
1330:
1331: -------------------------------------------------------------------------------
1332: -- insertHierlevelscopeRecord - Private function that inserts a
1333: -- zpb_md_records.hier_level_scope_entry into zpb_hier_level_scope and
1334: -- returns the primary key of the newly created entry
1335: -------------------------------------------------------------------------------
1336: function insertHierlevelscopeRecord(p_hier_level_scope_rec zpb_md_records.hier_level_scope_entry)
1337: return number is

Line 1348: from zpb_hier_level_scope

1344:
1345: begin
1346:
1347: select scope_id into l_hier_level_scope_rec.ScopeId
1348: from zpb_hier_level_scope
1349: where hier_id = l_hier_level_scope_rec.HierId and
1350: level_id = l_hier_level_scope_rec.LevelId and
1351: user_id = l_hier_level_scope_rec.UserId and
1352: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);

Line 1354: update zpb_hier_level_scope

1350: level_id = l_hier_level_scope_rec.LevelId and
1351: user_id = l_hier_level_scope_rec.UserId and
1352: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1353:
1354: update zpb_hier_level_scope
1355: set
1356:
1357: PERS_COL_ID = l_hier_level_scope_rec.PersColId,
1358: CREATED_BY = FND_GLOBAL.USER_ID,

Line 1367: SELECT zpb_hier_level_scope_seq.NEXTVAL INTO l_hier_level_scope_rec.ScopeId FROM DUAL;

1363: where scope_id = l_hier_level_scope_rec.ScopeId;
1364:
1365: exception
1366: when NO_DATA_FOUND then
1367: SELECT zpb_hier_level_scope_seq.NEXTVAL INTO l_hier_level_scope_rec.ScopeId FROM DUAL;
1368:
1369: insert into zpb_hier_level_scope
1370: (
1371: LEVEL_ID,

Line 1369: insert into zpb_hier_level_scope

1365: exception
1366: when NO_DATA_FOUND then
1367: SELECT zpb_hier_level_scope_seq.NEXTVAL INTO l_hier_level_scope_rec.ScopeId FROM DUAL;
1368:
1369: insert into zpb_hier_level_scope
1370: (
1371: LEVEL_ID,
1372: HIER_ID,
1373: SCOPE_ID,

Line 1517: delete zpb_hier_level

1513: from zpb_hierarchies
1514: where dimension_id = p_dimension_id);
1515:
1516: -- delete hier_level
1517: delete zpb_hier_level
1518: where hier_id in (select hierarchy_id
1519: from zpb_hierarchies
1520: where dimension_id = p_dimension_id);
1521:

Line 1523: delete zpb_hier_level_scope

1519: from zpb_hierarchies
1520: where dimension_id = p_dimension_id);
1521:
1522: -- delete hier_level_scope
1523: delete zpb_hier_level_scope
1524: where hier_id in (select hierarchy_id
1525: from zpb_hierarchies
1526: where dimension_id = p_dimension_id);
1527:

Line 1636: delete zpb_hier_level

1632: delete zpb_hierarchies_tl
1633: where hierarchy_id = p_hierarchy_id;
1634:
1635: -- delete hier_level
1636: delete zpb_hier_level
1637: where hier_id = p_hierarchy_id;
1638:
1639: -- delete hier_level_scope
1640: delete zpb_hier_level_scope

Line 1640: delete zpb_hier_level_scope

1636: delete zpb_hier_level
1637: where hier_id = p_hierarchy_id;
1638:
1639: -- delete hier_level_scope
1640: delete zpb_hier_level_scope
1641: where hier_id = p_hierarchy_id;
1642:
1643: -- delete hier_scope
1644: delete zpb_hier_scope

Line 1732: delete zpb_hier_level

1728: table_id in (select table_id
1729: from zpb_tables
1730: where bus_area_id = bus_area_id_num);
1731:
1732: delete zpb_hier_level
1733: where last_update_date < p_start_time
1734: and hier_id in (select hier.hierarchy_id
1735: from zpb_hierarchies hier,
1736: zpb_dimensions dim

Line 2372: -- zpb_hier_levels as we do not want to store personal-personal table column id there

2368: -- insert hier-level entry
2369: m_hier_level_en.LevelOrder := m_level_order;
2370:
2371: -- If we are building MD for a personal-personal hierarchy, do not update
2372: -- zpb_hier_levels as we do not want to store personal-personal table column id there
2373: if (p_type='PERSONAL' and m_level_en.PersLevelFlag='Y') or p_type='SHARED' then
2374: m_hier_level_id := insertHierLevelRecord(m_hier_level_en);
2375: end if;
2376:

Line 5322: delete zpb_hier_level_scope

5318: zpb_dimensions dims
5319: where hier.dimension_id = dims.dimension_id and
5320: dims.bus_area_id = bus_area_id_num);
5321:
5322: delete zpb_hier_level_scope
5323: where user_id = to_number(p_user) and
5324: hier_id in (select hierarchy_id
5325: from zpb_hierarchies hier,
5326: zpb_dimensions dims

Line 5449: from zpb_hier_level hl,

5445:
5446: -- cursor for scoping level of null hierarchies of range dimensions
5447: cursor c_range_dim_null_hier_levels is
5448: select hl.hier_id, hl.level_id, hl.pers_col_id
5449: from zpb_hier_level hl,
5450: zpb_dimensions dims,
5451: zpb_attributes attr,
5452: zpb_hierarchies hier
5453: where dims.bus_area_id = bus_area_id_num and

Line 5664: -- Run Query that will update zpb_hier_level_scope pers_col_id entries

5660:
5661: exit when lj = 0;
5662: end loop; -- End level loop
5663:
5664: -- Run Query that will update zpb_hier_level_scope pers_col_id entries
5665: -- for all levels of hierarchy for this user back to the pers_col_id column
5666: -- of zpb_hier_level if user had no personal levels for this hierarchy
5667: if l_persLvl = false then
5668:

Line 5666: -- of zpb_hier_level if user had no personal levels for this hierarchy

5662: end loop; -- End level loop
5663:
5664: -- Run Query that will update zpb_hier_level_scope pers_col_id entries
5665: -- for all levels of hierarchy for this user back to the pers_col_id column
5666: -- of zpb_hier_level if user had no personal levels for this hierarchy
5667: if l_persLvl = false then
5668:
5669: update zpb_hier_level_scope hlevscope
5670: set hlevscope.pers_col_id = (select pers_col_id from zpb_hier_level hlev

Line 5669: update zpb_hier_level_scope hlevscope

5665: -- for all levels of hierarchy for this user back to the pers_col_id column
5666: -- of zpb_hier_level if user had no personal levels for this hierarchy
5667: if l_persLvl = false then
5668:
5669: update zpb_hier_level_scope hlevscope
5670: set hlevscope.pers_col_id = (select pers_col_id from zpb_hier_level hlev
5671: where hlevscope.hier_id = hlev.hier_id and
5672: hlevscope.level_id = hlev.level_id)
5673: where hlevscope.user_id = l_user_id and

Line 5670: set hlevscope.pers_col_id = (select pers_col_id from zpb_hier_level hlev

5666: -- of zpb_hier_level if user had no personal levels for this hierarchy
5667: if l_persLvl = false then
5668:
5669: update zpb_hier_level_scope hlevscope
5670: set hlevscope.pers_col_id = (select pers_col_id from zpb_hier_level hlev
5671: where hlevscope.hier_id = hlev.hier_id and
5672: hlevscope.level_id = hlev.level_id)
5673: where hlevscope.user_id = l_user_id and
5674: hlevscope.resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

Line 5706: from zpb_hier_level

5702: l_dummy_num := insertHierScopeRecord(l_hier_scope_en);
5703:
5704: select hier_id, level_id, pers_col_id
5705: into l_hl_scope_en.HierId, l_hl_scope_en.LevelId, l_hl_scope_en.PersColId
5706: from zpb_hier_level
5707: where hier_id = l_hier_scope_en.HierarchyId;
5708:
5709: l_hl_scope_en.UserId := l_user_id;
5710:

Line 5813: delete zpb_hier_level_scope

5809: where hier.dimension_id = dims.dimension_id and
5810: dims.bus_area_id = bus_area_id_num and
5811: dims.dimension_id = l_dimension_id);
5812:
5813: delete zpb_hier_level_scope
5814: where user_id = l_user_id and
5815: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5816: last_update_date < l_start_time and
5817: hier_id in (select hierarchy_id

Line 5913: delete zpb_hier_level

5909: from zpb_hierarchies
5910: where dimension_id = v_dim.dimension_id);
5911:
5912: -- delete hier_level
5913: delete zpb_hier_level
5914: where hier_id in (select hierarchy_id
5915: from zpb_hierarchies
5916: where dimension_id = v_dim.dimension_id);
5917:

Line 5919: delete zpb_hier_level_scope

5915: from zpb_hierarchies
5916: where dimension_id = v_dim.dimension_id);
5917:
5918: -- delete hier_level_scope
5919: delete zpb_hier_level_scope
5920: where hier_id in (select hierarchy_id
5921: from zpb_hierarchies
5922: where dimension_id = v_dim.dimension_id);
5923: