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_ANALYTICAL_HDRS_F_PKG SQL Statements

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

Line: 61


|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_analytical_criterion_code        IN VARCHAR2
  ,x_analytical_criterion_type_co     IN VARCHAR2
  ,x_amb_context_code                 IN VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_balancing_flag                   IN VARCHAR2
  ,x_display_order                    IN NUMBER
  ,x_enabled_flag                     IN VARCHAR2
  ,x_year_end_carry_forward_code      IN VARCHAR2
  ,x_display_in_inquiries_flag        IN VARCHAR2
  ,x_criterion_value_code             IN VARCHAR2
  ,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_analytical_hdrs_b
WHERE  analytical_criterion_code        = x_analytical_criterion_code
  AND  analytical_criterion_type_code   = x_analytical_criterion_type_co
  AND  amb_context_code                 = x_amb_context_code
;

Line: 97


  l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 101


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

Line: 107


INSERT INTO xla_analytical_hdrs_b
(creation_date
,created_by
,analytical_criterion_code
,analytical_criterion_type_code
,amb_context_code
,application_id
,balancing_flag
,display_order
,enabled_flag
,year_end_carry_forward_code
,display_in_inquiries_flag
,criterion_value_code
,updated_flag
,version_num
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_analytical_criterion_code
,x_analytical_criterion_type_co
,x_amb_context_code
,x_application_id
,x_balancing_flag
,x_display_order
,x_enabled_flag
,x_year_end_carry_forward_code
,x_display_in_inquiries_flag
,x_criterion_value_code
,'Y'
,0
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;

Line: 145


INSERT INTO xla_analytical_hdrs_tl
(analytical_criterion_code
,analytical_criterion_type_code
,amb_context_code
,name
,description
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,language
,source_lang)
SELECT
       x_analytical_criterion_code
      ,x_analytical_criterion_type_co
      ,x_amb_context_code
      ,x_name
      ,x_description
      ,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_analytical_hdrs_tl             t
       WHERE  t.analytical_criterion_code        = x_analytical_criterion_code
         AND  t.analytical_criterion_type_code   = x_analytical_criterion_type_co
         AND  t.amb_context_code                 = x_amb_context_code
         AND  t.language                         = l.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: 220


SELECT analytical_criterion_code
      ,application_id
      ,balancing_flag
      ,display_order
      ,enabled_flag
      ,year_end_carry_forward_code
      ,display_in_inquiries_flag
      ,criterion_value_code
FROM   xla_analytical_hdrs_b
WHERE  analytical_criterion_code        = x_analytical_criterion_code
  AND  analytical_criterion_type_code   = x_analytical_criterion_type_co
  AND  amb_context_code                 = x_amb_context_code
FOR UPDATE OF analytical_criterion_code NOWAIT;

Line: 237


SELECT analytical_criterion_code
      ,name
      ,description
      ,DECODE(language     , USERENV('LANG'), 'Y', 'N') baselang
FROM   xla_analytical_hdrs_tl
WHERE  analytical_criterion_code        = X_analytical_criterion_code
  AND  analytical_criterion_type_code   = X_analytical_criterion_type_co
  AND  amb_context_code                 = X_amb_context_code
  AND  USERENV('LANG')                 IN (language     ,source_lang)
FOR UPDATE OF analytical_criterion_code NOWAIT;

Line: 266


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

Line: 317


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_analytical_criterion_code        IN VARCHAR2
 ,x_analytical_criterion_type_co     IN VARCHAR2
 ,x_amb_context_code                 IN VARCHAR2
 ,x_application_id                   IN NUMBER
 ,x_balancing_flag                   IN VARCHAR2
 ,x_display_order                    IN NUMBER
 ,x_enabled_flag                     IN VARCHAR2
 ,x_year_end_carry_forward_code      IN VARCHAR2
 ,x_display_in_inquiries_flag        IN VARCHAR2
 ,x_criterion_value_code             IN VARCHAR2
 ,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: 342


  l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 346


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

Line: 351


UPDATE xla_analytical_hdrs_b
   SET
       last_update_date                 = x_last_update_date
      ,application_id                   = x_application_id
      ,balancing_flag                   = x_balancing_flag
      ,display_order                    = x_display_order
      ,enabled_flag                     = x_enabled_flag
      ,year_end_carry_forward_code      = x_year_end_carry_forward_code
      ,display_in_inquiries_flag        = x_display_in_inquiries_flag
      ,criterion_value_code             = x_criterion_value_code
      ,updated_flag                     = 'Y'
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  analytical_criterion_code        = X_analytical_criterion_code
  AND  analytical_criterion_type_code   = X_analytical_criterion_type_co
  AND  amb_context_code                 = X_amb_context_code;

Line: 372


UPDATE xla_analytical_hdrs_tl
SET
       last_update_date                 = x_last_update_date
      ,name                             = X_name
      ,description                      = X_description
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
      ,source_lang                      = USERENV('LANG')
WHERE  analytical_criterion_code        = X_analytical_criterion_code
  AND  analytical_criterion_type_code   = X_analytical_criterion_type_co
  AND  amb_context_code                 = X_amb_context_code
  AND  USERENV('LANG')                 IN (language, source_lang);

Line: 390


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

Line: 395


END update_row;

Line: 399


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_analytical_criterion_code        IN VARCHAR2
  ,x_analytical_criterion_type_co     IN VARCHAR2
  ,x_amb_context_code                 IN VARCHAR2)

IS

l_log_module                    VARCHAR2(240);

Line: 412


  l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 416


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

Line: 421


DELETE FROM xla_analytical_hdrs_tl
WHERE analytical_criterion_code        = x_analytical_criterion_code
  AND analytical_criterion_type_code   = x_analytical_criterion_type_co
  AND amb_context_code                 = x_amb_context_code;

Line: 431


DELETE FROM xla_analytical_hdrs_b
WHERE analytical_criterion_code        = x_analytical_criterion_code
  AND analytical_criterion_type_code   = x_analytical_criterion_type_co
  AND amb_context_code                 = x_amb_context_code;

Line: 443


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

Line: 447


END delete_row;

Line: 471


DELETE FROM xla_analytical_hdrs_tl T
WHERE  NOT EXISTS
      (SELECT NULL
       FROM   xla_analytical_hdrs_b              b
       WHERE  b.analytical_criterion_code        = t.analytical_criterion_code
         AND  b.analytical_criterion_type_code   = t.analytical_criterion_type_code
         AND  b.amb_context_code                 = t.amb_context_code);

Line: 479


UPDATE xla_analytical_hdrs_tl   t
SET   (name
      ,description)
   = (SELECT b.name
            ,b.description
      FROM   xla_analytical_hdrs_tl             b
      WHERE  b.analytical_criterion_code        = t.analytical_criterion_code
        AND  b.analytical_criterion_type_code   = t.analytical_criterion_type_code
        AND  b.amb_context_code                 = t.amb_context_code
        AND  b.language                         = t.source_lang)
WHERE (t.analytical_criterion_code
      ,t.analytical_criterion_type_code
      ,t.amb_context_code
      ,t.language)
    IN (SELECT subt.analytical_criterion_code
              ,subt.analytical_criterion_type_code
              ,subt.amb_context_code
              ,subt.language
        FROM   xla_analytical_hdrs_tl                 subb
              ,xla_analytical_hdrs_tl                 subt
        WHERE  subb.analytical_criterion_code        = subt.analytical_criterion_code
         AND  subb.analytical_criterion_type_code    = subt.analytical_criterion_type_code
         AND  subb.amb_context_code                  = subt.amb_context_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: 512


INSERT INTO xla_analytical_hdrs_tl
(analytical_criterion_code
,analytical_criterion_type_code
,amb_context_code
,name
,description
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,language
,source_lang)
SELECT   /*+ ORDERED */
       b.analytical_criterion_code
      ,b.analytical_criterion_type_code
      ,b.amb_context_code
      ,b.name
      ,b.description
      ,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_analytical_hdrs_tl           b
      ,fnd_languages                    l
WHERE  l.installed_flag                IN ('I', 'B')
  AND  b.language                       = userenv('LANG')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_analytical_hdrs_tl             t
       WHERE  t.analytical_criterion_code        = b.analytical_criterion_code
         AND  t.analytical_criterion_type_code   = b.analytical_criterion_type_code
         AND  t.amb_context_code                 = b.amb_context_code
         AND  t.language                         = l.language_code);

Line: 571


  ,p_last_update_date                 IN VARCHAR2
  ,p_custom_mode                      IN VARCHAR2)
IS
  l_rowid                 ROWID;

Line: 577


  f_ludate                DATE;        -- entity update date in file

Line: 579


  db_ludate               DATE;        -- entity update date in db

Line: 597


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

Line: 600


    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_analytical_hdrs_tl
     WHERE amb_context_code                = p_amb_context_code
       AND analytical_criterion_type_code  = p_analytical_criterion_type_co
       AND analytical_criterion_code       = p_analytical_criterion_code
       AND language                        = userenv('LANG');

Line: 610


      UPDATE xla_analytical_hdrs_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 amb_context_code                = p_amb_context_code
         AND analytical_criterion_type_code  = p_analytical_criterion_type_co
         AND analytical_criterion_code       = p_analytical_criterion_code;