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_API SQL Statements

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

Line: 14


procedure insert_eff_report_approvals
(p_validate                       in            boolean  default false
,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 boolean
)
IS
  --
  -- Declare cursors and local variables
  --
  l_proc                      varchar2(72) := g_package||'insert_eff_report_approvals';

Line: 83


  savepoint insert_eff_report_approvals;

Line: 97


    psp_eff_report_approvals_bk1.insert_eff_report_approvals_b
		(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                   =>  l_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
		);

Line: 151


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

Line: 223


     psp_eff_report_approvals_bk1.insert_eff_report_approvals_a
		(p_effort_report_approval_id       =>  l_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                   =>  l_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_object_version_number           =>  l_object_version_number
		,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_return_status                   =>  l_return_status
		);

Line: 280


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

Line: 304


    rollback to insert_eff_report_approvals;

Line: 318


    rollback to insert_eff_report_approvals;

Line: 328


end insert_eff_report_approvals;

Line: 342


procedure update_eff_report_approvals
(p_validate                       in            boolean  default false
,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 boolean
) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_eff_report_approvals';

Line: 447


  savepoint update_eff_report_approvals;

Line: 540


    psp_eff_report_approvals_bk2.update_eff_report_approvals_b
		(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                   =>  l_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               =>  l_pera_information1
		,p_pera_information2               =>  l_pera_information2
		,p_pera_information3               =>  l_pera_information3
		,p_pera_information4               =>  l_pera_information4
		,p_pera_information5               =>  l_pera_information5
		,p_pera_information6               =>  l_pera_information6
		,p_pera_information7               =>  l_pera_information7
		,p_pera_information8               =>  l_pera_information8
		,p_pera_information9               =>  l_pera_information9
		,p_pera_information10              =>  l_pera_information10
		,p_pera_information11              =>  l_pera_information11
		,p_pera_information12              =>  l_pera_information12
		,p_pera_information13              =>  l_pera_information13
		,p_pera_information14              =>  l_pera_information14
		,p_pera_information15              =>  l_pera_information15
		,p_pera_information16              =>  l_pera_information16
		,p_pera_information17              =>  l_pera_information17
		,p_pera_information18              =>  l_pera_information18
		,p_pera_information19              =>  l_pera_information19
		,p_pera_information20              =>  l_pera_information20
		,p_wf_role_display_name            =>  p_wf_role_display_name
		,p_object_version_number           =>  l_object_version_number
		,p_eff_information_category        =>  p_eff_information_category
		,p_eff_information1                =>  l_eff_information1
		,p_eff_information2                =>  l_eff_information2
		,p_eff_information3                =>  l_eff_information3
		,p_eff_information4                =>  l_eff_information4
		,p_eff_information5                =>  l_eff_information5
		,p_eff_information6                =>  l_eff_information6
		,p_eff_information7                =>  l_eff_information7
		,p_eff_information8                =>  l_eff_information8
		,p_eff_information9                =>  l_eff_information9
		,p_eff_information10               =>  l_eff_information10
		,p_eff_information11               =>  l_eff_information11
		,p_eff_information12               =>  l_eff_information12
		,p_eff_information13               =>  l_eff_information13
		,p_eff_information14               =>  l_eff_information14
		,p_eff_information15               =>  l_eff_information15
		);

Line: 596


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

Line: 775


    psp_eff_report_approvals_bk2.update_eff_report_approvals_a
		(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                   =>  l_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               =>  l_pera_information1
		,p_pera_information2               =>  l_pera_information2
		,p_pera_information3               =>  l_pera_information3
		,p_pera_information4               =>  l_pera_information4
		,p_pera_information5               =>  l_pera_information5
		,p_pera_information6               =>  l_pera_information6
		,p_pera_information7               =>  l_pera_information7
		,p_pera_information8               =>  l_pera_information8
		,p_pera_information9               =>  l_pera_information9
		,p_pera_information10              =>  l_pera_information10
		,p_pera_information11              =>  l_pera_information11
		,p_pera_information12              =>  l_pera_information12
		,p_pera_information13              =>  l_pera_information13
		,p_pera_information14              =>  l_pera_information14
		,p_pera_information15              =>  l_pera_information15
		,p_pera_information16              =>  l_pera_information16
		,p_pera_information17              =>  l_pera_information17
		,p_pera_information18              =>  l_pera_information18
		,p_pera_information19              =>  l_pera_information19
		,p_pera_information20              =>  l_pera_information20
		,p_wf_role_display_name            =>  p_wf_role_display_name
		,p_object_version_number           =>  l_object_version_number
		,p_eff_information_category        =>  p_eff_information_category
		,p_eff_information1                =>  l_eff_information1
		,p_eff_information2                =>  l_eff_information2
		,p_eff_information3                =>  l_eff_information3
		,p_eff_information4                =>  l_eff_information4
		,p_eff_information5                =>  l_eff_information5
		,p_eff_information6                =>  l_eff_information6
		,p_eff_information7                =>  l_eff_information7
		,p_eff_information8                =>  l_eff_information8
		,p_eff_information9                =>  l_eff_information9
		,p_eff_information10               =>  l_eff_information10
		,p_eff_information11               =>  l_eff_information11
		,p_eff_information12               =>  l_eff_information12
		,p_eff_information13               =>  l_eff_information13
		,p_eff_information14               =>  l_eff_information14
		,p_eff_information15               =>  l_eff_information15
		,p_return_status                   =>  l_return_status
		);

Line: 832


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

Line: 854


    rollback to update_eff_report_approvals;

Line: 867


    rollback to update_eff_report_approvals;

Line: 876


end update_eff_report_approvals;

Line: 886


procedure delete_eff_report_approvals
( p_validate                     in             boolean  default false
, p_effort_report_approval_id    in             number
, p_object_version_number        in out nocopy  number
, p_return_status                   out	nocopy  boolean
)
IS
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_eff_report_approvals_line';

Line: 904


  savepoint delete_eff_report_approvals;

Line: 914


    psp_eff_report_approvals_bk3.delete_eff_report_approvals_b
	( p_effort_report_approval_id      =>   p_effort_report_approval_id
	, p_object_version_number          =>   l_object_version_number
	);

Line: 921


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

Line: 946


     psp_eff_report_approvals_bk3.delete_eff_report_approvals_a
	( p_effort_report_approval_id      =>   p_effort_report_approval_id
	, p_object_version_number          =>   l_object_version_number
	, p_return_status                  =>   l_return_status
	);

Line: 954


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

Line: 976


    rollback to delete_eff_report_approvals;

Line: 989


    rollback to delete_eff_report_approvals;

Line: 998


end delete_eff_report_approvals;