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_PREVIEW_STATS

Line 14: G_SOURCE CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

10: G_DIM_ALIAS CONSTANT VARCHAR2(1) := 'D';
11: G_STAT_ALIAS CONSTANT VARCHAR2(1) := 'S';
12: G_MATCH_ALIAS CONSTANT VARCHAR2(1) := 'M';
13: G_DIM_TEMPLATE_TABLE CONSTANT VARCHAR2(30) := 'FEM_DIM_TEMPLATE';
14: G_SOURCE CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
15: := 'SOURCE';
16: G_DRIVER CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
17: := 'DRIVER';
18: G_DEBIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

Line 16: G_DRIVER CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

12: G_MATCH_ALIAS CONSTANT VARCHAR2(1) := 'M';
13: G_DIM_TEMPLATE_TABLE CONSTANT VARCHAR2(30) := 'FEM_DIM_TEMPLATE';
14: G_SOURCE CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
15: := 'SOURCE';
16: G_DRIVER CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
17: := 'DRIVER';
18: G_DEBIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
19: := 'DEBIT';
20: G_CREDIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

Line 18: G_DEBIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

14: G_SOURCE CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
15: := 'SOURCE';
16: G_DRIVER CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
17: := 'DRIVER';
18: G_DEBIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
19: := 'DEBIT';
20: G_CREDIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
21: := 'CREDIT';
22: G_ACCT_TRANS_TYPE CONSTANT VARCHAR2(30) := 'ACCOUNT_TRANS';

Line 20: G_CREDIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE

16: G_DRIVER CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
17: := 'DRIVER';
18: G_DEBIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
19: := 'DEBIT';
20: G_CREDIT CONSTANT FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE
21: := 'CREDIT';
22: G_ACCT_TRANS_TYPE CONSTANT VARCHAR2(30) := 'ACCOUNT_TRANS';
23: G_LEDGER_TYPE CONSTANT VARCHAR2(30) := 'LEDGER';
24: G_OTHER_TABLE_TYPE CONSTANT VARCHAR2(30) := 'OTHER_TABLE_TYPE';

Line 186: -- It deletes data from the FEM_ALLOC_PREVIEW_STATS and

182: -- Remove_Results
183: --
184: -- DESCRIPTION
185: -- This procedure removes the results generated by a Preview execution.
186: -- It deletes data from the FEM_ALLOC_PREVIEW_STATS and
187: -- FEM_ALLOC_PREVIEW_MAPS tables. It also calls
188: -- FEM_UD_PKG.Remove_Process_Locks to remove the Process Lock
189: -- registration data, and along with it the Preview temporary tables.
190: --

Line 330: DELETE FROM fem_alloc_preview_stats

326:
327: -- Now delete all data created by the preview execution in the
328: -- persistent preview output tables
329:
330: DELETE FROM fem_alloc_preview_stats
331: WHERE preview_obj_def_id = p_preview_obj_def_id;
332:
333: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
334: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 338: ||' rows from FEM_ALLOC_PREVIEW_STATS');

334: FEM_ENGINES_PKG.TECH_MESSAGE(
335: p_severity => FND_LOG.level_statement,
336: p_module => C_MODULE,
337: p_msg_text => 'Deleted '||SQL%ROWCOUNT
338: ||' rows from FEM_ALLOC_PREVIEW_STATS');
339: END IF;
340:
341: DELETE FROM fem_alloc_preview_maps
342: WHERE preview_obj_def_id = p_preview_obj_def_id;

Line 419: -- and store those table names in the FEM_ALLOC_PREVIEW_STATS table.

415: -- This procedure is responsible for the pre-processing steps
416: -- to prepare for CCE to run in preview mode.
417: -- For each "preview row group", e.g. SOURCE, DRIVER, CREDIT, DEBIT,
418: -- create a temporary table that mirrors the corresponding fact table
419: -- and store those table names in the FEM_ALLOC_PREVIEW_STATS table.
420: --
421: -- IN
422: -- p_obj_def_id - Preview rule ID
423: -- p_request_id - Preview execution concurrent request ID

Line 448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;

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;
452: v_map_where_clause VARCHAR2(16000);

Line 449: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%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;
452: v_map_where_clause VARCHAR2(16000);
453: v_create_temp_table BOOLEAN;

Line 454: v_debit_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;

450: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
451: v_temp_table_seq NUMBER;
452: v_map_where_clause VARCHAR2(16000);
453: v_create_temp_table BOOLEAN;
454: v_debit_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
455: --
456: -- Gets information related to each preview row group needed to
457: -- create the temporary tables.
458: -- p_obj_def_id is the rule version of the parent mapping rule.

Line 567: -- and insert the temporary table information in FEM_ALLOC_PREVIEW_STATS.

563: -- Counter for number of temp objects being created
564: v_temp_table_seq := 0;
565:
566: -- For each preview group, create the temporary table
567: -- and insert the temporary table information in FEM_ALLOC_PREVIEW_STATS.
568: FOR row_group IN c_row_group_info(cv_obj_def_id => v_map_obj_def_id) LOOP
569:
570: -- If the Mapping Rule Type is By Dimension and
571: -- Preview Row Group is DRIVER, do nothing. By Dimension rule

Line 772: FROM fem_alloc_preview_stats

768: -- Gets information related to each preview row group needed to
769: -- update the Preview Stats and populate the dimension names.
770: CURSOR c_row_group_info (cv_preview_obj_def_id NUMBER) IS
771: SELECT fact_table_name, temp_table_name, preview_row_group
772: FROM fem_alloc_preview_stats
773: WHERE preview_obj_def_id = cv_preview_obj_def_id
774: ORDER BY preview_row_group_display_seq;
775: --
776: BEGIN

Line 1185: -- Inserts a row into FEM_ALLOC_PREVIEW_STATS with the temp table

1181: -- PROCEDURE
1182: -- CreatePreviewStats
1183: --
1184: -- DESCRIPTION
1185: -- Inserts a row into FEM_ALLOC_PREVIEW_STATS with the temp table
1186: -- information. In Post_Process, the stats rows will be updated with
1187: -- the preview statistics.
1188: --
1189: -------------------------------------------------------------------------------

Line 1241: -- Insert the temp table information into FEM_ALLOC_PREVIEW_STATS

1237: EXECUTE IMMEDIATE v_sql INTO v_row_count;
1238:
1239: END IF;
1240:
1241: -- Insert the temp table information into FEM_ALLOC_PREVIEW_STATS
1242: INSERT INTO fem_alloc_preview_stats (
1243: preview_obj_def_id, preview_row_group, preview_row_group_display_seq,
1244: fact_table_name, temp_table_name, estimated_rows, created_by_request_id,
1245: created_by_object_id, last_updated_by_request_id, last_updated_by_object_id)

Line 1242: INSERT INTO fem_alloc_preview_stats (

1238:
1239: END IF;
1240:
1241: -- Insert the temp table information into FEM_ALLOC_PREVIEW_STATS
1242: INSERT INTO fem_alloc_preview_stats (
1243: preview_obj_def_id, preview_row_group, preview_row_group_display_seq,
1244: fact_table_name, temp_table_name, estimated_rows, created_by_request_id,
1245: created_by_object_id, last_updated_by_request_id, last_updated_by_object_id)
1246: VALUES (

Line 1547: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;

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);
1550: v_temp_table_group FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE;
1551: --

Line 1548: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;

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);
1550: v_temp_table_group FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE;
1551: --
1552: -- Retrieves the temporary and fact table names

Line 1550: v_temp_table_group FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE;

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);
1550: v_temp_table_group FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE;
1551: --
1552: -- Retrieves the temporary and fact table names
1553: -- given the Preview Row Group and Preview rule version
1554: CURSOR c_preview_tables (cv_preview_obj_def_id IN NUMBER,

Line 1557: FROM fem_alloc_preview_stats s

1553: -- given the Preview Row Group and Preview rule version
1554: CURSOR c_preview_tables (cv_preview_obj_def_id IN NUMBER,
1555: cv_preview_row_group IN VARCHAR2) IS
1556: SELECT s.temp_table_name, s.fact_table_name
1557: FROM fem_alloc_preview_stats s
1558: WHERE s.preview_obj_def_id = cv_preview_obj_def_id
1559: AND s.preview_row_group = cv_preview_row_group;
1560: --
1561: BEGIN

Line 2238: -- Populate the following columns in FEM_ALLOC_PREVIEW_STATS:

2234: -- PROCEDURE
2235: -- UpdatePreviewStats
2236: --
2237: -- DESCRIPTION
2238: -- Populate the following columns in FEM_ALLOC_PREVIEW_STATS:
2239: -- 1. PREVIEW_AMOUNT_TOTAL: Sum of the source, driver, debit and credit
2240: -- amounts that CCE used or generated during the Preview run.
2241: -- 2. PREVIEW_ROWS: Number of rows for the source and driver data that
2242: -- CCE used during the Preview run.

Line 2259: v_functional_currency FEM_ALLOC_PREVIEW_STATS.amount_currency_code%TYPE;

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: --
2263: BEGIN

Line 2260: v_amount_total FEM_ALLOC_PREVIEW_STATS.preview_amount_total%TYPE;

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: --
2263: BEGIN
2264: --

Line 2261: v_row_count FEM_ALLOC_PREVIEW_STATS.preview_rows%TYPE;

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: --
2263: BEGIN
2264: --
2265: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2287: UPDATE fem_alloc_preview_stats

2283: GetPreviewRowCount(
2284: p_temp_table_name => p_temp_table_name,
2285: x_preview_row_count => v_row_count);
2286:
2287: UPDATE fem_alloc_preview_stats
2288: SET preview_amount_total = v_amount_total,
2289: amount_currency_code = v_functional_currency,
2290: preview_rows = v_row_count
2291: WHERE preview_obj_def_id = p_preview_obj_def_id