APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_COMPANIES_TL

Line 1961: p_member_tl_table_name => 'FEM_COMPANIES_TL',

1957: Populate_Single_Segment(
1958: p_dim_id => FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id,
1959: p_vs_id => FEM_INTG_DIM_RULE_ENG_PKG.pv_com_vs_id,
1960: p_member_b_table_name => 'FEM_COMPANIES_B',
1961: p_member_tl_table_name => 'FEM_COMPANIES_TL',
1962: p_member_col => 'COMPANY_ID',
1963: p_member_display_code_col => 'COMPANY_DISPLAY_CODE',
1964: p_member_name_col => 'COMPANY_NAME',
1965: x_row_count_tot => v_row_count_tot

Line 3317: pv_progress := 'Before insert into fem_companies_tl';

3313: ,p_value1 => 'FEM_COMPANIES_B'
3314: ,p_token2 => 'NUM'
3315: ,p_value2 => v_comp_member_b_count);
3316:
3317: pv_progress := 'Before insert into fem_companies_tl';
3318: --piush_util.put_line(pv_progress);
3319:
3320: INSERT INTO fem_companies_tl
3321: (

Line 3320: INSERT INTO fem_companies_tl

3316:
3317: pv_progress := 'Before insert into fem_companies_tl';
3318: --piush_util.put_line(pv_progress);
3319:
3320: INSERT INTO fem_companies_tl
3321: (
3322: company_id,
3323: value_set_id,
3324: language,

Line 3350: FROM fem_companies_tl tab2

3346: ,fnd_flex_values_tl TL
3347: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_com_vs_id
3348: AND tab1.company_id = TL.flex_value_id
3349: AND not exists ( SELECT 'x'
3350: FROM fem_companies_tl tab2
3351: WHERE tab1.value_set_id = tab2.value_set_id
3352: AND tab1.company_id = tab2.company_id
3353: AND TL.language = tab2.language );
3354:

Line 3363: ,p_value1 => 'FEM_COMPANIES_TL'

3359: ,p_module => pc_module_name||c_func_name
3360: ,p_app_name => 'FEM'
3361: ,p_msg_name => 'FEM_GL_POST_216'
3362: ,p_token1 => 'TABLE'
3363: ,p_value1 => 'FEM_COMPANIES_TL'
3364: ,p_token2 => 'NUM'
3365: ,p_value2 => v_comp_member_tl_count);
3366:
3367: ELSE /* table validated value set */