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_API

Line 40: if nvl(p_rec.api_hook_id, hr_api.g_number) <>

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

Line 42: ,hr_api.g_number

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

Line 48: if nvl(p_rec.api_hook_call_type, hr_api.g_varchar2) <>

44: l_argument := 'api_hook_id';
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';

Line 50: ,hr_api.g_varchar2

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

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

52: l_argument := 'api_hook_call_type';
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';

Line 58: ,hr_api.g_varchar2

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

Line 64: if nvl(p_rec.application_id, hr_api.g_number) <>

60: l_argument := 'legislation_code';
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';

Line 66: ,hr_api.g_number

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

Line 75: hr_api.argument_changed_error

71: --
72: hr_utility.set_location(l_proc, 40);
73: exception
74: when l_error then
75: hr_api.argument_changed_error
76: (p_api_name => l_proc
77: ,p_argument => l_argument
78: );
79: when others then

Line 120: from hr_api_hooks

116:
117: -- Setup cursor for valid hook id check
118: cursor csr_valid_hook_id is
119: select api_hook_id
120: from hr_api_hooks
121: where api_hook_id = p_api_hook_id;
122:
123: --
124: begin

Line 130: hr_api.mandatory_arg_error

126: --
127: --------------------------------
128: -- Check hook id not null --
129: --------------------------------
130: hr_api.mandatory_arg_error
131: (p_api_name => l_proc,
132: p_argument => 'p_api_hook_id',
133: p_argument_value => p_api_hook_id);
134:

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

189: --
190: --------------------------------
191: -- Check hook call type not null --
192: --------------------------------
193: hr_api.mandatory_arg_error
194: (p_api_name => l_proc,
195: p_argument => 'p_api_hook_call_type',
196: p_argument_value => p_api_hook_call_type);
197:

Line 201: if hr_api.not_exists_in_hr_lookups

197:
198: --------------------------------
199: -- Check hook call type is valid --
200: --------------------------------
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');

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

391:
392: --------------------------------
393: -- Check enabled flag type not null --
394: --------------------------------
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'p_enabled_flag',
398: p_argument_value => p_enabled_flag);
399:

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 413: if hr_api.not_exists_in_hr_lookups

409:
410: --------------------------------
411: -- Check enabled is valid --
412: --------------------------------
413: if hr_api.not_exists_in_hr_lookups
414: (p_effective_date => p_effective_date,
415: p_lookup_type => 'YES_NO',
416: p_lookup_code => p_enabled_flag) then
417: hr_utility.set_message(800,'PER_52136_AHC_ENAB_FLAG_INV');

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

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
478: (p_api_hook_call_type = 'FF' and p_call_package is not null)

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

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
541: (p_api_hook_call_type = 'FF' and p_call_procedure is not null)

Line 605: select api_hook_call_id from hr_api_hook_calls

601: -- Declare a cursor that will check whether the passed
602: -- in hook package and hook procedure form a unique combination
603:
604: cursor csr_valid_combo is
605: select api_hook_call_id from hr_api_hook_calls
606: where api_hook_id = p_api_hook_id
607: and nvl(legislation_code,'X')
608: = nvl(p_legislation_code,'X')
609: and nvl(application_id, -987123654)

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

897:
898: --------------------------------
899: -- Check status not null --
900: --------------------------------
901: hr_api.mandatory_arg_error
902: (p_api_name => l_proc,
903: p_argument => 'p_status',
904: p_argument_value => p_status);
905:

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 919: if hr_api.not_exists_in_hr_lookups

915:
916: --------------------------------
917: -- Check status is valid --
918: --------------------------------
919: if hr_api.not_exists_in_hr_lookups
920: (p_effective_date => p_effective_date,
921: p_lookup_type => 'API_HOOK_CALL_STATUS',
922: p_lookup_code => p_status) then
923: hr_utility.set_message(800,'PER_52140_AHC_STATUS_INV');

Line 1039: if hr_api.not_exists_in_hr_lookups

1035: ELSE
1036: -- combination of application_id and app_install_status is ok
1037: IF p_app_install_status IS NOT NULL THEN
1038: -- validate against HR_LOOKUPS
1039: if hr_api.not_exists_in_hr_lookups
1040: (p_effective_date => p_effective_date,
1041: p_lookup_type => 'APP_INSTALL_STATUS',
1042: p_lookup_code => p_app_install_status) then
1043: hr_utility.set_message(800,'PER_289088_AHC_INST_STATUS_ERR');

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

1062: -- As this data is not within the context of a business group
1063: -- the set_security_group_id procedure has zero passed
1064: -- to it as the default security_group_id.
1065: --
1066: hr_api.set_security_group_id(p_security_group_id => 0);
1067: --
1068: hr_utility.set_location('Entering:'||l_proc, 6);
1069: --
1070: -- Call all supporting business operations

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

1189: -- As this data is not within the context of a business group
1190: -- the set_security_group_id procedure has zero passed
1191: -- to it as the default security_group_id.
1192: --
1193: hr_api.set_security_group_id(p_security_group_id => 0);
1194: --
1195: hr_utility.set_location('Entering:'||l_proc, 6);
1196: --
1197: -- Check that non-updateable columns have not been updated