APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_LEVELS

Line 612: insert into ZPB_BUSAREA_LEVELS

608: p_level_id IN NUMBER,
609: p_hierarchy_id IN NUMBER)
610: is
611: begin
612: insert into ZPB_BUSAREA_LEVELS
613: (VERSION_ID,
614: LOGICAL_DIM_ID, -- "Consistent Dimension"
615: LEVEL_ID,
616: HIERARCHY_ID,

Line 722: delete from ZPB_BUSAREA_LEVELS

718:
719: delete from ZPB_BUSAREA_HIER_VERSIONS
720: where VERSION_ID = p_version_id;
721:
722: delete from ZPB_BUSAREA_LEVELS
723: where VERSION_ID = p_version_id;
724:
725: delete from ZPB_BUSAREA_ATTRIBUTES
726: where VERSION_ID = p_version_id;

Line 1131: insert into ZPB_BUSAREA_LEVELS

1127: FND_GLOBAL.USER_ID
1128: from ZPB_BUSAREA_HIER_VERSIONS
1129: where VERSION_ID = l_from_version_id;
1130:
1131: insert into ZPB_BUSAREA_LEVELS
1132: (VERSION_ID,
1133: LOGICAL_DIM_ID, -- "Consistent Dimension"
1134: HIERARCHY_ID,
1135: LEVEL_ID,

Line 1150: from ZPB_BUSAREA_LEVELS

1146: FND_GLOBAL.USER_ID,
1147: FND_GLOBAL.LOGIN_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID
1150: from ZPB_BUSAREA_LEVELS
1151: where VERSION_ID = l_from_version_id;
1152:
1153: insert into ZPB_BUSAREA_ATTRIBUTES
1154: (VERSION_ID,

Line 1746: delete from ZPB_BUSAREA_LEVELS

1742: where VERSION_ID = p_version_id
1743: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1744: and HIERARCHY_ID = p_hierarchy_id;
1745:
1746: delete from ZPB_BUSAREA_LEVELS
1747: where VERSION_ID = p_version_id
1748: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1749: and HIERARCHY_ID = p_hierarchy_id;
1750:

Line 1887: delete from ZPB_BUSAREA_LEVELS

1883: p_hierarchy_id IN NUMBER,
1884: p_level_id IN NUMBER)
1885: is
1886: begin
1887: delete from ZPB_BUSAREA_LEVELS
1888: where VERSION_ID = p_version_id
1889: and LOGICAL_DIM_ID = p_logical_dim_id -- "Consistent Dimension"
1890: and HIERARCHY_ID = p_hierarchy_id
1891: and LEVEL_ID = p_level_id;