APPS.ZPB_METADATA_PKG dependencies on ZPB_LEVELS_TL

Line 1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and

1057: end insertHierarchyTLRecord;
1058:
1059: -------------------------------------------------------------------------------
1060: -- insertLevelTLRecord - Private procedure that inserts a
1061: -- zpb_md_records.levels_tl_entry into zpb_levels_tl and
1062: -------------------------------------------------------------------------------
1063: procedure insertLevelTLRecord(p_levels_tl_rec in zpb_md_records.levels_tl_entry)
1064: is
1065: l_levels_tl_rec zpb_md_records.levels_tl_entry;

Line 1073: from zpb_levels_tl

1069:
1070: l_levels_tl_rec := p_levels_tl_rec;
1071:
1072: select count(*) into l_record_count
1073: from zpb_levels_tl
1074: where level_id = l_levels_tl_rec.LevelId and
1075: language = l_levels_tl_rec.Language;
1076:
1077: if l_record_count = 1 then

Line 1079: update zpb_levels_tl

1075: language = l_levels_tl_rec.Language;
1076:
1077: if l_record_count = 1 then
1078:
1079: update zpb_levels_tl
1080: set
1081: LONG_NAME = l_levels_tl_rec.LongName,
1082: NAME = l_levels_tl_rec.Name,
1083: PLURAL_LONG_NAME = l_levels_tl_rec.PluralLongName,

Line 1095: insert into zpb_levels_tl

1091: language = l_levels_tl_rec.Language;
1092:
1093: else
1094:
1095: insert into zpb_levels_tl
1096: (
1097: LEVEL_ID,
1098: LANGUAGE,
1099: LONG_NAME,

Line 1556: delete zpb_levels_tl

1552: delete zpb_hierarchies
1553: where dimension_id = p_dimension_id;
1554:
1555: -- delete levels_tl
1556: delete zpb_levels_tl
1557: where level_id in (select level_id
1558: from zpb_levels
1559: where dimension_id = p_dimension_id);
1560:

Line 1614: delete zpb_levels_tl

1610:
1611: begin
1612:
1613: -- delete levels_tl
1614: delete zpb_levels_tl
1615: where level_id = p_level_id;
1616:
1617: -- Finally delete levels
1618: delete zpb_levels

Line 5935: delete zpb_levels_tl

5931: delete zpb_hierarchies
5932: where dimension_id = v_dim.dimension_id;
5933:
5934: -- delete levels_tl
5935: delete zpb_levels_tl
5936: where level_id in (select level_id
5937: from zpb_levels
5938: where dimension_id = v_dim.dimension_id);
5939: