PACKAGE BODY: APPS.HRI_OLTP_VIEW_GEOGRAPHY

Source

1 PACKAGE BODY HRI_OLTP_VIEW_GEOGRAPHY AS
2 /* $Header: hriovgeo.pkb 120.1 2006/11/01 11:13:53 smohapat noship $ */
3 
4 /******************************************************************************/
5 /* This function returns the specific region code for a location.             */
6 /*                                                                            */
7 /******************************************************************************/
8 
9 FUNCTION get_region_code (p_Location_id IN NUMBER)
10    RETURN  VARCHAR2 IS
11 
12 BEGIN
13 RETURN hri_bpl_geography.get_region_code(p_location_id);
14 
15 
16 EXCEPTION
17   WHEN OTHERS THEN
18     RETURN TO_CHAR(NULL);
19 END get_region_code;
20 
21 FUNCTION get_country_name (p_country_code IN VARCHAR2)
22    RETURN  VARCHAR2 IS
23 
24    CURSOR ctry_name_cur IS
25      SELECT terr.territory_short_name
26      FROM fnd_territories_tl terr
27      WHERE LANGUAGE = userenv('LANG')
28      and terr.territory_code = p_country_code;
29 
30      l_country_name varchar2(90);
31 
32 BEGIN
33 
34   OPEN ctry_name_cur ;
35 
36   FETCH ctry_name_cur INTO l_country_name ;
37   RETURN l_country_name;
38 
39   CLOSE ctry_name_cur;
40 
41 EXCEPTION
42   WHEN OTHERS THEN
43     RETURN TO_CHAR(NULL);
44 END get_country_name;
45 END;