DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_NUMBER

Line 386: add_parameter(name, fnd_number.number_to_canonical(value));

382: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
383: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'add_parameter NUMBER:->name='||name||'**Value='||value, FALSE);
384: end if;
385:
386: add_parameter(name, fnd_number.number_to_canonical(value));
387: END add_parameter;
388:
389: FUNCTION get_string RETURN VARCHAR2 IS
390: BEGIN

Line 405: RETURN fnd_number.canonical_to_number(m_resultValue);

401: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
402: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'get_number :->m_resultValue='||m_resultValue, FALSE);
403: end if;
404:
405: RETURN fnd_number.canonical_to_number(m_resultValue);
406: END;
407:
408: FUNCTION get_date RETURN VARCHAR2 IS
409: BEGIN

Line 2140: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN

2136:
2137: --Date is stored in the DB as RRRR/MM/DD HH:MI:SS format
2138:
2139: IF(p_DataType = C_NUMERIC) THEN
2140: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN

Line 2142: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN

2138:
2139: IF(p_DataType = C_NUMERIC) THEN
2140: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2145: RETURN 0;
2146: END IF;

Line 2144: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN

2140: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2145: RETURN 0;
2146: END IF;
2147: ELSIF (p_DataType = C_DATE) THEN
2148: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

Line 2824: l_param_value := fnd_number.canonical_to_number(l_param_value);

2820:
2821: IF (l_data_type = C_DATE) THEN
2822: l_param_value := fnd_date.canonical_to_date(l_param_value);
2823: ELSIF (l_data_type = C_NUMERIC) THEN
2824: l_param_value := fnd_number.canonical_to_number(l_param_value);
2825: END IF;
2826:
2827: for i in 1..l_numColumns
2828: loop