eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_GRS_BUS dependencies on PER_GRS_SHD

Line 47: l_api_updating := per_grs_shd.api_updating

43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := per_grs_shd.api_updating
48: (p_cagr_grade_structure_id => p_cagr_grade_structure_id,
49: p_object_version_number => p_object_version_number,
50: p_effective_date => p_effective_date);
51: --

Line 54: <> per_grs_shd.g_old_rec.cagr_grade_structure_id) then

50: p_effective_date => p_effective_date);
51: --
52: if (l_api_updating
53: and nvl(p_cagr_grade_structure_id,hr_api.g_number)
54: <> per_grs_shd.g_old_rec.cagr_grade_structure_id) then
55: --
56: -- raise error as PK has changed
57: --
58: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');

Line 58: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');

54: <> per_grs_shd.g_old_rec.cagr_grade_structure_id) then
55: --
56: -- raise error as PK has changed
57: --
58: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');
59: --
60: elsif not l_api_updating then
61: --
62: -- check if PK is null

Line 68: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');

64: if p_cagr_grade_structure_id is not null then
65: --
66: -- raise error as PK is not null
67: --
68: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');
69: --
70: end if;
71: --
72: end if;

Line 342: (p_rec in per_grs_shd.g_rec_type) is

338: -- Access Status:
339: -- Internal Row Handler Use Only.
340: --
341: procedure chk_df
342: (p_rec in per_grs_shd.g_rec_type) is
343: --
344: l_proc varchar2(72) := g_package||'chk_df';
345: --
346: begin

Line 350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

346: begin
347: hr_utility.set_location('Entering:'||l_proc, 10);
348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or

Line 390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or
393: (p_rec.cagr_grade_structure_id is null) then
394: --

Line 506: l_api_updating := per_grs_shd.api_updating

502: );
503: --
504: hr_utility.set_location(l_proc, 20);
505: --
506: l_api_updating := per_grs_shd.api_updating
507: (p_cagr_grade_structure_id => p_cagr_grade_structure_id
508: ,p_object_version_number => p_object_version_number
509: ,p_effective_date => p_effective_date
510: );

Line 515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>

511: --
512: hr_utility.set_location(l_proc, 30);
513: --
514: if ((l_api_updating and
515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>
516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))
517: or (NOT l_api_updating))
518: then
519: hr_utility.set_location(l_proc, 40);

Line 614: p_rec in per_grs_shd.g_rec_type) is

610: -- ----------------------------------------------------------------------------
611: -- |---------------------------< insert_validate >----------------------------|
612: -- ----------------------------------------------------------------------------
613: Procedure insert_validate(p_effective_date in date,
614: p_rec in per_grs_shd.g_rec_type) is
615: --
616: l_proc varchar2(72) := g_package||'insert_validate';
617: --
618: Begin

Line 657: p_rec in per_grs_shd.g_rec_type) is

653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< update_validate >----------------------------|
655: -- ----------------------------------------------------------------------------
656: Procedure update_validate( p_effective_date in date,
657: p_rec in per_grs_shd.g_rec_type) is
658: --
659: l_proc varchar2(72) := g_package||'update_validate';
660: --
661: Begin

Line 694: p_rec in per_grs_shd.g_rec_type) is

690: -- ----------------------------------------------------------------------------
691: -- |---------------------------< delete_validate >----------------------------|
692: -- ----------------------------------------------------------------------------
693: Procedure delete_validate(p_effective_date in date,
694: p_rec in per_grs_shd.g_rec_type) is
695: --
696: l_proc varchar2(72) := g_package||'delete_validate';
697: --
698: Begin