APPS.XLA_CONDITIONS_PKG SQL Statements

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

Line: 60

| 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: 82

      l_log_module := C_DEFAULT_MODULE||'.delete_condition';

Line: 86

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

Line: 100

      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: 111

      DELETE
        FROM xla_conditions
       WHERE segment_rule_detail_id   = p_segment_rule_detail_id;

Line: 117

      DELETE
        FROM xla_conditions
       WHERE description_prio_id   = p_description_prio_id;

Line: 122

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

Line: 129

        (p_location   => 'xla_conditions_pkg.delete_condition');

Line: 131

END delete_condition;

Line: 160

   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: 201

   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: 213

   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: 224

   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: 233

   SELECT application_short_name
     FROM fnd_application_vl
    WHERE application_id = p_application_id;

Line: 543

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

Line: 610

   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: 629

   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: 641

   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: 648

   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: 655

   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: 662

   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: 670

   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: 680

   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: 690

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

Line: 697

   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: 706

   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: 717

   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: 731

   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: 741

   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: 752

   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: 761

   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: 771

   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: 1117

   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: 1135

   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: 1147

   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: 1154

   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: 1161

   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: 1168

   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: 1176

   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: 1186

   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: 1196

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

Line: 1203

   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: 1212

   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: 1223

   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: 1237

   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: 1247

   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: 1258

   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: 1267

   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: 1277

   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: 1630

   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: 1641

   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: 1671

   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: 1683

   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: 1695

   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: 1707

   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: 1720

   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: 1735

   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: 1750

   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: 1762

   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: 1776

   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: 1792

   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: 1811

   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: 1826

   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: 1842

   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: 1856

   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: 1871

   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;