APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_NEW_DIM_MEMBER_PKG

Line 745: FEM_INTG_NEW_DIM_MEMBER_PKG.Create_Parent_Members(

741: p_msg_text => 'v_parent_level :' || v_parent_level );
742: v_parent_level := v_parent_level + 1;
743: END LOOP;
744: COMMIT;
745: FEM_INTG_NEW_DIM_MEMBER_PKG.Create_Parent_Members(
746: x_completion_code => v_compl_code);
747: IF (v_compl_code = 2) THEN
748: RAISE FEM_INTG_fatal_err;
749: END IF;

Line 2591: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Multi_Segment (v_completion_code, v_dim_process_row_cnt, 'HIER_MULTI_SEG');

2587: -- 17OCT2005 BUG 4681970
2588: v_seq_stmt := 'DROP SEQUENCE ' || v_seq_name;
2589: EXECUTE IMMEDIATE v_seq_stmt;
2590: COMMIT;
2591: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Multi_Segment (v_completion_code, v_dim_process_row_cnt, 'HIER_MULTI_SEG');
2592: IF v_completion_code <> 0
2593: THEN
2594: raise_application_error(-20001, fnd_message.get);
2595: END IF;

Line 2598: set gt.parent_id = (select distinct b1.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b1 ';

2594: raise_application_error(-20001, fnd_message.get);
2595: END IF;
2596: -- update the hier GT table with the member_ids
2597: v_sql := 'update FEM_INTG_DIM_HIER_GT gt
2598: set gt.parent_id = (select distinct b1.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b1 ';
2599: v_sql := v_sql || ' where b1.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.parent_display_code and b1.VALUE_SET_ID = :pv_dim_vs_id)';
2600: v_sql := v_sql || ', gt.child_id = (select distinct b2.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b2 ';
2601: v_sql := v_sql || ' where b2.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.child_display_code and b2.VALUE_SET_ID = :pv_dim_vs_id)';
2602:

Line 2600: v_sql := v_sql || ', gt.child_id = (select distinct b2.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b2 ';

2596: -- update the hier GT table with the member_ids
2597: v_sql := 'update FEM_INTG_DIM_HIER_GT gt
2598: set gt.parent_id = (select distinct b1.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b1 ';
2599: v_sql := v_sql || ' where b1.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.parent_display_code and b1.VALUE_SET_ID = :pv_dim_vs_id)';
2600: v_sql := v_sql || ', gt.child_id = (select distinct b2.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b2 ';
2601: v_sql := v_sql || ' where b2.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.child_display_code and b2.VALUE_SET_ID = :pv_dim_vs_id)';
2602:
2603: FEM_ENGINES_PKG.Tech_Message(
2604: p_severity => pc_log_level_statement,