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

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

Line: 17


|    05-Apr-05  eklau   Added new column mpa_option_code to insert and  |
|                       update procedures.                              |
+======================================================================*/

--=============================================================================
--               *********** Local Trace Routine **********
--=============================================================================
C_LEVEL_STATEMENT     CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line: 63


|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_transaction_coa_id               IN NUMBER
  ,x_accounting_entry_type_code       IN VARCHAR2
  ,x_natural_side_code                IN VARCHAR2
  ,x_gl_transfer_mode_code            IN VARCHAR2
  ,x_switch_side_flag                 IN VARCHAR2
  ,x_gain_or_loss_flag                IN VARCHAR2
  ,x_merge_duplicate_code             IN VARCHAR2
  ,x_enabled_flag                     IN VARCHAR2
  ,x_accounting_class_code            IN VARCHAR2
  ,x_rounding_class_code              IN VARCHAR2
  ,x_business_method_code             IN VARCHAR2
  ,x_business_class_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
  ,x_mpa_option_code                  IN VARCHAR2
  ,x_encumbrance_type_id              IN NUMBER)

IS

CURSOR c IS
SELECT rowid
FROM   xla_acct_line_types_b
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  entity_code                      = x_entity_code
  AND  event_class_code                 = x_event_class_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code
;

Line: 112


  l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 116


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

Line: 121


INSERT INTO xla_acct_line_types_b
(creation_date
,created_by
,amb_context_code
,application_id
,entity_code
,event_class_code
,accounting_line_type_code
,accounting_line_code
,transaction_coa_id
,accounting_entry_type_code
,natural_side_code
,gl_transfer_mode_code
,switch_side_flag
,gain_or_loss_flag
,merge_duplicate_code
,enabled_flag
,accounting_class_code
,rounding_class_code
,business_method_code
,business_class_code
,last_update_date
,last_updated_by
,last_update_login
,mpa_option_code
,encumbrance_type_id)
VALUES
(x_creation_date
,x_created_by
,x_amb_context_code
,x_application_id
,x_entity_code
,x_event_class_code
,x_accounting_line_type_code
,x_accounting_line_code
,x_transaction_coa_id
,x_accounting_entry_type_code
,x_natural_side_code
,x_gl_transfer_mode_code
,x_switch_side_flag
,x_gain_or_loss_flag
,x_merge_duplicate_code
,x_enabled_flag
,x_accounting_class_code
,x_rounding_class_code
,x_business_method_code
,x_business_class_code
,x_last_update_date
,x_last_updated_by
,x_last_update_login
,x_mpa_option_code
,x_encumbrance_type_id)
;

Line: 175


INSERT INTO xla_acct_line_types_tl
(amb_context_code
,application_id
,entity_code
,event_class_code
,accounting_line_type_code
,accounting_line_code
,name
,description
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,language
,source_lang)
SELECT
       x_amb_context_code
      ,x_application_id
      ,x_entity_code
      ,x_event_class_code
      ,x_accounting_line_type_code
      ,x_accounting_line_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_acct_line_types_tl             t
       WHERE  t.application_id                   = x_application_id
         AND  t.amb_context_code                 = x_amb_context_code
         AND  t.entity_code                      = x_entity_code
         AND  t.event_class_code                 = x_event_class_code
         AND  t.accounting_line_type_code        = x_accounting_line_type_code
         AND  t.accounting_line_code             = x_accounting_line_code
         AND  t.language                         = l.language_code);

Line: 230


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

Line: 235


END insert_row;

Line: 269


SELECT amb_context_code
      ,transaction_coa_id
      ,accounting_entry_type_code
      ,natural_side_code
      ,gl_transfer_mode_code
      ,switch_side_flag
      ,gain_or_loss_flag
      ,merge_duplicate_code
      ,enabled_flag
      ,accounting_class_code
      ,rounding_class_code
      ,business_method_code
      ,business_class_code
      ,mpa_option_code
      ,encumbrance_type_id
FROM   xla_acct_line_types_b
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  entity_code                      = x_entity_code
  AND  event_class_code                 = x_event_class_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code
FOR UPDATE OF application_id NOWAIT;

Line: 296


SELECT amb_context_code
      ,name
      ,description
      ,DECODE(language     , USERENV('LANG'), 'Y', 'N') baselang
FROM   xla_acct_line_types_tl
WHERE  application_id                   = X_application_id
  AND  amb_context_code                 = X_amb_context_code
  AND  entity_code                      = X_entity_code
  AND  event_class_code                 = X_event_class_code
  AND  accounting_line_type_code        = X_accounting_line_type_code
  AND  accounting_line_code             = X_accounting_line_code
  AND  USERENV('LANG')                 IN (language     ,source_lang)
FOR UPDATE OF application_id NOWAIT;

Line: 328


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

Line: 392


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_application_id                   IN NUMBER
 ,x_amb_context_code                 IN VARCHAR2
 ,x_entity_code                      IN VARCHAR2
 ,x_event_class_code                 IN VARCHAR2
 ,x_accounting_line_type_code        IN VARCHAR2
 ,x_accounting_line_code             IN VARCHAR2
 ,x_transaction_coa_id               IN NUMBER
 ,x_accounting_entry_type_code       IN VARCHAR2
 ,x_natural_side_code                IN VARCHAR2
 ,x_gl_transfer_mode_code            IN VARCHAR2
 ,x_switch_side_flag                 IN VARCHAR2
  ,x_gain_or_loss_flag                IN VARCHAR2
 ,x_merge_duplicate_code             IN VARCHAR2
 ,x_enabled_flag                     IN VARCHAR2
 ,x_accounting_class_code            IN VARCHAR2
 ,x_rounding_class_code              IN VARCHAR2
 ,x_business_method_code             IN VARCHAR2
 ,x_business_class_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
 ,x_mpa_option_code                   IN VARCHAR2
 ,x_encumbrance_type_id              IN NUMBER)

IS

l_log_module                    VARCHAR2(240);

Line: 427


  l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 431


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

Line: 436


UPDATE xla_acct_line_types_b
   SET
       last_update_date                 = x_last_update_date
      ,transaction_coa_id               = x_transaction_coa_id
      ,accounting_entry_type_code       = x_accounting_entry_type_code
      ,natural_side_code                = x_natural_side_code
      ,gl_transfer_mode_code            = x_gl_transfer_mode_code
      ,switch_side_flag                 = x_switch_side_flag
      ,gain_or_loss_flag                = x_gain_or_loss_flag
      ,merge_duplicate_code             = x_merge_duplicate_code
      ,enabled_flag                     = x_enabled_flag
      ,accounting_class_code            = x_accounting_class_code
      ,rounding_class_code              = x_rounding_class_code
      ,business_method_code             = x_business_method_code
      ,business_class_code              = x_business_class_code
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
      ,mpa_option_code                  = x_mpa_option_code
      ,encumbrance_type_id              = x_encumbrance_type_id
WHERE  application_id                   = X_application_id
  AND  amb_context_code                 = X_amb_context_code
  AND  entity_code                      = X_entity_code
  AND  event_class_code                 = X_event_class_code
  AND  accounting_line_type_code        = X_accounting_line_type_code
  AND  accounting_line_code             = X_accounting_line_code;

Line: 466


UPDATE xla_acct_line_types_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  application_id                   = X_application_id
  AND  amb_context_code                 = X_amb_context_code
  AND  entity_code                      = X_entity_code
  AND  event_class_code                 = X_event_class_code
  AND  accounting_line_type_code        = X_accounting_line_type_code
  AND  accounting_line_code             = X_accounting_line_code
  AND  USERENV('LANG')                 IN (language, source_lang);

Line: 487


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

Line: 492


END update_row;

Line: 496


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2)

IS

l_log_module                    VARCHAR2(240);

Line: 512


  l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 516


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

Line: 521


DELETE FROM xla_acct_line_types_tl
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND entity_code                      = x_entity_code
  AND event_class_code                 = x_event_class_code
  AND accounting_line_type_code        = x_accounting_line_type_code
  AND accounting_line_code             = x_accounting_line_code;

Line: 534


DELETE FROM xla_acct_line_types_b
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND entity_code                      = x_entity_code
  AND event_class_code                 = x_event_class_code
  AND accounting_line_type_code        = x_accounting_line_type_code
  AND accounting_line_code             = x_accounting_line_code;

Line: 549


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

Line: 554


END delete_row;

Line: 577


DELETE FROM xla_acct_line_types_tl T
WHERE  NOT EXISTS
      (SELECT NULL
       FROM   xla_acct_line_types_b              b
       WHERE  b.application_id                   = t.application_id
         AND  b.amb_context_code                 = t.amb_context_code
         AND  b.entity_code                      = t.entity_code
         AND  b.event_class_code                 = t.event_class_code
         AND  b.accounting_line_type_code        = t.accounting_line_type_code
         AND  b.accounting_line_code             = t.accounting_line_code);

Line: 588


UPDATE xla_acct_line_types_tl   t
SET   (name
      ,description)
   = (SELECT b.name
            ,b.description
      FROM   xla_acct_line_types_tl             b
      WHERE  b.application_id                   = t.application_id
        AND  b.amb_context_code                 = t.amb_context_code
        AND  b.entity_code                      = t.entity_code
        AND  b.event_class_code                 = t.event_class_code
        AND  b.accounting_line_type_code        = t.accounting_line_type_code
        AND  b.accounting_line_code             = t.accounting_line_code
        AND  b.language                         = t.source_lang)
WHERE (t.application_id
      ,t.amb_context_code
      ,t.entity_code
      ,t.event_class_code
      ,t.accounting_line_type_code
      ,t.accounting_line_code
      ,t.language)
    IN (SELECT subt.application_id
              ,subt.amb_context_code
              ,subt.entity_code
              ,subt.event_class_code
              ,subt.accounting_line_type_code
              ,subt.accounting_line_code
              ,subt.language
        FROM   xla_acct_line_types_tl                 subb
              ,xla_acct_line_types_tl                 subt
        WHERE  subb.application_id                   = subt.application_id
         AND  subb.amb_context_code                  = subt.amb_context_code
         AND  subb.entity_code                       = subt.entity_code
         AND  subb.event_class_code                  = subt.event_class_code
         AND  subb.accounting_line_type_code         = subt.accounting_line_type_code
         AND  subb.accounting_line_code              = subt.accounting_line_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: 633


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

Line: 703


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


  f_ludate                DATE;        -- entity update date in file

Line: 717


  db_ludate               DATE;        -- entity update date in db

Line: 735


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

Line: 742


    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_acct_line_types_tl
     WHERE application_id             = l_application_id
       AND amb_context_code           = p_amb_context_code
       AND event_class_code           = p_event_class_code
       AND accounting_line_type_code  = p_accounting_line_type_code
       AND accounting_line_code       = p_accounting_line_code
       AND language                   = userenv('LANG');

Line: 754


      UPDATE xla_acct_line_types_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 accounting_line_type_code  = p_accounting_line_type_code
         AND accounting_line_code       = p_accounting_line_code;