APPS.XLA_ACCTG_METHODS_PKG SQL Statements

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

Line: 23

| delete_method_details                                                 |
|                                                                       |
| Deletes all details of the accounting method                          |
|                                                                       |
+======================================================================*/

PROCEDURE delete_method_details
  (p_accounting_method_type_code           IN VARCHAR2
  ,p_accounting_method_code                IN VARCHAR2)
IS

BEGIN

   xla_utility_pkg.trace('> xla_acctg_methods_pkg.delete_method_details'   , 10);

Line: 41

   DELETE
     FROM xla_acctg_method_rules
    WHERE accounting_method_type_code    = p_accounting_method_type_code
      AND accounting_method_code         = p_accounting_method_code;

Line: 46

   xla_utility_pkg.trace('< xla_acctg_methods_pkg.delete_method_details'    , 10);

Line: 53

        (p_location   => 'xla_acctg_methods_pkg.delete_method_details');

Line: 55

END delete_method_details;

Line: 75

   l_last_update_date                DATE;

Line: 77

   l_last_update_login               INTEGER;

Line: 78

   l_last_updated_by                 INTEGER;

Line: 84

   SELECT application_id, amb_context_code, product_rule_type_code, product_rule_code,
          start_date_active, end_date_active
     FROM xla_acctg_method_rules
    WHERE accounting_method_type_code    = p_old_accting_meth_type_code
      AND accounting_method_code         = p_old_accting_meth_code;

Line: 102

   l_last_update_date                := sysdate;

Line: 104

   l_last_update_login               := xla_environment_pkg.g_login_id;

Line: 105

   l_last_updated_by                 := xla_environment_pkg.g_usr_id;

Line: 112

            SELECT xla_acctg_method_rules_s.nextval
              INTO l_acctg_method_rule_id
              FROM DUAL;

Line: 116

            INSERT INTO xla_acctg_method_rules
              (acctg_method_rule_id
              ,accounting_method_type_code
              ,accounting_method_code
              ,application_id
              ,amb_context_code
              ,product_rule_type_code
              ,product_rule_code
              ,start_date_active
              ,end_date_active
              ,creation_date
              ,created_by
              ,last_update_date
              ,last_updated_by
              ,last_update_login)
            VALUES
              (l_acctg_method_rule_id
              ,p_new_accting_meth_type_code
              ,p_new_accting_meth_code
              ,l_meth_rule.application_id
              ,l_meth_rule.amb_context_code
              ,l_meth_rule.product_rule_type_code
              ,l_meth_rule.product_rule_code
              ,l_meth_rule.start_date_active
              ,l_meth_rule.end_date_active
              ,l_creation_date
              ,l_created_by
              ,l_last_update_date
              ,l_last_updated_by
              ,l_last_update_login);

Line: 191

   SELECT name ledger_name
     FROM xla_gl_ledgers_v
    WHERE sla_accounting_method_type         = p_accounting_method_type_code
      AND sla_accounting_method_code         = p_accounting_method_code;

Line: 204

   IF p_event in ('DELETE','UPDATE','DISABLE') THEN
      OPEN c_assignment_exist;