APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_OBJ_COLUMNS_V

Line 168: FROM cn_obj_columns_v

164:
165: -- Get IDs for PRIMARY_KEY
166: BEGIN
167: SELECT column_id INTO x_primary_key_id
168: FROM cn_obj_columns_v
169: WHERE name = p_hier_record.primary_key AND table_id = x_base_table_id and org_id=p_org_id
170: ;
171: EXCEPTION
172: -- primary_key not exist

Line 183: FROM cn_obj_columns_v

179:
180: -- Get IDs for HIERARCHY_VALUE
181: BEGIN
182: SELECT column_id INTO x_hier_value_id
183: FROM cn_obj_columns_v
184: WHERE name = p_hier_record.hierarchy_value
185: AND table_id = x_base_table_id and org_id=p_org_id
186: ;
187: EXCEPTION

Line 244: SELECT 1 INTO l_dummy FROM cn_obj_columns_v

240:
241: -- Check created/existed hierarchy type has same base table,pk,
242: -- hier_value within the import data
243: BEGIN
244: SELECT 1 INTO l_dummy FROM cn_obj_columns_v
245: WHERE table_id = x_base_table_id
246: AND dimension_id = x_dimension_id
247: AND column_id = x_primary_key_id
248: AND primary_key = 'Y' and org_id=p_org_id

Line 250: SELECT 1 INTO l_dummy FROM cn_obj_columns_v

246: AND dimension_id = x_dimension_id
247: AND column_id = x_primary_key_id
248: AND primary_key = 'Y' and org_id=p_org_id
249: ;
250: SELECT 1 INTO l_dummy FROM cn_obj_columns_v
251: WHERE table_id = x_base_table_id
252: AND column_id = x_hier_value_id
253: AND user_column_name = 'Y' and org_id=p_org_id
254: ;

Line 872: l_primary_key_id cn_obj_columns_v.column_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;
874: l_def_base_name cn_hierarchy_nodes.name%TYPE;
875:
876: -- cursor to get all record missed required field

Line 873: l_hier_value_id cn_obj_columns_v.column_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;
874: l_def_base_name cn_hierarchy_nodes.name%TYPE;
875:
876: -- cursor to get all record missed required field
877: CURSOR c_miss_required_csr IS