The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
select null
from per_pay_bases
where input_value_id = p_input_value_id;
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';
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;
select null
from per_pay_bases
where input_value_id = l_input_value_id;
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;
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);
savepoint update_link_input_values;
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
);
(p_module_name => 'UPDATE_LINK_INPUT_VALUES'
,p_hook_type => 'BP'
);
,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
);
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
);
(p_module_name => 'UPDATE_LINK_INPUT_VALUES'
,p_hook_type => 'AP'
);
rollback to update_link_input_values;
rollback to update_link_input_values;
end UPDATE_LINK_INPUT_VALUES;
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';
savepoint delete_link_input_values;
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
);
(p_module_name => 'DELETE_LINK_INPUT_VALUES'
,p_hook_type => 'BP'
);
If p_datetrack_delete_mode in ('ZAP','DELETE') then
fnd_message.set_name('PAY','HR_7098_INPVAL_NO_CHANGES');
,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
);
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
);
(p_module_name => 'DELETE_LINK_INPUT_VALUES'
,p_hook_type => 'AP'
);
rollback to delete_link_input_values;
rollback to delete_link_input_values;
end DELETE_LINK_INPUT_VALUES;