APPS.PER_ASR_BUS dependencies on HR_API

Line 54: hr_api.argument_changed_error

50: end if;
51: --
52: exception
53: when l_error then
54: hr_api.argument_changed_error
55: (p_api_name => l_proc
56: ,p_argument => l_argument);
57: when others then
58: raise;

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: -- Check that the business_group_id is not null.
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'business_group_id'
119: ,p_argument_value => p_business_group_id
120: );

Line 135: nvl(per_asr_shd.g_old_rec.name, hr_api.g_varchar2)

131: --
132: hr_utility.set_location (l_proc, 2);
133: --
134: if (l_api_updating AND
135: nvl(per_asr_shd.g_old_rec.name, hr_api.g_varchar2)
136: <> nvl(p_name, hr_api.g_varchar2)
137: or not l_api_updating)
138: then
139: --

Line 136: <> nvl(p_name, hr_api.g_varchar2)

132: hr_utility.set_location (l_proc, 2);
133: --
134: if (l_api_updating AND
135: nvl(per_asr_shd.g_old_rec.name, hr_api.g_varchar2)
136: <> nvl(p_name, hr_api.g_varchar2)
137: or not l_api_updating)
138: then
139: --
140: hr_utility.set_location (l_proc, 3);

Line 260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

256: begin
257: hr_utility.set_location('Entering:'||l_proc, 10);
258: --
259: if ((p_rec.assessment_group_id is not null) and (
260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

257: hr_utility.set_location('Entering:'||l_proc, 10);
258: --
259: if ((p_rec.assessment_group_id is not null) and (
260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

258: --
259: if ((p_rec.assessment_group_id is not null) and (
260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

259: if ((p_rec.assessment_group_id is not null) and (
260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

262: nvl(per_asr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

263: nvl(p_rec.attribute1, hr_api.g_varchar2) or
264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

264: nvl(per_asr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

265: nvl(p_rec.attribute2, hr_api.g_varchar2) or
266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

266: nvl(per_asr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

267: nvl(p_rec.attribute3, hr_api.g_varchar2) or
268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

268: nvl(per_asr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

269: nvl(p_rec.attribute4, hr_api.g_varchar2) or
270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

270: nvl(per_asr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

271: nvl(p_rec.attribute5, hr_api.g_varchar2) or
272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

272: nvl(per_asr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

273: nvl(p_rec.attribute6, hr_api.g_varchar2) or
274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

274: nvl(per_asr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

275: nvl(p_rec.attribute7, hr_api.g_varchar2) or
276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

276: nvl(per_asr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

277: nvl(p_rec.attribute8, hr_api.g_varchar2) or
278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

278: nvl(per_asr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

279: nvl(p_rec.attribute9, hr_api.g_varchar2) or
280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

280: nvl(per_asr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

281: nvl(p_rec.attribute10, hr_api.g_varchar2) or
282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

282: nvl(per_asr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

283: nvl(p_rec.attribute11, hr_api.g_varchar2) or
284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

284: nvl(per_asr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

285: nvl(p_rec.attribute12, hr_api.g_varchar2) or
286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

286: nvl(per_asr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

287: nvl(p_rec.attribute13, hr_api.g_varchar2) or
288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

288: nvl(per_asr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

289: nvl(p_rec.attribute14, hr_api.g_varchar2) or
290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

290: nvl(per_asr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

291: nvl(p_rec.attribute15, hr_api.g_varchar2) or
292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

292: nvl(per_asr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

293: nvl(p_rec.attribute16, hr_api.g_varchar2) or
294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

294: nvl(per_asr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute20, hr_api.g_varchar2)))
302: or

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

295: nvl(p_rec.attribute17, hr_api.g_varchar2) or
296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute20, hr_api.g_varchar2)))
302: or
303: (p_rec.assessment_group_id is null) then

Line 300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

296: nvl(per_asr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute20, hr_api.g_varchar2)))
302: or
303: (p_rec.assessment_group_id is null) then
304: --

Line 301: nvl(p_rec.attribute20, hr_api.g_varchar2)))

297: nvl(p_rec.attribute18, hr_api.g_varchar2) or
298: nvl(per_asr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute19, hr_api.g_varchar2) or
300: nvl(per_asr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute20, hr_api.g_varchar2)))
302: or
303: (p_rec.assessment_group_id is null) then
304: --
305: -- Only execute the validation if absolutely necessary:

Line 375: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call all supporting business operations
374: --
375: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
376: --
377: -- VALIDATE CHK_NAME_UNIQUE
378: -- Business Rule Mapping
379: -- ---------------------

Line 411: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

407: --
408: -- Call all supporting business operations. Mapping is provided
409: --
410: --
411: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
412: --
413: -- VALIDATE CHK_NON_UPDATABLE_ARGS
414: -- Check those columns which cannot be updated have not changed.
415: -- Business Rule Mapping

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

478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- Ensure that all the mandatory parameters are not null
481: --
482: hr_api.mandatory_arg_error (p_api_name => l_proc,
483: p_argument => 'assessment_group_id',
484: p_argument_value => p_assessment_group_id );
485: if nvl(g_assessment_group_id, hr_api.g_number) = p_assessment_group_id then
486: --

Line 485: if nvl(g_assessment_group_id, hr_api.g_number) = p_assessment_group_id then

481: --
482: hr_api.mandatory_arg_error (p_api_name => l_proc,
483: p_argument => 'assessment_group_id',
484: p_argument_value => p_assessment_group_id );
485: if nvl(g_assessment_group_id, hr_api.g_number) = p_assessment_group_id then
486: --
487: -- The legislation code has already been found with a previous
488: -- call to this function. Just return the value in the global
489: -- variable.