APPS.XLA_FLEX_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 70

   SELECT flex_value_set_name
   INTO   g_flex_value_set_name
   FROM   fnd_flex_value_sets
   WHERE  flex_value_set_id = p_flex_value_set_id
   ;

Line: 127

   SELECT id_flex_structure_name
   INTO   g_coa_name
   FROM   fnd_id_flex_structures_v
   WHERE  application_id = p_application_id
     AND  id_flex_code   = p_flex_code
     AND  id_flex_num    = p_chart_of_accounts_id
   ;

Line: 177

SELECT segment_name
FROM   fnd_id_flex_segments_vl
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_flex_code
  AND  id_flex_num             = p_chart_of_accounts_id
  AND  application_column_name = p_flexfield_segment_code
;

Line: 257

   SELECT validation_type
   INTO   l_validation_type
   FROM   fnd_flex_value_sets
   WHERE  flex_value_set_id = p_flex_value_set_id;

Line: 267

      SELECT flex_value_meaning
      INTO   g_meaning_meaning
      FROM   fnd_flex_values_vl
      WHERE  flex_value_set_id      = p_flex_value_set_id
        AND  flex_value             = p_flex_value
      ;

Line: 285

         SELECT additional_where_clause
           INTO l_additional_where_clause
           FROM fnd_flex_validation_tables
          WHERE flex_value_set_id = p_flex_value_set_id;

Line: 315

            SELECT 'SELECT '||value_column_name
               ||  xla_environment_pkg.g_chr_newline
               ||  'FROM   '||application_table_name
               ||  xla_environment_pkg.g_chr_newline
               ||  'WHERE  '||id_column_name  || ' = :1'
            INTO    l_statement
            FROM    fnd_flex_validation_tables
            WHERE   flex_value_set_id       = p_flex_value_set_id
            ;

Line: 329

            SELECT 'SELECT '||value_column_name
               ||  xla_environment_pkg.g_chr_newline
               ||  'FROM   '||application_table_name
               ||  xla_environment_pkg.g_chr_newline
               ||  'WHERE  '||id_column_name  || ' = :1'
               ||  ' AND  '||l_additional_where_clause
            INTO    l_statement
            FROM    fnd_flex_validation_tables
            WHERE   flex_value_set_id       = p_flex_value_set_id
            ;

Line: 408

SELECT segment_name
      ,segment_num
FROM   fnd_id_flex_segments_vl
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_flex_code
  AND  id_flex_num             = p_chart_of_accounts_id
  AND  application_column_name = p_flexfield_segment_code
  AND  enabled_flag            = 'Y'
;

Line: 421

SELECT count(segment_num)
FROM   fnd_id_flex_segments
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_flex_code
  AND  id_flex_num             = p_chart_of_accounts_id
  AND  enabled_flag            = 'Y'
  AND  display_flag            = 'Y'
  AND  segment_num             <= this_segment_num
;

Line: 480

| get_table_vset_select                                                 |
|                                                                       |
| Get the select for a table validated valueset                         |
|                                                                       |
+======================================================================*/
PROCEDURE get_table_vset_select
  (p_flex_value_set_id               IN     INTEGER
  ,p_select                          OUT NOCOPY    VARCHAR2
  ,p_mapping_code                    OUT NOCOPY    VARCHAR2
  ,p_success                         OUT NOCOPY    NUMBER)

IS


BEGIN

xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select'                , 20);

Line: 500

   fnd_flex_val_api.get_table_vset_select
                        (p_value_set_id           => p_flex_value_set_id
                        ,x_select                 => p_select
                        ,x_mapping_code           => p_mapping_code
                        ,x_success                => p_success);

Line: 507

xla_utility_pkg.trace('select       = '||p_select            , 40);

Line: 511

xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select'                , 20);

Line: 518

      (p_location   => 'xla_flex_pkg.get_table_vset_select');

Line: 519

END get_table_vset_select;

Line: 544

SELECT 'x'
FROM   fnd_segment_attribute_values
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_flex_code
  AND  id_flex_num             = p_chart_of_accounts_id
  AND  segment_attribute_type  = p_flexfield_segment_code
  AND  attribute_value         = 'Y'
;

Line: 617

   SELECT id_column_name
     INTO l_id_column_name
     FROM fnd_flex_validation_tables
    WHERE flex_value_set_id = p_flex_value_set_id;

Line: 662

   SELECT meaning_column_name
     INTO l_meaning_column_name
     FROM fnd_flex_validation_tables
    WHERE flex_value_set_id = p_flex_value_set_id;

Line: 708

      SELECT additional_where_clause
        INTO l_additional_where_clause
        FROM fnd_flex_validation_tables
       WHERE flex_value_set_id = p_flex_value_set_id;

Line: 763

SELECT application_column_name
FROM   fnd_segment_attribute_values
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_id_flex_code
  AND  id_flex_num             = p_id_flex_num
  AND  segment_attribute_type  = p_qualifier_segment
  AND  attribute_value         = 'Y'
;

Line: 825

SELECT segment_attribute_type
FROM   fnd_segment_attribute_values
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_id_flex_code
  AND  id_flex_num             = p_id_flex_num
  AND  application_column_name = p_segment_code
  AND  attribute_value         = 'Y'
;

Line: 891

SELECT flex_value_set_id
FROM   fnd_id_flex_segments
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_id_flex_code
  AND  id_flex_num             = p_id_flex_num
  AND  application_column_name = p_segment_code
;

Line: 954

SELECT segment_prompt
FROM   fnd_segment_attribute_types
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_id_flex_code
  AND  segment_attribute_type  = p_qualifier_segment;

Line: 1010

SELECT id_flex_num
FROM   fnd_id_flex_structures_vl
WHERE  application_id          = p_application_id
  AND  id_flex_code            = p_id_flex_code;