DBA Data[Home] [Help]

APPS.HR_LOC_SHD dependencies on HR_LOC_SHD

Line 1: PACKAGE BODY hr_loc_shd AS

1: PACKAGE BODY hr_loc_shd AS
2: /* $Header: hrlocrhi.pkb 120.7 2006/05/15 13:34:54 srenukun noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package VARCHAR2(33) := ' hr_loc_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package VARCHAR2(33) := ' hr_loc_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------

Line 594: procedure derive_locale(p_rec in out nocopy hr_loc_shd.g_rec_type)

590: --
591: -- ----------------------------------------------------------------------------
592: -- |----------------------------< derive_locale >-----------------------------|
593: -- ----------------------------------------------------------------------------
594: procedure derive_locale(p_rec in out nocopy hr_loc_shd.g_rec_type)
595: is
596: --
597: l_number_table dbms_describe.number_table;
598: l_varchar_table dbms_describe.varchar2_table;

Line 777: END hr_loc_shd;

773: p_rec.derived_locale := ltrim(p_rec.town_or_city) || l_seperator || ltrim(p_rec.country);
774: END IF;
775: end;
776:
777: END hr_loc_shd;