APPS.ZPB_METADATA_PKG dependencies on ZPB_HIERARCHIES_TL

Line 989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and

985: end insertHierarchyRecord;
986:
987: -------------------------------------------------------------------------------
988: -- insertHierarchyTLRecord - Private procedure that inserts a
989: -- zpb_md_records.hierarchies_tl_entry into zpb_hierarchies_tl and
990: -------------------------------------------------------------------------------
991: procedure insertHierarchyTLRecord(p_hierarchies_tl_rec in zpb_md_records.hierarchies_tl_entry)
992: is
993: l_hierarchies_tl_rec zpb_md_records.hierarchies_tl_entry;

Line 1001: from zpb_hierarchies_tl

997:
998: l_hierarchies_tl_rec := p_hierarchies_tl_rec;
999:
1000: select count(*) into l_record_count
1001: from zpb_hierarchies_tl
1002: where hierarchy_id = l_hierarchies_tl_rec.HierarchyId and
1003: language = l_hierarchies_tl_rec.Language;
1004:
1005: --Make sure do not try to insert hierarchy entry for same language twice

Line 1008: insert into zpb_hierarchies_tl

1004:
1005: --Make sure do not try to insert hierarchy entry for same language twice
1006: if l_record_count = 0 then
1007:
1008: insert into zpb_hierarchies_tl
1009: (
1010: HIERARCHY_ID,
1011: LANGUAGE,
1012: LONG_NAME,

Line 1040: update zpb_hierarchies_tl

1036: );
1037:
1038: else
1039:
1040: update zpb_hierarchies_tl
1041: set
1042:
1043: LONG_NAME = l_hierarchies_tl_rec.LongName,
1044: NAME = l_hierarchies_tl_rec.Name,

Line 1511: delete zpb_hierarchies_tl

1507: delete zpb_attributes
1508: where dimension_id = p_dimension_id;
1509:
1510: -- delete hierarchies_tl
1511: delete zpb_hierarchies_tl
1512: where hierarchy_id in (select hierarchy_id
1513: from zpb_hierarchies
1514: where dimension_id = p_dimension_id);
1515:

Line 1632: delete zpb_hierarchies_tl

1628:
1629: begin
1630:
1631: -- delete hierarchies_tl
1632: delete zpb_hierarchies_tl
1633: where hierarchy_id = p_hierarchy_id;
1634:
1635: -- delete hier_level
1636: delete zpb_hier_level

Line 5907: delete zpb_hierarchies_tl

5903: delete zpb_attributes
5904: where dimension_id = v_dim.dimension_id;
5905:
5906: -- delete hierarchies_tl
5907: delete zpb_hierarchies_tl
5908: where hierarchy_id in (select hierarchy_id
5909: from zpb_hierarchies
5910: where dimension_id = v_dim.dimension_id);
5911: