APPS.XLA_JLT_ACCT_ATTRS_F_PKG SQL Statements

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

Line: 23

|  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_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_accounting_attribute_code        IN VARCHAR2
  ,x_source_application_id            IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      IN VARCHAR2
  ,x_event_class_default_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_jlt_acct_attrs
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code
  AND  accounting_attribute_code        = x_accounting_attribute_code
;

Line: 58

xla_utility_pkg.trace('> .insert_row'                    ,20);

Line: 60

INSERT INTO xla_jlt_acct_attrs
(creation_date
,created_by
,application_id
,amb_context_code
,event_class_code
,accounting_line_type_code
,accounting_line_code
,accounting_attribute_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_amb_context_code
,x_event_class_code
,x_accounting_line_type_code
,x_accounting_line_code
,x_accounting_attribute_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: 101

xla_utility_pkg.trace('< .insert_row'                    ,20);

Line: 102

END insert_row;

Line: 125

SELECT application_id
      ,amb_context_code
      ,event_class_code
      ,accounting_line_type_code
      ,accounting_line_code
      ,accounting_attribute_code
      ,source_application_id
      ,source_type_code
      ,source_code
      ,event_class_default_flag
FROM   xla_jlt_acct_attrs
WHERE  application_id                   = x_application_id
  AND  amb_context_code                 = x_amb_context_code
  AND  event_class_code                 = x_event_class_code
  AND  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code
  AND  accounting_attribute_code        = x_accounting_attribute_code
FOR UPDATE OF application_id NOWAIT;

Line: 154

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

Line: 190

|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_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_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_accounting_attribute_code        IN VARCHAR2
  ,x_source_application_id            IN NUMBER
  ,x_source_type_code                 IN VARCHAR2
  ,x_source_code                      IN VARCHAR2
  ,x_event_class_default_flag         IN VARCHAR2
  ,x_last_update_date                 IN DATE
  ,x_last_updated_by                  IN NUMBER
  ,x_last_update_login                IN NUMBER)
IS

BEGIN
xla_utility_pkg.trace('> .update_row'                    ,20);

Line: 212

UPDATE xla_jlt_acct_attrs
   SET
       last_update_date                 = x_last_update_date
      ,source_application_id            = x_source_application_id
      ,source_type_code                 = x_source_type_code
      ,source_code                      = x_source_code
      ,event_class_default_flag         = x_event_class_default_flag
      ,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  accounting_line_type_code        = x_accounting_line_type_code
  AND  accounting_line_code             = x_accounting_line_code
  AND  accounting_attribute_code           = x_accounting_attribute_code;

Line: 232

xla_utility_pkg.trace('< .update_row'                    ,20);

Line: 233

END update_row;

Line: 237

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

IS

BEGIN
xla_utility_pkg.trace('> .delete_row'                    ,20);

Line: 252

DELETE FROM xla_jlt_acct_attrs
WHERE application_id                   = x_application_id
  AND amb_context_code                 = x_amb_context_code
  AND event_class_code                 = x_event_class_code
  AND accounting_line_type_code        = x_accounting_line_type_code
  AND accounting_line_code             = x_accounting_line_code
  AND accounting_attribute_code        = x_accounting_attribute_code;

Line: 264

xla_utility_pkg.trace('< .delete_row'                    ,20);

Line: 265

END delete_row;