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_ATTRIBUTES

Line 425: -- zpb_md_records.attributes_entry into zpb_attributes and

421: end insertHierLevelRecord;
422:
423: -------------------------------------------------------------------------------
424: -- inserAttributeRecord - Private function that inserts a
425: -- zpb_md_records.attributes_entry into zpb_attributes and
426: -- returns the primary key of the newly created entry
427: -------------------------------------------------------------------------------
428: function insertAttributeRecord(p_attr_rec zpb_md_records.attributes_entry)
429: return number is

Line 440: from zpb_attributes

436:
437: begin
438:
439: select attribute_id into l_attr_rec.AttributeId
440: from zpb_attributes
441: where dimension_id = l_attr_rec.DimensionId and
442: pers_cwm_name = l_attr_rec.PersCWMName;
443:
444: update zpb_attributes

Line 444: update zpb_attributes

440: from zpb_attributes
441: where dimension_id = l_attr_rec.DimensionId and
442: pers_cwm_name = l_attr_rec.PersCWMName;
443:
444: update zpb_attributes
445: set
446: DIMENSION_ID = l_attr_rec.DimensionId,
447: EPB_ID = l_attr_rec.EpbId,
448: LABEL = l_attr_rec.Label,

Line 463: SELECT zpb_attributes_seq.NEXTVAL INTO l_attr_rec.AttributeId FROM DUAL;

459: where attribute_id = l_attr_rec.AttributeId;
460:
461: exception
462: when NO_DATA_FOUND then
463: SELECT zpb_attributes_seq.NEXTVAL INTO l_attr_rec.AttributeId FROM DUAL;
464:
465: insert into zpb_attributes
466: (
467:

Line 465: insert into zpb_attributes

461: exception
462: when NO_DATA_FOUND then
463: SELECT zpb_attributes_seq.NEXTVAL INTO l_attr_rec.AttributeId FROM DUAL;
464:
465: insert into zpb_attributes
466: (
467:
468: ATTRIBUTE_ID,
469: DIMENSION_ID,

Line 819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl

815: end insertMeasureRecord;
816:
817: -------------------------------------------------------------------------------
818: -- insertAttributeTLRecord - Private procedure that inserts a
819: -- zpb_md_records.attributes_tl_entry into zpb_attributes_tl
820: -------------------------------------------------------------------------------
821: procedure insertAttributesTLRecord(p_attributes_tl_rec zpb_md_records.attributes_tl_entry)
822: is
823: l_attributes_tl_rec zpb_md_records.attributes_tl_entry;

Line 828: delete zpb_attributes_tl

824: begin
825:
826: l_attributes_tl_rec := p_attributes_tl_rec;
827:
828: delete zpb_attributes_tl
829: where attribute_id = l_attributes_tl_rec.AttributeId and
830: language = l_attributes_tl_rec.Language;
831:
832: insert into zpb_attributes_tl

Line 832: insert into zpb_attributes_tl

828: delete zpb_attributes_tl
829: where attribute_id = l_attributes_tl_rec.AttributeId and
830: language = l_attributes_tl_rec.Language;
831:
832: insert into zpb_attributes_tl
833: (
834: ATTRIBUTE_ID,
835: LANGUAGE,
836: LONG_NAME,

Line 1491: from zpb_attributes

1487:
1488: -- delete attribute_scope
1489: delete zpb_attribute_scope
1490: where attribute_id in (select attribute_id
1491: from zpb_attributes
1492: where dimension_id = p_dimension_id);
1493:
1494: -- delete attr_table_col
1495: delete zpb_attr_table_col

Line 1497: from zpb_attributes

1493:
1494: -- delete attr_table_col
1495: delete zpb_attr_table_col
1496: where attribute_id in (select attribute_id
1497: from zpb_attributes
1498: where dimension_id = p_dimension_id);
1499:
1500: -- delete attributes_tl
1501: delete zpb_attributes_tl

Line 1501: delete zpb_attributes_tl

1497: from zpb_attributes
1498: where dimension_id = p_dimension_id);
1499:
1500: -- delete attributes_tl
1501: delete zpb_attributes_tl
1502: where attribute_id in (select attribute_id
1503: from zpb_attributes
1504: where dimension_id = p_dimension_id);
1505:

Line 1503: from zpb_attributes

1499:
1500: -- delete attributes_tl
1501: delete zpb_attributes_tl
1502: where attribute_id in (select attribute_id
1503: from zpb_attributes
1504: where dimension_id = p_dimension_id);
1505:
1506: -- Finally delete attributes
1507: delete zpb_attributes

Line 1507: delete zpb_attributes

1503: from zpb_attributes
1504: where dimension_id = p_dimension_id);
1505:
1506: -- Finally delete attributes
1507: delete zpb_attributes
1508: where dimension_id = p_dimension_id;
1509:
1510: -- delete hierarchies_tl
1511: delete zpb_hierarchies_tl

Line 1596: delete zpb_attributes_tl

1592: delete zpb_attr_table_col
1593: where attribute_id = p_attribute_id;
1594:
1595: -- delete attributes_tl
1596: delete zpb_attributes_tl
1597: where attribute_id = p_attribute_id;
1598:
1599: -- detele zpb_attributes
1600: delete zpb_attributes

Line 1599: -- detele zpb_attributes

1595: -- delete attributes_tl
1596: delete zpb_attributes_tl
1597: where attribute_id = p_attribute_id;
1598:
1599: -- detele zpb_attributes
1600: delete zpb_attributes
1601: where attribute_id = p_attribute_id;
1602:
1603: end deleteAttributeRecord;

Line 1600: delete zpb_attributes

1596: delete zpb_attributes_tl
1597: where attribute_id = p_attribute_id;
1598:
1599: -- detele zpb_attributes
1600: delete zpb_attributes
1601: where attribute_id = p_attribute_id;
1602:
1603: end deleteAttributeRecord;
1604:

Line 1678: from zpb_attributes

1674: v_dim c_dimensions%ROWTYPE;
1675:
1676: CURSOR c_attributes is
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);

Line 5333: from zpb_attributes attr,

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

Line 5432: from zpb_attributes

5428:
5429: -- cursor for scoping special attributes
5430: cursor c_special_attrs is
5431: select attribute_id
5432: from zpb_attributes
5433: where dimension_id = l_dimension_id and
5434: type in ('TIMESPAN_ATTRIBUTE', 'ENDDATE_ATTRIBUTE', 'SHORT_VALUE_NAME_ATTRIBUTE', 'VALUE_NAME_ATTRIBUTE');
5435:
5436: -- cursor for scoping null hierarchies of range dimensions

Line 5441: zpb_attributes attr

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;
5445:

Line 5451: zpb_attributes attr,

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
5455: dims.dimension_id = hier.dimension_id and

Line 5462: zpb_attributes attr,

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
5466: dims.dimension_id = attr2.dimension_id;

Line 5463: zpb_attributes attr2

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
5466: dims.dimension_id = attr2.dimension_id;
5467:

Line 5774: from zpb_attributes

5770:
5771: l_attr_perscwm := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
5772:
5773: select attribute_id into l_attr_scope_en.AttributeId
5774: from zpb_attributes
5775: where dimension_id = l_dimension_id and
5776: pers_cwm_name = l_attr_perscwm;
5777:
5778: l_attr_scope_en.UserId := l_user_id;

Line 5829: from zpb_attributes attr,

5825: where user_id = l_user_id and
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);

Line 5887: from zpb_attributes

5883:
5884: -- delete attribute_scope
5885: delete zpb_attribute_scope
5886: where attribute_id in (select attribute_id
5887: from zpb_attributes
5888: where dimension_id = v_dim.dimension_id);
5889:
5890: -- delete attr_table_col
5891: delete zpb_attr_table_col

Line 5893: from zpb_attributes

5889:
5890: -- delete attr_table_col
5891: delete zpb_attr_table_col
5892: where attribute_id in (select attribute_id
5893: from zpb_attributes
5894: where dimension_id = v_dim.dimension_id);
5895:
5896: -- delete attributes_tl
5897: delete zpb_attributes_tl

Line 5897: delete zpb_attributes_tl

5893: from zpb_attributes
5894: where dimension_id = v_dim.dimension_id);
5895:
5896: -- delete attributes_tl
5897: delete zpb_attributes_tl
5898: where attribute_id in (select attribute_id
5899: from zpb_attributes
5900: where dimension_id = v_dim.dimension_id);
5901:

Line 5899: from zpb_attributes

5895:
5896: -- delete attributes_tl
5897: delete zpb_attributes_tl
5898: where attribute_id in (select attribute_id
5899: from zpb_attributes
5900: where dimension_id = v_dim.dimension_id);
5901:
5902: -- Finally delete attributes
5903: delete zpb_attributes

Line 5903: delete zpb_attributes

5899: from zpb_attributes
5900: where dimension_id = v_dim.dimension_id);
5901:
5902: -- Finally delete attributes
5903: delete zpb_attributes
5904: where dimension_id = v_dim.dimension_id;
5905:
5906: -- delete hierarchies_tl
5907: delete zpb_hierarchies_tl