eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SYS_TABLES_PVT dependencies on CN_OBJECTS

Line 5: object_id cn_objects.object_id%TYPE

1: PACKAGE CN_SYS_TABLES_PVT AS
2: --$Header: cnvsytbs.pls 120.2 2005/08/08 04:45:32 rramakri noship $
3:
4: TYPE table_rec_type IS RECORD (
5: object_id cn_objects.object_id%TYPE
6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE

Line 6: , name cn_objects.name%TYPE

2: --$Header: cnvsytbs.pls 120.2 2005/08/08 04:45:32 rramakri noship $
3:
4: TYPE table_rec_type IS RECORD (
5: object_id cn_objects.object_id%TYPE
6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE

Line 7: , description cn_objects.description%TYPE

3:
4: TYPE table_rec_type IS RECORD (
5: object_id cn_objects.object_id%TYPE
6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE

Line 8: , status cn_objects.object_status%TYPE

4: TYPE table_rec_type IS RECORD (
5: object_id cn_objects.object_id%TYPE
6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE

Line 9: , repository_id cn_objects.repository_id%TYPE

5: object_id cn_objects.object_id%TYPE
6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE

Line 10: , alias cn_objects.alias%TYPE

6: , name cn_objects.name%TYPE
7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE

Line 11: , table_level cn_objects.table_level%TYPE

7: , description cn_objects.description%TYPE
8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE

Line 12: , table_type cn_objects.table_level%TYPE

8: , status cn_objects.object_status%TYPE
9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE

Line 13: , object_type cn_objects.object_type%TYPE

9: , repository_id cn_objects.repository_id%TYPE
10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE

Line 14: , schema cn_objects.schema%TYPE

10: , alias cn_objects.alias%TYPE
11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE
18: , object_version_number cn_objects.object_version_number%TYPE

Line 15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE

11: , table_level cn_objects.table_level%TYPE
12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE
18: , object_version_number cn_objects.object_version_number%TYPE
19: );

Line 16: , user_name cn_objects.user_name%TYPE

12: , table_type cn_objects.table_level%TYPE
13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE
18: , object_version_number cn_objects.object_version_number%TYPE
19: );
20:

Line 17: , org_id cn_objects.org_id%TYPE

13: , object_type cn_objects.object_type%TYPE
14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE
18: , object_version_number cn_objects.object_version_number%TYPE
19: );
20:
21: TYPE column_rec_type IS RECORD (

Line 18: , object_version_number cn_objects.object_version_number%TYPE

14: , schema cn_objects.schema%TYPE
15: , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16: , user_name cn_objects.user_name%TYPE
17: , org_id cn_objects.org_id%TYPE
18: , object_version_number cn_objects.object_version_number%TYPE
19: );
20:
21: TYPE column_rec_type IS RECORD (
22: object_id cn_objects.object_id%TYPE

Line 22: object_id cn_objects.object_id%TYPE

18: , object_version_number cn_objects.object_version_number%TYPE
19: );
20:
21: TYPE column_rec_type IS RECORD (
22: object_id cn_objects.object_id%TYPE
23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE

Line 23: , user_name cn_objects.user_name%TYPE

19: );
20:
21: TYPE column_rec_type IS RECORD (
22: object_id cn_objects.object_id%TYPE
23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE

Line 24: , usage cn_objects.calc_formula_flag%TYPE

20:
21: TYPE column_rec_type IS RECORD (
22: object_id cn_objects.object_id%TYPE
23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE

Line 25: , foreign_key cn_objects.foreign_key%TYPE

21: TYPE column_rec_type IS RECORD (
22: object_id cn_objects.object_id%TYPE
23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE

Line 26: , dimension_id cn_objects.dimension_id%TYPE

22: object_id cn_objects.object_id%TYPE
23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE

Line 27: , user_column_name cn_objects.user_column_name%TYPE

23: , user_name cn_objects.user_name%TYPE
24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE

Line 28: , classification_column cn_objects.classification_column%TYPE

24: , usage cn_objects.calc_formula_flag%TYPE
25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE

Line 29: , column_datatype cn_objects.column_datatype%TYPE

25: , foreign_key cn_objects.foreign_key%TYPE
26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE

Line 30: , value_set_id cn_objects.value_set_id%TYPE

26: , dimension_id cn_objects.dimension_id%TYPE
27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE

Line 31: , primary_key cn_objects.primary_key%TYPE

27: , user_column_name cn_objects.user_column_name%TYPE
28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE
35: , object_version_number cn_objects.object_version_number%TYPE

Line 32: , position cn_objects.position%TYPE

28: , classification_column cn_objects.classification_column%TYPE
29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE
35: , object_version_number cn_objects.object_version_number%TYPE
36: );

Line 33: , custom_call cn_objects.custom_call%TYPE

29: , column_datatype cn_objects.column_datatype%TYPE
30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE
35: , object_version_number cn_objects.object_version_number%TYPE
36: );
37:

Line 34: , org_id cn_objects.org_id%TYPE

30: , value_set_id cn_objects.value_set_id%TYPE
31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE
35: , object_version_number cn_objects.object_version_number%TYPE
36: );
37:
38: -- Start of comments

Line 35: , object_version_number cn_objects.object_version_number%TYPE

31: , primary_key cn_objects.primary_key%TYPE
32: , position cn_objects.position%TYPE
33: , custom_call cn_objects.custom_call%TYPE
34: , org_id cn_objects.org_id%TYPE
35: , object_version_number cn_objects.object_version_number%TYPE
36: );
37:
38: -- Start of comments
39: -- API name : Create_Table

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

37:
38: -- Start of comments
39: -- API name : Create_Table
40: -- Type : Private.
41: -- Function : Create the information for the table in cn_objects
42: -- Also create the columns associated with the table
43: -- Pre-reqs : None.
44: -- Parameters :
45: -- IN : p_api_version IN NUMBER Required