eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_LINE_DEFINITIONS_F_PVT SQL Statements

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

Line: 46


|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_event_type_code                  IN VARCHAR2
  ,x_line_definition_owner_code       IN VARCHAR2
  ,x_line_definition_code             IN VARCHAR2
  ,x_validation_status_code           IN VARCHAR2
  ,x_enabled_flag                     IN VARCHAR2
  ,x_budgetary_control_flag           IN VARCHAR2
  ,x_transaction_coa_id               IN NUMBER
  ,x_accounting_coa_id                IN NUMBER
  ,x_name                             IN VARCHAR2
  ,x_description                      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_line_definitions_b
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
;

Line: 87


  l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 91


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

Line: 96


INSERT INTO xla_line_definitions_b
(creation_date
,created_by
,application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,validation_status_code
,enabled_flag
,budgetary_control_flag
,transaction_coa_id
,accounting_coa_id
,object_version_number
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_application_id
,x_amb_context_code
,x_event_class_code
,x_event_type_code
,x_line_definition_owner_code
,x_line_definition_code
,x_validation_status_code
,x_enabled_flag
,x_budgetary_control_flag
,x_transaction_coa_id
,x_accounting_coa_id
,1
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;

Line: 134


INSERT INTO xla_line_definitions_tl
(amb_context_code
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,object_version_number
,application_id
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,name
,description
,language
,source_lang)
SELECT
       x_amb_context_code
      ,x_creation_date
      ,x_created_by
      ,x_last_update_date
      ,x_last_updated_by
      ,x_last_update_login
      ,1
      ,x_application_id
      ,x_event_class_code
      ,x_event_type_code
      ,x_line_definition_owner_code
      ,x_line_definition_code
      ,x_name
      ,x_description
      ,fl.language_code
      ,USERENV('LANG')
FROM   fnd_languages            fl
WHERE  fl.installed_flag        IN ('I', 'B')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_line_definitions_tl            xld
       WHERE  xld.application_id                 = x_application_id
         AND  xld.amb_context_code               = x_amb_context_code
         AND  xld.event_class_code               = x_event_class_code
         AND  xld.event_type_code                = x_event_type_code
         AND  xld.line_definition_owner_code     = x_line_definition_owner_code
         AND  xld.line_definition_code           = x_line_definition_code
         AND  xld.language                       = fl.language_code);

Line: 191


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

Line: 196


END insert_row;

Line: 221


SELECT enabled_flag
      ,transaction_coa_id
      ,accounting_coa_id
      ,budgetary_control_flag
FROM   xla_line_definitions_b
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
FOR UPDATE OF application_id NOWAIT;

Line: 237


SELECT name
      ,description
      ,DECODE(language, USERENV('LANG'), 'Y', 'N') baselang
FROM   xla_line_definitions_tl
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
  AND  USERENV('LANG')                 IN (language     ,source_lang)
FOR UPDATE OF application_id NOWAIT;

Line: 268


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

Line: 313


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_application_id                   IN NUMBER
 ,x_amb_context_code                 IN VARCHAR2
 ,x_event_class_code                 IN VARCHAR2
 ,x_event_type_code                  IN VARCHAR2
 ,x_line_definition_owner_code       IN VARCHAR2
 ,x_line_definition_code             IN VARCHAR2
 ,x_validation_status_code           IN VARCHAR2
 ,x_enabled_flag                     IN VARCHAR2
 ,x_budgetary_control_flag           IN VARCHAR2
 ,x_transaction_coa_id               IN NUMBER
 ,x_accounting_coa_id                IN NUMBER
 ,x_name                             IN VARCHAR2
 ,x_description                      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: 339


  l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 343


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

Line: 348


UPDATE xla_line_definitions_b
   SET
       last_update_date                 = x_last_update_date
      ,validation_status_code           = x_validation_status_code
      ,enabled_flag                     = x_enabled_flag
      ,budgetary_control_flag           = x_budgetary_control_flag
      ,transaction_coa_id               = x_transaction_coa_id
      ,accounting_coa_id                = x_accounting_coa_id
      ,object_version_number            = object_version_number+1
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code;

Line: 370


UPDATE xla_line_definitions_tl
SET
       last_update_date                 = x_last_update_date
      ,name                             = x_name
      ,description                      = x_description
      ,object_version_number            = object_version_number+1
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
      ,source_lang                      = USERENV('LANG')
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
  AND  USERENV('LANG')                 IN (language, source_lang);

Line: 392


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

Line: 397


END update_row;

Line: 401


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_event_type_code                  IN VARCHAR2
  ,x_line_definition_owner_code       IN VARCHAR2
  ,x_line_definition_code             IN VARCHAR2)

IS

l_log_module       VARCHAR2(240);

Line: 418


  l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 422


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

Line: 427


DELETE FROM xla_line_definitions_tl
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND event_class_code                 = x_event_class_code
  AND event_type_code                  = x_event_type_code
  AND line_definition_owner_code       = x_line_definition_owner_code
  AND line_definition_code             = x_line_definition_code;

Line: 439


DELETE FROM xla_line_definitions_b
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND event_class_code                 = x_event_class_code
  AND event_type_code                  = x_event_type_code
  AND line_definition_owner_code       = x_line_definition_owner_code
  AND line_definition_code             = x_line_definition_code;

Line: 452


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

Line: 457


END delete_row;

Line: 479


DELETE FROM xla_line_definitions_tl T
WHERE  NOT EXISTS
      (SELECT NULL
       FROM   xla_line_definitions_b             b
       WHERE  b.application_id                   = t.application_id
         AND  b.amb_context_code                 = t.amb_context_code
         AND  b.event_class_code                 = t.event_class_code
         AND  b.event_type_code                  = t.event_type_code
         AND  b.line_definition_owner_code       = t.line_definition_owner_code
         AND  b.line_definition_code             = t.line_definition_code);

Line: 490


UPDATE xla_line_definitions_tl   t
SET   (name
      ,description
      ,object_version_number)
   = (SELECT b.name
            ,b.description
            ,b.object_version_number + 1
      FROM   xla_line_definitions_tl            b
      WHERE  b.application_id                   = t.application_id
        AND  b.amb_context_code                 = t.amb_context_code
        AND  b.event_class_code                 = t.event_class_code
        AND  b.event_type_code                  = t.event_type_code
        AND  b.line_definition_owner_code       = t.line_definition_owner_code
        AND  b.line_definition_code             = t.line_definition_code
        AND  b.language                         = t.source_lang)
WHERE (t.application_id
      ,t.amb_context_code
      ,t.event_class_code
      ,t.event_type_code
      ,t.line_definition_owner_code
      ,t.line_definition_code
      ,t.language)
    IN (SELECT subt.application_id
              ,subt.amb_context_code
              ,subt.event_class_code
              ,subt.event_type_code
              ,subt.line_definition_owner_code
              ,subt.line_definition_code
              ,subt.language
        FROM   xla_line_definitions_tl               subb
              ,xla_line_definitions_tl               subt
        WHERE  subb.application_id                   = subt.application_id
         AND  subb.amb_context_code                  = subt.amb_context_code
         AND  subb.event_class_code                  = subt.event_class_code
         AND  subb.event_type_code                   = subt.event_type_code
         AND  subb.line_definition_owner_code        = subt.line_definition_owner_code
         AND  subb.line_definition_code              = subt.line_definition_code
         AND  subb.language                          = subt.source_lang
         AND (subb.name                              <> subt.name
          OR  subb.description                       <> subt.description
          OR (subb.description                       IS NULL
         AND  subt.description                       IS NOT NULL)
          OR (subb.description                       IS NOT NULL
         AND  subt.description                       IS NULL)
      ))
;

Line: 537


INSERT INTO xla_line_definitions_tl
(amb_context_code
,object_version_number
,last_update_login
,creation_date
,created_by
,last_update_date
,last_updated_by
,application_id
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,name
,description
,language
,source_lang)
SELECT   /*+ ORDERED */
       b.amb_context_code
      ,1
      ,b.last_update_login
      ,b.creation_date
      ,b.created_by
      ,b.last_update_date
      ,b.last_updated_by
      ,b.application_id
      ,b.event_class_code
      ,b.event_type_code
      ,b.line_definition_owner_code
      ,b.line_definition_code
      ,b.name
      ,b.description
      ,l.language_code
      ,b.source_lang
FROM   xla_line_definitions_tl         b
      ,fnd_languages                   l
WHERE  l.installed_flag                IN ('I', 'B')
  AND  b.language                      = userenv('LANG')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_line_definitions_tl               t
       WHERE  t.application_id                   = b.application_id
         AND  t.amb_context_code                 = b.amb_context_code
         AND  t.event_class_code                 = b.event_class_code
         AND  t.event_type_code                  = b.event_type_code
         AND  t.line_definition_owner_code       = b.line_definition_owner_code
         AND  t.line_definition_code             = b.line_definition_code
         AND  t.language                         = l.language_code);

Line: 610


  ,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: 622


  f_ludate                DATE;        -- entity update date in file

Line: 624


  db_ludate               DATE;        -- entity update date in db

Line: 642


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

Line: 649


    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_line_definitions_tl
     WHERE application_id              = l_application_id
       AND amb_context_code            = p_amb_context_code
       AND event_class_code            = p_event_class_code
       AND event_type_code             = p_event_type_code
       AND line_definition_owner_code  = p_line_definition_owner_code
       AND line_definition_code        = p_line_definition_code
       AND language                    = userenv('LANG');

Line: 662


      UPDATE xla_line_definitions_tl
         SET name                        = p_name
            ,description                 = p_description
            ,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 application_id              = l_application_id
         AND amb_context_code            = p_amb_context_code
         AND event_class_code            = p_event_class_code
         AND event_type_code             = p_event_type_code
         AND line_definition_owner_code  = p_line_definition_owner_code
         AND line_definition_code        = p_line_definition_code;