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.HR_AHK_BUS dependencies on HR_AHK_SHD

Line 16: (p_rec in hr_ahk_shd.g_rec_type

12: -- |-----------------------< chk_non_updateable_args >--------------|
13: -- -----------------------------------------------------------------
14: --
15: Procedure chk_non_updateable_args
16: (p_rec in hr_ahk_shd.g_rec_type
17: ) is
18: --
19: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
20: l_error exception;

Line 29: if not hr_ahk_shd.api_updating

25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --
29: if not hr_ahk_shd.api_updating
30: (p_api_hook_id => p_rec.api_hook_id
31: ) then
32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 39: nvl(hr_ahk_shd.g_old_rec.api_module_id

35: end if;
36: hr_utility.set_location(l_proc, 30);
37: --
38: if nvl(p_rec.api_module_id, hr_api.g_varchar2) <>
39: nvl(hr_ahk_shd.g_old_rec.api_module_id
40: ,hr_api.g_varchar2
41: ) then
42: l_argument := 'api_module_id';
43: raise l_error;

Line 47: nvl(hr_ahk_shd.g_old_rec.legislation_code

43: raise l_error;
44: end if;
45: --
46: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
47: nvl(hr_ahk_shd.g_old_rec.legislation_code
48: ,hr_api.g_varchar2
49: ) then
50: l_argument := 'legislation_code';
51: raise l_error;

Line 125: hr_ahk_shd.constraint_error('HR_API_HOOKS_FK1');

121: open csr_valid_module_type;
122: fetch csr_valid_module_type into l_api_module_type;
123: if csr_valid_module_type%notfound then
124: close csr_valid_module_type;
125: hr_ahk_shd.constraint_error('HR_API_HOOKS_FK1');
126: end if;
127: -- #661588:-
128: if l_api_module_type = 'AI' then
129: close csr_valid_module_type;

Line 211: l_api_updating := hr_ahk_shd.api_updating

207: p_argument_value => p_api_hook_type);
208: --
209: -- Check if hook is being updated
210: --
211: l_api_updating := hr_ahk_shd.api_updating
212: (p_api_hook_id => p_api_hook_id);
213:
214:
215: --

Line 218: hr_ahk_shd.g_old_rec.api_hook_type <> p_api_hook_type) or

214:
215: --
216: -- Proceed with validation based on outcome of api_updating call.
217: if ((l_api_updating and
218: hr_ahk_shd.g_old_rec.api_hook_type <> p_api_hook_type) or
219: (not l_api_updating)) then
220:
221:
222: --------------------------------

Line 230: hr_ahk_shd.constraint_error('HR_API_HOOKS_CK1');

226: if hr_api.not_exists_in_hr_lookups
227: (p_effective_date => p_effective_date,
228: p_lookup_type => 'API_HOOK_TYPE',
229: p_lookup_code => p_api_hook_type) then
230: hr_ahk_shd.constraint_error('HR_API_HOOKS_CK1');
231: end if;
232:
233: --------------------------------------------------------
234: -- Check for unique Module id and hook type combo --

Line 241: hr_ahk_shd.constraint_error('HR_API_HOOKS_UK1');

237: fetch csr_valid_combo into l_api_module_id;
238:
239: if csr_valid_combo%found then
240: close csr_valid_combo;
241: hr_ahk_shd.constraint_error('HR_API_HOOKS_UK1');
242: end if;
243:
244: close csr_valid_combo;
245:

Line 478: l_api_updating := hr_ahk_shd.api_updating

474: begin
475: hr_utility.set_location('Entering: '||l_proc,5);
476:
477: -- Check if hook is being updated
478: l_api_updating := hr_ahk_shd.api_updating
479: (p_api_hook_id => p_api_hook_id);
480:
481:
482: -- Proceed with validation based on outcome of api_updating call.

Line 484: hr_ahk_shd.g_old_rec.hook_procedure <> nvl(p_hook_procedure, hr_api.g_varchar2) and

480:
481:
482: -- Proceed with validation based on outcome of api_updating call.
483: if ((l_api_updating and
484: hr_ahk_shd.g_old_rec.hook_procedure <> nvl(p_hook_procedure, hr_api.g_varchar2) and
485: hr_ahk_shd.g_old_rec.hook_package <> nvl(p_hook_package, hr_api.g_varchar2) ) or
486: (not l_api_updating)) then
487:
488: --------------------------------------------------------

Line 485: hr_ahk_shd.g_old_rec.hook_package <> nvl(p_hook_package, hr_api.g_varchar2) ) or

481:
482: -- Proceed with validation based on outcome of api_updating call.
483: if ((l_api_updating and
484: hr_ahk_shd.g_old_rec.hook_procedure <> nvl(p_hook_procedure, hr_api.g_varchar2) and
485: hr_ahk_shd.g_old_rec.hook_package <> nvl(p_hook_package, hr_api.g_varchar2) ) or
486: (not l_api_updating)) then
487:
488: --------------------------------------------------------
489: -- Check for unique hook package and hook procedure combo --

Line 496: hr_ahk_shd.constraint_error('HR_API_HOOKS_UK2');

492: fetch csr_valid_combo into l_api_module_id;
493:
494: if csr_valid_combo%found then
495: close csr_valid_combo;
496: hr_ahk_shd.constraint_error('HR_API_HOOKS_UK2');
497: end if;
498:
499: close csr_valid_combo;
500:

Line 555: l_api_updating := hr_ahk_shd.api_updating

551: begin
552: hr_utility.set_location('Entering: '||l_proc,5);
553:
554: -- Check if hook is being updated
555: l_api_updating := hr_ahk_shd.api_updating
556: (p_api_hook_id => p_api_hook_id);
557:
558: -- Proceed with validation based on outcome of api_updating call.
559: if ((l_api_updating and

Line 560: nvl(hr_ahk_shd.g_old_rec.legislation_package, hr_api.g_varchar2) <>

556: (p_api_hook_id => p_api_hook_id);
557:
558: -- Proceed with validation based on outcome of api_updating call.
559: if ((l_api_updating and
560: nvl(hr_ahk_shd.g_old_rec.legislation_package, hr_api.g_varchar2) <>
561: nvl(p_legislation_package, hr_api.g_varchar2) ) or
562: (not l_api_updating)) then
563:
564: ----------------------------------------

Line 634: l_api_updating := hr_ahk_shd.api_updating

630: begin
631: hr_utility.set_location('Entering: '||l_proc,5);
632:
633: -- Check if hook is being updated
634: l_api_updating := hr_ahk_shd.api_updating
635: (p_api_hook_id => p_api_hook_id);
636:
637: -- Proceed with validation based on outcome of api_updating call.
638: if ((l_api_updating and

Line 639: nvl(hr_ahk_shd.g_old_rec.legislation_function, hr_api.g_varchar2) <>

635: (p_api_hook_id => p_api_hook_id);
636:
637: -- Proceed with validation based on outcome of api_updating call.
638: if ((l_api_updating and
639: nvl(hr_ahk_shd.g_old_rec.legislation_function, hr_api.g_varchar2) <>
640: nvl(p_legislation_function, hr_api.g_varchar2) ) or
641: (not l_api_updating)) then
642:
643: ----------------------------------------

Line 713: hr_ahk_shd.constraint_error('HR_API_HOOKS_CK2');

709:
710: if (p_legislation_function is not null and p_legislation_package is null) OR
711: (p_legislation_function is null and p_legislation_package is not null)
712: then
713: hr_ahk_shd.constraint_error('HR_API_HOOKS_CK2');
714: end if;
715:
716: hr_utility.set_location('Leaving: '||l_proc,10);
717: end chk_leg_package_function;

Line 784: Procedure insert_validate(p_rec in hr_ahk_shd.g_rec_type,

780: --
781: -- ----------------------------------------------------------------------------
782: -- |---------------------------< insert_validate >----------------------------|
783: -- ----------------------------------------------------------------------------
784: Procedure insert_validate(p_rec in hr_ahk_shd.g_rec_type,
785: p_effective_date in date) is
786: --
787: l_proc varchar2(72) := g_package||'insert_validate';
788: --

Line 866: Procedure update_validate(p_rec in hr_ahk_shd.g_rec_type,

862: --
863: -- ----------------------------------------------------------------------------
864: -- |---------------------------< update_validate >----------------------------|
865: -- ----------------------------------------------------------------------------
866: Procedure update_validate(p_rec in hr_ahk_shd.g_rec_type,
867: p_effective_date in date) is
868: --
869: l_proc varchar2(72) := g_package||'update_validate';
870: --

Line 936: Procedure delete_validate(p_rec in hr_ahk_shd.g_rec_type) is

932: --
933: -- ----------------------------------------------------------------------------
934: -- |---------------------------< delete_validate >----------------------------|
935: -- ----------------------------------------------------------------------------
936: Procedure delete_validate(p_rec in hr_ahk_shd.g_rec_type) is
937: --
938: l_proc varchar2(72) := g_package||'delete_validate';
939: --
940: Begin