APPS.XLA_CONDITIONS_PKG SQL Statements

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

Line: 73

| delete_condition                                                      |
|                                                                       |
| Deletes all conditions attached to the parent                         |
|                                                                       |
+======================================================================*/

PROCEDURE delete_condition
  (p_context                          IN VARCHAR2
  ,p_application_id                   IN NUMBER    DEFAULT NULL
  ,p_amb_context_code                 IN VARCHAR2  DEFAULT NULL
  ,p_entity_code                      IN VARCHAR2  DEFAULT NULL
  ,p_event_class_code                 IN VARCHAR2  DEFAULT NULL
  ,p_accounting_line_type_code        IN VARCHAR2  DEFAULT NULL
  ,p_accounting_line_code             IN VARCHAR2  DEFAULT NULL
  ,p_segment_rule_detail_id           IN NUMBER    DEFAULT NULL
  ,p_description_prio_id              IN NUMBER    DEFAULT NULL)

IS
  l_log_module             VARCHAR2(240);

Line: 95

      l_log_module := C_DEFAULT_MODULE||'.delete_condition';

Line: 99

      trace('delete_condition.Begin',C_LEVEL_PROCEDURE,l_log_module);

Line: 113

      DELETE
        FROM xla_conditions
       WHERE application_id            = p_application_id
         AND amb_context_code          = p_amb_context_code
         AND entity_code               = p_entity_code
         AND event_class_code          = p_event_class_code
         AND accounting_line_type_code = p_accounting_line_type_code
         AND accounting_line_code      = p_accounting_line_code;

Line: 124

      DELETE
        FROM xla_conditions
       WHERE segment_rule_detail_id   = p_segment_rule_detail_id;

Line: 130

      DELETE
        FROM xla_conditions
       WHERE description_prio_id   = p_description_prio_id;

Line: 135

   trace('delete_condition.End',C_LEVEL_PROCEDURE,l_log_module);

Line: 142

        (p_location   => 'xla_conditions_pkg.delete_condition');

Line: 144

END delete_condition;

Line: 173

   SELECT user_sequence, bracket_left_code, bracket_right_code, value_type_code,
          source_application_id, source_type_code, source_code,
          flexfield_segment_code, value_flexfield_segment_code,
          value_source_application_id, value_source_type_code,
          value_source_code, value_constant, line_operator_code,
          logical_operator_code, independent_value_constant
     FROM xla_conditions
    WHERE segment_rule_detail_id = p_segment_rule_detail_id
      AND p_context              = 'S'
   UNION
   SELECT user_sequence, bracket_left_code, bracket_right_code, value_type_code,
          source_application_id, source_type_code, source_code,
          flexfield_segment_code, value_flexfield_segment_code,
          value_source_application_id, value_source_type_code,
          value_source_code, value_constant, line_operator_code,
          logical_operator_code, independent_value_constant
     FROM xla_conditions
    WHERE application_id            = p_application_id
      AND amb_context_code          = p_amb_context_code
      AND entity_code               = p_entity_code
      AND event_class_code          = p_event_class_code
      AND accounting_line_type_code = p_accounting_line_type_code
      AND accounting_line_code      = p_accounting_line_code
      AND p_context              = 'A'
   UNION
   SELECT user_sequence, bracket_left_code, bracket_right_code, value_type_code,
          source_application_id, source_type_code, source_code,
          flexfield_segment_code, value_flexfield_segment_code,
          value_source_application_id, value_source_type_code,
          value_source_code, value_constant, line_operator_code,
          logical_operator_code, independent_value_constant
     FROM xla_conditions
    WHERE description_prio_id = p_description_prio_id
      AND p_context              = 'D'
    ORDER BY user_sequence;

Line: 214

   SELECT name, flex_value_set_id, datatype_code, view_application_id, lookup_type,
          flexfield_application_id, id_flex_code, segment_code
     FROM xla_sources_vl
    WHERE application_id    = p_application_id
      AND source_type_code  = p_source_type_code
      AND source_code       = p_source_code;

Line: 226

   SELECT name, flexfield_application_id, id_flex_code
     FROM xla_sources_vl
    WHERE application_id    = p_application_id
      AND source_type_code  = p_source_type_code
      AND source_code       = p_source_code;

Line: 237

   SELECT meaning
     FROM fnd_lookup_values_vl
    WHERE view_application_id = p_view_application_id
      AND lookup_type         = p_lookup_type
      AND lookup_code         = p_lookup_code;

Line: 246

   SELECT application_short_name
     FROM fnd_application_vl
    WHERE application_id = p_application_id;

Line: 708

   SELECT 'x'
     FROM xla_desc_priorities d
    WHERE d.application_id        = p_application_id
      AND d.amb_context_code      = p_amb_context_code
      AND d.description_type_code = p_description_type_code
      AND d.description_code      = p_description_code
      AND exists(SELECT count(1)
                   FROM xla_conditions c
                  WHERE c.description_prio_id = d.description_prio_id
                    AND c.bracket_left_code is not null
                  MINUS
                 SELECT count(1)
                   FROM xla_conditions c1
                  WHERE c1.description_prio_id = d.description_prio_id
                    AND c1.bracket_right_code is not null);

Line: 727

   SELECT description_prio_id
     FROM xla_desc_priorities d
    WHERE d.application_id        = p_application_id
      AND d.amb_context_code      = p_amb_context_code
      AND d.description_type_code = p_description_type_code
      AND d.description_code      = p_description_code
      AND exists (SELECT 'y'
                   FROM xla_conditions c
                  WHERE c.description_prio_id = d.description_prio_id);

Line: 739

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is not null;

Line: 746

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_right_code is not null;

Line: 753

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is not null;

Line: 760

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_right_code is not null;

Line: 768

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is null
      AND c.bracket_right_code is null
      AND c.source_code is null;

Line: 778

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is not null
      AND c.bracket_right_code is not null
      AND c.source_code is null;

Line: 788

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id;

Line: 795

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.user_sequence          = l_desc_user_sequence
      AND c.logical_operator_code is not null;

Line: 804

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is not null
      AND c.source_code is null
      AND c.logical_operator_code is not null;

Line: 815

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND (c.source_code is not null
       OR  c.bracket_right_code is not null)
      AND c.logical_operator_code is null
      AND c.user_sequence <> l_desc_user_sequence;

Line: 829

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_no_logical_operator.user_sequence + 1;

Line: 839

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.source_code is null
      AND c.bracket_left_code is not null;

Line: 850

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.bracket_left_code is not null
      AND c.user_sequence = l_no_source_bracket.user_sequence + 1;

Line: 859

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.logical_operator_code is not null;

Line: 869

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.description_prio_id = p_description_prio_id
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_log_op_not_null.user_sequence + 1;

Line: 1215

   SELECT 'x'
     FROM xla_seg_rule_details d
    WHERE d.application_id         = p_application_id
      AND d.amb_context_code       = p_amb_context_code
      AND d.segment_rule_type_code = p_segment_rule_type_code
      AND d.segment_rule_code      = p_segment_rule_code
      AND exists(SELECT count(1)
                   FROM xla_conditions c
                  WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
                    AND c.bracket_left_code is not null
                  MINUS
                 SELECT count(1)
                   FROM xla_conditions c1
                  WHERE c1.segment_rule_detail_id = d.segment_rule_detail_id
                    AND c1.bracket_right_code is not null);

Line: 1233

   SELECT segment_rule_detail_id
     FROM xla_seg_rule_details d
    WHERE d.application_id         = p_application_id
      AND d.amb_context_code       = p_amb_context_code
      AND d.segment_rule_type_code = p_segment_rule_type_code
      AND d.segment_rule_code      = p_segment_rule_code
      AND exists (SELECT 'y'
                   FROM xla_conditions c
                  WHERE c.segment_rule_detail_id = d.segment_rule_detail_id);

Line: 1245

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is not null;

Line: 1252

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_right_code is not null;

Line: 1259

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is not null;

Line: 1266

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_right_code is not null;

Line: 1274

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is null
      AND c.bracket_right_code is null
      AND c.source_code is null;

Line: 1284

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is not null
      AND c.bracket_right_code is not null
      AND c.source_code is null;

Line: 1294

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id;

Line: 1301

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.user_sequence          = l_seg_user_sequence
      AND c.logical_operator_code is not null;

Line: 1310

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is not null
      AND c.source_code is null
      AND c.logical_operator_code is not null;

Line: 1321

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND (c.source_code is not null
       OR  c.bracket_right_code is not null)
      AND c.logical_operator_code is null
      AND c.user_sequence <> l_seg_user_sequence;

Line: 1335

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_no_logical_operator.user_sequence + 1;

Line: 1345

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.source_code is null
      AND c.bracket_left_code is not null;

Line: 1356

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.bracket_left_code is not null
      AND c.user_sequence = l_no_source_bracket.user_sequence + 1;

Line: 1365

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.logical_operator_code is not null;

Line: 1375

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_log_op_not_null.user_sequence + 1;

Line: 1728

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code;

Line: 1739

   SELECT 'x'
     FROM xla_acct_line_types_b d
    WHERE d.application_id            = p_application_id
      AND d.amb_context_code          = p_amb_context_code
      AND d.entity_code               = p_entity_code
      AND d.event_class_code          = p_event_class_code
      AND d.accounting_line_type_code = p_accounting_line_type_code
      AND d.accounting_line_code      = p_accounting_line_code
      AND exists(SELECT count(1)
                   FROM xla_conditions c
                  WHERE c.application_id            = d.application_id
                    AND c.amb_context_code          = d.amb_context_code
                    AND c.entity_code               = d.entity_code
                    AND c.event_class_code          = d.event_class_code
                    AND c.accounting_line_type_code = d.accounting_line_type_code
                    AND c.accounting_line_code      = d.accounting_line_code
                    AND c.bracket_left_code is not null
                  MINUS
                 SELECT count(1)
                   FROM xla_conditions c1
                  WHERE c1.application_id            = d.application_id
                    AND c1.amb_context_code          = d.amb_context_code
                    AND c1.entity_code               = d.entity_code
                    AND c1.event_class_code          = d.event_class_code
                    AND c1.accounting_line_type_code = d.accounting_line_type_code
                    AND c1.accounting_line_code      = d.accounting_line_code
                    AND c1.bracket_right_code is not null);

Line: 1769

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is not null;

Line: 1781

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_right_code is not null;

Line: 1793

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is not null;

Line: 1805

   SELECT min(user_sequence)
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_right_code is not null;

Line: 1818

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is null
      AND c.bracket_right_code is null
      AND c.source_code is null;

Line: 1833

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is not null
      AND c.bracket_right_code is not null
      AND c.source_code is null;

Line: 1848

   SELECT max(user_sequence)
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code;

Line: 1860

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.user_sequence             = l_acct_user_sequence
      AND c.logical_operator_code is not null;

Line: 1874

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is not null
      AND c.source_code is null
      AND c.logical_operator_code is not null;

Line: 1890

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND (c.source_code is not null
       OR  c.bracket_right_code is not null)
      AND c.logical_operator_code is null
      AND c.user_sequence <> l_acct_user_sequence;

Line: 1909

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_no_logical_operator.user_sequence + 1;

Line: 1924

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.source_code is null
      AND c.bracket_left_code is not null;

Line: 1940

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.bracket_left_code is not null
      AND c.user_sequence = l_no_source_bracket.user_sequence + 1;

Line: 1954

   SELECT user_sequence
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.logical_operator_code is not null;

Line: 1969

   SELECT 'x'
     FROM xla_conditions c
    WHERE c.application_id            = p_application_id
      AND c.amb_context_code          = p_amb_context_code
      AND c.entity_code               = p_entity_code
      AND c.event_class_code          = p_event_class_code
      AND c.accounting_line_type_code = p_accounting_line_type_code
      AND c.accounting_line_code      = p_accounting_line_code
      AND c.source_code is null
      AND c.bracket_right_code is not null
      AND c.user_sequence = l_log_op_not_null.user_sequence + 1;