341: --
342: IF l_condition.flexfield_segment_code is not null THEN
343:
344: IF l_source_flex_appl_id = 101 and l_source_id_flex_code = 'GL#' THEN
345: l_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
346: (p_application_id => 101
347: ,p_flex_code => 'GL#'
348: ,p_chart_of_accounts_id => p_chart_of_accounts_id
349: ,p_flexfield_segment_code => l_condition.flexfield_segment_code);
348: ,p_chart_of_accounts_id => p_chart_of_accounts_id
349: ,p_flexfield_segment_code => l_condition.flexfield_segment_code);
350:
351: IF l_flexfield_segment_name is null THEN
352: l_flexfield_segment_name := xla_flex_pkg.get_qualifier_name
353: (p_application_id => 101
354: ,p_id_flex_code => 'GL#'
355: ,p_qualifier_segment => l_condition.flexfield_segment_code);
356:
357:
358: END IF;
359: ELSE
360:
361: l_source_id_flex_num := xla_flex_pkg.get_flexfield_structure
362: (p_application_id => l_source_flex_appl_id
363: ,p_id_flex_code => l_source_id_flex_code);
364:
365: l_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
361: l_source_id_flex_num := xla_flex_pkg.get_flexfield_structure
362: (p_application_id => l_source_flex_appl_id
363: ,p_id_flex_code => l_source_id_flex_code);
364:
365: l_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
366: (p_application_id => l_source_flex_appl_id
367: ,p_flex_code => l_source_id_flex_code
368: ,p_chart_of_accounts_id => l_source_id_flex_num
369: ,p_flexfield_segment_code => l_condition.flexfield_segment_code);
413: ELSIF l_condition.value_type_code = 'C' THEN
414:
415: IF l_flex_value_set_id is not null THEN
416:
417: l_value_dsp := xla_flex_pkg.get_flex_value_meaning
418: (p_flex_value_set_id => l_flex_value_set_id
419: ,p_flex_value => l_condition.value_constant);
420:
421: ELSIF l_view_application_id is not null THEN
440: ,combination_id => to_number(l_condition.value_constant));
441:
442: ELSE
443:
444: l_source_id_flex_num := xla_flex_pkg.get_flexfield_structure
445: (p_application_id => l_source_flex_appl_id
446: ,p_id_flex_code => l_source_id_flex_code);
447:
448: OPEN c_appl(l_source_flex_appl_id);
481: --
482: IF l_condition.value_flexfield_segment_code is not null THEN
483:
484: IF l_value_source_flex_appl_id = 101 and l_value_source_id_flex_code = 'GL#' THEN
485: l_value_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
486: (p_application_id => 101
487: ,p_flex_code => 'GL#'
488: ,p_chart_of_accounts_id => p_chart_of_accounts_id
489: ,p_flexfield_segment_code => l_condition.value_flexfield_segment_code);
488: ,p_chart_of_accounts_id => p_chart_of_accounts_id
489: ,p_flexfield_segment_code => l_condition.value_flexfield_segment_code);
490:
491: IF l_value_flexfield_segment_name is null THEN
492: l_value_flexfield_segment_name := xla_flex_pkg.get_qualifier_name
493: (p_application_id => 101
494: ,p_id_flex_code => 'GL#'
495: ,p_qualifier_segment => l_condition.value_flexfield_segment_code);
496:
496:
497: END IF;
498: ELSE
499:
500: l_value_source_id_flex_num := xla_flex_pkg.get_flexfield_structure
501: (p_application_id => l_value_source_flex_appl_id
502: ,p_id_flex_code => l_value_source_id_flex_code);
503:
504: l_value_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
500: l_value_source_id_flex_num := xla_flex_pkg.get_flexfield_structure
501: (p_application_id => l_value_source_flex_appl_id
502: ,p_id_flex_code => l_value_source_id_flex_code);
503:
504: l_value_flexfield_segment_name := xla_flex_pkg.get_flexfield_segment_name
505: (p_application_id => l_value_source_flex_appl_id
506: ,p_flex_code => l_value_source_id_flex_code
507: ,p_chart_of_accounts_id => l_value_source_id_flex_num
508: ,p_flexfield_segment_code => l_condition.value_flexfield_segment_code);