PACKAGE BODY: APPS.PER_HK_DATA_PUMP

Source

1 package body per_hk_data_pump as
2 /* $Header: hrhkdpmf.pkb 120.0 2005/05/31 00:42:39 appldev noship $
3    Name        Date         Version      Bug               Text
4 -------------------------------------------------------------------------------
5   apunekar    29-MAY-2001     115.0     1620654         Created mapping function
6 
7 */
8 function get_legal_employer_id
9 (p_legal_employer_name in varchar2,
10  p_business_group_id   in number)
11  return varchar2 is
12  l_legal_employer_id number;
13 
14 begin
15   select hou.organization_id
16   into l_legal_employer_id
17   from hr_organization_information hoi, hr_organization_units hou
18   where hoi.organization_id = hou.organization_id
19   and hou.name = p_legal_employer_name
20   and hou.business_group_id = p_business_group_id
21   and hoi.org_information_context = 'HK_LEGAL_EMPLOYER';
22   return to_char(l_legal_employer_id);
23 exception
24   when others then
25     hr_data_pump.fail('get_legal_employer_id', sqlerrm,
26                        p_legal_employer_name, p_business_group_id);
27     raise;
28 
29 end get_legal_employer_id;
30 end per_hk_data_pump ;