eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ACCRUAL_PLAN_SWI SQL Statements

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

Line: 273


PROCEDURE update_accrual_plan
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_accrual_plan_id              in     number
  ,p_pto_input_value_id           in     number    default hr_api.g_number
  ,p_accrual_category             in     varchar2  default hr_api.g_varchar2
  ,p_accrual_start                in     varchar2  default hr_api.g_varchar2
  ,p_ineligible_period_length     in     number    default hr_api.g_number
  ,p_ineligible_period_type       in     varchar2  default hr_api.g_varchar2
  ,p_accrual_formula_id           in     number    default hr_api.g_number
  ,p_co_formula_id                in     number    default hr_api.g_number
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_ineligibility_formula_id     in     number    default hr_api.g_number
  ,p_balance_dimension_id         in     number    default hr_api.g_number
  ,p_information_category         in     varchar2  default hr_api.g_varchar2
  ,p_information1                 in     varchar2  default hr_api.g_varchar2
  ,p_information2                 in     varchar2  default hr_api.g_varchar2
  ,p_information3                 in     varchar2  default hr_api.g_varchar2
  ,p_information4                 in     varchar2  default hr_api.g_varchar2
  ,p_information5                 in     varchar2  default hr_api.g_varchar2
  ,p_information6                 in     varchar2  default hr_api.g_varchar2
  ,p_information7                 in     varchar2  default hr_api.g_varchar2
  ,p_information8                 in     varchar2  default hr_api.g_varchar2
  ,p_information9                 in     varchar2  default hr_api.g_varchar2
  ,p_information10                in     varchar2  default hr_api.g_varchar2
  ,p_information11                in     varchar2  default hr_api.g_varchar2
  ,p_information12                in     varchar2  default hr_api.g_varchar2
  ,p_information13                in     varchar2  default hr_api.g_varchar2
  ,p_information14                in     varchar2  default hr_api.g_varchar2
  ,p_information15                in     varchar2  default hr_api.g_varchar2
  ,p_information16                in     varchar2  default hr_api.g_varchar2
  ,p_information17                in     varchar2  default hr_api.g_varchar2
  ,p_information18                in     varchar2  default hr_api.g_varchar2
  ,p_information19                in     varchar2  default hr_api.g_varchar2
  ,p_information20                in     varchar2  default hr_api.g_varchar2
  ,p_information21                in     varchar2  default hr_api.g_varchar2
  ,p_information22                in     varchar2  default hr_api.g_varchar2
  ,p_information23                in     varchar2  default hr_api.g_varchar2
  ,p_information24                in     varchar2  default hr_api.g_varchar2
  ,p_information25                in     varchar2  default hr_api.g_varchar2
  ,p_information26                in     varchar2  default hr_api.g_varchar2
  ,p_information27                in     varchar2  default hr_api.g_varchar2
  ,p_information28                in     varchar2  default hr_api.g_varchar2
  ,p_information29                in     varchar2  default hr_api.g_varchar2
  ,p_information30                in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_payroll_formula_id              out nocopy number
  ,p_defined_balance_id              out nocopy number
  ,p_balance_element_type_id         out nocopy number
  ,p_tagging_element_type_id         out nocopy number
  ,p_check_accrual_ff                out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 337


  l_proc := g_package ||'update_accrual_plan';

Line: 342


  savepoint update_accrual_plan_swi;

Line: 366


  hr_accrual_plan_api.update_accrual_plan
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_accrual_plan_id              => p_accrual_plan_id
    ,p_pto_input_value_id           => p_pto_input_value_id
    ,p_accrual_category             => p_accrual_category
    ,p_accrual_start                => p_accrual_start
    ,p_ineligible_period_length     => p_ineligible_period_length
    ,p_ineligible_period_type       => p_ineligible_period_type
    ,p_accrual_formula_id           => p_accrual_formula_id
    ,p_co_formula_id                => p_co_formula_id
    ,p_description                  => p_description
    ,p_ineligibility_formula_id     => p_ineligibility_formula_id
    ,p_balance_dimension_id         => p_balance_dimension_id
    ,p_information_category         => p_information_category
    ,p_information1                 => p_information1
    ,p_information2                 => p_information2
    ,p_information3                 => p_information3
    ,p_information4                 => p_information4
    ,p_information5                 => p_information5
    ,p_information6                 => p_information6
    ,p_information7                 => p_information7
    ,p_information8                 => p_information8
    ,p_information9                 => p_information9
    ,p_information10                => p_information10
    ,p_information11                => p_information11
    ,p_information12                => p_information12
    ,p_information13                => p_information13
    ,p_information14                => p_information14
    ,p_information15                => p_information15
    ,p_information16                => p_information16
    ,p_information17                => p_information17
    ,p_information18                => p_information18
    ,p_information19                => p_information19
    ,p_information20                => p_information20
    ,p_information21                => p_information21
    ,p_information22                => p_information22
    ,p_information23                => p_information23
    ,p_information24                => p_information24
    ,p_information25                => p_information25
    ,p_information26                => p_information26
    ,p_information27                => p_information27
    ,p_information28                => p_information28
    ,p_information29                => p_information29
    ,p_information30                => p_information30
    ,p_object_version_number        => p_object_version_number
    ,p_payroll_formula_id           => p_payroll_formula_id
    ,p_defined_balance_id           => p_defined_balance_id
    ,p_balance_element_type_id      => p_balance_element_type_id
    ,p_tagging_element_type_id      => p_tagging_element_type_id
    ,p_check_accrual_ff             => l_check_accrual_ff
    );

Line: 444


    rollback to update_accrual_plan_swi;

Line: 464


    rollback to update_accrual_plan_swi;

Line: 480


end update_accrual_plan;

Line: 484


PROCEDURE delete_accrual_plan
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_accrual_plan_id              in     number
  ,p_accrual_plan_element_type_id in     number
  ,p_co_element_type_id           in     number
  ,p_residual_element_type_id     in     number
  ,p_balance_element_type_id      in     number
  ,p_tagging_element_type_id      in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 505


  l_proc := g_package ||'delete_accrual_plan';

Line: 511


  savepoint delete_accrual_plan_swi;

Line: 531


  hr_accrual_plan_api.delete_accrual_plan
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_accrual_plan_id              => p_accrual_plan_id
    ,p_accrual_plan_element_type_id => p_accrual_plan_element_type_id
    ,p_co_element_type_id           => p_co_element_type_id
    ,p_residual_element_type_id     => p_residual_element_type_id
    ,p_balance_element_type_id      => p_balance_element_type_id
    ,p_tagging_element_type_id      => p_tagging_element_type_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 564


    rollback to delete_accrual_plan_swi;

Line: 578


    rollback to delete_accrual_plan_swi;

Line: 588


end delete_accrual_plan;