DBA Data[Home] [Help]

APPS.HR_AMD_BUS dependencies on HR_API

Line 37: if nvl(p_rec.api_module_type, hr_api.g_varchar2) <>

33: hr_utility.set_message_token('STEP', '20');
34: end if;
35: hr_utility.set_location(l_proc, 30);
36: --
37: if nvl(p_rec.api_module_type, hr_api.g_varchar2) <>
38: nvl(hr_amd_shd.g_old_rec.api_module_type
39: ,hr_api.g_varchar2
40: ) then
41: l_argument := 'api_module_type';

Line 39: ,hr_api.g_varchar2

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

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

42: raise l_error;
43: end if;
44: --
45: --
46: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
47: nvl(hr_amd_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: --
45: --
46: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
47: nvl(hr_amd_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 106: hr_api.mandatory_arg_error

102: --
103: --------------------------------
104: -- Check module type not null --
105: --------------------------------
106: hr_api.mandatory_arg_error
107: (p_api_name => l_proc,
108: p_argument => 'p_api_module_type',
109: p_argument_value => p_api_module_type);
110: --------------------------------

Line 113: if hr_api.not_exists_in_hr_lookups

109: p_argument_value => p_api_module_type);
110: --------------------------------
111: -- Check module type is valid --
112: --------------------------------
113: if hr_api.not_exists_in_hr_lookups
114: (p_effective_date => p_effective_date,
115: p_lookup_type => 'API_MODULE_TYPE',
116: p_lookup_code => p_api_module_type) then
117: hr_amd_shd.constraint_error('HR_API_MODULES_CK1');

Line 117: hr_amd_shd.constraint_error('HR_API_MODULES_CK1');

113: if hr_api.not_exists_in_hr_lookups
114: (p_effective_date => p_effective_date,
115: p_lookup_type => 'API_MODULE_TYPE',
116: p_lookup_code => p_api_module_type) then
117: hr_amd_shd.constraint_error('HR_API_MODULES_CK1');
118: end if;
119:
120: hr_utility.set_location('Leaving: '||l_proc,10);
121: end chk_api_module_type;

Line 168: select api_module_id from hr_api_modules ham

164: --
165: -- Declare a cursor that will check whether the passed
166: -- in module type and module name form a unique combination
167: cursor csr_valid_combo is
168: select api_module_id from hr_api_modules ham
169: where ham.module_name = p_module_name
170: and ham.api_module_type = p_api_module_type;
171:
172: begin

Line 182: hr_amd_shd.g_old_rec.module_name <> nvl(p_module_name,hr_api.g_varchar2)) or

178: --
179: -- Proceed with validation based on outcome of api_updating call.
180:
181: if ((l_api_updating and
182: hr_amd_shd.g_old_rec.module_name <> nvl(p_module_name,hr_api.g_varchar2)) or
183: (not l_api_updating)) then
184: --------------------------------
185: -- Check module name not null --
186: --------------------------------

Line 187: hr_api.mandatory_arg_error

183: (not l_api_updating)) then
184: --------------------------------
185: -- Check module name not null --
186: --------------------------------
187: hr_api.mandatory_arg_error
188: (p_api_name => l_proc,
189: p_argument => 'p_module_name',
190: p_argument_value => p_module_name);
191:

Line 209: hr_amd_shd.constraint_error('HR_API_MODULES_UK1');

205: fetch csr_valid_combo into l_module_id;
206:
207: if csr_valid_combo%found then
208: close csr_valid_combo;
209: hr_amd_shd.constraint_error('HR_API_MODULES_UK1');
210: end if;
211:
212: close csr_valid_combo;
213: end if;

Line 261: from hr_api_hooks hk

257: l_exists varchar2(1);
258: --
259: Cursor csr_legislation_data is
260: select null
261: from hr_api_hooks hk
262: where hk.api_module_id = p_api_module_id
263: and (legislation_package is not null
264: or legislation_function is not null) ;
265: --

Line 272: hr_api.mandatory_arg_error

268:
269: ----------------------------------------
270: -- Check data within bus grp not null --
271: ----------------------------------------
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc,
274: p_argument => 'p_data_within_business_group',
275: p_argument_value => p_data_within_business_group);
276: --------------------------------

Line 286: if hr_api.not_exists_in_hr_lookups

282: (p_api_module_id is null) then
283: --
284: -- do look up validation
285: --
286: if hr_api.not_exists_in_hr_lookups
287: (p_effective_date => p_effective_date,
288: p_lookup_type => 'YES_NO',
289: p_lookup_code => p_data_within_business_group) then
290: -- Error, invalid value.

Line 291: hr_amd_shd.constraint_error('HR_API_MODULES_CK2');

287: (p_effective_date => p_effective_date,
288: p_lookup_type => 'YES_NO',
289: p_lookup_code => p_data_within_business_group) then
290: -- Error, invalid value.
291: hr_amd_shd.constraint_error('HR_API_MODULES_CK2');
292: end if;
293: --
294: if ((p_api_module_id is not null)
295: and hr_amd_shd.g_old_rec.data_within_business_group ='Y'

Line 490: from hr_api_hooks hah

486: --
487: -- Setup cursor to check for children
488: cursor csr_check_for_child is
489: select api_module_id
490: from hr_api_hooks hah
491: where hah.api_module_id = p_api_module_id;
492: --
493: --
494: begin

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

528: -- As this data is not within the context of a business group
529: -- the set_security_group_id procedure has zero passed
530: -- to it as the default security_group_id.
531: --
532: hr_api.set_security_group_id(p_security_group_id => 0);
533: --
534: --
535: hr_utility.set_location('Entering:'||l_proc, 7);
536: --

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

586: -- As this data is not within the context of a business group
587: -- the set_security_group_id procedure has zero passed
588: -- to it as the default security_group_id.
589: --
590: hr_api.set_security_group_id(p_security_group_id => 0);
591: --
592: -- Check that all non-updateable args have in fact not been modified.
593: --
594: hr_utility.set_location('Entering:'||l_proc, 7);