PACKAGE BODY: APPS.PER_ORG_DATA_PUMP

Source

1 PACKAGE BODY PER_ORG_DATA_PUMP AS
2 /* $Header: perorgdp.pkb 115.1 2002/10/09 09:03:27 fsheikh noship $ */
3 
4 --
5 -- Declare global variables
6 --
7 l_package_name    VARCHAR2(30) DEFAULT 'PER_ORG_DATA_PUMP.';
8 -- -------------------------------------------------------------------------
9 -- --------------------< get_company_valueset_id >--------------------------
10 -- -------------------------------------------------------------------------
11 FUNCTION GET_COMPANY_VALUESET_ID
12   (P_COMPANY_VALUESET_NAME IN varchar2 )
13 RETURN BINARY_INTEGER
14 IS
15 l_company_valueset_id NUMBER DEFAULT null;
16 BEGIN
17        SELECT flex_value_set_id
18        INTO   l_company_valueset_id
19        FROM   fnd_flex_value_sets
20        WHERE  flex_value_set_name = p_company_valueset_name;
21 
22    RETURN(l_company_valueset_id);
23 EXCEPTION
24 WHEN OTHERS THEN
25    hr_data_pump.fail('get_company_valueset_id'
26 		    , sqlerrm
27 		    , p_company_valueset_name);
28    RAISE;
29 END GET_COMPANY_VALUESET_ID;
30 -- -------------------------------------------------------------------------
31 -- --------------------< get_costcenter_valueset_id >--------------------------
32 -- -------------------------------------------------------------------------
33 FUNCTION GET_COSTCENTER_VALUESET_ID
34   (P_COSTCENTER_VALUESET_NAME IN varchar2 )
35 RETURN BINARY_INTEGER
36 IS
37 l_costcenter_valueset_id NUMBER DEFAULT null;
38 BEGIN
39        SELECT flex_value_set_id
40        INTO   l_costcenter_valueset_id
41        FROM   fnd_flex_value_sets
42        WHERE  flex_value_set_name = p_costcenter_valueset_name;
43 
44    RETURN(l_costcenter_valueset_id);
45 EXCEPTION
46 WHEN OTHERS THEN
47    hr_data_pump.fail('get_costcenter_valueset_id'
48 		    , sqlerrm
49 		    , p_costcenter_valueset_name);
50    RAISE;
51 END GET_COSTCENTER_VALUESET_ID;
52 END PER_ORG_DATA_PUMP;