APPS.XLA_ANALYTICAL_ASSGNS_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_analytical_assignment_id         IN OUT NOCOPY NUMBER
  ,x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_product_rule_type_code           IN VARCHAR2
  ,x_product_rule_code                IN VARCHAR2
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_event_type_code                  IN VARCHAR2
  ,x_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_anal_criterion_type_code          IN VARCHAR2
  ,x_analytical_criterion_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

l_analytical_assignment_id    number(38);

Line: 50

SELECT rowid
FROM   xla_analytical_assgns
WHERE  analytical_assignment_id                    = x_analytical_assignment_id
;

Line: 56

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

Line: 58

INSERT INTO xla_analytical_assgns
(creation_date
,created_by
,application_id
,amb_context_code
,analytical_assignment_id
,product_rule_type_code
,product_rule_code
,entity_code
,event_class_code
,event_type_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_application_id
,x_amb_context_code
,xla_analytical_assgns_s.nextval
,x_product_rule_type_code
,x_product_rule_code
,x_entity_code
,x_event_class_code
,x_event_type_code
,x_accounting_line_type_code
,x_accounting_line_code
,x_anal_criterion_type_code
,x_analytical_criterion_code
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
returning analytical_assignment_id into x_analytical_assignment_id
;

Line: 106

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

Line: 107

END insert_row;

Line: 132

SELECT application_id
      ,amb_context_code
      ,analytical_assignment_id
      ,product_rule_type_code
      ,product_rule_code
      ,entity_code
      ,event_class_code
      ,event_type_code
      ,accounting_line_type_code
      ,accounting_line_code
      ,analytical_criterion_type_code
      ,analytical_criterion_code
FROM   xla_analytical_assgns
WHERE  analytical_assignment_id                   = x_analytical_assignment_id
FOR UPDATE OF application_id NOWAIT;

Line: 158

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

Line: 192

|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_analytical_assignment_id         IN NUMBER
  ,x_application_id                   IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_product_rule_type_code           IN VARCHAR2
  ,x_product_rule_code                IN VARCHAR2
  ,x_entity_code                      IN VARCHAR2
  ,x_event_class_code                 IN VARCHAR2
  ,x_event_type_code                  IN VARCHAR2
  ,x_accounting_line_type_code        IN VARCHAR2
  ,x_accounting_line_code             IN VARCHAR2
  ,x_anal_criterion_type_code          IN VARCHAR2
  ,x_analytical_criterion_code         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: 217

UPDATE xla_analytical_assgns
   SET
       last_update_date                 = x_last_update_date
      ,analytical_criterion_type_code    = x_anal_criterion_type_code
      ,analytical_criterion_code         = x_analytical_criterion_code
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  analytical_assignment_id         = x_analytical_assignment_id;

Line: 230

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

Line: 231

END update_row;

Line: 235

|  Procedure delete_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE delete_row
  (x_analytical_assignment_id      IN NUMBER)

IS

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

Line: 245

DELETE FROM xla_analytical_assgns
WHERE  analytical_assignment_id         = x_analytical_assignment_id;

Line: 252

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

Line: 253

END delete_row;