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

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

Line: 65


|  Procedure insert_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE insert_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_object_name                      IN VARCHAR2
  ,x_reference_object_appl_id         IN NUMBER
  ,x_reference_object_name            IN VARCHAR2
  ,x_linked_to_ref_obj_appl_id        IN NUMBER
  ,x_linked_to_ref_obj_name           IN VARCHAR2
  ,x_join_condition                   IN VARCHAR2
  ,x_always_populated_flag            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_reference_objects
   WHERE  application_id           = x_application_id
     AND  entity_code		          = x_entity_code
     AND  event_class_code		      = x_event_class_code
     AND  object_name		          = x_object_name
     AND  reference_object_appl_id = x_reference_object_appl_id
     AND  reference_object_name    = x_reference_object_name
   ;

Line: 103


     l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 107


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

Line: 112


   INSERT INTO xla_reference_objects
     (creation_date
     ,created_by
     ,application_id
     ,entity_code
     ,event_class_code
     ,object_name
     ,reference_object_appl_id
     ,reference_object_name
     ,linked_to_ref_obj_appl_id
     ,linked_to_ref_obj_name
     ,join_condition
     ,always_populated_flag
     ,last_update_date
     ,last_updated_by
     ,last_update_login)
   VALUES
     (x_creation_date
     ,x_created_by
     ,x_application_id
     ,x_entity_code
     ,x_event_class_code
     ,x_object_name
     ,x_reference_object_appl_id
     ,x_reference_object_name
     ,x_linked_to_ref_obj_appl_id
     ,x_linked_to_ref_obj_name
     ,x_join_condition
     ,x_always_populated_flag
     ,x_last_update_date
     ,x_last_updated_by
     ,x_last_update_login)
   ;

Line: 157


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

Line: 162


END insert_row;

Line: 183


   SELECT application_id
         ,entity_code
         ,event_class_code
         ,object_name
         ,reference_object_appl_id
         ,reference_object_name
         ,linked_to_ref_obj_appl_id
         ,linked_to_ref_obj_name
         ,join_condition
         ,always_populated_flag
   FROM   xla_reference_objects
   WHERE  application_id           = x_application_id
     AND  entity_code		           = x_entity_code
     AND  event_class_code		     = x_event_class_code
     AND  object_name		           = x_object_name
     AND  reference_object_appl_id = x_reference_object_appl_id
     AND  reference_object_name    = x_reference_object_name
   FOR UPDATE OF application_id NOWAIT;

Line: 222


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

Line: 258


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
  (x_application_id                   IN NUMBER
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_object_name                      IN VARCHAR2
  ,x_reference_object_appl_id         IN NUMBER
  ,x_reference_object_name            IN VARCHAR2
  ,x_linked_to_ref_obj_appl_id        IN NUMBER    DEFAULT NULL
  ,x_linked_to_ref_obj_name           IN VARCHAR2  DEFAULT NULL
  ,x_join_condition                   IN VARCHAR2
  ,x_always_populated_flag            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: 282


     l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 286


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

Line: 291


   UPDATE xla_reference_objects
   SET
          last_update_date               = x_last_update_date
         ,linked_to_ref_obj_appl_id      = nvl(x_linked_to_ref_obj_appl_id,linked_to_ref_obj_appl_id)
         ,linked_to_ref_obj_name         = nvl(x_linked_to_ref_obj_name,linked_to_ref_obj_name)
         ,join_condition                 = x_join_condition
         ,always_populated_flag          = x_always_populated_flag
         ,last_updated_by                = x_last_updated_by
         ,last_update_login              = x_last_update_login
   WHERE  application_id                 = x_application_id
     AND  entity_code		           = x_entity_code
     AND  event_class_code		     = x_event_class_code
     AND  object_name		           = x_object_name
     AND  reference_object_appl_id       = x_reference_object_appl_id
     AND  reference_object_name          = x_reference_object_name
   ;

Line: 313


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

Line: 318


END update_row;

Line: 322


|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_application_id                   IN NUMBER
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_object_name                      IN VARCHAR2
  ,x_reference_object_appl_id         IN NUMBER
  ,x_reference_object_name            IN VARCHAR2)

IS

   l_log_module            VARCHAR2(240);

Line: 339


     l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 343


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

Line: 348


   DELETE
     FROM xla_reference_objects
   WHERE  application_id                 = x_application_id
     AND  entity_code		                = x_entity_code
     AND  event_class_code		            = x_event_class_code
     AND  object_name	          	      = x_object_name
     AND  reference_object_appl_id       = x_reference_object_appl_id
     AND  reference_object_name          = x_reference_object_name
   ;

Line: 363


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

Line: 368


END delete_row;

Line: 388


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

Line: 399


   f_ludate                DATE;        -- entity update date in file

Line: 401


   db_ludate               DATE;        -- entity update date in db

Line: 419


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

Line: 427


      SELECT last_updated_by, last_update_date
      INTO   db_luby, db_ludate
      FROM   xla_reference_objects
      WHERE  application_id            = l_application_id
        AND  entity_code               = p_entity_code
        AND  event_class_code          = p_event_class_code
        AND  object_name               = p_object_name
        AND  reference_object_appl_id  = p_reference_object_appl_id
        AND  reference_object_name     = p_reference_object_name;

Line: 438


        xla_reference_objects_f_pkg.update_row
            (x_application_id                => l_application_id
            ,x_entity_code                   => p_entity_code
            ,x_event_class_code              => p_event_class_code
            ,x_object_name                   => p_object_name
            ,x_reference_object_appl_id      => p_reference_object_appl_id
            ,x_reference_object_name         => p_reference_object_name
            ,x_linked_to_ref_obj_appl_id     => p_linked_to_ref_obj_appl_id
            ,x_linked_to_ref_obj_name        => p_linked_to_ref_obj_name
            ,x_join_condition                => p_join_condition
            ,x_always_populated_flag         => p_always_populated_flag
            ,x_last_update_date              => f_ludate
            ,x_last_updated_by               => f_luby
            ,x_last_update_login             => 0);

Line: 457


       xla_reference_objects_f_pkg.insert_row
           (x_rowid                         => l_rowid
           ,x_application_id                => l_application_id
           ,x_entity_code                   => p_entity_code
           ,x_event_class_code              => p_event_class_code
           ,x_object_name                   => p_object_name
           ,x_reference_object_appl_id      => p_reference_object_appl_id
           ,x_reference_object_name         => p_reference_object_name
           ,x_linked_to_ref_obj_appl_id      => p_linked_to_ref_obj_appl_id
           ,x_linked_to_ref_obj_name         => p_linked_to_ref_obj_name
           ,x_join_condition                => p_join_condition
           ,x_always_populated_flag         => p_always_populated_flag
           ,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);