The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_salary_cap
( p_validate in boolean default false
, p_salary_cap_id in number
, p_funding_source_code in varchar2
, p_start_date in date
, p_end_date in date
, p_currency_code in varchar2
, p_annual_salary_cap in number
, p_seed_flag in varchar2
, p_object_version_number in out nocopy number
, p_return_status out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_object_version_number number(9);
l_proc varchar2(72) := g_package||'update_salary_cap';
savepoint update_salary_cap;
psp_salary_caps_bk2.update_salary_cap_b
( p_salary_cap_id => p_salary_cap_id
, p_funding_source_code => p_funding_source_code
, p_start_date => l_start_date
, p_end_date => l_end_date
, p_currency_code => p_currency_code
, p_annual_salary_cap => p_annual_salary_cap
, p_seed_flag => p_seed_flag
);
(p_module_name => 'update_salary_cap'
,p_hook_type => 'BP'
);
psp_salary_caps_bk2.update_salary_cap_a
( p_salary_cap_id => p_salary_cap_id
, p_funding_source_code => p_funding_source_code
, p_start_date => l_start_date
, p_end_date => l_end_date
, p_currency_code => p_currency_code
, p_annual_salary_cap => p_annual_salary_cap
, p_seed_flag => p_seed_flag
);
(p_module_name => 'update_salary_cap'
,p_hook_type => 'AP'
);
rollback to update_salary_cap;
rollback to update_salary_cap;
end update_salary_cap;
procedure delete_salary_cap
( p_validate in boolean default false
, p_salary_cap_id in number
, p_object_version_number in out nocopy number
, p_return_status out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_object_version_number number(9);
l_proc varchar2(72) := g_package||'delete_salary_cap';
savepoint delete_salary_cap;
psp_salary_caps_bk3.delete_salary_cap_b
( p_salary_cap_id => p_salary_cap_id
);
(p_module_name => 'delete_salary_cap'
,p_hook_type => 'BP'
);
psp_salary_caps_bk3.delete_salary_cap_a
( p_salary_cap_id => p_salary_cap_id
);
(p_module_name => 'delete_salary_cap'
,p_hook_type => 'AP'
);
rollback to delete_salary_cap;
rollback to delete_salary_cap;
end delete_salary_cap;