DBA Data[Home] [Help]

APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FND_LOG_MESSAGES

Line 210: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

206: p_preview_obj_def_id IN NUMBER)
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: --

Line 439: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

435: p_request_id IN NUMBER)
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: --

Line 757: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

753: p_request_id IN NUMBER)
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;

Line 964: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

960: )
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);

Line 1203: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1199: )
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: --

Line 1282: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1278: )
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: --

Line 1352: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1348: )
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

Line 1425: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1421: )
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: --

Line 1544: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1540: )
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;

Line 1663: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1659: )
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: --

Line 1732: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1728: )
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);

Line 2017: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2013: )
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);

Line 2177: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2173: )
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

Line 2257: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2253: )
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;

Line 2331: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2327: )
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;

Line 2617: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2613: )
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

Line 2683: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2679: )
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: --

Line 2775: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2771: )
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;

Line 2924: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2920: )
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