APPS.FND_FLEX_SERVER1 dependencies on FND_NUMBER

Line 4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4232: fnd_dsql.add_text(mincol || ' is null or ' ||
4233: maxcol || ' is null) ');
4234: ELSE
4235: IF (valtype = 'N') THEN
4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

Line 4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('

4234: ELSE
4235: IF (valtype = 'N') THEN
4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

Line 4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4236: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4237:
4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

Line 4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

4238: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4239: || mincol || '),');
4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4245:
4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN

Line 4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

4240: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4241:
4242: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4243: || maxcol || '),');
4244: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4245:
4246: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4247: datefmt := stored_date_format(valtype, LENGTH(valstr));
4248: fnd_dsql.add_bind(To_date(valstr, datefmt));

Line 4348: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));

4344: IS
4345: datefmt VARCHAR2(30);
4346: BEGIN
4347: IF (coltype = 'N') THEN
4348: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4349: ELSIF (coltype = 'D') then
4350: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4351: datefmt := stored_date_format(vs_fmt, vs_len);
4352: fnd_dsql.add_bind(To_date(char_val, datefmt));