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_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 217: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;

213: C_API_VERSION CONSTANT NUMBER := 1.0;
214: --
215: e_api_error EXCEPTION;
216: v_request_id NUMBER;
217: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
218: --
219: -- Gets all object executions for a given preview rule.
220: -- In some cases, only fem_pl_requests gets registered and so
221: -- in that case, cannot rely on fem_pl_object_executions - hence the UNION.

Line 444: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;

440: 'fem.plsql.fem_mapping_preview_util_pkg.pre_process';
441: C_API_NAME CONSTANT VARCHAR2(30) := 'Pre_Process';
442: C_API_VERSION CONSTANT NUMBER := 1.0;
443: --
444: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
445: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;

Line 445: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

441: C_API_NAME CONSTANT VARCHAR2(30) := 'Pre_Process';
442: C_API_VERSION CONSTANT NUMBER := 1.0;
443: --
444: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
445: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
449: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;

Line 446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;

442: C_API_VERSION CONSTANT NUMBER := 1.0;
443: --
444: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
445: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
449: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;
450: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;

Line 447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

443: --
444: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
445: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
449: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;
450: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
451: v_temp_table_seq NUMBER;

Line 603: FROM fem_object_definition_b

599:
600: -- First get Stat Lookup obj def id
601: SELECT object_definition_id
602: INTO v_stat_obj_def_id
603: FROM fem_object_definition_b
604: WHERE object_id = row_group.sub_object_id;
605:
606: SELECT stat_lookup_table
607: INTO v_fact_table_name

Line 761: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

757: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
758: 'fem.plsql.fem_mapping_preview_util_pkg.post_process';
759: C_API_NAME CONSTANT VARCHAR2(30) := 'Post_Process';
760: C_API_VERSION CONSTANT NUMBER := 1.0;
761: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
762: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
763: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
764: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;
765: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id%TYPE;

Line 762: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;

758: 'fem.plsql.fem_mapping_preview_util_pkg.post_process';
759: C_API_NAME CONSTANT VARCHAR2(30) := 'Post_Process';
760: C_API_VERSION CONSTANT NUMBER := 1.0;
761: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
762: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
763: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
764: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;
765: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id%TYPE;
766: v_map_table_type VARCHAR2(30);

Line 763: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;

759: C_API_NAME CONSTANT VARCHAR2(30) := 'Post_Process';
760: C_API_VERSION CONSTANT NUMBER := 1.0;
761: v_map_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
762: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
763: v_preview_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
764: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;
765: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id%TYPE;
766: v_map_table_type VARCHAR2(30);
767: --

Line 1744: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

1740: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;
1741: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id %TYPE;
1742: v_dsg_obj_def_id FEM_ALLOC_PREVIEWS.dsg_obj_def_id%TYPE;
1743: v_query_row_limit FEM_ALLOC_PREVIEWS.query_row_limit%TYPE;
1744: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
1745: v_stat_cond_obj_def_id FEM_STAT_LOOKUPS.condition_obj_def_id%TYPE;
1746: v_preview_cond_obj_id FEM_ALLOC_PREVIEWS.source_condition_obj_id%TYPE;
1747: v_by_dimension_column FEM_ALLOC_BR_DIMENSIONS.alloc_dim_col_name%TYPE;
1748: v_by_dimension_id FEM_DIMENSIONS_B.dimension_id%TYPE;

Line 1846: FROM fem_object_definition_b

1842:
1843: -- First get Stat Lookup obj def id
1844: SELECT object_definition_id
1845: INTO v_stat_obj_def_id
1846: FROM fem_object_definition_b
1847: WHERE object_id = p_sub_obj_id;
1848:
1849: -- Then build the WHERE clause for the stat columns that is bound to
1850: -- defined values as part of the stat definition.