[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
pasg.assignment_id
FROM
per_all_assignments_f pasg,
per_all_assignments_f asg
WHERE asg.assignment_id = asgid
AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
AND pasg.person_id = asg.person_id
AND pasg.primary_flag = 'Y'
AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
insert_taxcard (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_tc => p_element_entry_id_tc
,p_taxcard_type => p_taxcard_type
,p_method_of_receipt => p_method_of_receipt
,p_base_rate => p_base_rate
,p_tax_municipality => p_tax_municipality
,p_additional_rate => p_additional_rate
,p_override_manual_upd => p_override_manual_upd
,p_previous_income => p_previous_income
,p_yearly_income_limit => p_yearly_income_limit
,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
,p_lower_income_percentage => p_lower_income_percentage);
insert_tax (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_t => p_element_entry_id_t
,p_primary_employment => p_primary_employment
,p_extra_income_rate => p_extra_income_rate
,p_extra_income_add_rate => p_extra_income_add_rate
,p_extra_income_limit => p_extra_income_limit
,p_prev_extra_income => p_prev_extra_income);
insert_tax (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_t => p_element_entry_id_t
,p_primary_employment => p_primary_employment
,p_extra_income_rate => p_extra_income_rate
,p_extra_income_add_rate => p_extra_income_add_rate
,p_extra_income_limit => p_extra_income_limit
,p_prev_extra_income => p_prev_extra_income);
PROCEDURE insert_taxcard (
p_legislation_code IN VARCHAR2
,p_effective_date IN DATE
,p_assignment_id IN VARCHAR2
,p_person_id IN VARCHAR2
,p_business_group_id IN VARCHAR2
,p_element_entry_id_tc IN VARCHAR2
,p_taxcard_type IN VARCHAR2 DEFAULT NULL
,p_method_of_receipt IN VARCHAR2 DEFAULT NULL
,p_base_rate IN NUMBER DEFAULT NULL
,p_tax_municipality IN VARCHAR2 DEFAULT NULL
,p_additional_rate IN NUMBER DEFAULT NULL
,p_override_manual_upd IN VARCHAR2 DEFAULT NULL
,p_previous_income IN NUMBER DEFAULT NULL
,p_yearly_income_limit IN NUMBER DEFAULT NULL
,p_date_returned IN DATE DEFAULT NULL
,p_registration_date IN DATE DEFAULT NULL
,p_lower_income_percentage IN NUMBER DEFAULT NULL
) IS
-- Declarations here
l_start_date DATE;
l_proc varchar2(72) := g_package||'insert_taxcard.';
SELECT
et.element_type_id,
MIN(DECODE(iv.name, 'Tax Card Type', iv.input_value_id, null)) iv1,
MIN(DECODE(iv.name, 'Method of Receipt', iv.input_value_id, null)) iv2,
MIN(DECODE(iv.name, 'Base Rate', iv.input_value_id, null)) iv3,
MIN(DECODE(iv.name, 'Tax Municipality', iv.input_value_id, null)) iv4,
MIN(DECODE(iv.name, 'Additional Rate', iv.input_value_id, null)) iv5,
MIN(DECODE(iv.name, 'Override Manual Update', iv.input_value_id, null)) iv6,
MIN(DECODE(iv.name, 'Previous Income', iv.input_value_id, null)) iv7,
MIN(DECODE(iv.name, 'Yearly Income Limit', iv.input_value_id, null)) iv8,
MIN(DECODE(iv.name, 'Date Returned', iv.input_value_id, null)) iv9,
MIN(DECODE(iv.name, 'Registration Date', iv.input_value_id, null)) iv10,
MIN(DECODE(iv.name, 'Lower Income Percentage', iv.input_value_id, null)) iv11
FROM
pay_element_types_f et,
pay_input_values_f iv
WHERE et.element_name = 'Tax Card'
AND et.legislation_code = 'FI'
AND et.business_group_id is null
AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
et.effective_start_date AND et.effective_end_date
AND iv.element_type_id = et.element_type_id
AND fnd_date.canonical_to_date(p_effective_date)
BETWEEN iv.effective_start_date AND iv.effective_end_date
GROUP BY
et.element_type_id;
select session_id
from fnd_sessions
where session_id = userenv('sessionid')
and effective_date = p_effective_date;
INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
END insert_taxcard;
PROCEDURE insert_tax (
p_legislation_code IN VARCHAR2
,p_effective_date IN DATE
,p_assignment_id IN VARCHAR2
,p_person_id IN VARCHAR2
,p_business_group_id IN VARCHAR2
,p_element_entry_id_t IN VARCHAR2
,p_primary_employment IN VARCHAR2 DEFAULT NULL
,p_extra_income_rate IN NUMBER DEFAULT NULL
,p_extra_income_add_rate IN NUMBER DEFAULT NULL
,p_extra_income_limit IN NUMBER DEFAULT NULL
,p_prev_extra_income IN NUMBER DEFAULT NULL
) IS
-- Declarations here
l_start_date DATE;
SELECT
et.element_type_id,
MIN(DECODE(iv.name, 'Primary Employment', iv.input_value_id, null)) iv1,
MIN(DECODE(iv.name, 'Extra Income Rate', iv.input_value_id, null)) iv2,
MIN(DECODE(iv.name, 'Extra Income Additional Rate', iv.input_value_id, null)) iv3,
MIN(DECODE(iv.name, 'Extra Income Limit', iv.input_value_id, null)) iv4,
MIN(DECODE(iv.name, 'Previous Extra Income', iv.input_value_id, null)) iv5
FROM
pay_element_types_f et,
pay_input_values_f iv
WHERE et.element_name = 'Tax'
AND et.legislation_code = 'FI'
AND et.business_group_id is null
AND fnd_date.canonical_to_date(p_effective_date)
BETWEEN et.effective_start_date AND et.effective_end_date
AND iv.element_type_id = et.element_type_id
AND fnd_date.canonical_to_date(p_effective_date)
BETWEEN iv.effective_start_date AND iv.effective_end_date
GROUP BY
et.element_type_id;
select session_id
from fnd_sessions
where session_id = userenv('sessionid')
and effective_date = p_effective_date;
SELECT pee.element_entry_id,pee.OBJECT_VERSION_NUMBER EE_OVN
FROM pay_element_types_f pet ,
pay_element_links_f pel ,
pay_element_entries_f pee
WHERE pet.element_name = l_element_name
AND pet.legislation_code = 'FI'
AND pet.business_group_id IS NULL
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pel.element_type_id = pet.element_type_id
AND pel.business_group_id = l_business_grp_id
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pel.effective_start_date AND pel.effective_end_date
AND pee.element_link_id = pel.element_link_id
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pee.effective_start_date AND pee.effective_end_date
AND pee.assignment_id = l_asgid;
l_proc varchar2(72) := g_package||'insert_tax.';
l_datetrack_update_mode VARCHAR2(255);
INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
l_datetrack_update_mode := 'CORRECTION'; -- doing this bcoz the user specified mode is to be given prio.
l_datetrack_update_mode := 'CORRECTION';
-- update Tax Element
pay_element_entry_api.update_element_entry
(p_validate => FALSE
,p_object_version_number => lrIsElementAttached.EE_OVN
,p_update_warning => l_warning
,p_datetrack_update_mode => l_datetrack_update_mode
,p_effective_date => p_effective_date
,p_business_group_id => p_business_group_id
,p_input_value_id1 => l_input_value_id1
,p_input_value_id2 => l_input_value_id2
,p_input_value_id3 => l_input_value_id3
,p_input_value_id4 => l_input_value_id4
,p_input_value_id5 => l_input_value_id5
,p_entry_value1 => p_primary_employment
,p_entry_value2 => p_extra_income_rate
,p_entry_value3 => p_extra_income_add_rate
,p_entry_value4 => p_extra_income_limit
,p_entry_value5 => p_prev_extra_income
,p_effective_start_date => l_start_date
,p_effective_end_date => l_end_date
,p_element_entry_id => lrIsElementAttached.element_entry_id
,p_cost_allocation_keyflex_id => hr_api.g_number
,p_updating_action_id => hr_api.g_number
,p_original_entry_id => hr_api.g_number
,p_creator_type => hr_api.g_varchar2
,p_comment_id => hr_api.g_number
,p_creator_id => hr_api.g_number
,p_reason => hr_api.g_varchar2
,p_subpriority => hr_api.g_number
,p_date_earned => hr_api.g_date
,p_personal_payment_method_id => hr_api.g_number
,p_attribute_category => hr_api.g_varchar2
,p_attribute1 => hr_api.g_varchar2
,p_attribute2 => hr_api.g_varchar2
,p_attribute3 => hr_api.g_varchar2
,p_attribute4 => hr_api.g_varchar2
,p_attribute5 => hr_api.g_varchar2
,p_attribute6 => hr_api.g_varchar2
,p_attribute7 => hr_api.g_varchar2
,p_attribute8 => hr_api.g_varchar2
,p_attribute9 => hr_api.g_varchar2
,p_attribute10 => hr_api.g_varchar2
,p_attribute11 => hr_api.g_varchar2
,p_attribute12 => hr_api.g_varchar2
,p_attribute13 => hr_api.g_varchar2
,p_attribute14 => hr_api.g_varchar2
,p_attribute15 => hr_api.g_varchar2
,p_attribute16 => hr_api.g_varchar2
,p_attribute17 => hr_api.g_varchar2
,p_attribute18 => hr_api.g_varchar2
,p_attribute19 => hr_api.g_varchar2
,p_attribute20 => hr_api.g_varchar2
,p_updating_action_type => hr_api.g_varchar2
,p_entry_information_category => hr_api.g_varchar2
,p_entry_information1 => hr_api.g_varchar2
,p_entry_information2 => hr_api.g_varchar2
,p_entry_information3 => hr_api.g_varchar2
,p_entry_information4 => hr_api.g_varchar2
,p_entry_information5 => hr_api.g_varchar2
,p_entry_information6 => hr_api.g_varchar2
,p_entry_information7 => hr_api.g_varchar2
,p_entry_information8 => hr_api.g_varchar2
,p_entry_information9 => hr_api.g_varchar2
,p_entry_information10 => hr_api.g_varchar2
,p_entry_information11 => hr_api.g_varchar2
,p_entry_information12 => hr_api.g_varchar2
,p_entry_information13 => hr_api.g_varchar2
,p_entry_information14 => hr_api.g_varchar2
,p_entry_information15 => hr_api.g_varchar2
,p_entry_information16 => hr_api.g_varchar2
,p_entry_information17 => hr_api.g_varchar2
,p_entry_information18 => hr_api.g_varchar2
,p_entry_information19 => hr_api.g_varchar2
,p_entry_information20 => hr_api.g_varchar2
,p_entry_information21 => hr_api.g_varchar2
,p_entry_information22 => hr_api.g_varchar2
,p_entry_information23 => hr_api.g_varchar2
,p_entry_information24 => hr_api.g_varchar2
,p_entry_information25 => hr_api.g_varchar2
,p_entry_information26 => hr_api.g_varchar2
,p_entry_information27 => hr_api.g_varchar2
,p_entry_information28 => hr_api.g_varchar2
,p_entry_information29 => hr_api.g_varchar2
,p_entry_information30 => hr_api.g_varchar2);
END insert_tax;
,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL
,p_object_version_number_tc IN VARCHAR2
,p_object_version_number_t IN VARCHAR2 DEFAULT NULL
) IS
--declarations here
l_proc varchar2(72) := g_package||'upd.';
SELECT
pasg.assignment_id
FROM
per_all_assignments_f pasg,
per_all_assignments_f asg
WHERE asg.assignment_id = asgid
AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
AND pasg.person_id = asg.person_id
AND pasg.primary_flag = 'Y'
AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
l_datetrack_update_mode VARCHAR2(255);
l_datetrack_update_mode := p_datetrack_update_mode;
l_datetrack_update_mode := p_datetrack_update_mode; -- doing this bcoz the user specified mode is to be given prio.
l_datetrack_update_mode := 'CORRECTION';
update_taxcard (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_tc => p_element_entry_id_tc
,p_taxcard_type => p_taxcard_type
,p_method_of_receipt => p_method_of_receipt
,p_base_rate => p_base_rate
,p_tax_municipality => p_tax_municipality
,p_additional_rate => p_additional_rate
,p_override_manual_upd => p_override_manual_upd
,p_previous_income => p_previous_income
,p_yearly_income_limit => p_yearly_income_limit
,p_date_returned => p_date_returned
,p_registration_date => p_registration_date
,p_lower_income_percentage => p_lower_income_percentage
,p_input_value_id1 => p_input_value_id1
,p_input_value_id2 => p_input_value_id2
,p_input_value_id3 => p_input_value_id3
,p_input_value_id4 => p_input_value_id4
,p_input_value_id5 => p_input_value_id5
,p_input_value_id6 => p_input_value_id6
,p_input_value_id7 => p_input_value_id7
,p_input_value_id8 => p_input_value_id8
,p_input_value_id9 => p_input_value_id9
,p_input_value_id10 => p_input_value_id10
,p_input_value_id11 => p_input_value_id11
,p_datetrack_update_mode => l_datetrack_update_mode
,p_object_version_number => p_object_version_number_tc);
insert_taxcard ( p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_tc => p_element_entry_id_tc
,p_taxcard_type => p_taxcard_type
,p_method_of_receipt => p_method_of_receipt
,p_base_rate => p_base_rate
,p_tax_municipality => p_tax_municipality
,p_additional_rate => p_additional_rate
,p_override_manual_upd => p_override_manual_upd
,p_previous_income => p_previous_income
,p_yearly_income_limit => p_yearly_income_limit
,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
,p_lower_income_percentage => p_lower_income_percentage);
l_datetrack_update_mode := p_datetrack_update_mode; -- doing this bcoz the user specified mode is to be given prio.
l_datetrack_update_mode := 'CORRECTION';
update_tax (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_t => p_element_entry_id_t
,p_primary_employment => p_primary_employment
,p_extra_income_rate => p_extra_income_rate
,p_extra_income_add_rate => p_extra_income_add_rate
,p_extra_income_limit => p_extra_income_limit
,p_prev_extra_income => p_prev_extra_income
,p_input_value_id1 => p_input_value_id12
,p_input_value_id2 => p_input_value_id13
,p_input_value_id3 => p_input_value_id14
,p_input_value_id4 => p_input_value_id15
,p_input_value_id5 => p_input_value_id16
,p_datetrack_update_mode => p_datetrack_update_mode
,p_object_version_number => p_object_version_number_t);
insert_tax (
p_legislation_code => p_legislation_code
,p_effective_date => p_effective_date
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_business_group_id => p_business_group_id
,p_element_entry_id_t => p_element_entry_id_t
,p_primary_employment => p_primary_employment
,p_extra_income_rate => p_extra_income_rate
,p_extra_income_add_rate => p_extra_income_add_rate
,p_extra_income_limit => p_extra_income_limit
,p_prev_extra_income => p_prev_extra_income);
PROCEDURE update_taxcard (
p_legislation_code IN VARCHAR2
,p_effective_date IN DATE
,p_assignment_id IN VARCHAR2
,p_person_id IN VARCHAR2
,p_business_group_id IN VARCHAR2
,p_element_entry_id_tc IN VARCHAR2
,p_taxcard_type IN VARCHAR2 DEFAULT NULL
,p_method_of_receipt IN VARCHAR2 DEFAULT NULL
,p_base_rate IN NUMBER DEFAULT NULL
,p_tax_municipality IN VARCHAR2 DEFAULT NULL
,p_additional_rate IN NUMBER DEFAULT NULL
,p_override_manual_upd IN VARCHAR2 DEFAULT NULL
,p_previous_income IN NUMBER DEFAULT NULL
,p_yearly_income_limit IN NUMBER DEFAULT NULL
,p_date_returned IN DATE DEFAULT NULL
,p_registration_date IN DATE DEFAULT NULL
,p_lower_income_percentage IN NUMBER DEFAULT NULL
,p_input_value_id1 IN VARCHAR2 DEFAULT NULL
,p_input_value_id2 IN VARCHAR2 DEFAULT NULL
,p_input_value_id3 IN VARCHAR2 DEFAULT NULL
,p_input_value_id4 IN VARCHAR2 DEFAULT NULL
,p_input_value_id5 IN VARCHAR2 DEFAULT NULL
,p_input_value_id6 IN VARCHAR2 DEFAULT NULL
,p_input_value_id7 IN VARCHAR2 DEFAULT NULL
,p_input_value_id8 IN VARCHAR2 DEFAULT NULL
,p_input_value_id9 IN VARCHAR2 DEFAULT NULL
,p_input_value_id10 IN VARCHAR2 DEFAULT NULL
,p_input_value_id11 IN VARCHAR2 DEFAULT NULL
,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL
,p_object_version_number IN VARCHAR2) IS
--declarations here
l_start_date DATE;
l_proc varchar2(72) := g_package||'update_taxcard';
pay_element_entry_api.update_element_entry
(p_validate => FALSE
,p_object_version_number => l_ovn
,p_update_warning => l_warning
,p_datetrack_update_mode => p_datetrack_update_mode
,p_effective_date => p_effective_date
,p_business_group_id => p_business_group_id
,p_input_value_id1 => p_input_value_id1
,p_input_value_id2 => p_input_value_id2
,p_input_value_id3 => p_input_value_id3
,p_input_value_id4 => p_input_value_id4
,p_input_value_id5 => p_input_value_id5
,p_input_value_id6 => p_input_value_id6
,p_input_value_id7 => p_input_value_id7
,p_input_value_id8 => p_input_value_id8
,p_input_value_id9 => p_input_value_id9
,p_input_value_id10 => p_input_value_id10
,p_input_value_id11 => p_input_value_id11
,p_entry_value1 => p_taxcard_type
,p_entry_value2 => p_method_of_receipt
,p_entry_value3 => p_base_rate
,p_entry_value4 => p_tax_municipality
,p_entry_value5 => p_additional_rate
,p_entry_value6 => p_override_manual_upd
,p_entry_value7 => p_previous_income
,p_entry_value8 => p_yearly_income_limit
,p_entry_value9 => p_date_returned
,p_entry_value10 => p_registration_date
,p_entry_value11 => p_lower_income_percentage
,p_effective_start_date => l_start_date
,p_effective_end_date => l_end_date
,p_element_entry_id => l_element_entry_id
,p_cost_allocation_keyflex_id => hr_api.g_number
,p_updating_action_id => hr_api.g_number
,p_original_entry_id => hr_api.g_number
,p_creator_type => hr_api.g_varchar2
,p_comment_id => hr_api.g_number
,p_creator_id => hr_api.g_number
,p_reason => hr_api.g_varchar2
,p_subpriority => hr_api.g_number
,p_date_earned => hr_api.g_date
,p_personal_payment_method_id => hr_api.g_number
,p_attribute_category => hr_api.g_varchar2
,p_attribute1 => hr_api.g_varchar2
,p_attribute2 => hr_api.g_varchar2
,p_attribute3 => hr_api.g_varchar2
,p_attribute4 => hr_api.g_varchar2
,p_attribute5 => hr_api.g_varchar2
,p_attribute6 => hr_api.g_varchar2
,p_attribute7 => hr_api.g_varchar2
,p_attribute8 => hr_api.g_varchar2
,p_attribute9 => hr_api.g_varchar2
,p_attribute10 => hr_api.g_varchar2
,p_attribute11 => hr_api.g_varchar2
,p_attribute12 => hr_api.g_varchar2
,p_attribute13 => hr_api.g_varchar2
,p_attribute14 => hr_api.g_varchar2
,p_attribute15 => hr_api.g_varchar2
,p_attribute16 => hr_api.g_varchar2
,p_attribute17 => hr_api.g_varchar2
,p_attribute18 => hr_api.g_varchar2
,p_attribute19 => hr_api.g_varchar2
,p_attribute20 => hr_api.g_varchar2
,p_updating_action_type => hr_api.g_varchar2
,p_entry_information_category => hr_api.g_varchar2
,p_entry_information1 => hr_api.g_varchar2
,p_entry_information2 => hr_api.g_varchar2
,p_entry_information3 => hr_api.g_varchar2
,p_entry_information4 => hr_api.g_varchar2
,p_entry_information5 => hr_api.g_varchar2
,p_entry_information6 => hr_api.g_varchar2
,p_entry_information7 => hr_api.g_varchar2
,p_entry_information8 => hr_api.g_varchar2
,p_entry_information9 => hr_api.g_varchar2
,p_entry_information10 => hr_api.g_varchar2
,p_entry_information11 => hr_api.g_varchar2
,p_entry_information12 => hr_api.g_varchar2
,p_entry_information13 => hr_api.g_varchar2
,p_entry_information14 => hr_api.g_varchar2
,p_entry_information15 => hr_api.g_varchar2
,p_entry_information16 => hr_api.g_varchar2
,p_entry_information17 => hr_api.g_varchar2
,p_entry_information18 => hr_api.g_varchar2
,p_entry_information19 => hr_api.g_varchar2
,p_entry_information20 => hr_api.g_varchar2
,p_entry_information21 => hr_api.g_varchar2
,p_entry_information22 => hr_api.g_varchar2
,p_entry_information23 => hr_api.g_varchar2
,p_entry_information24 => hr_api.g_varchar2
,p_entry_information25 => hr_api.g_varchar2
,p_entry_information26 => hr_api.g_varchar2
,p_entry_information27 => hr_api.g_varchar2
,p_entry_information28 => hr_api.g_varchar2
,p_entry_information29 => hr_api.g_varchar2
,p_entry_information30 => hr_api.g_varchar2);
END update_taxcard;
PROCEDURE update_tax (
p_legislation_code IN VARCHAR2
,p_effective_date IN DATE
,p_assignment_id IN VARCHAR2
,p_person_id IN VARCHAR2
,p_business_group_id IN VARCHAR2
,p_element_entry_id_t IN VARCHAR2
,p_primary_employment IN VARCHAR2 DEFAULT NULL
,p_extra_income_rate IN NUMBER DEFAULT NULL
,p_extra_income_add_rate IN NUMBER DEFAULT NULL
,p_extra_income_limit IN NUMBER DEFAULT NULL
,p_prev_extra_income IN NUMBER DEFAULT NULL
,p_input_value_id1 IN VARCHAR2 DEFAULT NULL
,p_input_value_id2 IN VARCHAR2 DEFAULT NULL
,p_input_value_id3 IN VARCHAR2 DEFAULT NULL
,p_input_value_id4 IN VARCHAR2 DEFAULT NULL
,p_input_value_id5 IN VARCHAR2 DEFAULT NULL
,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL
,p_object_version_number IN VARCHAR2) IS
--declarations here
l_start_date DATE;
l_proc varchar2(72) := g_package||'update_tax';
pay_element_entry_api.update_element_entry
(p_validate => FALSE
,p_object_version_number => l_ovn
,p_update_warning => l_warning
,p_datetrack_update_mode => p_datetrack_update_mode
,p_effective_date => p_effective_date
,p_business_group_id => p_business_group_id
,p_input_value_id1 => p_input_value_id1
,p_input_value_id2 => p_input_value_id2
,p_input_value_id3 => p_input_value_id3
,p_input_value_id4 => p_input_value_id4
,p_input_value_id5 => p_input_value_id5
,p_entry_value1 => p_primary_employment
,p_entry_value2 => p_extra_income_rate
,p_entry_value3 => p_extra_income_add_rate
,p_entry_value4 => p_extra_income_limit
,p_entry_value5 => p_prev_extra_income
,p_effective_start_date => l_start_date
,p_effective_end_date => l_end_date
,p_element_entry_id => l_element_entry_id
,p_cost_allocation_keyflex_id => hr_api.g_number
,p_updating_action_id => hr_api.g_number
,p_original_entry_id => hr_api.g_number
,p_creator_type => hr_api.g_varchar2
,p_comment_id => hr_api.g_number
,p_creator_id => hr_api.g_number
,p_reason => hr_api.g_varchar2
,p_subpriority => hr_api.g_number
,p_date_earned => hr_api.g_date
,p_personal_payment_method_id => hr_api.g_number
,p_attribute_category => hr_api.g_varchar2
,p_attribute1 => hr_api.g_varchar2
,p_attribute2 => hr_api.g_varchar2
,p_attribute3 => hr_api.g_varchar2
,p_attribute4 => hr_api.g_varchar2
,p_attribute5 => hr_api.g_varchar2
,p_attribute6 => hr_api.g_varchar2
,p_attribute7 => hr_api.g_varchar2
,p_attribute8 => hr_api.g_varchar2
,p_attribute9 => hr_api.g_varchar2
,p_attribute10 => hr_api.g_varchar2
,p_attribute11 => hr_api.g_varchar2
,p_attribute12 => hr_api.g_varchar2
,p_attribute13 => hr_api.g_varchar2
,p_attribute14 => hr_api.g_varchar2
,p_attribute15 => hr_api.g_varchar2
,p_attribute16 => hr_api.g_varchar2
,p_attribute17 => hr_api.g_varchar2
,p_attribute18 => hr_api.g_varchar2
,p_attribute19 => hr_api.g_varchar2
,p_attribute20 => hr_api.g_varchar2
,p_updating_action_type => hr_api.g_varchar2
,p_entry_information_category => hr_api.g_varchar2
,p_entry_information1 => hr_api.g_varchar2
,p_entry_information2 => hr_api.g_varchar2
,p_entry_information3 => hr_api.g_varchar2
,p_entry_information4 => hr_api.g_varchar2
,p_entry_information5 => hr_api.g_varchar2
,p_entry_information6 => hr_api.g_varchar2
,p_entry_information7 => hr_api.g_varchar2
,p_entry_information8 => hr_api.g_varchar2
,p_entry_information9 => hr_api.g_varchar2
,p_entry_information10 => hr_api.g_varchar2
,p_entry_information11 => hr_api.g_varchar2
,p_entry_information12 => hr_api.g_varchar2
,p_entry_information13 => hr_api.g_varchar2
,p_entry_information14 => hr_api.g_varchar2
,p_entry_information15 => hr_api.g_varchar2
,p_entry_information16 => hr_api.g_varchar2
,p_entry_information17 => hr_api.g_varchar2
,p_entry_information18 => hr_api.g_varchar2
,p_entry_information19 => hr_api.g_varchar2
,p_entry_information20 => hr_api.g_varchar2
,p_entry_information21 => hr_api.g_varchar2
,p_entry_information22 => hr_api.g_varchar2
,p_entry_information23 => hr_api.g_varchar2
,p_entry_information24 => hr_api.g_varchar2
,p_entry_information25 => hr_api.g_varchar2
,p_entry_information26 => hr_api.g_varchar2
,p_entry_information27 => hr_api.g_varchar2
,p_entry_information28 => hr_api.g_varchar2
,p_entry_information29 => hr_api.g_varchar2
,p_entry_information30 => hr_api.g_varchar2);
END update_tax;
SELECT pee.element_entry_id
FROM pay_element_types_f pet ,
pay_element_links_f pel ,
pay_element_entries_f pee
WHERE pet.element_name = l_element_name
AND pet.legislation_code = 'FI'
AND pet.business_group_id IS NULL
AND fnd_date.canonical_to_date(l_effective_date)
BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pel.element_type_id = pet.element_type_id
AND pel.business_group_id = l_business_grp_id
AND fnd_date.canonical_to_date(l_effective_date)
BETWEEN pel.effective_start_date AND pel.effective_end_date
AND pee.element_link_id = pel.element_link_id
AND fnd_date.canonical_to_date(l_effective_date)
BETWEEN pee.effective_start_date AND pee.effective_end_date
AND pee.assignment_id = l_asgid;
select pee.element_entry_id
from pay_element_entries_f pee,
pay_element_types_f pet
where pee.element_type_id = pet.element_type_id
and pet.element_name = c_element_name
and c_effective_date between pet.effective_start_date and pet.effective_end_date
and pee.assignment_id = c_asg_id
and c_effective_date between pee.effective_start_date and pee.effective_end_date
and pee.effective_start_date = c_effective_date;
SELECT asg.primary_flag
FROM per_all_assignments_f asg
WHERE asg.assignment_id = asgid
AND fnd_date.chardate_to_date(effective_date) BETWEEN
asg.effective_start_date AND asg.effective_end_date;
SELECT pee.element_entry_id
FROM pay_element_types_f pet ,
pay_element_links_f pel ,
pay_element_entries_f pee
WHERE pet.element_name = l_element_name
AND pet.legislation_code = 'FI'
AND pet.business_group_id IS NULL
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pel.element_type_id = pet.element_type_id
AND pel.business_group_id = l_business_grp_id
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pel.effective_start_date AND pel.effective_end_date
AND pee.element_link_id = pel.element_link_id
AND fnd_date.chardate_to_date(l_effective_date)
BETWEEN pee.effective_start_date AND pee.effective_end_date
AND pee.assignment_id = l_asgid;
,p_update OUT NOCOPY BOOLEAN
,p_update_override OUT NOCOPY BOOLEAN
,p_update_change_insert OUT NOCOPY BOOLEAN
,p_correction_start_date OUT NOCOPY DATE
,p_correction_end_date OUT NOCOPY DATE
,p_update_start_date OUT NOCOPY DATE
,p_update_end_date OUT NOCOPY DATE
,p_override_start_date OUT NOCOPY DATE
,p_override_end_date OUT NOCOPY DATE
,p_upd_chg_start_date OUT NOCOPY DATE
,p_upd_chg_end_date OUT NOCOPY DATE
) IS
l_proc varchar2(72) := g_package||'find_dt_upd_modes';
,p_update => p_update
,p_update_override => p_update_override
,p_update_change_insert => p_update_change_insert
,p_correction_start_date => p_correction_start_date
,p_correction_end_date => p_correction_end_date
,p_update_start_date => p_update_start_date
,p_update_end_date => p_update_end_date
,p_override_start_date => p_override_start_date
,p_override_end_date => p_override_end_date
,p_upd_chg_start_date => p_upd_chg_start_date
,p_upd_chg_end_date => p_upd_chg_end_date);