The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_dml
(p_rec in out nocopy pay_cft_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
-- Cursor to select 'old' created AOL who column values
--
Cursor C_Sel1 Is
select t.created_by,
t.creation_date
from pay_ca_emp_fed_tax_info_f t
where t.emp_fed_tax_inf_id = p_rec.emp_fed_tax_inf_id
and t.effective_start_date =
pay_cft_shd.g_old_rec.effective_start_date
and t.effective_end_date = (p_validation_start_date - 1);
l_proc varchar2(72) := g_package||'dt_insert_dml';
l_last_update_date pay_ca_emp_fed_tax_info_f.last_update_date%TYPE;
l_last_updated_by pay_ca_emp_fed_tax_info_f.last_updated_by%TYPE;
l_last_update_login pay_ca_emp_fed_tax_info_f.last_update_login%TYPE;
If (p_datetrack_mode <> 'INSERT') then
hr_utility.set_location(l_proc, 10);
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
insert into pay_ca_emp_fed_tax_info_f
( emp_fed_tax_inf_id,
effective_start_date,
effective_end_date,
legislation_code,
assignment_id,
business_group_id,
employment_province,
tax_credit_amount,
claim_code,
basic_exemption_flag,
additional_tax,
annual_dedn,
total_expense_by_commission,
total_remnrtn_by_commission,
prescribed_zone_dedn_amt,
other_fedtax_credits,
cpp_qpp_exempt_flag,
fed_exempt_flag,
ei_exempt_flag,
tax_calc_method,
fed_override_amount,
fed_override_rate,
ca_tax_information_category,
ca_tax_information1,
ca_tax_information2,
ca_tax_information3,
ca_tax_information4,
ca_tax_information5,
ca_tax_information6,
ca_tax_information7,
ca_tax_information8,
ca_tax_information9,
ca_tax_information10,
ca_tax_information11,
ca_tax_information12,
ca_tax_information13,
ca_tax_information14,
ca_tax_information15,
ca_tax_information16,
ca_tax_information17,
ca_tax_information18,
ca_tax_information19,
ca_tax_information20,
ca_tax_information21,
ca_tax_information22,
ca_tax_information23,
ca_tax_information24,
ca_tax_information25,
ca_tax_information26,
ca_tax_information27,
ca_tax_information28,
ca_tax_information29,
ca_tax_information30,
object_version_number,
fed_lsf_amount,
cpp_election_date, --For Bug Number 13258136
cpp_revocation_date, --For Bug Number 13258136
created_by,
creation_date,
last_update_date,
last_updated_by,
last_update_login
)
Values
( p_rec.emp_fed_tax_inf_id,
p_rec.effective_start_date,
p_rec.effective_end_date,
p_rec.legislation_code,
p_rec.assignment_id,
p_rec.business_group_id,
p_rec.employment_province,
p_rec.tax_credit_amount,
p_rec.claim_code,
p_rec.basic_exemption_flag,
p_rec.additional_tax,
p_rec.annual_dedn,
p_rec.total_expense_by_commission,
p_rec.total_remnrtn_by_commission,
p_rec.prescribed_zone_dedn_amt,
p_rec.other_fedtax_credits,
p_rec.cpp_qpp_exempt_flag,
p_rec.fed_exempt_flag,
p_rec.ei_exempt_flag,
p_rec.tax_calc_method,
p_rec.fed_override_amount,
p_rec.fed_override_rate,
p_rec.ca_tax_information_category,
p_rec.ca_tax_information1,
p_rec.ca_tax_information2,
p_rec.ca_tax_information3,
p_rec.ca_tax_information4,
p_rec.ca_tax_information5,
p_rec.ca_tax_information6,
p_rec.ca_tax_information7,
p_rec.ca_tax_information8,
p_rec.ca_tax_information9,
p_rec.ca_tax_information10,
p_rec.ca_tax_information11,
p_rec.ca_tax_information12,
p_rec.ca_tax_information13,
p_rec.ca_tax_information14,
p_rec.ca_tax_information15,
p_rec.ca_tax_information16,
p_rec.ca_tax_information17,
p_rec.ca_tax_information18,
p_rec.ca_tax_information19,
p_rec.ca_tax_information20,
p_rec.ca_tax_information21,
p_rec.ca_tax_information22,
p_rec.ca_tax_information23,
p_rec.ca_tax_information24,
p_rec.ca_tax_information25,
p_rec.ca_tax_information26,
p_rec.ca_tax_information27,
p_rec.ca_tax_information28,
p_rec.ca_tax_information29,
p_rec.ca_tax_information30,
p_rec.object_version_number,
p_rec.fed_lsf_amount,
p_rec.cpp_election_date, --For Bug Number 13258136
p_rec.cpp_revocation_date, --For Bug Number 13258136
l_created_by,
l_creation_date,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
End dt_insert_dml;
Procedure insert_dml
(p_rec in out nocopy pay_cft_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'insert_dml';
dt_insert_dml(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy pay_cft_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select pay_ca_emp_fed_tax_info_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert
(p_rec in pay_cft_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'post_insert';
pay_cft_rki.after_insert
(
p_emp_fed_tax_inf_id =>p_rec.emp_fed_tax_inf_id
,p_effective_start_date =>p_rec.effective_start_date
,p_effective_end_date =>p_rec.effective_end_date
,p_legislation_code =>p_rec.legislation_code
,p_assignment_id =>p_rec.assignment_id
,p_business_group_id =>p_rec.business_group_id
,p_employment_province =>p_rec.employment_province
,p_tax_credit_amount =>p_rec.tax_credit_amount
,p_claim_code =>p_rec.claim_code
,p_basic_exemption_flag =>p_rec.basic_exemption_flag
,p_additional_tax =>p_rec.additional_tax
,p_annual_dedn =>p_rec.annual_dedn
,p_total_expense_by_commission =>p_rec.total_expense_by_commission
,p_total_remnrtn_by_commission =>p_rec.total_remnrtn_by_commission
,p_prescribed_zone_dedn_amt =>p_rec.prescribed_zone_dedn_amt
,p_other_fedtax_credits =>p_rec.other_fedtax_credits
,p_cpp_qpp_exempt_flag =>p_rec.cpp_qpp_exempt_flag
,p_fed_exempt_flag =>p_rec.fed_exempt_flag
,p_ei_exempt_flag =>p_rec.ei_exempt_flag
,p_tax_calc_method =>p_rec.tax_calc_method
,p_fed_override_amount =>p_rec.fed_override_amount
,p_fed_override_rate =>p_rec.fed_override_rate
,p_ca_tax_information_category =>p_rec.ca_tax_information_category
,p_ca_tax_information1 =>p_rec.ca_tax_information1
,p_ca_tax_information2 =>p_rec.ca_tax_information2
,p_ca_tax_information3 =>p_rec.ca_tax_information3
,p_ca_tax_information4 =>p_rec.ca_tax_information4
,p_ca_tax_information5 =>p_rec.ca_tax_information5
,p_ca_tax_information6 =>p_rec.ca_tax_information6
,p_ca_tax_information7 =>p_rec.ca_tax_information7
,p_ca_tax_information8 =>p_rec.ca_tax_information8
,p_ca_tax_information9 =>p_rec.ca_tax_information9
,p_ca_tax_information10 =>p_rec.ca_tax_information10
,p_ca_tax_information11 =>p_rec.ca_tax_information11
,p_ca_tax_information12 =>p_rec.ca_tax_information12
,p_ca_tax_information13 =>p_rec.ca_tax_information13
,p_ca_tax_information14 =>p_rec.ca_tax_information14
,p_ca_tax_information15 =>p_rec.ca_tax_information15
,p_ca_tax_information16 =>p_rec.ca_tax_information16
,p_ca_tax_information17 =>p_rec.ca_tax_information17
,p_ca_tax_information18 =>p_rec.ca_tax_information18
,p_ca_tax_information19 =>p_rec.ca_tax_information19
,p_ca_tax_information20 =>p_rec.ca_tax_information20
,p_ca_tax_information21 =>p_rec.ca_tax_information21
,p_ca_tax_information22 =>p_rec.ca_tax_information22
,p_ca_tax_information23 =>p_rec.ca_tax_information23
,p_ca_tax_information24 =>p_rec.ca_tax_information24
,p_ca_tax_information25 =>p_rec.ca_tax_information25
,p_ca_tax_information26 =>p_rec.ca_tax_information26
,p_ca_tax_information27 =>p_rec.ca_tax_information27
,p_ca_tax_information28 =>p_rec.ca_tax_information28
,p_ca_tax_information29 =>p_rec.ca_tax_information29
,p_ca_tax_information30 =>p_rec.ca_tax_information30
,p_object_version_number =>p_rec.object_version_number
,p_fed_lsf_amount =>p_rec.fed_lsf_amount
,p_cpp_election_date =>p_rec.cpp_election_date --For Bug Number 13258136
,p_cpp_revocation_date =>p_rec.cpp_revocation_date --For Bug Number 13258136
,p_effective_date =>p_effective_date
,p_validation_start_date =>p_validation_start_date
,p_validation_end_date =>p_validation_end_date
);
End post_insert;
l_datetrack_mode varchar2(30) := 'INSERT';
pay_cft_bus.insert_validate
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
pre_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
select max(effective_start_date)
from per_assignments_f asg
where asg.assignment_id = asg_id;