APPS.CN_DIMENSIONS_PKG dependencies on CN_HEAD_HIERARCHIES

Line 194: from cn_dim_hierarchies d, cn_head_hierarchies h

190:
191: -- remove dangling head hierarchies, dim hierarchies and tree fragments
192: delete from cn_hierarchy_nodes e where dim_hierarchy_id in
193: (select d.dim_hierarchy_id
194: from cn_dim_hierarchies d, cn_head_hierarchies h
195: where h.dimension_id = X_DIMENSION_ID
196: --R12 MOAC Changes--Start
197: and h.org_id = X_ORG_ID
198: and h.org_id = d.org_id

Line 203: from cn_dim_hierarchies d, cn_head_hierarchies h

199: --R12 MOAC Changes--End
200: and d.header_dim_hierarchy_id = h.head_hierarchy_id);
201: delete from cn_hierarchy_edges e where dim_hierarchy_id in
202: (select d.dim_hierarchy_id
203: from cn_dim_hierarchies d, cn_head_hierarchies h
204: where h.dimension_id = X_DIMENSION_ID
205: --R12 MOAC Changes--Start
206: and h.org_id = X_ORG_ID
207: and h.org_id = d.org_id

Line 211: (select head_hierarchy_id from cn_head_hierarchies

207: and h.org_id = d.org_id
208: --R12 MOAC Changes--End
209: and d.header_dim_hierarchy_id = h.head_hierarchy_id);
210: delete from cn_dim_hierarchies d where header_dim_hierarchy_id in
211: (select head_hierarchy_id from cn_head_hierarchies
212: where dimension_id = X_DIMENSION_ID
213: --R12 MOAC Changes--Start
214: and org_id = X_ORG_ID);
215: --R12 MOAC Changes--End

Line 217: -- delete from cn_head_hierarchies and dimensions - handle MLS delete

213: --R12 MOAC Changes--Start
214: and org_id = X_ORG_ID);
215: --R12 MOAC Changes--End
216:
217: -- delete from cn_head_hierarchies and dimensions - handle MLS delete
218: delete from CN_HEAD_HIERARCHIES_ALL_TL
219: where dimension_id = X_DIMENSION_ID
220: and ORG_ID = X_ORG_ID;
221:

Line 218: delete from CN_HEAD_HIERARCHIES_ALL_TL

214: and org_id = X_ORG_ID);
215: --R12 MOAC Changes--End
216:
217: -- delete from cn_head_hierarchies and dimensions - handle MLS delete
218: delete from CN_HEAD_HIERARCHIES_ALL_TL
219: where dimension_id = X_DIMENSION_ID
220: and ORG_ID = X_ORG_ID;
221:
222: delete from CN_HEAD_HIERARCHIES_ALL_B

Line 222: delete from CN_HEAD_HIERARCHIES_ALL_B

218: delete from CN_HEAD_HIERARCHIES_ALL_TL
219: where dimension_id = X_DIMENSION_ID
220: and ORG_ID = X_ORG_ID;
221:
222: delete from CN_HEAD_HIERARCHIES_ALL_B
223: where dimension_id = X_DIMENSION_ID
224: and ORG_ID = X_ORG_ID;
225:
226: delete from CN_DIMENSIONS_ALL_TL