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_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_INTG_DIM_RULE_DEFS

Line 1298: UPDATE fem_intg_dim_rule_defs

1294: --------------------------------------------------------------
1295: -- Update Dimension definition table with max_ccid_processed
1296: --------------------------------------------------------------
1297:
1298: UPDATE fem_intg_dim_rule_defs
1299: SET max_ccid_processed = fem_intg_dim_rule_eng_pkg.pv_max_ccid_to_be_mapped
1300: WHERE dim_rule_obj_def_id = fem_intg_dim_rule_eng_pkg.pv_dim_rule_obj_def_id;
1301: v_rows_processed := v_rows_processed + SQL%ROWCOUNT;
1302:

Line 2165: UPDATE FEM_INTG_DIM_RULE_DEFS

2161: --
2162: -- Update dimension rule definitions for single segment/value rules
2163: --
2164:
2165: UPDATE FEM_INTG_DIM_RULE_DEFS
2166: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
2167: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
2168: FROM fem_intg_dim_rules idr,
2169: fem_object_definition_b fodb,

Line 2171: fem_intg_dim_rule_defs defs,

2167: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
2168: FROM fem_intg_dim_rules idr,
2169: fem_object_definition_b fodb,
2170: fem_xdim_dimensions fxd,
2171: fem_intg_dim_rule_defs defs,
2172: fem_tab_columns_b ftcb
2173: WHERE ftcb.table_name = 'FEM_BALANCES'
2174: AND ftcb.fem_data_type_code = 'DIMENSION'
2175: AND ftcb.dimension_id = fxd.dimension_id

Line 2187: p_module => v_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',

2183: v_row_count_tot := SQL%ROWCOUNT;
2184:
2185: FEM_ENGINES_PKG.Tech_Message(
2186: p_severity => pc_log_level_statement,
2187: p_module => v_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',
2188: p_msg_text => v_row_count_tot
2189: );
2190:
2191: x_row_count_tot := x_row_count_tot + v_row_count_tot;

Line 3767: -- fem_intg_dim_rule_defs.max_flex_value_id_Processed

3763:
3764:
3765: -------------------------------------------------------------------------
3766: -- Store MAX flex value ID from member table into
3767: -- fem_intg_dim_rule_defs.max_flex_value_id_Processed
3768: -------------------------------------------------------------------------
3769: pv_progress := 'Before update of fem_intg_dim_rule_defs.max_flex_value_id_processed';
3770: --piush_util.put_line(pv_progress);
3771:

Line 3769: pv_progress := 'Before update of fem_intg_dim_rule_defs.max_flex_value_id_processed';

3765: -------------------------------------------------------------------------
3766: -- Store MAX flex value ID from member table into
3767: -- fem_intg_dim_rule_defs.max_flex_value_id_Processed
3768: -------------------------------------------------------------------------
3769: pv_progress := 'Before update of fem_intg_dim_rule_defs.max_flex_value_id_processed';
3770: --piush_util.put_line(pv_progress);
3771:
3772: UPDATE fem_intg_dim_rule_defs
3773: SET max_flex_value_id_processed

Line 3772: UPDATE fem_intg_dim_rule_defs

3768: -------------------------------------------------------------------------
3769: pv_progress := 'Before update of fem_intg_dim_rule_defs.max_flex_value_id_processed';
3770: --piush_util.put_line(pv_progress);
3771:
3772: UPDATE fem_intg_dim_rule_defs
3773: SET max_flex_value_id_processed
3774: = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
3775: WHERE dim_rule_obj_def_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id;
3776:

Line 3781: ,p_msg_text => 'Update fem_intg_dim_rule_defs.max_flex_value_id_processed'||

3777: FEM_ENGINES_PKG.Tech_Message
3778: (
3779: p_severity => pc_log_level_procedure
3780: ,p_module => pc_module_name||c_func_name
3781: ,p_msg_text => 'Update fem_intg_dim_rule_defs.max_flex_value_id_processed'||
3782: 'with '||FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped);
3783:
3784: v_rows_processed :=
3785: NVL(v_main_insert_gt_count,0)

Line 4088: UPDATE FEM_INTG_DIM_RULE_DEFS

4084: --
4085: -- Update dimension rule definitions for single segment/value rules
4086: --
4087:
4088: UPDATE FEM_INTG_DIM_RULE_DEFS
4089: SET MAX_CCID_PROCESSED = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
4090: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
4091: FROM fem_intg_dim_rules idr,
4092: fem_object_definition_b fodb,

Line 4094: fem_intg_dim_rule_defs defs,

4090: WHERE DIM_RULE_OBJ_DEF_ID IN ( SELECT defs.dim_rule_obj_def_id
4091: FROM fem_intg_dim_rules idr,
4092: fem_object_definition_b fodb,
4093: fem_xdim_dimensions fxd,
4094: fem_intg_dim_rule_defs defs,
4095: fem_tab_columns_b ftcb
4096: WHERE ftcb.table_name = 'FEM_BALANCES'
4097: AND ftcb.fem_data_type_code = 'DIMENSION'
4098: AND ftcb.dimension_id = fxd.dimension_id

Line 4112: p_module => pc_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',

4108: COMMIT;
4109:
4110: FEM_ENGINES_PKG.Tech_Message(
4111: p_severity => pc_log_level_statement,
4112: p_module => pc_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',
4113: p_msg_text => v_rows_processed
4114: );
4115:
4116: x_row_count_tot := x_row_count_tot + v_rows_processed;

Line 4629: fem_intg_dim_rule_defs defs,

4625: defs.dim_mapping_option_code
4626: FROM fem_intg_dim_rules idr,
4627: fem_object_definition_b fodb,
4628: fem_xdim_dimensions fxd,
4629: fem_intg_dim_rule_defs defs,
4630: fem_tab_columns_b ftcb
4631: WHERE ftcb.table_name = 'FEM_BALANCES'
4632: AND ftcb.fem_data_type_code = 'DIMENSION'
4633: AND ftcb.dimension_id = fxd.dimension_id