APPS.PER_PTU_BUS dependencies on HR_API

Line 41: p_person_id in number default hr_api.g_number,

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: --

Line 55: hr_api.mandatory_arg_error

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: --

Line 67: hr_api.mandatory_arg_error

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: --

Line 72: 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: --
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: --

Line 77: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and

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,

Line 163: hr_api.mandatory_arg_error

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: --

Line 177: hr_api.mandatory_arg_error

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: --

Line 182: 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: --
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: --

Line 187: 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: --
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: --

Line 255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

Line 257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 258: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 260: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 262: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 264: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 266: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 268: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 270: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 272: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 274: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 276: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 278: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 280: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 282: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 284: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 286: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 288: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 290: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 292: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

Line 293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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) <>

Line 294: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

Line 295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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) <>

Line 296: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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

Line 297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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) <>

Line 298: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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

Line 299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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) <>

Line 300: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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

Line 301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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) <>

Line 302: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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

Line 303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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) <>

Line 304: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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

Line 305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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) <>

Line 306: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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

Line 307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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) <>

Line 308: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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

Line 309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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) <>

Line 310: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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

Line 311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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) <>

Line 312: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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)))

Line 313: nvl(per_ptu_shd.g_old_rec.attribute29, 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

Line 314: nvl(p_rec.attribute29, hr_api.g_varchar2) 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

Line 315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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: --

Line 316: nvl(p_rec.attribute30, 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: --
320: -- Only execute the validation if absolutely necessary:

Line 437: hr_api.argument_changed_error

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

Line 491: hr_api.mandatory_arg_error

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:

Line 587: hr_api.mandatory_arg_error

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: --

Line 844: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

Line 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.