[Home] [Help]
183: --
184: -- DESCRIPTION
185: -- This procedure removes the results generated by a Preview execution.
186: -- It deletes data from the FEM_ALLOC_PREVIEW_STATS and
187: -- FEM_ALLOC_PREVIEW_MAPS tables. It also calls
188: -- FEM_UD_PKG.Remove_Process_Locks to remove the Process Lock
189: -- registration data, and along with it the Preview temporary tables.
190: --
191: -- The Preview UI and FEM_BR_MAPPING_PREVIEW_PVT.DeleteObjectDefinition
337: p_msg_text => 'Deleted '||SQL%ROWCOUNT
338: ||' rows from FEM_ALLOC_PREVIEW_STATS');
339: END IF;
340:
341: DELETE FROM fem_alloc_preview_maps
342: WHERE preview_obj_def_id = p_preview_obj_def_id;
343:
344: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
345: FEM_ENGINES_PKG.TECH_MESSAGE(
345: FEM_ENGINES_PKG.TECH_MESSAGE(
346: p_severity => FND_LOG.level_statement,
347: p_module => C_MODULE,
348: p_msg_text => 'Deleted '||SQL%ROWCOUNT
349: ||' rows from FEM_ALLOC_PREVIEW_MAPS');
350: END IF;
351:
352: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
353: p_count => x_msg_count,
1265: -- CreatePreviewMaps
1266: --
1267: -- DESCRIPTION
1268: -- Inserts the dimension member column and dimension
1269: -- member name column names in FEM_ALLOC_PREVIEW_MAPS.
1270: --
1271: -------------------------------------------------------------------------------
1272: PROCEDURE CreatePreviewMaps(
1273: p_preview_obj_def_id IN NUMBER,
1293: p_msg_text => 'Begin Procedure');
1294: END IF;
1295:
1296: -- Insert the dimension member column and dimension
1297: -- member name column names in FEM_ALLOC_PREVIEW_MAPS.
1298: INSERT INTO fem_alloc_preview_maps(
1299: preview_obj_def_id, preview_row_group, dim_member_column_name,
1300: dim_name_column_name, created_by_request_id, created_by_object_id,
1301: last_updated_by_request_id, last_updated_by_object_id)
1294: END IF;
1295:
1296: -- Insert the dimension member column and dimension
1297: -- member name column names in FEM_ALLOC_PREVIEW_MAPS.
1298: INSERT INTO fem_alloc_preview_maps(
1299: preview_obj_def_id, preview_row_group, dim_member_column_name,
1300: dim_name_column_name, created_by_request_id, created_by_object_id,
1301: last_updated_by_request_id, last_updated_by_object_id)
1302: SELECT p_preview_obj_def_id, p_preview_row_group, tc.column_name,
1354: --
1355: CURSOR c_dim (cv_preview_obj_def_id IN NUMBER,
1356: cv_preview_row_group IN VARCHAR2) IS
1357: SELECT dim_name_column_name
1358: FROM fem_alloc_preview_maps
1359: WHERE preview_obj_def_id = cv_preview_obj_def_id
1360: AND preview_row_group = cv_preview_row_group;
1361: --
1362: BEGIN
1372: -- Start off the SELECT clause.
1373: -- i.e. 'SELECT F.*'
1374: x_select_clause := 'SELECT '||G_FACT_ALIAS||'.*';
1375:
1376: -- Then loop through FEM_ALLOC_PREVIEW_MAPS to get the
1377: -- dimension member name column names to append to the SELECT clause.
1378: -- i.e. ||', D.template_dim_name AS fem1_1234567'
1379: FOR dims IN c_dim(cv_preview_obj_def_id => p_preview_obj_def_id,
1380: cv_preview_row_group => p_preview_row_group) LOOP
2788: cv_global_vs_combo_id NUMBER) IS
2789: SELECT pm.dim_member_column_name, pm.dim_name_column_name,
2790: xd.member_name_col, xd.member_vl_object_name, xd.member_col,
2791: gv.value_set_id
2792: FROM fem_alloc_preview_maps pm, fem_tab_columns_v tc,
2793: fem_xdim_dimensions xd, fem_global_vs_combo_defs gv
2794: WHERE pm.preview_obj_def_id = cv_preview_obj_def_id
2795: AND pm.preview_row_group = cv_preview_row_group
2796: AND pm.dim_member_column_name = tc.column_name