37: -- {End Of Comments}
38: -- ----------------------------------------------------------------------------
39: Procedure dt_update_validate
40: (
41: p_person_id in number default hr_api.g_number,
42: p_datetrack_mode in varchar2,
43: p_validation_start_date in date,
44: p_validation_end_date in date) Is
45: --
51: hr_utility.set_location('Entering:'||l_proc, 5);
52: --
53: -- Ensure that the p_datetrack_mode argument is not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc,
57: p_argument => 'datetrack_mode',
58: p_argument_value => p_datetrack_mode);
59: --
63: --
64: --
65: -- Ensure the arguments are not null
66: --
67: hr_api.mandatory_arg_error
68: (p_api_name => l_proc,
69: p_argument => 'validation_start_date',
70: p_argument_value => p_validation_start_date);
71: --
68: (p_api_name => l_proc,
69: p_argument => 'validation_start_date',
70: p_argument_value => p_validation_start_date);
71: --
72: hr_api.mandatory_arg_error
73: (p_api_name => l_proc,
74: p_argument => 'validation_end_date',
75: p_argument_value => p_validation_end_date);
76: --
73: (p_api_name => l_proc,
74: p_argument => 'validation_end_date',
75: p_argument_value => p_validation_end_date);
76: --
77: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
78: NOT (dt_api.check_min_max_dates
79: (p_base_table_name => 'per_all_people_f', -- Bug 3111207
80: p_base_key_column => 'person_id',
81: p_base_key_value => p_person_id,
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: -- Ensure that the p_datetrack_mode argument is not null
162: --
163: hr_api.mandatory_arg_error
164: (p_api_name => l_proc,
165: p_argument => 'datetrack_mode',
166: p_argument_value => p_datetrack_mode);
167: --
173: --
174: --
175: -- Ensure the arguments are not null
176: --
177: hr_api.mandatory_arg_error
178: (p_api_name => l_proc,
179: p_argument => 'validation_start_date',
180: p_argument_value => p_validation_start_date);
181: --
178: (p_api_name => l_proc,
179: p_argument => 'validation_start_date',
180: p_argument_value => p_validation_start_date);
181: --
182: hr_api.mandatory_arg_error
183: (p_api_name => l_proc,
184: p_argument => 'validation_end_date',
185: p_argument_value => p_validation_end_date);
186: --
183: (p_api_name => l_proc,
184: p_argument => 'validation_end_date',
185: p_argument_value => p_validation_end_date);
186: --
187: hr_api.mandatory_arg_error
188: (p_api_name => l_proc,
189: p_argument => 'person_type_usage_id',
190: p_argument_value => p_person_type_usage_id);
191: --
251: begin
252: hr_utility.set_location('Entering:'||l_proc, 10);
253: --
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
252: hr_utility.set_location('Entering:'||l_proc, 10);
253: --
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
253: --
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or
318: (p_rec.person_type_usage_id is null) then
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or
318: (p_rec.person_type_usage_id is null) then
319: --
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or
318: (p_rec.person_type_usage_id is null) then
319: --
320: -- Only execute the validation if absolutely necessary:
433: hr_utility.set_location(l_proc, 50);
434: --
435: exception
436: when l_error then
437: hr_api.argument_changed_error
438: (p_api_name => l_proc
439: ,p_argument => l_argument
440: );
441: when others then
487: --
488: --------------------------------
489: -- Check person id not null --
490: --------------------------------
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc,
493: p_argument => 'p_person_id',
494: p_argument_value => p_person_id);
495:
583: -----------------------------------
584: -- Check person type id not null --
585: -----------------------------------
586: --
587: hr_api.mandatory_arg_error
588: (p_api_name => l_proc,
589: p_argument => 'p_person_type_id',
590: p_argument_value => p_person_type_id);
591: --
840: hr_utility.set_location('Entering:'|| l_proc, 10);
841: --
842: -- Ensure that all the mandatory parameter are not null
843: --
844: hr_api.mandatory_arg_error(p_api_name => l_proc,
845: p_argument => 'person_type_usage_id',
846: p_argument_value => p_person_type_usage_id);
847: --
848: if nvl(g_person_type_usage_id, hr_api.g_number) = p_person_type_usage_id then
844: hr_api.mandatory_arg_error(p_api_name => l_proc,
845: p_argument => 'person_type_usage_id',
846: p_argument_value => p_person_type_usage_id);
847: --
848: if nvl(g_person_type_usage_id, hr_api.g_number) = p_person_type_usage_id then
849: --
850: -- The legislation code has already been found with a previous
851: -- call to this function. Just return the value in the global
852: -- variable.