DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_NUMBER

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

374: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
375: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'add_parameter NUMBER:->name='||name||'**Value='||value, FALSE);
376: end if;
377:
378: add_parameter(name, fnd_number.number_to_canonical(value));
379: END add_parameter;
380:
381: FUNCTION get_string RETURN VARCHAR2 IS
382: BEGIN

Line 397: RETURN fnd_number.canonical_to_number(m_resultValue);

393: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
394: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'get_number :->m_resultValue='||m_resultValue, FALSE);
395: end if;
396:
397: RETURN fnd_number.canonical_to_number(m_resultValue);
398: END;
399:
400: FUNCTION get_date RETURN VARCHAR2 IS
401: BEGIN

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

2128:
2129: --Date is stored in the DB as RRRR/MM/DD HH:MI:SS format
2130:
2131: IF(p_DataType = C_NUMERIC) THEN
2132: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2133: RETURN 1;
2134: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2135: RETURN -1;
2136: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN

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

2130:
2131: IF(p_DataType = C_NUMERIC) THEN
2132: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2133: RETURN 1;
2134: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2135: RETURN -1;
2136: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2137: RETURN 0;
2138: END IF;

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

2132: IF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) > FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2133: RETURN 1;
2134: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) < FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2135: RETURN -1;
2136: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2137: RETURN 0;
2138: END IF;
2139: ELSIF (p_DataType = C_DATE) THEN
2140: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

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

2789:
2790: IF (l_data_type = C_DATE) THEN
2791: l_param_value := fnd_date.canonical_to_date(l_param_value);
2792: ELSIF (l_data_type = C_NUMERIC) THEN
2793: l_param_value := fnd_number.canonical_to_number(l_param_value);
2794: END IF;
2795:
2796: for i in 1..l_numColumns
2797: loop