APPS.CN_PROC_BATCHES_PKG dependencies on CN_HIERARCHY_NODES_ALL

Line 270: UPDATE cn_hierarchy_nodes_all

266: AND value_external_id = rc.revenue_class_id
267: AND ancestor_external_id = rc.revenue_class_id);
268: BEGIN
269: FOR CLASS IN classes LOOP
270: UPDATE cn_hierarchy_nodes_all
271: SET external_id = CLASS.revenue_class_id
272: , last_update_date = SYSDATE
273: , last_update_login = l_login_id
274: , last_updated_by = l_user_id

Line 284: INSERT INTO cn_hierarchy_nodes_all

280: AND NAME = CLASS.NAME
281: AND dim_hierarchy_id = x_dim_hierarchy
282: AND org_id = g_org_id;
283:
284: INSERT INTO cn_hierarchy_nodes_all
285: (
286: dim_hierarchy_id
287: , value_id
288: , external_id

Line 322: FROM cn_hierarchy_nodes_all

318: , g_org_id
319: FROM SYS.DUAL
320: WHERE NOT EXISTS(
321: SELECT 1
322: FROM cn_hierarchy_nodes_all
323: WHERE dim_hierarchy_id = x_dim_hierarchy
324: AND external_id = CLASS.revenue_class_id
325: AND org_id = g_org_id));
326:

Line 331: FROM cn_hierarchy_nodes_all

327: UPDATE cn_dim_explosion_all
328: SET ancestor_external_id = CLASS.revenue_class_id
329: WHERE ancestor_id IN(
330: SELECT value_id
331: FROM cn_hierarchy_nodes_all
332: WHERE dim_hierarchy_id = x_dim_hierarchy
333: AND external_id = CLASS.revenue_class_id
334: AND org_id = g_org_id)
335: AND dim_hierarchy_id = x_dim_hierarchy

Line 343: FROM cn_hierarchy_nodes_all

339: UPDATE cn_dim_explosion_all
340: SET value_external_id = CLASS.revenue_class_id
341: WHERE value_id IN(
342: SELECT value_id
343: FROM cn_hierarchy_nodes_all
344: WHERE dim_hierarchy_id = x_dim_hierarchy
345: AND external_id = CLASS.revenue_class_id
346: AND org_id = g_org_id)
347: AND dim_hierarchy_id = x_dim_hierarchy