[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy pay_pay_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||'dt_update_dml';
update pay_all_payrolls_f
set
payroll_id = p_rec.payroll_id
,default_payment_method_id = p_rec.default_payment_method_id
,business_group_id = p_rec.business_group_id
,consolidation_set_id = p_rec.consolidation_set_id
,cost_allocation_keyflex_id = p_rec.cost_allocation_keyflex_id
,suspense_account_keyflex_id = p_rec.suspense_account_keyflex_id
,gl_set_of_books_id = p_rec.gl_set_of_books_id
,soft_coding_keyflex_id = p_rec.soft_coding_keyflex_id
,period_type = p_rec.period_type
,organization_id = p_rec.organization_id
,cut_off_date_offset = p_rec.cut_off_date_offset
,direct_deposit_date_offset = p_rec.direct_deposit_date_offset
,first_period_end_date = p_rec.first_period_end_date
,negative_pay_allowed_flag = p_rec.negative_pay_allowed_flag
,number_of_years = p_rec.number_of_years
,pay_advice_date_offset = p_rec.pay_advice_date_offset
,pay_date_offset = p_rec.pay_date_offset
,payroll_name = p_rec.payroll_name
,workload_shifting_level = p_rec.workload_shifting_level
,comment_id = p_rec.comment_id
,midpoint_offset = p_rec.midpoint_offset
,attribute_category = p_rec.attribute_category
,attribute1 = p_rec.attribute1
,attribute2 = p_rec.attribute2
,attribute3 = p_rec.attribute3
,attribute4 = p_rec.attribute4
,attribute5 = p_rec.attribute5
,attribute6 = p_rec.attribute6
,attribute7 = p_rec.attribute7
,attribute8 = p_rec.attribute8
,attribute9 = p_rec.attribute9
,attribute10 = p_rec.attribute10
,attribute11 = p_rec.attribute11
,attribute12 = p_rec.attribute12
,attribute13 = p_rec.attribute13
,attribute14 = p_rec.attribute14
,attribute15 = p_rec.attribute15
,attribute16 = p_rec.attribute16
,attribute17 = p_rec.attribute17
,attribute18 = p_rec.attribute18
,attribute19 = p_rec.attribute19
,attribute20 = p_rec.attribute20
,arrears_flag = p_rec.arrears_flag
,payroll_type = p_rec.payroll_type
,prl_information_category = p_rec.prl_information_category
,prl_information1 = p_rec.prl_information1
,prl_information2 = p_rec.prl_information2
,prl_information3 = p_rec.prl_information3
,prl_information4 = p_rec.prl_information4
,prl_information5 = p_rec.prl_information5
,prl_information6 = p_rec.prl_information6
,prl_information7 = p_rec.prl_information7
,prl_information8 = p_rec.prl_information8
,prl_information9 = p_rec.prl_information9
,prl_information10 = p_rec.prl_information10
,prl_information11 = p_rec.prl_information11
,prl_information12 = p_rec.prl_information12
,prl_information13 = p_rec.prl_information13
,prl_information14 = p_rec.prl_information14
,prl_information15 = p_rec.prl_information15
,prl_information16 = p_rec.prl_information16
,prl_information17 = p_rec.prl_information17
,prl_information18 = p_rec.prl_information18
,prl_information19 = p_rec.prl_information19
,prl_information20 = p_rec.prl_information20
,prl_information21 = p_rec.prl_information21
,prl_information22 = p_rec.prl_information22
,prl_information23 = p_rec.prl_information23
,prl_information24 = p_rec.prl_information24
,prl_information25 = p_rec.prl_information25
,prl_information26 = p_rec.prl_information26
,prl_information27 = p_rec.prl_information27
,prl_information28 = p_rec.prl_information28
,prl_information29 = p_rec.prl_information29
,prl_information30 = p_rec.prl_information30
,multi_assignments_flag = p_rec.multi_assignments_flag
,period_reset_years = p_rec.period_reset_years
,object_version_number = p_rec.object_version_number
,payslip_view_date_offset = p_rec.payslip_view_date_offset
where payroll_id = p_rec.payroll_id
and effective_start_date = p_validation_start_date
and effective_end_date = p_validation_end_date;
'pay_payrolls_f_pkg.update_row');
End dt_update_dml;
Procedure update_dml
(p_rec in out nocopy pay_pay_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||'update_dml';
pay_pay_upd.dt_update_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 update_dml;
Procedure dt_pre_update
(p_rec in out nocopy pay_pay_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||'dt_pre_update';
If (p_datetrack_mode = hr_api.g_update_override) then
--
-- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
-- delete any future rows
--
pay_pay_del.delete_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
);
pay_pay_ins.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 dt_pre_update;
Procedure pre_update
(p_rec in out nocopy pay_pay_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_update';
dt_pre_update
(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 pre_update;
Procedure post_update
(p_rec in pay_pay_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_update';
null, -- last_update_date
null, -- last_updated_by
null, -- last_update_login
null, -- created_by
null, -- creation_date
p_effective_date -- effective_date
);*/
pay_pay_rku.after_update
(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
,p_payroll_id => p_rec.payroll_id
,p_effective_start_date => p_rec.effective_start_date
,p_effective_end_date => p_rec.effective_end_date
,p_default_payment_method_id => p_rec.default_payment_method_id
,p_consolidation_set_id => p_rec.consolidation_set_id
,p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id
,p_suspense_account_keyflex_id => p_rec.suspense_account_keyflex_id
,p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id
,p_negative_pay_allowed_flag => p_rec.negative_pay_allowed_flag
,p_number_of_years => p_rec.number_of_years
,p_payroll_name => p_rec.payroll_name
,p_workload_shifting_level => p_rec.workload_shifting_level
,p_comment_id => p_rec.comment_id
,p_comments => p_rec.comments
,p_attribute_category => p_rec.attribute_category
,p_attribute1 => p_rec.attribute1
,p_attribute2 => p_rec.attribute2
,p_attribute3 => p_rec.attribute3
,p_attribute4 => p_rec.attribute4
,p_attribute5 => p_rec.attribute5
,p_attribute6 => p_rec.attribute6
,p_attribute7 => p_rec.attribute7
,p_attribute8 => p_rec.attribute8
,p_attribute9 => p_rec.attribute9
,p_attribute10 => p_rec.attribute10
,p_attribute11 => p_rec.attribute11
,p_attribute12 => p_rec.attribute12
,p_attribute13 => p_rec.attribute13
,p_attribute14 => p_rec.attribute14
,p_attribute15 => p_rec.attribute15
,p_attribute16 => p_rec.attribute16
,p_attribute17 => p_rec.attribute17
,p_attribute18 => p_rec.attribute18
,p_attribute19 => p_rec.attribute19
,p_attribute20 => p_rec.attribute20
,p_arrears_flag => p_rec.arrears_flag
,p_prl_information_category => p_rec.prl_information_category
,p_prl_information1 => p_rec.prl_information1
,p_prl_information2 => p_rec.prl_information2
,p_prl_information3 => p_rec.prl_information3
,p_prl_information4 => p_rec.prl_information4
,p_prl_information5 => p_rec.prl_information5
,p_prl_information6 => p_rec.prl_information6
,p_prl_information7 => p_rec.prl_information7
,p_prl_information8 => p_rec.prl_information8
,p_prl_information9 => p_rec.prl_information9
,p_prl_information10 => p_rec.prl_information10
,p_prl_information11 => p_rec.prl_information11
,p_prl_information12 => p_rec.prl_information12
,p_prl_information13 => p_rec.prl_information13
,p_prl_information14 => p_rec.prl_information14
,p_prl_information15 => p_rec.prl_information15
,p_prl_information16 => p_rec.prl_information16
,p_prl_information17 => p_rec.prl_information17
,p_prl_information18 => p_rec.prl_information18
,p_prl_information19 => p_rec.prl_information19
,p_prl_information20 => p_rec.prl_information20
,p_prl_information21 => p_rec.prl_information21
,p_prl_information22 => p_rec.prl_information22
,p_prl_information23 => p_rec.prl_information23
,p_prl_information24 => p_rec.prl_information24
,p_prl_information25 => p_rec.prl_information25
,p_prl_information26 => p_rec.prl_information26
,p_prl_information27 => p_rec.prl_information27
,p_prl_information28 => p_rec.prl_information28
,p_prl_information29 => p_rec.prl_information29
,p_prl_information30 => p_rec.prl_information30
,p_multi_assignments_flag => p_rec.multi_assignments_flag
,p_object_version_number => p_rec.object_version_number
,p_payslip_view_date_offset => p_rec.payslip_view_date_offset
,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
,p_period_type_o => pay_pay_shd.g_old_rec.period_type
,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
,p_comments_o => pay_pay_shd.g_old_rec.comments
,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
);
End post_update;
pay_pay_bus.update_validate
(p_rec => l_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pre_update
(p_rec => l_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
update_dml
(p_rec => l_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
post_update
(p_rec => l_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);