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 732: cn_dim_hierarchies_pvt.Create_Edge

728: parent_value_id = l_parent_value_id))
729: ;
730: EXCEPTION
731: WHEN no_data_found THEN
732: cn_dim_hierarchies_pvt.Create_Edge
733: (p_api_version => 1.0,
734: p_init_msg_list => FND_API.G_TRUE,
735: p_dim_hierarchy_id => p_dim_hierarchy_id,
736: p_parent_value_id => l_parent_value_id,

Line 832: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies

828: -- Start of comments
829: -- API name : Hierarchy_Import
830: -- Type : Private.
831: -- Function : programtransfer data from staging table into
832: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies
833: -- cn_hierarchy_nodes, cn_hierarchy_edges
834: -- Pre-reqs : None.
835: -- Parameters :
836: -- IN : p_imp_header_id IN NUMBER,

Line 869: l_dim_hierarchy_id cn_dim_hierarchies.dim_hierarchy_id%TYPE;

865: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
866:
867: l_dimension_id cn_dimensions_all_b.dimension_id%TYPE;
868: l_head_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
869: l_dim_hierarchy_id cn_dim_hierarchies.dim_hierarchy_id%TYPE;
870: l_hier_record imp_hier_rec_type;
871: l_base_tbl_id cn_obj_tables_v.table_id%TYPE;
872: l_primary_key_id cn_obj_columns_v.column_id%TYPE;
873: l_hier_value_id cn_obj_columns_v.column_id%TYPE;