[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy per_pml_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into per_objectives_library
(objective_id
,object_version_number
,objective_name
,valid_from
,valid_to
,target_date
,next_review_date
,group_code
,priority_code
,appraise_flag
,weighting_percent
,measurement_style_code
,measure_name
,target_value
,uom_code
,measure_type_code
,measure_comments
,eligibility_type_code
,details
,success_criteria
,comments
,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
)
Values
(p_rec.objective_id
,p_rec.object_version_number
,p_rec.objective_name
,p_rec.valid_from
,p_rec.valid_to
,p_rec.target_date
,p_rec.next_review_date
,p_rec.group_code
,p_rec.priority_code
,p_rec.appraise_flag
,p_rec.weighting_percent
,p_rec.measurement_style_code
,p_rec.measure_name
,p_rec.target_value
,p_rec.uom_code
,p_rec.measure_type_code
,p_rec.measure_comments
,p_rec.eligibility_type_code
,p_rec.details
,p_rec.success_criteria
,p_rec.comments
,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
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy per_pml_shd.g_rec_type
) is
--
Cursor C_Sel1 is select per_objectives_library_s.nextval from sys.dual;
Select null
from per_objectives_library
where objective_id =
per_pml_ins.g_objective_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_pml_shd.g_rec_type
,p_duplicate_name_warning in boolean
,p_weighting_over_100_warning in boolean
,p_weighting_appraisal_warning in boolean
) is
--
l_proc varchar2(72) := g_package||'post_insert';
per_pml_rki.after_insert
(p_effective_date => p_effective_date
,p_objective_id
=> p_rec.objective_id
,p_object_version_number
=> p_rec.object_version_number
,p_objective_name
=> p_rec.objective_name
,p_valid_from
=> p_rec.valid_from
,p_valid_to
=> p_rec.valid_to
,p_target_date
=> p_rec.target_date
,p_next_review_date
=> p_rec.next_review_date
,p_group_code
=> p_rec.group_code
,p_priority_code
=> p_rec.priority_code
,p_appraise_flag
=> p_rec.appraise_flag
,p_weighting_percent
=> p_rec.weighting_percent
,p_measurement_style_code
=> p_rec.measurement_style_code
,p_measure_name
=> p_rec.measure_name
,p_target_value
=> p_rec.target_value
,p_uom_code
=> p_rec.uom_code
,p_measure_type_code
=> p_rec.measure_type_code
,p_measure_comments
=> p_rec.measure_comments
,p_eligibility_type_code
=> p_rec.eligibility_type_code
,p_details
=> p_rec.details
,p_success_criteria
=> p_rec.success_criteria
,p_comments
=> p_rec.comments
,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_duplicate_name_warning
=> p_duplicate_name_warning
,p_weighting_over_100_warning
=> p_weighting_over_100_warning
,p_weighting_appraisal_warning
=> p_weighting_appraisal_warning
);
End post_insert;
per_pml_bus.insert_validate
(p_effective_date
,p_rec
,p_duplicate_name_warning
,p_weighting_over_100_warning
,p_weighting_appraisal_warning
);
per_pml_ins.pre_insert(p_rec);
per_pml_ins.insert_dml(p_rec);
per_pml_ins.post_insert
(p_effective_date => p_effective_date
,p_rec => p_rec
,p_duplicate_name_warning => p_duplicate_name_warning
,p_weighting_over_100_warning => p_weighting_over_100_warning
,p_weighting_appraisal_warning => p_weighting_appraisal_warning
);