The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy per_pmp_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into per_perf_mgmt_plans
(plan_id
,object_version_number
,plan_name
,administrator_person_id
,previous_plan_id
,start_date
,end_date
,status_code
,hierarchy_type_code
,supervisor_id
,supervisor_assignment_id
,organization_structure_id
,org_structure_version_id
,top_organization_id
,position_structure_id
,pos_structure_version_id
,top_position_id
,hierarchy_levels
,automatic_enrollment_flag
,assignment_types_code
,primary_asg_only_flag
,include_obj_setting_flag
,obj_setting_start_date
,obj_setting_deadline
,obj_set_outside_period_flag
,method_code
,notify_population_flag
,automatic_allocation_flag
,copy_past_objectives_flag
,sharing_alignment_task_flag
,include_appraisals_flag
,change_sc_status_flag
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,update_library_objectives -- 8740021 bug fix
,automatic_approval_flag
)
Values
(p_rec.plan_id
,p_rec.object_version_number
,p_rec.plan_name
,p_rec.administrator_person_id
,p_rec.previous_plan_id
,p_rec.start_date
,p_rec.end_date
,p_rec.status_code
,p_rec.hierarchy_type_code
,p_rec.supervisor_id
,p_rec.supervisor_assignment_id
,p_rec.organization_structure_id
,p_rec.org_structure_version_id
,p_rec.top_organization_id
,p_rec.position_structure_id
,p_rec.pos_structure_version_id
,p_rec.top_position_id
,p_rec.hierarchy_levels
,p_rec.automatic_enrollment_flag
,p_rec.assignment_types_code
,p_rec.primary_asg_only_flag
,p_rec.include_obj_setting_flag
,p_rec.obj_setting_start_date
,p_rec.obj_setting_deadline
,p_rec.obj_set_outside_period_flag
,p_rec.method_code
,p_rec.notify_population_flag
,p_rec.automatic_allocation_flag
,p_rec.copy_past_objectives_flag
,p_rec.sharing_alignment_task_flag
,p_rec.include_appraisals_flag
,p_rec.change_sc_status_flag
,p_rec.attribute_category
,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.attribute11
,p_rec.attribute12
,p_rec.attribute13
,p_rec.attribute14
,p_rec.attribute15
,p_rec.attribute16
,p_rec.attribute17
,p_rec.attribute18
,p_rec.attribute19
,p_rec.attribute20
,p_rec.attribute21
,p_rec.attribute22
,p_rec.attribute23
,p_rec.attribute24
,p_rec.attribute25
,p_rec.attribute26
,p_rec.attribute27
,p_rec.attribute28
,p_rec.attribute29
,p_rec.attribute30
,p_rec.update_library_objectives -- 8740021 bug fix
,p_rec.automatic_approval_flag
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy per_pmp_shd.g_rec_type
) is
--
Cursor C_Sel1 is select per_perf_mgmt_plans_s.nextval from sys.dual;
Select null
from per_perf_mgmt_plans
where plan_id =
per_pmp_ins.g_plan_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in per_pmp_shd.g_rec_type
,p_duplicate_name_warning in boolean
,p_no_life_events_warning in boolean
) is
--
l_proc varchar2(72) := g_package||'post_insert';
per_pmp_rki.after_insert
(p_effective_date => p_effective_date
,p_plan_id
=> p_rec.plan_id
,p_object_version_number
=> p_rec.object_version_number
,p_plan_name
=> p_rec.plan_name
,p_administrator_person_id
=> p_rec.administrator_person_id
,p_previous_plan_id
=> p_rec.previous_plan_id
,p_start_date
=> p_rec.start_date
,p_end_date
=> p_rec.end_date
,p_status_code
=> p_rec.status_code
,p_hierarchy_type_code
=> p_rec.hierarchy_type_code
,p_supervisor_id
=> p_rec.supervisor_id
,p_supervisor_assignment_id
=> p_rec.supervisor_assignment_id
,p_organization_structure_id
=> p_rec.organization_structure_id
,p_org_structure_version_id
=> p_rec.org_structure_version_id
,p_top_organization_id
=> p_rec.top_organization_id
,p_position_structure_id
=> p_rec.position_structure_id
,p_pos_structure_version_id
=> p_rec.pos_structure_version_id
,p_top_position_id
=> p_rec.top_position_id
,p_hierarchy_levels
=> p_rec.hierarchy_levels
,p_automatic_enrollment_flag
=> p_rec.automatic_enrollment_flag
,p_assignment_types_code
=> p_rec.assignment_types_code
,p_primary_asg_only_flag
=> p_rec.primary_asg_only_flag
,p_include_obj_setting_flag
=> p_rec.include_obj_setting_flag
,p_obj_setting_start_date
=> p_rec.obj_setting_start_date
,p_obj_setting_deadline
=> p_rec.obj_setting_deadline
,p_obj_set_outside_period_flag
=> p_rec.obj_set_outside_period_flag
,p_method_code
=> p_rec.method_code
,p_notify_population_flag
=> p_rec.notify_population_flag
,p_automatic_allocation_flag
=> p_rec.automatic_allocation_flag
,p_copy_past_objectives_flag
=> p_rec.copy_past_objectives_flag
,p_sharing_alignment_task_flag
=> p_rec.sharing_alignment_task_flag
,p_include_appraisals_flag
=> p_rec.include_appraisals_flag
,p_change_sc_status_flag => p_rec.change_sc_status_flag
,p_attribute_category
=> p_rec.attribute_category
,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_attribute11
=> p_rec.attribute11
,p_attribute12
=> p_rec.attribute12
,p_attribute13
=> p_rec.attribute13
,p_attribute14
=> p_rec.attribute14
,p_attribute15
=> p_rec.attribute15
,p_attribute16
=> p_rec.attribute16
,p_attribute17
=> p_rec.attribute17
,p_attribute18
=> p_rec.attribute18
,p_attribute19
=> p_rec.attribute19
,p_attribute20
=> p_rec.attribute20
,p_attribute21
=> p_rec.attribute21
,p_attribute22
=> p_rec.attribute22
,p_attribute23
=> p_rec.attribute23
,p_attribute24
=> p_rec.attribute24
,p_attribute25
=> p_rec.attribute25
,p_attribute26
=> p_rec.attribute26
,p_attribute27
=> p_rec.attribute27
,p_attribute28
=> p_rec.attribute28
,p_attribute29
=> p_rec.attribute29
,p_attribute30
=> p_rec.attribute30
,p_update_library_objectives
=> p_rec.update_library_objectives -- 8740021 bug fix
,p_automatic_approval_flag
=> p_rec.automatic_approval_flag
);
End post_insert;
per_pmp_bus.insert_validate
(p_effective_date
,p_rec
,p_duplicate_name_warning
,p_no_life_events_warning
);
per_pmp_ins.pre_insert(p_rec);
per_pmp_ins.insert_dml(p_rec);
per_pmp_ins.post_insert
(p_effective_date
,p_rec
,p_duplicate_name_warning
,p_no_life_events_warning
);
,p_update_library_objectives in varchar2 default null -- 8740021 bug fix
,p_automatic_approval_flag in varchar2 default null
) is
--
l_rec per_pmp_shd.g_rec_type;
,p_update_library_objectives -- 8740021 bug fix
,p_automatic_approval_flag
);