APPS.BEN_XEL_BUS dependencies on HR_LOOKUPS

Line 175: p_meaning hr_lookups.meaning%type;

171: invalid_frmt1 exception;
172: invalid_frmt2 exception;
173: Pragma Exception_Init(invalid_frmt1,-01821);
174: Pragma Exception_Init(invalid_frmt2,-01481);
175: p_meaning hr_lookups.meaning%type;
176: p_part_meaning hr_lookups.meaning%type;
177: --
178:
179: Begin

Line 176: p_part_meaning hr_lookups.meaning%type;

172: invalid_frmt2 exception;
173: Pragma Exception_Init(invalid_frmt1,-01821);
174: Pragma Exception_Init(invalid_frmt2,-01481);
175: p_meaning hr_lookups.meaning%type;
176: p_part_meaning hr_lookups.meaning%type;
177: --
178:
179: Begin
180: --

Line 196: if hr_api.not_exists_in_hr_lookups

192: --
193: -- check if value of lookup falls within lookup type.
194: --
195: if p_business_group_id is not null then
196: if hr_api.not_exists_in_hr_lookups
197: (p_lookup_type => 'BEN_EXT_FRMT_MASK',
198: p_lookup_code => p_frmt_mask_cd,
199: p_effective_date => p_effective_date) then
200: --

Line 227: select meaning into p_meaning from hr_lookups

223: end if;
224: --
225: end if;
226: --
227: select meaning into p_meaning from hr_lookups
228: where lookup_type='BEN_EXT_FRMT_MASK'
229: and lookup_code =p_frmt_mask_cd
230: and enabled_flag='Y';
231: if substr(p_frmt_mask_cd,1,1) = 'N' then

Line 538: if hr_api.not_exists_in_hr_lookups

534: -- check if value of lookup falls within lookup type.
535: --
536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);
537: if p_business_group_id is not null then
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
540: p_lookup_code => p_data_elmt_typ_cd,
541: p_effective_date => p_effective_date) then
542: --

Line 664: if hr_api.not_exists_in_hr_lookups

660: --
661: -- check if value of lookup falls within lookup type.
662: --
663: if p_business_group_id is not null then
664: if hr_api.not_exists_in_hr_lookups
665: (p_lookup_type => 'BEN_EXT_JUST',
666: p_lookup_code => p_just_cd,
667: p_effective_date => p_effective_date) then
668: --