DBA Data[Home] [Help]

APPS.XLA_POST_ACCT_PROGS_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_program_code                     IN VARCHAR2
  ,x_program_owner_code               IN VARCHAR2
  ,x_application_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_post_acct_progs_b
WHERE  program_code                      = x_program_code
  AND  program_owner_code                 = x_program_owner_code
;
Line: 93

    l_log_module := C_DEFAULT_MODULE||'.insert_row';
Line: 97

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

INSERT INTO xla_post_acct_progs_b
(creation_date
,created_by
,program_code
,program_owner_code
,application_id
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_program_code
,x_program_owner_code
,x_application_id
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;
Line: 123

INSERT INTO xla_post_acct_progs_tl
(creation_date
,program_code
,program_owner_code
,name
,description
,last_update_date
,last_updated_by
,last_update_login
,created_by
,language
,source_lang)
SELECT
       x_creation_date
      ,x_program_code
      ,x_program_owner_code
      ,x_name
      ,x_description
      ,x_last_update_date
      ,x_last_updated_by
      ,x_last_update_login
      ,x_created_by
      ,l.language_code
      ,USERENV('LANG')
FROM   fnd_languages l
WHERE  l.installed_flag                 IN ('I', 'B')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_post_acct_progs_tl               t
       WHERE  t.program_code                      = x_program_code
         AND  t.program_owner_code                 = x_program_owner_code
         AND  t.language                         = l.language_code);
Line: 166

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

END insert_row;
Line: 188

SELECT application_id
FROM   xla_post_acct_progs_b
WHERE  program_code                      = x_program_code
  AND  program_owner_code                 = x_program_owner_code
FOR UPDATE OF application_id NOWAIT;
Line: 197

SELECT source_lang
      ,name
      ,description
      ,DECODE(language     , USERENV('LANG'), 'Y', 'N') baselang
FROM   xla_post_acct_progs_tl
WHERE  program_code                      = X_program_code
  AND  program_owner_code                 = X_program_owner_code
  AND  USERENV('LANG')                 IN (language     ,source_lang)
FOR UPDATE OF program_code NOWAIT;
Line: 225

   fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 265

|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_program_code                     IN VARCHAR2
  ,x_program_owner_code               IN VARCHAR2
  ,x_application_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: 284

    l_log_module := C_DEFAULT_MODULE||'.update_row';
Line: 288

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

UPDATE xla_post_acct_progs_b
   SET
       last_update_date                 = x_last_update_date
      ,application_id                     = x_application_id
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  program_code                      = X_program_code
  AND  program_owner_code                 = X_program_owner_code;
Line: 306

UPDATE xla_post_acct_progs_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  program_code                      = X_program_code
  AND  program_owner_code                 = X_program_owner_code
  AND  USERENV('LANG')                 IN (language, source_lang);
Line: 323

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

END update_row;
Line: 332

|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_program_code                      IN VARCHAR2
  ,x_program_owner_code                 IN VARCHAR2)

IS

  l_log_module            VARCHAR2(240);
Line: 345

    l_log_module := C_DEFAULT_MODULE||'.delete_row';
Line: 349

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

DELETE FROM xla_post_acct_progs_tl
WHERE program_code                      = x_program_code
  AND program_owner_code                 = x_program_owner_code;
Line: 363

DELETE FROM xla_post_acct_progs_b
WHERE program_code                      = x_program_code
  AND program_owner_code                 = x_program_owner_code;
Line: 373

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

END delete_row;
Line: 400

DELETE FROM xla_post_acct_progs_tl T
WHERE  NOT EXISTS
      (SELECT NULL
       FROM   xla_post_acct_progs_b                b
       WHERE  b.program_code                      = t.program_code
         AND  b.program_owner_code                 = t.program_owner_code);
Line: 407

UPDATE xla_post_acct_progs_tl   t
SET   (name
      ,description)
   = (SELECT b.name
            ,b.description
      FROM   xla_post_acct_progs_tl               b
      WHERE  b.program_code                      = t.program_code
        AND  b.program_owner_code                 = t.program_owner_code
        AND  b.language                         = t.source_lang)
WHERE (t.program_code
      ,t.program_owner_code
      ,t.language)
    IN (SELECT subt.program_code
              ,subt.program_owner_code
              ,subt.language
        FROM   xla_post_acct_progs_tl                   subb
              ,xla_post_acct_progs_tl                   subt
        WHERE  subb.program_code                       = subt.program_code
         AND  subb.program_owner_code                  = subt.program_owner_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: 436

INSERT INTO xla_post_acct_progs_tl
(creation_date
,program_code
,program_owner_code
,name
,description
,last_update_date
,last_updated_by
,last_update_login
,created_by
,language
,source_lang)
SELECT   /*+ ORDERED */
       b.creation_date
      ,b.program_code
      ,b.program_owner_code
      ,b.name
      ,b.description
      ,b.last_update_date
      ,b.last_updated_by
      ,b.last_update_login
      ,b.created_by
      ,l.language_code
      ,b.source_lang
FROM   xla_post_acct_progs_tl             b
      ,fnd_languages                    l
WHERE  l.installed_flag                IN ('I', 'B')
  AND  b.language                       = userenv('LANG')
  AND  NOT EXISTS
      (SELECT NULL
       FROM   xla_post_acct_progs_tl               t
       WHERE  t.program_code                      = b.program_code
         AND  t.program_owner_code                = b.program_owner_code
         AND  t.language                          = l.language_code);
Line: 490

,p_last_update_date                   IN VARCHAR2
,p_name                               IN VARCHAR2
,p_description                        IN VARCHAR2)
IS
  CURSOR c_app_id IS
  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = p_application_short_name;
Line: 503

  f_ludate                DATE;        -- entity update date in file
Line: 505

  db_ludate               DATE;        -- entity update date in db
Line: 523

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

    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_post_acct_progs_vl
     WHERE program_code         = p_program_code
       AND program_owner_code   = p_program_owner_code;
Line: 538

      xla_post_acct_progs_f_pkg.update_row
          (x_application_id                => l_application_id
          ,x_program_code                  => p_program_code
          ,x_program_owner_code            => p_program_owner_code
          ,x_name                          => p_name
          ,x_description                   => p_description
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);
Line: 552

      xla_post_acct_progs_f_pkg.insert_row
          (x_rowid                         => l_rowid
          ,x_application_id                => l_application_id
          ,x_program_code                  => p_program_code
          ,x_program_owner_code            => p_program_owner_code
          ,x_name                          => p_name
          ,x_description                   => p_description
          ,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: 593

  ,p_last_update_date                 IN VARCHAR2
  ,p_custom_mode                      IN VARCHAR2)
IS

  l_application_id        INTEGER;
Line: 601

  f_ludate                DATE;        -- entity update date in file
Line: 603

  db_ludate               DATE;        -- entity update date in db
Line: 621

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

    SELECT last_updated_by, last_update_date
      INTO db_luby, db_ludate
      FROM xla_post_acct_progs_tl
     WHERE program_code       = p_program_code
       AND program_owner_code = p_program_owner_code
       AND language           = userenv('LANG');
Line: 633

      UPDATE xla_post_acct_progs_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 program_code       = p_program_code
         AND program_owner_code = p_program_owner_code;