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_LINE_DEFN_JLT_ASSGNS_F_PVT 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_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_event_type_code                  IN VARCHAR2
  ,x_line_definition_owner_code       IN VARCHAR2
  ,x_line_definition_code             IN VARCHAR2
  ,x_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_inherit_desc_flag                IN VARCHAR2
  ,x_description_type_code            IN VARCHAR2
  ,x_description_code                 IN VARCHAR2
  ,x_active_flag                      IN VARCHAR2
  ,x_mpa_header_desc_code             IN VARCHAR2
  ,x_mpa_header_desc_type_code        IN VARCHAR2
  ,x_mpa_num_je_code                  IN VARCHAR2
  ,x_mpa_gl_dates_code                IN VARCHAR2
  ,x_mpa_proration_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_line_defn_jlt_assgns
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_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: 102


INSERT INTO xla_line_defn_jlt_assgns
(creation_date
,created_by
,application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,active_flag
,inherit_desc_flag
,description_type_code
,description_code
,object_version_number
,mpa_header_desc_code
,mpa_header_desc_type_code
,mpa_num_je_code
,mpa_gl_dates_code
,mpa_proration_code
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_application_id
,x_amb_context_code
,x_event_class_code
,x_event_type_code
,x_line_definition_owner_code
,x_line_definition_code
,x_accounting_line_type_code
,x_accounting_line_code
,x_active_flag
,x_inherit_desc_flag
,x_description_type_code
,x_description_code
,1
,x_mpa_header_desc_code
,x_mpa_header_desc_type_code
,x_mpa_num_je_code
,x_mpa_gl_dates_code
,x_mpa_proration_code
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
;

Line: 162


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

Line: 167


END insert_row;

Line: 196


SELECT active_flag
      ,inherit_desc_flag
      ,description_type_code
      ,description_code
      ,mpa_header_desc_code
      ,mpa_header_desc_type_code
      ,mpa_num_je_code
      ,mpa_gl_dates_code
      ,mpa_proration_code
FROM   xla_line_defn_jlt_assgns
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_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: 236


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

Line: 281


|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
 (x_application_id                   IN NUMBER
 ,x_amb_context_code                 IN VARCHAR2
 ,x_event_class_code                 IN VARCHAR2
 ,x_event_type_code                  IN VARCHAR2
 ,x_line_definition_owner_code       IN VARCHAR2
 ,x_line_definition_code             IN VARCHAR2
 ,x_accounting_line_type_code        IN VARCHAR2
 ,x_accounting_line_code             IN VARCHAR2
 ,x_inherit_desc_flag                IN VARCHAR2
 ,x_description_type_code            IN VARCHAR2
 ,x_description_code                 IN VARCHAR2
 ,x_active_flag                      IN VARCHAR2
 ,x_mpa_header_desc_code             IN VARCHAR2
 ,x_mpa_header_desc_type_code        IN VARCHAR2
 ,x_mpa_num_je_code                  IN VARCHAR2
 ,x_mpa_gl_dates_code                IN VARCHAR2
 ,x_mpa_proration_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: 311


  l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 315


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

Line: 320


UPDATE xla_line_defn_jlt_assgns
   SET
       last_update_date                 = x_last_update_date
      ,description_type_code            = x_description_type_code
      ,description_code                 = x_description_code
      ,active_flag                      = x_active_flag
      ,inherit_desc_flag                = x_inherit_desc_flag
      ,object_version_number            = object_version_number+1
      ,mpa_header_desc_code             = x_mpa_header_desc_code
      ,mpa_header_desc_type_code        = x_mpa_header_desc_type_code
      ,mpa_num_je_code                  = x_mpa_num_je_code
      ,mpa_gl_dates_code                = x_mpa_gl_dates_code
      ,mpa_proration_code               = x_mpa_proration_code
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  event_type_code                  = x_event_type_code
  AND  line_definition_owner_code       = x_line_definition_owner_code
  AND  line_definition_code             = x_line_definition_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code;

Line: 349


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

Line: 354


END update_row;

Line: 358


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

IS

l_log_module       VARCHAR2(240);

Line: 377


  l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 381


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

Line: 386


DELETE FROM xla_line_defn_jlt_assgns
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND event_class_code                 = x_event_class_code
  AND event_type_code                  = x_event_type_code
  AND line_definition_owner_code       = x_line_definition_owner_code
  AND line_definition_code             = x_line_definition_code
  AND accounting_line_type_code        = x_accounting_line_type_code
  AND accounting_line_code             = x_accounting_line_code;

Line: 401


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

Line: 406


END delete_row;