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_HIER_RULE_ENG_PKG

Line 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);

2598: else
2599:
2600: --piush_util.put_line('else block');
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

Line 2654: , FEM_INTG_HIER_RULE_ENG_PKG.pv_hier_obj_def_id;

2650: ,p_value2 => v_main_gt_insert_stmt);
2651:
2652: EXECUTE IMMEDIATE v_main_gt_insert_stmt
2653: USING FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id
2654: , FEM_INTG_HIER_RULE_ENG_PKG.pv_hier_obj_def_id;
2655:
2656: end if;
2657:
2658: --piush_util.put_line('Execute v_main_gt_insert_stmt');

Line 4290: '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_id||',

4286: segment4_value,
4287: segment5_value,
4288: concat_segment_value)
4289: SELECT DISTINCT
4290: '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_id||',
4291: hgt.child_display_code,
4292: ''-1'',
4293: ''-1'',
4294: ''-1'',

Line 4299: WHERE ff.flex_value_set_id = '||FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id||'

4295: ''-1'',
4296: hgt.child_display_code
4297: FROM FEM_INTG_DIM_HIER_GT hgt,
4298: FND_FLEX_VALUES ff
4299: WHERE ff.flex_value_set_id = '||FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id||'
4300: AND ff.flex_value = hgt.child_display_code';
4301:
4302:
4303:

Line 4319: 'MERGE INTO '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_b_tab||' b

4315: COMMIT;
4316:
4317: -- Merge all parent members into the FEM member _B and _TL tables
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

Line 4326: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' =s.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
4327: AND b.value_set_id = :pv_dim_vs_id)
4328: WHEN MATCHED THEN UPDATE
4329: SET b.last_update_date = SYSDATE
4330: WHEN NOT MATCHED THEN

Line 4332: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',

4328: WHEN MATCHED THEN UPDATE
4329: SET b.last_update_date = SYSDATE
4330: WHEN NOT MATCHED THEN
4331: INSERT
4332: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',
4333: b.value_set_id,
4334: b.dimension_group_id,
4335: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_disp_col||',
4336: b.enabled_flag,

Line 4335: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_disp_col||',

4331: INSERT
4332: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',
4333: b.value_set_id,
4334: b.dimension_group_id,
4335: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_disp_col||',
4336: b.enabled_flag,
4337: b.personal_flag,
4338: b.creation_date,
4339: b.created_by,

Line 4371: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,

4367: p_token2 => 'VAR_VAL',
4368: p_value2 => v_sql_stmt);
4369:
4370: EXECUTE IMMEDIATE v_sql_stmt
4371: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4372: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4373: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4374: pv_user_id,
4375: pv_user_id,

Line 4372: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,

4368: p_value2 => v_sql_stmt);
4369:
4370: EXECUTE IMMEDIATE v_sql_stmt
4371: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4372: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4373: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4374: pv_user_id,
4375: pv_user_id,
4376: pv_login_id;

Line 4373: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,

4369:
4370: EXECUTE IMMEDIATE v_sql_stmt
4371: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4372: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4373: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4374: pv_user_id,
4375: pv_user_id,
4376: pv_login_id;
4377:

Line 4379: 'MERGE INTO '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_tl_tab||' b

4375: pv_user_id,
4376: pv_login_id;
4377:
4378: v_sql_stmt :=
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,

Line 4389: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' = s.flex_value_id

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
4388: AND ffv.flex_value = gt.concat_segment_value) s
4389: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' = s.flex_value_id
4390: AND b.language = s.language
4391: AND b.value_set_id = :pv_dim_vs_id)
4392: WHEN MATCHED THEN UPDATE
4393: SET b.last_update_date = SYSDATE

Line 4396: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',

4392: WHEN MATCHED THEN UPDATE
4393: SET b.last_update_date = SYSDATE
4394: WHEN NOT MATCHED THEN
4395: INSERT
4396: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',
4397: b.value_set_id,
4398: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_name_col||',
4399: b.language,
4400: b.source_lang,

Line 4398: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_name_col||',

4394: WHEN NOT MATCHED THEN
4395: INSERT
4396: (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||',
4397: b.value_set_id,
4398: b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_name_col||',
4399: b.language,
4400: b.source_lang,
4401: b.creation_date,
4402: b.created_by,

Line 4431: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,

4427: p_token2 => 'VAR_VAL',
4428: p_value2 => v_sql_stmt);
4429:
4430: EXECUTE IMMEDIATE v_sql_stmt
4431: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4432: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4433: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4434: pv_user_id,
4435: pv_user_id,

Line 4432: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,

4428: p_value2 => v_sql_stmt);
4429:
4430: EXECUTE IMMEDIATE v_sql_stmt
4431: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4432: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4433: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4434: pv_user_id,
4435: pv_user_id,
4436: pv_login_id;

Line 4433: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,

4429:
4430: EXECUTE IMMEDIATE v_sql_stmt
4431: USING FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id,
4432: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4433: FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_vs_id,
4434: pv_user_id,
4435: pv_user_id,
4436: pv_login_id;
4437:

Line 4441: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_id;

4437:
4438:
4439: -- Initialize the variables requred for Populate_Attr( )
4440: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id
4441: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_id;
4442: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id
4443: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_def_id;
4444: FEM_INTG_DIM_RULE_ENG_PKG.pv_user_id := pv_user_id;
4445:

Line 4443: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_def_id;

4439: -- Initialize the variables requred for Populate_Attr( )
4440: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id
4441: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_id;
4442: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id
4443: := FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_rule_obj_def_id;
4444: FEM_INTG_DIM_RULE_ENG_PKG.pv_user_id := pv_user_id;
4445:
4446: FEM_INTG_DIM_RULE_ENG_PKG.Init;
4447: