APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_DIM_HIERARCHIES

Line 217: cn_dim_hierarchies_pvt.Create_Hierarchy_Type

213: l_error_code := 'CN_HIER_DUP_BTBL';
214: RAISE FND_API.g_exc_error;
215: END;
216:
217: cn_dim_hierarchies_pvt.Create_Hierarchy_Type
218: (p_api_version => 1.0,
219: p_init_msg_list => FND_API.G_TRUE,
220: p_name => p_hier_record.hierarchy_type,
221: p_base_table_id => x_base_table_id,

Line 360: cn_dim_hierarchies_pvt.Create_Head_Hierarchy

356: AND org_id = p_org_id
357: ;
358: EXCEPTION
359: WHEN no_data_found THEN
360: cn_dim_hierarchies_pvt.Create_Head_Hierarchy
361: (p_api_version => 1.0,
362: p_init_msg_list => FND_API.G_TRUE,
363: p_name => p_hier_record.hierarchy_name,
364: p_dimension_id => p_dimension_id,

Line 468: FROM cn_dim_hierarchies

464: || p_hier_record.end_date);
465: -- Create new dim hierarchy if not exist
466: BEGIN
467: SELECT dim_hierarchy_id INTO x_dim_hierarchy_id
468: FROM cn_dim_hierarchies
469: WHERE header_dim_hierarchy_id = p_head_hierarchy_id
470: AND org_id = p_org_id
471: AND start_date = To_date(p_hier_record.start_date, 'DD/MM/YYYY')
472: AND Nvl(end_date,FND_API.g_miss_date) =

Line 478: cn_dim_hierarchies_pvt.Create_Dim_Hierarchy

474: ;
475:
476: EXCEPTION
477: WHEN no_data_found THEN
478: cn_dim_hierarchies_pvt.Create_Dim_Hierarchy
479: (p_api_version => 1.0,
480: p_init_msg_list => FND_API.G_TRUE,
481: p_head_hierarchy_id => p_head_hierarchy_id,
482: p_start_date => To_date(p_hier_record.start_date, 'DD/MM/YYYY'),

Line 726: cn_dim_hierarchies_pvt.Create_Edge

722: parent_value_id = l_parent_value_id))
723: ;
724: EXCEPTION
725: WHEN no_data_found THEN
726: cn_dim_hierarchies_pvt.Create_Edge
727: (p_api_version => 1.0,
728: p_init_msg_list => FND_API.G_TRUE,
729: p_dim_hierarchy_id => p_dim_hierarchy_id,
730: p_parent_value_id => l_parent_value_id,

Line 826: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies

822: -- Start of comments
823: -- API name : Hierarchy_Import
824: -- Type : Private.
825: -- Function : programtransfer data from staging table into
826: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies
827: -- cn_hierarchy_nodes, cn_hierarchy_edges
828: -- Pre-reqs : None.
829: -- Parameters :
830: -- IN : p_imp_header_id IN NUMBER,

Line 863: l_dim_hierarchy_id cn_dim_hierarchies.dim_hierarchy_id%TYPE;

859: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
860:
861: l_dimension_id cn_dimensions_all_b.dimension_id%TYPE;
862: l_head_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
863: l_dim_hierarchy_id cn_dim_hierarchies.dim_hierarchy_id%TYPE;
864: l_hier_record imp_hier_rec_type;
865: l_base_tbl_id cn_obj_tables_v.table_id%TYPE;
866: l_primary_key_id cn_obj_columns_v.column_id%TYPE;
867: l_hier_value_id cn_obj_columns_v.column_id%TYPE;