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_ATTRIBUTE_SCOPE

Line 1407: -- zpb_md_records.attribute_scope_entry into zpb_attribute_scope and

1403:
1404:
1405: -------------------------------------------------------------------------------
1406: -- insertAttributescopeRecord - Private function that inserts a
1407: -- zpb_md_records.attribute_scope_entry into zpb_attribute_scope and
1408: -- returns the primary key of the newly created entry
1409: -------------------------------------------------------------------------------
1410: function insertAttributescopeRecord(p_attribute_scope_rec zpb_md_records.attribute_scope_entry)
1411: return number is

Line 1422: from zpb_attribute_scope

1418:
1419: begin
1420:
1421: select scope_id into l_attribute_scope_rec.ScopeId
1422: from zpb_attribute_scope
1423: where attribute_id = l_attribute_scope_rec.AttributeId and
1424: user_id = l_attribute_scope_rec.UserId and
1425: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1426:

Line 1427: update zpb_attribute_scope

1423: where attribute_id = l_attribute_scope_rec.AttributeId and
1424: user_id = l_attribute_scope_rec.UserId and
1425: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1426:
1427: update zpb_attribute_scope
1428: set
1429:
1430: CREATED_BY = FND_GLOBAL.USER_ID,
1431: CREATION_DATE = sysdate,

Line 1439: SELECT zpb_attribute_scope_seq.NEXTVAL INTO l_attribute_scope_rec.ScopeId FROM DUAL;

1435: where scope_id = l_attribute_scope_rec.ScopeId;
1436:
1437: exception
1438: when NO_DATA_FOUND then
1439: SELECT zpb_attribute_scope_seq.NEXTVAL INTO l_attribute_scope_rec.ScopeId FROM DUAL;
1440:
1441: insert into zpb_attribute_scope
1442: (
1443: SCOPE_ID,

Line 1441: insert into zpb_attribute_scope

1437: exception
1438: when NO_DATA_FOUND then
1439: SELECT zpb_attribute_scope_seq.NEXTVAL INTO l_attribute_scope_rec.ScopeId FROM DUAL;
1440:
1441: insert into zpb_attribute_scope
1442: (
1443: SCOPE_ID,
1444: ATTRIBUTE_ID,
1445: USER_ID,

Line 1489: delete zpb_attribute_scope

1485: delete zpb_dimensions_tl
1486: where dimension_id = p_dimension_id;
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:

Line 1588: delete zpb_attribute_scope

1584:
1585: begin
1586:
1587: -- delete attribute_scope
1588: delete zpb_attribute_scope
1589: where attribute_id = p_attribute_id;
1590:
1591: -- delete attr_table_col
1592: delete zpb_attr_table_col

Line 5330: delete zpb_attribute_scope

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

Line 5824: delete zpb_attribute_scope

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:
5824: delete zpb_attribute_scope
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

Line 5885: delete zpb_attribute_scope

5881: delete zpb_dimensions_tl
5882: where dimension_id = v_dim.dimension_id;
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: