44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_rtl_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: per_rtl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
95: per_rtl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_rtl_shd.constraint_error
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_rtl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: Raise;
107: End update_dml;
137: -- Internal Table Handler Use Only.
138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_update(p_rec in per_rtl_shd.g_rec_type) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --
145: Begin
179: -- Internal Table Handler Use Only.
180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update(p_rec in per_rtl_shd.g_rec_type) is
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --
187: Begin
219: p_attribute17 => p_rec.attribute17 ,
220: p_attribute18 => p_rec.attribute18 ,
221: p_attribute19 => p_rec.attribute19 ,
222: p_attribute20 => p_rec.attribute20 ,
223: p_business_group_id_o => per_rtl_shd.g_old_rec.business_group_id ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
220: p_attribute18 => p_rec.attribute18 ,
221: p_attribute19 => p_rec.attribute19 ,
222: p_attribute20 => p_rec.attribute20 ,
223: p_business_group_id_o => per_rtl_shd.g_old_rec.business_group_id ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
221: p_attribute19 => p_rec.attribute19 ,
222: p_attribute20 => p_rec.attribute20 ,
223: p_business_group_id_o => per_rtl_shd.g_old_rec.business_group_id ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
222: p_attribute20 => p_rec.attribute20 ,
223: p_business_group_id_o => per_rtl_shd.g_old_rec.business_group_id ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
223: p_business_group_id_o => per_rtl_shd.g_old_rec.business_group_id ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
224: p_object_version_number_o => per_rtl_shd.g_old_rec.object_version_number,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
225: p_step_value_o => per_rtl_shd.g_old_rec.step_value ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
226: p_name_o => per_rtl_shd.g_old_rec.name ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
227: p_rating_scale_id_o => per_rtl_shd.g_old_rec.rating_scale_id ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
228: p_competence_id_o => per_rtl_shd.g_old_rec.competence_id ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
229: p_behavioural_indicator_o => per_rtl_shd.g_old_rec.behavioural_indicator,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
230: p_attribute_category_o => per_rtl_shd.g_old_rec.attribute_category ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
231: p_attribute1_o => per_rtl_shd.g_old_rec.attribute1 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
232: p_attribute2_o => per_rtl_shd.g_old_rec.attribute2 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
233: p_attribute3_o => per_rtl_shd.g_old_rec.attribute3 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
234: p_attribute4_o => per_rtl_shd.g_old_rec.attribute4 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
235: p_attribute5_o => per_rtl_shd.g_old_rec.attribute5 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
236: p_attribute6_o => per_rtl_shd.g_old_rec.attribute6 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
237: p_attribute7_o => per_rtl_shd.g_old_rec.attribute7 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
238: p_attribute8_o => per_rtl_shd.g_old_rec.attribute8 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
239: p_attribute9_o => per_rtl_shd.g_old_rec.attribute9 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
240: p_attribute10_o => per_rtl_shd.g_old_rec.attribute10 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
241: p_attribute11_o => per_rtl_shd.g_old_rec.attribute11 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
242: p_attribute12_o => per_rtl_shd.g_old_rec.attribute12 ,
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
243: p_attribute13_o => per_rtl_shd.g_old_rec.attribute13 ,
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
244: p_attribute14_o => per_rtl_shd.g_old_rec.attribute14 ,
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
252: exception
245: p_attribute15_o => per_rtl_shd.g_old_rec.attribute15 ,
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
252: exception
253: when hr_api.cannot_find_prog_unit then
246: p_attribute16_o => per_rtl_shd.g_old_rec.attribute16 ,
247: p_attribute17_o => per_rtl_shd.g_old_rec.attribute17 ,
248: p_attribute18_o => per_rtl_shd.g_old_rec.attribute18 ,
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
304: -- Internal Table Handler Use Only.
305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure convert_defs(p_rec in out nocopy per_rtl_shd.g_rec_type) is
309: --
310: l_proc varchar2(72) := g_package||'convert_defs';
311: --
312: Begin
319: -- is being used then we must set to the 'current' argument value.
320: --
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_rtl_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.step_value = hr_api.g_number) then
326: p_rec.step_value :=
327: per_rtl_shd.g_old_rec.step_value;
323: per_rtl_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.step_value = hr_api.g_number) then
326: p_rec.step_value :=
327: per_rtl_shd.g_old_rec.step_value;
328: End If;
329: If (p_rec.rating_scale_id = hr_api.g_number) then
330: p_rec.rating_scale_id :=
331: per_rtl_shd.g_old_rec.rating_scale_id;
327: per_rtl_shd.g_old_rec.step_value;
328: End If;
329: If (p_rec.rating_scale_id = hr_api.g_number) then
330: p_rec.rating_scale_id :=
331: per_rtl_shd.g_old_rec.rating_scale_id;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: per_rtl_shd.g_old_rec.name;
331: per_rtl_shd.g_old_rec.rating_scale_id;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: per_rtl_shd.g_old_rec.name;
336: End If;
337: If (p_rec.competence_id = hr_api.g_number) then
338: p_rec.competence_id :=
339: per_rtl_shd.g_old_rec.competence_id;
335: per_rtl_shd.g_old_rec.name;
336: End If;
337: If (p_rec.competence_id = hr_api.g_number) then
338: p_rec.competence_id :=
339: per_rtl_shd.g_old_rec.competence_id;
340: End If;
341: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
342: p_rec.behavioural_indicator :=
343: per_rtl_shd.g_old_rec.behavioural_indicator;
339: per_rtl_shd.g_old_rec.competence_id;
340: End If;
341: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
342: p_rec.behavioural_indicator :=
343: per_rtl_shd.g_old_rec.behavioural_indicator;
344: End If;
345: If (p_rec.attribute_category = hr_api.g_varchar2) then
346: p_rec.attribute_category :=
347: per_rtl_shd.g_old_rec.attribute_category;
343: per_rtl_shd.g_old_rec.behavioural_indicator;
344: End If;
345: If (p_rec.attribute_category = hr_api.g_varchar2) then
346: p_rec.attribute_category :=
347: per_rtl_shd.g_old_rec.attribute_category;
348: End If;
349: If (p_rec.attribute1 = hr_api.g_varchar2) then
350: p_rec.attribute1 :=
351: per_rtl_shd.g_old_rec.attribute1;
347: per_rtl_shd.g_old_rec.attribute_category;
348: End If;
349: If (p_rec.attribute1 = hr_api.g_varchar2) then
350: p_rec.attribute1 :=
351: per_rtl_shd.g_old_rec.attribute1;
352: End If;
353: If (p_rec.attribute2 = hr_api.g_varchar2) then
354: p_rec.attribute2 :=
355: per_rtl_shd.g_old_rec.attribute2;
351: per_rtl_shd.g_old_rec.attribute1;
352: End If;
353: If (p_rec.attribute2 = hr_api.g_varchar2) then
354: p_rec.attribute2 :=
355: per_rtl_shd.g_old_rec.attribute2;
356: End If;
357: If (p_rec.attribute3 = hr_api.g_varchar2) then
358: p_rec.attribute3 :=
359: per_rtl_shd.g_old_rec.attribute3;
355: per_rtl_shd.g_old_rec.attribute2;
356: End If;
357: If (p_rec.attribute3 = hr_api.g_varchar2) then
358: p_rec.attribute3 :=
359: per_rtl_shd.g_old_rec.attribute3;
360: End If;
361: If (p_rec.attribute4 = hr_api.g_varchar2) then
362: p_rec.attribute4 :=
363: per_rtl_shd.g_old_rec.attribute4;
359: per_rtl_shd.g_old_rec.attribute3;
360: End If;
361: If (p_rec.attribute4 = hr_api.g_varchar2) then
362: p_rec.attribute4 :=
363: per_rtl_shd.g_old_rec.attribute4;
364: End If;
365: If (p_rec.attribute5 = hr_api.g_varchar2) then
366: p_rec.attribute5 :=
367: per_rtl_shd.g_old_rec.attribute5;
363: per_rtl_shd.g_old_rec.attribute4;
364: End If;
365: If (p_rec.attribute5 = hr_api.g_varchar2) then
366: p_rec.attribute5 :=
367: per_rtl_shd.g_old_rec.attribute5;
368: End If;
369: If (p_rec.attribute6 = hr_api.g_varchar2) then
370: p_rec.attribute6 :=
371: per_rtl_shd.g_old_rec.attribute6;
367: per_rtl_shd.g_old_rec.attribute5;
368: End If;
369: If (p_rec.attribute6 = hr_api.g_varchar2) then
370: p_rec.attribute6 :=
371: per_rtl_shd.g_old_rec.attribute6;
372: End If;
373: If (p_rec.attribute7 = hr_api.g_varchar2) then
374: p_rec.attribute7 :=
375: per_rtl_shd.g_old_rec.attribute7;
371: per_rtl_shd.g_old_rec.attribute6;
372: End If;
373: If (p_rec.attribute7 = hr_api.g_varchar2) then
374: p_rec.attribute7 :=
375: per_rtl_shd.g_old_rec.attribute7;
376: End If;
377: If (p_rec.attribute8 = hr_api.g_varchar2) then
378: p_rec.attribute8 :=
379: per_rtl_shd.g_old_rec.attribute8;
375: per_rtl_shd.g_old_rec.attribute7;
376: End If;
377: If (p_rec.attribute8 = hr_api.g_varchar2) then
378: p_rec.attribute8 :=
379: per_rtl_shd.g_old_rec.attribute8;
380: End If;
381: If (p_rec.attribute9 = hr_api.g_varchar2) then
382: p_rec.attribute9 :=
383: per_rtl_shd.g_old_rec.attribute9;
379: per_rtl_shd.g_old_rec.attribute8;
380: End If;
381: If (p_rec.attribute9 = hr_api.g_varchar2) then
382: p_rec.attribute9 :=
383: per_rtl_shd.g_old_rec.attribute9;
384: End If;
385: If (p_rec.attribute10 = hr_api.g_varchar2) then
386: p_rec.attribute10 :=
387: per_rtl_shd.g_old_rec.attribute10;
383: per_rtl_shd.g_old_rec.attribute9;
384: End If;
385: If (p_rec.attribute10 = hr_api.g_varchar2) then
386: p_rec.attribute10 :=
387: per_rtl_shd.g_old_rec.attribute10;
388: End If;
389: If (p_rec.attribute11 = hr_api.g_varchar2) then
390: p_rec.attribute11 :=
391: per_rtl_shd.g_old_rec.attribute11;
387: per_rtl_shd.g_old_rec.attribute10;
388: End If;
389: If (p_rec.attribute11 = hr_api.g_varchar2) then
390: p_rec.attribute11 :=
391: per_rtl_shd.g_old_rec.attribute11;
392: End If;
393: If (p_rec.attribute12 = hr_api.g_varchar2) then
394: p_rec.attribute12 :=
395: per_rtl_shd.g_old_rec.attribute12;
391: per_rtl_shd.g_old_rec.attribute11;
392: End If;
393: If (p_rec.attribute12 = hr_api.g_varchar2) then
394: p_rec.attribute12 :=
395: per_rtl_shd.g_old_rec.attribute12;
396: End If;
397: If (p_rec.attribute13 = hr_api.g_varchar2) then
398: p_rec.attribute13 :=
399: per_rtl_shd.g_old_rec.attribute13;
395: per_rtl_shd.g_old_rec.attribute12;
396: End If;
397: If (p_rec.attribute13 = hr_api.g_varchar2) then
398: p_rec.attribute13 :=
399: per_rtl_shd.g_old_rec.attribute13;
400: End If;
401: If (p_rec.attribute14 = hr_api.g_varchar2) then
402: p_rec.attribute14 :=
403: per_rtl_shd.g_old_rec.attribute14;
399: per_rtl_shd.g_old_rec.attribute13;
400: End If;
401: If (p_rec.attribute14 = hr_api.g_varchar2) then
402: p_rec.attribute14 :=
403: per_rtl_shd.g_old_rec.attribute14;
404: End If;
405: If (p_rec.attribute15 = hr_api.g_varchar2) then
406: p_rec.attribute15 :=
407: per_rtl_shd.g_old_rec.attribute15;
403: per_rtl_shd.g_old_rec.attribute14;
404: End If;
405: If (p_rec.attribute15 = hr_api.g_varchar2) then
406: p_rec.attribute15 :=
407: per_rtl_shd.g_old_rec.attribute15;
408: End If;
409: If (p_rec.attribute16 = hr_api.g_varchar2) then
410: p_rec.attribute16 :=
411: per_rtl_shd.g_old_rec.attribute16;
407: per_rtl_shd.g_old_rec.attribute15;
408: End If;
409: If (p_rec.attribute16 = hr_api.g_varchar2) then
410: p_rec.attribute16 :=
411: per_rtl_shd.g_old_rec.attribute16;
412: End If;
413: If (p_rec.attribute17 = hr_api.g_varchar2) then
414: p_rec.attribute17 :=
415: per_rtl_shd.g_old_rec.attribute17;
411: per_rtl_shd.g_old_rec.attribute16;
412: End If;
413: If (p_rec.attribute17 = hr_api.g_varchar2) then
414: p_rec.attribute17 :=
415: per_rtl_shd.g_old_rec.attribute17;
416: End If;
417: If (p_rec.attribute18 = hr_api.g_varchar2) then
418: p_rec.attribute18 :=
419: per_rtl_shd.g_old_rec.attribute18;
415: per_rtl_shd.g_old_rec.attribute17;
416: End If;
417: If (p_rec.attribute18 = hr_api.g_varchar2) then
418: p_rec.attribute18 :=
419: per_rtl_shd.g_old_rec.attribute18;
420: End If;
421: If (p_rec.attribute19 = hr_api.g_varchar2) then
422: p_rec.attribute19 :=
423: per_rtl_shd.g_old_rec.attribute19;
419: per_rtl_shd.g_old_rec.attribute18;
420: End If;
421: If (p_rec.attribute19 = hr_api.g_varchar2) then
422: p_rec.attribute19 :=
423: per_rtl_shd.g_old_rec.attribute19;
424: End If;
425: If (p_rec.attribute20 = hr_api.g_varchar2) then
426: p_rec.attribute20 :=
427: per_rtl_shd.g_old_rec.attribute20;
423: per_rtl_shd.g_old_rec.attribute19;
424: End If;
425: If (p_rec.attribute20 = hr_api.g_varchar2) then
426: p_rec.attribute20 :=
427: per_rtl_shd.g_old_rec.attribute20;
428: End If;
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: --
435: -- |---------------------------------< upd >----------------------------------|
436: -- ----------------------------------------------------------------------------
437: Procedure upd
438: (
439: p_rec in out nocopy per_rtl_shd.g_rec_type,
440: p_effective_date in date default null,
441: p_validate in boolean default false
442: ) is
443: --
456: End If;
457: --
458: -- We must lock the row which we need to update.
459: --
460: per_rtl_shd.lck
461: (
462: p_rec.rating_level_id,
463: p_rec.object_version_number
464: );
533: p_effective_date in date ,
534: p_validate in boolean default false
535: ) is
536: --
537: l_rec per_rtl_shd.g_rec_type;
538: l_proc varchar2(72) := g_package||'upd';
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
543: -- Call conversion function to turn arguments into the
544: -- l_rec structure.
545: --
546: l_rec :=
547: per_rtl_shd.convert_args
548: (
549: p_rating_level_id,
550: hr_api.g_number,
551: hr_api.g_number,