APPS.HR_AHC_BUS dependencies on HR_LOOKUPS

Line 156: -- HR_LOOKUPS table.

152: -- -----------------------------------------------------------------
153: --
154: -- Description:
155: -- Check that the api_hook_call_type is not null and validate it against the
156: -- HR_LOOKUPS table.
157: --
158: -- Pre-Requisites:
159: -- None
160: --

Line 184: l_lookup_code hr_lookups.lookup_code%TYPE;

180: ) is
181: --
182: -- Local declarations
183: l_proc varchar2(72) := g_package||'chk_api_hook_call_type';
184: l_lookup_code hr_lookups.lookup_code%TYPE;
185: --
186: --
187: begin
188: hr_utility.set_location('Entering: '||l_proc,5);

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 355: -- Check that enabled flag is not null and validate it against HR_LOOKUPS.

351: -- |-----------------------< chk_enabled_flag >-------------------------|
352: -- -----------------------------------------------------------------
353: --
354: -- Description:
355: -- Check that enabled flag is not null and validate it against HR_LOOKUPS.
356: --
357: -- Pre-Requisites:
358: -- None
359: --

Line 385: l_application_id hr_lookups.application_id%TYPE;

381: ) is
382: --
383: -- Local declarations
384: l_proc varchar2(72) := g_package||'chk_enabled_flag';
385: l_application_id hr_lookups.application_id%TYPE;
386: l_api_updating boolean;
387: --
388: --
389: begin

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 861: -- HR_LOOKUPS for subsequent update calls.

857: -- -----------------------------------------------------------------
858: --
859: -- Description:
860: -- Check that status is not null, N on insert and then validate against
861: -- HR_LOOKUPS for subsequent update calls.
862: --
863: -- Pre-Requisites:
864: -- None
865: --

Line 891: l_lookup_code hr_lookups.lookup_code%TYPE;

887: ) is
888: --
889: -- Local declarations
890: l_proc varchar2(72) := g_package||'chk_status';
891: l_lookup_code hr_lookups.lookup_code%TYPE;
892: l_api_updating boolean;
893: --
894: --
895: begin

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 1038: -- validate against HR_LOOKUPS

1034: hr_utility.raise_error;
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

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