APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FND_FLEX_VALUES

Line 184: fnd_flex_values v,

180: fem_object_definition_b b1,
181: fem_intg_dim_rules dr,
182: fem_intg_dim_rule_defs drf,
183: fem_intg_hier_def_segs seg,
184: fnd_flex_values v,
185: fem_xdim_dimensions d,
186: fem_intg_aol_valset_map m
187: WHERE hir.hier_rule_obj_id = pv_hier_rule_obj_id
188: AND b1.object_definition_id = hir.dim_rule_obj_def_id

Line 257: fnd_flex_values v,

253: fem_object_definition_b b1,
254: fem_intg_dim_rules dr,
255: fem_intg_dim_rule_defs drf,
256: fem_intg_hier_def_segs seg,
257: fnd_flex_values v,
258: fem_xdim_dimensions d,
259: fem_intg_aol_valset_map m
260: WHERE hir.hier_rule_obj_id = pv_hier_rule_obj_id
261: AND b1.object_definition_id = hir.dim_rule_obj_def_id

Line 295: from fnd_flex_values

291: v_app_col_name5, 5,
292: null) INTO l_rec.concat_segment FROM DUAL;
293: -- Using l_rec.aol_vs_id and l_rec.top_parent_value to get l_rec.top_parent_id
294: select flex_value_id into l_rec.top_parent_id
295: from fnd_flex_values
296: where flex_value_set_id=l_rec.aol_vs_id
297: and flex_value= l_rec.top_parent_value ;
298: pv_traversal_rarray.extend;
299: pv_traversal_rarray(c_traversal_info%ROWCOUNT) := l_rec;

Line 643: fnd_flex_values ff

639: -1,
640: :v_dimension_group_id
641: FROM fem_intg_dim_hier_gt gt,
642: fnd_flex_value_norm_hierarchy vh,
643: fnd_flex_values ff
644: WHERE gt.child_depth_num = :v_parent_level
645: AND vh.flex_value_set_id = :pv_aol_vs_id
646: AND vh.parent_flex_value = gt.child_display_code
647: AND vh.range_attribute = ''P''

Line 1329: fnd_flex_values ff

1325: -1,
1326: 'N'
1327: FROM fem_intg_dim_hier_c1_gt gt,
1328: fnd_flex_value_norm_hierarchy vh,
1329: fnd_flex_values ff
1330: WHERE gt.child_depth_num = v_parent_level
1331: AND vh.flex_value_set_id = v_aol_vs_id
1332: AND vh.parent_flex_value = gt.child_display_code
1333: AND vh.range_attribute = 'P'

Line 1363: fnd_flex_values ff

1359: -1,
1360: 'N'
1361: FROM fem_intg_dim_hier_c2_gt gt,
1362: fnd_flex_value_norm_hierarchy vh,
1363: fnd_flex_values ff
1364: WHERE gt.child_depth_num = v_parent_level
1365: AND vh.flex_value_set_id = v_aol_vs_id
1366: AND vh.parent_flex_value = gt.child_display_code
1367: AND vh.range_attribute = 'P'

Line 1397: fnd_flex_values ff

1393: -1,
1394: 'N'
1395: FROM fem_intg_dim_hier_c3_gt gt,
1396: fnd_flex_value_norm_hierarchy vh,
1397: fnd_flex_values ff
1398: WHERE gt.child_depth_num = v_parent_level
1399: AND vh.flex_value_set_id = v_aol_vs_id
1400: AND vh.parent_flex_value = gt.child_display_code
1401: AND vh.range_attribute = 'P'

Line 1431: fnd_flex_values ff

1427: -1,
1428: 'N'
1429: FROM fem_intg_dim_hier_c4_gt gt,
1430: fnd_flex_value_norm_hierarchy vh,
1431: fnd_flex_values ff
1432: WHERE gt.child_depth_num = v_parent_level
1433: AND vh.flex_value_set_id = v_aol_vs_id
1434: AND vh.parent_flex_value = gt.child_display_code
1435: AND vh.range_attribute = 'P'

Line 1465: fnd_flex_values ff

1461: -1,
1462: 'N'
1463: FROM fem_intg_dim_hier_c5_gt gt,
1464: fnd_flex_value_norm_hierarchy vh,
1465: fnd_flex_values ff
1466: WHERE gt.child_depth_num = v_parent_level
1467: AND vh.flex_value_set_id = v_aol_vs_id
1468: AND vh.parent_flex_value = gt.child_display_code
1469: AND vh.range_attribute = 'P'

Line 1515: -- Test to use user defind tables versus fnd_flex_values for bottom leaves

1511: v_parent_level := v_parent_level + 1;
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

Line 1519: -- bottom level detail from fnd_flex_values

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:
1521: FEM_ENGINES_PKG.Tech_Message
1522: (p_severity => pc_log_level_procedure,
1523: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Bottom_Standard.',

Line 1550: fnd_flex_values ff

1546: -1,
1547: 'Y'
1548: FROM fem_intg_dim_hier_c1_gt gt,
1549: fnd_flex_value_norm_hierarchy vh,
1550: fnd_flex_values ff
1551: WHERE vh.flex_value_set_id = v_aol_vs_id
1552: AND vh.parent_flex_value = gt.child_display_code
1553: AND vh.range_attribute = 'C'
1554: AND ff.flex_value_set_id = v_aol_vs_id

Line 1581: fnd_flex_values ff

1577: -1,
1578: 'Y'
1579: FROM fem_intg_dim_hier_c2_gt gt,
1580: fnd_flex_value_norm_hierarchy vh,
1581: fnd_flex_values ff
1582: WHERE vh.flex_value_set_id = v_aol_vs_id
1583: AND vh.parent_flex_value = gt.child_display_code
1584: AND vh.range_attribute = 'C'
1585: AND ff.flex_value_set_id = v_aol_vs_id

Line 1612: fnd_flex_values ff

1608: -1,
1609: 'Y'
1610: FROM fem_intg_dim_hier_c3_gt gt,
1611: fnd_flex_value_norm_hierarchy vh,
1612: fnd_flex_values ff
1613: WHERE vh.flex_value_set_id = v_aol_vs_id
1614: AND vh.parent_flex_value = gt.child_display_code
1615: AND vh.range_attribute = 'C'
1616: AND ff.flex_value_set_id = v_aol_vs_id

Line 1643: fnd_flex_values ff

1639: -1,
1640: 'Y'
1641: FROM fem_intg_dim_hier_c4_gt gt,
1642: fnd_flex_value_norm_hierarchy vh,
1643: fnd_flex_values ff
1644: WHERE vh.flex_value_set_id = v_aol_vs_id
1645: AND vh.parent_flex_value = gt.child_display_code
1646: AND vh.range_attribute = 'C'
1647: AND ff.flex_value_set_id = v_aol_vs_id

Line 1674: fnd_flex_values ff

1670: -1,
1671: 'Y'
1672: FROM fem_intg_dim_hier_c5_gt gt,
1673: fnd_flex_value_norm_hierarchy vh,
1674: fnd_flex_values ff
1675: WHERE vh.flex_value_set_id = v_aol_vs_id
1676: AND vh.parent_flex_value = gt.child_display_code
1677: AND vh.range_attribute = 'C'
1678: AND ff.flex_value_set_id = v_aol_vs_id