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.PSP_EFF_REPORT_APPROVALS_SWI SQL Statements

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

Line: 11


PROCEDURE delete_eff_report_approvals
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effort_report_approval_id    in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 26


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

Line: 32


  savepoint delete_eff_report_approval_swi;

Line: 56


  psp_eff_report_approvals_api.delete_eff_report_approvals
    (p_validate                     => l_validate
    ,p_effort_report_approval_id    => p_effort_report_approval_id
    ,p_object_version_number        => p_object_version_number
    ,p_return_status                => l_return_status
    );

Line: 88


    rollback to delete_eff_report_approval_swi;

Line: 104


    rollback to delete_eff_report_approval_swi;

Line: 116


end delete_eff_report_approvals;

Line: 120


PROCEDURE insert_eff_report_approvals
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effort_report_detail_id      in     number
  ,p_wf_role_name                 in     varchar2
  ,p_wf_orig_system_id            in     number
  ,p_wf_orig_system               in     varchar2
  ,p_approver_order_num           in     number
  ,p_approval_status              in     varchar2
  ,p_response_date                in     date
  ,p_actual_cost_share            in     number
  ,p_overwritten_effort_percent   in     number
  ,p_wf_item_key                  in     varchar2
  ,p_comments                     in     varchar2
  ,p_pera_information_category    in     varchar2
  ,p_pera_information1            in     varchar2
  ,p_pera_information2            in     varchar2
  ,p_pera_information3            in     varchar2
  ,p_pera_information4            in     varchar2
  ,p_pera_information5            in     varchar2
  ,p_pera_information6            in     varchar2
  ,p_pera_information7            in     varchar2
  ,p_pera_information8            in     varchar2
  ,p_pera_information9            in     varchar2
  ,p_pera_information10           in     varchar2
  ,p_pera_information11           in     varchar2
  ,p_pera_information12           in     varchar2
  ,p_pera_information13           in     varchar2
  ,p_pera_information14           in     varchar2
  ,p_pera_information15           in     varchar2
  ,p_pera_information16           in     varchar2
  ,p_pera_information17           in     varchar2
  ,p_pera_information18           in     varchar2
  ,p_pera_information19           in     varchar2
  ,p_pera_information20           in     varchar2
  ,p_wf_role_display_name         in     varchar2
  ,p_eff_information_category     in     varchar2
  ,p_eff_information1             in     varchar2
  ,p_eff_information2             in     varchar2
  ,p_eff_information3             in     varchar2
  ,p_eff_information4             in     varchar2
  ,p_eff_information5             in     varchar2
  ,p_eff_information6             in     varchar2
  ,p_eff_information7             in     varchar2
  ,p_eff_information8             in     varchar2
  ,p_eff_information9             in     varchar2
  ,p_eff_information10            in     varchar2
  ,p_eff_information11            in     varchar2
  ,p_eff_information12            in     varchar2
  ,p_eff_information13            in     varchar2
  ,p_eff_information14            in     varchar2
  ,p_eff_information15            in     varchar2
  ,p_effort_report_approval_id       out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 183


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

Line: 189


  savepoint insert_eff_report_approval_swi;

Line: 215


  psp_eff_report_approvals_api.insert_eff_report_approvals
    (p_validate                     => l_validate
    ,p_effort_report_detail_id      => p_effort_report_detail_id
    ,p_wf_role_name                 => p_wf_role_name
    ,p_wf_orig_system_id            => p_wf_orig_system_id
    ,p_wf_orig_system               => p_wf_orig_system
    ,p_approver_order_num           => p_approver_order_num
    ,p_approval_status              => p_approval_status
    ,p_response_date                => p_response_date
    ,p_actual_cost_share            => p_actual_cost_share
    ,p_overwritten_effort_percent   => p_overwritten_effort_percent
    ,p_wf_item_key                  => p_wf_item_key
    ,p_comments                     => p_comments
    ,p_pera_information_category    => p_pera_information_category
    ,p_pera_information1            => p_pera_information1
    ,p_pera_information2            => p_pera_information2
    ,p_pera_information3            => p_pera_information3
    ,p_pera_information4            => p_pera_information4
    ,p_pera_information5            => p_pera_information5
    ,p_pera_information6            => p_pera_information6
    ,p_pera_information7            => p_pera_information7
    ,p_pera_information8            => p_pera_information8
    ,p_pera_information9            => p_pera_information9
    ,p_pera_information10           => p_pera_information10
    ,p_pera_information11           => p_pera_information11
    ,p_pera_information12           => p_pera_information12
    ,p_pera_information13           => p_pera_information13
    ,p_pera_information14           => p_pera_information14
    ,p_pera_information15           => p_pera_information15
    ,p_pera_information16           => p_pera_information16
    ,p_pera_information17           => p_pera_information17
    ,p_pera_information18           => p_pera_information18
    ,p_pera_information19           => p_pera_information19
    ,p_pera_information20           => p_pera_information20
    ,p_wf_role_display_name         => p_wf_role_display_name
    ,p_eff_information_category     => p_eff_information_category
    ,p_eff_information1             => p_eff_information1
    ,p_eff_information2             => p_eff_information2
    ,p_eff_information3             => p_eff_information3
    ,p_eff_information4             => p_eff_information4
    ,p_eff_information5             => p_eff_information5
    ,p_eff_information6             => p_eff_information6
    ,p_eff_information7             => p_eff_information7
    ,p_eff_information8             => p_eff_information8
    ,p_eff_information9             => p_eff_information9
    ,p_eff_information10            => p_eff_information10
    ,p_eff_information11            => p_eff_information11
    ,p_eff_information12            => p_eff_information12
    ,p_eff_information13            => p_eff_information13
    ,p_eff_information14            => p_eff_information14
    ,p_eff_information15            => p_eff_information15
    ,p_effort_report_approval_id    => p_effort_report_approval_id
    ,p_object_version_number        => p_object_version_number
    ,p_return_status                => l_return_status
    );

Line: 296


    rollback to insert_eff_report_approval_swi;

Line: 313


    rollback to insert_eff_report_approval_swi;

Line: 326


end insert_eff_report_approvals;

Line: 330


PROCEDURE update_eff_report_approvals
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effort_report_approval_id    in     number
  ,p_effort_report_detail_id      in     number    default hr_api.g_number
  ,p_wf_role_name                 in     varchar2  default hr_api.g_varchar2
  ,p_wf_orig_system_id            in     number    default hr_api.g_number
  ,p_wf_orig_system               in     varchar2  default hr_api.g_varchar2
  ,p_approver_order_num           in     number    default hr_api.g_number
  ,p_approval_status              in     varchar2  default hr_api.g_varchar2
  ,p_response_date                in     date      default hr_api.g_date
  ,p_actual_cost_share            in     number    default hr_api.g_number
  ,p_overwritten_effort_percent   in     number    default hr_api.g_number
  ,p_wf_item_key                  in     varchar2  default hr_api.g_varchar2
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_pera_information_category    in     varchar2  default hr_api.g_varchar2
  ,p_pera_information1            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information2            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information3            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information4            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information5            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information6            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information7            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information8            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information9            in     varchar2  default hr_api.g_varchar2
  ,p_pera_information10           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information11           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information12           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information13           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information14           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information15           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information16           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information17           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information18           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information19           in     varchar2  default hr_api.g_varchar2
  ,p_pera_information20           in     varchar2  default hr_api.g_varchar2
  ,p_wf_role_display_name         in     varchar2  default hr_api.g_varchar2
  ,p_eff_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_eff_information1             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information2             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information3             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information4             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information5             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information6             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information7             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information8             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information9             in     varchar2  default hr_api.g_varchar2
  ,p_eff_information10            in     varchar2  default hr_api.g_varchar2
  ,p_eff_information11            in     varchar2  default hr_api.g_varchar2
  ,p_eff_information12            in     varchar2  default hr_api.g_varchar2
  ,p_eff_information13            in     varchar2  default hr_api.g_varchar2
  ,p_eff_information14            in     varchar2  default hr_api.g_varchar2
  ,p_eff_information15            in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 394


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

Line: 400


  savepoint update_eff_report_approval_swi;

Line: 424


  psp_eff_report_approvals_api.update_eff_report_approvals
    (p_validate                     => l_validate
    ,p_effort_report_approval_id    => p_effort_report_approval_id
    ,p_effort_report_detail_id      => p_effort_report_detail_id
    ,p_wf_role_name                 => p_wf_role_name
    ,p_wf_orig_system_id            => p_wf_orig_system_id
    ,p_wf_orig_system               => p_wf_orig_system
    ,p_approver_order_num           => p_approver_order_num
    ,p_approval_status              => p_approval_status
    ,p_response_date                => p_response_date
    ,p_actual_cost_share            => p_actual_cost_share
    ,p_overwritten_effort_percent   => p_overwritten_effort_percent
    ,p_wf_item_key                  => p_wf_item_key
    ,p_comments                     => p_comments
    ,p_pera_information_category    => p_pera_information_category
    ,p_pera_information1            => p_pera_information1
    ,p_pera_information2            => p_pera_information2
    ,p_pera_information3            => p_pera_information3
    ,p_pera_information4            => p_pera_information4
    ,p_pera_information5            => p_pera_information5
    ,p_pera_information6            => p_pera_information6
    ,p_pera_information7            => p_pera_information7
    ,p_pera_information8            => p_pera_information8
    ,p_pera_information9            => p_pera_information9
    ,p_pera_information10           => p_pera_information10
    ,p_pera_information11           => p_pera_information11
    ,p_pera_information12           => p_pera_information12
    ,p_pera_information13           => p_pera_information13
    ,p_pera_information14           => p_pera_information14
    ,p_pera_information15           => p_pera_information15
    ,p_pera_information16           => p_pera_information16
    ,p_pera_information17           => p_pera_information17
    ,p_pera_information18           => p_pera_information18
    ,p_pera_information19           => p_pera_information19
    ,p_pera_information20           => p_pera_information20
    ,p_wf_role_display_name         => p_wf_role_display_name
    ,p_eff_information_category     => p_eff_information_category
    ,p_eff_information1             => p_eff_information1
    ,p_eff_information2             => p_eff_information2
    ,p_eff_information3             => p_eff_information3
    ,p_eff_information4             => p_eff_information4
    ,p_eff_information5             => p_eff_information5
    ,p_eff_information6             => p_eff_information6
    ,p_eff_information7             => p_eff_information7
    ,p_eff_information8             => p_eff_information8
    ,p_eff_information9             => p_eff_information9
    ,p_eff_information10            => p_eff_information10
    ,p_eff_information11            => p_eff_information11
    ,p_eff_information12            => p_eff_information12
    ,p_eff_information13            => p_eff_information13
    ,p_eff_information14            => p_eff_information14
    ,p_eff_information15            => p_eff_information15
    ,p_object_version_number        => p_object_version_number
    ,p_return_status                => l_return_status
    );

Line: 505


    rollback to update_eff_report_approval_swi;

Line: 521


    rollback to update_eff_report_approval_swi;

Line: 533


end update_eff_report_approvals;