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_SOURCE_PARAMS_F_PKG 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_source_param_id                  IN NUMBER
  ,x_application_id                   IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      IN VARCHAR2
  ,x_user_sequence                    IN NUMBER
  ,x_parameter_type_code              IN VARCHAR2
  ,x_constant_value                   IN VARCHAR2
  ,x_ref_source_application_id        IN NUMBER
  ,x_ref_source_type_code             IN VARCHAR2
  ,x_ref_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_source_params
WHERE  source_param_id       = x_source_param_id
;

Line: 79


    l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 83


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

Line: 89


INSERT INTO xla_source_params
(creation_date
,created_by
,source_param_id
,application_id
,source_type_code
,source_code
,user_sequence
,parameter_type_code
,constant_value
,ref_source_application_id
,ref_source_type_code
,ref_source_code
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_source_param_id
,x_application_id
,x_source_type_code
,x_source_code
,x_user_sequence
,x_parameter_type_code
,x_constant_value
,x_ref_source_application_id
,x_ref_source_type_code
,x_ref_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: 160


SELECT application_id
      ,source_type_code
      ,source_code
      ,user_sequence
      ,parameter_type_code
      ,constant_value
      ,ref_source_application_id
      ,ref_source_type_code
      ,ref_source_code
FROM   xla_source_params
WHERE  source_param_id                = x_source_param_id
FOR UPDATE OF application_id NOWAIT;

Line: 193


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

Line: 230


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_source_param_id                  IN NUMBER
 ,x_application_id                   IN NUMBER
 ,x_source_type_code                 IN VARCHAR2
 ,x_source_code                      IN VARCHAR2
 ,x_user_sequence                    IN NUMBER
 ,x_parameter_type_code              IN VARCHAR2
 ,x_constant_value                   IN VARCHAR2
 ,x_ref_source_application_id        IN NUMBER
 ,x_ref_source_type_code             IN VARCHAR2
 ,x_ref_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: 253


    l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 257


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

Line: 262


UPDATE xla_source_params
   SET
       last_update_date             = x_last_update_date
      ,application_id               = x_application_id
      ,source_type_code             = x_source_type_code
      ,source_code                  = x_source_code
      ,user_sequence                = x_user_sequence
      ,parameter_type_code          = x_parameter_type_code
      ,constant_value               = x_constant_value
      ,ref_source_application_id    = x_ref_source_application_id
      ,ref_source_type_code         = x_ref_source_type_code
      ,ref_source_code              = x_ref_source_code
      ,last_updated_by              = x_last_updated_by
      ,last_update_login            = x_last_update_login
WHERE  source_param_id              = x_source_param_id;

Line: 283


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

Line: 288


END update_row;

Line: 292


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_source_param_id                   IN NUMBER)
IS
  l_log_module            VARCHAR2(240);

Line: 302


    l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 306


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

Line: 311


DELETE FROM xla_source_params
WHERE source_param_id             = x_source_param_id;

Line: 319


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

Line: 324


END delete_row;

Line: 343


,p_last_update_date                   IN VARCHAR2)
IS
  CURSOR c_app_id(l_app_id VARCHAR2) IS
  SELECT application_id
  FROM   fnd_application
  WHERE  application_short_name          = l_app_id;

Line: 356


  f_ludate                DATE;        -- entity update date in file

Line: 358


  db_ludate               DATE;        -- entity update date in db

Line: 376


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

Line: 388


    SELECT source_param_id, last_updated_by, last_update_date
      INTO l_source_param_id, db_luby, db_ludate
      FROM xla_source_params
     WHERE application_id       = l_application_id
       AND source_type_code     = p_source_type_code
       AND source_code          = p_source_code
       AND user_sequence        = p_user_sequence;

Line: 397


      xla_source_params_f_pkg.update_row
          (x_source_param_id               => l_source_param_id
          ,x_application_id                => l_application_id
          ,x_source_type_code              => p_source_type_code
          ,x_source_code                   => p_source_code
          ,x_user_sequence                 => p_user_sequence
          ,x_parameter_type_code           => p_parameter_type_code
          ,x_constant_value                => p_constant_value
          ,x_ref_source_application_id     => l_ref_source_app_id
          ,x_ref_source_type_code          => p_ref_source_type_code
          ,x_ref_source_code               => p_ref_source_code
          ,x_last_update_date              => f_ludate
          ,x_last_updated_by               => f_luby
          ,x_last_update_login             => 0);

Line: 416


      SELECT xla_source_params_s.nextval INTO l_source_param_id
        FROM dual;

Line: 419


      xla_source_params_f_pkg.insert_row
          (x_rowid                         => l_rowid
          ,x_source_param_id               => l_source_param_id
          ,x_application_id                => l_application_id
          ,x_source_type_code              => p_source_type_code
          ,x_source_code                   => p_source_code
          ,x_user_sequence                 => p_user_sequence
          ,x_parameter_type_code           => p_parameter_type_code
          ,x_constant_value                => p_constant_value
          ,x_ref_source_application_id     => l_ref_source_app_id
          ,x_ref_source_type_code          => p_ref_source_type_code
          ,x_ref_source_code               => p_ref_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);