APPS.HR_IN_UTILITY dependencies on HR_GENERAL

Line 53: l_full_name:= hr_general.decode_lookup('TITLE',p_title) ||' '|| l_full_name ;

49: IF p_first_name IS NOT NULL THEN
50: l_full_name:= p_first_name||' '|| l_full_name ;
51: END IF;
52: IF p_title IS NOT NULL THEN
53: l_full_name:= hr_general.decode_lookup('TITLE',p_title) ||' '|| l_full_name ;
54: END IF;
55: --
56: RETURN substr(l_full_name,1,240);
57: END per_in_full_name;

Line 185: hr_general.decode_lookup('IN_STATES',p_loc_information16)|| ',';

181: p_derived_locale := p_loc_information15 || ',';
182: END IF;
183: IF (ltrim(p_loc_information16) is not null) THEN
184: p_derived_locale := p_derived_locale ||
185: hr_general.decode_lookup('IN_STATES',p_loc_information16)|| ',';
186: END IF;
187: IF (ltrim(p_country) is null) THEN
188: p_derived_locale := rtrim(p_derived_locale, ',');
189: ELSE

Line 191: hr_general.decode_lookup('PER_US_COUNTRY_CODE',p_country);

187: IF (ltrim(p_country) is null) THEN
188: p_derived_locale := rtrim(p_derived_locale, ',');
189: ELSE
190: p_derived_locale := p_derived_locale ||
191: hr_general.decode_lookup('PER_US_COUNTRY_CODE',p_country);
192: END IF;
193: END;
194: end hr_in_utility;