APPS.HR_LEI_BUS dependencies on HR_LOCATION_EXTRA_INFO

Line 42: p_location_id in hr_location_extra_info.location_id%type

38: -- {End Of Comments}
39: -- ----------------------------------------------------------------------------
40: Procedure chk_location_id
41: (
42: p_location_id in hr_location_extra_info.location_id%type
43: ) is
44: --
45: l_proc varchar2(72) := g_package||'chk_location_id';
46: l_dummy varchar2(1);

Line 173: -- FK HR_LOCATION_EXTRA_INFO_FK1, ensures the existence of row in info type table

169: --
170: -- Description:
171: -- This procedure check number of rows against an info type
172: -- Information_type must exist with active_inactive_flag='Y',
173: -- FK HR_LOCATION_EXTRA_INFO_FK1, ensures the existence of row in info type table
174: -- but it should exist with active_inactive_flag = 'Y'
175: --
176: --
177: -- Pre Conditions:

Line 303: FROM hr_location_extra_info lei

299: l_failure exception;
300: --
301: CURSOR c_count_rows IS
302: SELECT 'x'
303: FROM hr_location_extra_info lei
304: WHERE lei.information_type = p_information_type
305: AND lei.location_id = p_location_id ;
306: --
307: Begin

Line 441: ,p_descflex_name => 'HR_LOCATION_EXTRA_INFO'

437: -- b) During insert.
438: --
439: hr_dflex_utility.ins_or_upd_descflex_attribs
440: (p_appl_short_name => 'PER'
441: ,p_descflex_name => 'HR_LOCATION_EXTRA_INFO'
442: ,p_attribute_category => p_rec.lei_attribute_category
443: ,p_attribute1_name => 'LEI_ATTRIBUTE1'
444: ,p_attribute1_value => p_rec.lei_attribute1
445: ,p_attribute2_name => 'LEI_ATTRIBUTE2'