[Home] [Help]
50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_pos_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_pos_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- PMFLETCH Now using per_all_positions
68: --
69: -- Update the per_all_positions Row
114: attribute20 = p_rec.attribute20,
115: object_version_number = p_rec.object_version_number
116: where position_id = p_rec.position_id;
117: --
118: per_pos_shd.g_api_dml := false; -- Unset the api dml status
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: --
122: Exception
121: --
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
126: per_pos_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
131: per_pos_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: per_pos_shd.g_api_dml := false; -- Unset the api dml status
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: per_pos_shd.g_api_dml := false; -- Unset the api dml status
140: Raise;
135: per_pos_shd.g_api_dml := false; -- Unset the api dml status
136: per_pos_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: per_pos_shd.g_api_dml := false; -- Unset the api dml status
140: Raise;
141: End update_dml;
142: --
143: -- ----------------------------------------------------------------------------
171: -- Internal Table Handler Use Only.
172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure pre_update(p_rec in per_pos_shd.g_rec_type) is
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --
179: Begin
213: -- Internal Table Handler Use Only.
214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure post_update(p_rec in per_pos_shd.g_rec_type) is
218: --
219: l_proc varchar2(72) := g_package||'post_update';
220: --
221: Begin
267: ,p_attribute19 => p_rec.attribute19
268: ,p_attribute20 => p_rec.attribute20
269: ,p_object_version_number => p_rec.object_version_number
270: ,p_business_group_id_o
271: => per_pos_shd.g_old_rec.business_group_id
272: ,p_job_id_o
273: => per_pos_shd.g_old_rec.job_id
274: ,p_organization_id_o
275: => per_pos_shd.g_old_rec.organization_id
269: ,p_object_version_number => p_rec.object_version_number
270: ,p_business_group_id_o
271: => per_pos_shd.g_old_rec.business_group_id
272: ,p_job_id_o
273: => per_pos_shd.g_old_rec.job_id
274: ,p_organization_id_o
275: => per_pos_shd.g_old_rec.organization_id
276: ,p_successor_position_id_o
277: => per_pos_shd.g_old_rec.successor_position_id
271: => per_pos_shd.g_old_rec.business_group_id
272: ,p_job_id_o
273: => per_pos_shd.g_old_rec.job_id
274: ,p_organization_id_o
275: => per_pos_shd.g_old_rec.organization_id
276: ,p_successor_position_id_o
277: => per_pos_shd.g_old_rec.successor_position_id
278: ,p_relief_position_id_o
279: => per_pos_shd.g_old_rec.relief_position_id
273: => per_pos_shd.g_old_rec.job_id
274: ,p_organization_id_o
275: => per_pos_shd.g_old_rec.organization_id
276: ,p_successor_position_id_o
277: => per_pos_shd.g_old_rec.successor_position_id
278: ,p_relief_position_id_o
279: => per_pos_shd.g_old_rec.relief_position_id
280: ,p_location_id_o
281: => per_pos_shd.g_old_rec.location_id
275: => per_pos_shd.g_old_rec.organization_id
276: ,p_successor_position_id_o
277: => per_pos_shd.g_old_rec.successor_position_id
278: ,p_relief_position_id_o
279: => per_pos_shd.g_old_rec.relief_position_id
280: ,p_location_id_o
281: => per_pos_shd.g_old_rec.location_id
282: ,p_position_definition_id_o
283: => per_pos_shd.g_old_rec.position_definition_id
277: => per_pos_shd.g_old_rec.successor_position_id
278: ,p_relief_position_id_o
279: => per_pos_shd.g_old_rec.relief_position_id
280: ,p_location_id_o
281: => per_pos_shd.g_old_rec.location_id
282: ,p_position_definition_id_o
283: => per_pos_shd.g_old_rec.position_definition_id
284: ,p_date_effective_o
285: => per_pos_shd.g_old_rec.date_effective
279: => per_pos_shd.g_old_rec.relief_position_id
280: ,p_location_id_o
281: => per_pos_shd.g_old_rec.location_id
282: ,p_position_definition_id_o
283: => per_pos_shd.g_old_rec.position_definition_id
284: ,p_date_effective_o
285: => per_pos_shd.g_old_rec.date_effective
286: ,p_comments_o
287: => per_pos_shd.g_old_rec.comments
281: => per_pos_shd.g_old_rec.location_id
282: ,p_position_definition_id_o
283: => per_pos_shd.g_old_rec.position_definition_id
284: ,p_date_effective_o
285: => per_pos_shd.g_old_rec.date_effective
286: ,p_comments_o
287: => per_pos_shd.g_old_rec.comments
288: ,p_date_end_o
289: => per_pos_shd.g_old_rec.date_end
283: => per_pos_shd.g_old_rec.position_definition_id
284: ,p_date_effective_o
285: => per_pos_shd.g_old_rec.date_effective
286: ,p_comments_o
287: => per_pos_shd.g_old_rec.comments
288: ,p_date_end_o
289: => per_pos_shd.g_old_rec.date_end
290: ,p_frequency_o
291: => per_pos_shd.g_old_rec.frequency
285: => per_pos_shd.g_old_rec.date_effective
286: ,p_comments_o
287: => per_pos_shd.g_old_rec.comments
288: ,p_date_end_o
289: => per_pos_shd.g_old_rec.date_end
290: ,p_frequency_o
291: => per_pos_shd.g_old_rec.frequency
292: ,p_name_o
293: => per_pos_shd.g_old_rec.name
287: => per_pos_shd.g_old_rec.comments
288: ,p_date_end_o
289: => per_pos_shd.g_old_rec.date_end
290: ,p_frequency_o
291: => per_pos_shd.g_old_rec.frequency
292: ,p_name_o
293: => per_pos_shd.g_old_rec.name
294: ,p_probation_period_o
295: => per_pos_shd.g_old_rec.probation_period
289: => per_pos_shd.g_old_rec.date_end
290: ,p_frequency_o
291: => per_pos_shd.g_old_rec.frequency
292: ,p_name_o
293: => per_pos_shd.g_old_rec.name
294: ,p_probation_period_o
295: => per_pos_shd.g_old_rec.probation_period
296: ,p_probation_period_units_o
297: => per_pos_shd.g_old_rec.probation_period_units
291: => per_pos_shd.g_old_rec.frequency
292: ,p_name_o
293: => per_pos_shd.g_old_rec.name
294: ,p_probation_period_o
295: => per_pos_shd.g_old_rec.probation_period
296: ,p_probation_period_units_o
297: => per_pos_shd.g_old_rec.probation_period_units
298: ,p_replacement_required_flag_o
299: => per_pos_shd.g_old_rec.replacement_required_flag
293: => per_pos_shd.g_old_rec.name
294: ,p_probation_period_o
295: => per_pos_shd.g_old_rec.probation_period
296: ,p_probation_period_units_o
297: => per_pos_shd.g_old_rec.probation_period_units
298: ,p_replacement_required_flag_o
299: => per_pos_shd.g_old_rec.replacement_required_flag
300: ,p_time_normal_finish_o
301: => per_pos_shd.g_old_rec.time_normal_finish
295: => per_pos_shd.g_old_rec.probation_period
296: ,p_probation_period_units_o
297: => per_pos_shd.g_old_rec.probation_period_units
298: ,p_replacement_required_flag_o
299: => per_pos_shd.g_old_rec.replacement_required_flag
300: ,p_time_normal_finish_o
301: => per_pos_shd.g_old_rec.time_normal_finish
302: ,p_time_normal_start_o
303: => per_pos_shd.g_old_rec.time_normal_start
297: => per_pos_shd.g_old_rec.probation_period_units
298: ,p_replacement_required_flag_o
299: => per_pos_shd.g_old_rec.replacement_required_flag
300: ,p_time_normal_finish_o
301: => per_pos_shd.g_old_rec.time_normal_finish
302: ,p_time_normal_start_o
303: => per_pos_shd.g_old_rec.time_normal_start
304: ,p_status_o
305: => per_pos_shd.g_old_rec.status
299: => per_pos_shd.g_old_rec.replacement_required_flag
300: ,p_time_normal_finish_o
301: => per_pos_shd.g_old_rec.time_normal_finish
302: ,p_time_normal_start_o
303: => per_pos_shd.g_old_rec.time_normal_start
304: ,p_status_o
305: => per_pos_shd.g_old_rec.status
306: ,p_working_hours_o
307: => per_pos_shd.g_old_rec.working_hours
301: => per_pos_shd.g_old_rec.time_normal_finish
302: ,p_time_normal_start_o
303: => per_pos_shd.g_old_rec.time_normal_start
304: ,p_status_o
305: => per_pos_shd.g_old_rec.status
306: ,p_working_hours_o
307: => per_pos_shd.g_old_rec.working_hours
308: ,p_request_id_o
309: => per_pos_shd.g_old_rec.request_id
303: => per_pos_shd.g_old_rec.time_normal_start
304: ,p_status_o
305: => per_pos_shd.g_old_rec.status
306: ,p_working_hours_o
307: => per_pos_shd.g_old_rec.working_hours
308: ,p_request_id_o
309: => per_pos_shd.g_old_rec.request_id
310: ,p_program_application_id_o
311: => per_pos_shd.g_old_rec.program_application_id
305: => per_pos_shd.g_old_rec.status
306: ,p_working_hours_o
307: => per_pos_shd.g_old_rec.working_hours
308: ,p_request_id_o
309: => per_pos_shd.g_old_rec.request_id
310: ,p_program_application_id_o
311: => per_pos_shd.g_old_rec.program_application_id
312: ,p_program_id_o
313: => per_pos_shd.g_old_rec.program_id
307: => per_pos_shd.g_old_rec.working_hours
308: ,p_request_id_o
309: => per_pos_shd.g_old_rec.request_id
310: ,p_program_application_id_o
311: => per_pos_shd.g_old_rec.program_application_id
312: ,p_program_id_o
313: => per_pos_shd.g_old_rec.program_id
314: ,p_program_update_date_o
315: => per_pos_shd.g_old_rec.program_update_date
309: => per_pos_shd.g_old_rec.request_id
310: ,p_program_application_id_o
311: => per_pos_shd.g_old_rec.program_application_id
312: ,p_program_id_o
313: => per_pos_shd.g_old_rec.program_id
314: ,p_program_update_date_o
315: => per_pos_shd.g_old_rec.program_update_date
316: ,p_attribute_category_o
317: => per_pos_shd.g_old_rec.attribute_category
311: => per_pos_shd.g_old_rec.program_application_id
312: ,p_program_id_o
313: => per_pos_shd.g_old_rec.program_id
314: ,p_program_update_date_o
315: => per_pos_shd.g_old_rec.program_update_date
316: ,p_attribute_category_o
317: => per_pos_shd.g_old_rec.attribute_category
318: ,p_attribute1_o
319: => per_pos_shd.g_old_rec.attribute1
313: => per_pos_shd.g_old_rec.program_id
314: ,p_program_update_date_o
315: => per_pos_shd.g_old_rec.program_update_date
316: ,p_attribute_category_o
317: => per_pos_shd.g_old_rec.attribute_category
318: ,p_attribute1_o
319: => per_pos_shd.g_old_rec.attribute1
320: ,p_attribute2_o
321: => per_pos_shd.g_old_rec.attribute2
315: => per_pos_shd.g_old_rec.program_update_date
316: ,p_attribute_category_o
317: => per_pos_shd.g_old_rec.attribute_category
318: ,p_attribute1_o
319: => per_pos_shd.g_old_rec.attribute1
320: ,p_attribute2_o
321: => per_pos_shd.g_old_rec.attribute2
322: ,p_attribute3_o
323: => per_pos_shd.g_old_rec.attribute3
317: => per_pos_shd.g_old_rec.attribute_category
318: ,p_attribute1_o
319: => per_pos_shd.g_old_rec.attribute1
320: ,p_attribute2_o
321: => per_pos_shd.g_old_rec.attribute2
322: ,p_attribute3_o
323: => per_pos_shd.g_old_rec.attribute3
324: ,p_attribute4_o
325: => per_pos_shd.g_old_rec.attribute4
319: => per_pos_shd.g_old_rec.attribute1
320: ,p_attribute2_o
321: => per_pos_shd.g_old_rec.attribute2
322: ,p_attribute3_o
323: => per_pos_shd.g_old_rec.attribute3
324: ,p_attribute4_o
325: => per_pos_shd.g_old_rec.attribute4
326: ,p_attribute5_o
327: => per_pos_shd.g_old_rec.attribute5
321: => per_pos_shd.g_old_rec.attribute2
322: ,p_attribute3_o
323: => per_pos_shd.g_old_rec.attribute3
324: ,p_attribute4_o
325: => per_pos_shd.g_old_rec.attribute4
326: ,p_attribute5_o
327: => per_pos_shd.g_old_rec.attribute5
328: ,p_attribute6_o
329: => per_pos_shd.g_old_rec.attribute6
323: => per_pos_shd.g_old_rec.attribute3
324: ,p_attribute4_o
325: => per_pos_shd.g_old_rec.attribute4
326: ,p_attribute5_o
327: => per_pos_shd.g_old_rec.attribute5
328: ,p_attribute6_o
329: => per_pos_shd.g_old_rec.attribute6
330: ,p_attribute7_o
331: => per_pos_shd.g_old_rec.attribute7
325: => per_pos_shd.g_old_rec.attribute4
326: ,p_attribute5_o
327: => per_pos_shd.g_old_rec.attribute5
328: ,p_attribute6_o
329: => per_pos_shd.g_old_rec.attribute6
330: ,p_attribute7_o
331: => per_pos_shd.g_old_rec.attribute7
332: ,p_attribute8_o
333: => per_pos_shd.g_old_rec.attribute8
327: => per_pos_shd.g_old_rec.attribute5
328: ,p_attribute6_o
329: => per_pos_shd.g_old_rec.attribute6
330: ,p_attribute7_o
331: => per_pos_shd.g_old_rec.attribute7
332: ,p_attribute8_o
333: => per_pos_shd.g_old_rec.attribute8
334: ,p_attribute9_o
335: => per_pos_shd.g_old_rec.attribute9
329: => per_pos_shd.g_old_rec.attribute6
330: ,p_attribute7_o
331: => per_pos_shd.g_old_rec.attribute7
332: ,p_attribute8_o
333: => per_pos_shd.g_old_rec.attribute8
334: ,p_attribute9_o
335: => per_pos_shd.g_old_rec.attribute9
336: ,p_attribute10_o
337: => per_pos_shd.g_old_rec.attribute10
331: => per_pos_shd.g_old_rec.attribute7
332: ,p_attribute8_o
333: => per_pos_shd.g_old_rec.attribute8
334: ,p_attribute9_o
335: => per_pos_shd.g_old_rec.attribute9
336: ,p_attribute10_o
337: => per_pos_shd.g_old_rec.attribute10
338: ,p_attribute11_o
339: => per_pos_shd.g_old_rec.attribute11
333: => per_pos_shd.g_old_rec.attribute8
334: ,p_attribute9_o
335: => per_pos_shd.g_old_rec.attribute9
336: ,p_attribute10_o
337: => per_pos_shd.g_old_rec.attribute10
338: ,p_attribute11_o
339: => per_pos_shd.g_old_rec.attribute11
340: ,p_attribute12_o
341: => per_pos_shd.g_old_rec.attribute12
335: => per_pos_shd.g_old_rec.attribute9
336: ,p_attribute10_o
337: => per_pos_shd.g_old_rec.attribute10
338: ,p_attribute11_o
339: => per_pos_shd.g_old_rec.attribute11
340: ,p_attribute12_o
341: => per_pos_shd.g_old_rec.attribute12
342: ,p_attribute13_o
343: => per_pos_shd.g_old_rec.attribute13
337: => per_pos_shd.g_old_rec.attribute10
338: ,p_attribute11_o
339: => per_pos_shd.g_old_rec.attribute11
340: ,p_attribute12_o
341: => per_pos_shd.g_old_rec.attribute12
342: ,p_attribute13_o
343: => per_pos_shd.g_old_rec.attribute13
344: ,p_attribute14_o
345: => per_pos_shd.g_old_rec.attribute14
339: => per_pos_shd.g_old_rec.attribute11
340: ,p_attribute12_o
341: => per_pos_shd.g_old_rec.attribute12
342: ,p_attribute13_o
343: => per_pos_shd.g_old_rec.attribute13
344: ,p_attribute14_o
345: => per_pos_shd.g_old_rec.attribute14
346: ,p_attribute15_o
347: => per_pos_shd.g_old_rec.attribute15
341: => per_pos_shd.g_old_rec.attribute12
342: ,p_attribute13_o
343: => per_pos_shd.g_old_rec.attribute13
344: ,p_attribute14_o
345: => per_pos_shd.g_old_rec.attribute14
346: ,p_attribute15_o
347: => per_pos_shd.g_old_rec.attribute15
348: ,p_attribute16_o
349: => per_pos_shd.g_old_rec.attribute16
343: => per_pos_shd.g_old_rec.attribute13
344: ,p_attribute14_o
345: => per_pos_shd.g_old_rec.attribute14
346: ,p_attribute15_o
347: => per_pos_shd.g_old_rec.attribute15
348: ,p_attribute16_o
349: => per_pos_shd.g_old_rec.attribute16
350: ,p_attribute17_o
351: => per_pos_shd.g_old_rec.attribute17
345: => per_pos_shd.g_old_rec.attribute14
346: ,p_attribute15_o
347: => per_pos_shd.g_old_rec.attribute15
348: ,p_attribute16_o
349: => per_pos_shd.g_old_rec.attribute16
350: ,p_attribute17_o
351: => per_pos_shd.g_old_rec.attribute17
352: ,p_attribute18_o
353: => per_pos_shd.g_old_rec.attribute18
347: => per_pos_shd.g_old_rec.attribute15
348: ,p_attribute16_o
349: => per_pos_shd.g_old_rec.attribute16
350: ,p_attribute17_o
351: => per_pos_shd.g_old_rec.attribute17
352: ,p_attribute18_o
353: => per_pos_shd.g_old_rec.attribute18
354: ,p_attribute19_o
355: => per_pos_shd.g_old_rec.attribute19
349: => per_pos_shd.g_old_rec.attribute16
350: ,p_attribute17_o
351: => per_pos_shd.g_old_rec.attribute17
352: ,p_attribute18_o
353: => per_pos_shd.g_old_rec.attribute18
354: ,p_attribute19_o
355: => per_pos_shd.g_old_rec.attribute19
356: ,p_attribute20_o
357: => per_pos_shd.g_old_rec.attribute20
351: => per_pos_shd.g_old_rec.attribute17
352: ,p_attribute18_o
353: => per_pos_shd.g_old_rec.attribute18
354: ,p_attribute19_o
355: => per_pos_shd.g_old_rec.attribute19
356: ,p_attribute20_o
357: => per_pos_shd.g_old_rec.attribute20
358: ,p_object_version_number_o
359: => per_pos_shd.g_old_rec.object_version_number
353: => per_pos_shd.g_old_rec.attribute18
354: ,p_attribute19_o
355: => per_pos_shd.g_old_rec.attribute19
356: ,p_attribute20_o
357: => per_pos_shd.g_old_rec.attribute20
358: ,p_object_version_number_o
359: => per_pos_shd.g_old_rec.object_version_number
360: );
361: exception
355: => per_pos_shd.g_old_rec.attribute19
356: ,p_attribute20_o
357: => per_pos_shd.g_old_rec.attribute20
358: ,p_object_version_number_o
359: => per_pos_shd.g_old_rec.object_version_number
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error
413: -- Internal Table Handler Use Only.
414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure convert_defs(p_rec in out nocopy per_pos_shd.g_rec_type) is
418: --
419: l_proc varchar2(72) := g_package||'convert_defs';
420: --
421: Begin
428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.business_group_id = hr_api.g_number) then
431: p_rec.business_group_id :=
432: per_pos_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.job_id = hr_api.g_number) then
435: p_rec.job_id :=
436: per_pos_shd.g_old_rec.job_id;
432: per_pos_shd.g_old_rec.business_group_id;
433: End If;
434: If (p_rec.job_id = hr_api.g_number) then
435: p_rec.job_id :=
436: per_pos_shd.g_old_rec.job_id;
437: End If;
438: If (p_rec.organization_id = hr_api.g_number) then
439: p_rec.organization_id :=
440: per_pos_shd.g_old_rec.organization_id;
436: per_pos_shd.g_old_rec.job_id;
437: End If;
438: If (p_rec.organization_id = hr_api.g_number) then
439: p_rec.organization_id :=
440: per_pos_shd.g_old_rec.organization_id;
441: End If;
442: If (p_rec.successor_position_id = hr_api.g_number) then
443: p_rec.successor_position_id :=
444: per_pos_shd.g_old_rec.successor_position_id;
440: per_pos_shd.g_old_rec.organization_id;
441: End If;
442: If (p_rec.successor_position_id = hr_api.g_number) then
443: p_rec.successor_position_id :=
444: per_pos_shd.g_old_rec.successor_position_id;
445: End If;
446: If (p_rec.relief_position_id = hr_api.g_number) then
447: p_rec.relief_position_id :=
448: per_pos_shd.g_old_rec.relief_position_id;
444: per_pos_shd.g_old_rec.successor_position_id;
445: End If;
446: If (p_rec.relief_position_id = hr_api.g_number) then
447: p_rec.relief_position_id :=
448: per_pos_shd.g_old_rec.relief_position_id;
449: End If;
450: If (p_rec.location_id = hr_api.g_number) then
451: p_rec.location_id :=
452: per_pos_shd.g_old_rec.location_id;
448: per_pos_shd.g_old_rec.relief_position_id;
449: End If;
450: If (p_rec.location_id = hr_api.g_number) then
451: p_rec.location_id :=
452: per_pos_shd.g_old_rec.location_id;
453: End If;
454: If (p_rec.position_definition_id = hr_api.g_number) then
455: p_rec.position_definition_id :=
456: per_pos_shd.g_old_rec.position_definition_id;
452: per_pos_shd.g_old_rec.location_id;
453: End If;
454: If (p_rec.position_definition_id = hr_api.g_number) then
455: p_rec.position_definition_id :=
456: per_pos_shd.g_old_rec.position_definition_id;
457: End If;
458: If (p_rec.date_effective = hr_api.g_date) then
459: p_rec.date_effective :=
460: per_pos_shd.g_old_rec.date_effective;
456: per_pos_shd.g_old_rec.position_definition_id;
457: End If;
458: If (p_rec.date_effective = hr_api.g_date) then
459: p_rec.date_effective :=
460: per_pos_shd.g_old_rec.date_effective;
461: End If;
462: If (p_rec.comments = hr_api.g_varchar2) then
463: p_rec.comments :=
464: per_pos_shd.g_old_rec.comments;
460: per_pos_shd.g_old_rec.date_effective;
461: End If;
462: If (p_rec.comments = hr_api.g_varchar2) then
463: p_rec.comments :=
464: per_pos_shd.g_old_rec.comments;
465: End If;
466: If (p_rec.date_end = hr_api.g_date) then
467: p_rec.date_end :=
468: per_pos_shd.g_old_rec.date_end;
464: per_pos_shd.g_old_rec.comments;
465: End If;
466: If (p_rec.date_end = hr_api.g_date) then
467: p_rec.date_end :=
468: per_pos_shd.g_old_rec.date_end;
469: End If;
470: If (p_rec.frequency = hr_api.g_varchar2) then
471: p_rec.frequency :=
472: per_pos_shd.g_old_rec.frequency;
468: per_pos_shd.g_old_rec.date_end;
469: End If;
470: If (p_rec.frequency = hr_api.g_varchar2) then
471: p_rec.frequency :=
472: per_pos_shd.g_old_rec.frequency;
473: End If;
474: If (p_rec.name = hr_api.g_varchar2) then
475: p_rec.name :=
476: per_pos_shd.g_old_rec.name;
472: per_pos_shd.g_old_rec.frequency;
473: End If;
474: If (p_rec.name = hr_api.g_varchar2) then
475: p_rec.name :=
476: per_pos_shd.g_old_rec.name;
477: End If;
478: If (p_rec.probation_period = hr_api.g_number) then
479: p_rec.probation_period :=
480: per_pos_shd.g_old_rec.probation_period;
476: per_pos_shd.g_old_rec.name;
477: End If;
478: If (p_rec.probation_period = hr_api.g_number) then
479: p_rec.probation_period :=
480: per_pos_shd.g_old_rec.probation_period;
481: End If;
482: If (p_rec.probation_period_units = hr_api.g_varchar2) then
483: p_rec.probation_period_units :=
484: per_pos_shd.g_old_rec.probation_period_units;
480: per_pos_shd.g_old_rec.probation_period;
481: End If;
482: If (p_rec.probation_period_units = hr_api.g_varchar2) then
483: p_rec.probation_period_units :=
484: per_pos_shd.g_old_rec.probation_period_units;
485: End If;
486: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
487: p_rec.replacement_required_flag :=
488: per_pos_shd.g_old_rec.replacement_required_flag;
484: per_pos_shd.g_old_rec.probation_period_units;
485: End If;
486: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
487: p_rec.replacement_required_flag :=
488: per_pos_shd.g_old_rec.replacement_required_flag;
489: End If;
490: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
491: p_rec.time_normal_finish :=
492: per_pos_shd.g_old_rec.time_normal_finish;
488: per_pos_shd.g_old_rec.replacement_required_flag;
489: End If;
490: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
491: p_rec.time_normal_finish :=
492: per_pos_shd.g_old_rec.time_normal_finish;
493: End If;
494: If (p_rec.time_normal_start = hr_api.g_varchar2) then
495: p_rec.time_normal_start :=
496: per_pos_shd.g_old_rec.time_normal_start;
492: per_pos_shd.g_old_rec.time_normal_finish;
493: End If;
494: If (p_rec.time_normal_start = hr_api.g_varchar2) then
495: p_rec.time_normal_start :=
496: per_pos_shd.g_old_rec.time_normal_start;
497: End If;
498: If (p_rec.status = hr_api.g_varchar2) then
499: p_rec.status :=
500: per_pos_shd.g_old_rec.status;
496: per_pos_shd.g_old_rec.time_normal_start;
497: End If;
498: If (p_rec.status = hr_api.g_varchar2) then
499: p_rec.status :=
500: per_pos_shd.g_old_rec.status;
501: End If;
502: If (p_rec.working_hours = hr_api.g_number) then
503: p_rec.working_hours :=
504: per_pos_shd.g_old_rec.working_hours;
500: per_pos_shd.g_old_rec.status;
501: End If;
502: If (p_rec.working_hours = hr_api.g_number) then
503: p_rec.working_hours :=
504: per_pos_shd.g_old_rec.working_hours;
505: End If;
506: If (p_rec.request_id = hr_api.g_number) then
507: p_rec.request_id :=
508: per_pos_shd.g_old_rec.request_id;
504: per_pos_shd.g_old_rec.working_hours;
505: End If;
506: If (p_rec.request_id = hr_api.g_number) then
507: p_rec.request_id :=
508: per_pos_shd.g_old_rec.request_id;
509: End If;
510: If (p_rec.program_application_id = hr_api.g_number) then
511: p_rec.program_application_id :=
512: per_pos_shd.g_old_rec.program_application_id;
508: per_pos_shd.g_old_rec.request_id;
509: End If;
510: If (p_rec.program_application_id = hr_api.g_number) then
511: p_rec.program_application_id :=
512: per_pos_shd.g_old_rec.program_application_id;
513: End If;
514: If (p_rec.program_id = hr_api.g_number) then
515: p_rec.program_id :=
516: per_pos_shd.g_old_rec.program_id;
512: per_pos_shd.g_old_rec.program_application_id;
513: End If;
514: If (p_rec.program_id = hr_api.g_number) then
515: p_rec.program_id :=
516: per_pos_shd.g_old_rec.program_id;
517: End If;
518: If (p_rec.program_update_date = hr_api.g_date) then
519: p_rec.program_update_date :=
520: per_pos_shd.g_old_rec.program_update_date;
516: per_pos_shd.g_old_rec.program_id;
517: End If;
518: If (p_rec.program_update_date = hr_api.g_date) then
519: p_rec.program_update_date :=
520: per_pos_shd.g_old_rec.program_update_date;
521: End If;
522: If (p_rec.attribute_category = hr_api.g_varchar2) then
523: p_rec.attribute_category :=
524: per_pos_shd.g_old_rec.attribute_category;
520: per_pos_shd.g_old_rec.program_update_date;
521: End If;
522: If (p_rec.attribute_category = hr_api.g_varchar2) then
523: p_rec.attribute_category :=
524: per_pos_shd.g_old_rec.attribute_category;
525: End If;
526: If (p_rec.attribute1 = hr_api.g_varchar2) then
527: p_rec.attribute1 :=
528: per_pos_shd.g_old_rec.attribute1;
524: per_pos_shd.g_old_rec.attribute_category;
525: End If;
526: If (p_rec.attribute1 = hr_api.g_varchar2) then
527: p_rec.attribute1 :=
528: per_pos_shd.g_old_rec.attribute1;
529: End If;
530: If (p_rec.attribute2 = hr_api.g_varchar2) then
531: p_rec.attribute2 :=
532: per_pos_shd.g_old_rec.attribute2;
528: per_pos_shd.g_old_rec.attribute1;
529: End If;
530: If (p_rec.attribute2 = hr_api.g_varchar2) then
531: p_rec.attribute2 :=
532: per_pos_shd.g_old_rec.attribute2;
533: End If;
534: If (p_rec.attribute3 = hr_api.g_varchar2) then
535: p_rec.attribute3 :=
536: per_pos_shd.g_old_rec.attribute3;
532: per_pos_shd.g_old_rec.attribute2;
533: End If;
534: If (p_rec.attribute3 = hr_api.g_varchar2) then
535: p_rec.attribute3 :=
536: per_pos_shd.g_old_rec.attribute3;
537: End If;
538: If (p_rec.attribute4 = hr_api.g_varchar2) then
539: p_rec.attribute4 :=
540: per_pos_shd.g_old_rec.attribute4;
536: per_pos_shd.g_old_rec.attribute3;
537: End If;
538: If (p_rec.attribute4 = hr_api.g_varchar2) then
539: p_rec.attribute4 :=
540: per_pos_shd.g_old_rec.attribute4;
541: End If;
542: If (p_rec.attribute5 = hr_api.g_varchar2) then
543: p_rec.attribute5 :=
544: per_pos_shd.g_old_rec.attribute5;
540: per_pos_shd.g_old_rec.attribute4;
541: End If;
542: If (p_rec.attribute5 = hr_api.g_varchar2) then
543: p_rec.attribute5 :=
544: per_pos_shd.g_old_rec.attribute5;
545: End If;
546: If (p_rec.attribute6 = hr_api.g_varchar2) then
547: p_rec.attribute6 :=
548: per_pos_shd.g_old_rec.attribute6;
544: per_pos_shd.g_old_rec.attribute5;
545: End If;
546: If (p_rec.attribute6 = hr_api.g_varchar2) then
547: p_rec.attribute6 :=
548: per_pos_shd.g_old_rec.attribute6;
549: End If;
550: If (p_rec.attribute7 = hr_api.g_varchar2) then
551: p_rec.attribute7 :=
552: per_pos_shd.g_old_rec.attribute7;
548: per_pos_shd.g_old_rec.attribute6;
549: End If;
550: If (p_rec.attribute7 = hr_api.g_varchar2) then
551: p_rec.attribute7 :=
552: per_pos_shd.g_old_rec.attribute7;
553: End If;
554: If (p_rec.attribute8 = hr_api.g_varchar2) then
555: p_rec.attribute8 :=
556: per_pos_shd.g_old_rec.attribute8;
552: per_pos_shd.g_old_rec.attribute7;
553: End If;
554: If (p_rec.attribute8 = hr_api.g_varchar2) then
555: p_rec.attribute8 :=
556: per_pos_shd.g_old_rec.attribute8;
557: End If;
558: If (p_rec.attribute9 = hr_api.g_varchar2) then
559: p_rec.attribute9 :=
560: per_pos_shd.g_old_rec.attribute9;
556: per_pos_shd.g_old_rec.attribute8;
557: End If;
558: If (p_rec.attribute9 = hr_api.g_varchar2) then
559: p_rec.attribute9 :=
560: per_pos_shd.g_old_rec.attribute9;
561: End If;
562: If (p_rec.attribute10 = hr_api.g_varchar2) then
563: p_rec.attribute10 :=
564: per_pos_shd.g_old_rec.attribute10;
560: per_pos_shd.g_old_rec.attribute9;
561: End If;
562: If (p_rec.attribute10 = hr_api.g_varchar2) then
563: p_rec.attribute10 :=
564: per_pos_shd.g_old_rec.attribute10;
565: End If;
566: If (p_rec.attribute11 = hr_api.g_varchar2) then
567: p_rec.attribute11 :=
568: per_pos_shd.g_old_rec.attribute11;
564: per_pos_shd.g_old_rec.attribute10;
565: End If;
566: If (p_rec.attribute11 = hr_api.g_varchar2) then
567: p_rec.attribute11 :=
568: per_pos_shd.g_old_rec.attribute11;
569: End If;
570: If (p_rec.attribute12 = hr_api.g_varchar2) then
571: p_rec.attribute12 :=
572: per_pos_shd.g_old_rec.attribute12;
568: per_pos_shd.g_old_rec.attribute11;
569: End If;
570: If (p_rec.attribute12 = hr_api.g_varchar2) then
571: p_rec.attribute12 :=
572: per_pos_shd.g_old_rec.attribute12;
573: End If;
574: If (p_rec.attribute13 = hr_api.g_varchar2) then
575: p_rec.attribute13 :=
576: per_pos_shd.g_old_rec.attribute13;
572: per_pos_shd.g_old_rec.attribute12;
573: End If;
574: If (p_rec.attribute13 = hr_api.g_varchar2) then
575: p_rec.attribute13 :=
576: per_pos_shd.g_old_rec.attribute13;
577: End If;
578: If (p_rec.attribute14 = hr_api.g_varchar2) then
579: p_rec.attribute14 :=
580: per_pos_shd.g_old_rec.attribute14;
576: per_pos_shd.g_old_rec.attribute13;
577: End If;
578: If (p_rec.attribute14 = hr_api.g_varchar2) then
579: p_rec.attribute14 :=
580: per_pos_shd.g_old_rec.attribute14;
581: End If;
582: If (p_rec.attribute15 = hr_api.g_varchar2) then
583: p_rec.attribute15 :=
584: per_pos_shd.g_old_rec.attribute15;
580: per_pos_shd.g_old_rec.attribute14;
581: End If;
582: If (p_rec.attribute15 = hr_api.g_varchar2) then
583: p_rec.attribute15 :=
584: per_pos_shd.g_old_rec.attribute15;
585: End If;
586: If (p_rec.attribute16 = hr_api.g_varchar2) then
587: p_rec.attribute16 :=
588: per_pos_shd.g_old_rec.attribute16;
584: per_pos_shd.g_old_rec.attribute15;
585: End If;
586: If (p_rec.attribute16 = hr_api.g_varchar2) then
587: p_rec.attribute16 :=
588: per_pos_shd.g_old_rec.attribute16;
589: End If;
590: If (p_rec.attribute17 = hr_api.g_varchar2) then
591: p_rec.attribute17 :=
592: per_pos_shd.g_old_rec.attribute17;
588: per_pos_shd.g_old_rec.attribute16;
589: End If;
590: If (p_rec.attribute17 = hr_api.g_varchar2) then
591: p_rec.attribute17 :=
592: per_pos_shd.g_old_rec.attribute17;
593: End If;
594: If (p_rec.attribute18 = hr_api.g_varchar2) then
595: p_rec.attribute18 :=
596: per_pos_shd.g_old_rec.attribute18;
592: per_pos_shd.g_old_rec.attribute17;
593: End If;
594: If (p_rec.attribute18 = hr_api.g_varchar2) then
595: p_rec.attribute18 :=
596: per_pos_shd.g_old_rec.attribute18;
597: End If;
598: If (p_rec.attribute19 = hr_api.g_varchar2) then
599: p_rec.attribute19 :=
600: per_pos_shd.g_old_rec.attribute19;
596: per_pos_shd.g_old_rec.attribute18;
597: End If;
598: If (p_rec.attribute19 = hr_api.g_varchar2) then
599: p_rec.attribute19 :=
600: per_pos_shd.g_old_rec.attribute19;
601: End If;
602: If (p_rec.attribute20 = hr_api.g_varchar2) then
603: p_rec.attribute20 :=
604: per_pos_shd.g_old_rec.attribute20;
600: per_pos_shd.g_old_rec.attribute19;
601: End If;
602: If (p_rec.attribute20 = hr_api.g_varchar2) then
603: p_rec.attribute20 :=
604: per_pos_shd.g_old_rec.attribute20;
605: End If;
606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: --
612: -- |---------------------------------< upd >----------------------------------|
613: -- ----------------------------------------------------------------------------
614: Procedure upd
615: (
616: p_rec in out nocopy per_pos_shd.g_rec_type,
617: p_validate in boolean default false
618: ) is
619: --
620: l_proc varchar2(72) := g_package||'upd';
633: --
634: -- We must lock the row which we need to update.
635: --
636: --
637: per_pos_shd.lck
638: (
639: p_rec.position_id,
640: p_rec.object_version_number
641: );
727: p_object_version_number in out nocopy number,
728: p_validate in boolean default false
729: ) is
730: --
731: l_rec per_pos_shd.g_rec_type;
732: l_proc varchar2(72) := g_package||'upd';
733: --
734: Begin
735: hr_utility.set_location('Entering:'||l_proc, 5);
737: -- Call conversion function to turn arguments into the
738: -- l_rec structure.
739: --
740: l_rec :=
741: per_pos_shd.convert_args
742: (
743: p_position_id,
744: hr_api.g_number,
745: hr_api.g_number,