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.FEM_FUNC_DIM_PVT dependencies on FEM_FUNC_DIM_SET_MAPS

Line 151: from FEM_FUNC_DIM_SETS_VL,FEM_FUNC_DIM_SET_MAPS

147:
148: BEGIN
149:
150: Select DIMENSION_ID,FUNC_DIM_SET_NAME into l_func_dim_rec
151: from FEM_FUNC_DIM_SETS_VL,FEM_FUNC_DIM_SET_MAPS
152: where FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_ID = FEM_FUNC_DIM_SET_MAPS.FUNC_DIM_SET_ID
153: and FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_OBJ_DEF_ID = p_version_id
154: and FEM_FUNC_DIM_SET_MAPS.TABLE_NAME = p_table_name
155: and FEM_FUNC_DIM_SET_MAPS.COLUMN_NAME = p_column_name;

Line 152: where FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_ID = FEM_FUNC_DIM_SET_MAPS.FUNC_DIM_SET_ID

148: BEGIN
149:
150: Select DIMENSION_ID,FUNC_DIM_SET_NAME into l_func_dim_rec
151: from FEM_FUNC_DIM_SETS_VL,FEM_FUNC_DIM_SET_MAPS
152: where FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_ID = FEM_FUNC_DIM_SET_MAPS.FUNC_DIM_SET_ID
153: and FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_OBJ_DEF_ID = p_version_id
154: and FEM_FUNC_DIM_SET_MAPS.TABLE_NAME = p_table_name
155: and FEM_FUNC_DIM_SET_MAPS.COLUMN_NAME = p_column_name;
156:

Line 154: and FEM_FUNC_DIM_SET_MAPS.TABLE_NAME = p_table_name

150: Select DIMENSION_ID,FUNC_DIM_SET_NAME into l_func_dim_rec
151: from FEM_FUNC_DIM_SETS_VL,FEM_FUNC_DIM_SET_MAPS
152: where FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_ID = FEM_FUNC_DIM_SET_MAPS.FUNC_DIM_SET_ID
153: and FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_OBJ_DEF_ID = p_version_id
154: and FEM_FUNC_DIM_SET_MAPS.TABLE_NAME = p_table_name
155: and FEM_FUNC_DIM_SET_MAPS.COLUMN_NAME = p_column_name;
156:
157: x_dimension_id := l_func_dim_rec.dimension_id ;
158: x_func_dim_set_name := l_func_dim_rec.func_dim_set_name ;

Line 155: and FEM_FUNC_DIM_SET_MAPS.COLUMN_NAME = p_column_name;

151: from FEM_FUNC_DIM_SETS_VL,FEM_FUNC_DIM_SET_MAPS
152: where FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_ID = FEM_FUNC_DIM_SET_MAPS.FUNC_DIM_SET_ID
153: and FEM_FUNC_DIM_SETS_VL.FUNC_DIM_SET_OBJ_DEF_ID = p_version_id
154: and FEM_FUNC_DIM_SET_MAPS.TABLE_NAME = p_table_name
155: and FEM_FUNC_DIM_SET_MAPS.COLUMN_NAME = p_column_name;
156:
157: x_dimension_id := l_func_dim_rec.dimension_id ;
158: x_func_dim_set_name := l_func_dim_rec.func_dim_set_name ;
159:

Line 207: FEM_FUNC_DIM_SET_MAPS

203: g_api_name CONSTANT VARCHAR2(30) := 'UpdateColumnDisplayNames';
204:
205: CURSOR cur_fetch_table_column_combo (cur_set_id NUMBER) IS
206: Select TABLE_NAME,COLUMN_NAME from
207: FEM_FUNC_DIM_SET_MAPS
208: where FUNC_DIM_SET_ID = cur_set_id;
209:
210: BEGIN
211: SAVEPOINT Update_Column_Display_Pvt ;

Line 309: -- FEM_FUNC_DIM_SETS_VL and FEM_FUNC_DIM_SET_MAPS table.

305: -- CopyFuncDimRec
306: --
307: -- DESCRIPTION
308: -- Creates a new Functional Dimension Definition by copying records in the
309: -- FEM_FUNC_DIM_SETS_VL and FEM_FUNC_DIM_SET_MAPS table.
310: --
311: -- IN
312: -- p_source_obj_def_id - Source Object Definition ID.
313: -- p_target_obj_def_id - Target Object Definition ID.

Line 343: FEM_FUNC_DIM_SET_MAPS

339: FUNC_DIM_SET_OBJ_DEF_ID = p_source_obj_def_id;
340:
341: CURSOR cur_func_dim_set_map_id (p_old_func_dim_set_id NUMBER) IS
342: Select FUNC_DIM_SET_MAP_ID from
343: FEM_FUNC_DIM_SET_MAPS
344: where FUNC_DIM_SET_ID = p_old_func_dim_set_id;
345:
346: BEGIN
347: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 389: INSERT INTO FEM_FUNC_DIM_SET_MAPS(

385: LOOP
386: FETCH cur_func_dim_set_map_id INTO l_old_func_dim_set_map_id;
387: EXIT WHEN cur_func_dim_set_map_id%NOTFOUND;
388: select FEM_FUNC_DIM_SET_MAP_S.NEXTVAL into l_new_func_dim_set_map_id from dual;
389: INSERT INTO FEM_FUNC_DIM_SET_MAPS(
390: FUNC_DIM_SET_MAP_ID
391: ,FUNC_DIM_SET_ID
392: ,TABLE_NAME
393: ,COLUMN_NAME

Line 409: FROM FEM_FUNC_DIM_SET_MAPS

405: ,NVL(p_creation_date,creation_date)
406: ,FND_GLOBAL.USER_ID
407: ,SYSDATE
408: ,FND_GLOBAL.LOGIN_ID
409: FROM FEM_FUNC_DIM_SET_MAPS
410: WHERE FUNC_DIM_SET_ID = l_old_func_dim_set_id
411: AND FUNC_DIM_SET_MAP_ID = l_old_func_dim_set_map_id ;
412: END LOOP; -- Ending inner loop
413: CLOSE cur_func_dim_set_map_id ;

Line 427: -- in the FEM_FUNC_DIM_SET_MAPS and FEM_FUNC_DIM_SETS_VL table.

423: -- DeleteFuncDimRec
424: --
425: -- DESCRIPTION
426: -- Deletes records related to a Functional Dimension Definition by performing deletes on records
427: -- in the FEM_FUNC_DIM_SET_MAPS and FEM_FUNC_DIM_SETS_VL table.
428: --
429: -- IN
430: -- p_obj_def_id - Object Definition ID.
431: --

Line 451: DELETE FROM FEM_FUNC_DIM_SET_MAPS

447: LOOP
448: FETCH cur_func_dim_set_id INTO l_func_dim_set_id;
449: EXIT WHEN cur_func_dim_set_id%NOTFOUND ;
450:
451: DELETE FROM FEM_FUNC_DIM_SET_MAPS
452: WHERE FUNC_DIM_SET_ID = l_func_dim_set_id ;
453:
454: END LOOP;
455: CLOSE cur_func_dim_set_id;