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_HIER_RULE_ENG_PKG dependencies on FEM_INTG_DIM_RULE_ENG_PKG

Line 392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init

388: FEM_ENGINES_PKG.Tech_Message
389: (p_severity => pc_log_level_statement,
390: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
391: p_msg_text => 'pv_gvsc_id:'||pv_gvsc_id);
392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init
393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message

Line 393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;

389: (p_severity => pc_log_level_statement,
390: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
391: p_msg_text => 'pv_gvsc_id:'||pv_gvsc_id);
392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init
393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message
397: (p_severity => pc_log_level_procedure,

Line 394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;

390: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
391: p_msg_text => 'pv_gvsc_id:'||pv_gvsc_id);
392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init
393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message
397: (p_severity => pc_log_level_procedure,
398: p_module => 'fem.plsql.fem_intg_hier_eng.Init.',

Line 395: FEM_INTG_DIM_RULE_ENG_PKG.Init;

391: p_msg_text => 'pv_gvsc_id:'||pv_gvsc_id);
392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init
393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message
397: (p_severity => pc_log_level_procedure,
398: p_module => 'fem.plsql.fem_intg_hier_eng.Init.',
399: p_msg_text => ' pv_dim_varchar_label:' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label);

Line 399: p_msg_text => ' pv_dim_varchar_label:' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label);

395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message
397: (p_severity => pc_log_level_procedure,
398: p_module => 'fem.plsql.fem_intg_hier_eng.Init.',
399: p_msg_text => ' pv_dim_varchar_label:' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label);
400: x_completion_code := 0;
401: FEM_ENGINES_PKG.Tech_Message
402: (p_severity => pc_log_level_procedure,
403: p_module => 'fem.plsql.fem_intg_hier_eng.init.',

Line 582: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,

578: p_init_msg_list => FND_API.G_TRUE,
579: x_dimension_group_id => v_dimension_group_id,
580: x_dim_group_sequence => v_dim_group_seq,
581: p_dimension_varchar_label =>
582: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
583: p_dim_group_name =>
584: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
585: p_dim_group_display_code =>
586: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

Line 584: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

580: x_dim_group_sequence => v_dim_group_seq,
581: p_dimension_varchar_label =>
582: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
583: p_dim_group_name =>
584: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
585: p_dim_group_display_code =>
586: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
587: p_dim_group_description =>
588: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);

Line 586: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

582: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
583: p_dim_group_name =>
584: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
585: p_dim_group_display_code =>
586: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
587: p_dim_group_description =>
588: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
589: END IF;
590:

Line 588: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);

584: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
585: p_dim_group_display_code =>
586: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
587: p_dim_group_description =>
588: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
589: END IF;
590:
591: FEM_ENGINES_PKG.Tech_Message
592: (p_severity => pc_log_level_procedure,

Line 768: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,

764: p_init_msg_list => FND_API.G_TRUE,
765: x_dimension_group_id => v_dimension_group_id,
766: x_dim_group_sequence => v_dim_group_seq,
767: p_dimension_varchar_label =>
768: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
769: p_dim_group_name =>
770: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
771: p_dim_group_display_code =>
772: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

Line 770: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

766: x_dim_group_sequence => v_dim_group_seq,
767: p_dimension_varchar_label =>
768: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
769: p_dim_group_name =>
770: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
771: p_dim_group_display_code =>
772: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
773: p_dim_group_description =>
774: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);

Line 772: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

768: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
769: p_dim_group_name =>
770: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
771: p_dim_group_display_code =>
772: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
773: p_dim_group_description =>
774: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
775: END IF;
776:

Line 774: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);

770: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
771: p_dim_group_display_code =>
772: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
773: p_dim_group_description =>
774: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
775: END IF;
776:
777: FEM_ENGINES_PKG.Tech_Message
778: (p_severity => pc_log_level_procedure,

Line 1087: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;

1083: ' pv_coa_id' || pv_coa_id);
1084:
1085: -- run intialize dimension package variables
1086: -- sets up pv_mapped_segs structure which is used below.
1087: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
1088: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
1089: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id := pv_dim_id;
1090: FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id := pv_coa_id;
1091:

Line 1088: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;

1084:
1085: -- run intialize dimension package variables
1086: -- sets up pv_mapped_segs structure which is used below.
1087: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
1088: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
1089: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id := pv_dim_id;
1090: FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id := pv_coa_id;
1091:
1092: -- bug 4752271 - Add code to populate the company and cost center

Line 1089: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id := pv_dim_id;

1085: -- run intialize dimension package variables
1086: -- sets up pv_mapped_segs structure which is used below.
1087: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
1088: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
1089: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id := pv_dim_id;
1090: FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id := pv_coa_id;
1091:
1092: -- bug 4752271 - Add code to populate the company and cost center
1093: -- dimension and value set id values.

Line 1090: FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id := pv_coa_id;

1086: -- sets up pv_mapped_segs structure which is used below.
1087: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
1088: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
1089: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id := pv_dim_id;
1090: FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id := pv_coa_id;
1091:
1092: -- bug 4752271 - Add code to populate the company and cost center
1093: -- dimension and value set id values.
1094: IF pv_dim_id = 8 THEN

Line 1097: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id

1093: -- dimension and value set id values.
1094: IF pv_dim_id = 8 THEN
1095:
1096: SELECT dimension_id
1097: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id
1098: FROM fem_dimensions_b
1099: WHERE dimension_varchar_label = 'COMPANY';
1100:
1101: SELECT dimension_id

Line 1102: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id

1098: FROM fem_dimensions_b
1099: WHERE dimension_varchar_label = 'COMPANY';
1100:
1101: SELECT dimension_id
1102: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id
1103: FROM fem_dimensions_b
1104: WHERE dimension_varchar_label = 'COST_CENTER';
1105:
1106: SELECT value_set_id

Line 1107: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_com_vs_id

1103: FROM fem_dimensions_b
1104: WHERE dimension_varchar_label = 'COST_CENTER';
1105:
1106: SELECT value_set_id
1107: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_com_vs_id
1108: FROM fem_global_vs_combo_defs
1109: WHERE global_vs_combo_id = pv_gvsc_id
1110: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id;
1111:

Line 1110: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id;

1106: SELECT value_set_id
1107: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_com_vs_id
1108: FROM fem_global_vs_combo_defs
1109: WHERE global_vs_combo_id = pv_gvsc_id
1110: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id;
1111:
1112: SELECT value_set_id
1113: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_vs_id
1114: FROM fem_global_vs_combo_defs

Line 1113: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_vs_id

1109: WHERE global_vs_combo_id = pv_gvsc_id
1110: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id;
1111:
1112: SELECT value_set_id
1113: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_vs_id
1114: FROM fem_global_vs_combo_defs
1115: WHERE global_vs_combo_id = pv_gvsc_id
1116: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id;
1117:

Line 1116: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id;

1112: SELECT value_set_id
1113: INTO FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_vs_id
1114: FROM fem_global_vs_combo_defs
1115: WHERE global_vs_combo_id = pv_gvsc_id
1116: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id;
1117:
1118: END IF;
1119:
1120: FEM_INTG_DIM_RULE_ENG_PKG.Init;

Line 1120: FEM_INTG_DIM_RULE_ENG_PKG.Init;

1116: AND dimension_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_cc_dim_id;
1117:
1118: END IF;
1119:
1120: FEM_INTG_DIM_RULE_ENG_PKG.Init;
1121:
1122: -- loop and buid each component hierarchy based on
1123: -- pv_traversal_rarray which is base on hier rule definition
1124: i_hier_ctr := pv_traversal_rarray.first;

Line 1135: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).vs_id THEN

1131: v_aol_vs_id := pv_traversal_rarray(i_hier_ctr).aol_vs_id;
1132:
1133: -- these should be the same or there are rule definition inconsistencies
1134: if pv_traversal_rarray(i_hier_ctr).aol_vs_id <>
1135: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).vs_id THEN
1136:
1137: -- set messages and have fatial error.
1138: FEM_ENGINES_PKG.Tech_Message
1139: (p_severity => pc_log_level_unexpected,

Line 1516: CASE FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_validated_flag

1512:
1513: END loop; -- end of intermediate paraent loop
1514:
1515: -- Test to use user defind tables versus fnd_flex_values for bottom leaves
1516: CASE FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_validated_flag
1517: WHEN 'N' THEN
1518:
1519: -- bottom level detail from fnd_flex_values
1520:

Line 1696: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name

1692: bottom level detail based on user defined table
1693: we use pv_mapped_segs to get this info and use dynamic sql to
1694: construct a statement like this:
1695: The varing items are:
1696: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name
1697: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name
1698: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).id_col_name
1699: INSERT INTO fem_intg_dim_hier_gt
1700: (hierarchy_obj_def_id,

Line 1697: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name

1693: we use pv_mapped_segs to get this info and use dynamic sql to
1694: construct a statement like this:
1695: The varing items are:
1696: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name
1697: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name
1698: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).id_col_name
1699: INSERT INTO fem_intg_dim_hier_gt
1700: (hierarchy_obj_def_id,
1701: parent_depth_num,

Line 1698: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).id_col_name

1694: construct a statement like this:
1695: The varing items are:
1696: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name
1697: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name
1698: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).id_col_name
1699: INSERT INTO fem_intg_dim_hier_gt
1700: (hierarchy_obj_def_id,
1701: parent_depth_num,
1702: parent_id,

Line 1775: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || ',

1771: gt.child_id,
1772: gt.child_display_code,
1773: (gt.child_depth_num + 1),
1774: -1,
1775: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || ',
1776: ''Y'',
1777: -1,
1778: ''Y''
1779: FROM fem_intg_dim_hier_c' || pv_traversal_rarray(i_hier_ctr).display_order || '_gt gt,

Line 1780: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name || ',

1776: ''Y'',
1777: -1,
1778: ''Y''
1779: FROM fem_intg_dim_hier_c' || pv_traversal_rarray(i_hier_ctr).display_order || '_gt gt,
1780: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name || ',
1781: fnd_flex_value_norm_hierarchy vh
1782: ';
1783: -- ending concatinated to where that was assigned above
1784: V_sql_stmt_end := '

Line 1785: AND ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || '

1781: fnd_flex_value_norm_hierarchy vh
1782: ';
1783: -- ending concatinated to where that was assigned above
1784: V_sql_stmt_end := '
1785: AND ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || '
1786: ' || 'BETWEEN vh.child_flex_value_low
1787: AND vh.child_flex_value_high
1788: ORDER BY ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name ;
1789: -- concatenate three sections

Line 1788: ORDER BY ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name ;

1784: V_sql_stmt_end := '
1785: AND ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || '
1786: ' || 'BETWEEN vh.child_flex_value_low
1787: AND vh.child_flex_value_high
1788: ORDER BY ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name ;
1789: -- concatenate three sections
1790: V_sql_stmt := V_sql_stmt_start || v_where || V_sql_stmt_end;
1791:
1792: FEM_ENGINES_PKG.Tech_Message

Line 2508: p_dimension_varchar_label => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,

2504: p_encoded => FND_API.G_FALSE,
2505: p_init_msg_list => FND_API.G_TRUE,
2506: x_dimension_group_id => v_dimension_group_id,
2507: x_dim_group_sequence => v_dim_group_seq,
2508: p_dimension_varchar_label => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2509: p_dim_group_name => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2510: p_dim_group_display_code => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq
2512: );

Line 2509: p_dim_group_name => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

2505: p_init_msg_list => FND_API.G_TRUE,
2506: x_dimension_group_id => v_dimension_group_id,
2507: x_dim_group_sequence => v_dim_group_seq,
2508: p_dimension_varchar_label => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2509: p_dim_group_name => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2510: p_dim_group_display_code => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq
2512: );
2513: END IF;

Line 2510: p_dim_group_display_code => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,

2506: x_dimension_group_id => v_dimension_group_id,
2507: x_dim_group_sequence => v_dim_group_seq,
2508: p_dimension_varchar_label => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2509: p_dim_group_name => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2510: p_dim_group_display_code => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq
2512: );
2513: END IF;
2514: IF (v_API_return_status NOT IN ('S')) THEN

Line 2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq

2507: x_dim_group_sequence => v_dim_group_seq,
2508: p_dimension_varchar_label => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2509: p_dim_group_name => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2510: p_dim_group_display_code => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq,
2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq
2512: );
2513: END IF;
2514: IF (v_API_return_status NOT IN ('S')) THEN
2515: FEM_ENGINES_PKG.Tech_Message

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

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:
2603: FEM_ENGINES_PKG.Tech_Message(

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,

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

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,
2605: p_module => 'fem.plsql.Bld_Hier_Multi_Segment4',

Line 2793: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,

2789: p_init_msg_list => FND_API.G_TRUE,
2790: x_dimension_group_id => pv_top_dimension_group_id,
2791: x_dim_group_sequence => v_dim_group_seq,
2792: p_dimension_varchar_label =>
2793: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2794: p_dim_group_name =>
2795: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2796: p_dim_group_display_code =>
2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',

Line 2795: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',

2791: x_dim_group_sequence => v_dim_group_seq,
2792: p_dimension_varchar_label =>
2793: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2794: p_dim_group_name =>
2795: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2796: p_dim_group_display_code =>
2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2798: p_dim_group_description =>
2799: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100');

Line 2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',

2793: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label,
2794: p_dim_group_name =>
2795: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2796: p_dim_group_display_code =>
2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2798: p_dim_group_description =>
2799: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100');
2800: END IF;
2801: FEM_ENGINES_PKG.Tech_Message

Line 2799: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100');

2795: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2796: p_dim_group_display_code =>
2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2798: p_dim_group_description =>
2799: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100');
2800: END IF;
2801: FEM_ENGINES_PKG.Tech_Message
2802: (p_severity => pc_log_level_procedure,
2803: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',