44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_rsc_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_rsc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
100: per_rsc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: per_rsc_shd.constraint_error
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: per_rsc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: Raise;
112: End update_dml;
142: -- Internal Table Handler Use Only.
143: --
144: -- {End Of Comments}
145: -- ----------------------------------------------------------------------------
146: Procedure pre_update(p_rec in per_rsc_shd.g_rec_type) is
147: --
148: l_proc varchar2(72) := g_package||'pre_update';
149: --
150: Begin
184: -- Internal Table Handler Use Only.
185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure post_update(p_rec in per_rsc_shd.g_rec_type) is
189: --
190: l_proc varchar2(72) := g_package||'post_update';
191: --
192: Begin
225: p_attribute17 => p_rec.attribute17 ,
226: p_attribute18 => p_rec.attribute18 ,
227: p_attribute19 => p_rec.attribute19 ,
228: p_attribute20 => p_rec.attribute20 ,
229: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
226: p_attribute18 => p_rec.attribute18 ,
227: p_attribute19 => p_rec.attribute19 ,
228: p_attribute20 => p_rec.attribute20 ,
229: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
227: p_attribute19 => p_rec.attribute19 ,
228: p_attribute20 => p_rec.attribute20 ,
229: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
228: p_attribute20 => p_rec.attribute20 ,
229: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
229: p_business_group_id_o => per_rsc_shd.g_old_rec.business_group_id ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
230: p_object_version_number_o => per_rsc_shd.g_old_rec.object_version_number,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
231: p_name_o => per_rsc_shd.g_old_rec.name ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
232: p_type_o => per_rsc_shd.g_old_rec.type ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
233: p_description_o => per_rsc_shd.g_old_rec.description ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
234: p_default_flag_o => per_rsc_shd.g_old_rec.default_flag ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
235: p_max_scale_step_o => per_rsc_shd.g_old_rec.max_scale_step ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
236: p_min_scale_step_o => per_rsc_shd.g_old_rec.min_scale_step ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
237: p_attribute_category_o => per_rsc_shd.g_old_rec.attribute_category ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
238: p_attribute1_o => per_rsc_shd.g_old_rec.attribute1 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
239: p_attribute2_o => per_rsc_shd.g_old_rec.attribute2 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
240: p_attribute3_o => per_rsc_shd.g_old_rec.attribute3 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
241: p_attribute4_o => per_rsc_shd.g_old_rec.attribute4 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
242: p_attribute5_o => per_rsc_shd.g_old_rec.attribute5 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
243: p_attribute6_o => per_rsc_shd.g_old_rec.attribute6 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
244: p_attribute7_o => per_rsc_shd.g_old_rec.attribute7 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
245: p_attribute8_o => per_rsc_shd.g_old_rec.attribute8 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
246: p_attribute9_o => per_rsc_shd.g_old_rec.attribute9 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
247: p_attribute10_o => per_rsc_shd.g_old_rec.attribute10 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
248: p_attribute11_o => per_rsc_shd.g_old_rec.attribute11 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
249: p_attribute12_o => per_rsc_shd.g_old_rec.attribute12 ,
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
250: p_attribute13_o => per_rsc_shd.g_old_rec.attribute13 ,
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
251: p_attribute14_o => per_rsc_shd.g_old_rec.attribute14 ,
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
259: when hr_api.cannot_find_prog_unit then
252: p_attribute15_o => per_rsc_shd.g_old_rec.attribute15 ,
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
253: p_attribute16_o => per_rsc_shd.g_old_rec.attribute16 ,
254: p_attribute17_o => per_rsc_shd.g_old_rec.attribute17 ,
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: ( p_module_name => 'PER_RATING_SCALES'
310: -- Internal Table Handler Use Only.
311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure convert_defs(p_rec in out nocopy per_rsc_shd.g_rec_type) is
315: --
316: l_proc varchar2(72) := g_package||'convert_defs';
317: --
318: Begin
325: -- is being used then we must set to the 'current' argument value.
326: --
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: per_rsc_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: per_rsc_shd.g_old_rec.name;
329: per_rsc_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: per_rsc_shd.g_old_rec.name;
334: End If;
335: If (p_rec.type = hr_api.g_varchar2) then
336: p_rec.type :=
337: per_rsc_shd.g_old_rec.type;
333: per_rsc_shd.g_old_rec.name;
334: End If;
335: If (p_rec.type = hr_api.g_varchar2) then
336: p_rec.type :=
337: per_rsc_shd.g_old_rec.type;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: per_rsc_shd.g_old_rec.description;
337: per_rsc_shd.g_old_rec.type;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: per_rsc_shd.g_old_rec.description;
342: End If;
343: If (p_rec.max_scale_step = hr_api.g_number) then
344: p_rec.max_scale_step :=
345: per_rsc_shd.g_old_rec.max_scale_step;
341: per_rsc_shd.g_old_rec.description;
342: End If;
343: If (p_rec.max_scale_step = hr_api.g_number) then
344: p_rec.max_scale_step :=
345: per_rsc_shd.g_old_rec.max_scale_step;
346: End If;
347: If (p_rec.min_scale_step = hr_api.g_number) then
348: p_rec.min_scale_step :=
349: per_rsc_shd.g_old_rec.min_scale_step;
345: per_rsc_shd.g_old_rec.max_scale_step;
346: End If;
347: If (p_rec.min_scale_step = hr_api.g_number) then
348: p_rec.min_scale_step :=
349: per_rsc_shd.g_old_rec.min_scale_step;
350: End If;
351: if (p_rec.default_flag = hr_api.g_varchar2) then
352: p_rec.default_flag :=
353: per_rsc_shd.g_old_rec.default_flag;
349: per_rsc_shd.g_old_rec.min_scale_step;
350: End If;
351: if (p_rec.default_flag = hr_api.g_varchar2) then
352: p_rec.default_flag :=
353: per_rsc_shd.g_old_rec.default_flag;
354: end if;
355: If (p_rec.attribute_category = hr_api.g_varchar2) then
356: p_rec.attribute_category :=
357: per_rsc_shd.g_old_rec.attribute_category;
353: per_rsc_shd.g_old_rec.default_flag;
354: end if;
355: If (p_rec.attribute_category = hr_api.g_varchar2) then
356: p_rec.attribute_category :=
357: per_rsc_shd.g_old_rec.attribute_category;
358: End If;
359: If (p_rec.attribute1 = hr_api.g_varchar2) then
360: p_rec.attribute1 :=
361: per_rsc_shd.g_old_rec.attribute1;
357: per_rsc_shd.g_old_rec.attribute_category;
358: End If;
359: If (p_rec.attribute1 = hr_api.g_varchar2) then
360: p_rec.attribute1 :=
361: per_rsc_shd.g_old_rec.attribute1;
362: End If;
363: If (p_rec.attribute2 = hr_api.g_varchar2) then
364: p_rec.attribute2 :=
365: per_rsc_shd.g_old_rec.attribute2;
361: per_rsc_shd.g_old_rec.attribute1;
362: End If;
363: If (p_rec.attribute2 = hr_api.g_varchar2) then
364: p_rec.attribute2 :=
365: per_rsc_shd.g_old_rec.attribute2;
366: End If;
367: If (p_rec.attribute3 = hr_api.g_varchar2) then
368: p_rec.attribute3 :=
369: per_rsc_shd.g_old_rec.attribute3;
365: per_rsc_shd.g_old_rec.attribute2;
366: End If;
367: If (p_rec.attribute3 = hr_api.g_varchar2) then
368: p_rec.attribute3 :=
369: per_rsc_shd.g_old_rec.attribute3;
370: End If;
371: If (p_rec.attribute4 = hr_api.g_varchar2) then
372: p_rec.attribute4 :=
373: per_rsc_shd.g_old_rec.attribute4;
369: per_rsc_shd.g_old_rec.attribute3;
370: End If;
371: If (p_rec.attribute4 = hr_api.g_varchar2) then
372: p_rec.attribute4 :=
373: per_rsc_shd.g_old_rec.attribute4;
374: End If;
375: If (p_rec.attribute5 = hr_api.g_varchar2) then
376: p_rec.attribute5 :=
377: per_rsc_shd.g_old_rec.attribute5;
373: per_rsc_shd.g_old_rec.attribute4;
374: End If;
375: If (p_rec.attribute5 = hr_api.g_varchar2) then
376: p_rec.attribute5 :=
377: per_rsc_shd.g_old_rec.attribute5;
378: End If;
379: If (p_rec.attribute6 = hr_api.g_varchar2) then
380: p_rec.attribute6 :=
381: per_rsc_shd.g_old_rec.attribute6;
377: per_rsc_shd.g_old_rec.attribute5;
378: End If;
379: If (p_rec.attribute6 = hr_api.g_varchar2) then
380: p_rec.attribute6 :=
381: per_rsc_shd.g_old_rec.attribute6;
382: End If;
383: If (p_rec.attribute7 = hr_api.g_varchar2) then
384: p_rec.attribute7 :=
385: per_rsc_shd.g_old_rec.attribute7;
381: per_rsc_shd.g_old_rec.attribute6;
382: End If;
383: If (p_rec.attribute7 = hr_api.g_varchar2) then
384: p_rec.attribute7 :=
385: per_rsc_shd.g_old_rec.attribute7;
386: End If;
387: If (p_rec.attribute8 = hr_api.g_varchar2) then
388: p_rec.attribute8 :=
389: per_rsc_shd.g_old_rec.attribute8;
385: per_rsc_shd.g_old_rec.attribute7;
386: End If;
387: If (p_rec.attribute8 = hr_api.g_varchar2) then
388: p_rec.attribute8 :=
389: per_rsc_shd.g_old_rec.attribute8;
390: End If;
391: If (p_rec.attribute9 = hr_api.g_varchar2) then
392: p_rec.attribute9 :=
393: per_rsc_shd.g_old_rec.attribute9;
389: per_rsc_shd.g_old_rec.attribute8;
390: End If;
391: If (p_rec.attribute9 = hr_api.g_varchar2) then
392: p_rec.attribute9 :=
393: per_rsc_shd.g_old_rec.attribute9;
394: End If;
395: If (p_rec.attribute10 = hr_api.g_varchar2) then
396: p_rec.attribute10 :=
397: per_rsc_shd.g_old_rec.attribute10;
393: per_rsc_shd.g_old_rec.attribute9;
394: End If;
395: If (p_rec.attribute10 = hr_api.g_varchar2) then
396: p_rec.attribute10 :=
397: per_rsc_shd.g_old_rec.attribute10;
398: End If;
399: If (p_rec.attribute11 = hr_api.g_varchar2) then
400: p_rec.attribute11 :=
401: per_rsc_shd.g_old_rec.attribute11;
397: per_rsc_shd.g_old_rec.attribute10;
398: End If;
399: If (p_rec.attribute11 = hr_api.g_varchar2) then
400: p_rec.attribute11 :=
401: per_rsc_shd.g_old_rec.attribute11;
402: eND iF;
403: If (p_rec.attribute12 = hr_api.g_varchar2) then
404: p_rec.attribute12 :=
405: per_rsc_shd.g_old_rec.attribute12;
401: per_rsc_shd.g_old_rec.attribute11;
402: eND iF;
403: If (p_rec.attribute12 = hr_api.g_varchar2) then
404: p_rec.attribute12 :=
405: per_rsc_shd.g_old_rec.attribute12;
406: End If;
407: If (p_rec.attribute13 = hr_api.g_varchar2) then
408: p_rec.attribute13 :=
409: per_rsc_shd.g_old_rec.attribute13;
405: per_rsc_shd.g_old_rec.attribute12;
406: End If;
407: If (p_rec.attribute13 = hr_api.g_varchar2) then
408: p_rec.attribute13 :=
409: per_rsc_shd.g_old_rec.attribute13;
410: End If;
411: If (p_rec.attribute14 = hr_api.g_varchar2) then
412: p_rec.attribute14 :=
413: per_rsc_shd.g_old_rec.attribute14;
409: per_rsc_shd.g_old_rec.attribute13;
410: End If;
411: If (p_rec.attribute14 = hr_api.g_varchar2) then
412: p_rec.attribute14 :=
413: per_rsc_shd.g_old_rec.attribute14;
414: End If;
415: If (p_rec.attribute15 = hr_api.g_varchar2) then
416: p_rec.attribute15 :=
417: per_rsc_shd.g_old_rec.attribute15;
413: per_rsc_shd.g_old_rec.attribute14;
414: End If;
415: If (p_rec.attribute15 = hr_api.g_varchar2) then
416: p_rec.attribute15 :=
417: per_rsc_shd.g_old_rec.attribute15;
418: End If;
419: If (p_rec.attribute16 = hr_api.g_varchar2) then
420: p_rec.attribute16 :=
421: per_rsc_shd.g_old_rec.attribute16;
417: per_rsc_shd.g_old_rec.attribute15;
418: End If;
419: If (p_rec.attribute16 = hr_api.g_varchar2) then
420: p_rec.attribute16 :=
421: per_rsc_shd.g_old_rec.attribute16;
422: End If;
423: If (p_rec.attribute17 = hr_api.g_varchar2) then
424: p_rec.attribute17 :=
425: per_rsc_shd.g_old_rec.attribute17;
421: per_rsc_shd.g_old_rec.attribute16;
422: End If;
423: If (p_rec.attribute17 = hr_api.g_varchar2) then
424: p_rec.attribute17 :=
425: per_rsc_shd.g_old_rec.attribute17;
426: End If;
427: If (p_rec.attribute18 = hr_api.g_varchar2) then
428: p_rec.attribute18 :=
429: per_rsc_shd.g_old_rec.attribute18;
425: per_rsc_shd.g_old_rec.attribute17;
426: End If;
427: If (p_rec.attribute18 = hr_api.g_varchar2) then
428: p_rec.attribute18 :=
429: per_rsc_shd.g_old_rec.attribute18;
430: End If;
431: If (p_rec.attribute19 = hr_api.g_varchar2) then
432: p_rec.attribute19 :=
433: per_rsc_shd.g_old_rec.attribute19;
429: per_rsc_shd.g_old_rec.attribute18;
430: End If;
431: If (p_rec.attribute19 = hr_api.g_varchar2) then
432: p_rec.attribute19 :=
433: per_rsc_shd.g_old_rec.attribute19;
434: End If;
435: If (p_rec.attribute20 = hr_api.g_varchar2) then
436: p_rec.attribute20 :=
437: per_rsc_shd.g_old_rec.attribute20;
433: per_rsc_shd.g_old_rec.attribute19;
434: End If;
435: If (p_rec.attribute20 = hr_api.g_varchar2) then
436: p_rec.attribute20 :=
437: per_rsc_shd.g_old_rec.attribute20;
438: End If;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: --
445: -- |---------------------------------< upd >----------------------------------|
446: -- ----------------------------------------------------------------------------
447: Procedure upd
448: (
449: p_rec in out nocopy per_rsc_shd.g_rec_type,
450: p_validate in boolean default false,
451: p_effective_date in date
452: ) is
453: --
466: End If;
467: --
468: -- We must lock the row which we need to update.
469: --
470: per_rsc_shd.lck
471: (
472: p_rec.rating_scale_id,
473: p_rec.object_version_number
474: );
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
547: p_effective_date in date
548: ) is
549: --
550: l_rec per_rsc_shd.g_rec_type;
551: l_proc varchar2(72) := g_package||'upd';
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
556: -- Call conversion function to turn arguments into the
557: -- l_rec structure.
558: --
559: l_rec :=
560: per_rsc_shd.convert_args
561: (
562: p_rating_scale_id,
563: hr_api.g_number,
564: p_name,