APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_COST_CENTERS_B

Line 404: FEM_COST_CENTERS_B COST_CENTER,';

400: /*
401: Join to Cost Center member table to access member id
402: */
403: v_flex_value_from1 := '
404: FEM_COST_CENTERS_B COST_CENTER,';
405:
406: v_flex_value_where1 := ' AND
407: COST_CENTER.VALUE_SET_ID = :b_flex_value_where_vs_id1 AND
408: COST_CENTER.COST_CENTER_DISPLAY_CODE = ' || v_member_dc_col_name;

Line 542: FEM_COST_CENTERS_B COST_CENTER,';

538: /*
539: Join to Cost Center member table to access member id
540: */
541: v_flex_value_from2 := '
542: FEM_COST_CENTERS_B COST_CENTER,';
543:
544: v_flex_value_where2 := ' AND
545: COST_CENTER.VALUE_SET_ID = :b_flex_value_where_vs_id2 AND
546: COST_CENTER.COST_CENTER_DISPLAY_CODE = GT.SEGMENT' ||

Line 1974: p_member_b_table_name => 'FEM_COST_CENTERS_B',

1970: -- When a Single Segment is a Cost Center Segment
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',

Line 3504: pv_progress := 'Before insert into fem_cost_centers_b';

3500:
3501:
3502: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).table_validated_flag = 'N'
3503: THEN
3504: pv_progress := 'Before insert into fem_cost_centers_b';
3505: --piush_util.put_line(pv_progress);
3506: IF fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).dependent_value_set_flag = 'Y'
3507: THEN
3508: INSERT INTO fem_cost_centers_b

Line 3508: INSERT INTO fem_cost_centers_b

3504: pv_progress := 'Before insert into fem_cost_centers_b';
3505: --piush_util.put_line(pv_progress);
3506: IF fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).dependent_value_set_flag = 'Y'
3507: THEN
3508: INSERT INTO fem_cost_centers_b
3509: (
3510: cost_center_id,
3511: value_set_id,
3512: cost_center_display_code,

Line 3542: FROM fem_cost_centers_b tab2

3538: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).vs_id
3539: AND flex.parent_flex_value_low = tab1.segment1_value
3540: AND flex.flex_value = tab1.segment2_value
3541: AND not exists ( SELECT 'x'
3542: FROM fem_cost_centers_b tab2
3543: WHERE tab2.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3544: AND tab1.segment2_value = tab2.cost_center_display_code); v_cc_member_b_count := SQL%ROWCOUNT;
3545:
3546: ELSE /* Independent value set */

Line 3547: INSERT INTO fem_cost_centers_b

3543: WHERE tab2.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3544: AND tab1.segment2_value = tab2.cost_center_display_code); v_cc_member_b_count := SQL%ROWCOUNT;
3545:
3546: ELSE /* Independent value set */
3547: INSERT INTO fem_cost_centers_b
3548: (
3549: cost_center_id,
3550: value_set_id,
3551: cost_center_display_code,

Line 3580: FROM fem_cost_centers_b tab2

3576: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_cc_dim_id
3577: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).vs_id
3578: AND flex.flex_value = tab1.concat_segment_value
3579: AND not exists ( SELECT 'x'
3580: FROM fem_cost_centers_b tab2
3581: WHERE tab2.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3582: AND tab1.concat_segment_value = tab2.cost_center_display_code);
3583:
3584: v_cc_member_b_count := SQL%ROWCOUNT;

Line 3593: ,p_value1 => 'FEM_COST_CENTERS_B'

3589: ,p_module => pc_module_name||c_func_name
3590: ,p_app_name => 'FEM'
3591: ,p_msg_name => 'FEM_GL_POST_216'
3592: ,p_token1 => 'TABLE'
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';

Line 3624: FROM fem_cost_centers_b tab1

3620: ,pv_user_id
3621: ,pv_user_id
3622: ,SYSDATE
3623: ,pv_login_id
3624: FROM fem_cost_centers_b tab1
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'