PACKAGE BODY: APPS.PER_SG_DATA_PUMP

Source

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