APPS.XLA_EVENT_CLASSES_PKG SQL Statements

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

Line: 47

   SELECT 'x'
     FROM xla_event_types_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND event_type_code  <> p_event_class_code||'_ALL';

Line: 56

   SELECT 'x'
     FROM xla_event_types_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND event_type_code  <> p_event_class_code||'_ALL'
      AND enabled_flag     = 'Y';

Line: 66

   SELECT 'x'
     FROM xla_acct_line_types_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 74

   SELECT 'x'
     FROM xla_acct_line_types_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND enabled_flag     = 'Y';

Line: 83

   SELECT 'x'
     FROM xla_analytical_sources
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 91

   SELECT 'x'
     FROM xla_prod_acct_headers
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 105

   IF p_event = 'DELETE' THEN

      OPEN check_event_types;

Line: 219

| delete_class_details                                                  |
|                                                                       |
| Deletes all details of the class                                      |
|                                                                       |
+======================================================================*/

PROCEDURE delete_class_details
  (p_application_id                   IN NUMBER
  ,p_entity_code                      IN VARCHAR2
  ,p_event_class_code                 IN VARCHAR2)
IS

   l_event_mapping_id   integer;

Line: 237

   SELECT event_mapping_id
     FROM xla_event_mappings_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 244

   xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details'                    , 10);

Line: 253

   DELETE
     FROM xla_event_sources
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 259

   DELETE
     FROM xla_extract_objects
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 265

   DELETE
     FROM xla_event_class_predecs
    WHERE application_id   = p_application_id
      AND event_class_code = p_event_class_code;

Line: 276

      xla_event_mappings_f_pkg.delete_row
        (x_event_mapping_id   => l_event_mapping_id);

Line: 282

   xla_acct_setup_pkg.delete_event_class_setup
     (p_application_id             => l_application_id
     ,p_event_class_code           => l_event_class_code);

Line: 286

   DELETE
     FROM xla_event_class_attrs
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code;

Line: 292

     xla_event_types_f_pkg.delete_row
       (x_application_id                   => p_application_id
       ,x_entity_code                      => p_entity_code
       ,x_event_class_code                 => p_event_class_code
       ,x_event_type_code                  => p_event_class_code||'_ALL');

Line: 298

   xla_utility_pkg.trace('< xla_event_classes_pkg.delete_class_details'                    , 10);

Line: 305

        (p_location   => 'xla_event_classes_pkg.delete_class_details');

Line: 307

END delete_class_details;

Line: 378

    SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code,
           xpa.product_rule_type_code, xpa.product_rule_code,
           xpa.amb_context_code, xpa.locking_status_flag
      FROM xla_prod_acct_headers    xpa
     WHERE xpa.application_id             = p_application_id
       AND xpa.event_class_code           = p_event_class_code
       AND (xpa.validation_status_code    NOT IN ('E', 'Y', 'N') OR
            xpa.locking_status_flag       = 'Y');

Line: 427

      UPDATE xla_line_definitions_b     xld
         SET validation_status_code     = 'N'
       WHERE xld.application_id         = p_application_id
         AND xld.event_class_code       = p_event_class_code
         AND xld.validation_status_code <> 'N';

Line: 433

      UPDATE xla_prod_acct_headers      xpa
         SET validation_status_code     = 'N'
       WHERE xpa.application_id         = p_application_id
         AND xpa.event_class_code       = p_event_class_code
         AND xpa.validation_status_code <> 'N';

Line: 439

      UPDATE xla_product_rules_b        xpr
         SET compile_status_code        = 'N'
       WHERE xpr.application_id         = p_application_id
         AND xpr.compile_status_code    <> 'N'
         AND (xpr.amb_context_code
             ,xpr.product_rule_type_code
             ,xpr.product_rule_code)    IN
             (SELECT xpa.amb_context_code
                    ,xpa.product_rule_type_code
                    ,xpa.product_rule_code
                FROM xla_prod_acct_headers  xpa
               WHERE xpa.application_id         = p_application_id
                 AND xpa.event_class_code       = p_event_class_code);

Line: 505

   SELECT 'x'
     FROM xla_prod_acct_headers s
    WHERE application_id            = p_application_id
      AND event_class_code          = p_event_class_code
      AND locking_status_flag       = 'Y';