APPS.XLA_EVENT_MAPPINGS_F_PKG SQL Statements

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

Line: 64

|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_event_mapping_id                 IN NUMBER
  ,x_application_id                   IN NUMBER
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_user_sequence                    IN NUMBER
  ,x_column_name                      IN VARCHAR2
  ,x_column_title                     IN VARCHAR2
  ,x_creation_date                    IN DATE
  ,x_created_by                       IN NUMBER
  ,x_last_update_date                 IN DATE
  ,x_last_updated_by                  IN NUMBER
  ,x_last_update_login                IN NUMBER)

IS

CURSOR c IS
SELECT rowid
FROM   xla_event_mappings_b
WHERE  event_mapping_id                 = x_event_mapping_id
;

Line: 94

    l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 98

    trace(p_msg    => 'BEGIN of procedure insert_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 103

INSERT INTO xla_event_mappings_b
(creation_date
,created_by
,event_mapping_id
,application_id
,entity_code
,event_class_code
,user_sequence
,column_name
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_event_mapping_id
,x_application_id
,x_entity_code
,x_event_class_code
,x_user_sequence
,x_column_name
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;

Line: 129

INSERT INTO xla_event_mappings_tl
(event_mapping_id
,column_title
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,language
,source_lang)
SELECT
       x_event_mapping_id
      ,x_column_title
      ,x_creation_date
      ,x_created_by
      ,x_last_update_date
      ,x_last_updated_by
      ,x_last_update_login
      ,l.language_code
      ,USERENV('LANG')
FROM   fnd_languages l
WHERE  l.installed_flag                 IN ('I', 'B')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_event_mappings_tl              t
       WHERE  t.event_mapping_id                 = x_event_mapping_id
         AND  t.language                         = l.language_code);

Line: 167

    trace(p_msg    => 'END of procedure insert_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 172

END insert_row;

Line: 191

SELECT event_mapping_id
      ,application_id
      ,entity_code
      ,event_class_code
      ,user_sequence
      ,column_name
FROM   xla_event_mappings_b
WHERE  event_mapping_id                 = x_event_mapping_id
FOR UPDATE OF event_mapping_id NOWAIT;

Line: 204

SELECT event_mapping_id
      ,column_title
      ,DECODE(language     , USERENV('LANG'), 'Y', 'N') baselang
FROM   xla_event_mappings_tl
WHERE  event_mapping_id                 = X_event_mapping_id
  AND  USERENV('LANG')                 IN (language     ,source_lang)
FOR UPDATE OF event_mapping_id NOWAIT;

Line: 230

   fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 271

|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_event_mapping_id                 IN NUMBER
 ,x_application_id                   IN NUMBER
 ,x_entity_code                      IN VARCHAR2
 ,x_event_class_code                 IN VARCHAR2
 ,x_user_sequence                    IN NUMBER
 ,x_column_name                      IN VARCHAR2
 ,x_column_title                     IN VARCHAR2
 ,x_last_update_date                  IN DATE
 ,x_last_updated_by                   IN NUMBER
 ,x_last_update_login                 IN NUMBER)

IS

  l_log_module            VARCHAR2(240);

Line: 292

    l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 296

    trace(p_msg    => 'BEGIN of procedure update_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 301

UPDATE xla_event_mappings_b
   SET
       last_update_date                 = x_last_update_date
      ,application_id                   = x_application_id
      ,entity_code                      = x_entity_code
      ,event_class_code                 = x_event_class_code
      ,user_sequence                    = x_user_sequence
      ,column_name                      = x_column_name
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  event_mapping_id                 = X_event_mapping_id;

Line: 317

UPDATE xla_event_mappings_tl
SET
       last_update_date                 = x_last_update_date
      ,column_title                     = X_column_title
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
      ,source_lang                      = USERENV('LANG')
WHERE  event_mapping_id                 = X_event_mapping_id
  AND  USERENV('LANG')                 IN (language, source_lang);

Line: 332

    trace(p_msg    => 'END of procedure update_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 337

END update_row;

Line: 341

|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_event_mapping_id                 IN NUMBER)

IS

  l_log_module            VARCHAR2(240);

Line: 353

    l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 357

    trace(p_msg    => 'BEGIN of procedure delete_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 362

DELETE FROM xla_event_mappings_tl
WHERE event_mapping_id                 = x_event_mapping_id;

Line: 370

DELETE FROM xla_event_mappings_b
WHERE event_mapping_id                 = x_event_mapping_id;

Line: 380

    trace(p_msg    => 'END of procedure delete_row',
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 385

END delete_row;

Line: 409

DELETE FROM xla_event_mappings_tl T
WHERE  NOT EXISTS
      (SELECT NULL
       FROM   xla_event_mappings_b               b
       WHERE  b.event_mapping_id                 = t.event_mapping_id);

Line: 415

UPDATE xla_event_mappings_tl   t
SET   (column_title)
   = (SELECT b.column_title
      FROM   xla_event_mappings_tl              b
      WHERE  b.event_mapping_id                 = t.event_mapping_id
        AND  b.language                         = t.source_lang)
WHERE (t.event_mapping_id
      ,t.language)
    IN (SELECT subt.event_mapping_id
              ,subt.language
        FROM   xla_event_mappings_tl                  subb
              ,xla_event_mappings_tl                  subt
        WHERE  subb.event_mapping_id                 = subt.event_mapping_id
         AND  subb.language                         = subt.source_lang
         AND (SUBB.column_title                     <> SUBT.column_title
      ))
;

Line: 433

INSERT INTO xla_event_mappings_tl
(event_mapping_id
,column_title
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,language
,source_lang)
SELECT   /*+ ORDERED */
       b.event_mapping_id
      ,b.column_title
      ,b.creation_date
      ,b.created_by
      ,b.last_update_date
      ,b.last_updated_by
      ,b.last_update_login
      ,l.language_code
      ,b.source_lang
FROM   xla_event_mappings_tl            b
      ,fnd_languages                    l
WHERE  l.installed_flag                IN ('I', 'B')
  AND  b.language                       = userenv('LANG')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_event_mappings_tl              t
       WHERE  t.event_mapping_id                 = b.event_mapping_id
         AND  t.language                         = l.language_code);

Line: 484

,p_last_update_date                   IN VARCHAR2
,p_column_title                       IN VARCHAR2)
IS
  CURSOR c_app_id IS
  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = p_application_short_name;

Line: 497

  f_ludate                DATE;        -- entity update date in file

Line: 499

  db_ludate               DATE;        -- entity update date in db

Line: 517

  f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 525

    SELECT event_mapping_id, last_updated_by, last_update_date
      INTO l_event_mapping_id, db_luby, db_ludate
      FROM xla_event_mappings_vl
     WHERE application_id       = l_application_id
       AND entity_code          = p_entity_code
       AND event_class_code     = p_event_class_code
       AND (user_sequence       = p_user_sequence or
            column_name         = p_column_name);

Line: 535

      xla_event_mappings_f_pkg.update_row
          (x_event_mapping_id              => l_event_mapping_id
          ,x_application_id                => l_application_id
          ,x_entity_code                   => p_entity_code
          ,x_event_class_code              => p_event_class_code
          ,x_user_sequence                 => p_user_sequence
          ,x_column_name                   => p_column_name
          ,x_column_title                  => p_column_title
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);

Line: 551

      SELECT xla_event_mappings_s.nextval
        INTO l_event_mapping_id
        FROM dual;

Line: 555

      xla_event_mappings_f_pkg.insert_row
          (x_rowid                         => l_rowid
          ,x_event_mapping_id              => l_event_mapping_id
          ,x_application_id                => l_application_id
          ,x_entity_code                   => p_entity_code
          ,x_event_class_code              => p_event_class_code
          ,x_column_name                   => p_column_name
          ,x_user_sequence                 => p_user_sequence
          ,x_column_title                  => p_column_title
          ,x_creation_date                 => f_ludate
          ,x_created_by                    => f_luby
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);

Line: 571

      DELETE FROM xla_event_mappings_tl
       WHERE event_mapping_id IN
             (SELECT event_mapping_id
                FROM xla_event_mappings_b
               WHERE application_id       = l_application_id
                 AND entity_code          = p_entity_code
                 AND event_class_code     = p_event_class_code
                 AND (user_sequence       = p_user_sequence or
                      column_name         = p_column_name));

Line: 581

      DELETE FROM xla_event_mappings_b
            WHERE application_id       = l_application_id
              AND entity_code          = p_entity_code
              AND event_class_code     = p_event_class_code
              AND (user_sequence       = p_user_sequence or
                   column_name         = p_column_name);

Line: 588

      SELECT xla_event_mappings_s.nextval
        INTO l_event_mapping_id
        FROM dual;

Line: 592

      xla_event_mappings_f_pkg.insert_row
          (x_rowid                         => l_rowid
          ,x_event_mapping_id              => l_event_mapping_id
          ,x_application_id                => l_application_id
          ,x_entity_code                   => p_entity_code
          ,x_event_class_code              => p_event_class_code
          ,x_column_name                   => p_column_name
          ,x_user_sequence                 => p_user_sequence
          ,x_column_title                  => p_column_title
          ,x_creation_date                 => f_ludate
          ,x_created_by                    => f_luby
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);

Line: 637

  ,p_last_update_date                 IN VARCHAR2
  ,p_custom_mode                      IN VARCHAR2)
IS
  CURSOR c_app_id IS
  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = p_application_short_name;

Line: 650

  f_ludate                DATE;        -- entity update date in file

Line: 652

  db_ludate               DATE;        -- entity update date in db

Line: 670

  f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 678

    SELECT event_mapping_id, last_updated_by, last_update_date
      INTO l_event_mapping_id, db_luby, db_ludate
      FROM xla_event_mappings_vl
     WHERE application_id       = l_application_id
       AND entity_code          = p_entity_code
       AND event_class_code     = p_event_class_code
       AND (user_sequence       = p_user_sequence or
            column_name         = p_column_name);

Line: 689

      UPDATE xla_event_mappings_tl
         SET column_title      = p_column_title
            ,last_update_date  = f_ludate
            ,last_updated_by   = f_luby
            ,last_update_login = 0
            ,source_lang       = userenv('LANG')
       WHERE userenv('LANG')   IN (language, source_lang)
         AND event_mapping_id  = l_event_mapping_id;