50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_jbr_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_jbr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_job_requirements Row
68: --
69: update per_job_requirements
102: attribute20 = p_rec.attribute20,
103: object_version_number = p_rec.object_version_number
104: where job_requirement_id = p_rec.job_requirement_id;
105: --
106: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
114: per_jbr_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
114: per_jbr_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
114: per_jbr_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
119: per_jbr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
119: per_jbr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
119: per_jbr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
124: per_jbr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
124: per_jbr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
123: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
124: per_jbr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: per_jbr_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End update_dml;
130: --
131: -- ----------------------------------------------------------------------------
159: -- Internal Table Handler Use Only.
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_update(p_rec in per_jbr_shd.g_rec_type) is
164: --
165: l_proc varchar2(72) := g_package||'pre_update';
166: --
167: Begin
201: -- Internal Table Handler Use Only.
202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure post_update(p_rec in per_jbr_shd.g_rec_type) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --
209: Begin
247: p_attribute18 => p_rec.attribute18,
248: p_attribute19 => p_rec.attribute19,
249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
248: p_attribute19 => p_rec.attribute19,
249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
249: p_attribute20 => p_rec.attribute20,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
250: p_object_version_number => p_rec.object_version_number,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
251: p_business_group_id_o => per_jbr_shd.g_old_rec.business_group_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
252: p_analysis_criteria_id_o => per_jbr_shd.g_old_rec.analysis_criteria_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
253: p_comments_o => per_jbr_shd.g_old_rec.comments,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
254: p_date_from_o => per_jbr_shd.g_old_rec.date_from,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
255: p_date_to_o => per_jbr_shd.g_old_rec.date_to,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
256: p_essential_o => per_jbr_shd.g_old_rec.essential,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
257: p_job_id_o => per_jbr_shd.g_old_rec.job_id,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
258: p_position_id_o => per_jbr_shd.g_old_rec.position_id,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
259: p_request_id_o => per_jbr_shd.g_old_rec.request_id,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
260: p_program_application_id_o => per_jbr_shd.g_old_rec.program_application_id,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
261: p_program_id_o => per_jbr_shd.g_old_rec.program_id,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
262: p_program_update_date_o => per_jbr_shd.g_old_rec.program_update_date,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
263: p_attribute_category_o => per_jbr_shd.g_old_rec.attribute_category,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
264: p_attribute1_o => per_jbr_shd.g_old_rec.attribute1,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
265: p_attribute2_o => per_jbr_shd.g_old_rec.attribute2,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
266: p_attribute3_o => per_jbr_shd.g_old_rec.attribute3,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
267: p_attribute4_o => per_jbr_shd.g_old_rec.attribute4,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
268: p_attribute5_o => per_jbr_shd.g_old_rec.attribute5,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
269: p_attribute6_o => per_jbr_shd.g_old_rec.attribute6,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
270: p_attribute7_o => per_jbr_shd.g_old_rec.attribute7,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
271: p_attribute8_o => per_jbr_shd.g_old_rec.attribute8,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
272: p_attribute9_o => per_jbr_shd.g_old_rec.attribute9,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
273: p_attribute10_o => per_jbr_shd.g_old_rec.attribute10,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
274: p_attribute11_o => per_jbr_shd.g_old_rec.attribute11,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
275: p_attribute12_o => per_jbr_shd.g_old_rec.attribute12,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
276: p_attribute13_o => per_jbr_shd.g_old_rec.attribute13,
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
277: p_attribute14_o => per_jbr_shd.g_old_rec.attribute14,
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
278: p_attribute15_o => per_jbr_shd.g_old_rec.attribute15,
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
286: exception
279: p_attribute16_o => per_jbr_shd.g_old_rec.attribute16,
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then
280: p_attribute17_o => per_jbr_shd.g_old_rec.attribute17,
281: p_attribute18_o => per_jbr_shd.g_old_rec.attribute18,
282: p_attribute19_o => per_jbr_shd.g_old_rec.attribute19,
283: p_attribute20_o => per_jbr_shd.g_old_rec.attribute20,
284: p_object_version_number_o => per_jbr_shd.g_old_rec.object_version_number
285: );
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error
338: -- Internal Table Handler Use Only.
339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure convert_defs(p_rec in out nocopy per_jbr_shd.g_rec_type) is
343: --
344: l_proc varchar2(72) := g_package||'convert_defs';
345: --
346: Begin
353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.business_group_id = hr_api.g_number) then
356: p_rec.business_group_id :=
357: per_jbr_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.analysis_criteria_id = hr_api.g_number) then
360: p_rec.analysis_criteria_id :=
361: per_jbr_shd.g_old_rec.analysis_criteria_id;
357: per_jbr_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.analysis_criteria_id = hr_api.g_number) then
360: p_rec.analysis_criteria_id :=
361: per_jbr_shd.g_old_rec.analysis_criteria_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: per_jbr_shd.g_old_rec.comments;
361: per_jbr_shd.g_old_rec.analysis_criteria_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: per_jbr_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.date_from = hr_api.g_date) then
368: p_rec.date_from :=
369: per_jbr_shd.g_old_rec.date_from;
365: per_jbr_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.date_from = hr_api.g_date) then
368: p_rec.date_from :=
369: per_jbr_shd.g_old_rec.date_from;
370: End If;
371: If (p_rec.date_to = hr_api.g_date) then
372: p_rec.date_to :=
373: per_jbr_shd.g_old_rec.date_to;
369: per_jbr_shd.g_old_rec.date_from;
370: End If;
371: If (p_rec.date_to = hr_api.g_date) then
372: p_rec.date_to :=
373: per_jbr_shd.g_old_rec.date_to;
374: End If;
375: If (p_rec.essential = hr_api.g_varchar2) then
376: p_rec.essential :=
377: per_jbr_shd.g_old_rec.essential;
373: per_jbr_shd.g_old_rec.date_to;
374: End If;
375: If (p_rec.essential = hr_api.g_varchar2) then
376: p_rec.essential :=
377: per_jbr_shd.g_old_rec.essential;
378: End If;
379: If (p_rec.job_id = hr_api.g_number) then
380: p_rec.job_id :=
381: per_jbr_shd.g_old_rec.job_id;
377: per_jbr_shd.g_old_rec.essential;
378: End If;
379: If (p_rec.job_id = hr_api.g_number) then
380: p_rec.job_id :=
381: per_jbr_shd.g_old_rec.job_id;
382: End If;
383: If (p_rec.position_id = hr_api.g_number) then
384: p_rec.position_id :=
385: per_jbr_shd.g_old_rec.position_id;
381: per_jbr_shd.g_old_rec.job_id;
382: End If;
383: If (p_rec.position_id = hr_api.g_number) then
384: p_rec.position_id :=
385: per_jbr_shd.g_old_rec.position_id;
386: End If;
387: If (p_rec.request_id = hr_api.g_number) then
388: p_rec.request_id :=
389: per_jbr_shd.g_old_rec.request_id;
385: per_jbr_shd.g_old_rec.position_id;
386: End If;
387: If (p_rec.request_id = hr_api.g_number) then
388: p_rec.request_id :=
389: per_jbr_shd.g_old_rec.request_id;
390: End If;
391: If (p_rec.program_application_id = hr_api.g_number) then
392: p_rec.program_application_id :=
393: per_jbr_shd.g_old_rec.program_application_id;
389: per_jbr_shd.g_old_rec.request_id;
390: End If;
391: If (p_rec.program_application_id = hr_api.g_number) then
392: p_rec.program_application_id :=
393: per_jbr_shd.g_old_rec.program_application_id;
394: End If;
395: If (p_rec.program_id = hr_api.g_number) then
396: p_rec.program_id :=
397: per_jbr_shd.g_old_rec.program_id;
393: per_jbr_shd.g_old_rec.program_application_id;
394: End If;
395: If (p_rec.program_id = hr_api.g_number) then
396: p_rec.program_id :=
397: per_jbr_shd.g_old_rec.program_id;
398: End If;
399: If (p_rec.program_update_date = hr_api.g_date) then
400: p_rec.program_update_date :=
401: per_jbr_shd.g_old_rec.program_update_date;
397: per_jbr_shd.g_old_rec.program_id;
398: End If;
399: If (p_rec.program_update_date = hr_api.g_date) then
400: p_rec.program_update_date :=
401: per_jbr_shd.g_old_rec.program_update_date;
402: End If;
403: If (p_rec.attribute_category = hr_api.g_varchar2) then
404: p_rec.attribute_category :=
405: per_jbr_shd.g_old_rec.attribute_category;
401: per_jbr_shd.g_old_rec.program_update_date;
402: End If;
403: If (p_rec.attribute_category = hr_api.g_varchar2) then
404: p_rec.attribute_category :=
405: per_jbr_shd.g_old_rec.attribute_category;
406: End If;
407: If (p_rec.attribute1 = hr_api.g_varchar2) then
408: p_rec.attribute1 :=
409: per_jbr_shd.g_old_rec.attribute1;
405: per_jbr_shd.g_old_rec.attribute_category;
406: End If;
407: If (p_rec.attribute1 = hr_api.g_varchar2) then
408: p_rec.attribute1 :=
409: per_jbr_shd.g_old_rec.attribute1;
410: End If;
411: If (p_rec.attribute2 = hr_api.g_varchar2) then
412: p_rec.attribute2 :=
413: per_jbr_shd.g_old_rec.attribute2;
409: per_jbr_shd.g_old_rec.attribute1;
410: End If;
411: If (p_rec.attribute2 = hr_api.g_varchar2) then
412: p_rec.attribute2 :=
413: per_jbr_shd.g_old_rec.attribute2;
414: End If;
415: If (p_rec.attribute3 = hr_api.g_varchar2) then
416: p_rec.attribute3 :=
417: per_jbr_shd.g_old_rec.attribute3;
413: per_jbr_shd.g_old_rec.attribute2;
414: End If;
415: If (p_rec.attribute3 = hr_api.g_varchar2) then
416: p_rec.attribute3 :=
417: per_jbr_shd.g_old_rec.attribute3;
418: End If;
419: If (p_rec.attribute4 = hr_api.g_varchar2) then
420: p_rec.attribute4 :=
421: per_jbr_shd.g_old_rec.attribute4;
417: per_jbr_shd.g_old_rec.attribute3;
418: End If;
419: If (p_rec.attribute4 = hr_api.g_varchar2) then
420: p_rec.attribute4 :=
421: per_jbr_shd.g_old_rec.attribute4;
422: End If;
423: If (p_rec.attribute5 = hr_api.g_varchar2) then
424: p_rec.attribute5 :=
425: per_jbr_shd.g_old_rec.attribute5;
421: per_jbr_shd.g_old_rec.attribute4;
422: End If;
423: If (p_rec.attribute5 = hr_api.g_varchar2) then
424: p_rec.attribute5 :=
425: per_jbr_shd.g_old_rec.attribute5;
426: End If;
427: If (p_rec.attribute6 = hr_api.g_varchar2) then
428: p_rec.attribute6 :=
429: per_jbr_shd.g_old_rec.attribute6;
425: per_jbr_shd.g_old_rec.attribute5;
426: End If;
427: If (p_rec.attribute6 = hr_api.g_varchar2) then
428: p_rec.attribute6 :=
429: per_jbr_shd.g_old_rec.attribute6;
430: End If;
431: If (p_rec.attribute7 = hr_api.g_varchar2) then
432: p_rec.attribute7 :=
433: per_jbr_shd.g_old_rec.attribute7;
429: per_jbr_shd.g_old_rec.attribute6;
430: End If;
431: If (p_rec.attribute7 = hr_api.g_varchar2) then
432: p_rec.attribute7 :=
433: per_jbr_shd.g_old_rec.attribute7;
434: End If;
435: If (p_rec.attribute8 = hr_api.g_varchar2) then
436: p_rec.attribute8 :=
437: per_jbr_shd.g_old_rec.attribute8;
433: per_jbr_shd.g_old_rec.attribute7;
434: End If;
435: If (p_rec.attribute8 = hr_api.g_varchar2) then
436: p_rec.attribute8 :=
437: per_jbr_shd.g_old_rec.attribute8;
438: End If;
439: If (p_rec.attribute9 = hr_api.g_varchar2) then
440: p_rec.attribute9 :=
441: per_jbr_shd.g_old_rec.attribute9;
437: per_jbr_shd.g_old_rec.attribute8;
438: End If;
439: If (p_rec.attribute9 = hr_api.g_varchar2) then
440: p_rec.attribute9 :=
441: per_jbr_shd.g_old_rec.attribute9;
442: End If;
443: If (p_rec.attribute10 = hr_api.g_varchar2) then
444: p_rec.attribute10 :=
445: per_jbr_shd.g_old_rec.attribute10;
441: per_jbr_shd.g_old_rec.attribute9;
442: End If;
443: If (p_rec.attribute10 = hr_api.g_varchar2) then
444: p_rec.attribute10 :=
445: per_jbr_shd.g_old_rec.attribute10;
446: End If;
447: If (p_rec.attribute11 = hr_api.g_varchar2) then
448: p_rec.attribute11 :=
449: per_jbr_shd.g_old_rec.attribute11;
445: per_jbr_shd.g_old_rec.attribute10;
446: End If;
447: If (p_rec.attribute11 = hr_api.g_varchar2) then
448: p_rec.attribute11 :=
449: per_jbr_shd.g_old_rec.attribute11;
450: End If;
451: If (p_rec.attribute12 = hr_api.g_varchar2) then
452: p_rec.attribute12 :=
453: per_jbr_shd.g_old_rec.attribute12;
449: per_jbr_shd.g_old_rec.attribute11;
450: End If;
451: If (p_rec.attribute12 = hr_api.g_varchar2) then
452: p_rec.attribute12 :=
453: per_jbr_shd.g_old_rec.attribute12;
454: End If;
455: If (p_rec.attribute13 = hr_api.g_varchar2) then
456: p_rec.attribute13 :=
457: per_jbr_shd.g_old_rec.attribute13;
453: per_jbr_shd.g_old_rec.attribute12;
454: End If;
455: If (p_rec.attribute13 = hr_api.g_varchar2) then
456: p_rec.attribute13 :=
457: per_jbr_shd.g_old_rec.attribute13;
458: End If;
459: If (p_rec.attribute14 = hr_api.g_varchar2) then
460: p_rec.attribute14 :=
461: per_jbr_shd.g_old_rec.attribute14;
457: per_jbr_shd.g_old_rec.attribute13;
458: End If;
459: If (p_rec.attribute14 = hr_api.g_varchar2) then
460: p_rec.attribute14 :=
461: per_jbr_shd.g_old_rec.attribute14;
462: End If;
463: If (p_rec.attribute15 = hr_api.g_varchar2) then
464: p_rec.attribute15 :=
465: per_jbr_shd.g_old_rec.attribute15;
461: per_jbr_shd.g_old_rec.attribute14;
462: End If;
463: If (p_rec.attribute15 = hr_api.g_varchar2) then
464: p_rec.attribute15 :=
465: per_jbr_shd.g_old_rec.attribute15;
466: End If;
467: If (p_rec.attribute16 = hr_api.g_varchar2) then
468: p_rec.attribute16 :=
469: per_jbr_shd.g_old_rec.attribute16;
465: per_jbr_shd.g_old_rec.attribute15;
466: End If;
467: If (p_rec.attribute16 = hr_api.g_varchar2) then
468: p_rec.attribute16 :=
469: per_jbr_shd.g_old_rec.attribute16;
470: End If;
471: If (p_rec.attribute17 = hr_api.g_varchar2) then
472: p_rec.attribute17 :=
473: per_jbr_shd.g_old_rec.attribute17;
469: per_jbr_shd.g_old_rec.attribute16;
470: End If;
471: If (p_rec.attribute17 = hr_api.g_varchar2) then
472: p_rec.attribute17 :=
473: per_jbr_shd.g_old_rec.attribute17;
474: End If;
475: If (p_rec.attribute18 = hr_api.g_varchar2) then
476: p_rec.attribute18 :=
477: per_jbr_shd.g_old_rec.attribute18;
473: per_jbr_shd.g_old_rec.attribute17;
474: End If;
475: If (p_rec.attribute18 = hr_api.g_varchar2) then
476: p_rec.attribute18 :=
477: per_jbr_shd.g_old_rec.attribute18;
478: End If;
479: If (p_rec.attribute19 = hr_api.g_varchar2) then
480: p_rec.attribute19 :=
481: per_jbr_shd.g_old_rec.attribute19;
477: per_jbr_shd.g_old_rec.attribute18;
478: End If;
479: If (p_rec.attribute19 = hr_api.g_varchar2) then
480: p_rec.attribute19 :=
481: per_jbr_shd.g_old_rec.attribute19;
482: End If;
483: If (p_rec.attribute20 = hr_api.g_varchar2) then
484: p_rec.attribute20 :=
485: per_jbr_shd.g_old_rec.attribute20;
481: per_jbr_shd.g_old_rec.attribute19;
482: End If;
483: If (p_rec.attribute20 = hr_api.g_varchar2) then
484: p_rec.attribute20 :=
485: per_jbr_shd.g_old_rec.attribute20;
486: End If;
487:
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: -- |---------------------------------< upd >----------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure upd
497: (
498: p_rec in out nocopy per_jbr_shd.g_rec_type,
499: p_validate in boolean default false
500: ) is
501: --
502: l_proc varchar2(72) := g_package||'upd';
514: End If;
515: --
516: -- We must lock the row which we need to update.
517: --
518: per_jbr_shd.lck
519: (
520: p_rec.job_requirement_id,
521: p_rec.object_version_number
522: );
599: p_object_version_number in out nocopy number,
600: p_validate in boolean default false
601: ) is
602: --
603: l_rec per_jbr_shd.g_rec_type;
604: l_proc varchar2(72) := g_package||'upd';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
609: -- Call conversion function to turn arguments into the
610: -- l_rec structure.
611: --
612: l_rec :=
613: per_jbr_shd.convert_args
614: (
615: p_job_requirement_id,
616: hr_api.g_number,
617: p_analysis_criteria_id,