APPS.PER_ASR_BUS dependencies on PER_ASR_SHD

Line 23: Procedure chk_non_updateable_args(p_rec in per_asr_shd.g_rec_type) is

19: --
20: -- In the ASSESSMENT_GROUP entity, there is only one non updatable argument :
21: -- business_group_id
22: --
23: Procedure chk_non_updateable_args(p_rec in per_asr_shd.g_rec_type) is
24: --
25: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
26: l_error exception;
27: l_argument varchar2(30);

Line 35: if not per_asr_shd.api_updating

31: hr_utility.set_location('Entering:'|| l_proc,5);
32: --
33: -- Only proceed with validation if a row exists for
34: -- the current record in the HR Schema.
35: if not per_asr_shd.api_updating
36: --
37: (p_assessment_group_id => p_rec.assessment_group_id
38: ,p_object_version_number => p_rec.object_version_number
39: ) then

Line 127: l_api_updating := per_asr_shd.api_updating

123: -- a) The current g_old_rec is current and
124: -- b) The value for name has changed.
125: -- c) The value is being inserted.
126: --
127: l_api_updating := per_asr_shd.api_updating
128: (p_assessment_group_id => p_assessment_group_id
129: ,p_object_version_number => p_object_version_number
130: );
131: --

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 158: per_asr_shd.constraint_error

154: if csr_chk_name_unique%found then
155: hr_utility.set_location('name not unique:'||l_proc, 5);
156: -- The name already exists in the business group
157: close csr_chk_name_unique;
158: per_asr_shd.constraint_error
159: (p_constraint_name => 'PER_ASSESSMENT_GROUPS_NAME_UK1');
160: end if;
161: close csr_chk_name_unique;
162: --

Line 252: (p_rec in per_asr_shd.g_rec_type) is

248: -- Access Status:
249: -- Internal Row Handler Use Only.
250: --
251: procedure chk_df
252: (p_rec in per_asr_shd.g_rec_type) is
253: --
254: l_proc varchar2(72) := g_package||'chk_df';
255: --
256: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 365: (p_rec in per_asr_shd.g_rec_type

361: -- ----------------------------------------------------------------------------
362: -- |---------------------------< insert_validate >----------------------------|
363: -- ----------------------------------------------------------------------------
364: Procedure insert_validate
365: (p_rec in per_asr_shd.g_rec_type
366: ,p_effective_date in date) is
367: --
368: l_proc varchar2(72) := g_package||'insert_validate';
369: --

Line 400: (p_rec in per_asr_shd.g_rec_type

396: -- ----------------------------------------------------------------------------
397: -- |---------------------------< update_validate >----------------------------|
398: -- ----------------------------------------------------------------------------
399: Procedure update_validate
400: (p_rec in per_asr_shd.g_rec_type
401: ,p_effective_date in date) is
402: --
403: l_proc varchar2(72) := g_package||'update_validate';
404: --

Line 444: Procedure delete_validate(p_rec in per_asr_shd.g_rec_type) is

440: --
441: -- ----------------------------------------------------------------------------
442: -- |---------------------------< delete_validate >----------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure delete_validate(p_rec in per_asr_shd.g_rec_type) is
445: --
446: l_proc varchar2(72) := g_package||'delete_validate';
447: --
448: Begin