The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy psp_prt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update psp_report_templates
set
template_id = p_rec.template_id
,template_name = p_rec.template_name
,business_group_id = p_rec.business_group_id
,set_of_books_id = p_rec.set_of_books_id
,object_version_number = p_rec.object_version_number
,report_type = p_rec.report_type
,period_frequency_id = p_rec.period_frequency_id
,report_template_code = p_rec.report_template_code
,display_all_emp_distrib_flag = p_rec.display_all_emp_distrib_flag
,manual_entry_override_flag = p_rec.manual_entry_override_flag
,approval_type = p_rec.approval_type
,custom_approval_code = p_rec.custom_approval_code
,sup_levels = p_rec.sup_levels
,preview_effort_report_flag = p_rec.preview_effort_report_flag
,notification_reminder_in_days = p_rec.notification_reminder_in_days
,sprcd_tolerance_amt = p_rec.sprcd_tolerance_amt
,sprcd_tolerance_percent = p_rec.sprcd_tolerance_percent
,description = p_rec.description
,legislation_code = p_rec.legislation_code
,hundred_pcent_eff_at_per_asg = p_rec.hundred_pcent_eff_at_per_asg
,selection_match_level = p_rec.selection_match_level
where template_id = p_rec.template_id;
End update_dml;
Procedure pre_update
(p_rec in psp_prt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in psp_prt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
psp_prt_rku.after_update
(p_template_id
=> p_rec.template_id
,p_template_name
=> p_rec.template_name
,p_business_group_id
=> p_rec.business_group_id
,p_set_of_books_id
=> p_rec.set_of_books_id
,p_object_version_number
=> p_rec.object_version_number
,p_report_type
=> p_rec.report_type
,p_period_frequency_id
=> p_rec.period_frequency_id
,p_report_template_code
=> p_rec.report_template_code
,p_display_all_emp_distrib_flag
=> p_rec.display_all_emp_distrib_flag
,p_manual_entry_override_flag
=> p_rec.manual_entry_override_flag
,p_approval_type
=> p_rec.approval_type
,p_custom_approval_code
=> p_rec.custom_approval_code
,p_sup_levels
=> p_rec.sup_levels
,p_preview_effort_report_flag
=> p_rec.preview_effort_report_flag
,p_notification_reminder_in_day
=> p_rec.notification_reminder_in_days
,p_sprcd_tolerance_amt
=> p_rec.sprcd_tolerance_amt
,p_sprcd_tolerance_percent
=> p_rec.sprcd_tolerance_percent
,p_description
=> p_rec.description
,p_legislation_code
=> p_rec.legislation_code
,p_hundred_pcent_eff_at_per_asg
=> p_rec.hundred_pcent_eff_at_per_asg
,p_selection_match_level
=> p_rec.selection_match_level
,p_template_name_o
=> psp_prt_shd.g_old_rec.template_name
,p_business_group_id_o
=> psp_prt_shd.g_old_rec.business_group_id
,p_set_of_books_id_o
=> psp_prt_shd.g_old_rec.set_of_books_id
,p_object_version_number_o
=> psp_prt_shd.g_old_rec.object_version_number
,p_report_type_o
=> psp_prt_shd.g_old_rec.report_type
,p_period_frequency_id_o
=> psp_prt_shd.g_old_rec.period_frequency_id
,p_report_template_code_o
=> psp_prt_shd.g_old_rec.report_template_code
,p_display_all_emp_distrib_fl_o
=> psp_prt_shd.g_old_rec.display_all_emp_distrib_flag
,p_manual_entry_override_flag_o
=> psp_prt_shd.g_old_rec.manual_entry_override_flag
,p_approval_type_o
=> psp_prt_shd.g_old_rec.approval_type
,p_custom_approval_code_o
=> psp_prt_shd.g_old_rec.custom_approval_code
,p_sup_levels_o
=> psp_prt_shd.g_old_rec.sup_levels
,p_preview_effort_report_flag_o
=> psp_prt_shd.g_old_rec.preview_effort_report_flag
,p_notification_reminder_in_d_o
=> psp_prt_shd.g_old_rec.notification_reminder_in_days
,p_sprcd_tolerance_amt_o
=> psp_prt_shd.g_old_rec.sprcd_tolerance_amt
,p_sprcd_tolerance_percent_o
=> psp_prt_shd.g_old_rec.sprcd_tolerance_percent
,p_description_o
=> psp_prt_shd.g_old_rec.description
,p_legislation_code_o
=> psp_prt_shd.g_old_rec.legislation_code
,p_hundred_pcent_eff_at_per_a_o
=> psp_prt_shd.g_old_rec.hundred_pcent_eff_at_per_asg
,p_selection_match_level_o
=> psp_prt_shd.g_old_rec.selection_match_level
);
End post_update;
If (p_rec.selection_match_level = hr_api.g_varchar2) then
p_rec.selection_match_level :=
psp_prt_shd.g_old_rec.selection_match_level;
psp_prt_bus.update_validate
(p_rec
);
psp_prt_upd.pre_update(p_rec);
psp_prt_upd.update_dml(p_rec);
psp_prt_upd.post_update
(p_rec
);
,p_selection_match_level in varchar2 default hr_api.g_varchar2
,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
,p_custom_approval_code in varchar2 default hr_api.g_varchar2
,p_sup_levels in number default hr_api.g_number
,p_notification_reminder_in_day in number default hr_api.g_number
,p_sprcd_tolerance_amt in number default hr_api.g_number
,p_sprcd_tolerance_percent in number default hr_api.g_number
,p_description in varchar2 default hr_api.g_varchar2
,p_legislation_code in varchar2 default hr_api.g_varchar2
) is
--
l_rec psp_prt_shd.g_rec_type;
,p_selection_match_level
);