APPS.HR_CHKFMT dependencies on FND_PROFILE

Line 4: g_group_sep_profile CONSTANT VARCHAR2(2) := NVL(fnd_profile.value('HR_NUMBER_SEPARATOR'),'N');

1: package body hr_chkfmt as
2: /* $Header: pychkfmt.pkb 120.7 2007/11/06 10:38:55 ayegappa noship $ */
3:
4: g_group_sep_profile CONSTANT VARCHAR2(2) := NVL(fnd_profile.value('HR_NUMBER_SEPARATOR'),'N');
5:
6: FUNCTION add_remove_group_separator ( input IN VARCHAR2
7: , remove_separator IN BOOLEAN DEFAULT FALSE)
8: RETURN VARCHAR2

Line 12: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1),',');

8: RETURN VARCHAR2
9: IS
10: l_output VARCHAR2(100);
11: l_group_separator VARCHAR2(2) := substr(ltrim(to_char(1032,'0G999')),2,1);
12: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1),',');
13: l_dec_separator VARCHAR2(2) := substr(ltrim(to_char(.3,'0D0')),2,1);
14: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1),'.');
15: l_negative_flag BOOLEAN := FALSE ;
16: BEGIN

Line 14: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1),'.');

10: l_output VARCHAR2(100);
11: l_group_separator VARCHAR2(2) := substr(ltrim(to_char(1032,'0G999')),2,1);
12: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1),',');
13: l_dec_separator VARCHAR2(2) := substr(ltrim(to_char(.3,'0D0')),2,1);
14: --NVL(SUBSTR(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1),'.');
15: l_negative_flag BOOLEAN := FALSE ;
16: BEGIN
17:
18: IF remove_separator THEN