APPS.XLA_ENTITY_TYPES_PKG SQL Statements

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

Line: 46

   SELECT count(1)
     FROM xla_event_classes_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code;

Line: 53

   SELECT count(1)
     FROM xla_event_classes_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND enabled_flag     = 'Y';

Line: 66

   IF p_event = 'DELETE' THEN

      OPEN check_event_classes;

Line: 106

| delete_entity_details                                                 |
|                                                                       |
| Deletes all details of the entity                                     |
|                                                                       |
+======================================================================*/

PROCEDURE delete_entity_details
  (p_application_id                   IN NUMBER
  ,p_entity_code                      IN VARCHAR2)
IS

BEGIN

   xla_utility_pkg.trace('> xla_entity_types_pkg.delete_entity_details'        , 10);

Line: 124

   DELETE
     FROM xla_entity_id_mappings
    WHERE application_id = p_application_id
      AND entity_code    = p_entity_code;

Line: 129

   xla_utility_pkg.trace('< xla_entity_types_pkg.delete_entity_details'        , 10);

Line: 136

        (p_location   => 'xla_entity_types_pkg.delete_entity_details');

Line: 138

END delete_entity_details;

Line: 174

    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.entity_code                = p_entity_code
       AND (xpa.validation_status_code    NOT IN ('E', 'Y', 'N') OR
            xpa.locking_status_flag       = 'Y');

Line: 223

      UPDATE xla_line_definitions_b     xld
         SET validation_status_code     = 'N'
       WHERE xld.application_id         = p_application_id
         AND xld.event_class_code       IN (SELECT event_class_code
                                              FROM xla_event_classes_b
                                             WHERE entity_code = p_entity_code)
         AND xld.validation_status_code <> 'N';

Line: 231

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

Line: 237

      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.entity_code            = p_entity_code);