APPS.CN_SYS_TABLES_PVT dependencies on CN_OBJECTS

Line 67: -- Function : Create the information for the table in cn_objects

63: --{{{ Create_Table
64: -- Start of comments
65: -- API name : Create_Table
66: -- Type : Private.
67: -- Function : Create the information for the table in cn_objects
68: -- Also create the columns associated with the table
69: -- Pre-reqs : None.
70: -- Parameters :
71: -- IN : p_api_version IN NUMBER Required

Line 157: select cn_objects_s1.nextval

153: l_alias := l_alias || substr(p_table_rec.name, l_count + 1, 1);
154: l_count := instr(p_table_rec.name, '_', l_count + 1, 1);
155: end loop;
156:
157: select cn_objects_s1.nextval
158: into l_count
159: from dual;
160:
161: l_alias := l_alias || l_count;

Line 164: SELECT nvl(p_table_rec.object_id,cn_objects_s.nextval)

160:
161: l_alias := l_alias || l_count;
162: end if;
163:
164: SELECT nvl(p_table_rec.object_id,cn_objects_s.nextval)
165: INTO l_object_id
166: FROM dual;
167:
168: l_table_rec.object_id := l_object_id ;

Line 654: FROM cn_objects

650: and dimension_hierarchy_id is null;
651:
652: CURSOR l_col_csr ( p_object_id number ) IS
653: SELECT object_id, column_datatype,org_id
654: FROM cn_objects
655: WHERE object_id = p_object_id
656: AND org_id=p_column_rec.org_id
657: AND table_id = -11803;
658:

Line 863: l_table_rec cn_objects%ROWTYPE;

859: l_col_count number := 0;
860: l_data_type VARCHAR2(9);
861: l_data_len NUMBER(15);
862: l_column_data_type VARCHAR2(30);
863: l_table_rec cn_objects%ROWTYPE;
864: l_column_id number;
865: l_object_version_number number;
866:
867: l_return_status varchar2(1);

Line 873: FROM cn_objects

869: l_msg_data varchar2(2000);
870:
871: CURSOR l_tbl_csr IS
872: SELECT *
873: FROM cn_objects
874: WHERE name = p_table_name
875: AND schema = p_schema_name
876: AND org_id=p_column_rec.org_id
877: AND object_type = 'TBL';

Line 888: FROM cn_objects

884: AND col.table_name = syn.table_name
885: AND col.column_name = p_column_name
886: AND NOT EXISTS
887: (SELECT name
888: FROM cn_objects
889: WHERE table_id = p_table_id
890: AND name = p_column_name
891: AND org_id=p_column_rec.org_id
892: AND object_type = 'COL');

Line 956: SELECT cn_objects_s.nextval

952: ELSE
953: l_column_data_type := 'ALPN';
954: END IF;
955:
956: SELECT cn_objects_s.nextval
957: INTO l_column_id
958: FROM dual;
959:
960: cn_obj_tables_pkg.begin_record(