APPS.HR_AHC_BUS dependencies on HR_API_HOOK_CALLS

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 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;