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.CNDISL_SLICE_DEF_DIM_PKG dependencies on CN_OBJ_COLUMNS_V

Line 40: FROM cn_obj_columns_v col,

36: BEGIN
37:
38: SELECT col.name, dim.name
39: INTO X_column_name, X_dimension_name
40: FROM cn_obj_columns_v col,
41: cn_dimensions dim
42: WHERE col.column_id = X_source_column_id
43: AND col.dimension_id = dim.dimension_id (+);
44:

Line 47: FROM cn_obj_columns_v

43: AND col.dimension_id = dim.dimension_id (+);
44:
45: SELECT name
46: INTO X_dest_column_name
47: FROM cn_obj_columns_v
48: WHERE column_id = X_dest_column_id;
49:
50: END Populate_Fields;
51:

Line 80: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

76: VALUES (X_table_map_id, X_column_map_id,
77: X_source_column_id, X_group_by_flag,
78: X_destination_column_id);
79:
80: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
81: status, repository_id, table_id, data_length,
82: data_type, nullable, primary_key, position,
83: dimension_id, data_scale, column_type, object_type)
84: (SELECT X_destination_column_id, X_column_name, 'N',

Line 88: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

84: (SELECT X_destination_column_id, X_column_name, 'N',
85: 'V', X_repository_id, X_table_id, data_length,
86: data_type, nullable, 'N', position,
87: dimension_id, data_scale, column_type, 'COL'
88: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
89:
90:
91: -- Temp. slice table definition ----------
92:

Line 100: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

96: VALUES (X_tmp_table_map_id, X_tmp_column_map_id,
97: X_source_column_id, X_group_by_flag,
98: X_tmp_dest_column_id);
99:
100: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
101: status, repository_id, table_id, data_length,
102: data_type, nullable, primary_key, position,
103: dimension_id, data_scale, column_type, object_type)
104: (SELECT X_tmp_dest_column_id, X_column_name, 'N',

Line 108: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

104: (SELECT X_tmp_dest_column_id, X_column_name, 'N',
105: 'V', X_repository_id, X_tmp_table_id, data_length,
106: data_type, nullable, 'N', position,
107: dimension_id, data_scale, column_type, 'COL'
108: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
109:
110: -- Temp. Rollup table definition ----------
111:
112: INSERT INTO cn_column_maps (table_map_id, column_map_id,

Line 119: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

115: VALUES (X_rup_table_map_id, X_rup_column_map_id,
116: X_source_column_id, X_group_by_flag,
117: X_rup_dest_column_id);
118:
119: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
120: status, repository_id, table_id, data_length,
121: data_type, nullable, primary_key, position,
122: dimension_id, data_scale, column_type, object_type)
123: (SELECT X_rup_dest_column_id, X_column_name, 'N',

Line 127: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

123: (SELECT X_rup_dest_column_id, X_column_name, 'N',
124: 'V', X_repository_id, X_rup_table_id, data_length,
125: data_type, nullable, 'N', position,
126: dimension_id, data_scale, column_type, 'COL'
127: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
128:
129: END Insert_Row;
130:
131: -- -----------------------------------------------------------

Line 142: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;

138: X_rup_dest_column_id number) IS
139: BEGIN
140:
141: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
142: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
143:
144: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
145: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
146:

Line 145: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;

141: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
142: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
143:
144: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
145: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
146:
147: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
148: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
149:

Line 148: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;

144: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
145: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
146:
147: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
148: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
149:
150: END Delete_Row;
151:
152: -- -----------------------------------------------------------