DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_WEB dependencies on V$NLS_PARAMETERS

Line 19: from V$NLS_PARAMETERS

15: RETURN VARCHAR2 IS
16:
17: cursor csr_group_separator is
18: select value
19: from V$NLS_PARAMETERS
20: where parameter = p_parameter;
21:
22: l_parameter V$NLS_PARAMETERS.value%type;
23: l_proc constant varchar2(100) := g_package || ' get_nls_parameter';

Line 22: l_parameter V$NLS_PARAMETERS.value%type;

18: select value
19: from V$NLS_PARAMETERS
20: where parameter = p_parameter;
21:
22: l_parameter V$NLS_PARAMETERS.value%type;
23: l_proc constant varchar2(100) := g_package || ' get_nls_parameter';
24:
25:
26: BEGIN

Line 74: l_group_separator V$NLS_PARAMETERS.value%type;

70: -- ------------------------------------------------------------------------
71: FUNCTION is_valid_number(p_number in varchar2)
72: RETURN BOOLEAN IS
73:
74: l_group_separator V$NLS_PARAMETERS.value%type;
75: l_number number;
76: l_proc constant varchar2(100) := g_package || ' is_valid_number';
77: BEGIN
78: hr_utility.set_location('Entering: '|| l_proc,5);

Line 99: l_group_separator V$NLS_PARAMETERS.value%type;

95: -- ------------------------------------------------------------------------
96: FUNCTION is_valid_currency(p_currency in varchar2)
97: RETURN BOOLEAN IS
98:
99: l_group_separator V$NLS_PARAMETERS.value%type;
100: l_currency_mask V$NLS_PARAMETERS.value%type;
101: l_number number;
102: l_proc constant varchar2(100) := g_package || ' is_valid_currency';
103: BEGIN

Line 100: l_currency_mask V$NLS_PARAMETERS.value%type;

96: FUNCTION is_valid_currency(p_currency in varchar2)
97: RETURN BOOLEAN IS
98:
99: l_group_separator V$NLS_PARAMETERS.value%type;
100: l_currency_mask V$NLS_PARAMETERS.value%type;
101: l_number number;
102: l_proc constant varchar2(100) := g_package || ' is_valid_currency';
103: BEGIN
104: hr_utility.set_location('Entering: '|| l_proc,5);