DBA Data[Home] [Help]

APPS.PER_ADD_BUS dependencies on HR_GENERAL

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

2145: hr_utility.set_location(l_proc, 2);
2146: --
2147: -- Check if GEOCODES is installed for a US legislation
2148: --
2149: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
2150: --
2151: -- Check that the zip code is set
2152: --
2153: if p_postal_code is null then

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

2450: hr_utility.set_location(l_proc, 2);
2451: --
2452: -- Check if GEOCODES is installed for a US legislation
2453: --
2454: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2455: then
2456: --
2457: -- Check that the US postal code is either 5 or 10 character
2458: --

Line 2639: and hr_general.chk_geocodes_installed = 'Y'

2635: --
2636: -- Check for GEOCODES in a US legislation
2637: --
2638: if p_style = 'US'
2639: and hr_general.chk_geocodes_installed = 'Y'
2640: and p_validate_county then
2641: --
2642: -- Check that the county is set
2643: --

Line 2793: and hr_general.chk_geocodes_installed = 'Y'

2789: --
2790: -- Check for GEOCODES in a US legislation
2791: --
2792: if p_style = 'US'
2793: and hr_general.chk_geocodes_installed = 'Y'
2794: then
2795: open csr_valid_us_county;
2796: fetch csr_valid_us_county into l_exists;
2797: if csr_valid_us_county%notfound then

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

2914: hr_utility.set_location(l_proc, 2);
2915: --
2916: -- Check if GEOCODES is installed under a US legislation
2917: --
2918: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2919: then
2920: hr_utility.set_location(l_proc, 5);
2921: --
2922: -- Check if the state is set

Line 3080: if hr_general.chk_geocodes_installed = 'Y'

3076: hr_utility.set_location(l_proc, 2);
3077: --
3078: -- Check if GEOCODES is installed under a US legislation
3079: --
3080: if hr_general.chk_geocodes_installed = 'Y'
3081: then
3082: hr_utility.set_location(l_proc, 5);
3083: open csr_valid_state;
3084: fetch csr_valid_state into l_exists;

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

3202: (NOT l_api_updating))
3203: then
3204: hr_utility.set_location(l_proc, 2);
3205: --
3206: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
3207: --
3208: -- Check that the city is set
3209: --
3210: if p_town_or_city is null then

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

3319: (NOT l_api_updating))
3320: then
3321: hr_utility.set_location(l_proc, 2);
3322: --
3323: if hr_general.chk_geocodes_installed = 'Y' then
3324: open csr_valid_tax_city;
3325: fetch csr_valid_tax_city into l_exists;
3326: if csr_valid_tax_city%notfound then
3327: close csr_valid_tax_city;

Line 3490: l_geocodes_installed := hr_general.chk_geocodes_installed;

3486: hr_utility.set_location(l_proc, 20);
3487: --
3488: -- Check if US payroll installed.
3489: --
3490: l_geocodes_installed := hr_general.chk_geocodes_installed;
3491: --
3492: --
3493: -- If US address style and GEOCODES is installed, validate for right combination of
3494: -- city, state and county.

Line 3796: l_geocodes_installed := hr_general.chk_geocodes_installed;

3792: hr_utility.set_location(l_proc, 20);
3793: --
3794: -- Check if US payroll installed.
3795: --
3796: l_geocodes_installed := hr_general.chk_geocodes_installed;
3797: --
3798: --
3799: -- If US address style and GEOCODES is installed, validate for right combination of
3800: -- city, state and county.