[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_update_warning OUT NOCOPY BOOLEAN
) IS
l_proc VARCHAR2(72);
SELECT pet.element_type_id
FROM pay_element_types_f pet
WHERE pet.element_name = 'PAYE Information'
AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
AND legislation_code = 'NZ';
SELECT piv.input_value_id
,piv.name
FROM pay_input_values_f piv
WHERE piv.element_type_id = c_element_type_id
AND c_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
SELECT pee.element_entry_id,
object_version_number
FROM pay_element_entries_f pee,
pay_element_entry_values_f pev
WHERE pee.assignment_id = p_assignment_id
AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
AND pee.element_link_id = p_element_link
AND pev.element_entry_id = pee.element_entry_id
AND c_effective_date BETWEEN pev.effective_start_date AND pev.effective_end_date
AND pev.input_value_id = p_inp_val;
IF (p_mode IN ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE'))
THEN
-----------------------------------------------------------------------------
-- Get the element entry of the tax element entry that is to be updated
------------------------------------------------------------------------------
hr_utility.set_location(l_proc, 30);
py_element_entry_api.update_element_entry
(p_validate => p_validate
,p_datetrack_update_mode => p_mode
,p_effective_date => l_effective_date
,p_business_group_id => p_business_group_id
,p_element_entry_id => l_element_entry_id
,p_object_version_number => l_object_version_number
,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
,p_updating_action_id => p_updating_action_id
,p_updating_action_type => p_updating_action_type
,p_original_entry_id => p_original_entry_id
,p_creator_type => p_creator_type
,p_comment_id => p_comment_id
,p_creator_id => p_creator_id
,p_reason => p_reason
,p_subpriority => p_subpriority
,p_date_earned => p_date_earned
,p_personal_payment_method_id => p_personal_payment_method_id
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_input_value_id1 => l_inp_value_id_table(1)
,p_input_value_id2 => l_inp_value_id_table(2)
,p_input_value_id3 => l_inp_value_id_table(3)
,p_input_value_id4 => l_inp_value_id_table(4)
,p_input_value_id5 => l_inp_value_id_table(5)
,p_input_value_id6 => l_inp_value_id_table(6)
,p_entry_value1 => p_tax_code
,p_entry_value2 => p_special_tax_code
,p_entry_value3 => p_paye_special_rate
,p_entry_value4 => p_acc_special_rate
,p_entry_value5 => p_student_loan_rate
,p_entry_value6 => p_all_extra_emol_at_high_rate
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date
,p_override_user_ent_chk => 'Y'
,p_update_warning => p_update_warning);