DBA Data[Home] [Help]

APPS.PER_ADD_BUS dependencies on HR_GENERAL

Line 2130: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then

2126: hr_utility.set_location(l_proc, 2);
2127: --
2128: -- Check if GEOCODES is installed for a US legislation
2129: --
2130: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
2131: --
2132: -- Check that the zip code is set
2133: --
2134: if p_postal_code is null then

Line 2435: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'

2431: hr_utility.set_location(l_proc, 2);
2432: --
2433: -- Check if GEOCODES is installed for a US legislation
2434: --
2435: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2436: then
2437: --
2438: -- Check that the US postal code is either 5 or 10 character
2439: --

Line 2620: and hr_general.chk_geocodes_installed = 'Y'

2616: --
2617: -- Check for GEOCODES in a US legislation
2618: --
2619: if p_style = 'US'
2620: and hr_general.chk_geocodes_installed = 'Y'
2621: and p_validate_county then
2622: --
2623: -- Check that the county is set
2624: --

Line 2774: and hr_general.chk_geocodes_installed = 'Y'

2770: --
2771: -- Check for GEOCODES in a US legislation
2772: --
2773: if p_style = 'US'
2774: and hr_general.chk_geocodes_installed = 'Y'
2775: then
2776: open csr_valid_us_county;
2777: fetch csr_valid_us_county into l_exists;
2778: if csr_valid_us_county%notfound then

Line 2899: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'

2895: hr_utility.set_location(l_proc, 2);
2896: --
2897: -- Check if GEOCODES is installed under a US legislation
2898: --
2899: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2900: then
2901: hr_utility.set_location(l_proc, 5);
2902: --
2903: -- Check if the state is set

Line 3061: if hr_general.chk_geocodes_installed = 'Y'

3057: hr_utility.set_location(l_proc, 2);
3058: --
3059: -- Check if GEOCODES is installed under a US legislation
3060: --
3061: if hr_general.chk_geocodes_installed = 'Y'
3062: then
3063: hr_utility.set_location(l_proc, 5);
3064: open csr_valid_state;
3065: fetch csr_valid_state into l_exists;

Line 3187: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then

3183: (NOT l_api_updating))
3184: then
3185: hr_utility.set_location(l_proc, 2);
3186: --
3187: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
3188: --
3189: -- Check that the city is set
3190: --
3191: if p_town_or_city is null then

Line 3304: if hr_general.chk_geocodes_installed = 'Y' then

3300: (NOT l_api_updating))
3301: then
3302: hr_utility.set_location(l_proc, 2);
3303: --
3304: if hr_general.chk_geocodes_installed = 'Y' then
3305: open csr_valid_tax_city;
3306: fetch csr_valid_tax_city into l_exists;
3307: if csr_valid_tax_city%notfound then
3308: close csr_valid_tax_city;

Line 3471: l_geocodes_installed := hr_general.chk_geocodes_installed;

3467: hr_utility.set_location(l_proc, 20);
3468: --
3469: -- Check if US payroll installed.
3470: --
3471: l_geocodes_installed := hr_general.chk_geocodes_installed;
3472: --
3473: --
3474: -- If US address style and GEOCODES is installed, validate for right combination of
3475: -- city, state and county.

Line 3777: l_geocodes_installed := hr_general.chk_geocodes_installed;

3773: hr_utility.set_location(l_proc, 20);
3774: --
3775: -- Check if US payroll installed.
3776: --
3777: l_geocodes_installed := hr_general.chk_geocodes_installed;
3778: --
3779: --
3780: -- If US address style and GEOCODES is installed, validate for right combination of
3781: -- city, state and county.