APPS.CNDISL_SLICE_DEF_DIM_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, column_map_id,

69: X_rup_dest_column_id number) IS
70:
71: BEGIN
72:
73: INSERT INTO cn_column_maps (table_map_id, column_map_id,
74: source_column_id, group_by_flag,
75: destination_column_id)
76: VALUES (X_table_map_id, X_column_map_id,
77: X_source_column_id, X_group_by_flag,

Line 93: INSERT INTO cn_column_maps (table_map_id, column_map_id,

89:
90:
91: -- Temp. slice table definition ----------
92:
93: INSERT INTO cn_column_maps (table_map_id, column_map_id,
94: source_column_id, group_by_flag,
95: destination_column_id)
96: VALUES (X_tmp_table_map_id, X_tmp_column_map_id,
97: X_source_column_id, X_group_by_flag,

Line 112: INSERT INTO cn_column_maps (table_map_id, column_map_id,

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,
113: source_column_id, group_by_flag,
114: destination_column_id)
115: VALUES (X_rup_table_map_id, X_rup_column_map_id,
116: X_source_column_id, X_group_by_flag,

Line 141: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;

137: X_rup_column_map_id number,
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;

Line 144: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;

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:
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;

Line 147: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_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:
150: END Delete_Row;
151: