APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_COMPANIES_B

Line 387: FEM_COMPANIES_B COMPANY,';

383: /*
384: Join to Company member table to access member id
385: */
386: v_flex_value_from1 := '
387: FEM_COMPANIES_B COMPANY,';
388:
389: v_flex_value_where1 := ' AND
390: COMPANY.VALUE_SET_ID = :b_flex_value_where_vs_id1 AND
391: COMPANY.COMPANY_DISPLAY_CODE = ' || v_member_dc_col_name;

Line 520: FEM_COMPANIES_B COMPANY,';

516: /*
517: Join to Company member table to access member id
518: */
519: v_flex_value_from1 := '
520: FEM_COMPANIES_B COMPANY,';
521:
522: v_flex_value_where1 := ' AND
523: COMPANY.VALUE_SET_ID = :b_flex_value_where_vs_id1 AND
524: COMPANY.COMPANY_DISPLAY_CODE = GT.SEGMENT' ||

Line 1960: p_member_b_table_name => 'FEM_COMPANIES_B',

1956: -- When a Single Segment is a Balancing Segment
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',

Line 3266: pv_progress := 'Before insert into fem_companies_b';

3262: -- Insert individual dimension members for company
3263:
3264: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).table_validated_flag = 'N'
3265: THEN
3266: pv_progress := 'Before insert into fem_companies_b';
3267: --piush_util.put_line(pv_progress);
3268: INSERT INTO fem_companies_b
3269: (
3270: company_id,

Line 3268: INSERT INTO fem_companies_b

3264: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).table_validated_flag = 'N'
3265: THEN
3266: pv_progress := 'Before insert into fem_companies_b';
3267: --piush_util.put_line(pv_progress);
3268: INSERT INTO fem_companies_b
3269: (
3270: company_id,
3271: value_set_id,
3272: company_display_code,

Line 3301: FROM fem_companies_b tab2

3297: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_com_dim_id
3298: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(1).vs_id
3299: AND flex.flex_value = tab1.concat_segment_value
3300: AND not exists ( SELECT 'x'
3301: FROM fem_companies_b tab2
3302: WHERE tab2.value_set_id = fem_intg_dim_rule_eng_pkg.pv_com_vs_id
3303: AND tab1.concat_segment_value = tab2.company_display_code);
3304:
3305: v_comp_member_b_count := SQL%ROWCOUNT;

Line 3313: ,p_value1 => 'FEM_COMPANIES_B'

3309: ,p_module => pc_module_name||c_func_name
3310: ,p_app_name => 'FEM'
3311: ,p_msg_name => 'FEM_GL_POST_216'
3312: ,p_token1 => 'TABLE'
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';

Line 3345: FROM fem_companies_b tab1

3341: ,pv_user_id
3342: ,pv_user_id
3343: ,SYSDATE
3344: ,pv_login_id
3345: FROM fem_companies_b tab1
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'