[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy psp_erd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into psp_eff_report_details
(effort_report_detail_id
,effort_report_id
,object_version_number
,assignment_id
,assignment_number
,gl_sum_criteria_segment_name
,gl_segment1
,gl_segment2
,gl_segment3
,gl_segment4
,gl_segment5
,gl_segment6
,gl_segment7
,gl_segment8
,gl_segment9
,gl_segment10
,gl_segment11
,gl_segment12
,gl_segment13
,gl_segment14
,gl_segment15
,gl_segment16
,gl_segment17
,gl_segment18
,gl_segment19
,gl_segment20
,gl_segment21
,gl_segment22
,gl_segment23
,gl_segment24
,gl_segment25
,gl_segment26
,gl_segment27
,gl_segment28
,gl_segment29
,gl_segment30
,project_id
,project_number
,project_name
,expenditure_organization_id
,exp_org_name
,expenditure_type
,task_id
,task_number
,task_name
,award_id
,award_number
,award_short_name
,actual_salary_amt
,payroll_percent
,proposed_salary_amt
,proposed_effort_percent
,committed_cost_share
,schedule_start_date
,schedule_end_date
,ame_transaction_id
,investigator_name
,investigator_person_id
,investigator_org_name
,investigator_primary_org_id
,value1
,value2
,value3
,value4
,value5
,value6
,value7
,value8
,value9
,value10
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,grouping_category
)
Values
(p_rec.effort_report_detail_id
,p_rec.effort_report_id
,p_rec.object_version_number
,p_rec.assignment_id
,p_rec.assignment_number
,p_rec.gl_sum_criteria_segment_name
,p_rec.gl_segment1
,p_rec.gl_segment2
,p_rec.gl_segment3
,p_rec.gl_segment4
,p_rec.gl_segment5
,p_rec.gl_segment6
,p_rec.gl_segment7
,p_rec.gl_segment8
,p_rec.gl_segment9
,p_rec.gl_segment10
,p_rec.gl_segment11
,p_rec.gl_segment12
,p_rec.gl_segment13
,p_rec.gl_segment14
,p_rec.gl_segment15
,p_rec.gl_segment16
,p_rec.gl_segment17
,p_rec.gl_segment18
,p_rec.gl_segment19
,p_rec.gl_segment20
,p_rec.gl_segment21
,p_rec.gl_segment22
,p_rec.gl_segment23
,p_rec.gl_segment24
,p_rec.gl_segment25
,p_rec.gl_segment26
,p_rec.gl_segment27
,p_rec.gl_segment28
,p_rec.gl_segment29
,p_rec.gl_segment30
,p_rec.project_id
,p_rec.project_number
,p_rec.project_name
,p_rec.expenditure_organization_id
,p_rec.exp_org_name
,p_rec.expenditure_type
,p_rec.task_id
,p_rec.task_number
,p_rec.task_name
,p_rec.award_id
,p_rec.award_number
,p_rec.award_short_name
,p_rec.actual_salary_amt
,p_rec.payroll_percent
,p_rec.proposed_salary_amt
,p_rec.proposed_effort_percent
,p_rec.committed_cost_share
,p_rec.schedule_start_date
,p_rec.schedule_end_date
,p_rec.ame_transaction_id
,p_rec.investigator_name
,p_rec.investigator_person_id
,p_rec.investigator_org_name
,p_rec.investigator_primary_org_id
,p_rec.value1
,p_rec.value2
,p_rec.value3
,p_rec.value4
,p_rec.value5
,p_rec.value6
,p_rec.value7
,p_rec.value8
,p_rec.value9
,p_rec.value10
,p_rec.attribute1
,p_rec.attribute2
,p_rec.attribute3
,p_rec.attribute4
,p_rec.attribute5
,p_rec.attribute6
,p_rec.attribute7
,p_rec.attribute8
,p_rec.attribute9
,p_rec.attribute10
,p_rec.grouping_category
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy psp_erd_shd.g_rec_type
) is
--
Cursor C_Sel1 is select psp_eff_report_details_s.nextval from sys.dual;
Select null
from psp_eff_report_details
where effort_report_detail_id =
psp_erd_ins.g_effort_report_detail_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_rec in psp_erd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
psp_erd_rki.after_insert
(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
);
End post_insert;
psp_erd_bus.insert_validate
(p_rec
);
psp_erd_ins.pre_insert(p_rec);
psp_erd_ins.insert_dml(p_rec);
psp_erd_ins.post_insert
(p_rec
);