APPS.XLA_ACCTG_METHOD_RULES_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_acctg_method_rule_id             IN OUT NOCOPY NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_accounting_method_type_code      IN VARCHAR2
  ,x_accounting_method_code           IN VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_product_rule_type_code           IN VARCHAR2
  ,x_product_rule_code                IN VARCHAR2
  ,x_start_date_active                IN DATE
  ,x_end_date_active                  IN DATE
  ,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_acctg_method_rules
WHERE  acctg_method_rule_id      = x_acctg_method_rule_id;

Line: 50

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

Line: 52

INSERT INTO xla_acctg_method_rules
(creation_date
,created_by
,accounting_method_type_code
,accounting_method_code
,acctg_method_rule_id
,amb_context_code
,application_id
,product_rule_type_code
,product_rule_code
,start_date_active
,end_date_active
,last_update_date
,last_updated_by
,last_update_login)
VALUES
(x_creation_date
,x_created_by
,x_accounting_method_type_code
,x_accounting_method_code
,xla_acctg_method_rules_s.nextval
,x_amb_context_code
,x_application_id
,x_product_rule_type_code
,x_product_rule_code
,x_start_date_active
,x_end_date_active
,x_last_update_date
,x_last_updated_by
,x_last_update_login)
returning acctg_method_rule_id into x_acctg_method_rule_id
;

Line: 94

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

Line: 95

END insert_row;

Line: 117

SELECT accounting_method_type_code
      ,accounting_method_code
      ,amb_context_code
      ,application_id
      ,product_rule_type_code
      ,product_rule_code
      ,start_date_active
      ,end_date_active
FROM   xla_acctg_method_rules
WHERE  acctg_method_rule_id                            = x_acctg_method_rule_id
FOR UPDATE OF accounting_method_type_code NOWAIT;

Line: 139

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

Line: 168

|  Procedure update_row                                                 |
|                                                                       |
+======================================================================*/
PROCEDURE update_row
  (x_rowid                            IN OUT NOCOPY VARCHAR2
  ,x_acctg_method_rule_id             IN NUMBER
  ,x_amb_context_code                 IN VARCHAR2
  ,x_accounting_method_type_code      IN VARCHAR2
  ,x_accounting_method_code           IN VARCHAR2
  ,x_application_id                   IN NUMBER
  ,x_product_rule_type_code           IN VARCHAR2
  ,x_product_rule_code                IN VARCHAR2
  ,x_start_date_active                IN DATE
  ,x_end_date_active                  IN DATE
  ,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: 190

UPDATE xla_acctg_method_rules
   SET
       product_rule_type_code           = x_product_rule_type_code
      ,product_rule_code                = x_product_rule_code
      ,last_update_date                 = x_last_update_date
      ,start_date_active                = x_start_date_active
      ,end_date_active                  = x_end_date_active
      ,last_updated_by                  = x_last_updated_by
      ,last_update_login                = x_last_update_login
WHERE  acctg_method_rule_id             = x_acctg_method_rule_id;

Line: 205

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

Line: 206

END update_row;

Line: 210

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

IS

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

Line: 220

DELETE FROM xla_acctg_method_rules
WHERE  acctg_method_rule_id             = x_acctg_method_rule_id;

Line: 227

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

Line: 228

END delete_row;