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_BR_MAPPING_RULE_PVT dependencies on FEM_ALLOC_BR_DIMENSIONS

Line 688: -- in the FEM_ALLOC_BR_DIMENSIONS table.

684: -- DeleteDimensionRecs
685: --
686: -- DESCRIPTION
687: -- Delete Mapping Rule Definition Dimensions by performing deletes on records
688: -- in the FEM_ALLOC_BR_DIMENSIONS table.
689: --
690: -- IN
691: -- p_obj_def_id - Object Definition ID.
692: --

Line 701: delete from fem_alloc_br_dimensions

697: --------------------------------------------------------------------------------
698: IS
699: BEGIN
700:
701: delete from fem_alloc_br_dimensions
702: where object_definition_id = p_obj_def_id;
703:
704: END DeleteDimensionRecs;
705:

Line 1110: -- FEM_ALLOC_BR_DIMENSIONS table.

1106: -- CopyDimensionRecs
1107: --
1108: -- DESCRIPTION
1109: -- Creates new Mapping Rule Definition Dimensions by copying records in the
1110: -- FEM_ALLOC_BR_DIMENSIONS table.
1111: --
1112: -- IN
1113: -- p_source_obj_def_id - Source Object Definition ID.
1114: -- p_target_obj_def_id - Target Object Definition ID.

Line 1129: insert into fem_alloc_br_dimensions (

1125: --------------------------------------------------------------------------------
1126: IS
1127: BEGIN
1128:
1129: insert into fem_alloc_br_dimensions (
1130: object_definition_id
1131: ,function_seq
1132: ,alloc_dim_col_name
1133: ,post_to_balances_flag

Line 1165: from fem_alloc_br_dimensions

1161: ,FND_GLOBAL.user_id
1162: ,sysdate
1163: ,FND_GLOBAL.login_id
1164: ,object_version_number
1165: from fem_alloc_br_dimensions
1166: where object_definition_id = p_source_obj_def_id;
1167:
1168: END CopyDimensionRecs;
1169:

Line 1183: -- delete all corresponding rows in the FEM_ALLOC_BR_DIMENSIONS

1179: -- if the table is enabled
1180: -- call synchronize_dim_rows
1181: -- else if FEM_BALANCES is enabled
1182: -- update the formula row with FEM_BALANCES
1183: -- delete all corresponding rows in the FEM_ALLOC_BR_DIMENSIONS
1184: -- populate default rows in the FEM_ALLOC_BR_DIMENSIONS for FEM_BALANCES
1185: -- else if FEM_BALANCES is disabled
1186: -- error out
1187: --

Line 1184: -- populate default rows in the FEM_ALLOC_BR_DIMENSIONS for FEM_BALANCES

1180: -- call synchronize_dim_rows
1181: -- else if FEM_BALANCES is enabled
1182: -- update the formula row with FEM_BALANCES
1183: -- delete all corresponding rows in the FEM_ALLOC_BR_DIMENSIONS
1184: -- populate default rows in the FEM_ALLOC_BR_DIMENSIONS for FEM_BALANCES
1185: -- else if FEM_BALANCES is disabled
1186: -- error out
1187: --
1188: -- IN

Line 1436: delete from fem_alloc_br_dimensions

1432: p_obj_def_id in number
1433: ,p_func_seq in number)
1434: IS
1435: BEGIN
1436: delete from fem_alloc_br_dimensions
1437: where object_definition_id = p_obj_def_id
1438: and function_seq = p_func_seq;
1439:
1440: END;

Line 1472: insert into fem_alloc_br_dimensions (

1468:
1469: -- Note that p_function_cd can't be LEAFFUNC
1470: for l_dimension_candidate in c_dimension_candidates
1471: loop
1472: insert into fem_alloc_br_dimensions (
1473: object_definition_id
1474: ,function_seq
1475: ,alloc_dim_col_name
1476: ,post_to_balances_flag

Line 1522: from fem_alloc_br_dimensions

1518: IS
1519: CURSOR c_orphan_dimensions
1520: IS
1521: select alloc_dim_col_name, alloc_dim_usage_code
1522: from fem_alloc_br_dimensions
1523: where object_definition_id = p_obj_def_id
1524: and function_seq = p_func_seq
1525: and alloc_dim_col_name not in
1526: (select column_name

Line 1540: from fem_alloc_br_dimensions

1536: from fem_tab_column_prop
1537: where column_property_code = p_column_property_code
1538: and table_name = p_table_name
1539: and column_name not in (select alloc_dim_col_name
1540: from fem_alloc_br_dimensions
1541: where object_definition_id = p_obj_def_id
1542: and function_seq = p_func_seq);
1543:
1544: l_missing_dimensions_rec c_missing_dimensions%ROWTYPE;

Line 1551: delete from fem_alloc_br_dimensions

1547: BEGIN
1548: if p_function_cd not in ('LEAFFUNC', 'TABLE_ACCESS') then
1549: for l_orphan_dimensions_rec in c_orphan_dimensions
1550: loop
1551: delete from fem_alloc_br_dimensions
1552: where object_definition_id = p_obj_def_id
1553: and function_seq = p_func_seq
1554: and alloc_dim_col_name = l_orphan_dimensions_rec.alloc_dim_col_name;
1555:

Line 1559: update fem_alloc_br_dimensions

1555:
1556: if l_orphan_dimensions_rec.alloc_dim_usage_code = 'SAME_AS_PCT'
1557: and p_function_cd in ('CREDIT', 'DEBIT') then
1558: begin
1559: update fem_alloc_br_dimensions
1560: set percent_distribution_code = 'NOT_APPLICABLE'
1561: where object_definition_id = p_obj_def_id
1562: and alloc_dim_col_name = l_orphan_dimensions_rec.alloc_dim_col_name
1563: and function_cd = 'PCT_DISTRB'

Line 1574: insert into fem_alloc_br_dimensions (

1570: end loop;
1571:
1572: for l_missing_dimensions_rec in c_missing_dimensions
1573: loop
1574: insert into fem_alloc_br_dimensions (
1575: object_definition_id
1576: ,function_seq
1577: ,alloc_dim_col_name
1578: ,post_to_balances_flag

Line 1616: FEM_ALLOC_BR_FORMULA and FEM_ALLOC_BR_DIMENSIONS.

1612:
1613: delete_map_rule_content
1614: This procedure deletes the data from the 3 tables that store
1615: the mapping rule content viz. FEM_ALLOC_BUSINESS_RULE,
1616: FEM_ALLOC_BR_FORMULA and FEM_ALLOC_BR_DIMENSIONS.
1617:
1618: *************************************************************************/
1619:
1620: PROCEDURE delete_map_rule_content(p_object_definition_id IN NUMBER)