44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_ast_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: per_ast_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ast_shd.constraint_error
114: per_ast_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_ast_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_ast_shd.constraint_error
118: per_ast_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_ast_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: Raise;
126: End update_dml;
156: -- Internal Table Handler Use Only.
157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_update(p_rec in per_ast_shd.g_rec_type) is
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --
164: Begin
198: -- Internal Table Handler Use Only.
199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_update(p_rec in per_ast_shd.g_rec_type) is
203: --
204: l_proc varchar2(72) := g_package||'post_update';
205: --
206: Begin
252: p_type => p_rec.type ,
253: p_line_score_formula_id => p_rec.line_score_formula_id,
254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
253: p_line_score_formula_id => p_rec.line_score_formula_id,
254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
254: p_default_job_competencies => p_rec.default_job_competencies,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
255: p_available_flag => p_rec.available_flag,
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
256: p_business_group_id_o => per_ast_shd.g_old_rec.business_group_id ,
257: p_object_version_number_o => per_ast_shd.g_old_rec.object_version_number ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
258: p_name_o => per_ast_shd.g_old_rec.name ,
259: p_date_to_o => per_ast_shd.g_old_rec.date_to ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
260: p_date_from_o => per_ast_shd.g_old_rec.date_from ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
261: p_assessment_classification_o =>
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
262: per_ast_shd.g_old_rec.assessment_classification ,
263: p_display_assessment_comment_o =>
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
264: per_ast_shd.g_old_rec.display_assessment_comments ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
265: p_description_o => per_ast_shd.g_old_rec.description ,
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
266: p_rating_scale_comment_o => per_ast_shd.g_old_rec.rating_scale_comment ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
267: p_weighting_scale_comment_o =>
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
268: per_ast_shd.g_old_rec.weighting_scale_comment ,
269: p_comments_o => per_ast_shd.g_old_rec.comments ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
270: p_instructions_o => per_ast_shd.g_old_rec.instructions ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
271: p_line_score_formula_o => per_ast_shd.g_old_rec.line_score_formula ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
272: p_total_score_formula_o => per_ast_shd.g_old_rec.total_score_formula ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
273: p_weighting_classification_o =>
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
274: per_ast_shd.g_old_rec.weighting_classification ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
275: p_rating_scale_id_o => per_ast_shd.g_old_rec.rating_scale_id ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
276: p_weighting_scale_id_o => per_ast_shd.g_old_rec.weighting_scale_id ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
277: p_attribute_category_o => per_ast_shd.g_old_rec.attribute_category ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
278: p_attribute1_o => per_ast_shd.g_old_rec.attribute1 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
279: p_attribute2_o => per_ast_shd.g_old_rec.attribute2 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
280: p_attribute3_o => per_ast_shd.g_old_rec.attribute3 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
281: p_attribute4_o => per_ast_shd.g_old_rec.attribute4 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
282: p_attribute5_o => per_ast_shd.g_old_rec.attribute5 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
283: p_attribute6_o => per_ast_shd.g_old_rec.attribute6 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
284: p_attribute7_o => per_ast_shd.g_old_rec.attribute7 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
285: p_attribute8_o => per_ast_shd.g_old_rec.attribute8 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
286: p_attribute9_o => per_ast_shd.g_old_rec.attribute9 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
287: p_attribute10_o => per_ast_shd.g_old_rec.attribute10 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
288: p_attribute11_o => per_ast_shd.g_old_rec.attribute11 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
289: p_attribute12_o => per_ast_shd.g_old_rec.attribute12 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
290: p_attribute13_o => per_ast_shd.g_old_rec.attribute13 ,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
291: p_attribute14_o => per_ast_shd.g_old_rec.attribute14 ,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
292: p_attribute15_o => per_ast_shd.g_old_rec.attribute15 ,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
293: p_attribute16_o => per_ast_shd.g_old_rec.attribute16 ,
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
294: p_attribute17_o => per_ast_shd.g_old_rec.attribute17 ,
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
295: p_attribute18_o => per_ast_shd.g_old_rec.attribute18 ,
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:
296: p_attribute19_o => per_ast_shd.g_old_rec.attribute19 ,
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:
304: exception
297: p_attribute20_o => per_ast_shd.g_old_rec.attribute20 ,
298: p_type_o => per_ast_shd.g_old_rec.type,
299: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
300: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
301: p_available_flag_o => per_ast_shd.g_old_rec.available_flag
302: );
303:
304: exception
305: when hr_api.cannot_find_prog_unit then
357: -- Internal Table Handler Use Only.
358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure convert_defs(p_rec in out nocopy per_ast_shd.g_rec_type) is
362: --
363: l_proc varchar2(72) := g_package||'convert_defs';
364: --
365: Begin
372: -- is being used then we must set to the 'current' argument value.
373: --
374: If (p_rec.name = hr_api.g_varchar2) then
375: p_rec.name :=
376: per_ast_shd.g_old_rec.name;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: per_ast_shd.g_old_rec.business_group_id;
376: per_ast_shd.g_old_rec.name;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: per_ast_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.description = hr_api.g_varchar2) then
383: p_rec.description :=
384: per_ast_shd.g_old_rec.description;
380: per_ast_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.description = hr_api.g_varchar2) then
383: p_rec.description :=
384: per_ast_shd.g_old_rec.description;
385: End If;
386: If (p_rec.rating_scale_id = hr_api.g_number) then
387: p_rec.rating_scale_id :=
388: per_ast_shd.g_old_rec.rating_scale_id;
384: per_ast_shd.g_old_rec.description;
385: End If;
386: If (p_rec.rating_scale_id = hr_api.g_number) then
387: p_rec.rating_scale_id :=
388: per_ast_shd.g_old_rec.rating_scale_id;
389: End If;
390: If (p_rec.weighting_scale_id = hr_api.g_number) then
391: p_rec.weighting_scale_id :=
392: per_ast_shd.g_old_rec.weighting_scale_id;
388: per_ast_shd.g_old_rec.rating_scale_id;
389: End If;
390: If (p_rec.weighting_scale_id = hr_api.g_number) then
391: p_rec.weighting_scale_id :=
392: per_ast_shd.g_old_rec.weighting_scale_id;
393: End If;
394: If (p_rec.rating_scale_comment = hr_api.g_varchar2) then
395: p_rec.rating_scale_comment :=
396: per_ast_shd.g_old_rec.rating_scale_comment;
392: per_ast_shd.g_old_rec.weighting_scale_id;
393: End If;
394: If (p_rec.rating_scale_comment = hr_api.g_varchar2) then
395: p_rec.rating_scale_comment :=
396: per_ast_shd.g_old_rec.rating_scale_comment;
397: End If;
398: If (p_rec.weighting_scale_comment = hr_api.g_varchar2) then
399: p_rec.weighting_scale_comment :=
400: per_ast_shd.g_old_rec.weighting_scale_comment;
396: per_ast_shd.g_old_rec.rating_scale_comment;
397: End If;
398: If (p_rec.weighting_scale_comment = hr_api.g_varchar2) then
399: p_rec.weighting_scale_comment :=
400: per_ast_shd.g_old_rec.weighting_scale_comment;
401: End If;
402: If (p_rec.assessment_classification = hr_api.g_varchar2) then
403: p_rec.assessment_classification :=
404: per_ast_shd.g_old_rec.assessment_classification;
400: per_ast_shd.g_old_rec.weighting_scale_comment;
401: End If;
402: If (p_rec.assessment_classification = hr_api.g_varchar2) then
403: p_rec.assessment_classification :=
404: per_ast_shd.g_old_rec.assessment_classification;
405: End If;
406: If (p_rec.display_assessment_comments = hr_api.g_varchar2) then
407: p_rec.display_assessment_comments :=
408: per_ast_shd.g_old_rec.display_assessment_comments;
404: per_ast_shd.g_old_rec.assessment_classification;
405: End If;
406: If (p_rec.display_assessment_comments = hr_api.g_varchar2) then
407: p_rec.display_assessment_comments :=
408: per_ast_shd.g_old_rec.display_assessment_comments;
409: End If;
410: If (p_rec.date_from = hr_api.g_date) then
411: p_rec.date_from :=
412: per_ast_shd.g_old_rec.date_from;
408: per_ast_shd.g_old_rec.display_assessment_comments;
409: End If;
410: If (p_rec.date_from = hr_api.g_date) then
411: p_rec.date_from :=
412: per_ast_shd.g_old_rec.date_from;
413: End If;
414: If (p_rec.date_to = hr_api.g_date) then
415: p_rec.date_to :=
416: per_ast_shd.g_old_rec.date_to;
412: per_ast_shd.g_old_rec.date_from;
413: End If;
414: If (p_rec.date_to = hr_api.g_date) then
415: p_rec.date_to :=
416: per_ast_shd.g_old_rec.date_to;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_ast_shd.g_old_rec.comments;
416: per_ast_shd.g_old_rec.date_to;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_ast_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.instructions = hr_api.g_varchar2) then
423: p_rec.instructions :=
424: per_ast_shd.g_old_rec.instructions;
420: per_ast_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.instructions = hr_api.g_varchar2) then
423: p_rec.instructions :=
424: per_ast_shd.g_old_rec.instructions;
425: End If;
426: If (p_rec.weighting_classification = hr_api.g_varchar2) then
427: p_rec.weighting_classification :=
428: per_ast_shd.g_old_rec.weighting_classification;
424: per_ast_shd.g_old_rec.instructions;
425: End If;
426: If (p_rec.weighting_classification = hr_api.g_varchar2) then
427: p_rec.weighting_classification :=
428: per_ast_shd.g_old_rec.weighting_classification;
429: End If;
430: If (p_rec.line_score_formula = hr_api.g_varchar2) then
431: p_rec.line_score_formula :=
432: per_ast_shd.g_old_rec.line_score_formula;
428: per_ast_shd.g_old_rec.weighting_classification;
429: End If;
430: If (p_rec.line_score_formula = hr_api.g_varchar2) then
431: p_rec.line_score_formula :=
432: per_ast_shd.g_old_rec.line_score_formula;
433: End If;
434: If (p_rec.total_score_formula = hr_api.g_varchar2) then
435: p_rec.total_score_formula :=
436: per_ast_shd.g_old_rec.total_score_formula;
432: per_ast_shd.g_old_rec.line_score_formula;
433: End If;
434: If (p_rec.total_score_formula = hr_api.g_varchar2) then
435: p_rec.total_score_formula :=
436: per_ast_shd.g_old_rec.total_score_formula;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: per_ast_shd.g_old_rec.attribute_category;
436: per_ast_shd.g_old_rec.total_score_formula;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: per_ast_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: per_ast_shd.g_old_rec.attribute1;
440: per_ast_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: per_ast_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: per_ast_shd.g_old_rec.attribute2;
444: per_ast_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: per_ast_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: per_ast_shd.g_old_rec.attribute3;
448: per_ast_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: per_ast_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: per_ast_shd.g_old_rec.attribute4;
452: per_ast_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: per_ast_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: per_ast_shd.g_old_rec.attribute5;
456: per_ast_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: per_ast_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: per_ast_shd.g_old_rec.attribute6;
460: per_ast_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: per_ast_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: per_ast_shd.g_old_rec.attribute7;
464: per_ast_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: per_ast_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: per_ast_shd.g_old_rec.attribute8;
468: per_ast_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: per_ast_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: per_ast_shd.g_old_rec.attribute9;
472: per_ast_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: per_ast_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: per_ast_shd.g_old_rec.attribute10;
476: per_ast_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: per_ast_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.attribute11 = hr_api.g_varchar2) then
483: p_rec.attribute11 :=
484: per_ast_shd.g_old_rec.attribute11;
480: per_ast_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.attribute11 = hr_api.g_varchar2) then
483: p_rec.attribute11 :=
484: per_ast_shd.g_old_rec.attribute11;
485: End If;
486: If (p_rec.attribute12 = hr_api.g_varchar2) then
487: p_rec.attribute12 :=
488: per_ast_shd.g_old_rec.attribute12;
484: per_ast_shd.g_old_rec.attribute11;
485: End If;
486: If (p_rec.attribute12 = hr_api.g_varchar2) then
487: p_rec.attribute12 :=
488: per_ast_shd.g_old_rec.attribute12;
489: End If;
490: If (p_rec.attribute13 = hr_api.g_varchar2) then
491: p_rec.attribute13 :=
492: per_ast_shd.g_old_rec.attribute13;
488: per_ast_shd.g_old_rec.attribute12;
489: End If;
490: If (p_rec.attribute13 = hr_api.g_varchar2) then
491: p_rec.attribute13 :=
492: per_ast_shd.g_old_rec.attribute13;
493: End If;
494: If (p_rec.attribute14 = hr_api.g_varchar2) then
495: p_rec.attribute14 :=
496: per_ast_shd.g_old_rec.attribute14;
492: per_ast_shd.g_old_rec.attribute13;
493: End If;
494: If (p_rec.attribute14 = hr_api.g_varchar2) then
495: p_rec.attribute14 :=
496: per_ast_shd.g_old_rec.attribute14;
497: End If;
498: If (p_rec.attribute15 = hr_api.g_varchar2) then
499: p_rec.attribute15 :=
500: per_ast_shd.g_old_rec.attribute15;
496: per_ast_shd.g_old_rec.attribute14;
497: End If;
498: If (p_rec.attribute15 = hr_api.g_varchar2) then
499: p_rec.attribute15 :=
500: per_ast_shd.g_old_rec.attribute15;
501: End If;
502: If (p_rec.attribute16 = hr_api.g_varchar2) then
503: p_rec.attribute16 :=
504: per_ast_shd.g_old_rec.attribute16;
500: per_ast_shd.g_old_rec.attribute15;
501: End If;
502: If (p_rec.attribute16 = hr_api.g_varchar2) then
503: p_rec.attribute16 :=
504: per_ast_shd.g_old_rec.attribute16;
505: End If;
506: If (p_rec.attribute17 = hr_api.g_varchar2) then
507: p_rec.attribute17 :=
508: per_ast_shd.g_old_rec.attribute17;
504: per_ast_shd.g_old_rec.attribute16;
505: End If;
506: If (p_rec.attribute17 = hr_api.g_varchar2) then
507: p_rec.attribute17 :=
508: per_ast_shd.g_old_rec.attribute17;
509: End If;
510: If (p_rec.attribute18 = hr_api.g_varchar2) then
511: p_rec.attribute18 :=
512: per_ast_shd.g_old_rec.attribute18;
508: per_ast_shd.g_old_rec.attribute17;
509: End If;
510: If (p_rec.attribute18 = hr_api.g_varchar2) then
511: p_rec.attribute18 :=
512: per_ast_shd.g_old_rec.attribute18;
513: End If;
514: If (p_rec.attribute19 = hr_api.g_varchar2) then
515: p_rec.attribute19 :=
516: per_ast_shd.g_old_rec.attribute19;
512: per_ast_shd.g_old_rec.attribute18;
513: End If;
514: If (p_rec.attribute19 = hr_api.g_varchar2) then
515: p_rec.attribute19 :=
516: per_ast_shd.g_old_rec.attribute19;
517: End If;
518: If (p_rec.attribute20 = hr_api.g_varchar2) then
519: p_rec.attribute20 :=
520: per_ast_shd.g_old_rec.attribute20;
516: per_ast_shd.g_old_rec.attribute19;
517: End If;
518: If (p_rec.attribute20 = hr_api.g_varchar2) then
519: p_rec.attribute20 :=
520: per_ast_shd.g_old_rec.attribute20;
521: End If;
522: If (p_rec.type = hr_api.g_varchar2) then
523: p_rec.type :=
524: per_ast_shd.g_old_rec.type;
520: per_ast_shd.g_old_rec.attribute20;
521: End If;
522: If (p_rec.type = hr_api.g_varchar2) then
523: p_rec.type :=
524: per_ast_shd.g_old_rec.type;
525: End If;
526: If (p_rec.line_score_formula_id = hr_api.g_number) then
527: p_rec.line_score_formula_id :=
528: per_ast_shd.g_old_rec.line_score_formula_id;
524: per_ast_shd.g_old_rec.type;
525: End If;
526: If (p_rec.line_score_formula_id = hr_api.g_number) then
527: p_rec.line_score_formula_id :=
528: per_ast_shd.g_old_rec.line_score_formula_id;
529: End If;
530: If (p_rec.default_job_competencies = hr_api.g_varchar2) then
531: p_rec.default_job_competencies :=
532: per_ast_shd.g_old_rec.default_job_competencies;
528: per_ast_shd.g_old_rec.line_score_formula_id;
529: End If;
530: If (p_rec.default_job_competencies = hr_api.g_varchar2) then
531: p_rec.default_job_competencies :=
532: per_ast_shd.g_old_rec.default_job_competencies;
533: End If;
534: If (p_rec.available_flag = hr_api.g_varchar2) then
535: p_rec.available_flag :=
536: per_ast_shd.g_old_rec.available_flag;
532: per_ast_shd.g_old_rec.default_job_competencies;
533: End If;
534: If (p_rec.available_flag = hr_api.g_varchar2) then
535: p_rec.available_flag :=
536: per_ast_shd.g_old_rec.available_flag;
537: End If;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: --
544: -- |---------------------------------< upd >----------------------------------|
545: -- ----------------------------------------------------------------------------
546: Procedure upd
547: (
548: p_rec in out nocopy per_ast_shd.g_rec_type,
549: p_validate in boolean default false,
550: p_effective_date in date
551: ) is
552: --
565: End If;
566: --
567: -- We must lock the row which we need to update.
568: --
569: per_ast_shd.lck
570: (
571: p_rec.assessment_type_id,
572: p_rec.object_version_number
573: );
660: p_validate in boolean default false,
661: p_effective_date in date
662: ) is
663: --
664: l_rec per_ast_shd.g_rec_type;
665: l_proc varchar2(72) := g_package||'upd';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
673: hr_utility.set_location('In Upd attrib, ass_class is :'||p_assessment_classification, 10);
674: hr_utility.set_location('In Upd attrib, comments is :'||p_comments, 10);
675: --
676: l_rec :=
677: per_ast_shd.convert_args
678: (
679: p_assessment_type_id,
680: p_name,
681: hr_api.g_number,