eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CHKFMT dependencies on FND_NUMBER

Line 81: nvalue := fnd_number.canonical_to_number( p_value );

77: l_value VARCHAR2(100);
78: BEGIN
79: p_result := TRUE;
80: IF p_value_is_canonical THEN
81: nvalue := fnd_number.canonical_to_number( p_value );
82: ELSE
83: IF g_group_sep_profile = 'Y' THEN
84: l_value := add_remove_group_separator(p_value,TRUE);
85: IF p_value = l_value THEN

Line 121: IF noutput < fnd_number.canonical_to_number( p_minimum ) THEN

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
122: p_rgeflg := RGE_FAIL;
123: END IF;
124: END IF;
125: IF p_maximum IS NOT NULL THEN

Line 126: IF noutput > fnd_number.canonical_to_number( p_maximum ) THEN

122: p_rgeflg := RGE_FAIL;
123: END IF;
124: END IF;
125: IF p_maximum IS NOT NULL THEN
126: IF noutput > fnd_number.canonical_to_number( p_maximum ) THEN
127: p_rgeflg := RGE_FAIL;
128: END IF;
129: END IF;
130:

Line 139: p_output := fnd_number.number_to_canonical( noutput );

135: IF g_group_sep_profile = 'Y' THEN
136: p_value := add_remove_group_separator(p_value);
137: END IF;
138:
139: p_output := fnd_number.number_to_canonical( noutput );
140: EXCEPTION
141: -- this catches illegal numbers.
142: WHEN VALUE_ERROR THEN
143: p_result := FALSE;

Line 178: nvalue := fnd_number.canonical_to_number( p_value );

174: nvalue NUMBER; -- used to hold p_value as a number.
175: BEGIN
176: p_result := TRUE; -- start by assuming success.
177: IF p_value_is_canonical THEN
178: nvalue := fnd_number.canonical_to_number( p_value );
179: ELSE
180: nvalue := TO_NUMBER( p_value ); --uses session NLS settings.
181: END IF;
182: -- can get dec places from the last character of the format:

Line 196: IF nvalue < fnd_number.canonical_to_number( p_minimum ) THEN

192: INTO p_value
193: FROM dual;
194: -- range checking.
195: IF p_minimum IS NOT NULL THEN
196: IF nvalue < fnd_number.canonical_to_number( p_minimum ) THEN
197: p_rgeflg := RGE_FAIL;
198: END IF;
199: END IF;
200: IF p_maximum IS NOT NULL THEN

Line 201: IF nvalue > fnd_number.canonical_to_number( p_maximum ) THEN

197: p_rgeflg := RGE_FAIL;
198: END IF;
199: END IF;
200: IF p_maximum IS NOT NULL THEN
201: IF nvalue > fnd_number.canonical_to_number( p_maximum ) THEN
202: p_rgeflg := RGE_FAIL;
203: END IF;
204: END IF;
205: EXCEPTION

Line 249: nvalue := fnd_number.canonical_to_number( p_value );

245: l_value VARCHAR2(100);
246: BEGIN
247: p_result := TRUE; -- start by assuming success.
248: IF p_value_is_canonical THEN
249: nvalue := fnd_number.canonical_to_number( p_value );
250: ELSE
251: IF g_group_sep_profile = 'Y' THEN
252: l_value := add_remove_group_separator(p_value,TRUE);
253: IF p_value = l_value THEN

Line 283: IF nvalue < fnd_number.canonical_to_number( p_minimum ) THEN

279: end if;
280: END IF;
281: -- range checking.
282: IF p_minimum IS NOT NULL THEN
283: IF nvalue < fnd_number.canonical_to_number( p_minimum ) THEN
284: p_rgeflg := RGE_FAIL;
285: END IF;
286: END IF;
287: IF p_maximum IS NOT NULL THEN

Line 288: IF nvalue > fnd_number.canonical_to_number( p_maximum ) THEN

284: p_rgeflg := RGE_FAIL;
285: END IF;
286: END IF;
287: IF p_maximum IS NOT NULL THEN
288: IF nvalue > fnd_number.canonical_to_number( p_maximum ) THEN
289: p_rgeflg := RGE_FAIL;
290: END IF;
291: END IF;
292:

Line 297: p_output := fnd_number.number_to_canonical(p_value);

293: IF not (nvalue between MIN_VALUE and MAX_VALUE) then
294: p_result := FALSE;
295: END IF;
296:
297: p_output := fnd_number.number_to_canonical(p_value);
298:
299: IF g_group_sep_profile = 'Y' THEN
300: p_value := add_remove_group_separator(p_value);
301: END IF;

Line 542: output := fnd_number.number_to_canonical(

538: null;
539: end if;
540: --
541: -- output the converted value.
542: output := fnd_number.number_to_canonical(
543: round(hours + (minutes/60) + (seconds/3600),INT_PREC) );
544: --
545: -- having done the checks, we need to check
546: -- if we originally had negative input

Line 553: if(fnd_number.canonical_to_number(output) <

549: value := '-' || value;
550: end if;
551: -- minimum and maximum checking.
552: if(minimum is not null) then
553: if(fnd_number.canonical_to_number(output) <
554: fnd_number.canonical_to_number(minimum)) then
555: rgeflg := RGE_FAIL;
556: return;
557: end if;

Line 554: fnd_number.canonical_to_number(minimum)) then

550: end if;
551: -- minimum and maximum checking.
552: if(minimum is not null) then
553: if(fnd_number.canonical_to_number(output) <
554: fnd_number.canonical_to_number(minimum)) then
555: rgeflg := RGE_FAIL;
556: return;
557: end if;
558: end if;

Line 560: if(fnd_number.canonical_to_number(output) >

556: return;
557: end if;
558: end if;
559: if(maximum is not null) then
560: if(fnd_number.canonical_to_number(output) >
561: fnd_number.canonical_to_number(maximum)) then
562: rgeflg := RGE_FAIL;
563: return;
564: end if;

Line 561: fnd_number.canonical_to_number(maximum)) then

557: end if;
558: end if;
559: if(maximum is not null) then
560: if(fnd_number.canonical_to_number(output) >
561: fnd_number.canonical_to_number(maximum)) then
562: rgeflg := RGE_FAIL;
563: return;
564: end if;
565: end if;

Line 1185: --output := fnd_number.number_to_canonical( to_number(value) );

1181: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1182: hr_utility.raise_error;
1183: end if;
1184: --output is in canonical format
1185: --output := fnd_number.number_to_canonical( to_number(value) );
1186: elsif(format = 'H_HH' or format = 'H_HHMM' or
1187: format = 'H_HHMMSS') then
1188: chkhours(value,format,output,minimum,maximum,rgeflg,result);
1189: if(result = FALSE) then

Line 1219: output := fnd_number.number_to_canonical( to_number(value) );

1215: hr_utility.set_message(801,'HR_51153_INVAL_NUM_FORMAT');
1216: hr_utility.raise_error;
1217: end if;
1218: --output is in canonical format
1219: output := fnd_number.number_to_canonical( to_number(value) );
1220: elsif(format = 'DB_ITEM_NAME') then
1221: if(chkdbi(value) = FALSE) then
1222: hr_utility.set_message(801,'HR_51156_INVAL_NUM_FORMAT');
1223: hr_utility.raise_error;

Line 1318: hours := trunc(fnd_number.canonical_to_number( input ));

1314: hours varchar2(100); -- holds the hours string.
1315: mins number; -- holds minutes (and seconds) string.
1316: begin
1317: -- separate hours string.
1318: hours := trunc(fnd_number.canonical_to_number( input ));
1319: mins := abs(round((fnd_number.canonical_to_number( input ) - hours)
1320: * 3600));
1321: --
1322: -- Bugfix 4269787

Line 1319: mins := abs(round((fnd_number.canonical_to_number( input ) - hours)

1315: mins number; -- holds minutes (and seconds) string.
1316: begin
1317: -- separate hours string.
1318: hours := trunc(fnd_number.canonical_to_number( input ));
1319: mins := abs(round((fnd_number.canonical_to_number( input ) - hours)
1320: * 3600));
1321: --
1322: -- Bugfix 4269787
1323: -- If mins has been rounded to 3600 we have 1 hour!

Line 1332: and sign(fnd_number.canonical_to_number(input)) = -1 then

1328: --
1329: -- Bugfix 3650335
1330: -- Ensure the sign of the input is maintained.
1331: if hours = '0' and mins > 0
1332: and sign(fnd_number.canonical_to_number(input)) = -1 then
1333: --
1334: -- Prefix the hours value with a minus sign as this will have been
1335: -- lost in the conversion process.
1336: --