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_ALLOC_PREVIEWS

Line 280: FROM fem_alloc_previews

276: -- See if Preview has run yet
277: BEGIN
278: SELECT request_id
279: INTO v_request_id
280: FROM fem_alloc_previews
281: WHERE preview_obj_def_id = p_preview_obj_def_id;
282: EXCEPTION
283: WHEN no_data_found THEN
284: v_request_id := -1;

Line 764: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;

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: --
768: -- Gets information related to each preview row group needed to

Line 765: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id%TYPE;

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: --
768: -- Gets information related to each preview row group needed to
769: -- update the Preview Stats and populate the dimension names.

Line 842: FROM fem_alloc_previews

838:
839: -- Get preview parameter values
840: SELECT ledger_id, cal_period_id
841: INTO v_ledger_id, v_cal_period_id
842: FROM fem_alloc_previews
843: WHERE preview_obj_def_id = p_preview_obj_def_id;
844:
845: FOR row_group IN c_row_group_info(p_preview_obj_def_id) LOOP
846:

Line 1740: v_ledger_id FEM_ALLOC_PREVIEWS.ledger_id%TYPE;

1736: v_return_status VARCHAR2(1);
1737: v_msg_count NUMBER;
1738: v_msg_data VARCHAR2(4000);
1739: v_effective_date VARCHAR2(30);
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;

Line 1741: v_cal_period_id FEM_ALLOC_PREVIEWS.cal_period_id %TYPE;

1737: v_msg_count NUMBER;
1738: v_msg_data VARCHAR2(4000);
1739: v_effective_date VARCHAR2(30);
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;

Line 1742: v_dsg_obj_def_id FEM_ALLOC_PREVIEWS.dsg_obj_def_id%TYPE;

1738: v_msg_data VARCHAR2(4000);
1739: v_effective_date VARCHAR2(30);
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;

Line 1743: v_query_row_limit FEM_ALLOC_PREVIEWS.query_row_limit%TYPE;

1739: v_effective_date VARCHAR2(30);
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;

Line 1746: v_preview_cond_obj_id FEM_ALLOC_PREVIEWS.source_condition_obj_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;
1749: v_by_dimension_value VARCHAR2(38); -- max size of number
1750: --

Line 1773: FROM fem_alloc_previews

1769: decode(p_preview_row_group, G_SOURCE, source_condition_obj_id,
1770: driver_condition_obj_id)
1771: INTO v_effective_date, v_ledger_id, v_cal_period_id, v_dsg_obj_def_id,
1772: v_query_row_limit, v_preview_cond_obj_id
1773: FROM fem_alloc_previews
1774: WHERE preview_obj_def_id = p_preview_obj_def_id;
1775:
1776: -- The general structure of the WHERE clause is:
1777: -- WHERE