APPS.PAY_LINK_INPUT_VALUES_API SQL Statements

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

Line: 49

    select *
      from pay_input_values_f
     where input_value_id = p_input_value_id
       and p_effective_date between effective_start_date
       and effective_end_date;

Line: 57

    select costable_type
      from pay_element_links_f
     where element_link_id = p_element_link_id
       and p_effective_date between effective_start_date
       and effective_end_date;

Line: 65

    select null
      from per_pay_bases
     where input_value_id = p_input_value_id;

Line: 158

procedure UPDATE_LINK_INPUT_VALUES
  (p_validate                   in      boolean
  ,p_effective_date             in      date
  ,p_datetrack_update_mode      in      varchar2
  ,p_link_input_value_id        in      number
  ,p_object_version_number      in out  nocopy number
  ,p_costed_flag                in      varchar2
  ,p_default_value              in      varchar2
  ,p_max_value                  in      varchar2
  ,p_min_value                  in      varchar2
  ,p_warning_or_error           in      varchar2
  ,p_effective_start_date       out     nocopy date
  ,p_effective_end_date         out     nocopy date
  ,p_pay_basis_warning          out     nocopy boolean
  ,p_default_range_warning      out     nocopy boolean
  ,p_default_formula_warning    out     nocopy boolean
  ,p_assignment_id_warning      out     nocopy boolean
  ,p_formula_message            out     nocopy varchar2
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 198

    select element_link_id, input_value_id
      from pay_link_input_values_f
     where link_input_value_id = p_link_input_value_id
       and p_effective_date between effective_start_date
       and effective_end_date;

Line: 206

    select null
      from per_pay_bases
     where input_value_id = l_input_value_id;

Line: 212

    select lookup_type
      from pay_input_values_f
     where input_value_id = p_input_value_id
       and p_effective_date between effective_start_date
       and effective_end_date;

Line: 220

    select lookup_code
      from hr_lookups
     where lookup_type = p_lookup_type
       and upper(meaning) = p_default_value
       and enabled_flag = 'Y'
       and p_effective_date between nvl(start_date_active, p_effective_date)
       and nvl(end_date_active, p_effective_date);

Line: 234

  savepoint update_link_input_values;

Line: 292

    PAY_LINK_INPUT_VALUES_BK1.update_link_input_values_b
      (p_effective_date         => l_effective_date
      ,p_datetrack_update_mode  => p_datetrack_update_mode
      ,p_link_input_value_id    => p_link_input_value_id
      ,p_element_link_id        => l_element_link_id
      ,p_input_value_id         => l_input_value_id
      ,p_costed_flag            => p_costed_flag
      ,p_default_value          => l_default_value
      ,p_max_value              => p_max_value
      ,p_min_value              => p_min_value
      ,p_warning_or_error       => p_warning_or_error
      ,p_object_version_number  => l_object_version_number
      );

Line: 308

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

Line: 331

    ,p_datetrack_mode           => p_datetrack_update_mode
    ,p_element_link_id          => l_element_link_id
    ,p_input_value_id           => l_input_value_id
    ,p_costed_flag              => p_costed_flag
    ,p_default_value            => l_default_value
    ,p_max_value                => p_max_value
    ,p_min_value                => p_min_value
    ,p_warning_or_error         => p_warning_or_error
    ,p_link_input_value_id      => p_link_input_value_id
    ,p_object_version_number    => l_object_version_number
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    ,p_default_range_warning    => l_default_range_warning
    ,p_default_formula_warning  => l_default_formula_warning
    ,p_assignment_id_warning    => l_assignment_id_warning
    ,p_formula_message          => l_formula_message
    );

Line: 352

    PAY_LINK_INPUT_VALUES_BK1.update_link_input_values_a
      (p_effective_date          => l_effective_date
      ,p_datetrack_update_mode   => p_datetrack_update_mode
      ,p_link_input_value_id     => p_link_input_value_id
      ,p_element_link_id         => l_element_link_id
      ,p_input_value_id          => l_input_value_id
      ,p_costed_flag             => p_costed_flag
      ,p_default_value           => l_default_value
      ,p_max_value               => p_max_value
      ,p_min_value               => p_min_value
      ,p_warning_or_error        => p_warning_or_error
      ,p_effective_start_date    => l_effective_start_date
      ,p_effective_end_date      => l_effective_end_date
      ,p_object_version_number   => l_object_version_number
      ,p_pay_basis_warning       => p_pay_basis_warning
      ,p_default_range_warning   => l_default_range_warning
      ,p_default_formula_warning => l_default_formula_warning
      ,p_assignment_id_warning   => l_assignment_id_warning
      ,p_formula_message         => l_formula_message
      );

Line: 375

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

Line: 403

    rollback to update_link_input_values;

Line: 418

    rollback to update_link_input_values;

Line: 428

end UPDATE_LINK_INPUT_VALUES;

Line: 435

procedure DELETE_LINK_INPUT_VALUES
  (p_validate                   in      boolean
  ,p_effective_date             in      date
  ,p_datetrack_delete_mode      in      varchar2
  ,p_link_input_value_id        in      number
  ,p_effective_start_date       out     nocopy date
  ,p_effective_end_date         out     nocopy date
  ,p_object_version_number      in out  nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 459

  savepoint delete_link_input_values;

Line: 472

    PAY_LINK_INPUT_VALUES_BK2.delete_link_input_values_b
      (p_effective_date          => l_effective_date
      ,p_datetrack_delete_mode   => p_datetrack_delete_mode
      ,p_link_input_value_id     => p_link_input_value_id
      ,p_object_version_number   => l_object_version_number
      );

Line: 481

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

Line: 491

  If p_datetrack_delete_mode in ('ZAP','DELETE') then
    fnd_message.set_name('PAY','HR_7098_INPVAL_NO_CHANGES');

Line: 500

    ,p_datetrack_mode           => p_datetrack_delete_mode
    ,p_link_input_value_id      => p_link_input_value_id
    ,p_object_version_number    => l_object_version_number
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    );

Line: 510

    PAY_LINK_INPUT_VALUES_BK2.delete_link_input_values_a
      (p_effective_date          => p_effective_date
      ,p_datetrack_delete_mode   => p_datetrack_delete_mode
      ,p_link_input_value_id     => p_link_input_value_id
      ,p_object_version_number   => l_object_version_number
      ,p_effective_start_date    => l_effective_start_date
      ,p_effective_end_date      => l_effective_end_date
      );

Line: 521

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

Line: 545

    rollback to delete_link_input_values;

Line: 559

    rollback to delete_link_input_values;

Line: 565

end DELETE_LINK_INPUT_VALUES;