APPS.AME_CONDITION_API SQL Statements

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

Line: 50

         select attribute_type
           from ame_attributes
          where p_effective_date between start_date
                  and nvl(end_date - ame_util.oneSecond, p_effective_date)
            and attribute_id in (select attribute_id
                                   from ame_conditions
                                  where condition_id = p_condition_id
                                    and p_effective_date between start_date and
                                          nvl(end_date - ame_util.oneSecond,
                                            p_effective_date)
                                );

Line: 304

procedure update_ame_condition
  (p_validate                    in     boolean  default false
  ,p_condition_id                in     number
  ,p_parameter_one               in     varchar2 default hr_api.g_varchar2
  ,p_parameter_two               in     varchar2 default hr_api.g_varchar2
  ,p_parameter_three             in     varchar2 default hr_api.g_varchar2
  ,p_include_upper_limit         in     varchar2 default hr_api.g_varchar2
  ,p_include_lower_limit         in     varchar2 default hr_api.g_varchar2
  ,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_condition';

Line: 334

    savepoint update_ame_condition;

Line: 343

      ame_condition_bk2.update_ame_condition_b
        (p_condition_id          => p_condition_id
        ,p_parameter_one         => p_parameter_one
        ,p_parameter_two         => p_parameter_two
        ,p_parameter_three       => p_parameter_three
        ,p_include_upper_limit   => p_include_upper_limit
        ,p_include_lower_limit   => p_include_lower_limit
        ,p_object_version_number => p_object_version_number
        );

Line: 355

          (p_module_name => 'update_ame_condition'
          ,p_hook_type   => 'BP'
          );

Line: 363

                   ,p_datetrack_mode        => hr_api.g_update
                   ,p_condition_id          => p_condition_id
                   ,p_object_version_number => p_object_version_number
                   ,p_parameter_one         => p_parameter_one
                   ,p_parameter_two         => p_parameter_two
                   ,p_parameter_three       => p_parameter_three
                   ,p_include_upper_limit   => p_include_upper_limit
                   ,p_include_lower_limit   => p_include_lower_limit
                   ,p_security_group_id     => hr_api.g_number
                   ,p_start_date            => l_start_date
                   ,p_end_date              => l_end_date
                   );

Line: 379

      ame_condition_bk2.update_ame_condition_a
        (p_condition_id          => p_condition_id
        ,p_parameter_one         => p_parameter_one
        ,p_parameter_two         => p_parameter_two
        ,p_parameter_three       => p_parameter_three
        ,p_include_upper_limit   => p_include_upper_limit
        ,p_include_lower_limit   => p_include_lower_limit
        ,p_object_version_number => p_object_version_number
        ,p_start_date            => l_start_date
        ,p_end_date              => l_end_date
        );

Line: 393

          (p_module_name => 'update_ame_condition'
          ,p_hook_type   => 'AP'
          );

Line: 416

      rollback to update_ame_condition;

Line: 431

      rollback to update_ame_condition;

Line: 442

  end update_ame_condition;

Line: 449

procedure delete_ame_condition
  (p_validate              in     boolean  default false
  ,p_condition_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 ame_str_vals is
         select string_value, object_version_number
           from ame_string_values
          where condition_id = p_condition_id
            and sysdate between start_date and
                  nvl(end_date - ame_util.oneSecond,sysdate);

Line: 466

         select null
           from ame_rules,
                ame_rule_usages,
                ame_condition_usages
          where ame_rules.rule_id = ame_condition_usages.rule_id
            and ame_rules.rule_id = ame_rule_usages.rule_id
            and ame_condition_usages.condition_id = p_chk_condition_id
            and ((sysdate between ame_rules.start_date and
                   nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
                 or
                 (sysdate < ame_rules.start_date and
                    ame_rules.start_date < nvl(ame_rules.end_date,
                      ame_rules.start_date + ame_util.oneSecond)))
            and ((sysdate between ame_rule_usages.start_date and
                   nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
                 or
                 (sysdate < ame_rule_usages.start_date and
                  ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
                    ame_rule_usages.start_date + ame_util.oneSecond)))
            and ((sysdate between ame_condition_usages.start_date and
                nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
                or
                (sysdate < ame_condition_usages.start_date and
                   ame_condition_usages.start_date <
                     nvl(ame_condition_usages.end_date,
                       ame_condition_usages.start_date + ame_util.oneSecond)));

Line: 493

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

Line: 507

    savepoint delete_ame_condition;

Line: 516

      ame_condition_bk3.delete_ame_condition_b
        (p_condition_id             => p_condition_id
        ,p_object_version_number    => p_object_version_number
        );

Line: 523

          (p_module_name => 'delete_ame_condition'
          ,p_hook_type   => 'BP'
          );

Line: 553

            delete_ame_string_value
                (p_validate                => p_validate
                ,p_condition_id            => p_condition_id
                ,p_string_value            => l_string_value_tab(indx)
                ,p_object_version_number   => l_object_version_number_tab(indx)
                ,p_start_date              => l_start_date
                ,p_end_date                => l_end_date
                );

Line: 565

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

Line: 575

        ame_condition_bk3.delete_ame_condition_a
        (p_condition_id            => p_condition_id
        ,p_object_version_number   => p_object_version_number
        ,p_start_date              => l_start_date
        ,p_end_date                => l_end_date
        );

Line: 584

            (p_module_name => 'delete_ame_condition'
            ,p_hook_type   => 'AP'
            );

Line: 608

      rollback to delete_ame_condition;

Line: 623

      rollback to delete_ame_condition;

Line: 634

  end delete_ame_condition;

Line: 761

procedure delete_ame_string_value
  (p_validate              in     boolean  default false
  ,p_condition_id          in     number
  ,p_string_value          in     varchar2
  ,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||'delete_ame_string_value';

Line: 782

    savepoint delete_ame_string_value;

Line: 791

      ame_condition_bk5.delete_ame_string_value_b
        (p_condition_id             => p_condition_id
        ,p_string_value             => p_string_value
        ,p_object_version_number    => p_object_version_number
        );

Line: 799

          (p_module_name => 'delete_ame_string_value'
          ,p_hook_type   => 'BP'
          );

Line: 807

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

Line: 818

      ame_condition_bk5.delete_ame_string_value_a
        (p_condition_id            => p_condition_id
        ,p_string_value            => p_string_value
        ,p_object_version_number   => p_object_version_number
        ,p_start_date              => l_start_date
        ,p_end_date                => l_end_date
        );

Line: 828

          (p_module_name => 'delete_ame_string_value'
          ,p_hook_type   => 'AP'
          );

Line: 851

      rollback to delete_ame_string_value;

Line: 866

      rollback to delete_ame_string_value;

Line: 877

  end delete_ame_string_value;