APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_HEAD_HIERARCHIES

Line 353: FROM cn_head_hierarchies

349: ('Start Import Head Hierarchy : ' || p_hier_record.hierarchy_name);
350: -- Create new head hierarchy if not exist
351: BEGIN
352: SELECT head_hierarchy_id INTO x_head_hierarchy_id
353: FROM cn_head_hierarchies
354: WHERE name = p_hier_record.hierarchy_name
355: AND dimension_id = p_dimension_id
356: AND org_id = p_org_id
357: ;

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 868: l_head_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;

864: l_msg_count NUMBER := 0;
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;