APPS.ZPB_METADATA_PKG dependencies on ZPB_CUBE_HIER

Line 646: -- zpb_md_records.cube_hier_entry into zpb_cube_hier and

642: end insertCubeDimsRecord;
643:
644: -------------------------------------------------------------------------------
645: -- insertCubeHierRecord - Private function that inserts a
646: -- zpb_md_records.cube_hier_entry into zpb_cube_hier and
647: -- returns the primary key of the newly created entry
648: -------------------------------------------------------------------------------
649: function insertCubeHierRecord(p_cube_hier_rec zpb_md_records.cube_hier_entry)
650: return number is

Line 661: from zpb_cube_hier

657:
658: begin
659:
660: select relation_id into l_cube_hier_rec.RelationId
661: from zpb_cube_hier
662: where cube_id = l_cube_hier_rec.CubeId and
663: hierarchy_id = l_cube_hier_rec.HierarchyId;
664:
665: update zpb_cube_hier

Line 665: update zpb_cube_hier

661: from zpb_cube_hier
662: where cube_id = l_cube_hier_rec.CubeId and
663: hierarchy_id = l_cube_hier_rec.HierarchyId;
664:
665: update zpb_cube_hier
666: set
667:
668: COLUMN_ID = l_cube_hier_rec.ColumnId,
669: CREATED_BY = FND_GLOBAL.USER_ID,

Line 678: SELECT zpb_cube_hier_seq.NEXTVAL INTO l_cube_hier_rec.RelationId FROM DUAL;

674: where relation_id = l_cube_hier_rec.RelationId;
675:
676: exception
677: when NO_DATA_FOUND then
678: SELECT zpb_cube_hier_seq.NEXTVAL INTO l_cube_hier_rec.RelationId FROM DUAL;
679:
680: insert into zpb_cube_hier
681: (
682: COLUMN_ID,

Line 680: insert into zpb_cube_hier

676: exception
677: when NO_DATA_FOUND then
678: SELECT zpb_cube_hier_seq.NEXTVAL INTO l_cube_hier_rec.RelationId FROM DUAL;
679:
680: insert into zpb_cube_hier
681: (
682: COLUMN_ID,
683: CUBE_ID,
684: HIERARCHY_ID,

Line 1159: delete zpb_cube_hier

1155: -- delete cube mapping entries (to dims and hierarchies)
1156: delete zpb_cube_dims
1157: where cube_id = p_cube_id;
1158:
1159: delete zpb_cube_hier
1160: where cube_id = p_cube_id;
1161:
1162: -- finally delete cube entry
1163: delete zpb_cubes

Line 3202: -- (zpb_cube_dims) and its hierarchies (zpb_cube_hier)

3198: end BUILD_DIMS;
3199:
3200: -------------------------------------------------------------------------------
3201: -- BUILD_CUBE -Exposes metadata for a cube (zpb_cubes), its dimensionality
3202: -- (zpb_cube_dims) and its hierarchies (zpb_cube_hier)
3203: --
3204: -- IN: p_aw - The AW
3205: -- p_cubeView - The name of the cube
3206: -- p_dims - Dimensionality of cube