50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_pea_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_pea_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_person_analyses Row
68: --
69: update per_person_analyses
100: attribute20 = p_rec.attribute20,
101: object_version_number = p_rec.object_version_number
102: where person_analysis_id = p_rec.person_analysis_id;
103: --
104: per_pea_shd.g_api_dml := false; -- Unset the api dml status
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception
107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pea_shd.g_api_dml := false; -- Unset the api dml status
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pea_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pea_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End update_dml;
128: --
129: -- ----------------------------------------------------------------------------
157: -- Internal Table Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_update(p_rec in per_pea_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure post_update
204: (p_rec in per_pea_shd.g_rec_type) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207:
208: -- For BEN LER Check
248: p_attribute18 => p_rec.attribute18,
249: p_attribute19 => p_rec.attribute19,
250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
249: p_attribute19 => p_rec.attribute19,
250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
250: p_attribute20 => p_rec.attribute20,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
251: p_object_version_number => p_rec.object_version_number,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
252: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
253: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
254: p_person_id_o => per_pea_shd.g_old_rec.person_id,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
255: p_comments_o => per_pea_shd.g_old_rec.comments,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
256: p_date_from_o => per_pea_shd.g_old_rec.date_from,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
257: p_date_to_o => per_pea_shd.g_old_rec.date_to,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
258: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
259: p_request_id_o => per_pea_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
260: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
261: p_program_id_o => per_pea_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
262: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
263: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
264: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
265: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
266: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
267: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
268: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
269: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
270: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
271: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
272: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
273: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
274: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
275: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
276: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
277: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
278: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
279: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check
280: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
284: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
285: );
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
286:
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
287: -- Start of BEN LER Check
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
288: l_old_rec.person_id := per_pea_shd.g_old_rec.person_id;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
289: l_old_rec.business_group_id := per_pea_shd.g_old_rec.business_group_id;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
290: l_old_rec.ANALYSIS_CRITERIA_ID := per_pea_shd.g_old_rec.ANALYSIS_CRITERIA_ID;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
291: l_old_rec.DATE_FROM := per_pea_shd.g_old_rec.DATE_FROM;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
292: l_old_rec.DATE_TO := per_pea_shd.g_old_rec.DATE_TO;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
293: l_old_rec.ID_FLEX_NUM := per_pea_shd.g_old_rec.ID_FLEX_NUM;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
294: l_old_rec.attribute1 :=per_pea_shd.g_old_rec.attribute1;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
295: l_old_rec.attribute2 :=per_pea_shd.g_old_rec.attribute2;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
296: l_old_rec.attribute3 :=per_pea_shd.g_old_rec.attribute3;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
297: l_old_rec.attribute4 :=per_pea_shd.g_old_rec.attribute4;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
298: l_old_rec.attribute5 :=per_pea_shd.g_old_rec.attribute5;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
299: l_old_rec.attribute6 :=per_pea_shd.g_old_rec.attribute6;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
300: l_old_rec.attribute7 :=per_pea_shd.g_old_rec.attribute7;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
301: l_old_rec.attribute8 :=per_pea_shd.g_old_rec.attribute8;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
302: l_old_rec.attribute9 :=per_pea_shd.g_old_rec.attribute9;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
303: l_old_rec.attribute10 :=per_pea_shd.g_old_rec.attribute10;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
304: l_old_rec.attribute11 :=per_pea_shd.g_old_rec.attribute11;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
305: l_old_rec.attribute12 :=per_pea_shd.g_old_rec.attribute12;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
306: l_old_rec.attribute13 :=per_pea_shd.g_old_rec.attribute13;
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
307: l_old_rec.attribute14 :=per_pea_shd.g_old_rec.attribute14;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;
308: l_old_rec.attribute15 :=per_pea_shd.g_old_rec.attribute15;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;
316: l_new_rec.business_group_id := p_rec.business_group_id;
309: l_old_rec.attribute16 :=per_pea_shd.g_old_rec.attribute16;
310: l_old_rec.attribute17 :=per_pea_shd.g_old_rec.attribute17;
311: l_old_rec.attribute18 :=per_pea_shd.g_old_rec.attribute18;
312: l_old_rec.attribute19 :=per_pea_shd.g_old_rec.attribute19;
313: l_old_rec.attribute20 :=per_pea_shd.g_old_rec.attribute20;
314:
315: l_new_rec.person_id := p_rec.person_id;
316: l_new_rec.business_group_id := p_rec.business_group_id;
317: l_new_rec.ANALYSIS_CRITERIA_ID := p_rec.ANALYSIS_CRITERIA_ID;
405: -- Internal Table Handler Use Only.
406: --
407: -- {End Of Comments}
408: -- ----------------------------------------------------------------------------
409: Procedure convert_defs(p_rec in out nocopy per_pea_shd.g_rec_type) is
410: --
411: l_proc varchar2(72) := g_package||'convert_defs';
412: --
413: Begin
420: -- is being used then we must set to the 'current' argument value.
421: --
422: If (p_rec.business_group_id = hr_api.g_number) then
423: p_rec.business_group_id :=
424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;
424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;
428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;
432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;
436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;
440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;
444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;
448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;
452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;
456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;
460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;
464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;
468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;
472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;
476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;
480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;
484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;
488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;
492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;
496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;
500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;
504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;
508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;
512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;
516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;
520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;
524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;
528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;
532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;
536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;
540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;
544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;
549: End If;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: --
556: -- |---------------------------------< upd >----------------------------------|
557: -- ----------------------------------------------------------------------------
558: Procedure upd
559: (
560: p_rec in out nocopy per_pea_shd.g_rec_type,
561: p_validate in boolean default false
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
561: p_validate in boolean default false
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
565: l_rec per_pea_shd.g_rec_type;
566: l_object_version_number number;
567:
568: --
569: Begin
581: End If;
582: --
583: -- We must lock the row which we need to update.
584: --
585: per_pea_shd.lck
586: (
587: p_rec.person_analysis_id,
588: p_rec.object_version_number
589: );
673: p_object_version_number in out nocopy number,
674: p_validate in boolean default false
675: ) is
676: --
677: l_rec per_pea_shd.g_rec_type;
678: l_proc varchar2(72) := g_package||'upd';
679: --
680: Begin
681: hr_utility.set_location('Entering:'||l_proc, 5);
683: -- Call conversion function to turn arguments into the
684: -- l_rec structure.
685: --
686: l_rec :=
687: per_pea_shd.convert_args
688: (
689: p_person_analysis_id,
690: hr_api.g_number,
691: p_analysis_criteria_id,