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_AHC_BUS dependencies on HR_AHC_SHD

Line 16: (p_rec in hr_ahc_shd.g_rec_type

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

Line 30: if not hr_ahc_shd.api_updating

26: --
27: -- Only proceed with validation if a row exists for
28: -- the current record in the HR Schema
29: --
30: if not hr_ahc_shd.api_updating
31: (p_api_hook_call_id => p_rec.api_hook_call_id,
32: p_object_version_number => p_rec.object_version_number
33: ) then
34: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 41: nvl(hr_ahc_shd.g_old_rec.api_hook_id

37: end if;
38: hr_utility.set_location(l_proc, 30);
39: --
40: if nvl(p_rec.api_hook_id, hr_api.g_number) <>
41: nvl(hr_ahc_shd.g_old_rec.api_hook_id
42: ,hr_api.g_number
43: ) then
44: l_argument := 'api_hook_id';
45: raise l_error;

Line 49: nvl(hr_ahc_shd.g_old_rec.api_hook_call_type

45: raise l_error;
46: end if;
47: --
48: if nvl(p_rec.api_hook_call_type, hr_api.g_varchar2) <>
49: nvl(hr_ahc_shd.g_old_rec.api_hook_call_type
50: ,hr_api.g_varchar2
51: ) then
52: l_argument := 'api_hook_call_type';
53: raise l_error;

Line 57: nvl(hr_ahc_shd.g_old_rec.legislation_code

53: raise l_error;
54: end if;
55: --
56: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
57: nvl(hr_ahc_shd.g_old_rec.legislation_code
58: ,hr_api.g_varchar2
59: ) then
60: l_argument := 'legislation_code';
61: raise l_error;

Line 65: nvl(hr_ahc_shd.g_old_rec.application_id

61: raise l_error;
62: end if;
63: --
64: if nvl(p_rec.application_id, hr_api.g_number) <>
65: nvl(hr_ahc_shd.g_old_rec.application_id
66: ,hr_api.g_number
67: ) then
68: l_argument := 'application_id';
69: raise l_error;

Line 142: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_FK1');

138: open csr_valid_hook_id;
139: fetch csr_valid_hook_id into l_api_hook_id;
140: if csr_valid_hook_id%notfound then
141: close csr_valid_hook_id;
142: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_FK1');
143: end if;
144: close csr_valid_hook_id;
145:
146: hr_utility.set_location('Leaving: '||l_proc,10);

Line 205: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_CK1');

201: if hr_api.not_exists_in_hr_lookups
202: (p_effective_date => p_effective_date,
203: p_lookup_type => 'API_HOOK_CALL_TYPE',
204: p_lookup_code => p_api_hook_call_type) then
205: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_CK1');
206: end if;
207:
208: hr_utility.set_location('Leaving: '||l_proc,10);
209: end chk_api_hook_call_type;

Line 319: l_api_updating := hr_ahc_shd.api_updating

315: begin
316: hr_utility.set_location('Entering: '||l_proc,5);
317:
318: -- Check if hook is being updated
319: l_api_updating := hr_ahc_shd.api_updating
320: (p_api_hook_call_id => p_api_hook_call_id,
321: p_object_version_number => p_object_version_number);
322:
323: -- Proceed with validation based on outcome of api_updating call.

Line 325: hr_ahc_shd.g_old_rec.sequence <> nvl(p_sequence, hr_api.g_number) ) or

321: p_object_version_number => p_object_version_number);
322:
323: -- Proceed with validation based on outcome of api_updating call.
324: if ((l_api_updating and
325: hr_ahc_shd.g_old_rec.sequence <> nvl(p_sequence, hr_api.g_number) ) or
326: (not l_api_updating)) then
327:
328:
329: if ( p_legislation_code is not null and

Line 401: l_api_updating := hr_ahc_shd.api_updating

397: p_argument => 'p_enabled_flag',
398: p_argument_value => p_enabled_flag);
399:
400: -- Check if hook is being updated
401: l_api_updating := hr_ahc_shd.api_updating
402: (p_api_hook_call_id => p_api_hook_call_id,
403: p_object_version_number => p_object_version_number);
404:
405: -- Proceed with validation based on outcome of api_updating call.

Line 407: hr_ahc_shd.g_old_rec.enabled_flag <> nvl(p_enabled_flag, hr_api.g_varchar2) ) or

403: p_object_version_number => p_object_version_number);
404:
405: -- Proceed with validation based on outcome of api_updating call.
406: if ((l_api_updating and
407: hr_ahc_shd.g_old_rec.enabled_flag <> nvl(p_enabled_flag, hr_api.g_varchar2) ) or
408: (not l_api_updating)) then
409:
410: --------------------------------
411: -- Check enabled is valid --

Line 467: l_api_updating := hr_ahc_shd.api_updating

463: begin
464: hr_utility.set_location('Entering: '||l_proc,5);
465:
466: -- Check if hook is being updated
467: l_api_updating := hr_ahc_shd.api_updating
468: (p_api_hook_call_id => p_api_hook_call_id,
469: p_object_version_number => p_object_version_number);
470:
471: -- Proceed with validation based on outcome of api_updating call.

Line 473: nvl(hr_ahc_shd.g_old_rec.call_package, hr_api.g_varchar2) <>

469: p_object_version_number => p_object_version_number);
470:
471: -- Proceed with validation based on outcome of api_updating call.
472: if ((l_api_updating and
473: nvl(hr_ahc_shd.g_old_rec.call_package, hr_api.g_varchar2) <>
474: nvl(p_call_package, hr_api.g_varchar2) ) or
475: (not l_api_updating)) then
476:
477: if (p_api_hook_call_type = 'PP' and p_call_package is null) OR

Line 530: l_api_updating := hr_ahc_shd.api_updating

526: begin
527: hr_utility.set_location('Entering: '||l_proc,5);
528:
529: -- Check if hook is being updated
530: l_api_updating := hr_ahc_shd.api_updating
531: (p_api_hook_call_id => p_api_hook_call_id,
532: p_object_version_number => p_object_version_number);
533:
534: -- Proceed with validation based on outcome of api_updating call.

Line 536: nvl(hr_ahc_shd.g_old_rec.call_procedure, hr_api.g_varchar2) <>

532: p_object_version_number => p_object_version_number);
533:
534: -- Proceed with validation based on outcome of api_updating call.
535: if ((l_api_updating and
536: nvl(hr_ahc_shd.g_old_rec.call_procedure, hr_api.g_varchar2) <>
537: nvl(p_call_procedure, hr_api.g_varchar2) ) or
538: (not l_api_updating)) then
539:
540: if (p_api_hook_call_type = 'PP' and p_call_procedure is null) OR

Line 620: l_api_updating := hr_ahc_shd.api_updating

616: --
617: begin
618: hr_utility.set_location('Entering: '||l_proc,5);
619: -- Check if hook call is being updated
620: l_api_updating := hr_ahc_shd.api_updating
621: (p_api_hook_call_id => p_api_hook_call_id,
622: p_object_version_number => p_object_version_number);
623:
624: -- Proceed with validation based on outcome of api_updating call.

Line 626: (hr_ahc_shd.g_old_rec.call_package <> p_call_package or

622: p_object_version_number => p_object_version_number);
623:
624: -- Proceed with validation based on outcome of api_updating call.
625: if ( (l_api_updating and
626: (hr_ahc_shd.g_old_rec.call_package <> p_call_package or
627: hr_ahc_shd.g_old_rec.call_procedure <> p_call_procedure)
628: )
629: or
630: (not l_api_updating) ) then

Line 627: hr_ahc_shd.g_old_rec.call_procedure <> p_call_procedure)

623:
624: -- Proceed with validation based on outcome of api_updating call.
625: if ( (l_api_updating and
626: (hr_ahc_shd.g_old_rec.call_package <> p_call_package or
627: hr_ahc_shd.g_old_rec.call_procedure <> p_call_procedure)
628: )
629: or
630: (not l_api_updating) ) then
631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);

Line 631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);

627: hr_ahc_shd.g_old_rec.call_procedure <> p_call_procedure)
628: )
629: or
630: (not l_api_updating) ) then
631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);
632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);
633:
634: if p_api_hook_call_type = 'PP' then
635: ----------------------------------------------------------------------------

Line 632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);

628: )
629: or
630: (not l_api_updating) ) then
631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);
632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);
633:
634: if p_api_hook_call_type = 'PP' then
635: ----------------------------------------------------------------------------
636: -- Check for combination of hook call id, leg code, call pack, call proc --

Line 647: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_UK1');

643: fetch csr_valid_combo into l_api_hook_call_id;
644:
645: if csr_valid_combo%found then
646: close csr_valid_combo;
647: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_UK1');
648: end if;
649:
650: close csr_valid_combo;
651: end if;

Line 778: l_api_updating := hr_ahc_shd.api_updating

774: begin
775: hr_utility.set_location('Entering: '||l_proc,5);
776:
777: -- Check if hook is being updated
778: l_api_updating := hr_ahc_shd.api_updating
779: (p_api_hook_call_id => p_api_hook_call_id,
780: p_object_version_number => p_object_version_number);
781:
782: if (not l_api_updating and p_pre_processor_date is not null) then

Line 833: l_api_updating := hr_ahc_shd.api_updating

829: begin
830: hr_utility.set_location('Entering: '||l_proc,5);
831:
832: -- Check if hook is being updated
833: l_api_updating := hr_ahc_shd.api_updating
834: (p_api_hook_call_id => p_api_hook_call_id,
835: p_object_version_number => p_object_version_number);
836:
837: -- Proceed with validation based on outcome of api_updating call.

Line 907: l_api_updating := hr_ahc_shd.api_updating

903: p_argument => 'p_status',
904: p_argument_value => p_status);
905:
906: -- Check if hook is being updated
907: l_api_updating := hr_ahc_shd.api_updating
908: (p_api_hook_call_id => p_api_hook_call_id,
909: p_object_version_number => p_object_version_number);
910:
911: -- Proceed with validation based on outcome of api_updating call.

Line 913: hr_ahc_shd.g_old_rec.status <> nvl(p_status, hr_api.g_varchar2)) or

909: p_object_version_number => p_object_version_number);
910:
911: -- Proceed with validation based on outcome of api_updating call.
912: if ((l_api_updating and
913: hr_ahc_shd.g_old_rec.status <> nvl(p_status, hr_api.g_varchar2)) or
914: (not l_api_updating)) then
915:
916: --------------------------------
917: -- Check status is valid --

Line 1054: Procedure insert_validate(p_rec in hr_ahc_shd.g_rec_type,

1050: --
1051: -- ----------------------------------------------------------------------------
1052: -- |---------------------------< insert_validate >----------------------------|
1053: -- ----------------------------------------------------------------------------
1054: Procedure insert_validate(p_rec in hr_ahc_shd.g_rec_type,
1055: p_effective_date in date) is
1056: --
1057: l_proc varchar2(72) := g_package||'insert_validate';
1058: --

Line 1181: Procedure update_validate(p_rec in hr_ahc_shd.g_rec_type,

1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |---------------------------< update_validate >----------------------------|
1180: -- ----------------------------------------------------------------------------
1181: Procedure update_validate(p_rec in hr_ahc_shd.g_rec_type,
1182: p_effective_date in date) is
1183: --
1184: l_proc varchar2(72) := g_package||'update_validate';
1185: --

Line 1293: Procedure delete_validate(p_rec in hr_ahc_shd.g_rec_type) is

1289: --
1290: -- ----------------------------------------------------------------------------
1291: -- |---------------------------< delete_validate >----------------------------|
1292: -- ----------------------------------------------------------------------------
1293: Procedure delete_validate(p_rec in hr_ahc_shd.g_rec_type) is
1294: --
1295: l_proc varchar2(72) := g_package||'delete_validate';
1296: --
1297: Begin