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_DIMENSIONS

Line 8: -- zpb_md_records.dimensions_entry into zpb_dimensions and

4: G_PKG_NAME CONSTANT VARCHAR2(16) := 'ZPB_METADATA_PKG';
5:
6: -------------------------------------------------------------------------------
7: -- insertDimensionRecord - Private function that inserts a
8: -- zpb_md_records.dimensions_entry into zpb_dimensions and
9: -- returns the primary key of the newly created entry
10: --
11: -- if p_primary_key_provided is true, then the primary key for the
12: -- dimension to be inserted is provided and we do not select it from sequence

Line 33: from zpb_dimensions

29:
30: begin
31:
32: select dimension_id into l_dimension_rec.DimensionId
33: from zpb_dimensions
34: where bus_area_id = bus_area_id_num and
35: epb_id = l_dimension_rec.EpbId;
36:
37: update zpb_dimensions

Line 37: update zpb_dimensions

33: from zpb_dimensions
34: where bus_area_id = bus_area_id_num and
35: epb_id = l_dimension_rec.EpbId;
36:
37: update zpb_dimensions
38: set
39: AW_NAME = l_dimension_rec.AwName,
40: DEFAULT_HIER = l_dimension_rec.DefaultHier,
41: DEFAULT_MEMBER = l_dimension_rec.DefaultMember,

Line 63: SELECT zpb_dimensions_seq.NEXTVAL INTO l_dimension_rec.DimensionId FROM DUAL;

59:
60:
61: exception
62: when NO_DATA_FOUND then
63: SELECT zpb_dimensions_seq.NEXTVAL INTO l_dimension_rec.DimensionId FROM DUAL;
64: insert_flag := true;
65: end;
66: end if;
67:

Line 70: insert into zpb_dimensions

66: end if;
67:
68: if insert_flag=true then
69:
70: insert into zpb_dimensions
71: (
72: AW_NAME,
73: BUS_AREA_ID,
74: DEFAULT_HIER,

Line 866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl

862:
863:
864: -------------------------------------------------------------------------------
865: -- insertDimensionsTLRecord - Private procedure that inserts a
866: -- zpb_md_records.dimensions_tl_entry into zpb_dimensions_tl
867: -------------------------------------------------------------------------------
868: procedure insertDimensionsTLRecord(p_dimensions_tl_rec zpb_md_records.dimensions_tl_entry)
869: is
870: l_dimensions_tl_rec zpb_md_records.dimensions_tl_entry;

Line 875: delete zpb_dimensions_tl

871: begin
872:
873: l_dimensions_tl_rec := p_dimensions_tl_rec;
874:
875: delete zpb_dimensions_tl
876: where dimension_id = l_dimensions_tl_rec.DimensionId and
877: language = l_dimensions_tl_rec.Language;
878:
879: insert into zpb_dimensions_tl

Line 879: insert into zpb_dimensions_tl

875: delete zpb_dimensions_tl
876: where dimension_id = l_dimensions_tl_rec.DimensionId and
877: language = l_dimensions_tl_rec.Language;
878:
879: insert into zpb_dimensions_tl
880: (
881: DIMENSION_ID,
882: LANGUAGE,
883: LONG_NAME,

Line 1485: delete zpb_dimensions_tl

1481:
1482: begin
1483:
1484: -- delete dimensions_tl
1485: delete zpb_dimensions_tl
1486: where dimension_id = p_dimension_id;
1487:
1488: -- delete attribute_scope
1489: delete zpb_attribute_scope

Line 1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1563: where dimension_id = p_dimension_id;
1564:
1565:
1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

Line 1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1564:
1565:
1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1572:

Line 1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1572:
1573: -- Finally delete dimension
1574: delete zpb_dimensions

Line 1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1572:
1573: -- Finally delete dimension
1574: delete zpb_dimensions
1575: where dimension_id = p_dimension_id;

Line 1574: delete zpb_dimensions

1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1572:
1573: -- Finally delete dimension
1574: delete zpb_dimensions
1575: where dimension_id = p_dimension_id;
1576:
1577: end deleteDimensionRecord;
1578:

Line 1670: from zpb_dimensions

1666: bus_area_id_num number;
1667:
1668: CURSOR c_dimensions is
1669: select dimension_id
1670: from zpb_dimensions
1671: where bus_area_id = bus_area_id_num and
1672: last_update_date < p_start_time;
1673:
1674: v_dim c_dimensions%ROWTYPE;

Line 1681: from zpb_dimensions

1677: select attribute_id
1678: from zpb_attributes
1679: where last_update_date < p_start_time and
1680: dimension_id in (select dimension_id
1681: from zpb_dimensions
1682: where bus_area_id = bus_area_id_num);
1683:
1684: v_attribute c_attributes%ROWTYPE;
1685:

Line 1691: from zpb_dimensions

1687: select hierarchy_id
1688: from zpb_hierarchies
1689: where last_update_date < p_start_time and
1690: dimension_id in (select dimension_id
1691: from zpb_dimensions
1692: where bus_area_id = bus_area_id_num);
1693:
1694: v_hierarchy c_hierarchies%ROWTYPE;
1695:

Line 1701: from zpb_dimensions

1697: select level_id
1698: from zpb_levels
1699: where last_update_date < p_start_time and
1700: dimension_id in (select dimension_id
1701: from zpb_dimensions
1702: where bus_area_id = bus_area_id_num);
1703:
1704: v_level c_levels%ROWTYPE;
1705:

Line 1736: zpb_dimensions dim

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
1737: where hier.dimension_id = dim.dimension_id and
1738: dim.bus_area_id = bus_area_id_num);
1739:
1740: end cleanOldEntries;

Line 1897: from zpb_dimensions

1893: -- Get primary key for newly created dimension entry
1894: begin
1895:
1896: select dimension_id into m_dimension_en.DimensionId
1897: from zpb_dimensions
1898: where bus_area_id = bus_area_id_num and
1899: epb_id = m_dimension_en.EPBId;
1900:
1901: m_dimension_exists := false;

Line 1905: SELECT zpb_dimensions_seq.NEXTVAL INTO m_dimension_en.DimensionId FROM DUAL;

1901: m_dimension_exists := false;
1902:
1903: exception
1904: when NO_DATA_FOUND then
1905: SELECT zpb_dimensions_seq.NEXTVAL INTO m_dimension_en.DimensionId FROM DUAL;
1906: m_dimension_exists := true;
1907: end;
1908:
1909:

Line 2671: -- from zpb_dimensions

2667:
2668: -- begin
2669:
2670: -- select dimension_id into m_attr_rangedim_en.DimensionId
2671: -- from zpb_dimensions
2672: -- where bus_area_id = bus_area_id_num and
2673: -- epb_id = m_attr_rangedim_en.EPBId;
2674:
2675: -- exception

Line 2677: -- SELECT zpb_dimensions_seq.NEXTVAL INTO m_attr_rangedim_en.DimensionId FROM DUAL;

2673: -- epb_id = m_attr_rangedim_en.EPBId;
2674:
2675: -- exception
2676: -- when NO_DATA_FOUND then
2677: -- SELECT zpb_dimensions_seq.NEXTVAL INTO m_attr_rangedim_en.DimensionId FROM DUAL;
2678: -- end;
2679:
2680: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2681:

Line 3306: -- find appropriate dimension in zpb_dimensions

3302:
3303: -- initialize cube_dim entry
3304: m_cube_dims_en.cubeId := m_cube_num;
3305:
3306: -- find appropriate dimension in zpb_dimensions
3307: begin
3308:
3309: select dimension_id into m_cube_dims_en.dimensionId
3310: from zpb_dimensions

Line 3310: from zpb_dimensions

3306: -- find appropriate dimension in zpb_dimensions
3307: begin
3308:
3309: select dimension_id into m_cube_dims_en.dimensionId
3310: from zpb_dimensions
3311: where epb_id = l_dim and bus_area_id = bus_area_id_num;
3312:
3313: exception
3314: when no_data_found then

Line 4843: from zpb_dimensions

4839: each.DIMENSION_NAME||''')');
4840:
4841: -- set dimension id for cube-dims relation
4842: select dimension_id into m_cube_dims_en.dimensionId
4843: from zpb_dimensions
4844: where epb_id = l_dim and
4845: bus_area_id = bus_area_id_num;
4846:
4847: m_column_en.ColumnType :='MEMBER_COLUMN';

Line 5037: from zpb_dimensions

5033: m_column_en.AWName :='NA';
5034:
5035: -- set dimension id for cube-dims relation
5036: select dimension_id into m_cube_dims_en.dimensionId
5037: from zpb_dimensions
5038: where epb_id = l_dim and
5039: bus_area_id = bus_area_id_num;
5040:
5041: m_cube_dims_en.ColumnId := insertColumnRecord(m_column_en);

Line 5318: zpb_dimensions dims

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
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

Line 5326: zpb_dimensions dims

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
5327: where hier.dimension_id = dims.dimension_id and
5328: dims.bus_area_id = bus_area_id_num);
5329:
5330: delete zpb_attribute_scope

Line 5334: zpb_dimensions dims

5330: delete zpb_attribute_scope
5331: where user_id = to_number(p_user) and
5332: attribute_id in (select attribute_id
5333: from zpb_attributes attr,
5334: zpb_dimensions dims
5335: where attr.dimension_id = dims.dimension_id and
5336: dims.bus_area_id = bus_area_id_num);
5337:
5338: end if;

Line 5440: zpb_dimensions dims,

5436: -- cursor for scoping null hierarchies of range dimensions
5437: cursor c_range_dim_null_hiers is
5438: select hier.hierarchy_id, hier.pers_table_id
5439: from zpb_hierarchies hier,
5440: zpb_dimensions dims,
5441: zpb_attributes attr
5442: where dims.bus_area_id = bus_area_id_num and
5443: dims.dimension_id = attr.range_dim_id and
5444: dims.dimension_id = hier.dimension_id;

Line 5450: zpb_dimensions dims,

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
5454: dims.dimension_id = attr.range_dim_id and

Line 5461: from zpb_dimensions dims,

5457:
5458: -- cursor for scoping attributes of personal range dimensions
5459: cursor c_range_dim_attrs is
5460: select attr2.attribute_id
5461: from zpb_dimensions dims,
5462: zpb_attributes attr,
5463: zpb_attributes attr2
5464: where dims.bus_area_id = bus_area_id_num and
5465: dims.dimension_id = attr.range_dim_id and

Line 5500: from zpb_dimensions

5496: -- flag tracks whether user has access to at least one hierarchy for each dimension
5497: l_accessToAHier:= false;
5498:
5499: select dimension_id into l_dimension_id
5500: from zpb_dimensions
5501: where epb_id = l_dim and
5502: bus_area_id = bus_area_id_num;
5503:
5504: -- Reset all of the personal personal hierarchy table id's to the personal

Line 5515: zpb_dimensions dims

5511: where hscope.user_id = l_user_id and
5512: hscope.user_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5513: hscope.hierarchy_id in (select hierarchy_id
5514: from zpb_hierarchies hier,
5515: zpb_dimensions dims
5516: where hier.dimension_id = dims.dimension_id and
5517: dims.bus_area_id = bus_area_id_num and
5518: dims.dimension_id = l_dimension_id);
5519:

Line 5808: zpb_dimensions dims

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
5807: from zpb_hierarchies hier,
5808: zpb_dimensions dims
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:

Line 5819: zpb_dimensions dims

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
5818: from zpb_hierarchies hier,
5819: zpb_dimensions dims
5820: where hier.dimension_id = dims.dimension_id and
5821: dims.bus_area_id = bus_area_id_num and
5822: dims.dimension_id = l_dimension_id);
5823:

Line 5830: zpb_dimensions dims

5826: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5827: last_update_date < l_start_time and
5828: attribute_id in (select attribute_id
5829: from zpb_attributes attr,
5830: zpb_dimensions dims
5831: where attr.dimension_id = dims.dimension_id and
5832: dims.bus_area_id = bus_area_id_num and
5833: dims.dimension_id = l_dimension_id);
5834:

Line 5856: from zpb_dimensions

5852: procedure cleanBusArea(p_bus_area_id in number) is
5853:
5854: CURSOR c_dimensions is
5855: select dimension_id
5856: from zpb_dimensions
5857: where bus_area_id = p_bus_area_id;
5858:
5859: v_dim c_dimensions%ROWTYPE;
5860:

Line 5881: delete zpb_dimensions_tl

5877: -- loop over dimensions
5878: for v_dim in c_dimensions loop
5879:
5880: -- delete dimensions_tl
5881: delete zpb_dimensions_tl
5882: where dimension_id = v_dim.dimension_id;
5883:
5884: -- delete attribute_scope
5885: delete zpb_attribute_scope

Line 5945: delete zpb_dimensions

5941: delete zpb_levels
5942: where dimension_id = v_dim.dimension_id;
5943:
5944: -- Finally delete dimension
5945: delete zpb_dimensions
5946: where dimension_id = v_dim.dimension_id;
5947: end loop;
5948:
5949: for v_table in c_tables loop