The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
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
from per_perf_mgmt_plans
where plan_id = p_plan_id;
select
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
from per_perf_mgmt_plans
where plan_id = p_plan_id
for update nowait;
,p_update_library_objectives in varchar2 -- 8740021 bug fix
,p_automatic_approval_flag in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.update_library_objectives := p_update_library_objectives;