50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_grs_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_grs_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_cagr_grade_structures Row
68: --
69: update per_cagr_grade_structures
95: attribute19 = p_rec.attribute19,
96: attribute20 = p_rec.attribute20
97: where cagr_grade_structure_id = p_rec.cagr_grade_structure_id;
98: --
99: per_grs_shd.g_api_dml := false; -- Unset the api dml status
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
123: --
124: -- ----------------------------------------------------------------------------
153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure pre_update(p_effective_date in date,
157: p_rec in per_grs_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update(p_effective_date in date,
200: p_rec in per_grs_shd.g_rec_type) is
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --
204: Begin
236: ,p_attribute17 =>p_rec.attribute17
237: ,p_attribute18 =>p_rec.attribute18
238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
237: ,p_attribute18 =>p_rec.attribute18
238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
238: ,p_attribute19 =>p_rec.attribute19
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
239: ,p_attribute20 =>p_rec.attribute20
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
240: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
241: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
242: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
243: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
244: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
245: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
246: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
247: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
248: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
249: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
250: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
251: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
252: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
253: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
254: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
255: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
256: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
257: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
258: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );
259: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );
267: --
260: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
261: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
262: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
263: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
264: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
265: ,p_effective_date =>p_effective_date
266: );
267: --
268: exception
323: -- Internal Row Handler Use Only.
324: --
325: -- {End Of Comments}
326: -- ----------------------------------------------------------------------------
327: Procedure convert_defs(p_rec in out nocopy per_grs_shd.g_rec_type) is
328: --
329: l_proc varchar2(72) := g_package||'convert_defs';
330: --
331: Begin
338: -- is being used then we must set to the 'current' argument value.
339: --
340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
435: End If;
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: --
442: -- |---------------------------------< upd >----------------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure upd
445: (p_effective_date in date,
446: p_rec in out nocopy per_grs_shd.g_rec_type
447: ) is
448: --
449: l_proc varchar2(72) := g_package||'upd';
450: --
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- We must lock the row which we need to update.
455: --
456: per_grs_shd.lck
457: (p_effective_date => p_effective_date,
458: p_cagr_grade_structure_id => p_rec.cagr_grade_structure_id,
459: p_object_version_number => p_rec.object_version_number
460: );
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --
524: l_rec per_grs_shd.g_rec_type;
525: l_proc varchar2(72) := g_package||'upd';
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
530: -- Call conversion function to turn arguments into the
531: -- l_rec structure.
532: --
533: l_rec :=
534: per_grs_shd.convert_args
535: (
536: p_cagr_grade_structure_id,
537: p_collective_agreement_id,
538: p_object_version_number,