DBA Data[Home] [Help]

APPS.HR_NUMBER dependencies on V$NLS_PARAMETERS

Line 6: FROM V$NLS_PARAMETERS

2: /* $Header: hrutlnmw.pkb 120.4 2005/08/05 00:07:47 raranjan noship $ */
3:
4: CURSOR gcsr_group_separator(p_parameter in varchar2) IS
5: SELECT value
6: FROM V$NLS_PARAMETERS
7: WHERE parameter = p_parameter;
8:
9: g_group_separator V$NLS_PARAMETERS.VALUE%TYPE;
10: g_currency V$NLS_PARAMETERS.VALUE%TYPE;

Line 9: g_group_separator V$NLS_PARAMETERS.VALUE%TYPE;

5: SELECT value
6: FROM V$NLS_PARAMETERS
7: WHERE parameter = p_parameter;
8:
9: g_group_separator V$NLS_PARAMETERS.VALUE%TYPE;
10: g_currency V$NLS_PARAMETERS.VALUE%TYPE;
11:
12: -- ------------------------------------------------------------------------
13: -- number_to_canonical

Line 10: g_currency V$NLS_PARAMETERS.VALUE%TYPE;

6: FROM V$NLS_PARAMETERS
7: WHERE parameter = p_parameter;
8:
9: g_group_separator V$NLS_PARAMETERS.VALUE%TYPE;
10: g_currency V$NLS_PARAMETERS.VALUE%TYPE;
11:
12: -- ------------------------------------------------------------------------
13: -- number_to_canonical
14: -- convert number to canonical format number string