PACKAGE BODY: APPS.PER_CN_DATA_PUMP

Source

1 PACKAGE BODY per_cn_data_pump AS
2 /* $Header: hrcndpmf.pkb 115.0 2003/01/02 09:17:29 statkar noship $ */
3 
4 FUNCTION get_employer_id
5 (p_employer_name       IN VARCHAR2,
6  p_business_group_id   IN NUMBER )
7  RETURN VARCHAR2 IS
8 
9  l_employer_id NUMBER;
10 
11 BEGIN
12 
13   SELECT organization_id
14   INTO l_employer_id
15   FROM hr_organization_units
16   WHERE name= p_employer_name
17   AND   business_group_id = p_business_group_id;
18   RETURN TO_CHAR(l_employer_id);
19 
20   EXCEPTION
21     WHEN OTHERS THEN
22        hr_data_pump.fail('get_employer_id',sqlerrm,p_employer_name, p_business_group_id);
23     RAISE;
24 
25 END get_employer_id;
26 
27 END per_cn_data_pump ;