APPS.FND_FLEX_SERVER1 dependencies on FND_NUMBER

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

4212: fnd_dsql.add_text(mincol || ' is null or ' ||
4213: maxcol || ' is null) ');
4214: ELSE
4215: IF (valtype = 'N') THEN
4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

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

4214: ELSE
4215: IF (valtype = 'N') THEN
4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('

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

4216: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4217:
4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));

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

4218: fnd_dsql.add_text(' between nvl(fnd_number.canonical_to_number('
4219: || mincol || '),');
4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4225:
4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN

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

4220: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4221:
4222: fnd_dsql.add_text(') and nvl(fnd_number.canonical_to_number('
4223: || maxcol || '),');
4224: fnd_dsql.add_bind(fnd_number.canonical_to_number(valstr));
4225:
4226: ELSIF (valtype in ('D', 'T', 't', 'I', 'X', 'Y', 'Z')) THEN
4227: datefmt := stored_date_format(valtype, LENGTH(valstr));
4228: fnd_dsql.add_bind(To_date(valstr, datefmt));

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

4324: IS
4325: datefmt VARCHAR2(30);
4326: BEGIN
4327: IF (coltype = 'N') THEN
4328: fnd_dsql.add_bind(fnd_number.canonical_to_number(char_val));
4329: ELSIF (coltype = 'D') then
4330: IF (vs_fmt in ('X', 'Y', 'Z', 'D', 'T', 'I', 't')) then
4331: datefmt := stored_date_format(vs_fmt, vs_len);
4332: fnd_dsql.add_bind(To_date(char_val, datefmt));