DBA Data[Home] [Help]

APPS.HR_CHKFMT dependencies on FND_CURRENCIES

Line 49: Uses FND_CURRENCIES to get information about precision.

45: NAME
46: chkmoney - format currency.
47: DESCRIPTION
48: Formats and checks currency input.
49: Uses FND_CURRENCIES to get information about precision.
50: NOTES
51: p_value can be passed in in either NLS or canonical format, as
52: indicated by p_value_is_canonical. p_value is always returned in
53: NLS format, rounded and padded according to the rules in table

Line 54: fnd_currencies.

50: NOTES
51: p_value can be passed in in either NLS or canonical format, as
52: indicated by p_value_is_canonical. p_value is always returned in
53: NLS format, rounded and padded according to the rules in table
54: fnd_currencies.
55: */
56: PROCEDURE chkmoney
57: (
58: p_value IN OUT NOCOPY VARCHAR2, -- the input to be formatted (see notes).

Line 117: FROM fnd_currencies fc

113: ), ' ' --left trim white space.
114: )
115: INTO noutput
116: , p_value
117: FROM fnd_currencies fc
118: WHERE fc.currency_code = p_curcode;
119: -- range checking.
120: IF p_minimum IS NOT NULL THEN
121: IF noutput < fnd_number.canonical_to_number( p_minimum ) THEN