APPS.PER_ES_ADDRESS dependencies on HR_API

Line 68: IF p_postal_code <> hr_api.g_varchar2

64: --
65: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
66: --
67: --
68: IF p_postal_code <> hr_api.g_varchar2
69: OR p_region_2 <> hr_api.g_varchar2 THEN
70: --
71: OPEN csr_get_address_info(p_address_id);
72: FETCH csr_get_address_info INTO l_rec;

Line 69: OR p_region_2 <> hr_api.g_varchar2 THEN

65: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
66: --
67: --
68: IF p_postal_code <> hr_api.g_varchar2
69: OR p_region_2 <> hr_api.g_varchar2 THEN
70: --
71: OPEN csr_get_address_info(p_address_id);
72: FETCH csr_get_address_info INTO l_rec;
73: CLOSE csr_get_address_info;

Line 80: IF p_postal_code = hr_api.g_varchar2 THEN

76: --
77: l_postal_code := p_postal_code;
78: l_region_2 := p_region_2;
79: --
80: IF p_postal_code = hr_api.g_varchar2 THEN
81: l_postal_code := l_rec.postal_code;
82: ELSIF p_region_2 = hr_api.g_varchar2 THEN
83: l_region_2 := l_rec.region_2;
84: END IF;

Line 82: ELSIF p_region_2 = hr_api.g_varchar2 THEN

78: l_region_2 := p_region_2;
79: --
80: IF p_postal_code = hr_api.g_varchar2 THEN
81: l_postal_code := l_rec.postal_code;
82: ELSIF p_region_2 = hr_api.g_varchar2 THEN
83: l_region_2 := l_rec.region_2;
84: END IF;
85: --
86: per_es_address.check_es_address(p_postal_code => l_postal_code

Line 119: IF p_postal_code <> hr_api.g_varchar2

115: --
116: IF p_postal_code IS NOT NULL THEN
117: IF p_style = 'ES' THEN
118: --
119: IF p_postal_code <> hr_api.g_varchar2
120: OR p_region_2 <> hr_api.g_varchar2 THEN
121: OPEN csr_get_address_info(p_address_id);
122: FETCH csr_get_address_info INTO l_rec;
123: CLOSE csr_get_address_info;

Line 120: OR p_region_2 <> hr_api.g_varchar2 THEN

116: IF p_postal_code IS NOT NULL THEN
117: IF p_style = 'ES' THEN
118: --
119: IF p_postal_code <> hr_api.g_varchar2
120: OR p_region_2 <> hr_api.g_varchar2 THEN
121: OPEN csr_get_address_info(p_address_id);
122: FETCH csr_get_address_info INTO l_rec;
123: CLOSE csr_get_address_info;
124: --

Line 128: IF p_postal_code = hr_api.g_varchar2 THEN

124: --
125: l_postal_code := p_postal_code;
126: l_region_2 := p_region_2;
127: --
128: IF p_postal_code = hr_api.g_varchar2 THEN
129: l_postal_code := l_rec.postal_code;
130: ELSIF p_region_2 = hr_api.g_varchar2 THEN
131: l_region_2 := l_rec.region_2;
132: END IF;

Line 130: ELSIF p_region_2 = hr_api.g_varchar2 THEN

126: l_region_2 := p_region_2;
127: --
128: IF p_postal_code = hr_api.g_varchar2 THEN
129: l_postal_code := l_rec.postal_code;
130: ELSIF p_region_2 = hr_api.g_varchar2 THEN
131: l_region_2 := l_rec.region_2;
132: END IF;
133: --
134: per_es_address.check_es_address(p_postal_code => l_postal_code