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_MEMBERS_GT

Line 603: FEM_INTG_DIM_MEMBERS_GT GT,' || v_flex_value_from1 || v_flex_value_from2 || '

599: END IF;
600:
601: v_from := '
602: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' M,
603: FEM_INTG_DIM_MEMBERS_GT GT,' || v_flex_value_from1 || v_flex_value_from2 || '
604: FEM_DIM_ATTRIBUTES_B A,
605: FEM_DIM_ATTR_VERSIONS_B AV' || v_gvsc_from;
606:
607: v_where := '

Line 2505: -- members into GT table FEM_INTG_DIM_MEMBERS_GT

2501: END IF;
2502:
2503: ------------------------------------------------------------------------------
2504: -- Build dyanmic SQL to insert all the unique combination of concatenaned
2505: -- members into GT table FEM_INTG_DIM_MEMBERS_GT
2506: ------------------------------------------------------------------------------
2507:
2508: --piush_util.put_line('p_calling_module = ' || p_calling_module);
2509:

Line 2515: := ' INSERT INTO FEM_INTG_DIM_MEMBERS_GT

2511:
2512: --piush_util.put_line('if p_calling_module is null');
2513:
2514: v_main_gt_insert_stmt
2515: := ' INSERT INTO FEM_INTG_DIM_MEMBERS_GT
2516: ( DIMENSION_ID
2517: , SEGMENT1_VALUE
2518: , SEGMENT2_VALUE
2519: , SEGMENT3_VALUE

Line 2605: := ' INSERT INTO FEM_INTG_DIM_MEMBERS_GT

2601:
2602: --piush_util.put_line('FEM_INTG_HIER_RULE_ENG_PKG.pv_hier_obj_def_id = ' || FEM_INTG_HIER_RULE_ENG_PKG.pv_hier_obj_def_id);
2603:
2604: v_main_gt_insert_stmt
2605: := ' INSERT INTO FEM_INTG_DIM_MEMBERS_GT
2606: ( DIMENSION_ID
2607: , SEGMENT1_VALUE
2608: , SEGMENT2_VALUE
2609: , SEGMENT3_VALUE

Line 2670: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT'

2666: ,p_module => pc_module_name||c_func_name
2667: ,p_app_name => 'FEM'
2668: ,p_msg_name => 'FEM_GL_POST_216'
2669: ,p_token1 => 'TABLE'
2670: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT'
2671: ,p_token2 => 'NUM'
2672: ,p_value2 => v_main_insert_gt_count);
2673:
2674:

Line 2714: FROM fem_intg_dim_members_gt tab1

2710: , sysdate
2711: , :v_login_id
2712: , 1
2713: , ''N''
2714: FROM fem_intg_dim_members_gt tab1
2715: WHERE NOT EXISTS (SELECT ''x''
2716: FROM ' || -- Bug 4393061 - changed read_only_flag to 'N'
2717: FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name ||' tab2
2718: WHERE tab2.value_set_id = :v_fem_vs_id

Line 2874: fem_intg_dim_members_gt GT

2870: ,:v_userid UPDATED_BY
2871: ,sysdate UPDATED_DATE
2872: ,:v_login_id UPDATE_LOGIN
2873: FROM '||fem_intg_dim_rule_eng_pkg.pv_member_b_table_name ||' tab1,
2874: fem_intg_dim_members_gt GT
2875: ,fnd_languages fil
2876: ,fnd_languages fil_source';
2877:
2878: IF NVL(fem_intg_dim_rule_eng_pkg.pv_mapped_segs(1).table_validated_flag,'N') = 'Y'

Line 3215: 'INSERT INTO FEM_INTG_DIM_MEMBERS_GT GT

3211:
3212: pv_progress := 'Before creating dynamic GT insert for Company';
3213: --piush_util.put_line(pv_progress);
3214: v_comp_gt_insert_stmt :=
3215: 'INSERT INTO FEM_INTG_DIM_MEMBERS_GT GT
3216: ( DIMENSION_ID
3217: , SEGMENT1_VALUE
3218: , SEGMENT2_VALUE
3219: , SEGMENT3_VALUE

Line 3231: FROM FEM_INTG_DIM_MEMBERS_GT GT2

3227: , -1
3228: , -1
3229: , -1
3230: , segment1_value
3231: FROM FEM_INTG_DIM_MEMBERS_GT GT2
3232: WHERE GT2.dimension_id = :v_dim_id';
3233:
3234:
3235: FEM_ENGINES_PKG.Tech_Message

Line 3257: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT (for Comp dim)'

3253: ,p_module => pc_module_name||c_func_name
3254: ,p_app_name => 'FEM'
3255: ,p_msg_name => 'FEM_GL_POST_216'
3256: ,p_token1 => 'TABLE'
3257: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT (for Comp dim)'
3258: ,p_token2 => 'NUM'
3259: ,p_value2 => v_comp_insert_gt_count);
3260:
3261:

Line 3295: FROM fem_intg_dim_members_gt tab1

3291: ,SYSDATE
3292: ,pv_login_id
3293: ,'N' -- Bug 4393061 - changed read_only_flag to 'N'
3294: ,1
3295: FROM fem_intg_dim_members_gt tab1
3296: ,fnd_flex_values flex
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

Line 3403: FROM fem_intg_dim_members_gt tab1';

3399: ,''N''
3400: ,1
3401: ,concat_segment_value
3402: ,flex.descr
3403: FROM fem_intg_dim_members_gt tab1';
3404:
3405: v_insert_comp_vl_stmt := v_insert_comp_vl_stmt|| ',( SELECT '
3406: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).meaning_col_name
3407: ||' DESCR ,'

Line 3460: 'INSERT INTO FEM_INTG_DIM_MEMBERS_GT GT

3456:
3457: pv_progress := 'Before building dynamic stmt for CostCenter GT INSERT';
3458: --piush_util.put_line(pv_progress);
3459: v_cc_gt_insert_stmt :=
3460: 'INSERT INTO FEM_INTG_DIM_MEMBERS_GT GT
3461: ( DIMENSION_ID
3462: , SEGMENT1_VALUE
3463: , SEGMENT2_VALUE
3464: , SEGMENT3_VALUE

Line 3476: FROM FEM_INTG_DIM_MEMBERS_GT GT2

3472: , -1
3473: , -1
3474: , -1
3475: , segment2_value
3476: FROM FEM_INTG_DIM_MEMBERS_GT GT2
3477: WHERE GT2.dimension_id = :v_dim_id';
3478:
3479: pv_progress := 'Before EXECUTION of CostCenter GT INSERT';
3480: --piush_util.put_line(pv_progress);

Line 3494: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT (FOR CC DIM)'

3490: ,p_module => pc_module_name||c_func_name
3491: ,p_app_name => 'FEM'
3492: ,p_msg_name => 'FEM_GL_POST_216'
3493: ,p_token1 => 'TABLE'
3494: ,p_value1 => 'FEM_INTG_DIM_MEMBERS_GT (FOR CC DIM)'
3495: ,p_token2 => 'NUM'
3496: ,p_value2 => v_cc_insert_gt_count);
3497:
3498:

Line 3535: FROM fem_intg_dim_members_gt tab1

3531: ,SYSDATE
3532: ,pv_login_id
3533: ,'N'
3534: ,1
3535: FROM fem_intg_dim_members_gt tab1
3536: ,fnd_flex_values flex
3537: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_dim_id /* Because dependent VS*/
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

Line 3574: FROM fem_intg_dim_members_gt tab1

3570: ,SYSDATE
3571: ,pv_login_id
3572: ,'N' -- Bug 4393061 - changed read_only_flag to 'N'
3573: ,1
3574: FROM fem_intg_dim_members_gt tab1
3575: ,fnd_flex_values flex
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

Line 3681: FROM fem_intg_dim_members_gt tab1';

3677: ,''N''
3678: ,1
3679: ,concat_segment_value
3680: ,flex.descr
3681: FROM fem_intg_dim_members_gt tab1';
3682: -- Bug 4393061 - changed read_only_flag to 'N'
3683: v_insert_cc_vl_stmt := v_insert_cc_vl_stmt|| ',( SELECT '
3684: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).meaning_col_name
3685: ||' DESCR ,'

Line 4279: -- the member GT table FEM_INTG_DIM_MEMBERS_GT

4275:
4276: x_completion_code := 0;
4277:
4278: -- Insert all distinct parent members from the hierarchy into
4279: -- the member GT table FEM_INTG_DIM_MEMBERS_GT
4280: v_sql_stmt :=
4281: 'INSERT INTO fem_intg_dim_members_gt
4282: (dimension_id,
4283: segment1_value,

Line 4281: 'INSERT INTO fem_intg_dim_members_gt

4277:
4278: -- Insert all distinct parent members from the hierarchy into
4279: -- the member GT table FEM_INTG_DIM_MEMBERS_GT
4280: v_sql_stmt :=
4281: 'INSERT INTO fem_intg_dim_members_gt
4282: (dimension_id,
4283: segment1_value,
4284: segment2_value,
4285: segment3_value,

Line 4322: FROM fem_intg_dim_members_gt gt,

4318: v_sql_stmt :=
4319: 'MERGE INTO '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_b_tab||' b
4320: USING (SELECT gt.concat_segment_value,
4321: ffv.flex_value_id
4322: FROM fem_intg_dim_members_gt gt,
4323: fnd_flex_values ffv
4324: WHERE ffv.flex_value_set_id = :pv_aol_vs_id
4325: AND ffv.flex_value = gt.concat_segment_value) s
4326: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' =s.flex_value_id

Line 4383: FROM fem_intg_dim_members_gt gt,

4379: 'MERGE INTO '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_tl_tab||' b
4380: USING (SELECT tl.flex_value_id, ffv.flex_value,
4381: tl.description,
4382: tl.language, tl.source_lang
4383: FROM fem_intg_dim_members_gt gt,
4384: fnd_flex_values_tl tl,
4385: fnd_flex_values ffv
4386: WHERE tl.flex_value_id = ffv.flex_value_id
4387: AND ffv.flex_value_set_id = :pv_aol_vs_id