[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update psp_eff_report_approvals
set
effort_report_approval_id = p_rec.effort_report_approval_id
,effort_report_detail_id = p_rec.effort_report_detail_id
,wf_role_name = p_rec.wf_role_name
,wf_orig_system_id = p_rec.wf_orig_system_id
,wf_orig_system = p_rec.wf_orig_system
,approver_order_num = p_rec.approver_order_num
,approval_status = p_rec.approval_status
,response_date = p_rec.response_date
,actual_cost_share = p_rec.actual_cost_share
,overwritten_effort_percent = p_rec.overwritten_effort_percent
,wf_item_key = p_rec.wf_item_key
,comments = p_rec.comments
,pera_information_category = p_rec.pera_information_category
,pera_information1 = p_rec.pera_information1
,pera_information2 = p_rec.pera_information2
,pera_information3 = p_rec.pera_information3
,pera_information4 = p_rec.pera_information4
,pera_information5 = p_rec.pera_information5
,pera_information6 = p_rec.pera_information6
,pera_information7 = p_rec.pera_information7
,pera_information8 = p_rec.pera_information8
,pera_information9 = p_rec.pera_information9
,pera_information10 = p_rec.pera_information10
,pera_information11 = p_rec.pera_information11
,pera_information12 = p_rec.pera_information12
,pera_information13 = p_rec.pera_information13
,pera_information14 = p_rec.pera_information14
,pera_information15 = p_rec.pera_information15
,pera_information16 = p_rec.pera_information16
,pera_information17 = p_rec.pera_information17
,pera_information18 = p_rec.pera_information18
,pera_information19 = p_rec.pera_information19
,pera_information20 = p_rec.pera_information20
,wf_role_display_name = p_rec.wf_role_display_name
,object_version_number = p_rec.object_version_number
,notification_id = p_rec.notification_id
,eff_information_category = p_rec.eff_information_category
,eff_information1 = p_rec.eff_information1
,eff_information2 = p_rec.eff_information2
,eff_information3 = p_rec.eff_information3
,eff_information4 = p_rec.eff_information4
,eff_information5 = p_rec.eff_information5
,eff_information6 = p_rec.eff_information6
,eff_information7 = p_rec.eff_information7
,eff_information8 = p_rec.eff_information8
,eff_information9 = p_rec.eff_information9
,eff_information10 = p_rec.eff_information10
,eff_information11 = p_rec.eff_information11
,eff_information12 = p_rec.eff_information12
,eff_information13 = p_rec.eff_information13
,eff_information14 = p_rec.eff_information14
,eff_information15 = p_rec.eff_information15
where effort_report_approval_id = p_rec.effort_report_approval_id;
End update_dml;
Procedure pre_update
(p_rec in psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
psp_era_rku.after_update
(p_effort_report_approval_id
=> p_rec.effort_report_approval_id
,p_effort_report_detail_id
=> p_rec.effort_report_detail_id
,p_wf_role_name
=> p_rec.wf_role_name
,p_wf_orig_system_id
=> p_rec.wf_orig_system_id
,p_wf_orig_system
=> p_rec.wf_orig_system
,p_approver_order_num
=> p_rec.approver_order_num
,p_approval_status
=> p_rec.approval_status
,p_response_date
=> p_rec.response_date
,p_actual_cost_share
=> p_rec.actual_cost_share
,p_overwritten_effort_percent
=> p_rec.overwritten_effort_percent
,p_wf_item_key
=> p_rec.wf_item_key
,p_comments
=> p_rec.comments
,p_pera_information_category
=> p_rec.pera_information_category
,p_pera_information1
=> p_rec.pera_information1
,p_pera_information2
=> p_rec.pera_information2
,p_pera_information3
=> p_rec.pera_information3
,p_pera_information4
=> p_rec.pera_information4
,p_pera_information5
=> p_rec.pera_information5
,p_pera_information6
=> p_rec.pera_information6
,p_pera_information7
=> p_rec.pera_information7
,p_pera_information8
=> p_rec.pera_information8
,p_pera_information9
=> p_rec.pera_information9
,p_pera_information10
=> p_rec.pera_information10
,p_pera_information11
=> p_rec.pera_information11
,p_pera_information12
=> p_rec.pera_information12
,p_pera_information13
=> p_rec.pera_information13
,p_pera_information14
=> p_rec.pera_information14
,p_pera_information15
=> p_rec.pera_information15
,p_pera_information16
=> p_rec.pera_information16
,p_pera_information17
=> p_rec.pera_information17
,p_pera_information18
=> p_rec.pera_information18
,p_pera_information19
=> p_rec.pera_information19
,p_pera_information20
=> p_rec.pera_information20
,p_wf_role_display_name
=> p_rec.wf_role_display_name
,p_object_version_number
=> p_rec.object_version_number
,p_notification_id
=> p_rec.notification_id
,p_eff_information_category
=> p_rec.eff_information_category
,p_eff_information1
=> p_rec.eff_information1
,p_eff_information2
=> p_rec.eff_information2
,p_eff_information3
=> p_rec.eff_information3
,p_eff_information4
=> p_rec.eff_information4
,p_eff_information5
=> p_rec.eff_information5
,p_eff_information6
=> p_rec.eff_information6
,p_eff_information7
=> p_rec.eff_information7
,p_eff_information8
=> p_rec.eff_information8
,p_eff_information9
=> p_rec.eff_information9
,p_eff_information10
=> p_rec.eff_information10
,p_eff_information11
=> p_rec.eff_information11
,p_eff_information12
=> p_rec.eff_information12
,p_eff_information13
=> p_rec.eff_information13
,p_eff_information14
=> p_rec.eff_information14
,p_eff_information15
=> p_rec.eff_information15
,p_effort_report_detail_id_o
=> psp_era_shd.g_old_rec.effort_report_detail_id
,p_wf_role_name_o
=> psp_era_shd.g_old_rec.wf_role_name
,p_wf_orig_system_id_o
=> psp_era_shd.g_old_rec.wf_orig_system_id
,p_wf_orig_system_o
=> psp_era_shd.g_old_rec.wf_orig_system
,p_approver_order_num_o
=> psp_era_shd.g_old_rec.approver_order_num
,p_approval_status_o
=> psp_era_shd.g_old_rec.approval_status
,p_response_date_o
=> psp_era_shd.g_old_rec.response_date
,p_actual_cost_share_o
=> psp_era_shd.g_old_rec.actual_cost_share
,p_overwritten_effort_percent_o
=> psp_era_shd.g_old_rec.overwritten_effort_percent
,p_wf_item_key_o
=> psp_era_shd.g_old_rec.wf_item_key
,p_comments_o
=> psp_era_shd.g_old_rec.comments
,p_pera_information_category_o
=> psp_era_shd.g_old_rec.pera_information_category
,p_pera_information1_o
=> psp_era_shd.g_old_rec.pera_information1
,p_pera_information2_o
=> psp_era_shd.g_old_rec.pera_information2
,p_pera_information3_o
=> psp_era_shd.g_old_rec.pera_information3
,p_pera_information4_o
=> psp_era_shd.g_old_rec.pera_information4
,p_pera_information5_o
=> psp_era_shd.g_old_rec.pera_information5
,p_pera_information6_o
=> psp_era_shd.g_old_rec.pera_information6
,p_pera_information7_o
=> psp_era_shd.g_old_rec.pera_information7
,p_pera_information8_o
=> psp_era_shd.g_old_rec.pera_information8
,p_pera_information9_o
=> psp_era_shd.g_old_rec.pera_information9
,p_pera_information10_o
=> psp_era_shd.g_old_rec.pera_information10
,p_pera_information11_o
=> psp_era_shd.g_old_rec.pera_information11
,p_pera_information12_o
=> psp_era_shd.g_old_rec.pera_information12
,p_pera_information13_o
=> psp_era_shd.g_old_rec.pera_information13
,p_pera_information14_o
=> psp_era_shd.g_old_rec.pera_information14
,p_pera_information15_o
=> psp_era_shd.g_old_rec.pera_information15
,p_pera_information16_o
=> psp_era_shd.g_old_rec.pera_information16
,p_pera_information17_o
=> psp_era_shd.g_old_rec.pera_information17
,p_pera_information18_o
=> psp_era_shd.g_old_rec.pera_information18
,p_pera_information19_o
=> psp_era_shd.g_old_rec.pera_information19
,p_pera_information20_o
=> psp_era_shd.g_old_rec.pera_information20
,p_wf_role_display_name_o
=> psp_era_shd.g_old_rec.wf_role_display_name
,p_object_version_number_o
=> psp_era_shd.g_old_rec.object_version_number
,p_notification_id_o
=> psp_era_shd.g_old_rec.notification_id
,p_eff_information_category_o
=> psp_era_shd.g_old_rec.eff_information_category
,p_eff_information1_o
=> psp_era_shd.g_old_rec.eff_information1
,p_eff_information2_o
=> psp_era_shd.g_old_rec.eff_information2
,p_eff_information3_o
=> psp_era_shd.g_old_rec.eff_information3
,p_eff_information4_o
=> psp_era_shd.g_old_rec.eff_information4
,p_eff_information5_o
=> psp_era_shd.g_old_rec.eff_information5
,p_eff_information6_o
=> psp_era_shd.g_old_rec.eff_information6
,p_eff_information7_o
=> psp_era_shd.g_old_rec.eff_information7
,p_eff_information8_o
=> psp_era_shd.g_old_rec.eff_information8
,p_eff_information9_o
=> psp_era_shd.g_old_rec.eff_information9
,p_eff_information10_o
=> psp_era_shd.g_old_rec.eff_information10
,p_eff_information11_o
=> psp_era_shd.g_old_rec.eff_information11
,p_eff_information12_o
=> psp_era_shd.g_old_rec.eff_information12
,p_eff_information13_o
=> psp_era_shd.g_old_rec.eff_information13
,p_eff_information14_o
=> psp_era_shd.g_old_rec.eff_information14
,p_eff_information15_o
=> psp_era_shd.g_old_rec.eff_information15
);
End post_update;
psp_era_bus.update_validate
(p_rec
);
psp_era_upd.pre_update(p_rec);
psp_era_upd.update_dml(p_rec);
psp_era_upd.post_update
(p_rec
);