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.

[Home] [Help]

APPS.XLA_TAB_ATS_F_PKG SQL Statements

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

Line: 60


|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_account_type_code                IN VARCHAR2
  ,x_source_application_id            IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      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_tab_acct_type_srcs
WHERE  application_id         = x_application_id
  AND  account_type_code      = x_account_type_code
  AND  source_application_id  = x_source_application_id
  AND  source_type_code       = x_source_type_code
  AND  source_code            = x_source_code;

Line: 91


  l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 95


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

Line: 100


INSERT INTO xla_tab_acct_type_srcs
(creation_date
,created_by
,application_id
,account_type_code
,source_application_id
,source_type_code
,source_code
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_application_id
,x_account_type_code
,x_source_application_id
,x_source_type_code
,x_source_code
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;

Line: 133


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

Line: 138


END insert_row;

Line: 177


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
  (x_application_id                   IN NUMBER
  ,x_account_type_code                IN VARCHAR2
  ,x_source_application_id            IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      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: 195


  l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 199


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

Line: 204


UPDATE xla_tab_acct_type_srcs
   SET
      last_updated_by         = x_last_updated_by
      ,last_update_login      = x_last_update_login
WHERE  application_id         = x_application_id
  AND  account_type_code      = x_account_type_code
  AND  source_application_id  = x_source_application_id
  AND  source_type_code       = x_source_type_code
  AND  source_code            = x_source_code;

Line: 219


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

Line: 224


END update_row;

Line: 227


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_application_id                   IN NUMBER
  ,x_account_type_code                IN VARCHAR2
  ,x_source_application_id            IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      IN VARCHAR2)

IS

l_log_module                    VARCHAR2(240);

Line: 244


  l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 248


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

Line: 253


DELETE FROM xla_tab_acct_type_srcs
WHERE  application_id         = x_application_id
  AND  account_type_code      = x_account_type_code
  AND  source_application_id  = x_source_application_id
  AND  source_type_code       = x_source_type_code
  AND  source_code            = x_source_code;

Line: 265


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

Line: 270


END delete_row;

Line: 284


  ,p_last_update_date                 IN VARCHAR2)

IS

  CURSOR c_app_id IS
  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = p_application_short_name;

Line: 294


  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = p_source_app_short_name;

Line: 303


  f_ludate                DATE;        -- entity update date in file

Line: 305


  db_ludate               DATE;        -- entity update date in db

Line: 324


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

Line: 336


    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_tab_acct_type_srcs
     WHERE  application_id         = l_application_id
       AND  account_type_code      = p_account_type_code
       AND  source_application_id  = l_source_app_id
       AND  source_type_code       = p_source_type_code
       AND  source_code            = p_source_code;

Line: 346


      xla_tab_ats_f_pkg.update_row
          (x_application_id                => l_application_id
          ,x_account_type_code             => p_account_type_code
          ,x_source_application_id         => l_source_app_id
          ,x_source_type_code              => p_source_type_code
          ,x_source_code                   => p_source_code
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);

Line: 360


      xla_tab_ats_f_pkg.insert_row
          (x_rowid                         => l_rowid
          ,x_application_id                => l_application_id
          ,x_account_type_code             => p_account_type_code
          ,x_source_application_id         => l_source_app_id
          ,x_source_type_code              => p_source_type_code
          ,x_source_code                   => p_source_code
          ,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);