The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy psp_erd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update psp_eff_report_details
set
effort_report_detail_id = p_rec.effort_report_detail_id
,effort_report_id = p_rec.effort_report_id
,object_version_number = p_rec.object_version_number
,assignment_id = p_rec.assignment_id
,assignment_number = p_rec.assignment_number
,gl_sum_criteria_segment_name = p_rec.gl_sum_criteria_segment_name
,gl_segment1 = p_rec.gl_segment1
,gl_segment2 = p_rec.gl_segment2
,gl_segment3 = p_rec.gl_segment3
,gl_segment4 = p_rec.gl_segment4
,gl_segment5 = p_rec.gl_segment5
,gl_segment6 = p_rec.gl_segment6
,gl_segment7 = p_rec.gl_segment7
,gl_segment8 = p_rec.gl_segment8
,gl_segment9 = p_rec.gl_segment9
,gl_segment10 = p_rec.gl_segment10
,gl_segment11 = p_rec.gl_segment11
,gl_segment12 = p_rec.gl_segment12
,gl_segment13 = p_rec.gl_segment13
,gl_segment14 = p_rec.gl_segment14
,gl_segment15 = p_rec.gl_segment15
,gl_segment16 = p_rec.gl_segment16
,gl_segment17 = p_rec.gl_segment17
,gl_segment18 = p_rec.gl_segment18
,gl_segment19 = p_rec.gl_segment19
,gl_segment20 = p_rec.gl_segment20
,gl_segment21 = p_rec.gl_segment21
,gl_segment22 = p_rec.gl_segment22
,gl_segment23 = p_rec.gl_segment23
,gl_segment24 = p_rec.gl_segment24
,gl_segment25 = p_rec.gl_segment25
,gl_segment26 = p_rec.gl_segment26
,gl_segment27 = p_rec.gl_segment27
,gl_segment28 = p_rec.gl_segment28
,gl_segment29 = p_rec.gl_segment29
,gl_segment30 = p_rec.gl_segment30
,project_id = p_rec.project_id
,project_number = p_rec.project_number
,project_name = p_rec.project_name
,expenditure_organization_id = p_rec.expenditure_organization_id
,exp_org_name = p_rec.exp_org_name
,expenditure_type = p_rec.expenditure_type
,task_id = p_rec.task_id
,task_number = p_rec.task_number
,task_name = p_rec.task_name
,award_id = p_rec.award_id
,award_number = p_rec.award_number
,award_short_name = p_rec.award_short_name
,actual_salary_amt = p_rec.actual_salary_amt
,payroll_percent = p_rec.payroll_percent
,proposed_salary_amt = p_rec.proposed_salary_amt
,proposed_effort_percent = p_rec.proposed_effort_percent
,committed_cost_share = p_rec.committed_cost_share
,schedule_start_date = p_rec.schedule_start_date
,schedule_end_date = p_rec.schedule_end_date
,ame_transaction_id = p_rec.ame_transaction_id
,investigator_name = p_rec.investigator_name
,investigator_person_id = p_rec.investigator_person_id
,investigator_org_name = p_rec.investigator_org_name
,investigator_primary_org_id = p_rec.investigator_primary_org_id
,value1 = p_rec.value1
,value2 = p_rec.value2
,value3 = p_rec.value3
,value4 = p_rec.value4
,value5 = p_rec.value5
,value6 = p_rec.value6
,value7 = p_rec.value7
,value8 = p_rec.value8
,value9 = p_rec.value9
,value10 = p_rec.value10
,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
,grouping_category = p_rec.grouping_category
where effort_report_detail_id = p_rec.effort_report_detail_id;
End update_dml;
Procedure pre_update
(p_rec in psp_erd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in psp_erd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
psp_erd_rku.after_update
(p_effort_report_detail_id
=> p_rec.effort_report_detail_id
,p_effort_report_id
=> p_rec.effort_report_id
,p_object_version_number
=> p_rec.object_version_number
,p_assignment_id
=> p_rec.assignment_id
,p_assignment_number
=> p_rec.assignment_number
,p_gl_sum_criteria_segment_name
=> p_rec.gl_sum_criteria_segment_name
,p_gl_segment1
=> p_rec.gl_segment1
,p_gl_segment2
=> p_rec.gl_segment2
,p_gl_segment3
=> p_rec.gl_segment3
,p_gl_segment4
=> p_rec.gl_segment4
,p_gl_segment5
=> p_rec.gl_segment5
,p_gl_segment6
=> p_rec.gl_segment6
,p_gl_segment7
=> p_rec.gl_segment7
,p_gl_segment8
=> p_rec.gl_segment8
,p_gl_segment9
=> p_rec.gl_segment9
,p_gl_segment10
=> p_rec.gl_segment10
,p_gl_segment11
=> p_rec.gl_segment11
,p_gl_segment12
=> p_rec.gl_segment12
,p_gl_segment13
=> p_rec.gl_segment13
,p_gl_segment14
=> p_rec.gl_segment14
,p_gl_segment15
=> p_rec.gl_segment15
,p_gl_segment16
=> p_rec.gl_segment16
,p_gl_segment17
=> p_rec.gl_segment17
,p_gl_segment18
=> p_rec.gl_segment18
,p_gl_segment19
=> p_rec.gl_segment19
,p_gl_segment20
=> p_rec.gl_segment20
,p_gl_segment21
=> p_rec.gl_segment21
,p_gl_segment22
=> p_rec.gl_segment22
,p_gl_segment23
=> p_rec.gl_segment23
,p_gl_segment24
=> p_rec.gl_segment24
,p_gl_segment25
=> p_rec.gl_segment25
,p_gl_segment26
=> p_rec.gl_segment26
,p_gl_segment27
=> p_rec.gl_segment27
,p_gl_segment28
=> p_rec.gl_segment28
,p_gl_segment29
=> p_rec.gl_segment29
,p_gl_segment30
=> p_rec.gl_segment30
,p_project_id
=> p_rec.project_id
,p_project_number
=> p_rec.project_number
,p_project_name
=> p_rec.project_name
,p_expenditure_organization_id
=> p_rec.expenditure_organization_id
,p_exp_org_name
=> p_rec.exp_org_name
,p_expenditure_type
=> p_rec.expenditure_type
,p_task_id
=> p_rec.task_id
,p_task_number
=> p_rec.task_number
,p_task_name
=> p_rec.task_name
,p_award_id
=> p_rec.award_id
,p_award_number
=> p_rec.award_number
,p_award_short_name
=> p_rec.award_short_name
,p_actual_salary_amt
=> p_rec.actual_salary_amt
,p_payroll_percent
=> p_rec.payroll_percent
,p_proposed_salary_amt
=> p_rec.proposed_salary_amt
,p_proposed_effort_percent
=> p_rec.proposed_effort_percent
,p_committed_cost_share
=> p_rec.committed_cost_share
,p_schedule_start_date
=> p_rec.schedule_start_date
,p_schedule_end_date
=> p_rec.schedule_end_date
,p_ame_transaction_id
=> p_rec.ame_transaction_id
,p_investigator_name
=> p_rec.investigator_name
,p_investigator_person_id
=> p_rec.investigator_person_id
,p_investigator_org_name
=> p_rec.investigator_org_name
,p_investigator_primary_org_id
=> p_rec.investigator_primary_org_id
,p_value1
=> p_rec.value1
,p_value2
=> p_rec.value2
,p_value3
=> p_rec.value3
,p_value4
=> p_rec.value4
,p_value5
=> p_rec.value5
,p_value6
=> p_rec.value6
,p_value7
=> p_rec.value7
,p_value8
=> p_rec.value8
,p_value9
=> p_rec.value9
,p_value10
=> p_rec.value10
,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_grouping_category
=> p_rec.grouping_category
,p_effort_report_id_o
=> psp_erd_shd.g_old_rec.effort_report_id
,p_object_version_number_o
=> psp_erd_shd.g_old_rec.object_version_number
,p_assignment_id_o
=> psp_erd_shd.g_old_rec.assignment_id
,p_assignment_number_o
=> psp_erd_shd.g_old_rec.assignment_number
,p_gl_sum_criteria_segment_na_o
=> psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name
,p_gl_segment1_o
=> psp_erd_shd.g_old_rec.gl_segment1
,p_gl_segment2_o
=> psp_erd_shd.g_old_rec.gl_segment2
,p_gl_segment3_o
=> psp_erd_shd.g_old_rec.gl_segment3
,p_gl_segment4_o
=> psp_erd_shd.g_old_rec.gl_segment4
,p_gl_segment5_o
=> psp_erd_shd.g_old_rec.gl_segment5
,p_gl_segment6_o
=> psp_erd_shd.g_old_rec.gl_segment6
,p_gl_segment7_o
=> psp_erd_shd.g_old_rec.gl_segment7
,p_gl_segment8_o
=> psp_erd_shd.g_old_rec.gl_segment8
,p_gl_segment9_o
=> psp_erd_shd.g_old_rec.gl_segment9
,p_gl_segment10_o
=> psp_erd_shd.g_old_rec.gl_segment10
,p_gl_segment11_o
=> psp_erd_shd.g_old_rec.gl_segment11
,p_gl_segment12_o
=> psp_erd_shd.g_old_rec.gl_segment12
,p_gl_segment13_o
=> psp_erd_shd.g_old_rec.gl_segment13
,p_gl_segment14_o
=> psp_erd_shd.g_old_rec.gl_segment14
,p_gl_segment15_o
=> psp_erd_shd.g_old_rec.gl_segment15
,p_gl_segment16_o
=> psp_erd_shd.g_old_rec.gl_segment16
,p_gl_segment17_o
=> psp_erd_shd.g_old_rec.gl_segment17
,p_gl_segment18_o
=> psp_erd_shd.g_old_rec.gl_segment18
,p_gl_segment19_o
=> psp_erd_shd.g_old_rec.gl_segment19
,p_gl_segment20_o
=> psp_erd_shd.g_old_rec.gl_segment20
,p_gl_segment21_o
=> psp_erd_shd.g_old_rec.gl_segment21
,p_gl_segment22_o
=> psp_erd_shd.g_old_rec.gl_segment22
,p_gl_segment23_o
=> psp_erd_shd.g_old_rec.gl_segment23
,p_gl_segment24_o
=> psp_erd_shd.g_old_rec.gl_segment24
,p_gl_segment25_o
=> psp_erd_shd.g_old_rec.gl_segment25
,p_gl_segment26_o
=> psp_erd_shd.g_old_rec.gl_segment26
,p_gl_segment27_o
=> psp_erd_shd.g_old_rec.gl_segment27
,p_gl_segment28_o
=> psp_erd_shd.g_old_rec.gl_segment28
,p_gl_segment29_o
=> psp_erd_shd.g_old_rec.gl_segment29
,p_gl_segment30_o
=> psp_erd_shd.g_old_rec.gl_segment30
,p_project_id_o
=> psp_erd_shd.g_old_rec.project_id
,p_project_number_o
=> psp_erd_shd.g_old_rec.project_number
,p_project_name_o
=> psp_erd_shd.g_old_rec.project_name
,p_expenditure_organization_i_o
=> psp_erd_shd.g_old_rec.expenditure_organization_id
,p_exp_org_name_o
=> psp_erd_shd.g_old_rec.exp_org_name
,p_expenditure_type_o
=> psp_erd_shd.g_old_rec.expenditure_type
,p_task_id_o
=> psp_erd_shd.g_old_rec.task_id
,p_task_number_o
=> psp_erd_shd.g_old_rec.task_number
,p_task_name_o
=> psp_erd_shd.g_old_rec.task_name
,p_award_id_o
=> psp_erd_shd.g_old_rec.award_id
,p_award_number_o
=> psp_erd_shd.g_old_rec.award_number
,p_award_short_name_o
=> psp_erd_shd.g_old_rec.award_short_name
,p_actual_salary_amt_o
=> psp_erd_shd.g_old_rec.actual_salary_amt
,p_payroll_percent_o
=> psp_erd_shd.g_old_rec.payroll_percent
,p_proposed_salary_amt_o
=> psp_erd_shd.g_old_rec.proposed_salary_amt
,p_proposed_effort_percent_o
=> psp_erd_shd.g_old_rec.proposed_effort_percent
,p_committed_cost_share_o
=> psp_erd_shd.g_old_rec.committed_cost_share
,p_schedule_start_date_o
=> psp_erd_shd.g_old_rec.schedule_start_date
,p_schedule_end_date_o
=> psp_erd_shd.g_old_rec.schedule_end_date
,p_ame_transaction_id_o
=> psp_erd_shd.g_old_rec.ame_transaction_id
,p_investigator_name_o
=> psp_erd_shd.g_old_rec.investigator_name
,p_investigator_person_id_o
=> psp_erd_shd.g_old_rec.investigator_person_id
,p_investigator_org_name_o
=> psp_erd_shd.g_old_rec.investigator_org_name
,p_investigator_primary_org_i_o
=> psp_erd_shd.g_old_rec.investigator_primary_org_id
,p_value1_o
=> psp_erd_shd.g_old_rec.value1
,p_value2_o
=> psp_erd_shd.g_old_rec.value2
,p_value3_o
=> psp_erd_shd.g_old_rec.value3
,p_value4_o
=> psp_erd_shd.g_old_rec.value4
,p_value5_o
=> psp_erd_shd.g_old_rec.value5
,p_value6_o
=> psp_erd_shd.g_old_rec.value6
,p_value7_o
=> psp_erd_shd.g_old_rec.value7
,p_value8_o
=> psp_erd_shd.g_old_rec.value8
,p_value9_o
=> psp_erd_shd.g_old_rec.value9
,p_value10_o
=> psp_erd_shd.g_old_rec.value10
,p_attribute1_o
=> psp_erd_shd.g_old_rec.attribute1
,p_attribute2_o
=> psp_erd_shd.g_old_rec.attribute2
,p_attribute3_o
=> psp_erd_shd.g_old_rec.attribute3
,p_attribute4_o
=> psp_erd_shd.g_old_rec.attribute4
,p_attribute5_o
=> psp_erd_shd.g_old_rec.attribute5
,p_attribute6_o
=> psp_erd_shd.g_old_rec.attribute6
,p_attribute7_o
=> psp_erd_shd.g_old_rec.attribute7
,p_attribute8_o
=> psp_erd_shd.g_old_rec.attribute8
,p_attribute9_o
=> psp_erd_shd.g_old_rec.attribute9
,p_attribute10_o
=> psp_erd_shd.g_old_rec.attribute10
,p_grouping_category_o
=> psp_erd_shd.g_old_rec.grouping_category
);
End post_update;
psp_erd_bus.update_validate
(p_rec
);
psp_erd_upd.pre_update(p_rec);
psp_erd_upd.update_dml(p_rec);
psp_erd_upd.post_update
(p_rec
);