APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_COST_CENTERS_TL

Line 1975: p_member_tl_table_name => 'FEM_COST_CENTERS_TL',

1971: Populate_Single_Segment(
1972: p_dim_id => FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id,
1973: p_vs_id => FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_vs_id,
1974: p_member_b_table_name => 'FEM_COST_CENTERS_B',
1975: p_member_tl_table_name => 'FEM_COST_CENTERS_TL',
1976: p_member_col => 'COST_CENTER_ID',
1977: p_member_display_code_col => 'COST_CENTER_DISPLAY_CODE',
1978: p_member_name_col => 'COST_CENTER_NAME',
1979: x_row_count_tot => v_row_count_tot

Line 3597: pv_progress := 'Before insert into fem_cost_centers_tl';

3593: ,p_value1 => 'FEM_COST_CENTERS_B'
3594: ,p_token2 => 'NUM'
3595: ,p_value2 => v_cc_member_b_count);
3596:
3597: pv_progress := 'Before insert into fem_cost_centers_tl';
3598: --piush_util.put_line(pv_progress);
3599: INSERT INTO fem_cost_centers_tl
3600: (
3601: cost_center_id,

Line 3599: INSERT INTO fem_cost_centers_tl

3595: ,p_value2 => v_cc_member_b_count);
3596:
3597: pv_progress := 'Before insert into fem_cost_centers_tl';
3598: --piush_util.put_line(pv_progress);
3599: INSERT INTO fem_cost_centers_tl
3600: (
3601: cost_center_id,
3602: value_set_id,
3603: language,

Line 3629: FROM fem_cost_centers_tl tab2

3625: ,fnd_flex_values_tl TL
3626: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3627: AND tab1.cost_center_id = TL.flex_value_id
3628: AND not exists ( SELECT 'x'
3629: FROM fem_cost_centers_tl tab2
3630: WHERE tab1.value_set_id = tab2.value_set_id
3631: AND tab1.cost_center_id = tab2.cost_center_id
3632: AND TL.language = tab2.language );
3633:

Line 3641: ,p_value1 => 'FEM_COST_CENTERS_TL'

3637: ,p_module => pc_module_name||c_func_name
3638: ,p_app_name => 'FEM'
3639: ,p_msg_name => 'FEM_GL_POST_216'
3640: ,p_token1 => 'TABLE'
3641: ,p_value1 => 'FEM_COST_CENTERS_TL'
3642: ,p_token2 => 'NUM'
3643: ,p_value2 => v_cc_member_tl_count);
3644:
3645: ELSE /* CC is of table validated case */