[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into psp_eff_report_approvals
(effort_report_approval_id
,effort_report_detail_id
,wf_role_name
,wf_orig_system_id
,wf_orig_system
,approver_order_num
,approval_status
,response_date
,actual_cost_share
,overwritten_effort_percent
,wf_item_key
,comments
,pera_information_category
,pera_information1
,pera_information2
,pera_information3
,pera_information4
,pera_information5
,pera_information6
,pera_information7
,pera_information8
,pera_information9
,pera_information10
,pera_information11
,pera_information12
,pera_information13
,pera_information14
,pera_information15
,pera_information16
,pera_information17
,pera_information18
,pera_information19
,pera_information20
,wf_role_display_name
,object_version_number
,notification_id
,eff_information_category
,eff_information1
,eff_information2
,eff_information3
,eff_information4
,eff_information5
,eff_information6
,eff_information7
,eff_information8
,eff_information9
,eff_information10
,eff_information11
,eff_information12
,eff_information13
,eff_information14
,eff_information15
)
Values
(p_rec.effort_report_approval_id
,p_rec.effort_report_detail_id
,p_rec.wf_role_name
,p_rec.wf_orig_system_id
,p_rec.wf_orig_system
,p_rec.approver_order_num
,p_rec.approval_status
,p_rec.response_date
,p_rec.actual_cost_share
,p_rec.overwritten_effort_percent
,p_rec.wf_item_key
,p_rec.comments
,p_rec.pera_information_category
,p_rec.pera_information1
,p_rec.pera_information2
,p_rec.pera_information3
,p_rec.pera_information4
,p_rec.pera_information5
,p_rec.pera_information6
,p_rec.pera_information7
,p_rec.pera_information8
,p_rec.pera_information9
,p_rec.pera_information10
,p_rec.pera_information11
,p_rec.pera_information12
,p_rec.pera_information13
,p_rec.pera_information14
,p_rec.pera_information15
,p_rec.pera_information16
,p_rec.pera_information17
,p_rec.pera_information18
,p_rec.pera_information19
,p_rec.pera_information20
,p_rec.wf_role_display_name
,p_rec.object_version_number
,p_rec.notification_id
,p_rec.eff_information_category
,p_rec.eff_information1
,p_rec.eff_information2
,p_rec.eff_information3
,p_rec.eff_information4
,p_rec.eff_information5
,p_rec.eff_information6
,p_rec.eff_information7
,p_rec.eff_information8
,p_rec.eff_information9
,p_rec.eff_information10
,p_rec.eff_information11
,p_rec.eff_information12
,p_rec.eff_information13
,p_rec.eff_information14
,p_rec.eff_information15
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy psp_era_shd.g_rec_type
) is
--
Cursor C_Sel1 is select psp_eff_report_approvals_s.nextval from sys.dual;
Select null
from psp_eff_report_approvals
where effort_report_approval_id =
psp_era_ins.g_effort_report_approval_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_rec in psp_era_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
psp_era_rki.after_insert
(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
);
End post_insert;
psp_era_bus.insert_validate
(p_rec
);
psp_era_ins.pre_insert(p_rec);
psp_era_ins.insert_dml(p_rec);
psp_era_ins.post_insert
(p_rec
);