APPS.AME_TRANS_TYPE_API SQL Statements

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

Line: 27

   select ame_attributes.attribute_id,
          ame_attributes.attribute_type
     from ame_attributes,
          ame_mandatory_attributes
    where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
      and ame_mandatory_attributes.action_type_id = -1
      and sysdate between ame_attributes.start_date and
            nvl(ame_attributes.end_date - (1/86400), sysdate)
      and sysdate between ame_mandatory_attributes.start_date and
            nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);

Line: 38

    select item_class_id
      from ame_item_classes
     where name = ame_util.headerItemClassName
       and sysdate between start_date and
             nvl(end_date - (1/86400), sysdate);

Line: 115

        ,p_item_id_query           => 'select :transactionId from dual'
        ,p_item_class_order_number => 1
        ,p_item_class_par_mode     => ame_util.serialItems
        ,p_item_class_sublist_mode => ame_util.serialSublists
        ,p_application_id          => l_application_id
        ,p_item_class_id           => l_header_item_class_id
        ,p_object_version_number   => l_ovn_child
        ,p_start_date              => l_start_date_child
        ,p_end_date                => l_end_date_child
        );

Line: 226

procedure update_ame_transaction_type
  (p_validate                    in     boolean  default false
  ,p_language_code               in     varchar2 default hr_api.userenv_lang
  ,p_application_name            in     varchar2 default hr_api.g_varchar2
  ,p_application_id              in     number
  ,p_object_version_number       in out nocopy   number
  ,p_start_date                     out nocopy   date
  ,p_end_date                       out nocopy   date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                      varchar2(72) := g_package||'update_ame_transaction_type';

Line: 248

    savepoint update_ame_transaction_type;

Line: 257

      ame_trans_type_bk2.update_ame_transaction_type_b
        (p_application_name      => p_application_name
        ,p_application_id        => p_application_id
        ,p_object_version_number => p_object_version_number
        );

Line: 264

        hr_api.cannot_find_prog_unit_error(p_module_name => 'update_ame_transaction_type'
                                          ,p_hook_type   => 'BP'
                                          );

Line: 272

                   ,p_datetrack_mode        => hr_api.g_update
                   ,p_application_id        => p_application_id
                   ,p_object_version_number => p_object_version_number
                   ,p_line_item_id_query    => hr_api.g_varchar2
                   ,p_security_group_id     => hr_api.g_number
                   ,p_start_date            => l_start_date
                   ,p_end_date              => l_end_date
                   );*/

Line: 291

      ame_trans_type_bk2.update_ame_transaction_type_a
        (p_application_name      => p_application_name
        ,p_application_id        => p_application_id
        ,p_object_version_number => p_object_version_number
        ,p_start_date            => l_start_date
        ,p_end_date              => l_end_date
        );

Line: 300

        hr_api.cannot_find_prog_unit_error(p_module_name => 'update_ame_transaction_type'
                                          ,p_hook_type   => 'AP'
                                          );

Line: 323

      rollback to update_ame_transaction_type;

Line: 338

      rollback to update_ame_transaction_type;

Line: 349

  end update_ame_transaction_type;

Line: 356

procedure delete_ame_transaction_type
  (p_validate               in     boolean  default false
  ,p_application_id         in     number
  ,p_object_version_number  in out nocopy number
  ,p_start_date                out nocopy date
  ,p_end_date                  out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  cursor getRuleUsageCur is
    select rule_id,
           start_date,
           end_date,
           object_version_number
      from ame_rule_usages
     where item_id = p_application_id
       and ((sysdate between start_date
                         and nvl(end_date - ame_util.oneSecond, sysdate)) or
            (sysdate < start_date and
             start_date < nvl(end_date,start_date + ame_util.oneSecond)));

Line: 378

    select atu.attribute_id,
           atu.object_version_number
      from ame_attribute_usages atu
          ,ame_attributes att
     where application_id = p_application_id
       and att.attribute_id = atu.attribute_id
       and sysdate between atu.start_date and
             nvl(atu.end_date - ame_util.oneSecond, sysdate)
       and sysdate between att.start_date and
             nvl(att.end_date - ame_util.oneSecond, sysdate);

Line: 389

    select item_class_id,
           object_version_number
      from ame_item_class_usages
     where application_id = p_application_id
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 396

    select approval_group_id,
           object_version_number
      from ame_approval_group_config
     where application_id = p_application_id
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 403

    select action_type_id,
           object_version_number
      from ame_action_type_config
     where application_id = p_application_id
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 410

    select variable_name,
           object_version_number
      from ame_config_vars
     where application_id = p_application_id
       and sysdate between start_date and
             nvl(end_date - ame_util.oneSecond, sysdate);

Line: 418

  l_proc                   varchar2(72) := g_package||'delete_ame_transaction_type';

Line: 439

    savepoint delete_ame_transaction_type;

Line: 448

      ame_trans_type_bk3.delete_ame_transaction_type_b
        (p_application_id           => p_application_id
        ,p_object_version_number    => p_object_version_number
        );

Line: 454

        hr_api.cannot_find_prog_unit_error(p_module_name => 'delete_ame_transaction_type'
                                          ,p_hook_type   => 'BP'
                                          );

Line: 469

      ame_rule_api.delete_ame_rule_usage
        (p_validate              => p_validate
        ,p_rule_id               => l_ruleIds(indx)
        ,p_application_id        => p_application_id
        ,p_object_version_number => l_objectVersionNumbers(indx)
        ,p_start_date            => l_ruleStartDates(indx)
        ,p_end_date              => l_ruleEndDates(indx)
        );

Line: 487

      ame_attribute_api.delete_ame_attribute_usage
        (p_validate              => p_validate
        ,p_attribute_id          => l_attributeIds(indx)
        ,p_application_id        => p_application_id
        ,p_object_version_number => l_objectVersionNumbers(indx)
        ,p_start_date            => l_start_date_child
        ,p_end_date              => l_end_date_child
        );

Line: 505

      ame_item_class_api.delete_ame_item_class_usage
        (p_validate              => p_validate
        ,p_application_id        => p_application_id
        ,p_item_class_id         => l_itemClassIds(indx)
        ,p_object_version_number => l_objectVersionNumbers(indx)
        ,p_start_date            => l_start_date_child
        ,p_end_date              => l_end_date_child
        );

Line: 523

       ame_approver_group_api.delete_approver_group_config
         (p_validate              => p_validate
         ,p_approval_group_id     => l_approvalGroupIds(indx)
         ,p_application_id        => p_application_id
         ,p_object_version_number => l_objectVersionNumbers(indx)
         ,p_start_date            => l_start_date_child
         ,p_end_date              => l_end_date_child
         );

Line: 541

      ame_action_api.delete_ame_action_type_conf
        (p_validate              => p_validate
        ,p_action_type_id        => l_actionTypeIds(indx)
        ,p_application_id        => p_application_id
        ,p_object_version_number => l_objectVersionNumbers(indx)
        ,p_start_date            => l_start_date_child
        ,p_end_date              => l_end_date_child
        );

Line: 559

      ame_config_var_api.delete_ame_config_variable
        (p_validate              => p_validate
        ,p_application_id        => p_application_id
        ,p_variable_name         => l_configVarsList(indx)
        ,p_object_version_number => l_objectVersionNumbers(indx)
        ,p_start_date            => l_start_date_child
        ,p_end_date              => l_end_date_child
        );

Line: 571

    delete from ame_test_trans_att_values
     where application_id = p_application_id;

Line: 573

    delete from ame_test_transactions
     where application_id = p_application_id;

Line: 579

                   ,p_datetrack_mode          => hr_api.g_delete
                   ,p_application_id          => p_application_id
                   ,p_object_version_number   => p_object_version_number
                   ,p_start_date              => l_start_date
                   ,p_end_date                => l_end_date
                   );

Line: 589

      ame_trans_type_bk3.delete_ame_transaction_type_a
      (p_application_id          => p_application_id
      ,p_object_version_number   => p_object_version_number
      ,p_start_date              => l_start_date
      ,p_end_date                => l_end_date
      );

Line: 597

        hr_api.cannot_find_prog_unit_error(p_module_name => 'delete_ame_transaction_type'
                                          ,p_hook_type   => 'AP'
                                          );

Line: 620

      rollback to delete_ame_transaction_type;

Line: 635

      rollback to delete_ame_transaction_type;

Line: 646

  end delete_ame_transaction_type;