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_API

Line 38: if nvl(p_rec.api_module_id, hr_api.g_varchar2) <>

34: hr_utility.set_message_token('STEP', '20');
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';

Line 40: ,hr_api.g_varchar2

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;
44: end if;

Line 46: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

42: l_argument := 'api_module_id';
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';

Line 48: ,hr_api.g_varchar2

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;
52: end if;

Line 57: hr_api.argument_changed_error

53: --
54: hr_utility.set_location(l_proc, 40);
55: exception
56: when l_error then
57: hr_api.argument_changed_error
58: (p_api_name => l_proc
59: ,p_argument => l_argument
60: );
61: when others then

Line 72: -- the parent HR_API_MODULES table. Prohibit insert into table HR_API_HOOKS

68: -- -----------------------------------------------------------------
69: --
70: -- Description:
71: -- Check that the api_module_id is not null and that it refers to a row on
72: -- the parent HR_API_MODULES table. Prohibit insert into table HR_API_HOOKS
73: -- should the api-module-type equal 'AI' (Alternative Interface).
74: --
75: -- Pre-Requisites:
76: -- None

Line 99: l_api_module_type hr_api_modules.api_module_type%TYPE;

95: ) is
96: --
97: -- Local declarations
98: l_proc varchar2(72) := g_package||' chk_api_module_id';
99: l_api_module_type hr_api_modules.api_module_type%TYPE;
100:
101: -- Setup cursor for valid module type check
102: cursor csr_valid_module_type is
103: select api_module_type

Line 104: from hr_api_modules

100:
101: -- Setup cursor for valid module type check
102: cursor csr_valid_module_type is
103: select api_module_type
104: from hr_api_modules
105: where api_module_id = p_api_module_id;
106: --
107: begin
108: hr_utility.set_location('Entering: '||l_proc,5);

Line 113: hr_api.mandatory_arg_error

109: --
110: --------------------------------
111: -- Check module id not null --
112: --------------------------------
113: hr_api.mandatory_arg_error
114: (p_api_name => l_proc,
115: p_argument => 'p_api_module_id',
116: p_argument_value => p_api_module_id);
117:

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 186: select api_module_id from hr_api_hooks hah

182: --
183: -- Declare a cursor that will check whether the passed
184: -- in hook type and module id form a unique combination
185: cursor csr_valid_combo is
186: select api_module_id from hr_api_hooks hah
187: where hah.api_module_id = p_api_module_id
188: and hah.api_hook_type = p_api_hook_type;
189:
190: -- Declare a cursor to retrieve the module type from

Line 191: -- the HR_API_MODULES table, using the api_module_id as a key.

187: where hah.api_module_id = p_api_module_id
188: and hah.api_hook_type = p_api_hook_type;
189:
190: -- Declare a cursor to retrieve the module type from
191: -- the HR_API_MODULES table, using the api_module_id as a key.
192: cursor csr_get_module_type is
193: select api_module_type from hr_api_modules
194: where api_module_id = p_api_module_id;
195:

Line 193: select api_module_type from hr_api_modules

189:
190: -- Declare a cursor to retrieve the module type from
191: -- the HR_API_MODULES table, using the api_module_id as a key.
192: cursor csr_get_module_type is
193: select api_module_type from hr_api_modules
194: where api_module_id = p_api_module_id;
195:
196: --
197: --

Line 204: hr_api.mandatory_arg_error

200:
201: ----------------------------------
202: -- Check api hook type not null --
203: ----------------------------------
204: hr_api.mandatory_arg_error
205: (p_api_name => l_proc,
206: p_argument => 'p_api_hook_type',
207: p_argument_value => p_api_hook_type);
208: --

Line 226: if hr_api.not_exists_in_hr_lookups

222: --------------------------------
223: -- Check hook type is valid --
224: --------------------------------
225:
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');

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 373: hr_api.mandatory_arg_error

369:
370: --------------------------------
371: -- Check hook package not null --
372: --------------------------------
373: hr_api.mandatory_arg_error
374: (p_api_name => l_proc,
375: p_argument => 'p_hook_package',
376: p_argument_value => p_hook_package);
377:

Line 424: hr_api.mandatory_arg_error

420:
421: --------------------------------
422: -- Check hook procedure not null --
423: --------------------------------
424: hr_api.mandatory_arg_error
425: (p_api_name => l_proc,
426: p_argument => 'p_hook_procedure',
427: p_argument_value => p_hook_procedure);
428:

Line 469: select api_module_id from hr_api_hooks hah

465: --
466: -- Declare a cursor that will check whether the passed
467: -- in hook package and hook procedure form a unique combination
468: cursor csr_valid_combo is
469: select api_module_id from hr_api_hooks hah
470: where hah.hook_package = p_hook_package
471: and hah.hook_procedure = p_hook_procedure;
472:
473: --

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 541: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;

537: ) is
538: --
539: -- Local declarations
540: l_proc varchar2(72) := g_package||'chk_legislation_package';
541: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;
542: l_api_updating boolean;
543: --
544: -- Setup cursor for to retrieve data within business group from parent
545: cursor csr_get_data_within_bus_group is

Line 547: from hr_api_modules

543: --
544: -- Setup cursor for to retrieve data within business group from parent
545: cursor csr_get_data_within_bus_group is
546: select data_within_business_group
547: from hr_api_modules
548: where api_module_id = p_api_module_id;
549: --
550: --
551: begin

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 561: nvl(p_legislation_package, hr_api.g_varchar2) ) or

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: ----------------------------------------
565: -- Check legislation package is valid --

Line 620: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;

616: ) is
617: --
618: -- Local declarations
619: l_proc varchar2(72) := g_package||'chk_legislation_function';
620: l_data_within_business_group hr_api_modules.data_within_business_group%TYPE;
621: l_api_updating boolean;
622: --
623: -- Setup cursor for to retrieve data within business group from parent
624: cursor csr_get_data_within_bus_group is

Line 626: from hr_api_modules

622: --
623: -- Setup cursor for to retrieve data within business group from parent
624: cursor csr_get_data_within_bus_group is
625: select data_within_business_group
626: from hr_api_modules
627: where api_module_id = p_api_module_id;
628: --
629: --
630: begin

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 640: nvl(p_legislation_function, hr_api.g_varchar2) ) or

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: ----------------------------------------
644: -- Check legislation function is valid --

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 753: from hr_api_hook_calls hahc

749: --
750: -- Setup cursor to check for children
751: cursor csr_check_for_child is
752: select api_hook_id
753: from hr_api_hook_calls hahc
754: where hahc.api_hook_id = p_api_hook_id;
755: --
756: --
757: begin

Line 797: hr_api.set_security_group_id(p_security_group_id => 0);

793: -- As this data is not within the context of a business group
794: -- the set_security_group_id procedure has zero passed
795: -- to it as the default security_group_id.
796: --
797: hr_api.set_security_group_id(p_security_group_id => 0);
798: --
799: hr_utility.set_location('Entering:'||l_proc, 7);
800: --
801: -- Call all supporting business operations

Line 878: hr_api.set_security_group_id(p_security_group_id => 0);

874: -- As this data is not within the context of a business group
875: -- the set_security_group_id procedure has zero passed
876: -- to it as the default security_group_id.
877: --
878: hr_api.set_security_group_id(p_security_group_id => 0);
879: --
880: hr_utility.set_location('Entering:'||l_proc, 7);
881: --
882: -- Call all supporting business operations