APPS.CNDISL_SLICE_ATTRIBUTES_PKG dependencies on CN_COLUMN_MAPS

Line 15: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval

11: X_rup_column_map_id IN OUT number,
12: X_rup_dest_column_id IN OUT number) IS
13: BEGIN
14:
15: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
16: INTO X_column_map_id, X_destination_column_id
17: FROM dual;
18:
19: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval

Line 19: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval

15: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
16: INTO X_column_map_id, X_destination_column_id
17: FROM dual;
18:
19: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
20: INTO X_tmp_column_map_id, X_tmp_dest_column_id
21: FROM dual;
22:
23: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval

Line 23: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval

19: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
20: INTO X_tmp_column_map_id, X_tmp_dest_column_id
21: FROM dual;
22:
23: SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
24: INTO X_rup_column_map_id, X_rup_dest_column_id
25: FROM dual;
26:
27: END Default_Rows;

Line 73: INSERT INTO cn_column_maps ( table_map_id,

69: BEGIN
70:
71: -- Slice table definition --
72:
73: INSERT INTO cn_column_maps ( table_map_id,
74: column_map_id,
75: source_column_id,
76: group_by_flag,
77: destination_column_id,

Line 97: INSERT INTO cn_column_maps ( table_map_id,

93: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
94:
95: -- Temp. slice table definition --
96:
97: INSERT INTO cn_column_maps ( table_map_id,
98: column_map_id,
99: source_column_id,
100: group_by_flag,
101: destination_column_id,

Line 121: INSERT INTO cn_column_maps ( table_map_id,

117: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
118:
119: -- Rollup table definition --
120:
121: INSERT INTO cn_column_maps ( table_map_id,
122: column_map_id,
123: source_column_id,
124: group_by_flag,
125: destination_column_id,

Line 156: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;

152: X_rup_dest_column_id number) IS
153:
154: BEGIN
155:
156: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
157: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
158:
159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;

Line 159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;

155:
156: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
157: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
158:
159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
161:
162: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
163: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;

Line 162: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;

158:
159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
161:
162: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
163: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
164:
165: END Delete_Row;
166: