DBA Data[Home] [Help]

APPS.PER_SHT_BUS dependencies on HR_GENERAL

Line 209: select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;

205: -- key exists
206: if p_shared_type_id is null
207: or (p_shared_type_id is not null and p_shared_type_id <> l_shared_type_id) then
208: close c1;
209: select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;
210: -- different record is being updated inserted with same key, raise error.
211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);