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_MAPPING_PREVIEW_UTIL_PKG

Line 1: PACKAGE BODY FEM_MAPPING_PREVIEW_UTIL_PKG AS

1: PACKAGE BODY FEM_MAPPING_PREVIEW_UTIL_PKG AS
2: /* $Header: fem_mapping_preview_util_pkg.plb 120.5 2008/02/08 22:06:54 gcheng ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PRIVATE CONSTANTS

Line 2: /* $Header: fem_mapping_preview_util_pkg.plb 120.5 2008/02/08 22:06:54 gcheng ship $ */

1: PACKAGE BODY FEM_MAPPING_PREVIEW_UTIL_PKG AS
2: /* $Header: fem_mapping_preview_util_pkg.plb 120.5 2008/02/08 22:06:54 gcheng ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PRIVATE CONSTANTS
6: -------------------------------------------------------------------------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_MAPPING_PREVIEW_UTIL_PKG';

4: -------------------------------------------------------------------------------
5: -- PRIVATE CONSTANTS
6: -------------------------------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_MAPPING_PREVIEW_UTIL_PKG';
9: G_FACT_ALIAS CONSTANT VARCHAR2(1) := 'F';
10: G_DIM_ALIAS CONSTANT VARCHAR2(1) := 'D';
11: G_STAT_ALIAS CONSTANT VARCHAR2(1) := 'S';
12: G_MATCH_ALIAS CONSTANT VARCHAR2(1) := 'M';

Line 211: 'fem.plsql.fem_mapping_preview_util_pkg.remove_results';

207: -------------------------------------------------------------------------------
208: IS
209:
210: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
211: 'fem.plsql.fem_mapping_preview_util_pkg.remove_results';
212: C_API_NAME CONSTANT VARCHAR2(30) := 'Remove_Results';
213: C_API_VERSION CONSTANT NUMBER := 1.0;
214: --
215: e_api_error EXCEPTION;

Line 440: 'fem.plsql.fem_mapping_preview_util_pkg.pre_process';

436: -------------------------------------------------------------------------------
437: IS
438:
439: C_MODULE CONSTANT FND_LOG_MESSAGES.module%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;

Line 758: 'fem.plsql.fem_mapping_preview_util_pkg.post_process';

754: -------------------------------------------------------------------------------
755: IS
756:
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;

Line 965: 'fem.plsql.fem_mapping_preview_util_pkg.CreateTempTable';

961: -------------------------------------------------------------------------------
962: IS
963: --
964: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
965: 'fem.plsql.fem_mapping_preview_util_pkg.CreateTempTable';
966: v_select_clause VARCHAR2(16383);
967: v_from_clause VARCHAR2(4095);
968: v_where_clause VARCHAR2(32767);
969: v_return_status VARCHAR2(1);

Line 1204: 'fem.plsql.fem_mapping_preview_util_pkg.CreatePreviewStats';

1200: -------------------------------------------------------------------------------
1201: IS
1202: --
1203: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1204: 'fem.plsql.fem_mapping_preview_util_pkg.CreatePreviewStats';
1205: v_row_count NUMBER;
1206: v_sql VARCHAR2(32767);
1207: --
1208: BEGIN

Line 1283: 'fem.plsql.fem_mapping_preview_util_pkg.CreatePreviewMaps';

1279: -------------------------------------------------------------------------------
1280: IS
1281: --
1282: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1283: 'fem.plsql.fem_mapping_preview_util_pkg.CreatePreviewMaps';
1284: v_row_count NUMBER;
1285: v_sql VARCHAR2(32767);
1286: --
1287: BEGIN

Line 1353: 'fem.plsql.fem_mapping_preview_util_pkg.GetSelectClause';

1349: -------------------------------------------------------------------------------
1350: IS
1351: --
1352: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1353: 'fem.plsql.fem_mapping_preview_util_pkg.GetSelectClause';
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

Line 1426: 'fem.plsql.fem_mapping_preview_util_pkg.GetMapTableType';

1422: -------------------------------------------------------------------------------
1423: IS
1424: --
1425: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1426: 'fem.plsql.fem_mapping_preview_util_pkg.GetMapTableType';
1427: v_is_ledger VARCHAR2(1);
1428: v_is_acct_trans VARCHAR2(1);
1429: --
1430: -- Returns T if table is a "ledger" table and F otherwise

Line 1545: 'fem.plsql.fem_mapping_preview_util_pkg.GetOutputMatchingTable';

1541: -------------------------------------------------------------------------------
1542: IS
1543: --
1544: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1545: 'fem.plsql.fem_mapping_preview_util_pkg.GetOutputMatchingTable';
1546: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1547: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
1548: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;
1549: v_map_table_type VARCHAR2(30);

Line 1664: 'fem.plsql.fem_mapping_preview_util_pkg.GetFromClause';

1660: -------------------------------------------------------------------------------
1661: IS
1662: --
1663: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1664: 'fem.plsql.fem_mapping_preview_util_pkg.GetFromClause';
1665: --
1666: BEGIN
1667: --
1668: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1733: 'fem.plsql.fem_mapping_preview_util_pkg.GetInputWhereClause';

1729: -------------------------------------------------------------------------------
1730: IS
1731: --
1732: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1733: 'fem.plsql.fem_mapping_preview_util_pkg.GetInputWhereClause';
1734: v_map_table_type VARCHAR2(30);
1735: v_condition_filter VARCHAR2(16000);
1736: v_return_status VARCHAR2(1);
1737: v_msg_count NUMBER;

Line 2018: 'fem.plsql.fem_mapping_preview_util_pkg.GetOutputWhereClause';

2014: -------------------------------------------------------------------------------
2015: IS
2016: --
2017: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2018: 'fem.plsql.fem_mapping_preview_util_pkg.GetOutputWhereClause';
2019: v_map_table_type VARCHAR2(30);
2020: v_output_match_temp_table VARCHAR2(30);
2021: v_output_match_fact_table VARCHAR2(30);
2022: v_output_pk_sql VARCHAR2(8000);

Line 2178: 'fem.plsql.fem_mapping_preview_util_pkg.GetWhereClause';

2174: -------------------------------------------------------------------------------
2175: IS
2176: --
2177: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2178: 'fem.plsql.fem_mapping_preview_util_pkg.GetWhereClause';
2179: v_map_table_type VARCHAR2(30);
2180: --
2181: BEGIN
2182: --

Line 2258: 'fem.plsql.fem_mapping_preview_util_pkg.UpdatePreviewStats';

2254: -------------------------------------------------------------------------------
2255: IS
2256: --
2257: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2258: 'fem.plsql.fem_mapping_preview_util_pkg.UpdatePreviewStats';
2259: v_functional_currency FEM_ALLOC_PREVIEW_STATS.amount_currency_code%TYPE;
2260: v_amount_total FEM_ALLOC_PREVIEW_STATS.preview_amount_total%TYPE;
2261: v_row_count FEM_ALLOC_PREVIEW_STATS.preview_rows%TYPE;
2262: --

Line 2332: 'fem.plsql.fem_mapping_preview_util_pkg.GetPreviewAmount';

2328: -------------------------------------------------------------------------------
2329: IS
2330: --
2331: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2332: 'fem.plsql.fem_mapping_preview_util_pkg.GetPreviewAmount';
2333: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
2334: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
2335: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
2336: v_return_code NUMBER;

Line 2618: 'fem.plsql.fem_mapping_preview_util_pkg.GetPreviewRowCount';

2614: -------------------------------------------------------------------------------
2615: IS
2616: --
2617: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2618: 'fem.plsql.fem_mapping_preview_util_pkg.GetPreviewRowCount';
2619: v_sql VARCHAR2(4000);
2620: --
2621: BEGIN
2622: --

Line 2684: 'fem.plsql.fem_mapping_preview_util_pkg.CleanOutputTable';

2680: -------------------------------------------------------------------------------
2681: IS
2682: --
2683: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2684: 'fem.plsql.fem_mapping_preview_util_pkg.CleanOutputTable';
2685: v_sql VARCHAR2(4000);
2686: v_map_table_type VARCHAR2(30);
2687: --
2688: BEGIN

Line 2776: 'fem.plsql.fem_mapping_preview_util_pkg.PopulateDimensionNames';

2772: -------------------------------------------------------------------------------
2773: IS
2774: --
2775: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2776: 'fem.plsql.fem_mapping_preview_util_pkg.PopulateDimensionNames';
2777: C_TOKEN CONSTANT VARCHAR2(20) := 'FEMDIMNAMETOKEN';
2778: v_return_status VARCHAR2(1);
2779: v_msg_count NUMBER;
2780: v_msg_data VARCHAR2(4000);

Line 2925: 'fem.plsql.fem_mapping_preview_util_pkg.GetByDimParams';

2921: -------------------------------------------------------------------------------
2922: IS
2923: --
2924: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2925: 'fem.plsql.fem_mapping_preview_util_pkg.GetByDimParams';
2926: C_BYDIM_FUNCIONCD CONSTANT VARCHAR2(10) := 'LEAFFUNC';
2927: --
2928: BEGIN
2929: --

Line 2970: END FEM_MAPPING_PREVIEW_UTIL_PKG;

2966: -------------------------------------------------------------------------------
2967:
2968: -------------------------------------------------------------------------------
2969:
2970: END FEM_MAPPING_PREVIEW_UTIL_PKG;